• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

My aim is to design a spreadsheet for a teacher

Extracts from this document...

Introduction

Identify 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 ...read more.

Middle

Other softwares such as publisher which is used to design artistic leaflets and brochure would be unsuitable and power point which contains slides and each slide contains a number of frames (like a Desk top publishing software) which are for presentations complete with music and animations can be needed which is pointless in Ms Perry's spreadsheet. Analyse My task is to transfer Ms Perry's paper based system to a comprised system where she can work out and record the grades and percentages of pupils based on their exam results. The data input in the spreadsheet will be taken from the register and exam papers and will be: 1. Name of students- This is so the results do not get mixed up within pupils and Ms Perry will find it easier to find pupils results and they got also be alphabetised. 2. Form class of pupils- This is to categorise pupils so Ms Perry finds it easier to find the pupils necessary information and also to keep her files neat and tidy. 3. How many questions the pupils got right out of the total- This input is vital as the formulas I use will need this data in order to work out the grades and percentages. The data output in the spreadsheet will be: 1. ...read more.

Conclusion

I have shown how I have done this using screen shots: Go to tools then to options 1) [image003.gif] [image005.jpg] 2) Go to security and this should bring up how to encrypt a password [image006.gif] [image008.jpg] From this window I have been given a option to password protect my spreadsheet making it inaccessible by other people and I also have a choose to make the file read-only so people can access the document but not make any changes to it but Ms Perry has said that the information in her spreadsheet is strictly confident so I would choose the first option. She can also make her file signature binding but I feel this would sometimes cause her trouble when trying to access the document. Flowchart for data input and output Flowchart: Manual Operation: Enter Form (input) Oval: End [image011.gif] Backup Strategy Ms Perry can also keep her spreadsheet saved in her computer documents but to make sure this is kept confidential when using a network computer she should have a user name and create her own password, this will limit unauthorised access to the network, but she should change her password frequently. She can also make back up discs but again she is in danger of losing this, she could also make back-up files which should ideally be kept in a different location from the network. She can also copy or move some of her files somewhere for long-term storage (archiving). ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level Computer Science 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 AS and A Level Computer Science essays

  1. Control Unit, Memory Unit, and Arithmetic Logic Unit. The CPU or Central Processing ...

    A good example of this is the receipt that a shopper is presented with if buying something using a credit card, there are two copies produced, back to back, one for the shop to keep and one for the buyer to take away with them.

  2. Evalutation of a Spreadsheet

    Custom filter can also be a good feature to use because it can be used to filter data within a spreadsheet. In my spreadsheet I used this to show sales person A and B separately. This would make it easier for the manager to see how each individual sales person is doing.

  1. Unit 6 - Advanced Spreadsheet Skills

    Requirements: The management team have given access to the following tables: * Produce Details * Order Details * Sales Figures for the last 2 Years * Customer Details With this data the management team want the new system to be capable of the following: * Enable the creation of

  2. Analysis of Johnson Music

    Firstly, I will contact the owner of the shop to arrange an interview with his staff and make sure it is okay for me to conduct my project. Letter to initially contact (for samples of originals see appendix) Mr Johnson, My friends and I have been customers in your shop (Johnson Music)

  1. supermarket database-computer coursework

    It can be done as shown: Contain of the table This table is about the information of the customers which order products from the internet. The table should contain the following item: * Customer name * Customer no. * Address * Contact method * Phone number * Credit card number

  2. Logo design

    have Paint Alternative means of outputting logos; benefits & drawbacks A01Y Outputs: Printers - Desk Jet, Ink Jet, Laser Jet, Bubble Jet, Dot Matrix Benefits of using a Desk Jet printer: * Printer and ink are quite cheap * Printing quality is very good Drawbacks of using a Desk Jet

  1. Smart Card System

    Two examples of when we might use lock-and-key are as follows: 1. When we want a specific remote user (or group of remote users) to be able to access a host within our network, connecting from their remote host(s) via the Internet.

  2. Flexible Architectures in Communication Security Application

    The remaining algorithms, i.e., Mars [7], RC6 [33], and Twofish [35], are second round candidates for the Advanced Encryption Standard (AES) [1]. Many of the AES algorithms will likely emerge as high-quality encryption algorithms that will see use in popular applications and protocols.

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