ACCT Assignment 1
MrJinx29
acct300_01-13.xlsEx. 1-13
| Exercise 1-13 | # Incorrect N-box and B-box entries COUNTIF(A12:Z200,"~*") | ||||||||||||||||||||||||||||
| Name: | 0 | ||||||||||||||||||||||||||||
| Section: | # N-box Incorrects due to blanks COUNTIF(A12:Z200," ") | ||||||||||||||||||||||||||||
| 8 | |||||||||||||||||||||||||||||
| Score: | 0% | # N-box +B-box corrects COUNTIF(A12:Z200," ") | |||||||||||||||||||||||||||
| 0 | |||||||||||||||||||||||||||||
| Key Code: | 2 | Total SUM(AV13:AV15) | |||||||||||||||||||||||||||
| Instructions | 8 | ||||||||||||||||||||||||||||
| Answers are entered in the cells with gray backgrounds. | Percentage =(AD8-AD4-AD2)/AD8 | ||||||||||||||||||||||||||||
| Cells with non-gray backgrounds are protected and cannot be edited. | 0% | ||||||||||||||||||||||||||||
| A red asterisk (*) will appear in the column to the right of an incorrect answer. | Notes: | ||||||||||||||||||||||||||||
| If number-entry box is blank (this would be an incorrect answer for N-boxes), error check returns two spaces, " " | |||||||||||||||||||||||||||||
| If number-entry or blank-entry box is incorrect, returns "*" | |||||||||||||||||||||||||||||
| Net income for the month | If number-entry or blank-entry box is correct, returns single space, " " | ||||||||||||||||||||||||||||
| WESTWOOD COMPANY | Decrease in retained earnings | Use data verification to set data entry to whole number >= 0, and use drop-downs for lables and names, so that students can't enter a space in a box and have it counted as correct. | |||||||||||||||||||||||||||
| Retained Earnings Statement | Increase in retained earnings | Conditional formatting might be used but wasn't here, to hide some of the error check return symbols. If A1 = "~*", then font = red, if something else, then font = background color. | |||||||||||||||||||||||||||
| For the Month Ended June 30, 2012 | Less dividends | ||||||||||||||||||||||||||||
| Add dividends | |||||||||||||||||||||||||||||
| Retained earnings, June 1, 2012 | Steps: | ||||||||||||||||||||||||||||
| Open this sheet and macro sheet | |||||||||||||||||||||||||||||
| Open old templated, then change color palet to this sheet's | |||||||||||||||||||||||||||||
| Insert new header - change problem number and reformat | |||||||||||||||||||||||||||||
| Retained earnings, June 30, 2012 | Copy these formulas (column AD) to new sheet. | ||||||||||||||||||||||||||||
| Update to new edition numbers | |||||||||||||||||||||||||||||
| Copy new error check formulas: | |||||||||||||||||||||||||||||
| IF(sol.!$C$5="OFF","",IF(G19=""," ",IF(AND(G19<>"",G19<>sol.!G19),"*"," "))) | |||||||||||||||||||||||||||||
| Copy Score formula from this template to new sheet. | |||||||||||||||||||||||||||||
| IF(sol.!C5="OFF","","Score:") | |||||||||||||||||||||||||||||
| IF(sol.!C5="OFF","",AD10) | |||||||||||||||||||||||||||||
| Verification | |||||||||||||||||||||||||||||
| Verify that problem heading is ok (correct problem number, spacing, etc.) | |||||||||||||||||||||||||||||
| Enter answers from problem, verify correct scoring and monitor % score upating at top of sheet | |||||||||||||||||||||||||||||
| Check that students name box and section box are unprotected and data can be entered in them | |||||||||||||||||||||||||||||
| Click the "sol." tab and go to the instructor's sheet. Turn scoring "off" then go back to student sheet and verify that score and the sentence in red about asterisks do not display. |
Place the item that increases retained earnings on this line.
Place the net change in retained earnings on this line.
sol.
| Exercise 1-13 | # Incorrect N-box and B-box entries COUNTIF(A12:Z200,"~*") | ||||||||||||||||||||||||||||
| Name: | SOLUTION | 0 | |||||||||||||||||||||||||||
| Section: | # N-box Incorrects due to blanks COUNTIF(A12:Z200," ") | ||||||||||||||||||||||||||||
| Score: | See student sheet for student's score. | 0 | |||||||||||||||||||||||||||
| Scoring: | ON | # N-box +B-box corrects COUNTIF(A12:Z200," ") | |||||||||||||||||||||||||||
| 8 | |||||||||||||||||||||||||||||
| Total SUM(AV13:AV15) | |||||||||||||||||||||||||||||
| Instructions | 8 | ||||||||||||||||||||||||||||
| Answers are entered in the cells with gray backgrounds. | Percentage =(AD8-AD4-AD2)/AD8 | ||||||||||||||||||||||||||||
| Cells with non-gray backgrounds are protected and cannot be edited. | 100% | ||||||||||||||||||||||||||||
| A red asterisk (*) will appear in the column to the right of an incorrect answer. | Notes: | ||||||||||||||||||||||||||||
| If number-entry box is blank (this would be an incorrect answer for N-boxes), error check returns two spaces, " " | |||||||||||||||||||||||||||||
| If number-entry or blank-entry box is incorrect, returns "*" | |||||||||||||||||||||||||||||
| Net income for the month | If number-entry or blank-entry box is correct, returns single space, " " | ||||||||||||||||||||||||||||
| WESTWOOD COMPANY | Decrease in retained earnings | Use data verification to set data entry to whole number >= 0, and use drop-downs for lables and names, so that students can't enter a space in a box and have it counted as correct. | |||||||||||||||||||||||||||
| Retained Earnings Statement | Increase in retained earnings | Conditional formatting might be used but wasn't here, to hide some of the error check return symbols. If A1 = "~*", then font = red, if something else, then font = background color. | |||||||||||||||||||||||||||
| For the Month Ended June 30, 2012 | Less dividends | ||||||||||||||||||||||||||||
| Add dividends | |||||||||||||||||||||||||||||
| Retained earnings, April 1, 2010 | $ 615,000 | Steps: | |||||||||||||||||||||||||||
| Net income for the month | $ 230,000 | Open this sheet and macro sheet | |||||||||||||||||||||||||||
| Less dividends | 45,000 | Open old templated, then change color palet to this sheet's | |||||||||||||||||||||||||||
| Increase in retained earnings | 185,000 | Insert new header - change problem number and reformat | |||||||||||||||||||||||||||
| Retained earnings, April 30, 2010 | $ 800,000 | Copy these formulas (column AD) to new sheet. | |||||||||||||||||||||||||||
| Update to new edition numbers | |||||||||||||||||||||||||||||
| Copy new error check formulas: | |||||||||||||||||||||||||||||
| IF(sol.!$C$5="OFF","",IF(G19=""," ",IF(AND(G19<>"",G19<>sol.!G19),"*"," "))) | |||||||||||||||||||||||||||||
| Copy Score formula from this template to new sheet. | |||||||||||||||||||||||||||||
| IF(sol.!C5="OFF","","Score:") | |||||||||||||||||||||||||||||
| IF(sol.!C5="OFF","",AD10) | |||||||||||||||||||||||||||||
| Verification | |||||||||||||||||||||||||||||
| Verify that problem heading is ok (correct problem number, spacing, etc.) | |||||||||||||||||||||||||||||
| Enter answers from problem, verify correct scoring and monitor % score upating at top of sheet | |||||||||||||||||||||||||||||
| Check that students name box and section box are unprotected and data can be entered in them | |||||||||||||||||||||||||||||
| Click the "sol." tab and go to the instructor's sheet. Turn scoring "off" then go back to student sheet and verify that score and the sentence in red about asterisks do not display. |
Place the item that increases retained earnings on this line.
Place the net change in retained earnings on this line.
