2.8 Spreadsheets
2.8.1 Define Spreadsheets
.8.2 Outline the components of a spreadsheet including rows, columns, formulas, formatting and macros
Shortcomings of SS
Advantages of SS
2.8.3 Outline the major developments of spreadsheets from VisiCalc to modern SS software
2.8.4 Apply equations in spreadsheets to solve common problems including the processes of addition, subtraction, multiplication, division and the calculation of totals, means and character manipulation.
.
2.8.5 Predict the outcomes of changing the contents of cells in spreadsheets and the results obtained if given a simple spreadsheet formula.
2.8.6 Suggest two possible future developments of SS software.*
2.8.7 Discuss one situation where spreadsheets have been used to solve problems for each of the following: individuals, communities, and institutions/organizations.
2.8.8 Design a spreadsheet to solve a simple problem.
2.8.9 Discuss the possible ethical considerations arising from a total dependence on spreadsheets.