The 12 Days of Middles School
| INTRO | TASK | PROCEDURE |
12 DAYS OF MIDDLE SCHOOL
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
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.
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.Highlight cells D5-D167. Put 'all borders' on the content of our Spreadsheet by highlighting the cells(Cells A4 - E17), and using the BORDERS tool.
on the tool bar click FORMAT>NUMBER>Select currency with 2 decimal placings
Together we will now format cell D5 to calculate a formula. Click into cell D5, now Say the sentence in BOLD FACE while you type or click into the keys in RED: NOTE: (use the * for multiplication)
The total cost = the Quantity X the Cost of each item.
Now hit the Enter key
Repeat the steps to program formulas into column E, up to DAY 6 only
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?
- Highlight the area with calculations on our Spreadsheet (Cells A4 - E17)
- Use the CHART EDITOR button on Drive to select the type of chart/graph you want to create.
- Move it into position on your screen
You may now add a colors to the cells on your Spreadsheet!