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


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.


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.


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. Smart Card System

    lab assistance's encrypted data Source: Create Student Smart Card Process Destination: Lab Assistance Entity Type of Data Flow: [ ] File [ ] Screen [ ] Report [ ] Form [?] Internal Data Structure traveling with the flow: Smart Card Serial Number Volume / Time: 1 / Each Use Time Comments: Lab Assistance get their new smart card.

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

  2. Unit 6 - Advanced Spreadsheet Skills

    The have to keep in contact with the buying department to inform them what produce is available and in return the department will provide a delivery date for the products to be collected. 4. Customers: The customers were originally mainly locals however it has grown to encompass primary schools, care homes, local shops and supermarkets in the area.

  1. 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)

  2. supermarket database-computer coursework

    * It is limited to a low transaction rate. * It can bring down the entire servers if it is not used properly. The advantages of using Visual Basic are: * It provides a user-friendly interface. * The modular structure in visual basic program helps the programmer to develop a large program without knowing all the variables and their relationships.

  1. Logo design

    13 Stepping 8 GenuineIntel ~1729 Mhz What alternative hardware I could have used AO1D Apple Mac pc or laptop Advantages and disadvantages of alternative Hardware AO1E, AO1V, AO1W Advantages: * Reliable for a professional logo outcome Disadvantages: * Can react quite slowly * Doesn't communicate with other computers * Don't

  2. Flexible Architectures in Communication Security Application

    that produces the result of the key-parameterized function. SBOX's are easily reversible by inverting the table, i.e., indices become values and values become indices. In addition, other algorithms often employ two other mechanisms, modular multiplication and XBOXs. Lisa Wu Page 15 4/22/01 Modular Multiplication Modular multiplication has been shown to

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