I’m going to push the boundaries of what is acceptable here. I love this video and it’s message, even if it does use the word “Fartbag” a lot.
I’m going to push the boundaries of what is acceptable here.
I’m going to push the boundaries of what is acceptable here. I love this video and it’s message, even if it does use the word “Fartbag” a lot.
There are some wonderful resources from this teacher. Do you think they have a place in the toolkit?
There are some wonderful resources from this teacher. Do you think they have a place in the toolkit?
Originally shared by Merri Beth Kudrna
Close reading resources
This is a really robust set of definitions and explanations, I love the idea of “mean what you say.”
This is a really robust set of definitions and explanations, I love the idea of “mean what you say.”
Originally shared by Kim Fleming
Defining Personalized Learning. The International Association for K-12 Online Learning (iNACOL) has published a new report, Mean What You Say: Defining and Integrating Personalized, Blended and Competency Education. For more, see http://www.coreeducationllc.com/blog2/defining-personalized-learning/
I thought this list of links might be useful to our folks working with Chromebooks.
I thought this list of links might be useful to our folks working with Chromebooks.
Some free self-paced courses on Google Apps just became available. Could have some usefulness to our…
Some free self-paced courses on Google Apps just became available. Could have some usefulness to our schools: https://educourses.withgoogle.com/course
Some free self-paced courses on Google Apps just became available.
Some free self-paced courses on Google Apps just became available. Could have some usefulness to our schools: https://educourses.withgoogle.com/course
https://educourses.withgoogle.com/course//cdn.embedly.com/widgets/platform.js
New script from the same guy who created autocrat and formmule.
New script from the same guy who created autocrat and formmule.
Originally shared by Andrew Stillman (Personal)
After some debugging help from this community, the tallyHo script is now in the gallery. Jolly good hunting everyone!
See documentation at: http://cloudlab.newvisions.org/tallyho
What does it do, exactly?
It’s a poor-man’s multi-conditional COUNTIF (e.g. COUNTIFS — not possible in G-Sheets), which is frequently accomplished via =COUNTA(IFERROR(FILTER()) or a =COUNTA(QUERY()). The key advantages with tallyHo over these formulas are: simplicity, reduced Spreadsheet complexity, and the ability to reach across spreadsheets to tally values without pushing data between them.
Description not so helpful for the spreadsheet newbie, eh? What each of those formulas above does is count the number of occurrences of a matching criterion plus some additional criteria.
Examples:
I want to count the total number of form submissions in another spreadssheet that match a particular username with a date greater than 7 days ago.
I want to tally the number of absences for a particular student (matching student ID) in the past 10 school days and in the past 20 school days.
I want to count the number of courses with an average below 65 for each student in my school, using a data dump from our eGradebook solution imported weekly into another Google Sheet in Drive.
New script from the same guy who created autocrat and formmule.
New script from the same guy who created autocrat and formmule.
Originally shared by Andrew Stillman (Personal)
After some debugging help from this community, the tallyHo script is now in the gallery. Jolly good hunting everyone!
See documentation at: http://cloudlab.newvisions.org/tallyho
What does it do, exactly?
It’s a poor-man’s multi-conditional COUNTIF (e.g. COUNTIFS — not possible in G-Sheets), which is frequently accomplished via =COUNTA(IFERROR(FILTER()) or a =COUNTA(QUERY()). The key advantages with tallyHo over these formulas are: simplicity, reduced Spreadsheet complexity, and the ability to reach across spreadsheets to tally values without pushing data between them.
Description not so helpful for the spreadsheet newbie, eh? What each of those formulas above does is count the number of occurrences of a matching criterion plus some additional criteria.
Examples:
I want to count the total number of form submissions in another spreadssheet that match a particular username with a date greater than 7 days ago.
I want to tally the number of absences for a particular student (matching student ID) in the past 10 school days and in the past 20 school days.
I want to count the number of courses with an average below 65 for each student in my school, using a data dump from our eGradebook solution imported weekly into another Google Sheet in Drive.
An amazing 4th grade teacher in DPS, Jessica Raleigh, is doing this with her students.
An amazing 4th grade teacher in DPS, Jessica Raleigh, is doing this with her students. Anyone up for some collaboration?:
Our 4th and 6th graders are taking on a challenge to not just participate in the Hour of Code, but to facilitate coding in classrooms across our K-11. I’d love to get collaborative with other schools and do a share out on our learning or a collaborative coding project to wrap up Computer Science Education Week. Any ideas on how best to do this or teachers who want to play with us?
Originally shared by Code School
The Hour of Code is now just a few weeks away. If you haven’t heard already, Code School is supporting this unprecedented movement to help 10 million students try computer science this December (9-15). We’re asking you to join us.
If you’re interested in participating at your school or work – see: http://csedweek.org/participate
If you’re interested in helping promote this awesome event – see: http://csedweek.org/promote
Thanks 🙂