Music Class - Home Information Technology - Home Music Technology - Home OzMusEd - Australian Music Resources - Home
References Class work
Click on each module below
Work effectively in an information technology environment
Apply occupational health and safety procedures
Operate computing packages
Operate computer hardware
Design organisational documents using commercial computing packages
Integrate commercial computing packages
Maintain equipment & consumables
Communicate in the workplace
Connect hardware peripherals
Install software applications
Maintain system inventory
Receive and process oral and written communication
Maintain equipment / software inventory
Interact with clients
Identify components of multimedia
Access the internet

© S. Wilkins 17 June, 2006

PRELIMINARY COURSE
(AGHS 2004)
TERM 2 WEEK 1 - 4
Removing, Unpacking and Installing Computers
Installing and setting up computers
  

Half Yearly Exam
(WEEK 5)
  • Section I - Multiple Choice - 15 Marks
  • Section II - Short Answer - 30 Marks
  • Section III - Long Answer - 20 Marks
TERM 2 WEEK 7 - 8
Operate computing packages - Spreadsheets and Databases
Using computers for data management

Work in this unit will refer to Chapter 2 of the IT Text book: The Computer as a Data Management Tool
Spreadsheet Activities:

Spreadsheet terms you need to know are:- cells, rows, columns, range, formulae, functions (sum, average, maximum, minimum, count, if ), templates, cut/copy/paste, fill, pie/column/bar/line chart

Database Activities:

Database terms you need to know are:- field, record, table, sort, query, Structured Query Language (SQL), Relational Database Management System, form, report, security, record locking

As you learn about databases you will be required to create a database about your friends, step by step. Make sure you fully understand how to do the following:- (this is good for revision!)

  • create a table with correct fields and data types
  • design a form to enter data
  • print, sort and query the data using SQL
  • mail merge with a word processor document and print our invitations to a party!
Database Assessment Task:

Complete the Database Assessment Task over the holidays.

This task requires a database program such as Microsoft Access. If you do not have this MS Office, you will need to download a database program (such as StarOffice) or complete the task in your own time at school.

On this page you will find references and class work developed for students studying Information Technology (VET) in Years 11 and 12.
 This page is constantly under construction.

 Each GREEN button (left) will take you to a Core or Elective Module page with Course Materials, Key Terms and Concepts, HSC Requirements and Performance Criteria the activities.