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: i?? Takes up a lot of space – lots of filing cabinets i?? Searching for records can take a long time i?? Only one person can access the data at a time i?? The data mite get misfiled or even lost i?? If they are private they might be accessed by other people i?? Time consuming and chances of human error But she feels a computerised system has many benefits such as: i?? Takes up a lot less space i?? Searching for records can take a lot less space i??
More than one person at a time can access the same data from their network PC i?? The data stays within the computer’s memory it won’t get lost or misfiled i?? 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. i?? 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: i?? Perform calculations i?? Draw graphs to compare results with previous students. i??
Cells can contain a number of things such as numerical data, text data and formulas. i?? 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. i?? 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. 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 spreadsheet I plan to design as it isn’t relevant. Word can be used to do this as it has many features such as mail merge, creating templates, using macros, importing information and spelling and grammar checking but it would be extremely difficult for the teacher to keep all the files neat and tidy and also the calculations will have to be done manually as word cannot do calculations unlike excel where it was one of its most useful features.
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. Percentage of the marks received- In order for Ms Perry to see if her pupils have gained a higher or lower mark then their last examination and approximately how much of the exam paper was answered correctly 2. The grade they have received- This will be needed to put on pupils references and reports and allow Ms Perry to see how well the class did overall and how many A-C grades her class gained 3.
Two lists to show whether the pupil has failed or passed- This shows Ms Perry if a pupil received a A-C grade or a D-U grade without her even looking at any of the other outputs. These can be validated if necessary by a character count, a presence check, file lookup or a range check, this enables the computer program to check the data being entered and report any errors. These checks help ensure that the program processes the results accurately and that no pupils have their grades and percentages mixed up and therefore the teacher receives the incorrect data.
Hardware needed VDU – So I will be able to look at the information in the computer I have entered and use the Windows Icons Menus and Pointers. KEYBOARD – So I will be able to enter the characters via keystrokes and change case quickly. MOUSE – To make moving from programs and selecting options much quicker and easier. DESKTOP -The store of the CPU (central processing unit), backing store, programs, files, and documents etc.
PRINTER – to print out documents. FLOPPY DISKS – To save important documents if they are needed elsewhere. Software needed The software I will be using is Microsoft excel to store the input and output, this is the only program I need to produce a spreadsheet for Ms Perry as it has all the functions needed.
Security Strategy Due to the fact that the information is confidential and shouldn’t be accessed by anyone else other than Ms Perry as the contents of the spreadsheet are very important and students might to try to hack into the files so I have decided to encrypt a password on my system. 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.