DISTINCTION / 83%
CREDIT / 70%
PASS / 50%
ICAU2013A Task 2: Marking Guide (20 marks total)
(Deliverable 1: Word processor document with a static database table inserted.)
(20 marks total)
Example solution:
Word processor document (4 marks).
Static database table inserted (2 marks).
Database table (4 marks).
Solution here---
(Deliverable 2: Word processor document with an embedded spreadsheet (inserted and) created within it.)
Example solution:
Word processor document (4 marks).
Embedded spreadsheet inserted (2 marks).
Spreadsheet (4 marks).
Solution here---
(20 marks total)
Grade / Class MarkDISTINCTION / 83%
CREDIT / 70%
PASS / 50%
Inventory Report
product / product number / supplier / qty on handBlueSteel Fountain Pen / 6732 / Parkin Pen Co / 86
Magnum Roller Ball Pen / 4628 / Monte Noir PL / 14
Client list
Click here for database solution
Grade / Class MarkDISTINCTION / 83%
CREDIT / 70%
PASS / 50%
ICAU2013A Task 3: Marking Guide (20 marks total)
( Deliverable 1: Word processor special offer letters with merged names and addresses from database mailing list. )
(20 marks total)
Example solution:
Database mailing list table ( 5 marks).
Word processor document ( 5 marks).
Merged word processor documents ( 10 marks).
Lifetime Australia Pty Ltd
43 Lifetime Lane
Leichardt, NSW 2222
Tel: 02 9999-4321
(Insert today’s date)
«client_name»
«client_address»
Dear Customer,
Lifetime Australia is having a huge stock take sale!
All our products are 50% off.
This offer ends 30 June 2005.
Sincerely,
Lifetime Australia Pty Ltd
(20 marks total)
Grade / Class MarkDISTINCTION / 83%
CREDIT / 70%
PASS / 50%
Click here for mailing list
Lifetime Australia Pty Ltd
43 Lifetime Lane
Leichardt, NSW 2222
Tel: 02 9999-4321
(Insert today’s date)
«client_name»
«client_address»
Dear Customer,
Lifetime Australia is having a huge stock take sale!
All our products are 50% off.
This offer ends 30 June 2005.
Sincerely,
Lifetime Australia Pty Ltd
Grade / Class MarkDISTINCTION / 83%
CREDIT / 70%
PASS / 50%
Task 4: Marking Guide (20 marks total)
( Deliverable 1: Spreadsheet pricelist. )
( 5 marks)
( Deliverable 2: Product list database table. )
( 5 marks)
( Deliverable 3: Word processor sales brochure with spreadsheet pricelist inserted and product list database table pasted in. )
( 10 marks)
Example solution:
Lifetime Australia Pty Ltd
Products and Pricelist
product / id / descriptionThe Inspirational - Fountain Pen / 47321 / Fountain for bladder or cartridge
Red Writer Rollerball / 62239 / smooth writing rollerball - refillable cartridges
Banana Ballpoint / 82112 / economical plain ballpoint in red,blue or black
(20 marks total)
Grade / Class MarkDISTINCTION / 83%
CREDIT / 70%
PASS / 50%
product / price
Banana Ballpoint / $0.95
Red Writer Rollerball / $15.00
The Inspirational - Fountain Pen / $26.00
Click here for product list
Lifetime Australia Pty Ltd
Products and Pricelist
product / id / descriptionThe Inspirational - Fountain Pen / 47321 / Fountain for bladder or cartridge
Red Writer Rollerball / 62239 / smooth writing rollerball - refillable cartridges
Banana Ballpoint / 82112 / economical plain ballpoint in red,blue or black
Task 5
Deliverables solutions (these solutions were found using Microsoft Office):
Requirement 1.Using Microsoft Word office assistant to find out how to create a drawing inside a word document:
Findings:Use the Drawing toolbar to change and enhance these objects with colors, patterns, borders, and other effects.
The AutoShapes menu on the Drawing toolbar includes several categories of tools.
In the Lines category, you can use Curve, Freeform, and Scribble to draw lines and curves, as well as shapes that combine both lines and curves.
When you want to draw curves with greater control and accuracy, use Curve.
Use Freeform when you want a more refined shape— one without jagged lines or drastic changes in direction.
When you want a drawing object to look like it was drawn with a pen, use Scribble. The resulting shape closely matches what you draw on the screen.
Requirement 2.Using What’s this to find out what an icon is.
Findings:It is the Format Painter in the standard toolbar, copies the format from a selected object, or text, and applies it to the object or text your click.
Requirement 3.Finding Clip Art and Media Featured collections at office.microsoft.com include:
Findings:Finances, Leisure, Globes and Academics.
Requirement 4.Using to find more graphics software applications.
Findings:
- Jasc – Paint Shop Pro 9
- Microsoft – Digital Image Suite 10
- Xara – Xara X1.
Deliverables solutions:
Requirement 1.
Findings:
Requirement 2.
Findings:
Requirement 3.
Findings:
Requirement 4.
Findings: