• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  10. 10
  11. 11
  12. 12
  13. 13
  14. 14
  15. 15
  • Level: GCSE
  • Subject: ICT
  • Word count: 572

a spreadsheet for a school trip

Extracts from this document...


User Documentation I have created a spreadsheet for the school residential trip to Paris. I have written simple instructions on how to use the spreadsheet. The instructions consist of many images from the spreadsheet, which makes it more understandable. To access the spreadsheet, click on My Documents on the desktop. The School Residential Trip spreadsheet is very easy to use. There are five worksheets within the spreadsheet - a main page, pupil data page, medical page, payments page and a graphs page. You will see blue buttons on every worksheet. These blue buttons are macro buttons. A macro button consists of a series of instructions that are grouped together as a single command to a carry out a task automatically. ...read more.


An error message will appear if you try to do so. You may only edit a pupils' details by clicking on the Edit Pupil Data button (see below). The worksheet contains information on all pupils attending the trip. Information such as the name of the pupil, tutor group, date of birth, address and telephone number are included. When you click on a Print button, you will be taken to a Print Preview of the page you are currently on, which will look something like the one below. This is what the page will look like when it has been printed. This is what the Edit Pupil Data form (as mentioned before) will look like. ...read more.


These include the Main Menu button, Print button, Medical button, Sort By Surname and Sort By TG button. The only cells you will be typing in are coloured light turquoise. Every other cell is protected so you are unable to edit or delete any information. Here is an example of a completed payments table. Notice that payments are not paid in every week. Payments do not have to be paid in every week, just as long as by the end of the seven weeks, the pupil must have the full amount of �49. This is the Graphs worksheet. You can only use the buttons on this sheet. By now, you should be familiar with the Main Menu button, and the Payments button. ?? ?? ?? ?? Joanne Lee User Documentation Page 2 of 15 User Documentation Page 15 of 15 ...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. Design a spreadsheet that can be used by a school tuck shop.

    that you can compare last weeks product number sold to how many you sell the following week. Creating the wages spreadsheet Create a new spreadsheet and name it WAGES.This part of the spreadsheet is for one employee. Beneath this I have copied and pasted it again but changed the details for another employee.

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

    To turn all the values in this column into percentages, I high-lighted the values and clicked the percentage button in the top right-hand corner of the toolbar located at the top of the worksheet; this then converted them into percentages.

  1. Publisher. My fathers friends name is Mr. Hussaini, as his restaurant has just opened ...

    Here are some of the backup devices that can be used: 1. Floppy discs: since floppy discs are small and portable, data can be easily transferred from one computer to another, this is an advantage but as they do not have a very high storage capacity, they are seldom used for backup.

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

    Error messages should be helpful as well as user friendly. * As well as calculating the profit and loss it will also identify to the user whether the company is low in stock of an item. Error messages when impossible data is typed e.g.

  1. User Documentation

    As before, you can click the macros on the right hand side of the page to either save and go back to the menu, or save and not go back to the menu. 4, If you click on 'Back to Menu', you will appear back at this screen: How to

  2. computerised spreadsheet for pupil attendance data

    The packages cannot do any calculations so this is not the kind of package I need as it is too one sided. DTP (Desktop Publisher) is a package which produces high quality design work e.g. leaflets, posters, flyers etc. This package is not applicable to this project as it cannot

  1. In this project I will produce a spreadsheet for a successful and potential company

    and to put data into a chart to visually illustrate the relationship between different items. The research I will need to conduct is information about the sales services of the company. I will find out the information by interviewing the manager josh brown.

  2. Produce a spreadsheet for a successful and potential company

    * You can also produce graphs from the spreadsheet. These are more accurate. * You also save a lot of time as computer are more effective. I will set this spreadsheet up by using Microsoft excel. This is a software package that allows you to create financial spreadsheets and reports

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