TEACHER NOTES

Worksheets

Unit 1 - Information Systems

Harveys Pharmacy
Study a pharmacy and the flow of information for their ordering system.

Notes for Section Six
Notes to help student complete section six for the pre-release material (Jan 2001).

Unit 2 - Spreadsheet Design

Rules for Game 5000
Explains the rules for Game 5000. This is an ideal exercise to develop a spreadsheet to re-inact the game.

Instructions for Game 5000
This worksheet explains how to develop the spreadsheet for the Game 5000. First you need to load the EXCEL template for the game. yr12_agm201.xls

Project Details
Details the requirements for the project. Every section must be attempted.

Ledger Example
An EXCEL example of a ledger thought there are not instructions of explaination notes

Financial Functions and Tri functions
Explanation notes on how to use PMT, FV, SIN, COS in spreadsheet design. Does also need the user to write their own function to convert Degrees into Radians.

Unit 4 - System Installation

Expansion Cards
Look at the different types of expansion cards and motherboards.

Day and Knight Checklist
When installing hardware or software use this checklist sheet to help you follow the correct sequence. It will also help you keep notes no exactly what you did so the customer can be told/

Day and Knight Repair Form
Example of a computer repair form with macros assigned. No notes on what these macros are thought.