I have linked my spread sheet above. This could be one way to use a spread sheet in the classroom.
http://spreadsheets.google.com/ccc?key=pXtQRU686lJ7as7RMm25DAw&hl=en
I had to work with a spreadsheet this week and what a great way to manage a budget. I have been working on a make up unit plan having to do with music. although the spread sheet i had to do was over a wedding budget I know that I could use a spreadsheet in a the future.
One way that I would use a spread sheet would be with the unit plan that I have been working on. I would ask the students if they could start a band what type would it be? Then I would go into further detail with this. for example, i would ask what is needed to start this band. I would then give them a budget to go out and by there necessities. they can do some research and find out things they already knew or things they didn't know.
I had work on spread sheets before but i never knew that a spread sheet could give a message. I like that if i went over budget i would get a negative message. if i stay on or was under budget i would get good news. if they were under budget i would leave the a message that they could be allowed to purchase one more item that could be used for the band. If they were over budget they would have to stick with what they bought.