INSTRUCTIONS: Select one of the options below for your spreadsheet lab project.

• Create a spreadsheet that elementary students can use for a visual representation of math concepts. Some interesting examples are in the article The Spreadsheet -- Absolutely Elementary. This type of spreadsheet would be created by the teacher and used by the students (students would enter the amounts . . . they would not create the graphs or formulas).

• Create a spreadsheet for middle or high school students. This can include any type of math concept, from figuring car payments to algebraic formulas to individual gradebooks. Students at this age level should be able to create the actual spreadsheet with instructions from the teacher.

• Do you have another topic? Just let me know . . . I've been hearing so many neat ideas from everyone that I don't want to hinder your creative talents!

 

The following requirements must be met for each option:

• Use at least two formulas or functions (or a combination of the two).
• Include a heading for the spreadsheet that is centered across the width of the spreadsheet and formatted in a different font size, style, and color.
• Columns should be widened as necessary.
• Numbers should be formatted appropriately ($, %, decimal places, etc…)
• Good use of lines and/or borders (ex: lines above totals and under column headings)
• Create a graph from the data (use an appropriate style of graph, title, legends, and other descriptive information)
• In the lower left edge of your spreadsheet, write a brief description and purpose of the spreadsheet. Explain what math skills or concepts the students will learn. Put a dark border around the description.
• Print the spreadsheet twice; once showing actual data and once showing the cell formulas (Ctrl ` will toggle back and forth to show the formulas). Be sure to enter a page header with your name and EDT 280 (go to File à Page Setup to do this).