Em Andamento

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)

Habilidades: Processamento de Dados, Processamento de dados, Excel, Powerpoint

Ver mais: students data entry software, selecting a business plan, purpose of a business plan, project management tutor, maximum path, graphs with data, graphs of data, graphs data, graphs and data, formatting a business plan, excel data entry validation, entry level management, entry level it, data graphs, data entry tablet, data entry responsibilities, data entry methodology, data entry management system, data entry management software, data entry error, data entry and validation, cost graphs, best graphs for data, best graphs, excel mark

Acerca do Empregador:
( 6 comentários ) Essex, United Kingdom

ID do Projeto: #5106086

Premiar a:

dobreiiita

I am a Management graduate from premier B-School in India, I can get this work done easily. Also the budget you have kept for the project is low. Please revise that

£32 GBP em 2 dias
(16 Avaliações)
4.2

4 freelancers estão ofertando em média £19 para este trabalho

hepikurniawan

A proposal has not yet been provided

£18 GBP in 3 dias
(0 Comentários)
0.0
bishnuprasadpand

my long term experience will match the requirement and i will complete the project in time. but one thing you should inform me earlier about it.

£13 GBP in 3 dias
(0 Comentários)
0.0
naveed682

respected , i have great experience of ms excel and world and so on......... please hire me for your project thanks regards, naveed682

£13 GBP in 3 dias
(0 Comentários)
0.0