Evaluation Transient Module title:\u00a0Productivity and Collaboration Tools for Studying and Work<\/p>\n
Module code:\u00a0COM4016<\/p>\n
Assignment title:\u00a0Portfolio of Tasks<\/p>\n
Assignment layout:\u00a0Microsoft Word, Microsoft Excel and Microsoft PowerPoint<\/p>\n
Word\/closing date:\u00a03000 phrases<\/p>\n
File kind:\u00a0Microsoft Word, Microsoft Excel and Microsoft PowerPoint<\/p>\n
Percentage of closing grade:\u00a0This project is worth 100% of your closing grade for this module.<\/p>\n
Submission lower-off date:\u00a0Spy module iLearn internet page for date of submission<\/p>\n
Grade launch:\u00a0You are going to principally receive your provisional grade and suggestions inside 20 working days of the submission lower-off date<\/p>\n
Activity summary: You would possibly internet joined the technical reinforce group at a little firm (100 workers) with plans for hasty growth. The firm has been overly reliant on paper- primarily primarily based fully programs in the past. There are a core workforce who are IT literate, but the majority of workers has vital gaps in their abilities and knowledge of the advantages of productivity instruments.<\/p>\n
You are going to first prepare a epic for the workers of the firm utilizing Microsoft Word. Then that that you just can well be asked to analyse some records utilizing Microsoft Excel. At final, that that you just can well fetch a Microsoft PowerPoint presentation for managers of the firm.<\/p>\n
Assignment directions: You are required to total 3 responsibilities for this Assignment. Your submission must consist of three separate recordsdata, every named together with your student number, for the 3 responsibilities respectively as follows:<\/p>\n
Word file (.docx) for Activity 1 Excel file (.xlsx) for Activity 2<\/p>\n
PowerPoint Presentation file (.pptx) for Activity 3<\/p>\n
Alternatively, submissions in Originate File Structure, i.e. .odt, .ods and .odp for Activity 1, 2 and 3 respectively, are furthermore accredited, but college students are warned that tutors and markers are NOT to blame for any compatibility concerns. Interoperability is of public disclose but out of the scope of this evaluation.<\/p>\n
Native Microsoft file formats are aloof urged for the aim of this evaluation.<\/p>\n
DO NOT zip or compress your recordsdata in any capacity. The submission portal will will let you put up a pair of recordsdata.<\/p>\n
WARNING! Submission no longer in the excellent file formats mentioned above will end result in ZERO (0) marks given.<\/p>\n
Activity 1 Prepare a epic for the workers of the firm explaining the advantages of utilizing Microsoft productivity instruments and the want for the relevant abilities anticipated of working professionals as smartly as college or faculty graduates discovering jobs. Beef up your points on the subject of relevant literature.<\/p>\n
Use Microsoft Word to tag your epic, utilizing relevant aspects of the software to layout and latest your writing similar to Desk of Contents (TOC) with auto Online page Numbers, Headings, Tables, and Figures. Blueprint determined that appropriate References are created utilizing Arden University Harvard Referencing. The epic might possibly per chance well aloof be error free.<\/p>\n
[900 Words]<\/p>\n
[30 marks]<\/p>\n
(LO\u2019s 1-4)<\/p>\n
Activity 2 Having defined the advantages of utilizing productivity instruments, you were asked to analyse some gross sales records held by the firm. This knowledge shall be tantalizing to you (supplied by Tutor by the end of Week 4) and might possibly per chance well no longer be the linked as any of your fellow college students. This knowledge isn’t any longer in an without misfortune usable layout for diagnosis, comprising a chain of pages. In total there are little print of 20 gross sales.<\/p>\n
The exhaust of Microsoft Excel, fetch a spreadsheet that provides this recordsdata. You are going to aloof utilise the aspects of Excel that might possibly will let you latest the records in a logical and accessible capacity e.g. effectively formatted textual exclaim and numbers (where appropriate formatted as currency let’s sigh), exhaust of headings, appropriate column widths, effectively named worksheets (tabs).<\/p>\n
Produce calculations on the records and latest the corresponding outcomes as follows: Add a fresh column known as Earnings and calculate the profit on every sale.<\/p>\n
The administration is regularly drawn to what the profit would were if the selling impress of every product had been elevated by 10%. Influence a fresh column known as Predicted Earnings 10% and calculate for every sale the profit that might possibly per chance well were generated if this boost had been made.<\/p>\n
Calculate the total profit generated all the plan in which through all gross sales. Situation, layout and designate the records because it can well be.<\/p>\n
Use the COUNTIF honest to determine the alternative of cases of London district in your records. Situation and designate the records because it can well be.<\/p>\n
Use the COUNTIF honest to determine the alternative of cases of Envelopes product in your records.\u00a0 Situation and designate the records because it can well be.<\/p>\n
Adding columns or performing calculations that are no longer described above are notion to be pointless and might possibly per chance well end result in designate penalty. Fleshy marks might possibly per chance well no longer be given for formulas that are correct but are no longer at their easiest by the utilization of efficiency, scalability, compactness and readability.<\/p>\n
Influence and layout charts for every of the following in fresh worksheets (tabs) inside the linked file:<\/p>\n
Sum of portions sold per salesperson Sum of portions sold per district<\/p>\n
Sum of portions sold per product<\/p>\n
Name every tab to impress which chart it holds.\u00a0 The records required to generate the charts might possibly per chance well aloof be labored out utilizing Pivot Tables and might possibly per chance well also be shown on the linked worksheet as the resulting chart.<\/p>\n
Label that the maximum note count for this assignment is 1200 phrases an identical, meaning that the amount of labor and time required to total this assignment might possibly per chance well aloof be a a lot like that of manufacturing a 1200-note tutorial epic. The literal note count itself is irrelevant.<\/p>\n
[1200 Words Equivalent]<\/p>\n
[40 marks]<\/p>\n
(LO\u2019s 2-4)<\/p>\n
Activity 3 Influence a Microsoft PowerPoint presentation for managers of the firm to facilitate commerce determination making. First, the charts you internet created in Activity 2 might possibly per chance well aloof be incorporated. Moreover, gross sales performance by the utilization of profit is of even greater disclose to the managers, so some extra charts exhibiting the very best\/worst performing products, salespersons and districts, all by the utilization of profit, are required. You are going to favor to exhaust an identical charting abilities you demonstrated in Activity 2 to fetch these charts and consist of them in your presentation. (These extra charts are no longer required in Activity 2 so that you just are suggested to fetch a reproduction of the Excel file for Activity 2 and fetch them in the reproduction to manual clear of affecting Activity 2.) It suffices to incorporate your charts created in Excel as photos in PowerPoint.<\/p>\n
Within the presentation, consist of exclaim that explains every of the charts to produce insights such that the managers can preserve in thoughts what choices they favor to fetch. In total, together with a title plug and a summary plug, that that you just can well aloof aim for no longer lower than 8 slides. You are going to aloof point to your ability to exhaust aspects of the software that enable you to talk effectively with the supposed audience. Due consideration might possibly per chance well aloof be given to exhaust of plug construct, exhaust of colour, typefaces, media points etc.<\/p>\n
Label that the maximum note count for this assignment is 900 phrases an identical, meaning that the amount of labor and time required to total this assignment might possibly per chance well aloof be a a lot like that of manufacturing a 900-note tutorial epic. The literal note count itself is irrelevant.<\/p>\n
[900 Words Equivalent]<\/p>\n
[30 marks]<\/p>\n
(LO\u2019s 2-4)<\/p>\n
Studying outcomes (LO) By ending this evaluation, you internet shown and be assessed on all\u00a0four of the training outcomes:<\/p>\n
Name the key aspects of usual instruments interpret in discovering out and place of work settings that can toughen productivity e.g. note processing, spreadsheets, presentation instruments and collaborative instruments.<\/p>\n
Name the suitable instruments to exhaust to remedy enlighten complications e.g. analysing records, making a gross sales pitch or presenting findings<\/p>\n
Build competence in utilizing a unfold of instruments that might possibly per chance well also be musty to bolster gape and place of work abilities and toughen employability.<\/p>\n
Effective Communication: Talk effectively every, verbally and in writing, utilizing a unfold of<\/p>\n
media extensively musty in relevant expert context. Be IT, digitally and knowledge literate<\/p>\n","protected":false},"excerpt":{"rendered":"
Evaluation Transient Module title:\u00a0Productivity and Collaboration Tools for Studying and Work Module code:\u00a0COM4016 Assignment title:\u00a0Portfolio of Tasks Assignment layout:\u00a0Microsoft Word, Microsoft Excel and Microsoft PowerPoint Word\/closing date:\u00a03000 phrases File kind:\u00a0Microsoft Word, Microsoft Excel and Microsoft PowerPoint Percentage of closing grade:\u00a0This project is worth 100% of your closing grade for this module. Submission lower-off date:\u00a0Spy module […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-31349","post","type-post","status-publish","format-standard","hentry","category-solutions"],"_links":{"self":[{"href":"https:\/\/academicwritersbay.com\/solutions\/wp-json\/wp\/v2\/posts\/31349","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/academicwritersbay.com\/solutions\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/academicwritersbay.com\/solutions\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/academicwritersbay.com\/solutions\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/academicwritersbay.com\/solutions\/wp-json\/wp\/v2\/comments?post=31349"}],"version-history":[{"count":0,"href":"https:\/\/academicwritersbay.com\/solutions\/wp-json\/wp\/v2\/posts\/31349\/revisions"}],"wp:attachment":[{"href":"https:\/\/academicwritersbay.com\/solutions\/wp-json\/wp\/v2\/media?parent=31349"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/academicwritersbay.com\/solutions\/wp-json\/wp\/v2\/categories?post=31349"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/academicwritersbay.com\/solutions\/wp-json\/wp\/v2\/tags?post=31349"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}