Check this page to get started, get help on individual techniques & compare your results: Excel Overview & Tips (U24)
and be sure be sure you are using the downloaded and installed version of Excel (free) from portal.office.com/home. Don’t use the online version for class projects.
By submitting this assignment, you confirm that this is all your own, individual work. No help from other individuals, collaborative or group work was involved in completing this assignment. Academic Integrity violations will result in a failing grade and be reported to the Muma College of Business .
Submission Instructions: Upload by clicking the ‘Submit Assignment’. Be sure you are uploading the file that ends with .xlsx or .xls.
To check your upload, look at the submission information on the right side of your screen and 1) download a copy a copy of your project FROM Canvas to another folder on your computer. 2) Open this copy, be sure it’s the right project, etc. and then 3) close / save this copy. This is your back up copy and the creation and last modified dates will be retained as long as it is unopened.
Rubric
Excel 2 Rubric (U24) Draft
Excel 2 Rubric (U24) Draft
Criteria Ratings Pts
This criterion is linked to a Learning OutcomeRubric Item #1: Project uploaded matches project instructions (or can’t be graded).
0 pts
Full Marks
0 pts
No Marks
0 pts
This criterion is linked to a Learning OutcomeRubric Item #2: 1) Workbook named correctly : WarnerBL_2EX.xlsx (additional numbers added by Canvas for resubmits are ok), 2) Worksheets named correctly and 3) in the right order = Lookup, Bicycle, Pivot 1-3, Filter 1-3
3 pts
Full Marks
0 pts
No Marks
3 pts
This criterion is linked to a Learning OutcomeRubric Item #3: Bicycle: Data – 1) copied & pasted , 2) sorted correctly – first row: C14 / Runkidder 100 – orig ~ YTD Sales Goal =200 , 3) Headings wrapped AND stay wrapped if column width increased, // No additional columns added (-3 if additional data added)
6 pts
Full Marks
3 pts
1 part missing / incorrect
0 pts
No Marks
6 pts
This criterion is linked to a Learning OutcomeRubric Item #4: Lookup Title – 1) name included , 2) merged and centered across all columns with data , 3) date in title (formula – date changes) , 4) border around title cell, background fill and font color (not black / dark blue) , 5) note or comment included with name and project start date
10 pts
Full Marks
8 pts
1 part missing / incorrect
6 pts
2 parts incorrect / missing
4 pts
3 parts incorrect / missing
2 pts
4 parts incorrect / missing
0 pts
No Marks
10 pts
This criterion is linked to a Learning OutcomeRubric Item #5: Input Area: – 1) Input cell formatted to stand out , 2) arrow ‘shape’ used , 3) arrow ‘shape’ not dark blue/black
3 pts
Full Marks
2 pts
1 part missing / incorrect
1 pts
2 parts incorrect / missing
0 pts
No Marks
3 pts
This criterion is linked to a Learning OutcomeRubric Item #6: 1) Lookup: Worksheet protected correctly, only Bike ID can be changed, 2) IFERROR works, test with C18: – displays ‘code not found’ type message in ONLY one cell and other cells blank, 3) IFERROR ‘ code not found’ displayed on the chart
9 pts
Full Marks
6 pts
1 part missing or incorrect
3 pts
2 parts incorrect / missing
0 pts
No Marks
9 pts
This criterion is linked to a Learning OutcomeRubric Item #7: VLOOKUP formula correct: 1) 1st field: bicycle code cell, 2) 2nd field: NAMED RANGE (not cell references) , 3) column to return, 4) ‘false’ , 5) Absolute cell reference used in formula
10 pts
Full Marks
8 pts
1 part missing / incorrect
6 pts
2 parts incorrect / missing
4 pts
3 parts incorrect / missing
2 pts
4 parts incorrect / missing
0 pts
No Marks
10 pts
This criterion is linked to a Learning OutcomeRubric Item #8: Calculate & display 1) mark-up % , 2) YTD Bikes Sold , 3) % sales goal met – For Code C54: 50.1%, 92, 109.5%
9 pts
Full Marks
6 pts
1 part missing / incorrect
3 pts
2 parts incorrect / missing
0 pts
No Marks
9 pts
This criterion is linked to a Learning OutcomeRubric Item #9: If statements – 1) C54 ‘Sales to meet goal’ = 0 & goal met message, 2) Message Red 3) conditional formatting on % Sales Goal Met & 4) % Sales goal red if > 100% or >=100%, 5) C14 displays 38 & no message,
10 pts
Full Marks
8 pts
1 part missing / incorrect
6 pts
2 parts missing / incorrect
4 pts
3 parts incorrect / missing
2 pts
4 parts incorrect / missing
0 pts
No Marks
10 pts
This criterion is linked to a Learning OutcomeRubric Item #10: 1) Region YTD Sold calculations correct, 2) %’s correct – For Bike: C14…… 48 & 29.6% ……… 31 & 19.1% …….. 43 & 26.5% ………… 40 & 24.7%
6 pts
Full Marks
3 pts
1 part missing / incorrect
0 pts
No Marks
6 pts
This criterion is linked to a Learning OutcomeRubric Item #11: Chart: 1) 4 Correct columns only & background TEXTURE, 2) Color fonts on chart text (not dark blue/black) , 3) Data values displayed on columns, 4) Gradient used on columns ,5) Title = Bike Name and changed when code changes
10 pts
Full Marks
8 pts
1 part missing / incorrect
6 pts
2 parts incorrect / missing
4 pts
3 parts incorrect / missing
2 pts
4 parts incorrect / missing
0 pts
No Marks
10 pts
This criterion is linked to a Learning OutcomeRubric Item #12: Pivot Tables: 1) Categories & Average Selling Price – Road Ave Selling price = $475.77….. OK if COST is also included, 2) Table (West Sales = 2,176) & Chart: Regions & bicycle categories, . 3) Dealer’s choice, 4) w/textbox explanation
12 pts
Full Marks
9 pts
1 part missing / incorrect
6 pts
2 parts incorrect / missing
0 pts
No Marks
12 pts
This criterion is linked to a Learning OutcomeRubric Item #13: Filters: 1) Filter on Children w/selling price >$100 – 5 records , 2) Filter on Classic & Tea – 6 records , 3) Textbox explaining use of status bar for averages , 4) Dealer’s choice , 5) w/textbox explanation
10 pts
Full Marks
8 pts
1 part missing / incorrect
6 pts
2 parts incorrect / missing
4 pts
3 parts incorrect / missing
2 pts
4 parts incorrect / missing
0 pts
No Marks
10 pts
This criterion is linked to a Learning OutcomeRubric Item #14: 1) Currency includes $ and 2 decimals , 2) Percentages include % and 1 decimal
2 pts
Full Marks
0 pts
No Marks
2 pts
Total Points: 100
