Use Spreadsheets to Teach Mathematics and Meet Standards
NECC Chicago June 2001
Integrate Spreadsheets and Mathematics
Spreadsheet Assignments and Math Standards
Sample assignments and instructions for two assignments
Web links for spreadsheet assignments
Presented by Pamela Lewis
Computer Coordinator at St. Luke School, Brookfield WI
Author of Spreadsheet Magic,
published by the International Society for Technology in Education (http://www.iste.org)
email: pamlewis@execpc.com
Integrate Spreadsheets and Mathematics
Use the power of spreadsheets to teach Mathematics. Spreadsheets are a powerful learning tool for primary, elementary and middle school students.
Spreadsheet assignments offer concrete ways to explore abstract concepts in mathematics and other subjects. Mathematical ideas are conveyed in several different waysusing pictures, colored squares, and number lines. Counting on a number line or a number chart, or using pictures to count in a pictograph helps make the process of counting with numbers more meaningful.
A spreadsheet is a helpful tool for visual learners. Students use color and pattern to shade areas of the grid to visualize addition and subtraction. The use of borders and colors helps to organize and highlight data in unique ways. The formatting of font, size, color and pattern fill of cells and borders helps focus student attention on key elements of an assignment. A spreadsheet helps convey the meaning of Decimal numbers as students arrange them in ascending order on a number line.
Using spreadsheets promotes higher order thinking skills. Several assignments use formulas, which are then generalized, so that students can see how the outcome is changed when one of the variables in the formula is altered. The spreadsheet tool promotes the development of problem solving skills and supports "What if..." type questions. Some templates have formulas inserted so that students focus on problem solving, while the computer makes the calculations for them. Students use readymade formulas or they make up their own formulas to manipulate numbers. They explore how and why formulas are used, and how changing a variable affects the outcome. Students test how they can generalize formulas, using the Fill down and Fill Right functions. Students feel the power of spreadsheets as they fill numbers into the cells in a spreadsheet with the click of a mouse. They use formulas to generalize a rule, to make conversions, to calculate budget totals and to calculate ratios.
Students make charts and graphs from spreadsheet records, learning to organize their ideas and present information to an audience. Charts add meaning to information, helping students to analyze and interpret data, as they identify the maximum and minimum, mean, median and mode of a data set.. The computer can generate bar graphs, line graphs and pie charts. Pie charts reinforce the idea of percentages as these are represented visually, and help students compare ratios. Students make their own Bar Graphs by filling cells with color, and Clip Art is used to make Pictographs.
Students love to play on computer and are motivated to complete tasks in a Risk Free Environment, where errors can be easily corrected or edited. Color and pattern are strong motivators and students love to change font and size, add borders, and add Clip Art to their work. Students take pride in the pleasing presentation of their work: lines are straight, writing is clear, pictures are perfect for all students, not only the very best.
Using templates where print range, margins, row and column height, and borders have been formatted can improve presentation and speed up the completion of the task. Children as young as kindergartners can use the spreadsheet tool very successfully, as Templates allow them to learn to use the Spreadsheet tool without knowledge of all the Spreadsheet skills.
Back to "Use Spreadsheets to Teach Mathematics and Meet Standards"
This book offers classroomtested lessons for using spreadsheets to teach subjects across the curriculum. It includes instructions for over 50 assignments (Kindergarten through Eighth grade) that address National Standards in Technology and Mathematics, and other subjects including Language Arts, Science, Social Studies and Foreign Language. See a list of many of the assignments below. Detailed instructions are given for each assignment. A summarized form of these instructions is often included on the Template for each lesson, which is on the accompanying CDROM. The book includes Extension Activities and samples of completed assignments.
As students complete the assignments in this book, they gradually master the following computer skills:
List of Spreadsheet Assignments demonstrated and Math Standards met by these assignments:
Use AppleWorks, Excel, or Microsoft Works for these assignments
Spreadsheet Assignment 
National Mathematics Standards addressed 
Grade Level 

3 
K5 

1 
K5 

1,2 
1 

1,2 
1 

1,2 
1 

1,4,5,10 
1 

1,3,5,10 
1 

1,3,5,10 
1 

1,2,3 
2 

1,3,6 
2 

1,3,6 
2 

1,6,9 
2 

1,2 
2 

1,4 
2 

1,6 
2 

3 
3 

3 
3 

1,2 
3 

3,4 
3 

1,2,3 
3 

1,6,9 
3 

3,5,9,10 
3 

1,5,9,10 
4 

1,2 
4 

5,6,9,10 
4 

1,4,5 
4 

1,2,4 
4 

1,3 
4 

1,3 
4 

1,3 
4 

1,3 
5 

1,3 
5 

1,2 
5 

1,2 
5 

1,3 
5 

3,10 
5 

5,6,9,10 
6 

1,2,6 
7 

4,10 
6 

2 
7 

6 
8 

2 
8 

1,2,6 
8 
Back to "Use Spreadsheets to Teach Mathematics and Meet Standards"
Samples of some completed assignments:
AppleWorks Instructions for two assignments (without using templates):
Spreadsheet skills learned in this assignment:
Open a new ClarisWorks document.
Click on the File menu and click on Save As.
Save the document as Count to 100.
Type your name in cell A2.
Type Count to 100 in cell A3.
Highlight from cells A5 to J14. To do this, click in cell A5, hold down the mouse, and drag to J14.
Click on the Format menu. Click on Column Width and type in 40.
Click on the Format menu. Click on Borders and check all boxes.
Highlight from cells A1 to J14. Click on the Options menu and click on Set Print Range and click on OK.
Click on the Window menu and click on Page View to see what will print. (There is no print preview in AppleWorks).
To move around the spreadsheet, use your tab key, arrow keys, Home and End keys, Control Home and Control End.
Click on the Window menu. Click on Show Tools for the tools to appear on the left side of the screen as below.
To insert text:
Enter the numbers 1 through 100 as in the sample below. When you click on a cell, type in the appropriate number. You will notice it goes into the insertion bar as you type. It only goes into the cell when you press Enter/Return or Tab.
You can now color the multiples of 2 in red.
To fill a cell or cells with color:
Select the cell you want to change by clicking on it, or select the row or column of cells by highlighting it.
Click on the fill color control and select the color you want.
Next, click on each cell containing a multiple of 3 and change the fill pattern in that cell.
To change fill pattern in a cell or cells:
Select the cell you want to change by clicking on it, or select the row or column of cells by highlighting it.
Click on the fill pattern control and select the pattern you want.
To underline the multiples of 5, click on a cell where you want to underline the data, and click on the U button in the button bar.
You can format font by using other buttons in the button bar, like B for bold, change font and size.
2. Instructions for Multiplication Table
Spreadsheet skills learned in this assignment:
Open a new Apple Works Document. Save the file with the name Multiplication Table.
Highlight cells A1 through K11.
Click on the Format menu. Click on Column Width and type in 32.
Click on the Format menu, click on Borders and check all boxes.
To enter 1 to 10 across row 1 and down column A:
Enter * (the key for multiply on computer) in cell A1, 1 in cell B1, 2 in cell C1 and continue counting to 10 across row 1. You will finish in column K.
Enter the numbers 1 through 10 in cells A2 through A11.
To enter your multiplication tables:
To enter your 1x table, click on cell B2, then enter this formula into the cell:
=A2*1
Highlight cells B2 to B11 and click on the Edit menu and click on Fill Down.
To enter your 2x table, click on C2 enter this formula: =A2*2
Type in the correct formula for all of row 2. .(=A2*3, =A2*4, =A2*5 etcetera…)
Highlight B2 through K11, click on the Edit menu and click on Fill, and on Down to fill each column.
To view formulas or data (numbers):
Click on the Options menu and click on Formulas: This will place a check mark next to the word and will show formulas.
Click on the word Formulas again to remove the check mark, this will show data.
Your spreadsheet should look as follows:
Save.
Print the file with numbers showing and with formulas showing.
Back to "Use Spreadsheets to Teach Mathematics and Meet Standards"
Web links for spreadsheet assignments:
Description 
Web Address 
A tour of Fractions from Ask Dr. Math 

A Weekend in Paris – links for a weekend trip. 
http://www.kn.pacbell.com/wired/fil/pages/listleweekeba.html 
Apple's Spreadsheet tips 
http://www.apple.com/education/k12/products/appleworks/tips/index.html#spreadsheet 
AppleWorks Users Group 

Calculates the distance between cities as the crow flies 

Database of information about the planets. 

Fraction assignments – Who wants Pizza 

Free Clip Art from Microsoft for licensed software users 

In and out of the classroom with Microsoft Excel 
http://www.microsoft.com/education/tutorial/classroom/excel97/default.asp 
M&M's industrial Candy home page 

Macintosh Tips and Tutorials – Spreadsheet tutorials 

Magic squares – choose size and level of difficulty 

Math.com online unit converters 
http://www.math.com/students/converters/online_converters.htm 
NCTM's Standards for School Mathematics 

NCTM eexample, counting by multiples 
http://standards.nctm.org/document/eexamples/chap4/4.5/index.htm 
NCTM eexample, make patterns on 100s template 
http://standards.nctm.org/document/eexamples/chap4/4.5/index.htmv 
NCTM eexample, Fraction Traction 
http://standards.nctm.org/document/eexamples/chap5/5.1/index.htm 
Number base converter 

Olympic Medal results by NBC 

Pam Lewis’ Home Page 

Spreadsheet lessons by Susan Alejandre 

State and County quick facts from the Census Bureau 

Weather Underground – historical weather data 
http://www.wunderground.com/ 
.
Back to "Use Spreadsheets to Teach Mathematics and Meet Standards"