VMW 118 Applied Math & Spreadsheets for Vineyard Management

Lecture Hours: 4
Credits: 4

Equips students with essential mathematical and spreadsheet skills for vineyard management, including calculations, record-keeping, and budgeting. Emphasizes practical applications, students will learn to apply mathematical concepts to agricultural scenarios. Develops proficiency in performing common vineyard and agricultural calculations. Gain experience in building and editing worksheets, formatting and printing reports, utilizing formulas and functions, and creating charts using spreadsheet software.

Differential Fee Yes
Student Learning Outcomes:

Create, edit, and print basic worksheets in spreadsheet software.
Use basic formulas and functions in spreadsheet software.
Format, modify, and enhance basic worksheets and charts in spreadsheet software.
Use lists to filter and extract data in spreadsheet software.
Demonstrate basic mathematical operations-whole numbers, fractions, decimals, ratios and proportions, and percentages.
Solve measurement calculations-including conversions, perimeter, area, volume, and land measurements.
Compute basic field operation calculations.

Content Outline

Creating, Navigating, and Printing Spreadsheets
Editing, Copying, and Moving Cell Entries
Using Formulas and Functions
Formatting and Modifying Worksheets
Creating and Customizing Charts
Analyzing List Data
- Using Auto Filters and Custom Filters
- Sorting and Extracting Data
Creating Subtotals and Using Grouping
Performing Basic Mathematical Operations
- Whole numbers, fractions, decimals, ratios and proportions, percentages
Solving Measurement Calculations
- Conversions, perimeter, area, volume, land measurements
Computing Basic Field Operation Calculations
- Labor hours, linear feet, plants per acre, rates per acre, yield per acre, speed, dilutions