• 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)

    out you can rub the pencil out and write in the text. The problem here is that the rubbed out work can look messy and unprofessional. A non ICT solution for storing the documents is that you could store all of these documents in a closet or in a filing cabinet instead of the computers memory.

  2. Financial Model to help organise the year eleven prom

    In reply I found out that * To be able to model various scenarios in order to work out break even point * To be able to let pupils know the final price of an individual ticket as soon as possible, so they can then begin to save for things such as limousines and tuxedos.

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

    It gives me the opportunity to have contact with people I usually wouldn't. Facebook has often been criticised as a place where privacy is too easy to be broken. However, I can limit what exactly Facebook can show of mine to my friends using the privacy options and thus stopping people from seeing things I don't want them to see.

  2. ICT Project 1A

    Their second single, "Schrei" ("Scream"), climbed to the #5 position in the German charts. Their debut album, Schrei, was released on 19 September 2005; the album later received a platinum certification [4]. All songs were written by hired song writers, but Bill Kaulitz, the band's singer, brought in some ideas.

  1. ICT PROJECT

    * It is very time consuming, especially the calculation of percentages attained in marked worked and grades obtained overall. * As the names of students are not in order she finds it difficult to find the student to record a mark.

  2. GCSE Excel Project ICT

    it saves (in a separate file), prints the order (to be given to Alex), resets the forms, saves and closes. The file is going to be reused repeatedly for multiple customers. At least 3 Quantitative objectives THESE MUST BE CHECKED BY YOUR TEACHER.

  1. Database Design Guideline

    For example 'Doctors ID' witch will be common in both tables in my database. Then on one of the two tables I will have to click on the 'Doctor's ID' and drag it to the other table where it says Doctor's ID and, then I can find any other relationship if so between the two tables.

  2. ICT Coursework (MarcoS)

    * On the second combo box, the one below "Project Location", for: Input Range: First, as in the picture above, click on the button . Then open the projects worksheet, and select the first location in the list, then click and hold the shift button on your keyboard and select the last location on the list and then press enter.

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