Year9unit2PhoneMoney

=Unit 2 Phone Money=

You have designed two phones for you phone shop and now you need to set up a model ion excel that will tell the customer who visits your shop what phone package is the best for you.


 * ==[[image:bmisclass2009/bag_of_money.png]]== || [[image:phone.gif]] ||  ||
 * ==[[image:bmisclass2009/bag_of_money.png]]== || [[image:phone.gif]] ||  ||

 How to choose the right mobile operator tariff ?
Do not answer this until you have fully completed skills learning. The skills learning involves setting up the School hall booking system and a teacher led skills session for 2 periods.

Design Brief
Create a model that calculates the best phone deal for the customer. 6 customers will come into the shop and give you their average phone usage per day. From this information tell the customer what phone package they should buy based on price. They will have a choice of 4 packages.

Design Specifications
Tariff calculator page in MK
 * 1) You will have 4 different packages to offer called Bingo, Ringo, Galaxy and Saturn.
 * 2) You will ask the customer 9 questions about how they use their phone
 * 3) Do you want prepaid or monthly billing
 * 4) How many test messages do you send between 7 and 4 on average per day?
 * 5) How many text messages do you send after 4 on average aper day?
 * 6) How many voice calls in mins do you make on average per day between 7 and 4?
 * 7) How many voice calls in mins do you make on average after 4?
 * 8) H0w many minutes of international calls do you make on average bewteen 7 and 4?
 * 9) There is no monthy rental charge for Bingo and Ringo as both of these packages are pay as you go
 * 10) Galaxy charges 10,000Mk per month and Saturn charges 30,000MK per month as these are bill calculated phones
 * 11) Your model will look something like the model below but you do not have to follow the below model.
 * 12) Then you have to set it up so that when customer 1 comes in and tells you how often they use thier phone based on the
 * || ==Bingo== ||  || ==Ringo== ||   || ==Galaxy== ||   || ==Saturn== ||   ||   ||
 * ===1 Prepay or Monthly=== ||  ||   ||   ||   ||   ||   ||   ||   ||   ||
 * ===2 text 7-4=== ||  ||   ||   ||   ||   ||   ||   ||   ||   ||
 * ===3 text after 4=== ||  ||   ||   ||   ||   ||   ||   ||   ||   ||
 * ===4 voice 7-4=== ||  ||   ||   ||   ||   ||   ||   ||   ||   ||
 * ===5 Voice after 4=== ||  ||   ||   ||   ||   ||   ||   ||   ||   ||
 * ===6 International l7-4=== ||  ||   ||   ||   ||   ||   ||   ||   ||   ||
 * ===7 International after 4=== ||  ||   ||   ||   ||   ||   ||   ||   ||   ||
 * ===8 Internet 7-4=== ||  ||   ||   ||   ||   ||   ||   ||   ||   ||
 * ===9 Internet after 4=== ||  ||   ||   ||   ||   ||   ||   ||   ||   ||
 * ===9 Internet after 4=== ||  ||   ||   ||   ||   ||   ||   ||   ||   ||

Skills learning
Tutorial on the booking system Teacher led in groups to introduce the new formulas.

Design
Design the layout of the front page taking ideas from you investigation of phone companies in the UK. Orange and Vodacom

Planning
Plan your time management well. Make the deadline. When is the first deadline? When is the final deadline?

Creation
Make the model and make sure you test it according to the testing plan The model will have 2 pages ONe the customer will see and the other will be the mechanics behind it all

Evaluation

 * Product Number || Name || Description || Order || Mim qty || Reorder qty || Quantity in Stock || Stock || ORDERS ||

Some useful website [] [|http://www.vodafone.co.uk] @http://www.orange.co.uk