in Tools for Working

Merging Passwords and New Accounts


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.

Aaron

I am an Australian educator supporting the integration of technology and innovation. I have an interest in how collectively we can work to creating a better tomorrow.

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

Mentions

Continue the conversation

Comment

To respond on your own website, enter the URL of your response which should contain a link to this post's permalink URL. Your response will then appear (possibly after moderation) on this page. Want to update or remove your response? Update or delete your post and re-enter your post's URL again. (Learn More)

Webmentions

  • Aaron Davis mentioned this on readwriterespond.com.