Skip to Content

Create my LOGBOOK to track my students (absences and grades)

Of course, there are already ready-made solutions (ECOLE DIRECTE / PRONOTE or IDOCEO on Apple) that do the JOB very well.

But if you want to create your own LOGBOOK to track your students, this article might interest you…

A tutorial divided into 11 steps allows you to produce this solution. An Excel file is provided below for you to practice.

A playlist to accompany you


Similarly, the tutorial is offered in the form of a YOUTUBE PLAYLIST that describes the various actions to achieve the final result.


List of training materials

This section highlights the key statistics.

Step 1

The supporting Excel file

Download the file

Step 2

The Workshop sheet

Download the file

Step 3

The Creation guide

Download the file

Step 4

Sheet "Helping Hand No. 1 - Attendance Sheet"

Download the file

Step 5

Sheet "Helping Hand No. 2 - Grades Sheet"

Download the file

Step 6

Sheet "Helping Hand No. - Summary Sheet"

Download the file