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 4 May, 2006

PRELIMINARY COURSE
(AGHS 2005)
P.T1 | P.T2 | P.T3
H.T4 | H.T1 | H.T2 | H.T3
TERM 3 WEEK 1 - 7
Operate Compuing Packages (cont)
Spreadsheets

cells, rows, columns, range, formulae, functions (sum, average, maximum, minimum, count, if), templates, cut/copy/paste, fill, pie/column/bar/line chart.

Complete these activities (hardcopies from your teacher):-

  • Develop Your Skills (DYS) Activities:- 1, 2, 5, 6, 7, 14, 15, 16, 17, 18
  • Edsonic's Creating Spreadsheets and Produce Business Documents.pdf Activities 1 - 2 (p41-43)
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.
TERM 3 WEEK 7 - 10
Design Orgaisational Documents /
Integrate Commercial Computing Packages
Design Organisational Documents
 Assessment Task

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.