Malaysia Summit

Google sheets used in conjunction with Google classroom can give incredible, bespoke feedback to students and teachers about students’ progress. They key comes from linking sheets together and using suitable queries. This session looks at both the teaching and learning aspects of using sheets and the technical skills involved. The three main uses of sheets we will cover are:

• Firstly, use as a bespoke, interactive AfL tool that can be saturated with links and resources to help students both identify what they need to learn and also how to learn it independently.
  
  • e.g. An interactive revision checklist.
• Secondly, as a tool for teachers to get instant, live feedback on the progress of students in their class.
  
  • e.g. A class overview sheet of a test.
• Finally, I will look at the incredible live data analysis that faculty leaders can get from whole cohorts.
  
  • e.g. Mock exam analysis.

Both beginners and advanced users will be welcome at this session. There will be resources to help develop basic spreadsheet use right up to how to set up sheet structures and functions such as =importrange(), =query() and =vlookup(). Either way you should come away with plenty of things to think about.