After he wrote the new numbers, he would have to redo all the calculations by hand. With the invention of the personal computer, it became possible to do projections and calculations electronically. Not only did it allow entry of data into the computer's memory, it also allowed for automatic recalculation of the entire spreadsheet whenever values were changed. It also allowed database-style inquiries in order to determine relationships among numbers, as well as printed tabular reports. Other spreadsheets such as AppleWorks and ClarisWorks, allow data to be shared easily among programs.
Spreadsheet programs have nothing to do with music education directly.
However, they can be a real godsend to the teacher who must keep records for ten classes, as well as administer a large music budget. In this introduction to spreadsheets, we shall create a spreadsheet to keep track of grades for a small class students. An example Grades spreadsheet is included within this document. It will serve as a model for your own spreadsheet. A spreadsheet consists of numerous cells that are named for their locations in the columns and rows.