flickr photo shared by mrkrndvs under a Creative Commons ( BY-SA ) license

One of the biggest challenges when introducing a new application, such as Google Apps or Global2, is setting up the new accounts. Although programs often make it easy enough to create the accounts in bulk, the challenge is communicating this to students. My answer has been to merge cards for the students using Microsoft Publisher. This involves three steps:

Making a Spreadsheet

The first thing to do is to make a spreadsheet in which you collect all the information required. I find that it is always good to have a document with all this sort of information in one place. I use a few ‘concatenating‘ tricks in Google Sheets that I picked up via Alice Keeler to help combine different pieces of information and then download as a CSV to turn formulas into text and numbers. It is important to use clear headings for each of the columns.

Create a Template

The next step is to create a template. For this step, I use Microsoft Publisher. I begin by choosing a business card template and then enter all the appropriate information. This can include name, website, username and temporary passwords etc …

Produce the Merge

Once I have something that looks like a finished product, I click on the Mailings tab and work through the Step-by-Step Mail Merge Wizard. This includes selecting the appropriate spreadsheet (choosing comma), inserting the various fields and checking through the previews.  Once satisfied, I then print the merge.

Although I have come to use Google Apps for for many things and could possibly use Autocrat, this is still one thing that I still find easiest to do with Microsoft.

So what about you? What steps do you take to support students with new programs? Feel free to share below.

If you enjoy what you read here, feel free to sign up for my monthly newsletter to catch up on all things learning, edtech and storytelling.

Merging Passwords and New Accounts by Aaron Davis is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.

2 thoughts on “Merging Passwords and New Accounts

  1. Prashanth Kv breaks down the process for creating a strong password in Google Sheets. This breaks down all the various steps, such as random letters, upper and low case, as well as special characters, in the creation of a formula.
    =ArrayFormula(vlookup(mid(A2,2,1),Sheet2!$A$2:$B$27,2,0)&JOIN("",char(if(ISEVEN(code(split(REGEXREPLACE(LOWER(A2),"(.{1})", "$1,"),","))),code(split(REGEXREPLACE(LOWER(A2),"(.{1})", "$1,"),","))-32,code(split(REGEXREPLACE(LOWER(A2),"(.{1})", "$1,"),",")))))&vlookup(right(A2,1),Sheet2!$A$2:$B$27,2,0)&right(text(B2,"mmm"),1)&mid(text(B2,"yyy"),2,3)&day(B2))
    Alternatively, Zak Kolar created an add-on for Google Sheets that generates passwords in a similar style to DinoPass.
    This could be useful when generating/managing bulk account/password creation.


  • Aaron Davis

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: