The 12 Days of Middles School 
          |  INTRO |  TASK |   PROCEDURE |  

---

12 DAYS OF MIDDLE SCHOOL

INTRO:
Take a look at these new words to a familiar holiday song:

 

On the first day of Middle School my teachers gave to me, a locker for keeping all my stuff. On the

second day of Middle School my teacher gave to me, 2 new friends and a locker for keeping all my stuff.

On the third day of Middle School my teachers gave to me, 3 world maps, 2 new friends and a locker for

keeping all my stuff. … and so on. This pattern continues for 12 days.

 

Here are the rest of the gifts:

• 4th day: 4 books to read

• 5th day: 5 new textbooks

• 6th day: 6 hallway passes

• 7th day: 7 CTBS Tests

• 8th day: 8 calculators

• 9th day: 9 sheets of paper

• 10th day: 10 spelling words

• 11th day: 11 hours of homework

• 12thday: 12 sharpened pencils

 

---

TASK:

Your job is to find out how much money Middle School can cost according to this song. Using Google Spreadsheets we will create a spreadsheet on the computer so that it will do the entire Math.

You need to show each of the 12 days and all of the items bought on each day. We will set up formulas for the computer to figure the cost of all of the 12 days.

 

---

PROCEDURE:

 

12 DAYS OF MIDDLE SCHOOL
Follow these directions for setting up your spreadsheet to calculate how expensive Middle school can be.

Step 1: set up your spreadsheet:

1. Log into Google Drive

2. Create a spreadsheet in your VA&T folder, on Google Drive

3. In cell A1, type your name.

4. In cell A2, type 12 Days of Middle School.

 

5. Skip cell A5 and type Day 1

6. Go to cell B4, and set up the rest of the row as this EXAMPLE

7, Highlight the cell with Day 1- (A5),
8. Drag downward to cell A16; Click Ctrl-D or Right Click - Fill Down)
9. Change the entries to list Day 2, Day 3, etc.. until Day 12
10. Use this list to enter the information into the cells on your spreadsheet

the Quantity refers to how many of each item
the items description = what it is (ei. a partriage in a pear tree)
Cost = the cost of just ONE of the items

1st day: 1 locker for keeping all my stuff @ $28.95 each
2nd day: 2 new friends @ priceless ($0)
3rd day: 3 world maps @ $8.50 each
4th day: 4 books to read @ $6.95 each
5th day: 5 new textbooks @ $36.95 each
6th day: 6 hallway passes @ $.75 each
7th day: 7 CTBS Tests @ $50.00 each
8th day: 8 calculators @ $6.25 each
9th day: 9 sheets of paper @ $.02 each
10th day: 10 spelling words @ $2.00 each
11th day: 11 hours of homework @ $6.50 each
12thday: 12 sharpened pencils @ $0.25 each

Leave the  Total column blank
 

Step 2: Format your cells 
1. Highlight your entire spreadsheet and click the LEFT ALIGN tool

2.Highlight Column A, make it BOLD

3. Highlight Rows 1-4 Make them bold

4. In cell A12, Type 'Total Cost for Middle School'


6. Together we will now format the price column cells for currency.  7. Put 'all borders' on the content of our Spreadsheet by highlighting the cells(Cells A4 - E17), and using the BORDERS tool. 

 

Step 3: Enter in your formulas
3. Fill down the formula for Day 7-12 (highlight>Ctrl-D )

4. Lets review what we just did, and why it worked. 

5. Use the SUM function tool to calcultae a total cost for middle school. It looks like this: 

Step 5: Create a chart/graph to display with our information What will work better to display our content? a graph or a chart? Why?

1. Highlight the area with calculations on our Spreadsheet (Cells A4 - E17)
2. Use the CHART EDITOR button on Drive to select the type of chart/graph you want to create. 
3. Move it into position on your screen

You may now add a colors to the cells on your Spreadsheet! 

 

 

---