Appendices Appendix B Application of ICT in Subject Areas E1 Spreadsheet Design
Previous TOC Next

UNIT E1 – SPREADSHEET DESIGN

Objective

Students should be able to design and create a spreadsheet to solve a given problem.

Sub-objectives

Students should be able to:

  1. identify the problem that can be solved by a spreadsheet;
  2. enter and lock headings of columns and rows;
  3. vary width of columns;
  4. allocate values to columns;
  5. create correct formulas;
  6. copy formulas;
  7. re-arrange entries (rows);
  8. re-arrange columns;
  9. import information from a variety of sources;
  10. export information to a variety of destinations.

Context

The ability to create and use spreadsheets has become essential for all involved with financial management, research, and many other commercial activities. Spreadsheets have the advantage that most can easily accept and manipulate information from databases and can create output as graphics. The ability to use spreadsheets efficiently is a decided advantage when seeking employment.

Content

Creating a class hobbies list may be a good first exercise. Students should then create at least one spreadsheet to draw up a budget in which a number of «what-if» situations arise. If the spreadsheet allows it, the reverse of this process should also be utilised. Students should create a simple spreadsheet to accept and calculate the results of an experiment or an opinion survey in at least one other discipline. A number of spreadsheet applications will arise naturally in most school activities. Spreadsheets should be used to create lists which can be re-arranged in a different order as needed.

Resources

Minimum necessary resources:
Simple spreadsheet program;
One computer for a group of students.

Optional extra resources:
Printer;
Training video or computer program;
Liquid Crystal Display panel and overhead projector.

Links

This is an extension of Unit A4 Working with a spreadsheet