COMP1010 – Business Computer Applications 1 Assignment 2 (20% of final grade)
F20 Assignment 2 Page 1 of 2
This assignment may be completed in a groups of four or less. You will prepare an Excel Workbook and related PowerPoint Presentation for the data set given. Use the raw data to perform calculation and analysis that are appropriate to you.
The documents should be submitted electronically via D2L before deadline.
Requirements:
Consistency across Excel & PowerPoint Documents
use the same Theme for both documents (2 marks)
consistent content, organization, positioning and formatting across both documents (2 marks) they look clean, professional and uncluttered
Excel Document
Format the tables on each worksheets properly formatted, labeled and titled (2 marks)
a non-default Table Style is applied to each (2 marks)
all tables have same format (1 mark)
Calculate and fill the values in columns I and J on each worksheet by using formulas and functions (2 marks)
Analyze the raw data and summarize them on Sales Rep, Manufacturers, Payment, etc. (4 marks)
Present your findings/summary in at least two different types of Charts (2 marks) on separate sheets presenting different information (1 mark)
properly formatted, labeled and titled (2 marks)
a non-default Chart Style is applied to each (1 mark)
Use of proper Cell Styles and Borders (2 marks)
Use of Structured (Named) References where appropriate (2 marks)
Include at least three different types of AutoFunctions in your tables (Sum, Average, Min, etc.) (3 marks)
Includes at least three, different type of, hand-written Formulae of at least intermediate complexity in your tables (6 marks) formulas should display
W24 Assignment 2 Page 2 of 2
▪ complex calculations using multiple operations and parentheses
▪ non-AutoFunction Formulae (If, PMT, Round, VLookup, CountIf, etc.)
Design a Microsoft Power BI Dashboard that effectively displays your work for presentation purposes (focus on relevant data and key performance indicators (KPIs))
Make sure that Formulae and other information is properly produced and copied by using the Fill Handle (4 marks)
Use at least three different Number Formats (Accounting, Currency, Dates, etc.) correctly and consistently in your Tables (3 marks)
Use Conditional Formatting at least twice in your Tables (4 marks)
Connect the information in your spreadsheet to Microsoft Power BI (5 marks)
PowerPoint Document
Include at least 8 well-organized and Spell Checked Slides (not including the Title Slide) (2 marks)
Include an Agenda slide (1 mark)
Include a slide introducing the organization (The Spa Experts), yourselves and your positions (by Title ( ex. Vice President of Human Resources) (1 mark)
Include the organization’s logo (choose a picture from Internet) and at least three other Images with Picture Styles applied (3 marks)
Link your Excel Tables into your Slides (2 marks)
(Here is the instruction on how to link Excel tables and charts to PowerPoint https://www.powerusersoftwares.com/post/how-to-create-links-between-excel-and-powerpoint-or-word-for-your-charts-and-tables)
Link your Excel Charts into your Slides (2 marks)
Transitions appear between every Slide (1 mark)
Slide elements are Animated on at least three slides (2 marks)
Your names and your organization name should be included in the Slide Footer area (1 mark)
MARK /65 (worth 20% of Final Grade)