 | Use this page to maintain syllabus information, learning objectives, required materials, and technical requirements for the course. |
| AGEC 20201 - Introduction To Data Analytics For Agricultural Business |
|---|
|
Associated Term:
Spring 2024
Learning Outcomes: 1. Create and format a basic Excel worksheet. 2. Apply formulas and functions to calculate and analyze data. 3. Create charts and insert sparklines to represent data visually. 4. Manage and analyze large sets of data. 5. Analyze data by creating subtotals, PivotTables, and PivotCharts. 6. Use decision-making tools such as Range Names, Data Tables, and Goal Seek. 7. Manipulate data using date, logical, statistical, and financial functions. 8. Employ statistical functions to analyze data for decision making. 9. Demonstrate data management and error control within workbooks containing links and 3-D formulas. 10. Import, format, and manipulate data from external sources. 11. Manipulate data using text, database, and lookup functions. 12. Demonstrate how to design templates, insert comments, create macros, and use VBA. 13. Read an ERD Diagram. 14. Learn elements of Structured Query Language including the ability to create tables, retrieve, update, and delete data. 15. Understand usage of primary and foreign keys. 16. Create a relational database. 17. Understand different data types. 18. Create and format visualizations. 19. Create visualizations for nominal, ordinal, interval, and ratio scale data. 20. Create map visualizations. Required Materials: Technical Requirements: |
| Return to Previous | New Search |
 |