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 create page borders in Google Docs

One of the most common frustrations with teachers who have made the move from Microsoft Word to Google Docs is they miss the ability to create borders on their Google Docs – like they could in Word.
And they are right. There is no page border tool in Google Docs. However there are a couple of workarounds that allow you to do it. This blog will show you how.

VIEW POST

Customising Google Sheets cells to display text and numbers

The custom number format allows you to have text and numbers in the same cell in a Google Sheet. This adds visual clarity to your spreadsheet and helps the user enter data. Calculations are still possible as Google Sheets ignores the text you have entered and uses the numerical data in the cell.

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

Download your skills checklist to see how you score...

 

Sign Up Now
To Get The Latest Updates

 

Holiday Rescue Maker Camp

Student to agree to and tick:
Guardian to agree to and tick: