• 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

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

# Related GCSE ICT Systems and Application essays

1. ## ICT PROJECT

There is a print, which is used to print the currently displayed report. The macro buttons are not printed. I did this by un-checking the print object option in format control. Macro Code These are the macros I used on chart summaries.

2. ## GCSE Excel Project ICT

different formula-wise is a modification to the cell selection, but apart from that, the basic gist of it is already done on sheet1. The formula, which has a slight modification, is the formula which VLOOKUP's the information for the Wi-Fi: =IF(Sheet1!B16=0,"Not Selected",VLOOKUP(A11,FinalTBL,2))

1. ## Benefits of using my IT system in the Travel Agents.

* After that, click on Microsoft Office. * Then you click on All Programs. * Finally you click on Microsoft Word. Create letterhead * First, you should go on Microsoft Word. * Then, you should click on Insert. * After that, you should click on Header and Footer.

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

Because a barcode reader merely captures and translates the barcode into numbers and/or letters, the data must be sent to a computer so that a software application can make sense of the data. Barcode scanners can e connected to a computer through a serial port, keyboard port, or an interface device called a wedge.

1. ## Design Section

I will make my east instructions by using comment boxes + input + output messages. * What the solution needs to be like - Microsoft Excel will allow me to complete the solution to what it needs to be like because I have all the things to make it such

2. ## ICT AT HOME AND AT SCHOOL

legible format that she can read and understand, helping her to read my essay quickly, instead of trying to read my hand written (Evaluative comment made) document, that looks untidy as reading it is made impossible by the amount of rubbing out and re-writing I have had to do because I wanted to insert text and pictures.

1. ## System requirements analysis

CRTs also emit electrical, magnetic, and electromagnetic fields, which are harmful for not only the patients but also the receptionist. It may also interfere with hospital equipment. The next output device that I shall be discussing is the printer. There are three types of different printers and I shall be discussing advantages and the disadvantages of each one of them.

2. ## a level ict project

IT knowledge, he recognises the functions of Microsoft Word, Excel, however, he is yet to gain effective know how of software applications, e.g. Microsoft Access. As for his employees, they have next to no computer literacy, which is one of the reasons why they are doing manual, blue collar work

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