Evaluation Transient Module title: Productivity and Collaboration Tools for Studying and Work
Module code: COM4016
Assignment title: Portfolio of Tasks
Assignment layout: Microsoft Word, Microsoft Excel and Microsoft PowerPoint
Word/closing date: 3000 phrases
File kind: Microsoft Word, Microsoft Excel and Microsoft PowerPoint
Percentage of closing grade: This project is worth 100% of your closing grade for this module.
Submission lower-off date: Spy module iLearn internet page for date of submission
Grade launch: You are going to principally receive your provisional grade and suggestions inside 20 working days of the submission lower-off date
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.
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.
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:
Word file (.docx) for Activity 1 Excel file (.xlsx) for Activity 2
PowerPoint Presentation file (.pptx) for Activity 3
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.
Native Microsoft file formats are aloof urged for the aim of this evaluation.
DO NOT zip or compress your recordsdata in any capacity. The submission portal will will let you put up a pair of recordsdata.
WARNING! Submission no longer in the excellent file formats mentioned above will end result in ZERO (0) marks given.
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.
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.
[900 Words]
[30 marks]
(LO’s 1-4)
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.
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).
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.
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.
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.
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.
Use the COUNTIF honest to determine the alternative of cases of Envelopes product in your records. Situation and designate the records because it can well be.
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.
Influence and layout charts for every of the following in fresh worksheets (tabs) inside the linked file:
Sum of portions sold per salesperson Sum of portions sold per district
Sum of portions sold per product
Name every tab to impress which chart it holds. 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.
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.
[1200 Words Equivalent]
[40 marks]
(LO’s 2-4)
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.
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.
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.
[900 Words Equivalent]
[30 marks]
(LO’s 2-4)
Studying outcomes (LO) By ending this evaluation, you internet shown and be assessed on all four of the training outcomes:
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.
Name the suitable instruments to exhaust to remedy enlighten complications e.g. analysing records, making a gross sales pitch or presenting findings
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.
Effective Communication: Talk effectively every, verbally and in writing, utilizing a unfold of
media extensively musty in relevant expert context. Be IT, digitally and knowledge literate
- WE OFFER THE BEST CUSTOM PAPER WRITING SERVICES. WE HAVE DONE THIS QUESTION BEFORE, WE CAN ALSO DO IT FOR YOU.
- Assignment status: Already Solved By Our Experts
- (USA, AUS, UK & CA PhD. Writers)
- CLICK HERE TO GET A PROFESSIONAL WRITER TO WORK ON THIS PAPER AND OTHER SIMILAR PAPERS, GET A NON PLAGIARIZED PAPER FROM OUR EXPERTS
QUALITY: 100% ORIGINAL PAPER – NO ChatGPT.NO PLAGIARISM – CUSTOM PAPER
Looking for unparalleled custom paper writing services? Our team of experienced professionals at AcademicWritersBay.com is here to provide you with top-notch assistance that caters to your unique needs.
We understand the importance of producing original, high-quality papers that reflect your personal voice and meet the rigorous standards of academia. That’s why we assure you that our work is completely plagiarism-free—we craft bespoke solutions tailored exclusively for you.
Why Choose AcademicWritersBay.com?
- Our papers are 100% original, custom-written from scratch.
- We’re here to support you around the clock, any day of the year.
- You’ll find our prices competitive and reasonable.
- We handle papers across all subjects, regardless of urgency or difficulty.
- Need a paper urgently? We can deliver within 6 hours!
- Relax with our on-time delivery commitment.
- We offer money-back and privacy guarantees to ensure your satisfaction and confidentiality.
- Benefit from unlimited amendments upon request to get the paper you envisioned.
- We pledge our dedication to meeting your expectations and achieving the grade you deserve.
Our Process: Getting started with us is as simple as can be. Here’s how to do it:
- Click on the “Place Your Order” tab at the top or the “Order Now” button at the bottom. You’ll be directed to our order form.
- Provide the specifics of your paper in the “PAPER DETAILS” section.
- Select your academic level, the deadline, and the required number of pages.
- Click on “CREATE ACCOUNT & SIGN IN” to provide your registration details, then “PROCEED TO CHECKOUT.”
- Follow the simple payment instructions and soon, our writers will be hard at work on your paper.
AcademicWritersBay.com is dedicated to expediting the writing process without compromising on quality. Our roster of writers boasts individuals with advanced degrees—Masters and PhDs—in a myriad of disciplines, ensuring that no matter the complexity or field of your assignment, we have the expertise to tackle it with finesse. Our quick turnover doesn’t mean rushed work; it means efficiency and priority handling, ensuring your deadlines are met with the excellence your academics demand.
