Limited Offer Get 25% off — use code BESTW25
No AI No Plagiarism On-Time Delivery Free Revisions
Claim Now
Prices start at $5 per page · plagiarism-free papers · free revisions for 14 days 24/7 support: support@bestwriters.com
Uncategorized

ACCT5011 Accounting Systems in the Digital Age

  • Posted
  • Authoradmin
  • Length338 words
  • Reading time2 min
Write My Assignment FREE

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.

Plagiarism Free Assignment Help

Expert Help With This Assignment — On Your Terms

✓ Native UK, USA & Australia writers ✓ Deadline from 3 hours ✓ 100% Plagiarism-Free — Turnitin included ✓ Unlimited free revisions ✓ Free to submit — compare quotes

admin

Academic writer and editor at BestWriters.

Get your paper off your plate tonight

Post your instructions for free. Prices start at $5 per page.

Place an order