• 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

    me to not be active and just be on the computer all day. It makes me think I'm being social when in reality, I'm sitting on my backside spying on people without their knowledge by going through their Facebook statuses, walls etc.

  1. GCSE Excel Project ICT

    and printed three times (Objective 2) one for the customer, one for the accounts and one for the computer construction. Analyse (9 marks) Appropriate Software identified The software being used is part of the Microsoft Office suite (Microsoft Access and Microsoft Word and Microsoft Excel)

  2. GCSE Calculator Project

    Decimal Place Allow for decimal place to used in a number eg, 35.6 and then allowing the calculation to continue Hide/Show Buttons Hide - remove memory key pad Show - replace memory key pad It should work Help Option Hovering of mouse should bring up a comment or show help message in a text box.

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

    * The orders have got to be sent through to the supplier of the books through an order sheet, which she has got. * There is a certain amount of research done in the way of seeing what are the more favoured genres in the school and then choosing more books of this type for the pupils to read.

  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.

  1. Creating a computer system for a video rental shop

    This type of a daily back up is called a differential backup. This will insure that the majority of customer's orders will not be affected and therefore the company will not lose customers. The regular backup should be made to a floppy disk, there should be a floppy disk for daily back ups done on Saturdays, Tuesday s and Thursday.

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

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