My aim is to design a spreadsheet for a teacher

Authors Avatar

Tazeen Chowdry 11M

My aim is to design a spreadsheet for a teacher it will contain the following:

1) A list of pupils name, mark and form.

2) Say whether they have passed or failed.

3) Work out their percentage.

4) Say what grade they have got

I will produce a spreadsheet that shall assist an English teacher at Kelmscott school, Ms M Perry who needs to keep detailed records of her pupils such as exams results, coursework grades, and to store pupil’s reports which she would like to be able to access her pupils records efficiently and easily. She is currently using a pen and paper solution but would like to transfer this to a spreadsheet as she finds that a pen and paper solution has many disadvantages such as:

  • Takes up a lot of space – lots of filing cabinets
  • Searching for records can take a long time
  • Only one person can access the data at a time
  • The data mite get misfiled or even lost
  • If they are private they might be accessed by other people
  • Time consuming and chances of human error

But she feels a computerised system has many benefits such as:

 

  • Takes up a lot less space
  • Searching for records can take a lot less space
  • More than one person at a time can access the same data from their network PC
  • The data stays within the computer’s memory it won’t get lost or misfiled
  • If they are private then a number of things can be done to make sure they aren’t accessed by other people by password protecting them.
  • Reports can be generated very quickly often by an automated processing routine.

The program I have decided to use is Microsoft excel 2000 for this piece of work because it allows me to do various things such as:

  • Perform calculations
  • Draw graphs to compare results with previous students.
  • Cells can contain a number of things such as numerical data, text data and formulas.
  •  Spreadsheet data can also be exported and imported so if the data is stored in either a database or a data-logging device you can then import it directly into a spreadsheet without wasting time and typing it all in again.
  • It is able to change formulas to, these are very useful as they save time by calculating numbers instantly, and when a cell changes it will update accordingly.
Join now!

                                                               

The reason I have decided not use other programs such as Microsoft word is because it does not as have as many suitable functions as Microsoft Excel for keeping detailed it can only do a limited amount of things such as word processing and text formatting. The appearance of the document can be improved easily through font style and word art but this is not necessary in the ...

This is a preview of the whole essay