2. INDIVIDUAL ASSIGNMENT (50%)
Each student is required to build a data model using Microsoft Excel for the Expo Budget Spreadsheet (you can use the details in budget planning in your group project report, e.g. the number of laptops to purchase, the cost for decoration, etc).
2.1. Data Modelling
Your Expo Budget Spreadsheet should have multiple worksheets with various types of data, such as item name, item ID, supplier name, supplier ID, unit price, quantity, web link, category ID, category name, remark, etc.
To improve the quality of your Expo Budget Spreadsheet, you should have clear input and output cells with proper labels or comments (small amount of text to explain each element) to help the users understand how to use the data model.
You can create several scenarios to help the decision-makers to understand the results of the decisions about the Expo. For example, if the
paid professional consultation service can be offered at the expo, what should be the charge of each consultation (decision 1)? And how many cases to reach a breakeven point (decision 2)? What is the optimum capacity for this consultation service at the expo per day/session (decision 3)? Creating a scenario is also giving the users some options to choose (Worst, Most Likely, or Best case) and then the input parameters automatically change and the decision-maker can view the result corresponding to that scenario.
Hint: the Spreadsheet Modelling Online Course and the article of ‘Good Modelling Practices in Microsoft Excel’ can be very helpful in giving you some ideas to create your scenarios.
2.2. Requirements and Marking Criteria
Each student must demonstrate his/her skills in using Microsoft Excel to perform data modelling through the scenario that he/she creates. The mark for the Expo Budget Spreadsheet will be allocated based on FIVE areas, each with some required components:
1. Design of the worksheets (students must demonstrate the use of annotation, appropriate screen space and sizes in each worksheet, the use of conditional formatting, the data that has been sorted and filtered accordingly.) – 10 marks
2. Use of formula and functions (students must demonstrate the use of mathematical operations, absolute formatting, IF statement, range names, lookup function, conditional counts, date and time function, and SUMPRODUCT function in the worksheets.) – 10 marks
3. Spreadsheet modelling (students must display the Data Table and Goal Seek in the Expo Budget Spreadsheet that allows the users to enter the input parameters and decision variables for generating the result.) – 10 marks
4. Charts (students must demonstrate the basic formatting of charts, the ability to customise the chart, the use of PIVOT table.) – 10 marks
5. With not more than 200 words, describe the key decisions that can be made by using this Expo Budget Spreadsheet. You can focus on the efficiency and accuracy when using this spreadsheet in making some decisions (elaborations/examples are needed.) – 10 marks
CS 340 Milestone One Guidelines and Rubric Overview: For this assignment, you will implement the fundamental operations of create, read, update,
Retail Transaction Programming Project Project Requirements: Develop a program to emulate a purchase transaction at a retail store. This
7COM1028 Secure Systems Programming Referral Coursework: Secure
Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip
CS 340 Final Project Guidelines and Rubric Overview The final project will encompass developing a web service using a software stack and impleme
