Don't touch Baz
Friday, September 11, 2020
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
responses!B2:B
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)))
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
responses!B2:B
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.
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
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
Digital tote resources
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
http://connect.iste.org/communities/community-home?CommunityKey=6fed01aa-9e1f-4c27-87d1-95d0afcbbbeb&_ga=2.10660724.1543399721.1527795788-599841043.1457746050
Add to digital tote | Go to my digital tote
Add to digital tote | Go to my digital tote
https://mitpress.mit.edu/books/lifelong-kindergarten
Description: Lifelong Kindergarten by Mitch Resnick
Description: Lifelong Kindergarten by Mitch Resnick
https://www.ncwit.org/
Description: National Council for Women and Information Technology
Description: National Council for Women and Information Technology
Description: Josh Caldwell: Creative Coding
https://nofearcoding.org
Description: No Fear Coding
Description: No Fear Coding
https://utexas.app.box.com/s/c6pfmvj0dkxc3o7swyplrk95pyu3wnax
Description: WeTeach_CS ISTE 2018 Conference Presentation
Description: WeTeach_CS ISTE 2018 Conference Presentation
ISTECS2018FirehoseAnnouncement.pdf
Description: CS 2018 Firehose Announcement
Description: CS 2018 Firehose Announcement
ISTECSFirehose2018Program.pdf
Description: ISTE CS Firehose 2018 Program
Description: ISTE CS Firehose 2018 Program
ISTE_CSFirst_EducatorsPDslidedeck_final.pdf
Description: Google: Using CS First to Teach Foundational Computer Science (Grades 4-9)
Description: Google: Using CS First to Teach Foundational Computer Science (Grades 4-9)
Subscribe to:
Posts (Atom)