• 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
  9. 9
    9
  10. 10
    10
  11. 11
    11
  12. 12
    12
  13. 13
    13
  14. 14
    14
  15. 15
    15
  16. 16
    16
  17. 17
    17
  18. 18
    18
  19. 19
    19
  • Level: GCSE
  • Subject: ICT
  • Word count: 4187

The aim of this project is to design a new system for anyone to use to model the cost of a trip. I have decided to manage a spreadsheet for the Head of History, who is organizing a Trip for Year 10 to The History Museum.

Extracts from this document...

Introduction

Introduction The aim of this project is to design a new system for anyone to use to model the cost of a trip. I have decided to manage a spreadsheet for the Head of History, who is organizing a Trip for Year 10 to The History Museum. This trip is important for the students because I feel that it will help them with their GCSE coursework. It will also give them an opportunity to research the part of history they are learning about and to find out about things they will be doing later. Other people that could use my spreadsheet are different schools and families. The new system I will design will be user friendly so that the user can be efficient. My new system will show all the information needed to work whether the trip is: * Making a profit or a loss. I will carry out other calculations to find the following: * Number Of Staff * Total number of People * Number Of Coaches * Cost of Coaches * Cost of Admission * Total Cost The system will include cell-referenced formulas so that if there are any changes the appropriate data will automatically change. Using the new system we will be able to make conditions to find out what amount we need to: * Break-even or make a profit. We will also be able to find out what effect a price fall will have on the profit. The current system is unable to do this because it will take a lot of time just to find out the results for one small criteria but with the new system answers to many criteria changes can be found instantly. What are the advantages of having a computer system? * Computers are precise. * Computers can work anytime. * It can be stored on various backups e.g. floppy disk, zip drive, hard drive, etc. ...read more.

Middle

* KEYBOARD - so I will be able to enter the characters via keystrokes and change case quickly. * MOUSE - to make moving from programs and selecting options much quicker and easier. * DESKTOP -the store of the CPU (central processing unit), backing store, programs, files, and documents etc. * PRINTER - to print out documents. * FLOPPY DISKS - to save work and to ensure documents can be transported from home and school. * 4.1 GB Hard Drive - to store the OP and software. E.g. Word. * Printer - to print out work. * Monitor - to view the programs on the system. * Pentium 2, 266 MHz Processor - Processes the information. The hardware I am using is sufficient to run word and excel. Other people and schools have this hardware; therefore the user will recognizable it. There are various ways of entering the information onto a computer so that the data can be processed or stored. I have chosen the one below: * Key-To-Disk - This is typing the data onto the computer using a keyboard, although this isn't expensive and is easy to use, it does take quite a lot of time and errors are often caused by this method. But still, this method is practical and simple and can be used for our system. Data Collection and Input The data I have collected Are: * The number of pupils - this was found by sending and receiving letters from parents asking for a deposit if they are interested, and phoning them to double check * Coach Price - I rang different companies and went online to find the coach with the best value for money. * No. Of seats in a coach - I rang different companies and went online to find the coach with the best value for money. * Admission price - I rang the Museum and went on the Internet to find the cheapest price possible. ...read more.

Conclusion

This also proves that my prediction was correct. Before After Changing the student/teacher ratio from 8 to 20 had an effect on almost every column. As the Student/Teacher ratio was higher the profit/loss column changed, the profit/loss column had more profit than before, this is because there are less teachers needed, which means less people would have to come. The following also change if there are more people coming: Cost Of Coaches Admission Cost Before After From this, I can see that my spreadsheet works. Evaluation In my opinion, this assignment has been a very successful one. I met the user's need, which was my original and main target; I also obtained the results I expected. These needs were met with a sufficient amount of detail in the time allocated. I was satisfied with the way in which my spreadsheet was set up, and with the variety of formulas and functions that were related to the work. These functions allowed me to set the spreadsheet to calculate data automatically in most cases, which is essential as it makes calculating the cost of a trip quick and efficient. In the specification part, I wanted the system to be able to calculate the profit and loss. I also wanted the system to be user friendly and organised. I believe I have met the specification target. I think that I could have improved my spreadsheet by making it more accurate in certain aspects. For instance, I could have got real data like found the actual cost of a coach, this would have made my spreadsheet more accurate. If I were to do this project again, I would perhaps choose an overseas location, like France. This would provide a greater challenge, as there would be different column headings dealing with conversions of pounds Stirling to french currency/Euros, etc. Overall, I have found this project a very motivating and fascinating one. I am proud to say that I have met the user's needs, and thus have met the main target set out at the start of this project. 1 Sachin Shah ...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. Marked by a teacher

    Planning- design a memo, letter and webpage for Capital FM.

    4 star(s)

    Notepad is very easy software to write with as it specialises in writing documents. The problem with notepad is that you can not really get a good design with it and it does not have a macro fill-in feature. We also could use the paint program to design out templates.

  2. GCSE Excel Project ICT

    Droplet size 3 Pl (minimum) with Variable-sized Droplet Technology Ink system Epson DURABrite(tm) Ultra Ink Print resolution Up to 5760 x 1440 optimised dpi on suitable media using RPM (Resolution Performance Management) Print speed Black text A4 Up to 37 ppm (Fastest), 25 ppm (Business quality)* Colour text A4 Up to 20 ppm (Fastest), 11 ppm (Business quality)* Photo 10x15 cm Approx.

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

    You can use the platform of Facebook's liking or becoming a fan feature to make friends with people with similar interests. You can even find out who in your current social circle likes similar things as you, thus providing the chance for a 'friendship' to blossom.

  2. Use of IT in schools

    13th September 2002 Spoke to Rosie Sinden - Evans in the Learning Resource Centre in the Trent Park campus of Middlesex University, about analysing them for the project. She also said that the university would be willing to participate. 16th September 2002 Searched the internet for websites related to "Uses

  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. Creating a computer system for a video rental shop

    fine reports Requesting report Videos out report Tables The tables are linked together to make a relational database. The tables are linked by means of a common field. One of the common fields must be a key field and the other is known as a foreign key.

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

    Disadvantages (How it does not meet Sarah's needs) The computer does have a few faults though. To do a lot of the things the computer is capable of, you need access to the internet. Without the internet, a computer's abilities are quite limited.

  2. My presentation is about work experience and advice on work experience its audience is ...

    I used it because it's uncomplicated for regular users like me to use because I frequently use and research on internet and I have got used to using internet explorer. Microsoft windows movie maker: I used windows movie maker to make the video that goes in my presentation.

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