skip to Main Content

I’m working on a Excel project and need support to help me learn.Here are some q

Please note that this is just a preview of a school assignment posted on our website by one of our clients. If you need assistance with this question too, please click on the Learn More button at the bottom of the page to get started.

I’m working on a Excel project and need support to help me learn.Here are some quick video Tips to help refresh your ‘Excel Memory.’ Excel 1 Rubric F20Excel 1 Rubric F20CriteriaRatingsPtsThis criterion is linked to a Learning OutcomeProject matches the assignment instructions ( or cannot be graded).0.0 ptsFull Marks0.0 ptsNo Marks0.0 ptsThis criterion is linked to a Learning OutcomeMUSIC: Data correct, 1) titles wrapped even when column width expanded, 2) Sorted Correctly (BR4018…. 21 units sold in 2015)1.0 ptsFull Marks0.5 pts1 part missing or incorrect0.0 ptsNo Marks1.0 ptsThis criterion is linked to a Learning OutcomeMUSIC: Data correct, 1) Conditional formatting – Selling price >=9 green fill, 2) Named Range = MusicData1.0 ptsFull Marks0.5 pts1 part missing or incorrect0.0 ptsNo Marks1.0 ptsThis criterion is linked to a Learning OutcomeLOOKUP: 1) IFERROR used correctly (TEST: BU6009, “Code Not Found” and “15%” is all that should be displayed), 2) Worksheet protected correctly (no password)1.0 ptsFull Marks0.5 pts1 part missing or incorrect0.0 ptsNo Marks1.0 ptsThis criterion is linked to a Learning OutcomeLOOKUP: 1) Title w/borders & CURRENT date (uses formula) & comment, 2) arrow shape / color1.0 ptsFull Marks0.5 pts1 part missing or incorrect0.0 ptsNo Marks1.0 ptsThis criterion is linked to a Learning OutcomeLOOKUP: 1) Vlookup correct with 2) absolute cell reference & named range1.0 ptsFull Marks0.5 pts1 part missing or incorrect0.0 ptsNo Marks1.0 ptsThis criterion is linked to a Learning OutcomeCALCULATIONS: 1) Gross Margin correct and Markup % Correct, 3) 2016 Goal correct & INT used. Check with BU6005: $3.05, 93.8%, 711.0 ptsFull Marks0.5 pts1 part missing or incorrect0.0 ptsNo Marks1.0 ptsThis criterion is linked to a Learning OutcomeIF: 1) Units to meet goal correct, 2) Goal met message or nothing displayed. Check with BU6005: 40, no message AND EU7006: 0, Message displayed1.0 ptsFull Marks0.5 pts1 part missing or incorrect0.0 ptsNo Marks1.0 ptsThis criterion is linked to a Learning OutcomeCHART: 1) correct format & data values displayed, 2) Gradient used & title changes1.0 ptsFull Marks0.5 pts1 part missing or incorrect0.0 ptsNo Marks1.0 ptsThis criterion is linked to a Learning OutcomePIVOTS: Pivot 1) Event Name / Ave Selling Price : $7.46, Pivot 2) Grade / Units Sold 7,839 and 3,499 w/chart and 3) student designed pivot table w/textbox explanation1.0 ptsFull Marks0.5 pts1 part missing or incorrect0.0 ptsNo Marks1.0 ptsThis criterion is linked to a Learning OutcomeFILTERS: Filter 1) CFP and brass, 4 records displayed, Filter 2) Grade 4 & 5 and Tubas, 5 records displayed and 3) student designed filter worksheet w/textbox explanation1.0 ptsFull Marks0.5 pts1 part missing or incorrect0.0 ptsNo Marks1.0 ptsThis criterion is linked to a Learning OutcomeNOTE: this project is only worth 10 points, Excel 2 will be graded in more detail.0.0 ptsFull Marks0.0 ptsNo Marks0.0 ptsTotal Points: 10.0PreviousNext

Get Help Today

Struggling with this particular assignment? Learn how our team of professional writers can help you today.

Leave a Reply

Your email address will not be published. Required fields are marked *