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 ~~~For this or similar assignment papers~~~
Ordering & Making Payment
Click Order Now/Place and fill the form accordingly then click checkout to be directed to payment preview & payment page. Your payment(which updates the order from pending to in progress) is processed by an encrypted secure system . We accept PayPal, and all cards. No intrusion of personal data.
Writing & Communication Process
We facilitate live chats, messages, and emails where you can communicate with your writer or support to clarify or track order progress
Check your completed orders files section. Download and check if it meets requirement for approval. If any changes are needed, request a revision to be done.
Why ‘Essay Bishop’?
- ~ Perfectly structured and formatted paper in step with the citation requested.
- ~ Both ENL and ESL writers for all model of students. Proofread, 0% grammar errors
- ~ Deadline policy; all papers are delivered hours before the set time in order to permit you to review it before submission.
- ~ We guarantee top quality original content research papers – the final copies are uploaded with their plagiarism reports showing 0% similarity index or your money back.
- ~ 100% privacy of all our customer’s personal and financial data – the payment system is encrypted thus your card data is kept safe from fraud and external intrusion.
“Welcome to the bishops of hope”