• 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

    Service Pack 2 (2600.xpsp_sp2_qfe.070227-2300) Print technology Printing method 4-colour inkjet printer with Dual Black Ink System, Epson Micro Piezo(tm) print head Nozzle configuration 360 nozzles Black / 59 x 3 nozzles Colour (cyan, magenta, yellow) Droplet size 3 Pl (minimum)

  1. Use of IT in schools

    Found some information, but nothing extremely useful. 25th September 2002 Contacted Holy Trinity primary school in East Finchley about using them in the project. The principal regrettably said that she would not be able to allow me to study them, due to other commitments. 4th October 2002 Drew up a questionnaire for the students of Middlesex University to answer.

  2. a level ict project

    Moreover, consistency must be in place to allow users to remember the layout more easily, so that the learning curve of the system becomes steeper as the user employs the system more often. The security of the data is essential, due to the large amount of sensitive data regarding customers and their vehicles.

  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

    This makes Sarah feel quite frustrated as she isn't fast enough to keep up with the rate her thoughts are pouring out onto the word processor. Also due to her motor-difficulties, she might find it hard to point at words quickly, even with increased text-size.

  1. 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.

  2. ICT car insurance quotation System Coursework

    I then clicked on that macro and pressed o.k. I then right clicked on my macro button And clicked edit text. I named the buttons suitable manes, like "View Quotes." Adding the User form: To add the user form to my system I loaded Visual Basic Editor by clicking Macro on the tools menus.

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