Evaluation Short Module title: Productiveness and Collaboration Instruments for Learning and Work
Module code: COM4016
Assignment title: Portfolio of Initiatives
Assignment format: Microsoft Note, Microsoft Excel and Microsoft PowerPoint
Note/time restrict: 3000 words
File form: Microsoft Note, Microsoft Excel and Microsoft PowerPoint
Percentage of closing grade: This project is price 100% of your closing grade for this module.
Submission closing date: Gape module iLearn page for date of submission
Grade release: You are going to customarily discover your provisional grade and feedback within 20 working days of the submission closing date
Activity abstract: That you simply may maybe furthermore be pleased joined the technical toughen crew at a shrimp firm (100 workers) with plans for snappy growth. The company has been overly reliant on paper- essentially essentially based techniques so a ways. There are a core crew of workers who’re IT literate, nevertheless the majority of workers has distinguished gaps of their abilities and files of some powerful advantages of productivity tools.
You are going to first prepare a file for the staff of the company the exercise of Microsoft Note. Then you positively will most doubtless be requested to analyse some knowledge the exercise of Microsoft Excel. One draw or the other, you will construct a Microsoft PowerPoint presentation for managers of the company.
Assignment instructions: You more than doubtless will most doubtless be required to total 3 initiatives for this Assignment. Your submission must consist of three separate recordsdata, each named together with your student amount, for the three initiatives respectively as follows:
Note file (.docx) for Activity 1 Excel file (.xlsx) for Activity 2
PowerPoint Presentation file (.pptx) for Activity 3
Alternatively, submissions in Commence Doc Layout, i.e. .odt, .ods and .odp for Activity 1, 2 and 3 respectively, are also permitted, nevertheless students are warned that tutors and markers are NOT to blame for any compatibility concerns. Interoperability is of public stammer nevertheless out of the scope of this evaluate.
Native Microsoft file codecs are peaceable beneficial for the motive of this evaluate.
DO NOT zip or compress your recordsdata in any system. The submission portal will support you put up a few recordsdata.
WARNING! Submission no longer within the upright file codecs said above will result in ZERO (0) marks given.
Activity 1 Put together a file for the staff of the company explaining some powerful advantages of the exercise of Microsoft productivity tools and the need for the relevant abilities expected of working professionals besides to varsity or college graduates discovering jobs. Enhance your functions with reference to relevant literature.
Exhaust Microsoft Note to receive your file, the exercise of relevant functions of the appliance to format and recent your writing similar to Table of Contents (TOC) with auto Page Numbers, Headings, Tables, and Figures. Be clear appropriate References are created the exercise of Arden College Harvard Referencing. The file wants to be error free.
[900 Words]
[30 marks]
(LO’s 1-4)
Activity 2 Having defined some powerful advantages of the exercise of productivity tools, you may maybe well presumably furthermore had been requested to analyse some gross sales knowledge held by the company. This knowledge will most doubtless be distinctive to you (supplied by Tutor by the quit of Week 4) and may maybe presumably no longer be similar to any of your fellow students. This knowledge is never any longer in an without trouble usable format for prognosis, comprising a collection of pages. In complete there are distinguished functions of 20 gross sales.
The usage of Microsoft Excel, construct a spreadsheet that items this knowledge. You could peaceable utilise the functions of Excel that support you up-to-date the records in a logical and accessible system e.g. neatly formatted text and numbers (where appropriate formatted as foreign money as an instance), exercise of headings, appropriate column widths, neatly named worksheets (tabs).
Produce calculations on the records and recent the corresponding outcomes as follows: Add a brand new column called Earnings and calculate the profit on each sale.
The administration is continually drawn to what the profit would had been if the selling designate of every product had been increased by 10%. Construct a brand new column called Predicted Earnings 10% and calculate for each sale the profit that would had been generated if this construct bigger had been made.
Calculate the full profit generated across all gross sales. Space, format and designate the records precisely.
Exhaust the COUNTIF characteristic to figure out the amount of instances of London district on your knowledge. Space and designate the records precisely.
Exhaust the COUNTIF characteristic to figure out the amount of instances of Envelopes product on your knowledge. Space and designate the records precisely.
Including columns or performing calculations which are no longer described above are thought about pointless and may maybe furthermore result in designate penalty. Tubby marks may maybe presumably no longer be given for formulas which are upright nevertheless are no longer at their easiest in phrases of effectivity, scalability, compactness and readability.
Construct and format charts for each of the following in new worksheets (tabs) within the same file:
Sum of quantities supplied per salesperson Sum of quantities supplied per district
Sum of quantities supplied per product
Name each tab to describe which chart it holds. The guidelines required to generate the charts wants to be worked out the exercise of Pivot Tables and is also shown on the same worksheet because the ensuing chart.
Level to that the utmost observe depend for this job is 1200 words similar, which system that the amount of labor and time required to total this job wants to be similar to that of manufacturing a 1200-observe tutorial file. The literal observe depend itself is beside the level.
[1200 Words Equivalent]
[40 marks]
(LO’s 2-4)
Activity 3 Construct a Microsoft PowerPoint presentation for managers of the company to facilitate change resolution making. First, the charts you may maybe well presumably furthermore be pleased created in Activity 2 wants to be included. Moreover, gross sales performance in phrases of profit is of even higher stammer to the managers, so some extra charts exhibiting the ideal/worst performing products, salespersons and districts, all in phrases of profit, are required. You would possibly want to make exercise of comparable charting abilities you demonstrated in Activity 2 to construct these charts and consist of them on your presentation. (These extra charts are no longer required in Activity 2 so you may maybe well presumably be beneficial to construct a reproduction of the Excel file for Activity 2 and construct them within the reproduction to keep remote from affecting Activity 2.) It suffices to consist of your charts created in Excel as photos in PowerPoint.
Within the presentation, consist of voice material that explains each of the charts to provide insights such that the managers can take into fable what decisions they must construct. In complete, including a title shuffle and a abstract shuffle, it is distinguished to peaceable just for no no longer as a lot as 8 slides. You could peaceable describe your ability to make exercise of functions of the appliance that support you retain in touch successfully with the intended target audience. Due consideration wants to be given to make exercise of of shuffle receive, exercise of coloration, typefaces, media parts and many others.
Level to that the utmost observe depend for this job is 900 words similar, which system that the amount of labor and time required to total this job wants to be similar to that of manufacturing a 900-observe tutorial file. The literal observe depend itself is beside the level.
[900 Words Equivalent]
[30 marks]
(LO’s 2-4)
Learning outcomes (LO) By winding up this evaluate, you may maybe well presumably furthermore be pleased shown and be assessed on all four of the educational outcomes:
Title the most distinguished functions of overall tools dispute in studying and procedure of business settings that will pork up productivity e.g. observe processing, spreadsheets, presentation tools and collaborative tools.
Title the correct tools to make exercise of to unravel particular concerns e.g. analysing knowledge, making a gross sales pitch or presenting findings
Originate competence within the exercise of a fluctuate of tools that will most doubtless be extinct to toughen peep and procedure of business abilities and pork up employability.
Effective Verbal change: Keep in touch successfully each, verbally and in writing, the exercise of a fluctuate of
media widely extinct in relevant legitimate context. Be IT, digitally and info 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.
