Content Area: Mathematics & Technology
Grade Level(s): 8
Targeted Curriculum Standards(s) Use NETS or NHEON number(s) and description:
MATH – 5A, Grade 8, Data Analysis & Probability Strand
NHEON (NH Educator’s Online) 6.1.5.2 – Basic Operations and Concepts
NETS – 3, 4 Technology Productivity tools
Targeted Proficiencies Use Student Outcomes \ Proficiency:
Students will understand the purpose and function of a spreadsheet and enter labels, values, formulas and function, and format data in a spreadsheet and chart.
Resources:
Computer Lab with spreadsheet software installed. One computer per student. InFocus projector and whiteboard for instructor use.
Procedures:
Part I
1. Students open a new spreadsheet such as MS Excel. Save it as “How Time Flies”
2. Students should create a header with their name, date and section on it for this spreadsheet.
3. Begin by reviewing the following vocabulary by utilizing the InFocus projector. Students should take notes. Identify these terms: Spreadsheet, rows & columns, worksheet, cell, active cell, label, value.
4. Students key in activities in column A. Make a list as a class of all the possibilities for their time. Activities such as school, eating, traveling, sports practice, and music lesson, watching TV etc. are good examples. Try to limit it to 20 – 25 activities. Be sure to have one contribution per student.
5. Students key in days of the week beginning in cell B2 with Sunday, B3 with Monday, continue through Saturday.
6. Illustrate how to preview page with grid lines. Center titles. Students should take care to enter in activity times as whole, half or quarter hour activities (1, .5, .25). Each day, they may only use 24 hours.
Part II
1. (At least one week later) One week later. Students enter in their results from their spreadsheets.
Part III
1. Insert a row at B. Enter in the number 24 and Edit, Fill, Right to fill in Sunday through Saturday.
2. Enter a formula at the end of the activity column like this 24-sum (B3…. B20). Edit fill right
3. Students should adjust their times within the cells so everything ends with a zero. Print.

Part IV
Illustrate how to create averages and charts to class.
Instructional Strategies:
• Hands-on
• Lecture
• Review previous knowledge
Assessment Strategies:
• Completed spreadsheet (with handwritten notes)
• Completed spreadsheet with chart
Essential Questions:
Do the students understand the purpose and function of a spreadsheet? Can they enter in data, formulas (for average, sum, subtraction), and insert\print charts?