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

    Following that, I then created the formula which told me whether the pupil had exceeded or met their target or whether I needed to inform their parents. Again, I had to complete another nested if function; I followed the same steps as before, only changing the formula.

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

    The modification/corrections highlighted above should be incorporated in the next review. Best of Luck. Regards. Syed Mr.Hussaini. Design I started by an initial design of the menu by hand on an a4sheet of paper. So now I am going to modify it by using Microsoft publisher as my design maker and also considering the user comments.

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

    The implemented spreadsheet will be simple to use, so that any member of staff can record any events, and that at the end of the month, the VAT file can be edited and printed into use. As well as this to simplify the spreadsheet for the user and make it

  1. User Documentation

    change the colour of the forms 1, As an example, we are going to use the main menu. First of all, you need to go to the main menu. We are going to change this blue colour. 2, After you have got to the Main Menu, you need to click

  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