Tech Lesson 04-4: Check Book Project: Using a Spreadsheet
(Alternate Lesson: Charting Weather Data)

Standards:
Demonstrates understanding of basic technology and telecommunication tools
Operates Basic technology tools and applications
CSTA Level I Standard 4: (3rd to 5th) Use general purpose productivity tools and peripherals to support personal productivity, remediate skill deficits, and facilitate learning throughout the curriculum.
CSTA Level I Standard 5: (3rd to 5th) Use technology tools for individual and collaborative writing, communication, and publishing activities to create presentations, and publishing activities to create presentations for audiences inside and outside the classroom.
CSTA Level I Standard 9: (3rd to 5th) Determine which technology is useful and select the appropriate tools and technology resources to address a variety of tasks and problems.

Basic Skills:
M4P1:  Students will solve problems (using appropriate technology).
M4P4:  Students will make connections among mathematical ideas and to other disciplines.
M4P5:  Students will represent mathematics in multiple ways.
S4CS4: Students will use ideas of system, model, change, and scale in exploring scientific and technological matters.
S4E4: Students will analyze weather charts/maps and collect weather data to predict weather events and infer patterns and seasonal changes.

Objectives:
Students will use a Spreadsheet program to create a check register that will calculate the total funds remaining in their account.
Students will identify column and row labeling system for spreadsheet cells.
Students will enter money values and transactions into their spreadsheet.
Students will identify the accounting system for negative numbers (red).
-Alternative for Weather Graphing-
Students will use Average and Sum commands to process data
Students will make a line graph with temperature data.

Process:  (Check Register)
1. Students brainstorm what they would buy if they made $4000.00 per month
2. Students make a list in their idea books of the things they would buy
3. Students use Google shopping and Amazon.com to figure amounts for their desired purchases
4. Teacher prepares handouts with a starting balance and following expenses and additions:
Salary:   $4000.00
Taxes:  -$1500.00
Health Insurance: -$250
Electricity: -$100
Phone and Internet Service: -$60
5. Students create Spreadsheet to record check register.

                Total:
Date:        Amount:        Reason:

6. Students key in their desired purchases
7. Students key in the values from the handout
8. Students format cells for currency.
8. Calculate the balance at the end of the month
9.  See who has the most money left!
10. Students save their work in their file area.

Process: (Weather Data)
1.  Students bring weather Data chards from the weather bus to class.
2.  Teacher demonstrates rows and column naming and data conventions with Spreadsheet:  (Naming, A1, A2, B1 etc . . .)
3.  Students create Column Headers:

Day

Temperature (Celsius)

Temperature (Fahrenheit)

Releative Humidity

Wind Speed

Precipitation

Atmospheric Conditions

4. Students Enter in Data for the days they have recorded
5. Use =AVG() command to calculate average temperature
6. Use =SUM() to calculate total precipation
7. Create a line Graph showing temperature in Celsius
8. Save Weather graph in the student file area.

Assessment:
Meets the Standard: Students will have created and saved a Spreadsheet document that records and calculates currency values that track expenses and credits.