BCBT016: To provide an opportunity for students to apply their skills on analyzing and presenting numeric data using basic and advanced features of MS EXCEL 365: Business IT & Data Analytics, Assignment, TP, Singapore

OBJECTIVES

The objectives of this project assignment are:

1. To provide an opportunity for students to apply their skills on analysing and presenting numeric data using basic and advanced features of MS EXCEL 365.
2. Use data tools such as Excel pivots and charts for data analysis.
3. To showcase creativity and initiative in self-exploration of the MS Excel 365

GUIDELINES

1. This is an INDIVIDUAL project.
2. Each student is required to select ONLY ONE (1) of the options in item 6.
3. Apply spreadsheet techniques for analysis based on the dataset you have selected. Your spreadsheets should be able to demonstrate the use of ALL MS Excel 365 features taught to uncover deeper business insights as listed in GRADING POLICY.
4.  Based on your chosen dataset, you are to apply meaningful spreadsheet techniques to ALL 5 (FIVE) raw worksheets (except Excel Project Proposal worksheet) and in each worksheet, highlight the salient points you observed with comments.
5. Students must ensure that all files submitted are in softcopy, can be opened and viewed by your tutor for marking. Only file with .xlsm or .xlsx extension will be accepted.

6. Select any ONE of the 6 themes below:

• Education
•  Health
• Hospitality
•  Logistics
•  Transport
• Human Resource

If you would like to explore other dataset outside the one listed above, you MUST show the datasets and SEEK approval from your tutor before you continue with the project.