• 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. I have been given the task to design a database for a company called ...

    The improved form is shown below. Destination Data Form Order Data Form Original design I have modified the order table throughout the project to make it easier for the users to use, however below is my first design, which simply includes places for the user to enter in the ID's

  1. Smart Card System

    The code produced by the Java compiler is checked for validity and the program is prevented from performing unauthorized actions. b) Robust No pointers operations are made available to the programmers. There are no pointer variables, arrays cannot be manipulated through pointers and the integers cannot be converted into pointers.

  2. CP3 - Proposed Solution to a Realistic Problem - Apartment Administration software

    Using a program like Access would mean that it would be fairly simple to produce report outputs for the client using built a built in feature like mail merge. Other features and advantages of using a database over the current system include, * Graphical analysis of statistics * Queries to

  1. Computer Aided Design Package

    The reason I have chosen these four is because the CAM machine in the workshop will only accept .DWG files for reading and if the CAD package didn't output .DWG files it would not be able to integrate with the CAM machine.

  2. Robot Prototype design principles.

    Repetition leads to fatigue, mistakes, wasted time, and forgetting of key information. However, streamlining should not increase the number of ways to carry out a task, which can confuse the user. In the programmer study, programmers had to select a node and perform two pull down selections to trim an arm, a relatively common activity.

  1. You need to discuss the advantages and disadvantages of someone in your

    Do you use a database? Did you need training? How often do you use it? Is it easy to use? What data is stored about...........? What is good about the system? What would you change? Do you need a user guide to help you use it? Is your system on a network or a stand alone PC?

  2. File transfer protocols

    End; (* Process_Votes *) (* 3 Menu *) Procedure Menu(Songs_Table : Songs_Table_Type; Total_Votes : PosInt); Begin (* Menu *) Writeln( 'Menu') End; (* Menu *) (* 0 - Songs *) (* Calls Set_Up to load song details into the table, Process_Votes to input votes and collate them, and Menu to offer options *)

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