Tracking Students’ Progress

  • Grade (term 1)
  • Grade (term 2)
  • Charts (term 1)
  • Charts (term 2)
  • Competences
  • Assess participation (term 1)
  • Assess participation (term 2)
  • Comments
  • Report (term 1)
  • Report (term 2)
  • Attendance
  • Special Needs
  • Accounts
  • Create groups
  • Student Picker
  • Seating plan
  • To insert the date, press cmd or ctrl + ; (be sure to go to Help > Keyboard shortcuts and activate Enable compatible spreadsheet shortcuts).
  • To display a time or a date (which will be automatically updated every day), use the functions =NOW() or =DATE(). To format the date, head to Format > Number > Date.

Grades & Competences

  • For grades, choose “Greater than” or “Less than or Is equal to”.
  • For assessing participation (see down below), pick “Text is exactly”.


Assess participation

=IF(logical_expression, value_if_true, 

IF(logical_expression, value_if_true,

IF(logical_expression, value_if_true, value_if_false



=IF(B7="très bonne participation", 2,

IF(B7="bonne participation", 1,

IF(B7="suit mais ne participe pas", 0.5, 0






Special needs

Seating plan

  1. On the first one (the sheet is labelled “Liste”), you will find a list of your students. For each student, a random number is allocated. Using Filters, you can change the order of the names so they are mixed up. To assign a random number use this function: =RAND() (it returns a random number between 0 inclusive and 1 exclusive).
  2. On the second one (“Tables”), you have a simple sitting plan with only numbers.
  3. Finally, on the third one (“Plan”), you have the same sitting plan but (and this is where the magic happens) but instead of numbers, you have a function using INDEX and MATCH. It places random students!

Create groups

Pick a student randomly

  3. INDEX





Teacher and Director of Academic Research & Innovation @ Lycée International de Londres Winston Churchill

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Designing a Medical Images Labeling Tool — Laibel

EPL Analysis and Gameweek 20 Prediction

TDSP : Team Data Science Process

Introduction to Data Analytics Do you ever wonder where data comes from?

Analyzing Completely Randomized Design(CRD) in R

2021 Super Bowl Square Pool Odds by Quarter

4 Decades of U.S. Music Industry Revisited

Data Science Interview Questions My Friends and I got asked recently (II)

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Yann Houry

Yann Houry

Teacher and Director of Academic Research & Innovation @ Lycée International de Londres Winston Churchill

More from Medium

“If you knew me very well, you would know that…” or “People need continuous improvement”.

Compiling Knowledge Nuggets from Your Meetings for Confident Decision Making

7 Best Practices to Ease Virtual Team Challenges — KNOLSKAPE

ankit1234| Kharagpur Winter of Code Report