Information Processing 10, 20, 30
Investigate the purpose and characteristics of spreadsheets.
Indicators for this outcome
| (a) | Provide a definition for the term spreadsheet. |
| (b) | Describe the purpose, benefits and limitations of spreadsheets. |
| (c) | Discuss practical uses for spreadsheets. |
| (d) | Compare the features and functionality of a spreadsheet with those of a word document or a database. |
| (e) | Explain common spreadsheet components such as cell, row, column, cell address, active cell, current cell, range, workbook and worksheet, functions and formula. |
| (f) | Demonstrate common functions available in spreadsheets such as formatting, filtering, sorting and calculations. |
| (g) | Distinguish among the three types of information (label, value, formula) a cell can contain. |
| (h) | Identify the formula bar, name box, mouse pointer, column letters, row numbers, sheet tabs, task pane, help feature, tab scrolling buttons and toolbars in a spreadsheet application. |
| (i) | Compare the features and functionality of various spreadsheet software and mobile apps. |
| (j) | Compare the features and functionality of desktop and mobile versions of a specific spreadsheet application. |
| (k) | Explore formatting options available in spreadsheets, including row height, column width, borders, numerical formats, alignments and fills. |
Loading...
