Office Application Packages - Assignment Example

Details of Assessment Term and Year Time allowed N/A Assessment No 3 Assessment Weighting 25% Assessment Type Written/Observation Due Date Week 8 Room Details of Subject Qualification ICA20111Certificate II in Information, Digital Media and Technology Subject Name Office Application Packages Part A Details of Unit(s) of competency Unit Code ICAICT203A Operate application software packages ICAICT205A Design basic organisational documents using computing packages Details of Student Student Name College Student ID Student Declaration: I declare that the work submitted is my own, and has not been copied or plagiarised from any person or source. Signature: ___________________________ Date: _______/________/_______________ Details of Assessor Assessor’s Name Assessment Outcome Results Satisfactory Not Satisfactory Marks FEEDBACK TO STUDENT Progressive feedback to students, identifying gaps in competency and comments on positive improvements: ________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________ Student Declaration: I declare that I have been assessed in this unit, and I have been advised of my result. I also am aware of my appeal rights and reassessment procedure. Signature: ____________________________ Date: ____/_____/_____ Assessor Declaration: I declare that I have conducted a fair, valid, reliable and flexible assessment with this student, and I have provided appropriate feedback Student did not attend the feedback session. Feedback provided on assessment. Signature: ____________________________ Date: ____/_____/_____ Part A – Written Task 1 (2 Marks) a. Explain how the use of the following can assist with the creation of workplace templates: 1. Styles: when creating a template, the designer applies styles that he wants all the documents based on the template to have. 2. Electronic Forms: they provide a layout which guides in entering data to complete a document 3. Slide Masters: they are used in Microsoft PowerPoint to store slide layout, style and themes of a presentation (Microsoft Office). Therefore, once used as a template, they help in making presentations based on the desired layout, theme and style. b. Outline the approval processes required before template can be created and stored within your workplace. Firstly, the person creating the template presents the proposal to the IT manager alongside the design brief. The IT manager goes through the proposal and if worthwhile, he approves it giving the designer the go ahead to make the template. Once the template is done, it is sent to the IT manager who reviews it, tests it and if satisfactory, he approves it allowing the designer to save it. Part B – Scenario/Observation Task 1 (3 Marks) a. In at least three different software applications, create templates/slide masters that can be used to meet documentation or other requirements within your workplace. You can use Ms Word, Ms Excel, Ns PowerPoint as they are the widely used software applications b. Save templates/slide masters to your assessment folder. c. Document the design requirements followed in the creation of the templates (corporate fonts, colours, etc). d. Create an instruction sheet how to use the templates/slide masters for creating documents. e. Access the templates/slide masters built above and create two documents from each. Ms Word Template A new document was opened. In the header, the company’s logo and addresses were inserted after which the title section of the memo was designed and formatted. Page layout was set to 2.5 cm all round and the document saved as a template Ms Excel The template is for managing work. Each supervisor is supposed to create a document using this template which he/she can use to manage his/or her employees’ work by entering the title of the work, name of assigned employee and expected completion date. Using this information, a function created will calculate time remaining to the deadline. A blank excel document was opened and saved as a template named Work Management Sheet. Guiding information was the entered showing where employees will enter data. The function, =IF(E116="Completed","N/A",TEXT(D116-NOW(),"d:h:mm")), was entered for calculating time remaining. If the work has been completed, the answer is N/A. Format was applied and the document saved. Ms PowerPoint A blank PowerPoint presentation was opened. On the View Tab and under the Master Views group, Slide Master was clicked, which opened some layouts. The best layout was selected, changes made to it and then saved as a template known as Presentations. Task 2 (5 Marks) a. Create a new workbook and name it StudentName_StudentID_Assessment 3.xlsx. and enter the following information: c. Save the spreadsheet as Home Budget.xlsx c. Utilise various formatting tools to format the spreadsheet as follows: d. On the spreadsheet, perform the following: 1. Use an addition formula in cell B7 to add the income totals in column B Use the Fill Handle to complete the same formula in columns C and D 2. Use the Autosum function to add the Expense totals in column B Use the Fill Handle to complete the same function in columns C and D 3. Use a subtraction formula to calculate the Net total in cell B15 Use the Fill Handle to complete the same formula in columns C and D 4. Use a multiplication formula to calculate a savings amount of 25% of the Net amount in Cell B16 5. Use the Fill Handle to complete the same formula in columns C and D 6. Use a subtraction formula to calculate the Spending total in cell B18 7. Explain to your supervisor/assessor how you would notice and rectify any formula errors discovered Errors are associated with error messages, which have a flag at the side of the cell containing the error. By pointing this flag, the reason for error is displayed, which can then be used to rectify the error. 8. Adjust the width of columns B, C & D to a column measurement of 12 9. Bold the Spending totals in Row 18 by copying the bold format from cell A3. 10. Insert a header with your name in the left tab and your company name in the right tab 11. Insert a footer with the date on the left tab and the subject name in the right tab 12. Save the spreadsheet as an HTML file 13. Print Home Budget.xlsx in landscape layout and attach to this assessment tool as evidence Attached. Task 3 (8 Marks) 1. Create a new worksheet and name it live weight. Enter below data. 2. Format sheet accordingly and use AutoFill to create the sequential numbers in column A 3. Now calculate the Actual Weight of product in column D by using Absolute Cell Referencing 4. Create a new worksheet and name it Wendys. Enter below data. a. Use the columns computer and No.Sold to create a 3D pie chart b. Display percentages in the pie chart 5. Create a new worksheet and name it Fat Freddie. Enter below data. a. Apply AutoFilter to display stores with sales greater than $3 million. Turn off AutoFilter once done b. Sort the database in ascending order by state, then by city c. Apply automatic subtotals to the sorted database so that sum of 200sales is displayed for every change in state. Your sheet should appear as: Task 4 (5 Marks) 1. Create a new worksheet Task4 in the Workbook " StudentName_StudentID_Assessment 3.xlsx. " enter the following data. The following worksheet displays car rental details for Con's Car Rentals 2. Enter formulas to calculate Days Rented Kilometres Travelled Rental Fee Total rental Fees Rental fee is calculation based on days rented and kilometres travelled Rental Fee =($20 x Days rented)+(Kilometres Travelled x Car Category rate) Hint: You could either use VLOOKUP or IF function to insert the car category rate. Attached You must submit: Submission: (2 Marks) Create a Folder with name StudentName_StudentID_Assessment 3. All answers from Part A will be saved in a word document named Answers.docx Save Answers.docx, StudentName_StudentID_Assessment 3.xlsx in a folder name: StudentName_StudentID_Assessment 3. Ask for feedback from your trainer and modify document accordingly. Print all documents from part A and attach it to your assessment as evidence Submit soft copies and hard copy. Works Cited Microsoft Office. What is a Slide Master? 2015. Web. July 30, 2015 Read More