Workbench and Google Sheets part 4

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

This blog post will show you how to read and write data using a conditional loop from a spreadsheet 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 using loops we can collect multiple sets of data, making this a powerful tool in the classroom. 

In this 11:23 minute video, you will learn how to write code using blocks in the programming canvas to read and write sets of data from a spreadsheet using loops. 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

Want to learn more? Then keep an eye out for the next blog where we add a touch more functionality and draw charts which can be used to represent real-time data. 


How to easily manage meeting minutes with Microsoft Outlook & OneNote

Microsoft OneNote is an excellent tool for collaborating on and collating meeting minutes. However, when you utilise the connection between OneNote and Microsoft Outlook email and calendar, it becomes even more powerful! In this blog post, I’ll show you how the two tools work together to make taking and sharing meeting minutes quicker and easier.

VIEW POST
Homework help

How parents can easily see what their child is learning at school

It used to be that parents could look at their child’s school book and feel like they had a sense of how their child was progressing. Now with work being completed on a computer, often that work is hidden behind a username and password.

In this post we show you how schools can easily empower parents to be involved in the learning process as well as improve communication between school and home by simply teaching the parents how to log into their students Google Drive or OneDrive account.

Plus you can download our step by step guides for parents

VIEW POST

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

VIEW POST

Here’s What
Our Clients Say

PR Industrya

Client

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