Making Password Cards from a Google Sheet

Hi! At our school, students get started with Google for Education accounts in grade 2. The randomly generated password provided to students is a real challenge for them to type, not to mention to memorize. So students practice logging in to their Google account multiple times in their Technology class. The teacher has an index card with each student's name, username, and password. She hands them out to students in need, until eventually, they don't request it any longer. With 160 students in the grade 2 generation, it's a daunting task to try to manually create these cards and avoid making any mistake.

I found a way to automate this task and eliminate any errors and provide a similar solution as to what the teacher currently was successfully using. Here are the steps to follow.

1- Create a list with all necessary data in Google Sheets.
The names of the column headers will be used in the following steps as fields. For example:


2- Create template in Google Slides
Open a Google Slide and add text boxes. Format as necessary. The field names that will be active should be between << >>  For example:

3- Install Add-on Autocrat
In the spreadsheet, go to the menu Add-Ons --> Get add-ons. Look for Autocrat.
 

4- Set-up Autocrat
5- Run Autocrat
Press play > and let Autocrat do its magic!
Once it finishes the process, you will have a brand new Google Slides file with a slide for each of the rows in the Google sheet.

6- Change page set up in Google Slides
The trick is to change the print settings. Change it to 6 or 9 slides per handout.
  

7- Print slides/cards.
You will end up with something like this. Now just print and cut the cards!

Cheers!



Comments

Post a Comment

Popular posts from this blog

Hello World!

Hello World! This is how I started my first tweet some years ago and this is how I start my first public blog. I am trying to reach anyone out there that shares the same interests I have. The purpose of this blog is to share my experience as a technology trainer at an elementary school. I will be posting what has worked for me, any resources I recommend, and in general, the day to day experiences I go through in my daily life. Check back frequently and feel free to comment and share your experiences too. Let the learning begin!
Read more

Creating QR Codes

Image
Last week, fourth grade students started working on a project about Native Americans. They will create an exhibit of the different tribes that includes artifacts, pictures, posters, and QR codes. Parents will be invited, along with other teachers. The kids are so excited preparing for this special day! What is new to the kids is what is a QR code, how to create one and what to do with it. Well, QR code stands for Quick Response code. It works in a similar way as barcodes do. In this case, the image is a matrix that shows an arrangement of squares.  A QR code contains information. It could be a URL, text, a telephone number, etc. In order to "read" a QR code, you will need a QR scanner. There are apps you can download to your mobile device and easily read these codes. The iPad app we use at school is called " Scan ". There are two QR code generators I suggest using : QR Stuff In this application, you ...
Read more

Discovering Add-ons & Scripts

Image
Hi! It's back-to-school time. I hope your school year is off to a good start. As for me, it's been a very busy season. I can tell you that, amongst many other events, two major situations take place each year at my school: Open House and New Google Apps accounts. What's so special about these two? They both require a great deal of prepping and tech assistance. For instance, during Open House, the Tech Integration Team takes advantage that all the parents are present to have them register for tech orientation sessions. A couple of years ago, we'd lay out long sheets of lined paper, one for each different session, with a limited amount of lines. In the next years, we decided to take it a step further and created a Google Form. We had laptops available during each of the Open House nights and asked parents to register electronically to a tech session. While parents were submitting forms, I'd be in the background, checking numbers against the capacity we had fo...
Read more