Posts

Showing posts from October, 2019

Making Password Cards from a Google Sheet

Image
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 O