Reference no: EM132673105
COMR2002 Business Information Systems - Laureate International Universities
Practical Application - Excel Assessment
Learning Outcome 1: Apply practical skills in the major functions of spreadsheet and database tools.
Learning Outcome 2: Communicate with IT professionals, stakeholders and user groups of information systems.
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.
Attachment:- Business Information Systems.rar