Loading…
This event has ended. Visit the official site or create your own event on Sched.
View analytic
Sunday, May 15 • 9:40am - 10:40am
Using Google Sheets for AfL

Sign up or log in to save this to your schedule and see who's attending!

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.

Speakers
avatar for Andrew Sharpe

Andrew Sharpe

Teacher of Mathematics, Garden International School
I have been teaching Mathematics at secondary schools since 2008, initially in Yorkshire, England and recently in Kuala Lumpur, Malaysia. My main responsibilities have been curriculum based, working as second in department and having responsibilities for both KS4 and KS5 Maths at various times. Before beginning to work with iPads in education I was responsible for the development of the VLE and for training staff in the use of interactive... Read More →


Attendees (14)