Unit 9 (Microsoft excel) example
Creating a design
Purpose/ user requirements
The purpose for my spreadsheet is to tell the user the prices and the benefits of buying a season ticket for your favourite football club and it will allow you to enter your information to buy your season ticket. The user requirements that my spreadsheet should meet are, it should be expected to manage the ticket prices and tell them how many have been sold and for at what price, it will also tell you what seat the buyer has chosen in what part of the stadium and what row and seat number they have chosen, if the seat the user has chosen is already taken it will come up with an error message telling them that the seat has already been taken, they can then choose another seat, it will also tell you the prices for different ages as well as telling you the total price for it all,
What you get for buying a season ticket
If you buy a season ticket you will be able to enroll onto the Auto Cup Ticket Schemes during Season Ticket renewal. The Club will again allow Season Ticket Holders the opportunity to enroll onto the Auto Cup Ticket Schemes alongside other Season Ticket Holders and select an alternative seat to their usual Premier League Seat
Question |
Drop down (text or numbers) |
Description |
What block and row do you want to sit |
|
Enter what seat allocation you want (shown on map of stadium) |
How old are you? |
|
Age to work out prices |
Do you have any disabilities |
|
If you have disabilities you will get a discount |
Select the date you need |
|
|
What type of ticket do you want? |
|
|
Do you want multiple tickets? |
|
|
Name (first and last) |
|
|
Address |
|
|
postcode |
|
|
Phone number |
|
|
Title (Mr,Mrs,Miss,Sir,Master) |
|
|
