• 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. computerised spreadsheet for pupil attendance data

    My friends teacher asked for a number of requirements to be met, they are as follows: * Dave needs to use a spreadsheet to keep a record of the attendance of all of the students in the class. * At the end of each half term he needs to be

  1. Technical Documentation.

    telephone number has to be entered in, to prevent anything other than numbers from been typed into it. The rule was that it is only numbers that can be typed in. Mobile Number - I put a validation rule in place on the cell where the mobile number has to

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

    5. The map will be taken from 'Google maps' and then edited in paint application and this edited image will then be copied and pasted on to the menu. 6. In order to make a logo I am first going to use 'google images and find a suitable picture

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

    be password protected for extra security; this can be created directly in the Excel file. This is also an advantage as the teacher may want to keep the data safe and protected, so nobody can change or delete data within the file by accident.

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

    so that all members of staff and future employees will have less hassle using the filing system. My spreadsheet will be more useful than a manual system for the following reasons: * My system will reduce paper work, as more of it will be kept on the computer.

  1. Developing an I.T. system to monitor School Attendance

    SOLUTION The system will use a model to record student attendance and it would have facilities to search through the database for relevant information. It would be easy to use the system because it will have micro buttons that can be clicked by a mouse to perform a task.

  2. User Documentation

    1, You need to open up the database, type in the password, open the main menu, and click on 'Registered Childminding Contract.' 2, This screen will then appear: 3, On this form, you have to enter all your details in.

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