Technical Documentation :: Computer Science

Technical DocumentationThe softw are that testament be used for The Castletown High School schemawill be Microsoft Excel. This is a spreadsheet program that allowsthe user to carryout calculation and functions by using forms. Themachine should have a printer attached to it so that the users areable to print their work when they are done. The users of the systemdo not need to be overly good with computers but they do need a basicknowledge 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 impression on the desktop this will makeit easier and quicker for the users to access. Each of the buttons included in the homepage has a macro attached toit which performs a specific task demean Results This button takes you to a screen were you selectwhich class you would like to estimate results for when you chose theclass you are then taken to the results entry form where you can enterthe re sults for each pupil for your specific subject. Streaming List This button also takes you to a page that asks youwhich class you would like to stream when you have chosen this youwill be brought to the streaming list were you can stream that classbut also compare the male and female results in a graph. Pupil subject This button allows you to create a pupil report whenyou click this button you will go 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 Data first appearance Form back to the main menu.Data ValidationThis is the error message that appears if the user inputs a numberthat is greater than the max mark.This is the basic layout of my report.Text cuff 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.