Exclusive first look – setup Google Classroom with this Google Sheets add-on

I have been speaking with Blake Seufert from Naavi about the development of this add-on for a while now, and am glad it is now available to schools.

If you are using Google Classroom, you will enjoy this ad-on.  Blake has written the following how-to post, if you have any questions let Blake or the UTB team know.

Naavi Classroom Sync is here! A simple add-on for Google Sheets that can setup your classes in Google Classroom with one easy process. Whether you’re a teacher or school administrator, Naavi Classroom Sync can save you some serious time.

Let’s take a look at how it works:

Create a new Google Sheet and click the Add-ons menu > Get add-ons. Search for Naavi Classroom Sync and click the +Free button to install.

Once installed, it’s time to setup each class in our spreadsheet. Use the image below as a guide. In this example we’ve used a simple example of a teacher with 3 classes and a few students in each class.
Tip: To save even more time, you could copy and paste a list of students from your timetable or student management suite into the Google Sheet.

 

Classroom Sync_1

Note: If you’re the school domain administrator you can take your timetable export (import a CSV or Excel file into Google Sheets) and map the columns to pre-setup all student and staff classes in Google Classroom.

Naavi Classroom Sync let’s you create Google Classroom Classes from a class list in Google Sheets! Click To Tweet

Once you’ve entered all your data, simply press the Sync Courses button!
Check the log to make sure the sync completes without error. If successful, it should look like this:

Classroom Sync_2

You will also get an email confirming the sync has completed successfully or any errors that it encountered.

Now let’s take a look in Google Classroom and see what has been setup:

Classroom Sync_3

As you can see, the classes have been created and are ready for you to accept!

Note: You may notice the student count is at 0 as students are only ‘invited’ at this stage. Once they accept the invitation you will see the student count rise. Students will appear in the ‘Students’ section of the Classroom with ‘(invited)’ next to their name until they join. If you set up classes from a domain admin account, students will be forced to the class, skipping the invite process.

Classroom Sync_4

And that’s it! If you want to know more, check out http://classroomsync.naavi.com for a video walkthrough and template to help you get started!


Gmail_7

Create multiple signatures in Gmail

A common question I get asked when training our corporate and government clients is ‘Can I have multiple signatures in Gmail?’. While Gmail doesn’t have a dedicated multiple signature function, the good news is that you can use the Canned Responses lab instead. In this blog post, I’ll show you how to use Canned responses to create and insert multiple signatures.

VIEW POST

Scratch 3.0 – What’s new?

Scratch 3.0 is available to try in beta version and it has some awesome new features. I’ll show you a couple of them in this video. If you’ve never used Scratch before or are an old pro you’ll be delighted by how much computational thinking can be developed in this user friendly system to design games, animations and stories.

VIEW POST

How to save a Gmail search

If you’ve mastered Gmail’s advanced search, you’ve probably found that you are frequently performing the same or similar searches. Because we love to help you be more efficient, in this post I’ll show you how you can save Gmail searches to speed up the process even more!

VIEW POST

Top tips for working from home by a remote working team

  With Google Drawings a lot of people don’t realise that it actually sits inside Google Docs. Inside Google Docs you actually have the Google Drawings tool. Under insert you’ve got Drawings and now there are two places that you can get a Drawing from. The ‘New’ is going to

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