Appendices Appendix A ICT Literacy A4 Working with a Spreadsheet
Previous TOC Next

UNIT A4 – WORKING WITH A SPREADSHEET

Objective

Students should be able to understand and make use of a prepared spreadsheet.

Sub-objectives

Students should be able to:

  1. demonstrate an understanding of what a spreadsheet is and its uses;
  2. use a prepared spreadsheet to change values of variables and to see its various effects;
  3. demonstrate an understanding of the uses of a spreadsheet.

Context

Spreadsheets are useful tools for individual or group work, and are widely used in industry and commerce. Students should understand what a spreadsheet is, how easy it is to manipulate variables, and should see the effects of this manipulation.

Content

Students are introduced to the concept of a spreadsheet and the components in a spreadsheet. They manipulate a spreadsheet by changing values in cells, and will also, perhaps, change formulas to see the effects. Graphs, based on the values entered in the cells, may be generated automatically. Students should also be able to understand the various uses of a spreadsheet in daily tasks.

Resources

Minimum necessary resources:
Computer systems for group work, spreadsheet software;
Teacher-prepared spreadsheets.

Optional extra resources:
Ready-made spreadsheets;
Liquid crystal display panel and overhead projector;
Tutorial software.

Links

All other A-Units

Methodology

Demonstrations; student-centred, hands-on activities.