Assessment 3_COMR2002BIS.docx Page 1 of 3
| ASSESSMENT BRIEF | |
| Subject Code and Title | COMR2002 Business Information Systems |
| Assessment | Practical Application – Excel Assessment |
| Individual/Group | Individual |
| Length | No required length |
| Learning Outcomes | 1. Apply practical skills in the major functions of spreadsheet and database tools. 2. Communicate with IT professionals, stakeholders and user groups of information systems. |
| Submission | By 11:55pm AEST/AEDT Sunday of Week 7 |
| Weighting | 30 % |
| Total Marks | 30 marks |
Context:
The aim of this assessment is to assess the student’s ability to create spreadsheets that can
aid business problem solving. Weekly online practical work will help students to complete
this assessment.
The spreadsheet is a powerful tool that has become entrenched in business processes
worldwide. A working knowledge of Excel is vital for most office based professionals today.
Instructions:
Students will be required to construct a spreadsheet using the case study provided by your
lecturer. Excel functionalities such as absolute and relative cell references, formatting, chart,
pivot tables and formulae will be used.
List of requirements:
1. Students are required to document the spreadsheet that informs the user how it is
constructed and why. (Submit using Word document)
2. In creating pivot tables, each student will be given different set of data and will have
a slightly different set of questions.
3. Students need to submit their Excel Spreadsheet and Word document.
Laureate_Assessment_Template.docx Page 2 of 3
Learning Rubrics
| Assessment Attributes | Fail (Unacceptable) | (Functional) Pass | (Proficient) Credit | (Advanced) Distinction | High Distinction (Exceptional) |
| Documentation 10 | The document is incomplete and do not meet the minimum requirements. 1-2 | Document contains the minimum requirement. Grammatical and spelling errors are present; document presentation needs to be improved. Some explanation on how the spreadsheet was created 3-4 | Document contain the required contents. Well present and has few grammatical and spelling errors. A complete explanation on how the spreadsheet was created. 5-6 | Document exceeds minimum standards. Detailed explanation of how the spreadsheet was created (some graphics and figures were provided to support the explanation). 7-8 | Document exceeds minimum standards and exhibit high quality presentation. Detailed explanation of how the spreadsheet was created (includes detailed graphics and figures to support the explanation). Document was clearly written for intended users. 9-10 |
| Formulae, formatting and cell references | Formulae, formatting and cell references are mostly incorrect and incomplete. Some data have been added. | More than 50% of the formulae, formatting and cell references are correct. Most data have been added. | More than 75 % of the formulae, formatting and cell references are correct. All data have been added. | Almost all formulae, formatting and cell references are correct. Very few errors (around 1 -2 errors) | All formulae, formatting and cell references are correct (No errors) All data have been entered correctly. |
Laureate_Assessment_Template.docx Page 3 of 3
| 10 | 1-2 | 3-4 | 5-6 | All data have been entered correctly. 7-8 | 9-10 |
| Answers to questions, graphs and pivot tables 10 | Answers to questions were mostly incorrect. No graphs nor pivot tables. 1-2 | More than 50% of the questions were answered correctly. Graphs and/or pivot tables were created but mostly incorrect. 3-4 | More than 75% of the questions were answered correctly. Graphs and pivot tables were created with minor errors. 5-6 | All questions were answered correctly. Graphs and pivot tables were created with minor errors. 7-8 | All questions were answered correctly. Graphs and pivot tables were created and they are complete and correct 9-10 |