• 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
  • Level: GCSE
  • Subject: ICT
  • Word count: 2562

Budgeting for a trip.

Extracts from this document...

Introduction

GCSE ICT Project MS Excel Budgeting for a trip Eliana Tacconi 10c2 Part 1-Identify Statement of the Problem My friend Thomas Edmondson and I are planning a trip in the summer holidays to Bologna. We need to work out the different costs for accommodation, food, transport and amusements. The user for this will be Thomas Edmondson. I am going to do this in a system because it would be difficult to work out the costs and keep it all in order in a written document. Using this system will allow us to work out our budget and sort everything efficiently. Consideration of Alternative Solutions There are some different ways in which this problem could be solved. 1. We could write and calculate everything by hand, this is the method we were originally using but we need a better system. 2. A special program could be written to do this. This is time consuming and I do not have the right skills for it. 3. I could use a database package. Each person's budget and expenditure could be stored but this isn't as well suited to the requirements as some of the other options as it would be difficult to do calculations on here. 4. A spreadsheet could be used. Separate worksheets can be used for accommodation, transport, food and amusements. Chosen Solution I am going to use a spreadsheet because: 1. If prices or budget changes the spreadsheet can be easily edited and any related figures will change automatically. ...read more.

Middle

the cheapest) is displayed on the user's screen Output The output for the system will be that the system is displayed and used on screen. It could be printed out but if this were done the system wouldn't be able to calculate the options. Backup/Security Strategy The computer file containing the final system must be backed up onto floppy disk. This copy should be kept at a different location from the computer in case there is a fire, theft or flood at the premises. A backup copy needs to be made each time the system is updated. There should be password security on the computer so that people using the system cannot change any of the formulae. This can be done by protecting the worksheet so that nothing can be changed without a password. If anyone attempts to make a change to the worksheet Excel will ask for a password. The password should be at least six characters long and not a common word that could be easily guessed. Part Three-Design Initial Designs I drew up the following initial design system: The spreadsheet will calculate the cheapest deal on the figures that we input. The information for each section is stored on a separate sheet. Each of these sheets contains tables of formulae, which will calculate the cheapest deal. The system will then sort the table of figures by 'total bill' and perform the lookup operation to post the result back to the entry form for the user to see. ...read more.

Conclusion

Test that tables are correctly sorted. Input data 100, 25, 10 Expected result I only had two problems, a spelling which was corrected, and I couldn't enter the password on the school computers so I sent this home and entered it there. Part 5-Evaluate Evaluation of Initial Objectives The system has a bright user interface, displays the information within three seconds and handled all of my figures efficiently. The system didn't incur any additional hardware or software costs. The system has five different sheets, showing accommodation, transport, food, amusements and a data entry screen. Tom said that the system was easy to update, he found it easy to use and he thought that it was accurate. All figures were rounded to two DP and I used validation, a macro and a drop down menu. All of my objectives from my user requirements have been achieved. User Feedback Tom was quite pleased with the spreadsheet and said that I fulfilled the requirements well. He also said that different people had different budgets so this was difficult to solve, we just added everybody's budgets together and entered this but Tom said it would have been good if we had thought of a different way. His letter is shown below Suggestions for Improvement To improve this system I may have devised an individual system for each person so that their budget wasn't a problem, as some people could afford what others couldn't, I would then incorporate all of this into a bigger system. I would also try to present the system better by removing the gridlines, using more colour and adding pictures of the different options. ...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. GCSE Excel Project ICT

    This is the new version of the macro: Sub FINALFINALFINAL() ' ' FINALFINALFINAL Macro ' Macro recorded 06/10/2008 by BVGS ' ' Workbooks.Open Filename:="F:\ICT\EXCEL\Backup.xls" Sheets("Sheet1").Select Sheets.Add Windows("Xl0000000(1).xlsm").Activate Range("=1:1048576").Select Selection.Copy Windows("Backup.xls").Activate Selection.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _ SkipBlanks:=False, Transpose:=False Selection.PasteSpecial Paste:=xlPasteColumnWidths, Operation:=xlNone, _ SkipBlanks:=False, Transpose:=False Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Application.CutCopyMode

  2. System requirements analysis

    For example, if I change the date to 26-09-06, then the day will also change. The time will not change, as it does not work according to the day and date. If I change the drop down menu with the surnames, then the first name, the date-of-birth, the patient's number, their postcode and doctor will all change.

  1. Database design.

    Number Number 11 No Table Video Entity Types Description Data type Length Key Validation Input Masks Combo box Video_ID ID Number Number 4 Primary >9999< No Video_Name The Name of the film Text 25 >C<???????????????????????? No Video_Category The Category Thriller,horrer,Romantic Text 20 Yes Video_Cert The certificate U,12A,PG,15,18 Text 20 Yes

  2. Benefits of using my IT system in the Travel Agents.

    * Additionally, you can rename the name of your table and by that name it will be saved. * Furthermore, you click on Subscription Start/End. * Finally, you click on Input Mask and type in (00/00/0000;0;). Using input mask (post code etc.) * First, you should go on Microsoft Access.

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

    Facebook has become a web of socialising. The need to socialise outside of the virtual world is eliminated and whether that causes a negative or positive effect on our current generation is shown directly by how it has affected me personally and my social life.

  2. In this (2b) report I am going to investigate software application, Input and Output ...

    that are appropriate for the operator's language. Other keys can produce actions when pressed, and other actions are available by the simultaneous pressing of more than one action key. MOUSE- In computing, a mouse is a pointing device that functions by detecting two-dimensional motion relative to its supporting surface.

  1. Design Section

    7 = statements on Extras Page Number = statements used = statements on Total Costs Number = statements used = statements on Delivery Page Number = statements used = statements on Delivery Page Number = statements used Just an appropriate system The software I shall be using to complete these tasks shall be Microsoft Excel.

  2. ICT PROJECT

    to support student, which need help, whether parents need contacting, whether other action is required e.g. Detention. * The system should automatically calculate the percentage and grades of each student. This system will therefore make her work more accurate and easy to use.

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