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

Spreadsheet Report

Extracts from this document...

Introduction

Spreadsheet report 1) describe what the user needs The purpose of my spreadsheet is to model the cost of a Limo hiring service. The limos can be hired on a daily basis for a minimum of a day and a maximum of two days there will be a discount for a hiring the limo for more than �50 the discount will be 5% and if the client has hired more than �100 than they will get 10% discount. This means that when it is finished you will be able to see when a limo is being hired, on what date and how long for. Describe the data needed For my spreadsheet to be successful it needs to have the following data: * Hiring costs * Details of limos * Details of customers * Prices * Discounts 3) Describe the worksheets, formulas and functions you plan to use I will collect data from the Internet due to the range of sources and data available. I will collect data from theses websites: * www.limo.org * www.limos.com * www.limospros.com Worksheet 1- Limo Details Column Name Description Format 1 Registration Registration Number of Limo General 2 Limo name Name of Limo General 3 Cost per hour Price per hour Accounting 4 Seats How many seats Number 5 Booked How many times been booked General Worksheet 2- Hirer Details Column Name Description Format 1 Hirer Name Name of Hirer Text 2 ...read more.

Middle

* Click on format * Go to column * Click on width and * Finally a window should appear, and then you can change the column width 6) Once I had everything saved in my folder, I then began to insert data which was needed for the boat information. * First I typed in headings for the worksheet; I then highlighted them all and formatted them to be bold. This was so that the titles stuck out from everything else. * Then I began to insert data into the worksheet in the correct headings that it was needed for: Registration, Limo name, Cost per hour and Seats 7) I changed the format of the cells by. * Right Clicking any Cell * Clicking on "Format Cell" * format Cell window should appear * Then e.g. click on Number and change the format of cell to Time And * Finally click on ok and the cell is formatted. I also added border, patterns and changed the alignment. This is how I done it Border: * Highlight where you want a border * Click on format * Click on cell * A window should appear * Click on Border and * Choose what kind of border u want * Then press ok Here is an example I completed the same for patterns and alignment. ...read more.

Conclusion

This result is also shown in the print off at the back of this report. 8 Sort at least one worksheet into a selected order I decided to sort the data in order of my choice in one of my worksheet. This was the "Hirer Details" worksheet. Here is an example o f how I did this. * Highlight the cells you want to sort * Click on Data * Click on sort * A window should come up * Choose how you want to sort the data: ascending / descending Here is some screenshots how I done it. Here is the Result 9 Describe how you ensured that your work was accurate and safe I kept backups of my spreadsheet report on floppy, on lgfl, on my h-drive and on my computer at home. Here is a screenshot of the file being sent to floppy Here my work is on floppy. Here is a screenshot of the file on my home computer. Here my file is on lgfl To make sure that I didn't have any errors on my work I proof read my work and did a spell check. I also did a spelling and grammar check. I made my work accurate, I checked all the formulae I used and they were correct. I checked all my formulas my clicking on tools then on options, clicking on view and selecting/ticking formulas. ?? ?? ?? ?? ...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 Software 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 Software essays

  1. Spreadsheet Technical report. My task was to produce a grade book for primary ...

    Step 13 I then added another column to calculate the total number of merits. I did this by: 1) I high-lighted the cell I wanted the formula to be in, and typed in an equals sign. This tells Excel that I want to write a formula.

  2. AQA GCSE ICT Specification B

    Drop down boxes must show every option, and not be hidden by other boxes. This is to ensure entering correct data is as easy as possible. 10. Receipt and Delivery Note must include all relevant data. The user and customer must be able to access the information they require.

  1. Logo Report

    The plane image stands out because the wings extend out of the silver circle. The "A" is very bold because of it's large size and it has a beautiful shape. This logo is very compact and attractive. Ryan Air is an Irish Airline company who specialise in cheap flights.

  2. Research, collect and describe graphics

    Impact: Gives the advice endorser's name - in this case RAC (a big name in terms of car tips, insurance, etc...), increasing the probability of a person clicking. The isolated region makes the viewer question themselves if they were in such a situation. Size: Small - does not restrain bandwidth.

  1. ICT BTEC UNIT 2 - REPORT

    one of the strongest security systems in all of the operating systems in this table. Disadvantages for Linux are as follows: it takes a long time to learn which could be seen as a disadvantage because people want things instantly now days.

  2. Payments Spreadsheet task. - formulas and fomatting

    In order for me to workout the average amount per month the function which I used was AVERAGE. For the running total per pupil, a formula is used to workout the amount a pupil has paid throughout the months except December and the running total keeps a record of the

  1. Software Report

    It includes many features, however, I will not be using them all, below is a brief description of what each of the programmes I'll be using does: * Office Word - a word processing programme * Office Excel - a spreadsheet that also has abilities like a database * Office

  2. Spreadsheet. This coursework is based on the work of a spreadsheet, which is ...

    Furthermore, when it comes to 'seasonal sale' time, the manager has a very difficult time putting products on sale. He would have to calculate what percentage less he could make it so that he wouldn't lose too much money. He had to calculate how much he could take off to make his outcome 'break even' or gain 'profit'.

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