Work with EXCEL презентация

GOOD DAY! TODAY WE WILL CONSIDER A TABLE WHICH IS USED BY TEACHERS OF ENGLISH AT ITMO UNIVERSITY FOR PUTTING POINTS FOR A SEMESTER.
Here is a number of educational group of each student in the first column, and his full name in the second. In the third the name of group on English.

After that - points and for what they are putted, respectively for the first and second module. For example in the 6-th column is visiting by the student of classes in the first semester, so, it is possible to get 11 points if its percent of visiting is more than ninety five. The Total – the amount of the gained points for all semester is highlighted with bold red color.

Now we will look through the most interesting part. It helps the teacher to enter quickly data about the students: visiting of classes, execution of homework in the “Cambridgelms” system and about examinations. The teacher shall just deliver each student, what he received, and the table itself will transfer these data to the points got for a certain discipline in that compliance as it is required.
For example, it’s the formula for cell I3

For example, In cell P2 the teacher puts a total quantity of classes which were in the first module. Personal qualities and the mark for the intermediate certification is put down by the teacher.