PART A – The Weighted Scoring Model
(10% of this coursework)
Decide on a set of appropriate business-related factors and criteria to decide which tablet to purchase. A 2-level Weighted Scoring Model MUST be used, and one of the factors must be the Total Cost of Ownership.
PART B – The Spreadsheet Model (30% of this coursework)
Plan a spreadsheet-based 2-level Weighted Scoring Model to assess the packages against the factors and criteria. Extend your spreadsheet to calculate the Total Cost of Ownership
1. Cell validation, with appropriate instructions and error messages
2. Cell formatting
3. Cell calculation
4. Automatic graphs
5. Cell protection with sheet password = “Q”
You MUST demonstrate your spreadsheet model to your tutor who will test it and mark it to ensure that it meets requirements.
FAILURE TO DEMONSTRATE YOUR MODEL WILL MEAN THAT YOU WILL GET ZERO FOR THIS PART OF THE COURSEWORK
PART C – The Use of the Weighted Scoring Model
(20% of this coursework)
Use your spreadsheet model to compare and contrast the features of at least 4 different tablets, and decide on which one best meets the requirements.
Prepare and present a 10 minute presentation, with a maximum of 10 slides, to justify the factors and criteria that were selected, the scores that were given to the tablets, and the final recommendation.
You MUST give a presentation to your tutor and fellow students explaining your options and your decision.
FAILURE TO GIVE A PRESENTATION WILL MEAN THAT YOU WILL GET A MAXIMUM OF 10 MARKS OUT OF 20 FOR THIS TASK.