Technical Documentation :: Computer Science

Technical DocumentationThe software that will be apply for The Castletown High School Systemwill be Microsoft Excel. This is a spreadsheet broadcast that every(prenominal)owsthe user to carryout calculation and functions by using formulas. Themachine should reach a printer attached to it so that the users areable to print their attain when they are done. The users of the systemdo not need to be likewise good with computers but they do need a basic association of how the system operates. The system has been designed tohelp those users who are not to a fault good with computers. This system should be opened by an icon on the desktop this will makeit easier and quicker for the users to access. Each of the vents included in the homepage has a macro attached toit which performs a specific task code Results This button takes you to a screen were you selectwhich ground level you would like to nominate out results for when you chose theclass you are then taken to the results entry form where you nates enterthe results for each school-age child for your specific subject. Streaming List This button also takes you to a page that asks youwhich class you would like to teem 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 Report This button allows you to create a pupil newspaper publisher 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)* light speedWhen the Mark and the Max Mark have been entered by the user the supraformula will automatically wor k out the percentage.This button when press will bring the user back out of the Data opening Form back to the main menu.Data ValidationThis is the error marrow that appears if the user inputs a numberthat is greater than the max mark.This is the basic layout of my report. textual matter 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 at that place comment manually.