Order 1076349: Read Instructions

Item

Total Points

Possible

Required Elements Presented

(See points below per element)

Elements logically

applied; adds value

to the application

(Does the element

solve a business

problem?)

Consistency of element

formatting (including

number formatting)

Thorough

explanation of

purpose for

elements are

defined on the

documentation

sheet for users

Total

Points

Earned

Documentation sheet with

justification and hyperlinks to an

element and back to the Doc

sheet

10

Use doc sheet template provided by

instructor

-Fill in all fields for name, purpose

and date (5 points)

-provide locations of all functions (5

points)

Worksheet data

10

Data must have multiple data types

with a minimum of :

Two different worksheets of data (4

points)

At least one text type (3 points)

At least one numeric or currency type

(3 points)

Formatting of worksheet data

10

Number or currency

must have consistent

decimal places

(5 points)

A consistent formatting

theme must be used

throughout the workbook

(5 points)

Formulas & functions

25

Minimum of 3 required formulas or

functions (6 points)

AND

1 required IF function (may be a

conditional IF) (5 points)

IF Function must

provide value to the

application

(5 points)

All results must be

appropriately formatted

(currency should be 2 or

0 decimals)

(4 points)

If function

explanation must

be defined on

the doc sheet (5

points)

Filtered list

10

A filter must be applied to a column

of the worksheet data

(3 points)

This filter must

answer a business

question (2 points)

Explanation on

doc sheet should

define the

purpose of the

filter (5 points)

Conditional Formatting

10

The conditional format must be

applied to a column of the worksheet

data (3 points)

This conditional

format must answer

a business question

(2 points)

Explanation on

doc sheet should

define the

purpose of the

format (5

points)

Chart 1

10 Chart created (2.5 points)

Appropriate chart

has elements that

will define the data

(legend or data

labels, proper title,

axis labels, etc)

(2.5 points)

All elements will be

formatted attractively

and in colors that allow

easily readable data

(2.5 points)

Doc sheet

explains the

chart's purpose

and data being

analyzed

(2.5 points)

Chart 2

10 Chart created (2.5 points)

Appropriate chart

has elements that

will define the data

(legend or data

labels, proper title,

axis labels, etc)

(2.5 points)

All elements will be

formatted attractively

and in colors that allow

easily readable data (2.5

points)

Doc sheet

explains the

chart's purpose

and data being

analyzed

(2.5 points)

Lookup table and lookup

function

15

Vlookup or Hlookup function used

from either already provided data or

additional data (5 points)

Function provides a

solution (5 points)

Explanation of

purpose (5

points)

Data validation and error

message

12

Data validation Settings and

corresponding error message setup (2

points)

The data validation

application works

and is not applied to

a formula cell

(5 points)

All necessary cells have

the same data validation

(full column if

necessary) (2 points)

Doc sheet has

purpose

explained

(3 points)

Pivot Table with Pivotchart

23

Pivot table added (5 points)

PivotChart added (3 points)

Does the pivot table

present data in a new

way that adds value?

(5 points)

All necessary data is

attractively formatted

(titles added, colors

complement

spreadsheet, proper

number formatting)

(5 points)

Pivot Table and

Pivot Chart are

properly

documented and

defined on doc

sheet (5 points)

Pick one of the following

Student Chooses: 15

One Variable Data Table

Table created (5 points)

Does the data table

presented data in a

way that adds value?

(4 points)

Numbers are formatted

and table is attractively

formatted (2 points)

Table purpose

explained on doc

sheet (4 points)

Goal-seek

Goal seek created and print screen

provided to show the function in

action (5 points)

Does the goal-seek

solve a business

problem adequately?

(5 points)

Explanation and

purpose of goal

seek; define why

goal seek and

not another

application such

as scenarios

(5 points)

Pick two of the following

Student chooses:

[20 pts each] 40

Macro macro implemented with button

and/or shortcut--check code

(5 points)

macro runs correctly (5 points)

Does it add value? (5

points)

Explanation of

purpose defined

(5 points)

Two Variable Data Table

Table created (5 points)

Does the data table

presented data in a

way that adds value?

(5 points)

Numbers are formatted

and table is attractively

formatted (5 points)

Table purpose

explained on doc

sheet (5 points)

Scenario manager

Scenarios and scenario summary

created--minimum of 2 scenarios

created (5 points)

Do the scenarios add

value and solve a

business problem? (5

points)

Numbers formatted

appropriately and all cell

references named on

report (5 points)

Scenario

purpose defined

on doc sheet (5

points)

Solver

Solver implemented (4 points)

answer report provided (4 points)

minimum of one constraint applied (4

points)

Does the solver app

add value and solve

a business problem?

(4 points)

Solver purpose

defined on doc

sheet (4 points)

Total 200 0

0.00%

Final Total Score

Total Percentage