Workbench and Google Sheets part 5

[et_pb_section fb_built=”1″ _builder_version=”3.22.3″][et_pb_row _builder_version=”3.22.3″ background_size=”initial” background_position=”top_left” background_repeat=”repeat”][et_pb_column type=”4_4″ _builder_version=”3.0.47″][et_pb_text _builder_version=”3.0.74″ background_size=”initial” background_position=”top_left” background_repeat=”repeat”]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:

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.


Top tips for working from home by a remote working team

  With Google Drawings a lot of people don’t realise that it actually sits inside Google Docs. Inside Google Docs you actually have the Google Drawings tool. Under insert you’ve got Drawings and now there are two places that you can get a Drawing from. The ‘New’ is going to


Here’s What
Our Clients Say

PR Industrya


In 2018, Using Technology Better designed and delivered a two phase post-migration training program for this New Zealand based graphic design firm. The initial goal of the training program was to reduce frustration with G Suite, with the long term aim of facilitating a change in culture and collaboration that can lead to transformative practices