Closed

IT Project and Quality Management 2

THIS IS AN INDIVIDUAL COURSEWORK

THE WORK SUBMITTED MUST THEREFORE BE YOUR OWN WORK

Specification:

Title: Laptop Selection

As a manager in a business you will often have to decide which of several alternative products to purchase. A Weighted Scoring Model can help you make a reasoned decision that you will be able to justify to your manager. For evaluation purposes the Total Cost of Ownership is more important than the purchase price, so this needs to be included in your model.

For the purposes of this coursework, assume that you are a manager working for an international company with a team of sales executives who need to be in constant contact with Head Office. The Head Office is in your own country, and there is a group of managers based there. Some staff will need to use their laptops worldwide.

You have been tasked to evaluate a range of laptops with built-in email and other functionality (e.g. camera, media player, organiser, browser, GPS) to determine which is the best one for the company to purchase for all its managers and sales executives. You have been particularly asked to consider the SAMSUNG Series 5 11.6" Touchscreen Convertible and the HP ENVY m6-1178sa 15.6" as well as other makes (e.g. Lenovo, Asus). Note that model numbers may vary according to region, if so, use nearest equivalents. You will need to consider the usability and functionality of the system, both now and in the future, and the Total Cost of Ownership.

Members of staff currently use a range of models, which is expensive, difficult to manage, and does not provide the level of functionality needed by the company. You have also been asked to plan the implementation of the new laptops to all four hundred staff over the period of a month. You need to decide how this is to be done, identifying responsibilities, milestones, costs, etc. Make sure you allow for testing such that the chosen system meets your requirements, and allow for post-implementation evaluation.

PART A – The Weighted Scoring Model

(10% of this coursework)

Decide on a set of appropriate business-related factors and criteria to decide which netbook 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 laptop. 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

(20% of this coursework)

Use your spreadsheet model to compare and contrast the features of at least 4 different laptops, and decide on which one best meets the requirements.

PART D – The Presentation

(20% of this coursework)

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 laptop, 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

Skills: Excel, PDF

See more: working samsung, usability company, test plan manager, task project manager, selecting business plan, quality manager, purpose business plan, project management tutor, mark management, lenovo, implementation graphs, get business manager, presentation cost, graphs used, help excel spreadsheet business, gps price range, formatting business plan, excel specification, cost graphs, best graphs, new media group, excel mark, responsibilities project manager, pdf project management, international project manager

About the Employer:
( 0 reviews ) United Kingdom

Project ID: #4516238

15 freelancers are bidding on average $336 for this job

Amalgamltd

We are interested. Thanks

$526 USD in 30 days
(11 Reviews)
4.3
pablotorres

i can do it

$444 USD in 30 days
(3 Reviews)
2.8
ahmedhamdypop

Dear Sir, This is Ahmed Hamdy an Industrial and CAD Engineer for more than 8 years, I worked as R&D Engineer for 4 years, I can do this project in a very very short time with a high quality with the lowest price I d More

$277 USD in 0 days
(1 Review)
1.0
WritingDignified

Details are in PM.

$250 USD in 7 days
(0 Reviews)
0.0
conreswri

Consider it Done!

$500 USD in 5 days
(0 Reviews)
0.0
pratikindia

I can do your work.

$666 USD in 3 days
(0 Reviews)
0.0
alphaedge999

I am interested in this project.

$222 USD in 3 days
(0 Reviews)
0.0
xoriettechno

I can do your work.

$155 USD in 3 days
(0 Reviews)
0.0
designstudiouk

i can do this if you like

$515 USD in 30 days
(0 Reviews)
0.0
starchip

ten gracia de dios

$155 USD in 3 days
(0 Reviews)
0.0
RealSteel30

Hi, I am new around here, though would get your work done in a speedy and reliable manner. Thanks.

$222 USD in 7 days
(0 Reviews)
0.0
vk2tds

Great Project

$360 USD in 3 days
(0 Reviews)
0.0
trajcep

I am interested in the job.

$166 USD in 5 days
(0 Reviews)
0.0
sandanimendis

I'd like to apply

$277 USD in 10 days
(0 Reviews)
0.0
ssemakka

I'm ready to start this job.

$300 USD in 5 days
(0 Reviews)
0.0