2006A Task 2 Marking Guide

2006a Task 1 Marking guide

Consideration:loose cables,

Solution:Tie and bundle all loose cables. If possible, cables should run inside walls or ceilings. Attach outside cables to walls.

Consideration:broken items,

Solution:All broken items should be repaired or removed.

Consideration:glare or poor lighting,

Solution:You can move the screen, lower the light level, use a good quality, glass anti-glare screen. Also make sure that the computer monitor screen isn't backed to a bright window or facing a bright window so that there's the screen looks washed out (use a shade or drapes to control window brightness).

You can also consider using a good quality glass anti-glare filter or an LCD display (like a laptop screen).

Solution from CornellUniversity Ergonomics Web

‘Ergonomic Guidelines for arranging a Computer Workstation’

Consideration:excessive noise

Solution:Try to choose a quiet place for your workstation, and use low volume music, preferably light classical, to mask the hum of any fans or other sound sources.

Solution from CornellUniversity Ergonomics Web

‘Ergonomic Guidelines for arranging a Computer Workstation’

Consideration:draught,

Solution:Move any seating that is in a draught to a non draught area.

Consideration:chair height,

Solution:Studies show that the best seated posture is a reclined posture of 100-110 degrees NOT the upright 90 degree posture that is often portrayed. In the recommended posture the chair starts to work for the body and there are significant decreases in postural muscle activity and in intervetebral disc pressure in the lumbar spine. Erect sitting is NOT relaxed, sustainable sitting, reclined sitting is.

Solution from CornellUniversity Ergonomics Web

‘Ergonomic Guidelines for arranging a Computer Workstation’

Consideration:keyboard positioning,

Solution:Use an external keyboard, preferably with a negative-tilt keyboard tray . Height should be adjustable, that allows you to tilt the keyboard down away from you slightly for better wrist posture (negative tilt),

Solution from CornellUniversity Ergonomics Web

‘Ergonomic Guidelines for arranging a Computer Workstation’

Consideration:special requirements of the operator.

Solution:Special requirements must be considered for any operator.

memorandum

Grade / Class Mark
DISTINCTION / 83%
CREDIT / 70%
PASS / 50%

ICAU2006A Task 2 Marking guide (16 marks total)

TO:DigiMobile Purchasing department

FROM:<Enter your name here>

SUBJECT:Software recommendations for DigiMobiles business requirements.

DATE:<Enter today’s date>

CC:

Dear Colleagues,

My software recommendations for DigiMobiles business requirements are as follows:

1.A Wordprocesoor software application.(3 marks)

2.Multimedia presentation software(such as MicroSoft Power Point).(3 marks)

3.A database software application/package.(3 marks)

4.A spreadsheet software application/package.(3 marks)

5.A program used to create and edit HTML documents. The easiest type of application is a WYSIWYG (what-you-see-is-what-you-get) editor, meaning that you can create the Web page exactly as you want it to look on the screen, and the program adds the HTML source code necessary to make sure that the page looks right in a Web browser (such as Microsoft FrontPage). (4 marks)

Grade / Class Mark
DISTINCTION / 83%
CREDIT / 70%
PASS / 50%

(16 marks total)

ICAU2006A Task 3 Marking Guide

Directory of folders (directories)saved onto a floppy disk or CD.

folder (directory) named ‘DigiMobile’(3 marks)
subfolder (subdirectory) of ‘DigiMobile’ named ‘Business Documents’.

(3 marks)

subfolder (subdirectory) of ‘BusinessDocuments’ named ‘WordProcessorDocuments’ (3 marks)
subfolder (subdirectory) of ‘BusinessDocuments’ named ‘SpreadSheets’

(3 marks)

subfolder (subdirectory) of ‘BusinessDocuments’ named ‘Databases’.

(3 marks)

Task 1 checklist saved in the appropriate folder (directory) also saved onto the floppy disk or CD. (1 mark)

Grade / Class Mark
DISTINCTION / 83%
CREDIT / 70%
PASS / 50%

ICAU2006A Task 4 Marking Guide: (16 marks total)

Software application / Description / Information site links / Download site links
Microsoft Word 2003 / A word processing program that you can use to create, edit, format, and save documents. / / Trial version download:
MS Access 2003 / A Microsoft software product that is primarily a data management tool (database software). Access has tools to enter, edit, and index data and to retrieve it via custom forms and reports.
(2 marks) /
(1 mark) / Access sample available at:
(1 mark)
MS Excel / A spreadsheet program that you can use to perform numerical calculations and bookkeeping tasks.
(2 marks) /
(1 mark) / Excel samples: (1 mark)
Macromedia DreamWeaver / Software from Macromedia used to build and manage websites and Internet applications.
(2 marks) /
(1 mark) / Trial version download:
(1 mark)
MS PowerPoint / A Microsoft software product, which aids in the creation of professional-looking presentations. PowerPoint handles text, outlines, drawings, graphics, and clip-art in the design of presentations and 'slide-shows'. (2 marks) /
(1 mark) / Samples available at: (1 mark)
Grade / Class Mark
DISTINCTION / 83%
CREDIT / 70%
PASS / 50%

Task 5 Marking Guide: (18 marks total)

Tim Allen Timesheet February 2005 (4 marks)

FlorenceHenderson Timesheet February 2005(4 marks)

Tony Barber Timesheet February 2005(4 marks)

A column chart embedded in each worksheet(6 marks)

Grade / Class Mark
DISTINCTION / 83%
CREDIT / 70%
PASS / 50%

Task 6 Marking Guide: (18 marks total)

DigiMobileSoftwarePackageInventory database, savedin the database folder (2 marks)

SoftwareInventoryTable created with data entered(2 marks)

and contains correct type fields:

a)Software Name: (Text)(2 marks)

b)Description: (Text)(2 marks)

c)Source: (HyperText Link)(3 marks)

d)Version: (Number)(2 marks)

e)Price: (Currency)(2 marks)

Sorted in ascending order by Price(3 marks)

Click here for icau2006a access database

Click here for icau2006a spread sheet

2004