We have been working with Google Sheets to make charts and graphs for a while now. SHEETS can be used to complete mathematical formulas, as you know from completing the recent FORMULAS assignment.

For this mini-project, you will use Google Sheets to come up with the proper answers to the questions below, considering the following information regarding Teacher's Lunches at Highland High School.

Here is the data that you need to consider:

Mr. Burkhard spent the following amounts for lunch last week: $1.25, 2.50, 0.00, 3.50 and 2.00.

Mr. Lind spent the following amounts for lunch last week: $5.75, 2.75, 7.00, 2.50 and 3.35.

Mrs. Rich spent the following amounts for lunch last week: $2.00, 2.00, 2.00, 2.00 and 2.00.

Mrs. Lopez spent the following amounts for lunch last week: $12.50, 7.50, 5.25, 0.00 and 2.50.

Mr. O'Brien spent the following amounts for lunch last week: $3.50, 5.25, 1.25, 7.85 and 6.35.

Start a new Google Sheets file, called LUNCHES, in your FRESHMAN_TECH folder. In that file, create a table to represent the data above.

Create ROWS for each teacher and COLUMNS for each day, with extra columns on the right for Total and Average.

Then, use the SUM and AVG functions to total each teacher's lunch cost information for the week, on average and teacher total. See instructions from either the video tutorial or the help webpage linked on the website for today! When your table is complete, you can then answer the questions below.

START BY reviewing the two minute video on the webpage for today or the linked help sheet, which both outline how to insert SUM and AVERAGE formulas into SHEETS.
Name: *
Your answer
Freshman Technology Class: *
Using any resources available to you (including memory of math classes past or present), define the term "AVERAGE" as it pertains to math. *
Please put this into words that a regular person can understand!
Your answer
Which teacher spent the most money on lunches last week? How much did they spend, total? *
Your answer
Which teacher spent the least ON AVERAGE for lunches last week? What was their average spent per day? *
(Find AVERAGE in the same way as you find SUM, as outlined in the video!)
Your answer
What was the total amount spent by all teachers last week for lunch? *
Your answer
What was the AVERAGE TOTAL amount per day spent by all teachers for lunch last week? *
Your answer
Never submit passwords through Google Forms.
This content is neither created nor endorsed by Google. Report Abuse - Terms of Service - Additional Terms