© S. Wilkins 17 June, 2006

Revision for Yearly
Preliminary Exam 2004

The exam will be in THREE sections and is out of 80:-

1. MULTIPLE CHOICE: Q1-15 (15 Marks)
2. SHORT ANSWER: Q16-19 (35 Marks)
3. EXTENDED REPONSE: Choose TWO questions from Q20-22 (30 Marks)

Revision Questions and Activities

Occupational Health and Safety

• Describe the following conditions:- Repetitive strain injury, occupational overuse syndrome, carpal tunnel syndrome, eye strain
• View the Ergonomics presentation and complete Activity 5 (plus all other activities) from the OH&S Handout
• Complete this Ergonomics Quiz

Connect Hardware Peripherals

• What consumables are required for:- a dot matrix printer, a laser printer, an inkjet printer, a floppy disk drive, a cd burner
• Computer Connections JMatch Activity
• What is a device driver and what does it do?

Operate Computer Hardware

• Input, Output and Storage Devices quiz
• General Hardware Quiz
• A new client-server computer network has been installed in your workplace / school. You now have to log on with a username and password.
  • Explain where your files are stored on this network?
  • What are the advantages and disadvantages of this system?
  • What is a file server?
  • What is a client workstation?

Operate Computer Packages

• Design a memorandum addressed to your teachers to document the study schedule you will be adopting in preparation for your yearly exams. Refer to the Creating a Memo activity you should have completed.
• Spreadsheet activities
• Try this Spreadsheet Quiz and then try these ones
• Explain what each of these spreadsheet terms mean:- cells, rows, columns, range, formulae, functions, fill, pie/column/bar/line chart
• Word Processor Functions homework sheet. Make sure you know how to format paragraphs and change the line spacing of a document.
• Explain how to use TABS correctly in a word processor.
• Data Types Quizes
• Complete this SQL quiz. (Remember, you only really have to know about the SELECT, FROM, WHERE and ORDER statements, and how to use AND, OR and LIKE commands. The % sign = a wildcard)
• What information would it be important to keep if maintaining a database of all of the computers in the school. Think about what you would need to know about each computer to help you work out fields and tables for the database.
• For each of the following, name the type of file and explain what it is. Give an example of a piece of software that uses each file type:- RTF, DIF, TXT, PNG, GIF, JPEG
• Why might you not be able to access the school's EduWeb inTRAnet site from home?
• When designing a website, explain some of the conventions you would use when saving files, such as, what would you name the home page file, where would you store image files, how would you set up your folders and directories?

Maintain System Integrity

• What is the difference between a software register and a software licence
• Make sure you have completed all these Class Activities on virus protection and backing up.