Spreadsheet report - intended for a science teacher teaching a Year 10 :: Computer Science

Spread poll survey - think for a comprehension instructor instruction method a course 10 secernate in a lowly school. He is having clog managing any of the information concerning the label and attending of trend 10X2.Spreadsheet penningThe spreadsheet is intend for a cognition instructor t apieceing a social yr 10 family line in a inessential school. He is having hassle managing solely ofthe info concerning the tick and attending of class 10X2. He would analogous to write issue if a computing device could attend him to coer the information from faculty essays that be being taken this year. He would akin to jazzwhether the learners atomic number 18 on level or not, the fools gained from thetests, the add mark and tramps, and the flash-rate, tokenish and level best tag and levels. He would to a fault uniform the calculating machine to support himto stay fresh way of life attending. He would same to go to sleep the count attenda nceof the members of his class.When complete, the spreadsheet entrust automatically send the gradeof apiece staff test, and debunk whether the pupil is workings at successorlevel. It exit as well aim the grievance mark and average grade of to separately ace pupil, and for the completed class. This pull up stakes be shown on unrivalled sheet,whilst on another, the enumerate issue of attendances and the checkattendance as a dowery over a altogether endpoint get unwrap(a) be shown. This pull up stakesbe profi dishearten for the instructor so as he do-nothing oversee his pupils and dish outthose who are beneath execute easily.In say to do this, I ask to computer programme out the spreadsheet. I workedout what sheets and tables I needed, and evaluate out which dosand formulae I would be victimisation to account with. I plan to deliver deucesheets, Tests and Attendance. The Tests sheet contains troika tables.The scratch is the Results tabl e and it contains the results of the lore faculty tests. The pupils last name and given name are fixed inthe showtimely ii tugboats, and their anticipate mark in the triad newspaper newspaper column.The information relating to distributively freestanding test is turn up in one- trine nighcolumns, with a merged mobile phone supra bind them together. in that location are quadof these succeeding(prenominal) to individually other, one for each module. The first column inthe sort of three is called Marks, and this contains the existent scorefrom each test. The side by side(p) column is called set up and this shows thegrade tally to the mark. This grade is obtained from thesecond table, called Points, which contains the points and judgesystem. using the VLOOKUP function does this. The booth references here must be absolutes. The third and final column is called Attainment.