This
Assignment MUST be completed in Pairs or Threesome’s. No Individual Assignments accepted (0%.) LATE assignments (after Dec. 6th class) will NOT
be accepted (0%).
You will prepare an Excel 2016 Workbook and related PowerPoint
2016 Document for an existing or fictional Organization of your choice presenting
Company information and statistics such as any of the following:
·
Inventory
data
·
human
resource data – employee related (salary, retention, benefits, performance …)
·
sales
and revenue data
·
budget
data
·
financial
analysis and forecasting data
Refer
to Company Websites, Financial Reports, SAM Projects, Library or Excel Textbook
etc. for examples. Both your documents must be created from scratch.
Your documents
must be submitted both electronically (via Blackboard email) AND in printed
form as outlined below.
Requirements:
Consistency across Excel
& PowerPoint Documents
·
use
the same Theme for both documents (2
marks)
·
consistent
content, organization, positioning and formatting across both documents (5 marks)
o they look clean, professional and uncluttered
Higher Marks for proper use and presentation/explanation of one or more
of the following (up to 5 marks):
·
What-If
Analysis (Goal Seek)
·
3d
References
·
Functioning
Data Table(s)
·
Amortization
Table(s)
·
Named
Reference Formulae
Excel
2016 Workbook:
·
include
at least two Tables (1 mark)
o on separate sheets presenting different information (1 mark)
o properly formatted, labeled and titled (2 marks)
o a non-default Table Style is applied to each (2 marks)
·
include
at least two different types of Charts (2
marks)
o on separate sheets presenting different information (1 mark)
o properly formatted, labeled and titled (2 mark)
o a non-default Chart Style is applied to each (1 mark)
·
use of
proper Cell Styles and Borders (4 marks)
·
use of
Structured (Named) References where appropriate (2 marks)
·
include
at least three different AutoFunctions in your tables (Sum, Average, Min, etc.)
(3 marks)
·
includes
at least three, different, hand-written Formulae of at least intermediate
complexity in your tables (6 marks)
o formulas should display
§ complex calculations using multiple operations and
parentheses and/or
§ non-AutoFunction Formulae (If, PMT, FV, Match, CountIf, etc.)
·
make
sure that Formulae and other information is properly produced in Series by
using the Fill Handle (2 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 (2 marks)
·
print
your Tables and Charts in a small booklet
o print on both sides of the page (1 mark)
o use the most appropriate page orientation(s) (portrait or
landscape) for easy reading (1 mark)
o set proper Print Areas to fit your tables and charts neatly,
and not too small to read (1 mark)
o in the printed headers, include the project title with the
name of the organization (1 mark)
o in the printed footers, include your names, your titles, date
and the correct page numbers (2 marks)
Get Free Quote!
376 Experts Online