MINI-PROJECT, FRESHMAN TECHNOLOGY: "The Teachers' Lunch Problem."
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.
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 day, week, on average and teacher total. See instructions from either the video tutorial or the help web page linked on the website for today! I have also included an image of a MODEL SHEET for this problem below.
When your table is complete, you can then answer the questions below.
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. Sandstrom spent the following amounts for lunch last week: $5.75, 2.75, 7.00, 2.50 and 3.35.
Ms. Roush spent the following amounts for lunch last week: $2.00, 2.00, 2.00, 2.00 and 2.00.
Mr. Kaminski 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.