Google Classroom Scripts You Can Use

[podcast]

In this video clip, we talked about what useful scripts you can use with Google Classroom and  Google Docs.  

This video was part of an hour long Google hangout.  You can watch the whole hangout here

Transcript: Google Classroom Scripts You Can Use

_

Download PDF Transcript

Mike: So let me ask you a couple of questions about Google Classroom and then you can run it through. Obviously it is, I would say a lot of schools, Australia, New Zealand, ask a complete tool for into Dashboard or by Hapara, a lot of schools in New Zealand use Hapara because it was out before Classroom was even thought of, and because it was born in New Zealand there’s a lot of, not allegiance, but what’s the word I’m looking for, there’s a soft spot to it.

 

So we’re going to talk about the differences between the two as we go, but one of the questions that we’ve got here in terms of using Google Classroom is a bit of a high-end question to kick off with, but can research projects for Middle School be streamlined to Google Classroom, if so what script would be useful? It’s from the USA, and I don’t know what he means by streamline, but you might want to talk about some of the scripts that you’ve written.

 

Alice: Let me first just say when you talk about Hapara with Google Classroom, there’s very little conflict. You talking about a Venn-diagram they actually overlap with just this one part. Hapara does so many other things that Google Classroom doesn’t do, so whether or not you want to do that one feature, Classroom gives a nice interface.

 

For scripts wise, first of all there are no add-ons for Google Classroom, so anything that you’re doing when they talk about scripts is really scripts for Google Spreadsheets and Google Docs, you actually can’t use scripts for Google Slides, but you can for forms. One of the things I need to extract all of group work being out of the classroom folder class, so then it lists every single document that any student has turned in on any assignment, so that’s alicekeelr.com/listdocs if you go to alicekeeler.com/googleclassroom I’ve got a 100 blog posts just on Google Classroom.

 

Some of them are talking about how to use something like list docs, so you can keep that efficiency under. In terms of research project, I don’t know how I would specifically do the script for research projects, obviously it’s going to depend on what you’re outcomes are and different things like that, but I do have one alicekeeler.com/groupdocs , this allows you as you get your roster of all your students in your email address, and then you create some sort of template of the project that your students seem to be working on.

 

So it might be an MLA formatted paper, or a Google Slide that they’ll each contribute their own piece to, whatever your template is, and it will prompt you for the document ID, and you will create a copy of that document for each group. So the problem is that Google Classroom is not currently set up to do group work, when you make a document you can’t make it for the whole group, you have to make it one per student, which then I end up opening a lot of blank documents.

 

Which is no problem, I just rename it to blank, and it’s not really that big of a deal, but what’s nice in my script alicekeeler.com/groupdocs is that it shows explicitly for the group members, but not with the other students from the class. So if you’re group one you cannot look at group three until in Google Classroom the teacher can actually attach everyone’s projects as people can view, because of course they’re all on the drive.

 

So when they’re ready they can open that, so that’s nice if they’re research project is collaborating. Another script that I like to use in terms of research is alicekeeler.com/templatetab there’s a pattern here of narcissism, but it allows you to create a tab on a spreadsheet for every student in the classroom.

 

You’ve got your student names and then there’s a tab for each student around a graphic organizer so you have students crowd source their research. I love Jane Roberts she has this great ideas like here’s the book, we’re going to divide up the book and you’re going to find example of irony. So for the first section you find all these examples of irony and you post the example and what page number, but everyone’s doing it on the same spreadsheet.

 

So how I have a whole books worth of references so when I go to write my paper I have a lot of things that I can cite specifically, but I didn’t have to go through to find all the examples in the whole book. So that’s easily attached in Google Classroom, when you attach the documents in Google Classroom you have three options, in one of them everyone can view it, in one of them it’s my favorite, everyone can edit the same document, don’t do that with a test document. So those are the scripts that I use.


Download PDF Transcript


Teacher Motivation Explained Part 1

When looking at teacher motivation, the principles are exactly the same as student motivation.  There is no one thing that you can do to increase your motivation; but every principle that you understand and implement makes a difference. One of the principles of motivation that is often overlooked or misunderstood

VIEW POST

Stop Your Google Doc From Going Viral

There is a little known extra security feature in Google Docs that stops collaborators from sharing your docs with others or changing the permissions of the Doc   Here is how to make your Google Docs more secure:

VIEW POST
Outclassed Podcast

Fake News and Getting Google Search to Work For You Ep 27

Get Notified Of Future Episodes: Apple Podcasts | Spotify | Google Podcast | Stitcher | TuneIn + Alex | Podcast Addict | Podchaser | Deezer | Listen Notes In this Episode: To see all the OutClassed episodes go to utb.fyi/outclassed Podcast Episode Highlights: Coming Resources and links mentioned: Transcript: Mike

VIEW POST

Here’s What
Our Clients Say

PR Industrya

Client

In 2018, Using Technology Better designed and delivered a two phase post-migration training program for this New Zealand based graphic design firm. The initial goal of the training program was to reduce frustration with G Suite, with the long term aim of facilitating a change in culture and collaboration that can lead to transformative practices

Download your skills checklist to see how you score...

 

Sign Up Now
To Get The Latest Updates

 

Holiday Rescue Maker Camp

Student to agree to and tick:
Guardian to agree to and tick: