Home Purchase - Excel Application Rubric
accounting
Description
Home Purchase - Excel Application Rubric
|
Item |
Max Points If all correct |
Minimum Points if Incorrect |
|
1. Is the file named correctly Lastname_StudentID_HomePurchase? |
If yes, Proceed to 2 |
If No, Stop and give the assignment a 0. |
|
2. Did the `student do his or her own work? |
If yes, Proceed to 3 |
If No, Stop and give the assignment a 0. |
|
3. Take home pay correct |
10 |
0 |
|
4. Time to save for 0% Down Payment |
10 |
0 |
|
5. Time to save for 10% Down Payment |
5 |
0 |
|
6. Time to save for 20% Down Payment. |
5 |
0 |
|
7. Time to save for 30% Down Payment |
5 |
0 |
|
8. How much can you afford to pay for the house with 0% Down Payment? |
10 |
0 |
|
9. How much can you afford to pay for the house with 10% Down
Payment? |
5 |
0 |
|
10. How much can you afford to pay for the house with 20% Down
Payment? |
5 |
0 |
|
11. How much can you afford to pay for the house with 30% Down
Payment? |
5 |
0 |
|
Total |
|
0 |
All students must submit their own work and create their own
spreadsheet. If data is given, it must be copied into a new Excel workbook. Files
that cannot be identified as the student’s work will not be graded. The
workbook must follow the naming convention given in the syllabus, which is Lastname_StudentID_HomeworkID.
Incorrectly named files will not be graded. All workbooks must be turned in on
the correct Brightspace dropbox. Work turned in any other way will not be
graded.
