MINI-PROJECT, FRESHMAN TECHNOLOGY: "The Teachers' Lunch Problem."

We have been working with Google Sheets to make charts and graphs for a while now. As you know, 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 HHS.

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, using the SUM and AVG functions (see instructions from either the video tutorial or the help webpage linked on the website for today!), answer the questions below.

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

Option 1

Option 2

Other: