A google sheets add-on

A typical lesson as a student might view it.

NOTE: On their first visit each student will be asked to enter their username - I have chosen their first names but anything can be used. Try 'Arthur','Barbara','Carlos','Deborah','Eve','Felix','Graham','Harold','Imogen' or 'Jack' to authenticate.

A typical marksheet as a teacher might view it.

As you mimic student responses into the lesson page above, see how the marks appear in the teacher's marksheet below!