Use your class list to produce corresponding folders. Use the folders to store work

Sample Documents 

• List to Folders

Record and analyse class attendance directly in a spreadsheet or import the attendance data from Moodle

Sample Documents 

• Attendance Files

Create a simple tracking system for equipment loans using Google forms and Google sheets

Documents

• Loans Tracking Files

The Error Responses File is used to collect submissions from a Google Form. 

The Error Log File pulls out the relevant data to share with staff.

Use the Macro to add automated email replies when the job is completed.

Documents

• Error Reporting Files

NB: Spiceworks is a very good free online help desk ticketing system.

Book laptops using a google form. The day and time of booking can be specified. Cancel booking through the form.

View the current booking on the connected Google Sheet

Documents

• Laptop Booking Files

NB: ClassroomBookings is a good free online booking system.

Collate data that is received from a google form

Documents

• Collate Form Responses (Google)

Search data in a single column in Excel using up to three keywords

Documents

• Three Keyword Search