computer+RPL+ACTIVITIES

to provide evidence for RPL complete the following tasks in class. Inform your lecturer that you wish to apply for RPL prior to starting task. No USB, shared drive or email to be active during task. That is you must complete the task in class and within given time frame.

1. create a table of class or family birthdays merge the top row and include a title - auotsort the table in ascending order & format correctly - include a header & footer with file name & path

2. Proof read & edit the attached link Gifts to Britain - format correctly - include a watermark & graphic - include a header & footer with file name & path - note you will need to be familar with tabs, dot leaders, hanging indents, bullerts & numbering to complete the task Cert 3 include an appropriate watermark & title using word art

see sample evidence for ideas in Teachers drive

3. the attached link to a memo has the writing in a block text that is difficult to read Annual Sales Meeting - set out the memo so that it is clear & easy to read - include a header & footer with file name & path

see sample evidence for ideas in Teachers drive

4. Correct & format the attached newsletter Dawsons Garden Centre roses Cert 3 complete the task in columns -include a header & footer with file name & path see sample evidence for ideas in Teachers drive

or

4. Correct & format the attached newsletter Paris in the late 19th Century

5. Correct the mistakes in the attached newsletter Electrical Supplies - format the heading to stand out - include an appropriate graphic next to the heading - change the size & font of address & position correctly - use bullets to make it easier to read - include the client's address & auto date - include a header & footer with file name & path see sample evidence for ideas in Teachers drive

6. Cert 3 only Morton Wines - correct the attached bulletin - format correctly as a bulletin - include a watermark, lines to segment sections, address etc - include a header & footer with file name & path see sample evidence for ideas in Teachers drive

7. Create a folder for your work named approriately

8. Create a contents page for your portfolio

9. Cert 3 Create a simple line graph & bar graph from your Statistics report Or from the data provided create a pie chart
 * **Mercury Superannuation Funds ** ||
 * **Portfolio** || **% ** ||
 * Australian shares || 30 ||
 * International shares || 20 ||
 * Liquid assets || 5 ||
 * Property shares || 15 ||
 * Australian fixed interest deposits || 15 ||
 * International fixed interest holdings || 15 ||

AND create a line graph & bar graph from the following data construct a one- line graph and a one column graph from the table. The figures represent Flower Corporation's annual profit and share prices over 6 years. Show the profit against time as a line graph and a share price for each year as a series of columns. Use years as a scale on the Horizontal axis and A$ million on the left as a vertical axis & $share price on the right hand axis. TIPS: you will need to select the appropriate columns for each graph and toggle through different styles until you find a style that includes text boxes to name graph & axis


 * **Year ** || **Profit (A$) million** || **Share price ($) ** ||
 * 2007 || 185 || 1.80 ||
 * 2008 || 220 || 3.40 ||
 * 2009 || 315 || 5.00 ||
 * 2010 || 375 || 6.00 ||
 * 2011 || 410 || 7.80 ||
 * 2012 || 580 || 9.50 ||

10. Create a 5 slide powerpoint to present. your choice of topic eg from a R&W or maths unit or favorite band etc - include a reference slide - graphics & animation - notes pages - follow the conventions of a powerpoint presentation