Technical Documentation :: Computer Science

Technical DocumentationThe software that will be apply for The Castletown High School Systemwill be Microsoft Excel. This is a spread cruise program that allowsthe substance abuser to carryout calculation and functions by using stochastic variableulas. Themachine should sire a scoreer attached to it so that the users areable to print their work when they are done. The users of the systemdo non need to be overly good with computers but they do need a grassrootsknowledge of how the system operates. The system has been designed tohelp those users who are not overly good with computers. This system should be opened by an look-a give care on the desktop this will makeit easier and quicker for the users to access. Each of the goings include in the homepage has a macro attached toit which performs a specific task Enter Results This button takes you to a screen were you selectwhich class you would like to enter results for when you chose theclass you are then interpreted to the resu lts entry form where you stooge enterthe results for each pupil for your specific subject. Streaming add up This button also takes you to a page that asks youwhich class you would like to blow when you have chosen this youwill be brought to the streaming list were you can stream that classbut also compare the male and young-bearing(prenominal) results in a graph. Pupil Report This button allows you to create a pupil report whenyou click this button you will go over again to the class selection. Whenyou chose the class you must then chose which of the pupils you wishto do a report on when you do this you will be brought to the reportsheet were all the pupils details including grades will already beentered.Lookup(Grade,GradeLookupTable)This formula is used to work out the grade for the pupils. This is done by the formula checking the percentages against a table.ROUND(Mark/Max_Mark)*100When the Mark and the Max Mark have been entered by the user the aboveformula will automatically work out the percentage.This button when pressed will bring the user back out of the dataEntry Form back to the main menu.Data ValidationThis is the geological fault message that appears if the user inputs a numberthat is greater than the max mark.This is the introductory layout of my report.Text Box When the report is opened the information for Aine Boyle is automatically taken from the database and displayed in the streaming list, so the user only has to fill in there comment manually.