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

Charts

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

)

)

)

Reports

Attendance

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

  1. RANDBETWEEN
  2. COUNTA
  3. INDEX

Conclusion

--

--

--

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

Pandas Tricks:

Random Forest and Ensemble Methods for YouTube Brand Lift Forecasting

Gary Vaynerchuk, famous entrepreneur and internet craze, advocates for closing

Giannella v Barrientos [LiVeStReaM]

Online live stream search engine

Mochizuki v Olivieri LIVE Stream#

Online live stream search engine

A Tender Introduction to Data Science

Overcoming digital, data and technology challenges in local government: 3 actions you can take

ABC of Data Science

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

What to look for in your laptops in 2022.

What You Should (Really) Expect From Star Trek 4

A small project in audio synthesis and data sonification

Summary of AI Code Completion Tools — Codota