This set of video-based lessons introduces students to using Excel for Agribusiness. In a series of videos, quizzes and case reports, students learn how to use Excel in a variety of ways to meet the needs of the business of agriculture.
Video content is bilingual in Spanish and English.
Excel for Agribusiness: Introduction
Author: Luis Enrique Ramos-Coronado
Subject: Computer Science, Agriculture, Math
Grade Level: 6th to 12th grades
Summary: This Excel video lesson is an introduction to Excel concepts and functions with a focus on agribusiness. The lesson includes defining and using workbooks, worksheet, cell, cell reference, range and formats. The lesson includes a crop production case study.
Excel for Agribusiness: Charts
Author: Luis Enrique Ramos-Coronado
Subject: Computer Science, Agriculture, Math
Grade Level: 6th to 12th grades
Summary: This Excel video lesson is focused on creating charts in Excel. Charts are often used in the agribusiness sector because they provide a visual representation of large amounts of data. In the lesson, students create charts from data related to yield, farm labor, and production on 300-acre farm.
Excel for Agribusiness: Inputs and Outputs in Crop Production
Author: Luis Enrique Ramos-Coronado
Subject: Computer Science, Agriculture, Math
Grade Level: 6th to 12th grades
Summary: This Excel video lesson focuses on inputs and outputs in crop production. In this lesson students complete case reports calculating guayule pre-harvest costs and bell pepper production.
Excel for Agribusiness: Variable and Fixed Costs in Farming
Author: Luis Enrique Ramos-Coronado
Subject: Computer Science, Agriculture, Agribusiness, Math
Grade Level: 6th to 12th grades
Summary: The lesson video focuses on variable and fixed costs in farming, along with their relationship in total costs by using Excel software. In the lesson students complete case reports calculating variable, fixed costs, and total costs for a 50- and 100-acre farmland.
Excel for Agribusiness: Opportunity Cost in Farming
Author: Luis Enrique Ramos-Coronado
Subject: Computer Science, Agriculture, Agribusiness, Math
Grade Level: 6th to 12th grades
Summary: This Excel video lesson focuses on opportunity cost in farming. In the lesson students will learn how to calculate opportunity cost. Students will also complete a case report by analyzing the option to either lease or farm guar on an 80-acre farm.
Excel for Agribusiness: Scarcity in Farming
Author: Luis Enrique Ramos-Coronado
Subject: Computer Science, Agriculture, Agribusiness, Math
Grade Level: 6th to 12th grades
Summary: This Excel video lesson focuses on scarcity in farming. In the lesson students will complete a case report by analyzing the option to either grow onions or jalapenos in a 100-acre farm, based on given water limitations. Students will calculate which crop is more profitable based on the available water in the farm.
Excel for Agribusiness: Depreciation
Video and lesson under development
Excel for Agribusiness: Supply & Demand
Video and lesson under development
Excel for Agribusiness: Inflation
Video and lesson under development