COMR2002 Business Information Systems

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-23-4 5-6All 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

Leave a Reply

Your email address will not be published. Required fields are marked *