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 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.

3.

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.

4.

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

5.

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.

6.

• We are hope it will be more comfortable to use this table,
which simplifies the teacher’s work.