mathsnet.net subscribe to mathsnetgcse.com  

home geometry ASA2 curriculum puzzles articles books download about us try a short tour MathsNet.com

spreadsheets

animations excel

links return to software page
Using spreadsheets in education, not just for data handling but for pure mathematical investigation too.
Some highlights
What is a spreadsheet? | A to Z | Ideas | Excel
Find out what a spreadsheet is, view a dictionary of basic spreadsheet terms and try out some ideas. Have a look also at these animations of common spreadsheet operations.

Recent additions
Embedded spreadsheets
For you to view and use the embedded spreadsheets on these pages, you will need to install a free plug-in from Formula One/NET. Go to the download page for details.

Some spreadsheet ideas

idea What is the largest number your spreadsheet can display?
(See here for a partial answer.)

idea Magic grid. Try this trick. Copy out the grid below. Now put a circle round any number and cross out all the others in the same row and column. Choose another number that has not been crossed out, circle it and once again cross out all the others in the same row and column. Continue until all the numbers are used up. Add up the four numbers you circled. Do you get 30? How does this work? Use a spreadsheet to create more, and bigger, magic grids.

6 5 8 3
9 8 11 6
7 6 9 4
10 9 12 7

idea Chaos. If you choose a value for the constant c and an initial value for the variable x, then the following formula will tell you how to work out the next value of x:

	next value = cx(1-x)


This formula can be used over and over again, to obtain a sequence of numbers. Start with 5 for c and about 0.1 for x and see what you get.




Spreadsheet links


You can find a brief introduction to the basics of spreadsheeting - using ClarisWorks - at Swarthmore. Spreadsheets in Education contains a varied collection of starting points, including lists of links.
Java is a programming language that browsers like Netscape can understand. For an illustration of the java language as applied to spreadsheets, visit the site at Sun, but note you must be using the 32-bit version of Netscape to do this. Another java spreadsheet can be found at Robert's online spreadsheet. Try the home page of The Spreadsheet User journal.

There are many other web resources based on Excel.



Google


copyright mathsnet