ACCT5011 Accounting Systems in the Digital Age
Semester 1, 2020 Practical Assignment Marking Rubric
1
Student name:
Student ID number:
| Components | Very poor effort |
Poor effort |
Reasonable effort |
Good work |
Excellent work |
| ACCESS: Database Design ‐Rename to “Ticket Limits” and “Organisations” tables correctly ‐Appropriate field type for Sales Number ‐Appropriate date format ‐Correct update query to update city name “Brisbane” in both Sales Table |
0‐3 | 4‐6 | 7‐8 | 9‐12 | 13‐15 |
| ACCESS: Entity‐Relationship Diagram ‐Include all tables ‐Link tables correctly and show correct cardinality between Organisations, Ticket Limits, 2015 Tickets, and 2016 Tickets Tables |
0‐3 | 4‐6 | 7‐8 | 9‐12 | 13‐15 |
| ACCESS: Queries/Reports ‐Queries and reports are correctly named ‐Queries work and are well‐designed Query for Report 1: Query for Report 2: Query for Report 3: Queries for Report 4: Query for Report 5: Query for Report 6: Query 7: Query 8: ‐Reports are professionally formatted and presented (e.g. appropriate labels) ‐Reports include necessary information ‐Reports show correct answers ‐No spelling mistakes |
0‐7 0‐4 |
8‐34 5‐10 |
35‐56 11‐15 |
57‐62 14‐17 |
63‐70 18‐20 |
| Data Export from ACCESS to EXCEL ‐all data exported correctly ‐2015 and 2016 combined in one worksheet |
0‐2 | 3‐4 | 5‐6 | 7‐8 | 9‐10 |
| EXCEL design: ‐A separate worksheet describing the workbook and assumptions ‐Appropriate description of all worksheets ‐Professionally formatted worksheet with basic information (e.g. Company name) |
0‐2 | 3‐4 | 5‐6 | 7‐8 | 9‐10 |
ACCT5011 Accounting Systems in the Digital Age
Semester 1, 2020 Practical Assignment Marking Rubric
2
| Components | Very poor effort |
Poor effort |
Reasonable effort |
Good work |
Excellent work |
| EXCEL: CaringShoeProject ‐Name the worksheet correctly ‐Combine Full Name correctly ‐Extract Year correctly ‐Correct VLOOKUP formula in all records ‐Correct Sumif function in price level table ‐Correct Percentage formula in price level table |
0‐3 | 4‐10 | 11‐15 | 16‐20 | 21‐25 |
| EXCEL: Pivot Table CitybyStatus ‐Correct Pivot table design ‐Formatting of Pivot table results ‐Pivot chart is shown correctly and professionally |
0‐3 | 4‐10 | 11‐15 | 16‐20 | 21‐25 |
| EXCEL: Pivot Table PriceLevelbyQuarter ‐Correct Pivot table design ‐Formatting of Pivot table results ‐Filter (year) is added correctly ‐Pivot chart is shown correctly and professionally |
0‐3 | 4‐10 | 11‐15 | 16‐20 | 21‐25 |
| EXCEL: Pivot Table OrgbyYear ‐Correct Pivot table design ‐Formatting of Pivot table results ‐Correct formula to calculate increase/decrease percentage |
0‐3 | 4‐10 | 11‐15 | 16‐20 | 21‐25 |
| Case Summary Report ‐appropriate memo format ‐professionally formatted and presented ‐good grammar, no spelling errors ‐Correct answers to questions |
0‐8 | 9‐27 | 28‐31 | 32‐51 | 52‐60 |
| Fail to follow all off‐line submission requirements |
|||||
| Fail to follow online submission requirements – Blackboard (deduct maximum 30 marks) |
|||||
| Late penalty: 5% 1st day, 10% from 2nd day onwards |
|||||
| Total Mark (max 300) | |||||
| Final Mark (max 30) | |||||
| Comments: |
The post ACCT5011 Accounting Systems in the Digital Age appeared first on My Assignment Online.