Workbench and Google Sheets part 5

Adrian lives the passion and intuitive pedagogy of contemporary education and is a full-time trainer at Using Technology Better. He is accredited as a Microsoft Peer Coaching Master Facilitator, a Microsoft Master Educator, a Google Certified Innovator, a Level 1 and 2 Google Certified Educator an Apple Learning Specialist and an Apple Distinguished Educator. With over 30 years experience working in Schools with an ICT and Curriculum focus, Adrian has lead teams in using digital tools to transform teaching and learning.

This is the final blog in the series on using Workbench. In this blog, we look at using the programming canvas to read and write multiple sets of data to a spreadsheet by incorporating a conditional loop.

This blog post will show you how to create a chart that can show real-time data using the programming canvass in Workbench #googleedu #workbenchedu Click To Tweet

Because we can read and write data via code, we are also able to collect data from external devices like a micro:bit. By incorporating data validation and charts, we can write code to read and write multiple sets of data and then display this in a live-updating chart.

In this 10:08 minute video, you will learn how to read and write multiple sets of data, use data validation to control the sample size and use multiple variables and blocks in the programming canvass expanding on what has been shown the previous posts. Click to watch the video.

Have you missed the other blogs in this series? Don’t panic! To access the blogs:

Click here for the first blog
Click here for the second blog
Click here for the third blog
Click here for the fourth blog

Want to learn more? Then keep an eye out for an upcoming blog where we link a micro:bit to Workbench and record live temperature data or check out our online courses.