A fictional smoothie store is used as the basis for teaching students how to create pie charts to display information visually. Students use some math functionality in Google Sheets to calculate total units sold, sales, and total sales with a tax applied.

Students populate a spreadsheet with fictional data from a preseason bowling tournament and use the AVERAGE function to calculate the bowlers’ average score for 5 strings. Students are also introduced to the IF function which assigns each bowler to Division 1 or Division 2 for the upcoming season based on their tournament scores.

Students discover how to create a balance sheet similar to what you would see in a bank statement. Fictional debit and credit transactions are typed in and students create a custom math function to calculate a running bank balance.