UTB Newsletter 2020 – Issue 6

UTB Newsletter - Issue 6 - 2020

The line of best fit and scatterplots in Google Sheets

Collecting data and finding the strength of the relationship between the variables, a method used in statistics. Making a scatterplot and finding the line of best fit or trendline in Excel was a piece of cake. I could never do it in Google Sheets until I found a solution! It is easy to build a meaningful scatterplot, put in a trendline and find the correlation coefficient within a couple of clicks.

VIEW POST

Conditional formatting: Tracking student progress with Google Sheets

With Google sheets you can track student progress and easily visualise how students are progressing.

The most common ways for teachers to visually represent student progress is through graphing the data. However with conditional formatting in Google sheets, teachers have another option for graphically representing student progress.

Here is a step by step guide to easily using conditional formatting to tract student progress.

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: