Midterm Grading Key Fall 2009

Midterm Grading Key Fall 2009 - ACCT-361 Spring 2009...

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

View Full Document Right Arrow Icon
ACCT-361 – Spring 2009 Midterm Grading Key for Partial Credit Query Exercise (50 points) # Description of Error Points Deducted 1 Everything is done properly: Only 4 records (grouped by date), total calculated as gross revenue by date, sorted in descending order by date (9/4 is first), and caption set for “Total Daily Revenue.” Sales for 9/4 equal $280.71. 0 2 Did not sort. 5 3 Did not change caption. 5 4 Did not group. # of records or total would be 56. 20 5 Did not multiply the item price by quantity sold (error would be $231.96 for 9/4). 15 7 Computed Gross Margin and not Revenue. 10 8 Did not include sales table for link 40 9 Grouped but had too many fields in query – more than 4 records displayed. 15 10 Inappropriate brackets or parentheses or lack of brackets or parentheses when needed. 10 11 Grouped calculation instead of summing it. 10 12 Did not use invoice date in query 30 Multiple Choice – No partial credit awarded (5 points each). Short Answers (order of questions are different based on the exam version): 1. Outer-join query example: The student must provide a specific example that is correct to get 15 points. Besides the examples given in the exam key, one student gave a perfect example report that was
Background image of page 1

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

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 3

Midterm Grading Key Fall 2009 - ACCT-361 Spring 2009...

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

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