Creating a travel planning ICT system
Extracts from this document...
Introduction
Analysis Year 11 project Background knowledge In this project I will be creating a system to help plan the costs, amount of people and which people are going on the overnight trip. Here you will be taking the role of Sana, who is helping her French teacher (Mr Campbell) work out the costs of the week long French trip as he was experiencing some difficulty. On a day to day basis Mr Campbell has to create a letter about parent evenings for the trip, permission slips, dietary and medical requirements and remaining money. He also needs to work out the total in goings and total outgoings and make sure that the school doesn't make a loss but doesn't need to make a profit. He will also need to create a record of data about which pupils are going and aren't going and how we will put this in and use this to help create letters As Mr Campbell was experiencing some difficulty working out the costs using a calculator and paper and you had suggested that you would create a system that helps him work out the cost very easily and is a very user friendly design (maybe a user guide to help those who find this system hard and need some help) and you should ensure that anybody with little knowledge of computers is able to change certain amounts e.g. ...read more.
Middle
I will be listing there advantages and disadvantages to help me to decide which one is more appropriate and suited to this task. Microsoft word is good because * can insert picture * can insert text * can make text boxes * can change colour, background and type and size and justification of text * can change colours etc of background * can insert tables to display data * can insert diagrams You can also do many other things with Microsoft word sop it would be a good program to use but I don't have as much freedom with the text etc then what I would have with another program in which I am able to do many more things. Paint is a good program to use because * I have a lot of freedom within this program * Can create my own lines and shapes and copy and paste parts easily * Can insert text boxes Microsoft paint also has many other good points but I still think I that this program isn't the most ideal because: * I don't now how to make it fit the whole page * Cant use word art, would have to copy and paste it There are also more problems with it and they wouldn't really influence my decision as I think that using paint is already to tedious from the above two problems so it isn't the most desirable solution. ...read more.
Conclusion
testing is needed. For sub problem 4 (letter) testing is needed. Performance criteria's Performance criteria sub problem 1 Must be able to merge cells Must be able to use formulas Must be able to do auto sum Must be able to do conditional formatting Must be bright Must be colourful Must have an interesting but easy to read font Must be able to make IF statements Must use absolute cell references Must be able to work out total income Must be able top work out total outgoings Must be able to work out the balance All the text will be aligned left It will be in times new roman It will have a font size of 12 In the title there will be a picture of the Eiffel tower The text must be in blue The title will have a blue background and white text. All titles must start with a capital letter. I will be using this to decide on the venue depending on how the transport costs It has to tell me if the trip can go ahead using an if statement It should fit onto one page I should ensure that there isn't a loss made I should be able to work out the minimum amount of people and use this in conditional formatting I should be able to limit the amount of people by using data validation I must be able to make a complicated IF statement Must be able to work out total costs Must be able to work out single costs e.g. ...read more.
The above preview is unformatted text
This student written piece of work is one of many that can be found in our GCSE ICT Systems and Application section.
Found what you're looking for?
- Start learning 29% faster today
- 150,000+ documents available
- Just £6.99 a month
