Spreadsheet series
This series explore the use of spreadsheets and online tools for effective data analysis, visualisation and representation either through reports, dashboards or other visual summaries are explored. Graphs, Pivot tables and Data studio are some of the well known forms of data visualisation tools to inform data driven decisions. These workshops are categorised on different development levels and learning categories.
See available content packs for self exploration or contact your district eAdvisor for more detail on the next available live webinar.
Track 1
Working with Spreadsheets: Excel
Integration Level: Beginner - Intermediate
Development Level: I can do it
Learning Category: Product Essential - Microsoft Excel
The purpose of the workshop is to guide teachers, management and administrative officials to effectively use spreadsheets to do calculations.
Data visualisation using Graphs: Excel
Integration Level: Beginner - Intermediate
Development Level: The Summit
Learning Category: Digital reporting, data visualization & systemic change
The purpose of the workshop is to guide teachers, management and administrative officials to effectively use spreadsheets to visualise data using graphs.
Data visualisation using Vlookup and pivot tables: Excel
Integration Level: Beginner - Intermediate
Development Level: The Summit
Learning Category: Digital reporting, data visualization & systemic change
The purpose of the workshop is to guide teachers, management and administrative officials to effectively use spreadsheets to combine data and to visualise data using pivot tables.
Track 2
The purpose of Masterclass 1 is to guide teachers, management and administrative officials to effectively use spreadsheets when integrating Google forms and Google sheets. In Masterclass 2 the same skills are revised before delving deeper into automation. The purpose of Masterclass 2 is to guide teachers, management and administrative officials to effectively manipulate, automate and protect datasheets. Below is 12 self-guided learning tutorial videos to guide you through the skillsets obtained during Masterclass 1 and 2 combined.
Masterclass 1: Google form and sheet integration overview
Masterclass 2: Data manipulation, automation and data protection using Google sheets
Integration Level: Intermediate - Advance
Development Level: The Summit
Learning Category: Digital reporting, data visualization & systemic change
Integration Level: Intermediate - Advance
Development Level: The Summit
Learning Category: Digital reporting, data visualization & systemic change
Masterclass 3: In-time data visualisation using Google Data Studio
The purpose of the workshop is to guide teachers, management and admin officials to effectively prepare and visualise spreadsheet data in data studio.
Integration Level: Intermediate - Advance
Development Level: The Summit
Learning Category: Digital reporting, data visualization & systemic change