Excel Assignment Winter 2011 Printout

Excel Assignment Winter 2011 Printout - Information Systems...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Information Systems MGCR 331 Winter 2011 C.E. Excel assignment - Grading sheet Value Your mark Comment Other (a) Reduction of -0.2 each for not identifying your section, name and/or student number at the top of Step 1 Links to other workbooks not submitted to webct ( ). This may effect what is being marked. Step 1: 2 Cell linking missing (-.3). Incompleted columns, calculation(s) missing/wrong or do not match to the penny (-.5). Improper formatting (0.3). Conditional formatting not right (-.3) No SUMIF or CountIF(-.3). Missing day of the name of the agent with single biggest Sales value (-.3). Other Step 2: 1 Missing or wrong selection for Part 2b (-.2), Part 2c (-.2), Part 2d (-.4). Wrong sequence (-.2). Wrong or missing criteria (-.3). Data table repeated in Step 2 (-.1) Other: Step 3: 1 Missing, not shown as a Pivot table, or wrong results. Pivot #1 (-.3), Pivot #2 (-.3), Pivot #3 (-.2), Pivot #4 (-.2). Formatting and/or layout of output (-.2). Pivot #4 does not show most recent date (-.2) Step 4: 1 Not done (-1) Sort order wrong (-.3). SubTotal display does not have the required number of levels (-.4) Not displayed in Subtotal format (-.9) Step 5: 1.5 5b - Pie chart missing (-.5). % Formatting not with 2 decimal places (-.2) 5c - Column bar chart missing missing (-.5) or improper values and/or format (-.3) 5d - Column bar chart with 2nd y axis (-.5) or scale(s) is/are wrong (-.2). Not a stacked bar. 5e - XY chart with trend line missing (-.5). Trend line does not cover earlier and/or following years (-.3) 5f - Pie of a Pie chart missing (-.5) or incorrect (-.3). Optional Stock chart Column chart with photos Step 6: 2 Data table repeated in Step 6 (-.1) 6a&b DCount and/or DAverage values are missing or wrong (-.8). 6c Expression wrong or missing: No First name (-.3). No encrypted name (-.3) Wrong or missing elapsed time (-.3). Elapsed time not properly formatted (-.3). Amount due wrong/missing (-.3). Step 7: 0.8 Step 7i not done (-.4) does not work ( ) No proper error message ( ) No symbol point to cell (-.2) Step 7ii not done (-.4) not using the Table features ( ) Step 8: 1.2 Step 8 not done (-1.2) Solver Answer is wrong (-.5). Solver Answer Report sheet not provided (-.4). Solver Answer Report Target cell is not Profit per bottle (-.3). Step 9: 3 Step 9 not done (-3). Other: Other (b) Reduction for the mutiple workbooks, sheets in your workbook not according instructions (e.g. order of sheets, too many sheets, data repeated where it should not have been, etc. (up to -.5)) Subtotal Subtotal is only given for more complex total mark calculations Total 13 Marked by: Date: Section class (Monday or Tuesday 1st person Student No & Name: 2nd person Student No and Name:
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Assignment # 1 - Excel - Winter 2011 Change the values in the tables below, per instructions. Note: Often in team work, one of the two students will do most of the work. Don't find yourself short changed for your midterm. Furthermore, plagiarism, i.e. the copying of this assignment will not be tolerated and is strictly enforced.
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 16

Excel Assignment Winter 2011 Printout - Information Systems...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online