The Math 112 spreadsheet assignment sequence guides students along a progressive learning path from foundational data mechanics to advanced, multi-tab business modeling.

 

Assignment 1 (Sales Summary Spreadsheet) establishes core mechanics, including raw data entry, basic summation (=SUM), cell formatting, autofill efficiency, and single-series column charts.

 

Assignment 2 (Gradebook & Class Statistics) expands this foundation into statistical summary functions (=AVERAGE, =MAX, =MIN) and introduces absolute cell referencing ($) for proportion and percentage calculations.

 

Assignment 3 (Survey Results & Conditional Analysis) shifts focus to qualitative customer feedback, teaching conditional counting (=COUNTIF, =COUNTA), ratio formulas, frequency distribution pie charts, and visual table design. Finally,

 

Assignment 4 (Sales Dashboard) serves as the capstone experience, requiring students to architect a multi-tab spreadsheet (Raw Data vs. Summary), write cross-sheet formulas ('Raw Data'!), evaluate regional conditional metrics (=SUMIF, =MAXIFS, =MINIFS), and build dynamic executive KPI indicators using advanced lookup logic (=INDEX(MATCH)).

Objective: Learn fundamental spreadsheet modeling by entering structured tabular sales data, calculating row totals using =SUM() to track daily volume, and calculating column totals using =SUM() to measure individual salesperson performance and aggregate revenue.

​

Assignment 1 Data

​

Assignment 1: Sales Summary Spreadsheet

Objective: Build a functional gradebook in Google Sheets.

 

You will enter student scores, calculate point totals using =SUM(), compute percentages using division and absolute cell referencing ($), analyze overall class performance using =AVERAGE(), =MAX(), and =MIN(), and generate a column chart comparing student outcomes.

​

Assignment 2 Data

​

Assignment 2: Sales Summary Spreadsheet

​

​

Objective: Import and process customer survey responses in Google Sheets / Excel. You will set up raw survey data, compute overall summary metrics using =COUNTA(), =AVERAGE(), and conditional =COUNTIF(), construct a score distribution frequency table using absolute cell references ($), format the table with Alternating Colors, and build a Pie Chart with percentage data labels.

​

Assignment 3 Data

​

Assignment 3: Survey and Conditional Data Spreadsheet

​

Objective: Build a multi-tab sales dashboard in Google Sheets or Microsoft Excel. You will set up raw transactional sales data on a 'Raw Data' tab, calculate line-item totals using arithmetic formulas, build a professional 'Summary' dashboard tab using =SUMIF(), =MAXIFS(), and =MINIFS(), construct a dynamic top-performer highlight card using =INDEX(MATCH()), configure data filters, and generate column and line charts to visualize performance trends.

​​

Assignment 4 Data

​

Assignment 4: Multi-Tab Sale Dashboard & Advanced Formulas

​