Information Technology in a Global Society

| Home | Overview | Program | Project | Exam Prep | Current Work |

Examination Preparation 3

2.2.2 Spreadsheets

Example spreadsheet

Paper One and Two may require you to study and evaluate the social and ethical issues involved in the use of spreadsheets, you should have an understanding of the following related technological concepts:

• Design and creation concepts

• cell,

• cell format (number, text, value, function, calculation, date, currency),

• row,

• column,

• label,

• formulae

• macro,

• template,

• worksheet,

• “what if” questions,

• range,

• absolute and relative reference

• Paper files versus electronic files

  Read these articles:

  • Optical Imaging Versus Paper Records Storage

  • Records Management

  • Paper vs. Electronic
     

• Reliability and integrity of data

  • Ensuring Spreadsheet Accuracy

  • What We Know About Spreadsheet Errors (long article)

   

• Storage and access concepts

• Data transfer between a database and a spreadsheet

• Presentation concepts

  • Select print and display area of a worksheet

  • Use of the appropriate graph or chart for the meaningful representation of information

• Special-purpose spreadsheets, eg inventory, budget

	Do you understand the concepts and issues involved with spreadsheets? Do you know the meaning of each of the terms in the Design and Creation concepts?  If you don't then do some more research - find out what ALL this means.
	When you think you know about Spreadsheets, complete this examination