Похожие презентации:
Work with EXCEL
1. Работа с EXCEL
РАБОТА С EXCELРАБОТУ ВЫПОЛНИЛИ
СТУДЕНТЫ ГРУППЫ M3134 (1ИТИПКТ B1.1/34)
ВОЛОШИН НИКИТА И МАКСИМОВ ТИМОФЕЙ
2. Good day! Today we will consider a table which is used by teachers of English at ITMO university for putting points for a
GOOD DAY! TODAY WE WILL CONSIDER A TABLE WHICH IS USED BY TEACHERS OFENGLISH 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.
3.
After that - points and for what they are putted, respectively for the first and second module. For examplein 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.
4.
Now we will look through the most interesting part. It helps the teacher to enter quickly data aboutthe 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
5.
For example, In cell P2 the teacher puts a total quantity of classeswhich were in the first module. Personal qualities and the mark for the
intermediate certification is put down by the teacher.
6.
• We are hope it will be more comfortable to use this table,which simplifies the teacher’s work.