Colour code for 2025 Transition Sheet

1. Teacher Details (current teaching staff)
2. Specify 2025 Teachers (for learners)
1. Option 1 Using Learner/Teacher Match Sheet
2. Option 2 (manual process)
3. Record Status (staying/leaving)
4. Comment Notifications

2024-2025 Edublogs Transitions

Where to find your school sheet - Looker

Each edublogs admin account will have edit permission for their sheet. (Manaiakalani accounts have view access)

Sort by cluster find by school. Do not make a copy

1. Teacher Details Current teaching staff

1. Add missing Teacher Titles and Surnames (for taglines)
2. Identify which teachers have left
3. Add email addresses for new teachers

​

​

​

2. Specify Teacher - Using Learner/Teacher Match Sheet

Option 1 - Good for large schools.

​

1. If you have a list of your learners and their 2025 teachers, you can put the list in the “Learner/Teacher Match ” tab.

This will automatically bring the right teacher email through onto the ROLLOVER Tab.

In hub spaces you can have multiple teachers emails, comma delimited in column B. Hub names will replace teacher names in taglines when processed.

2. Specify Teacher - Manually Select Teachers

Option 2

• Pick your teachers from the dropdown list.

3. Record Learner Status

Staying or Leaving/Left

Leavers

​

Any learners marked as leaving/left will show in the Leavers tab. If you know where they are headed, please complete column E

1) Sort by Column I (Teacher email)

​

2) Use link in column J to update Comment notifications with 2025 teacher email (you will need to be logged in as admin)

​

Option + Return will open multiple edublogs on the right page

4. Comment Notifications

Taglines

We will bulk update the taglines for you.

�The teacher name comes through from the Teacher Details tab, and the Year level comes from Column G. If there are gaps in this data, the taglines become more generic.

​

If your schools have a different tagline or the auto-generated one is wrong, please let us know and we will work with you to update these.

Eg If you want a tagline like

“I am a Year 11 learner in the Kowhai hub at Bay of Islands College in Kawakawa, New Zealand”��

If you have teachers who have left - mark this on the Teacher Details and we will archive their class blogs.

Class Blogs

Missing learner Blogs from your list?

Email awhina@manaiakalani.org with the blog URL and we will sort it.

Once your sheet is updated, email to awhina@manaiakalani.org to signify completion. You will receive an email when the automated part of the transition is complete.

​

The blogging support site will you step you through the remainder of the process need to be completed (comment notifications and removing teachers no longer associated to the blog - teachers can complete this step)

​

If your learners don’t transition to a High School within the network we will initiate an archive of left/leaving blogs in early Term 1 2025.

FAQ

1. Do all teachers need to be added to the teacher details tab? �This a list of all teachers who have edublogs accounts for this school. If they are new to the school (and will be blogging), or new to blogging then add them here.
2. I’ve added Year Levels to the Learner/Teacher Match tab, but they aren’t coming through to 2.ROLLOVER, what do I do?�You can either email awhina@manaiakalani.org and we will sort for you, or you can use a Vlookup formula.

=VLOOKUP(C2,'Learner/Teacher Match'!A:C,3,FALSE)

The data we want matched. Here it’s student emails

Where is it looking? You can highlight this on the next tab

What column is the data you want in? Ie C=3 (third column)