Thursday, October 18, 2007

Spreadsheets

I have realized that spreadsheets are a great tool for both teachers and students. I think a great activity that would incorporate the use of a spreadsheet would be tracking stocks. Each students would be given $10 000 to buy into as many stocks as they would like. Every week, the students would tract and record their stocks progress on a spreadsheet. On the spreadsheet they would record the stocks they purchased, how much they spent on each stock, the progress of their stocks over a two month period, and finally calculate how much they made on each stock and their overall sum. The teacher could also ask the students to create a graph that shows the progress of their stocks using excel. This would be a great opportunity for students to learn about stocks and how they work.

No comments: