• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
Page
  1. 1
    1
  2. 2
    2
  3. 3
    3
  4. 4
    4
  5. 5
    5
  6. 6
    6
  7. 7
    7
  8. 8
    8
  • Level: GCSE
  • Subject: ICT
  • Word count: 3194

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

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related GCSE ICT Systems and Application essays

  1. Different types of technology How I use ICT at home and at school

    3A Conclusion Overall, Facebook can be a good medium for connecting with old friends, new friends and current friends but it also makes you too dependent on this medium. It makes you rely on it too much, takes away your real social life and makes you addicted.

  2. GCSE Excel Project ICT

    On the computer itself, the administrators account (system administrator) will be hidden and encrypted with a password. The guest account will be turned off and the main account that will have the file active will password encrypted also. Design (9 marks) Initial designs of worksheets sketched out. The initial designs mentioned will be inserted after this page.

  1. The use of ict has changed the way in which people work. Explain the ...

    These might include sensors, light and heat sensors. Third generation-These are the latest robots under development in research laboratories that can 'learn' on the job. Robots operate under artificial intelligence software and can adapt and reason with the incoming data to improve their performance.

  2. The Advantages of Using ICT Over Manual Meethods. Using Paint and Access.

    Create letterhead To make a letterhead first you insert your slogan and logo wherever you want then you type in the address where want it to go then you type in the postcode. Create template letter To create a template letter first you then you type in everything and put dots in the personal information e.g.

  1. a level ict project

    to the most sensitive information, while the lower staff will be given access applications they need to perform their job. Furthermore, the business doesn't possess a particularly strong purchasing power, meaning that it doesn't have the financial strength to purchase expensive equipment, hence the small budget that has been presented to me.

  2. System requirements analysis

    Here is a screen shot of the Patient's records. It has the patients medical no., name, address, doctor, etc. the concatenate fiction is also here. These records (including the concatenate function) are all needed in the appointments page. The name, date-of-birth, etc is, unmistakably used in the appointments page, but the concatenate function is not.

  1. Creating a computer system for a video rental shop

    because they look less intimidating than tables and require less work on behalf of the user as they can have buttons on them to take the user to and from different forms and menus. Each form will have a title to identify it to the user.

  2. The impact of ICT on a person with special/particular needs

    If something does happen to the dish, Sarah would need to call professional help as she is in no shape to fix the satellite dish herself. Summary of advantages * Sarah can keep in touch with real life as she doesn't go out often * Sarah's use of her television

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work