Friday, August 14, 2020

Sheets countifs

Using Google sheets

People are give an option to reply other in a form. I want to be able to count The number of these. So I am using Countifs

Countifs allow us to count something if it meets multiple criteria

The first field is where to look ie where is the range.
In this case it on the tab responses in the range B2:B
note you need the exclamation mark to reference the tab

Determining if a value is not equal
"<>" in quotation marks is the same as not equals

Checking against a cell use an ampersand
&A2 will check against the value in A2

Here is the whole thing below each condition is separated by a comma.

=COUNTIFS(responses!B2:B,"<>"&A2, responses!B2:B, "> ", responses!B2:B,"<>"&A3,responses!B2:B,"<>"&A5,responses!B2:B,"<>"&A6,responses!B2:B,"<>"&A7,responses!B2:B,"<>"&A8,responses!B2:B,"<>"&A9,responses!B2:B,"<>"&A10,responses!B2:B,"<>"&A11,responses!B2:B,"<>"&A12,responses!B2:B,"<>"&A14,responses!B2:B,"<>"&A4)))

Thursday, May 28, 2020

Te Reo - a tēnei marama

Having a go at building te reo Māori. 

What I am going to try to do is us the audio recording in slides for this. 

I am saving the mp3s to practice and trying to build a base. 

Wednesday, May 20, 2020

A voice to listen to a Voice to be heard

The following slides show

  • why adding audio to slides add accessibility
  • how you can easily record it on a chromebook
  • the adding it process and
  • how to share

Wednesday, May 6, 2020

Posting tinkercad to your blog

Below is a sample of a tinker cad model embedded in a blog and a how to do it

A great way to show that the learners have been able to work in three dimensions and a way to share what they have 3d printed or intend to print. Have a play with the model picture

Alongside this they could share picture of the finished result prototype from along the way.
Often with the prototype share they might be able to seek direct feedback from blog partners too.

I have made a quick video howto below
In the meantime - check out the wonderful 3d print school from Taranaki for examples of 3 d printing from young people.

Wednesday, April 15, 2020

Quick and easy add bloglist to site

Here is a quick gif showing how to get a list of learner's blogs with links onto a google site

Wednesday, July 11, 2018

Scratch Getting unstuck day 1

So I came across getting unstuck a 21 day challenge  for the programming environment scratch.
Having attended the CS firehose at ISTE in Chicago I reconnected with the scratch team by following them on twitter. @ScratchEdTeam . I found out about getting unstuck through that and have started.

So here is my first project

New learning
  • Use glide to make movement look natural
  • The motion blocks will take on the position of the sprite

Digital tote resources