<HTML> <HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=windows-1252"> <META NAME="Generator" CONTENT="Microsoft Word 97"> <TITLE>Internet Resources</TITLE> </HEAD> <BODY LINK="#0000ff" VLINK="#800080" BGCOLOR="#ccecff"> <B><FONT FACE="Arial" SIZE=4><P> </P> <P ALIGN="CENTER"> </P> <P ALIGN="CENTER"><A NAME="Top"></A>Spreadsheet Magic by Pamela Lewis</P> </B></FONT><FONT SIZE=2> <P></FONT><A HREF="#Visual">Visual Learning</A></P> <FONT SIZE=2><P></FONT><A HREF="#HigherOrderThinking">Higher Order Thinking</A></P> <FONT SIZE=2><P></FONT><A HREF="#Math">Spreadsheet and Mathematics</A></P> <FONT SIZE=2><P></FONT><A HREF="#Skills">Spreadsheet skills mastered by students K-8, Templates used</A></P> <FONT SIZE=2><P></FONT><A HREF="#Internet">Internet Resources</A></P> <FONT SIZE=2><P></FONT><A HREF="#Magic">Spreadsheet Magic</A></P> <FONT SIZE=2><P></FONT><A HREF="#Author">About the author</A></P> <FONT SIZE=2><P> </P> </FONT><B><I><FONT FACE="Arial" SIZE=4><P><A NAME="Visual">A powerful tool for visual learners</A></P> </B></I></FONT><P>Students use color and pattern to fill cells on the grid. They use the grid for counting, doing math problems and making color patterns. In the first example below, they count to 100, notice number patterns, count in multiples and shade those cells. In the second example, cell borders are selectively hidden or shown and this is useful for learning fractions or making number lines.</P> <P><IMG SRC="visual.gif" WIDTH=238 HEIGHT=218></P> <P>Students insert <B>Clip Art</B> to count on computer, make their own pictographs, make bingo boards, calendars. Free Clip Art can be found on the Internet, at sites like Microsoft Design Gallery (http://dgl.microsoft.com/). Students copy a picture from the Internet, by right-clicking it using a PC, or by holding down the mouse using a Mac, they select copy, return to the spreadsheet application, and paste the picture into the appropriate cell. They must acknowledge the source of pictures copied and observe copyright restrictions.</P> <B><I><FONT FACE="Arial" SIZE=4><P><A NAME="HigherOrderThinking">Promote higher order thinking</A></P> </B></I></FONT><P>Spreadsheet formulas are entered on templates for students so that the computer does calculations for them and they focus on problem solving: in one assignment they spend a target amount at a toy store, and in another they make change for a target amount. Higher order thinking skills develop when students make their own formulas to manipulate numbers: they explore why formulas are used and how changing one variable affects the numbers generated in cells. They use formulas to count the cells in a spreadsheet, to generate a multiplication table, to generalize a rule, make magic squares, do conversions, and to make a calculator.</P> <P> </P> <B><I><FONT FACE="Arial" SIZE=4><P>Organize information</P> </B></I></FONT><P>Columns and rows organize data and pictures, for example to make an animal classification table. Students copy and paste information from the Internet into spreadsheet columns, for example when planning a trip to a foreign country.</P> <FONT SIZE=2><P></FONT><A HREF="#Top">Back to the top</A></P> <UL> <LI><A NAME="Math"></A><B><I><FONT FACE="Arial" SIZE=4>Teach Mathematics</LI></UL> </B></I></FONT><FONT SIZE=2><P> Assignments demonstrated show the following:</P> <UL> </FONT><LI>Counting on the grid, using pictures or numbers. Patterns become evident and students notice their own mistakes, as they see, for instance, that every number at the end of the row in the hundreds chart should end in a zero.</LI> <LI>Doing Math problems, adding and subtracting with the grid as a visual aid</LI> <LI>Making a budget to spend a target amount at a toy store and problem solving when the rules change and they have less money than expected to spend</LI> <LI>Using coordinates as they enter numbers in assigned cells on the grid</LI> <LI>Making arrays by formatting borders selectively around cells</LI> <LI>Making a multiplication table on the grid, first calculating the products themselves, then checking it by having the computer make the calculations for them</LI> <LI>Making change and make conversions with the help of formulas</LI> <LI>Making a magic square with or without formulas</LI> <LI>Making a pictograph or bar graph (First graders have fun with this)</LI> <LI>Making computer generated charts and interpreting them, making predictions based on an understanding of information on charts as students count M&M's and sort them by color, then try to predict the total number for each color in the one unopened bag. They interpret the charts to make comparisons and analyze their findings.</LI> <LI>Using the grid, borders, filling cells with color to help visualize fractions and decimals, making number lines to compare fractions, decimals, positive and negative numbers. The number line is also used to make time lines for Social Studies or Language Arts. </LI> <LI>Using formulas and predicting how changing one variable will affect the outcome. Exploring when formulas can and cannot be generalized. Students use formulas to find the rule, making conversions, making a calculator and calculate their own grades.</LI></UL> <FONT SIZE=2><P></FONT><A HREF="#Top">Back to the top</A></P> <P> </P> <UL> <LI><A NAME="Skills"><B><I><FONT FACE="Arial" SIZE=4>Skills </A>learned K-8 - Use Templates </LI></UL> <DIR> </B></I></FONT><P>Students as young as kindergartners can use spreadsheets with the help of templates where formatting has been done for them and they focus on the task at hand, for instance, they duplicate pictures as they count to ten on the grid, or fill in the numbers from one to ten. They concentrate on counting, or on making a pattern, gradually developing their computer skills. <P><IMG SRC="Image8.gif" WIDTH=238 HEIGHT=218></P>By eighth grade, students understand the use of spreadsheets and can create a new spreadsheet for their purposes. They are able to do the following:</P></DIR> <UL> <UL> <LI>Move through a spreadsheet (arrows, tab, enter, home, end) </LI> <LI>Duplicate graphics and move them into cells </LI> <LI>Enter and format text and numbers in cells (change font, color, size, bold)</LI> <LI>Add Clip Art, resize it</LI> <LI>Find pictures online and paste them into a Spreadsheet </LI> <LI>Fill cells with color or pattern </LI> <LI>Create graphs/charts, both computer-generated and their own</LI> <LI>Format borders so that they show around some or all cells</LI> <LI>Sort data in alphabetical or numerical order </LI> <LI>Use the Thesaurus and Spell Check </LI> <LI>Use readymade formulas and make up new ones</LI> <LI>Generalize formulas by filling right or down </LI> <LI>Set display options - show or hide the grid, and column and row headings </LI> <LI>Set print options</LI></UL> </UL> <FONT SIZE=2><P></FONT><A HREF="#Top">Back to the top</A></P> <P> </P> <UL> <LI><A NAME="Internet"><B><I><FONT FACE="Arial" SIZE=4>Internet Resources</A></LI></UL> </B></I></FONT><P>Tutorials for teachers to learn to use Spreadsheets:</P> <TABLE BORDER CELLSPACING=1 CELLPADDING=5 WIDTH=617> <TR><TD WIDTH="38%" VALIGN="TOP"> <P>Description</TD> <TD WIDTH="62%" VALIGN="TOP"> <P>Web Address</TD> </TR> <TR><TD WIDTH="38%" VALIGN="TOP"> <P>Apple's Spreadsheet tips</TD> <TD WIDTH="62%" VALIGN="TOP"> <FONT SIZE=2><P></FONT><A HREF="http://www.apple.com/education/k12/products/appleworks/tips/index.html">http://www.apple.com/education/k12/products/appleworks/tips/index.html#spreadsheet</A></TD> </TR> <TR><TD WIDTH="38%" VALIGN="TOP"> <P>In and out of the classroom with Microsoft Excel</TD> <TD WIDTH="62%" VALIGN="TOP"> <FONT SIZE=2><P></FONT><A HREF="http://www/">http://www</A>.microsoft.com/education/tutorial/classroom/excel97/default.asp</TD> </TR> <TR><TD WIDTH="38%" VALIGN="TOP"> <P>Macintosh Tips and Tutorials - Spreadsheet tutorials</TD> <TD WIDTH="62%" VALIGN="TOP"> <FONT SIZE=2><P></FONT><A HREF="http://home.earthlink.net/~ohora/spreadsheet/index.html">http://home.earthlink.net/~ohora/spreadsheet/index.html</A></TD> </TR> </TABLE> <P>Examples of real data that can be used to make spreadsheets </P> <TABLE BORDER CELLSPACING=1 CELLPADDING=5 WIDTH=617> <TR><TD WIDTH="38%" VALIGN="TOP"> <P>Description</TD> <TD WIDTH="62%" VALIGN="TOP"> <P>Web Address</TD> </TR> <TR><TD WIDTH="38%" VALIGN="TOP"> <P>A Weekend in Paris - links for a weekend trip.</TD> <TD WIDTH="62%" VALIGN="TOP"> <FONT SIZE=2><P></FONT><A HREF="http://www.kn.pacbell.com/wired/fil/pages/listleweekeba.html">http://www.kn.pacbell.com/wired/fil/pages/listleweekeba.html</A></TD> </TR> <TR><TD WIDTH="38%" VALIGN="TOP"> <P>Calculates the distance between cities as the crow flies</TD> <TD WIDTH="62%" VALIGN="TOP"> <FONT SIZE=2><P></FONT><A HREF="http://www.indo.com/distance/">http://www.indo.com/distance/</A></TD> </TR> <TR><TD WIDTH="38%" VALIGN="TOP"> <P>Database of information about the planets.</TD> <TD WIDTH="62%" VALIGN="TOP"> <FONT SIZE=2><P></FONT><A HREF="http://www.planetscapes.com/solar/eng/query.htm">http://www.planetscapes.com/solar/eng/query.htm</A></TD> </TR> <TR><TD WIDTH="38%" VALIGN="TOP"> <P>M&M's industrial Candy home page</TD> <TD WIDTH="62%" VALIGN="TOP"> <FONT SIZE=2><P></FONT><A HREF="http://www.m-ms.com/factory/history/faq1.html">http://www.m-ms.com/factory/history/faq1.html</A></TD> </TR> <TR><TD WIDTH="38%" VALIGN="TOP"> <P>Number base converter</TD> <TD WIDTH="62%" VALIGN="TOP"> <FONT SIZE=2><P></FONT><A HREF="http://www.math.com/students/converters/source/base.htm">http://www.math.com/students/converters/source/base.htm</A></TD> </TR> <TR><TD WIDTH="38%" VALIGN="TOP"> <P>Olympic Medal results by NBC</TD> <TD WIDTH="62%" VALIGN="TOP"> <FONT SIZE=2><P></FONT><A HREF="http://sydney2000.nbcolympics.com/">http://sydney2000.nbcolympics.com/</A></TD> </TR> <TR><TD WIDTH="38%" VALIGN="TOP"> <P>State and County quick facts from the Census Bureau</TD> <TD WIDTH="62%" VALIGN="TOP"> <FONT SIZE=2><P></FONT><A HREF="http://quickfacts.census.gov/qfd/">http://quickfacts.census.gov/qfd/</A></TD> </TR> <TR><TD WIDTH="38%" VALIGN="TOP"> <P>Weather Underground - historical weather data</TD> <TD WIDTH="62%" VALIGN="TOP"> <FONT SIZE=2><P></FONT><A HREF="http://www/">http://www</A>.wunderground.com/</TD> </TR> </TABLE> <P>Resources for teaching the Mathematical concepts mentioned above:</P> <TABLE BORDER CELLSPACING=1 CELLPADDING=5 WIDTH=617> <TR><TD WIDTH="38%" VALIGN="TOP"> <P>Ask Dr. Math</TD> <TD WIDTH="62%" VALIGN="TOP"> <FONT SIZE=2><P></FONT><A HREF="http://forum.swarthmore.edu/paths/fractions/">http://forum.swarthmore.edu</A></TD> </TR> <TR><TD WIDTH="38%" VALIGN="TOP"> <P>Fractions assignments </TD> <TD WIDTH="62%" VALIGN="TOP"> <FONT SIZE=2><P></FONT><A HREF="http://math.rice.edu/~lanius/fractions/">http://math.rice.edu/~lanius/fractions/</A></TD> </TR> <TR><TD WIDTH="38%" VALIGN="TOP"> <P>Allmath.com</TD> <TD WIDTH="62%" VALIGN="TOP"> <FONT SIZE=2><P></FONT><A HREF="http://www.allmath.com/MagicSquare.asp">http://www.allmath.com</A></TD> </TR> <TR><TD WIDTH="38%" VALIGN="TOP"> <P>Math.com </TD> <TD WIDTH="62%" VALIGN="TOP"> <FONT SIZE=2><P></FONT><A HREF="http://www.math.com/students/converters/online_converters.htm">http://www.math.com</A></TD> </TR> <TR><TD WIDTH="38%" VALIGN="TOP" HEIGHT=57> <P>National Council of Teachers of Mathematics - Standards for School Mathematics</TD> <TD WIDTH="62%" VALIGN="TOP" HEIGHT=57> <FONT SIZE=2><P></FONT><A HREF="http://standards.nctm.org/document/chapter3/index.htm">http://standards.nctm.org/document/chapter3/index.htm</A></TD> </TR> <TR><TD WIDTH="38%" VALIGN="TOP" HEIGHT=24> <P>Aplus Math</TD> <TD WIDTH="62%" VALIGN="TOP" HEIGHT=24> <FONT SIZE=2><P></FONT><A HREF="http://www.aplusmath.com/">http://www.aplusmath.com</A></TD> </TR> <TR><TD WIDTH="38%" VALIGN="TOP" HEIGHT=24> <P>Math Games</TD> <TD WIDTH="62%" VALIGN="TOP" HEIGHT=24> <FONT SIZE=2><P></FONT><A HREF="http://www.mathgames.com/">http://www.mathgames.com</A></TD> </TR> <TR><TD WIDTH="38%" VALIGN="TOP" HEIGHT=16> <P>Edhelper - Free Math worksheets</TD> <TD WIDTH="62%" VALIGN="TOP" HEIGHT=16> <U><P>http://www.edhelper.com/math.htm</U></TD> </TR> </TABLE> <P>Websites for integrating spreadsheets:</P> <TABLE BORDER CELLSPACING=1 CELLPADDING=7 WIDTH=589> <TR><TD WIDTH="49%" VALIGN="TOP"> <P>MS Excel Resources</TD> <TD WIDTH="51%" VALIGN="TOP"> <P>http://www.sabine.k12.la.us/class/excel_resources.htm</TD> </TR> <TR><TD WIDTH="49%" VALIGN="TOP"> </TD> <TD WIDTH="51%" VALIGN="TOP"> </TD> </TR> <TR><TD WIDTH="49%" VALIGN="TOP"> <P>Integrating spreadsheets across the curriculum</TD> <TD WIDTH="51%" VALIGN="TOP"> <U><P>http://www.kn.pacbell.com/wired/fil/pages/listspreadshli.html</U></TD> </TR> </TABLE> <U><FONT SIZE=4><P></U></FONT><A HREF="#Top"><FONT SIZE=4>Back to the top</FONT></A></P> <UL> <LI><A NAME="Magic"><B><I><FONT FACE="Arial" SIZE=4>Spreadsheet Magic</LI></UL> </B></I></FONT><P></A>by Pamela Lewis has recently been published by ISTE (International Society for Technology in Education: <A HREF=http://www.iste.org</A>). It includes an appendix entitled "Teacher, Teach Yourself!" with instructions for mastering the skills. There are more than 40 lessons in the book with detailed descriptions for doing the assignments. It includes a CD-ROM with templates and samples of completed assignments. National standards met by each assignment are listed for Technology, Mathematics, and other subjects.</P> <UL> <LI><A NAME="Author"><B><I><FONT FACE="Arial" SIZE=4>About the author</A></LI></UL> </B></I></FONT><P>Pamela Lewis works as Technology Coordinator at St. Luke School in Brookfield WI. She trains teachers on computer for the Archdiocese of Milwaukee "Train the Trainer" program and teaches graduate computer classes for St. Mary's University of Minnesota Outreach program. She has presented on Spreadsheets and other topics at several conferences, both local and national. E-mail: <A HREF="mailto:pamlewis@execpc.com">pamlewis@execpc.com</A></P> <FONT SIZE=2><P></FONT><A HREF="#Top">Back to the top</A></P></BODY> </HTML>