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.
Assessment 3_COMR2002BIS.docx Page 1 of 3
Learning Rubrics
Assessment Attributes Fail (Unacceptable) Pass (Functional) Credit (Proficient) Distinction (Advanced) 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 2 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
Laureate_Assessment_Template.docx Page 3 of 3