Thursday, October 4, 2007

What are the advantages and features of electronic spreadsheets? How do you see them as a benefit in an educational environment?

What are the advantages and features of electronic spreadsheets? How do you see them as a benefit in an educational environment?

One of the most beneficial advantage of electronic spreadsheet advantage of using electronic spreadsheet is a savings in manpower and time . Spreadsheets allow a user to easily compute mathematical functions. spreadsheet software package can be used for a variety of tasks to manage a program or research project and to cut costs in evaluation. LOTUS 1 2 3 is a versatile, commonly available, and well-known electronic spreadsheet package.
Spreadsheets were originally designed to emulate financial ledgers and balance sheets. They are useful for estimating projected costs and for simplified budgets. Subtotals and totals for a number of categories are automatically updated when an amount is changed.
Similar techniques may be used to collect, code, sort, and analyze research data--a particularly useful technique for tabulating questionnaire responses. It is also possible to enter questionnaire responses into the spreadsheet while conducting a telephone interview. Several commands may be chained together into a macro, in order to simplify data entry at the terminal.
LOTUS can be programmed to perform statistical procedures, and can sort and graph data. Data are stored on a floppy diskette and may be transferred to a mainframe computer, word processor, or software package. The amount of data which can fit into a spreadsheet is limited by the amount of memory capacity of the hardware system and the ease of moving around many screens of data
For the most part spreadsheets are benefical in the educational environment because reports can be easily generated and can be used as a way to tabulate many kinds of information, not just financial records.

3 comments:

Anonymous said...

I use spreadsheets daily to do precisely the things you described. I use them to analyze cost benefits, keep up with important items in a nice tabled layout, and to import data into other instructional software packages we use. Spreadsheet software enables us to manage data elements quickly and efficiently.

Chris Harper said...

Nicely reported, Jarrett. We do not use anything fancy at my school, so I use Microsoft Excel to keep track of grades and easily figure out each student's average and whatnot for the term. It's easier than trying to figure it all out by hand. You have mentioned some other good uses for spreadsheets as well. The uses for them are seemingly endless in the financial and educational world.

Unknown said...

On 2-2-2013 pm