Learning is Change

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 🙂

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 🙂

An amazing 4th grade teacher in DPS, Jessica Raleigh, is doing this with her students. Anyone up for some…

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 🙂

Good example of soliciting collaboration.

Good example of soliciting collaboration.

Originally shared by Jeremy Bell

Hey I’m looking for some other math teachers out there interested in collaborating on a math blended curriculum.  I already have on built through Moodle LMS, but I think with other people we could take it to the next level.

I am doing a soft-launch of the Standards Toolkit community so that we can get a few more members and interactions…

I am doing a soft-launch of the Standards Toolkit community so that we can get a few more members and interactions populated before I invite the whole district (seriously, that is the scope of this). 

So, here is the pitch: 

Just as the Standards Toolkit is design to support your role in our shared effort to implement these standards, the online community is designed to support the toolkit and the people using it. Please ask questions and post responses about the toolkit or about the standards in general. If you don’t know where something is in the toolkit, you can ask. If you are finding something particularly valuable, you can share it. And if you have suggestions for how to make things better or specific resources you need, please go ahead and suggest them. This is our community, and it will be as strong as we make it.

Please start posting things if you would like to see this space grow with lots of folks from around the district adding their ideas.

I’ve been trying to develop a script that allows for copying the current sheet of a spreadsheet to a whole bunch of…

I’ve been trying to develop a script that allows for copying the current sheet of a spreadsheet to a whole bunch of already created spreadsheets within a folder (it asks for the folder key in a menu). I was able to get it to work once for another project and I thought it was good to go, but now it is throwing an error that I can’t figure out. Can anyone take a look and help out with this script or just point me in the right direction if you have done something similar?

For a little context, I am adapting this script (which also throws the same error and I thought I had fixed): http://igoogledrive.blogspot.com/2012/10/Google-Spreadsheet-Script-to-Copy-Sheet-to-multiple-Spreadsheets-at-a-time.html