Information Processing 10, 20, 30
Explain and use the mathematical features that are characteristic of spreadsheet applications.
Indicators for this outcome
| (a) | Describe the mathematical concept of order of operations. |
| (b) | Perform calculations in spreadsheets using simple mathematical formulae that include addition (+), subtraction (-), division (/), multiplication (*) and exponentiation (^). |
| (c) | Explain that a function is a pre-defined formula. |
| (d) | Apply introductory mathematical functions such as SUM, AVERAGE, MEDIAN, MAX, MIN and ROUND to perform calculations in spreadsheets. |
| (e) | Compare the effectiveness of the fill handle to that of copying and pasting when replicating and adapting data. |
| (f) | Compare the efficiency of using mathematical functions to developing mathematical formulas from scratch. |
| (g) | Explore the effects of changing one or several data values in spreadsheets. |
| (h) | Discuss how data within a spreadsheet can be used to facilitate the decision-making process. |
Loading...
