The data required to build this system will be the information from Mr. Geller’s logbook for every class. He will be supplying me with information such as first names and surnames of students. In addition he will be supplying me with students test results of the year also from his logbook for every class. I will therefore input them into the system to create it.
Mr Geller will scan the student’s names directly from his logbook and print it out so I can add the students names into the system. Furthermore Mr. Geller will give me students test results handwritten so I can enter the data into the system and create graphs and an average for every class. Finally Mr. Geller will give me the grade boundaries which will be scanned from his logbook directly and a can create a “if so” to see if students have passed or failed and customize a color according to the results. I will be inputting the data of the test results in the beginning to create the system and make sure its fully functional however Mr. Geller should enter test results or new students information whenever the necessity arises.
Data Input
Once the information has been collected I will key it into the spreadsheet straight from Mr. Gellers logbook. All updates made to the system when students leave or a new student comes will be keyed in by Mr. Geller, he will also add any new test results straight into the spreadsheet and the spreadsheet will calculate the average and the graphs will be changed. The data will be in the form of numbers and letters.
Data flow
Mr. Geller will have to add new data and change the average for test results and student improvements. The new information will be added along with the new one this will involve the change in average and students improvements.
Macros
The macros that will be included in the spreadsheet will be used in the home page and every other page. The macros in the homepage will take me directly to the page that I want to go to by a press of a button and on every other page there is a macro that if pressed will take you back to the home page. This will be extremely useful as it saves a lot of time and is very easy to use. Also this will be very user friendly for my end user Mr. Geller as he can go through pages by a click of a button and vice versa.
V-LOOK UP
This will enable Mr. Geller to see what the grades are of every student through the grade boundaries. Whatever a student will get they will receive a grade according to the ranges from the grade boundaries. This is very useful as it is done automatically on the cells that have been formatted with V-look up. This is not hard to use and is extremely accurate and will be very useful to Mr. Geller as he does not have to input grades in manually.
Conditional formatting
By doing conditional formatting this will allow me to highlight a cell to a certain color if a student has failed an exam. This will be done by me entering formulae that say if a student has gotten below a certain value then the word fail will appear and it will be highlighted with Bright red. By doing this it will be very beneficial to my end user as he can clearly see who has failed and who has not.
Output
The data will be shown on the screen, therefore its easier to see and less complications. For the students results there will be graphs for every test and a graph for the average results. There will also be output pages for grade boundaries and the initial data. The data can be printed out if needed.
Back up
The computer file containing the system must be backed up by a DVD and a USB. There should be two copies just in case one copy will be destroyed there will be a backup and the two copies should be stored away from each other. Any time the system changes it should be saved as a back up on the two USB’s.
Security
There should be some form of security for the system so a password will be put on the system for added safety measures. This will prevent people from changing the system and corrupting some files. If anyone other than the end user wishes to change a formulae or change a worksheet a password will be asked for. The password should be reasonably long to be on the safe side, the password should be at least 5-10 letters and should not be a common name or a password easy to guess such as Geller etc. However it is crucial that My end user remembers this password or does not lose it because it could be potentially corrupted if in the wrong hands.