Spreadsheets are an extremely useful tool in mathematical investigations, presentations, and simulations. An essential feature should be the ability to make graphs and charts. There are a great deal of spreadsheets available, such as EXCEL, WINGS, or ClarisWorks. In addition, many spreadsheets designed specifically for statistical analysis are available, such as MINITAB and FATHOM. I have used MINITAB and feel it is an outstanding piece of software. For more information, you can visit Addison Wesley Longman's website at http://hepg.awl.com, keyword: MINITAB. For more information about FATHOM, contact Key Curriculum Press.
It is important for high school students to receive exposure to commom spreadsheet applications, such as EXCEL. The ability to use spreadsheet applications has become increasingly more important for college students and employees in today's workforce.
The following investigation is carried out using EXCEL. It is a great investigation for students who are beginners with spreadsheet software. As students learn to use the capabilities of EXCEL, the value of the tool becomes very apparent. In addition, the mathematics of the investigation are not very difficult, but challenge the student with discovery.
A B C D




AB BC CD DA
































In the eighth row, we get a row of all zeros.
Another trial.




















In the fifth row, we get a row of all zeros.
After repeated trials, it does in fact appear that the process will always lead to a zero in all four entries of a particular row.
It is not too difficult to generate up to eight rows before a zero row is generated, but is it possible to generate ten or more rows before a zero row is generated?
If you have any comments concerning this investigation that would be useful, especially for use at the high school level, please send email to esiwdivad@yahoo.com.
Return to my homepage.