Excel and data entry

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 for each of the tablets. Implement your plan to produce a robust and flexible spreadsheet system for the purpose of selecting the package to purchase. Your model should include 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” 6. Comments 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 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. PART D – The Presentation 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. PART E - The Project Plan Select a project management methodology to implement this project. This should include allocation of responsibilities and resources, a work breakdown schedule, a Gantt chart, a network diagram, identification of the critical path, etc. Implement the plan using project management software. Document the plan appropriately within the system (e.g. using notes with the project)