Certificate III in Information, Digital Media Technology (ICT30115)
ICTICT308
Use Advanced Features of Computer Applications
STUDENT WORKBOOK
You must complete all sections of this workbook in order to finish the assignment
Student Name:___________________________________________
Manipulating Data
1) Using Microsoft Word (or equivalent word processing software), you must create each of the following and paste screenshots along with an explanation of how you created them:
• Pie chart
• Graph
• Table
* For each of the above, you may decide what data or topic is presented
2) Using Microsoft Word (or equivalent word processing software), you must import / transfer data from Microsoft Excel (or equivalent spread sheet software)
* You may decide what data or topic is presented
3) Using Microsoft Word (or equivalent word processing software), you must import text from a website using the Insert Field method. You must paste screen shots below and explain how you achieved this technique.
4) Using Microsoft Word (or equivalent word processing software), you must create a macro to control a typical routine activity needed for a job. You must paste screen shots below and explain how you achieved this technique.
5) In the table below, explain how the following shortcuts can be achieved in Microsoft Word. You should include a range of keyboard, icon and menu shortcuts as part of your answers
Copy
Paste
Indent Paragraph
Open New blank document
Print current document
Accessing and Using Support Resources
6) List and describe at least three DIFFERENT support resources available online that could help you with any routine problems encountered with using Microsoft Office
1 –
2 –
3 –
7) Find the OFFICIAL online support website for Microsoft Office 2011 and locate help for the following problem:
“Word can't find a linked file”
Provide a link to the page and screenshots of the solution.
8) Find the OFFICIAL online support website for Adobe Photoshop and locate help for the following problem:
“How to reset a tool if not working properly”
Provide a link to the page and screenshots of the solution.
9) Locate a training manual or booklet (not a website) for a software package or operating system of your choice.
Place the link where this can be downloaded from and explain how it can be used to solve a particular problem.
You must provide screen shots of relevant sections to support your description.
10) Locate a reputable support forum for a piece of software that you use regularly. You must sign-up and post a question that would help you trouble-shoot or solve a typical problem.
You must provide screen shots WITH DESCRIPTIONS as evidence.
11) Using the table below, you must demonstrate AND EXPLAIN how you have used three computer applications. For each one you should summarise the advanced features you have used to achieve the following:
• Import & Export materials or data
• Maintained an efficient and productive workflow
You must provide screen shots WITH DESCRIPTIONS as evidence.
Software How you used advanced features for importing/exporting/efficiency

12) If you needed to locate the OFFLINE help file within Microsoft Word, where can this be found?
You must provide screen shots WITH DESCRIPTIONS as evidence.
12) If you needed to locate the OFFLINE help file within Microsoft Word, where can this be found?
You must provide screen shots WITH DESCRIPTIONS as evidence.
13) Outline the basic features and functions of the Windows Operating System software and describe at least three advanced system tools that are included.
Basic features of Windows –
Advanced system tool one -
Advanced system tool two -
Advanced system tool three -