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!


LearnBytes episode #6 – Michelle Bowditch: Do these 4 things when facing uncertainty or frustration

Samantha is joined by Michelle Bowditch, the founder of Door 20A and a Tech Lover, Educator Connecter & Advocate for Executive Assistants.

In her race against the clock, Michelle shares the 4 things you can do when facing uncertainty or frustration – even with little things like tech problems! We also hear some great podcast recommendations & a handy tip for planning your podcast listening.

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: