Learning is Change

What I'm Learning: The Facilitation Toolbox

I came across this toolbox for helping folks to facilitate online learning and online communities of practice. I really like the advice that they present, as well as their focus on curating and facilitating experiences. I also really like that they used a Google+ hangout to help develop the content for this organic course structure.

Facilitation Toolbox :: Home

Are you interested in solving the problem of digital engagement? We are too. This website is designed for practitioners that want to develop online environments to build and sustain new audiences by using facilitation techniques that affect learning in these informal spaces. Below you’ll find different tools that we believe can help you successfully facilitate an online environment.

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/

http://www.coreeducationllc.com/blog2/defining-personalized-learning/

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.