• 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. Different types of technology How I use ICT at home and at school

    What Facebook essentially does is make you think you have a social life and makes you depend and become addicted to Facebook using this illusion of a social life. It becomes addictive, distractive and hard to stop using. It distracts and causes me to procrastinate on my work and causes

  1. GCSE Excel Project ICT

    there are many other programs that could substitute for the MS Suite, but we use MS Suite because it is easy-to-use and is the 'typical´┐Ż choice of program to use. Excel will be used for the invoice function, which will enable the customer to select the parts and put them to order.

  2. This project is designed to help non-computerized library to easily keep track of their ...

    After the book has arrived librarian will calculate the total money and will cut the book from the stock list. The stock file and the Books Master File are updated. E.g. more barcodes of the book is written * There should be use of paper and pencils extensively and there should be vast amount of paper and pencils.

  1. GCSE Calculator Project

    It should work Backspace After inputting an equation, the pressing of backspace once should delete the last number inputted. Negative Number Button(+/-) Putting a negative number into the equation and trying to add to it a whole number. See if negative number is recognised.

  2. Use of IT in schools

    But why is this? There are several reasons: * ICT combines the full range of media through which successful learning takes place: sound, picture and text, as well as the ability to repeat. * Teachers are able to do things they were not able to do before such as visual

  1. ICT PROJECT

    -------------------------------------------------------------- -------------------------------------------------------------- 2. What type of system do you use for your mark tracks? --------------------------------------------------------------------- --------------------------------------------------------------------- 3. What method do you use to mark your student work? ------------------------------------------------------------------- ------------------------------------------------------------------- ------------------------------------------------------------------- 4. Do you compare boys and girls performance ----------------------------------------------------------------- ------------------------------------------------------------------ ----------------------------------------------------------------- 5. Do you analyse your students performance ---------------------------------------------------------------------- 6.

  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