One of the biggest fears that teachers often have to overcome is teaching students how to log into their Google GSuiteEdu account. There upper case letters, lowercase letters, shift key presses, funny characters, and let’s not forget about the infamous @ symbol. It strikes terror in their hearts and they can not get pass that point. Yet logging into their Chromebooks with time and practice will literally become second nature. I know it is painful but so listening to Dr. Seuss being read by a 15 first grader in blending mode. Loved my firsties.
One of the easiest ways that I have found to help students learn to login and be consistent at it is to provide a clear login card that is visually simple and easy to read. Using Google Docs a template, a simple add-on and a Sheets database, you can easy whip out colorful login cards for all of your students.
To get started, you need to create a Google Sheets database with the following column headers: First Name, Last Name, Google Email, and Google Password
Once you populate your students’ information into the Google Sheet, you will need to go download the Avery Label Merge Google Docs Add-on
To get started Click Add-Ons, Avery Label Merge, New Merge.
Select your size of label that you would prefer. I really like using the Name Badges, 8395 Series with the 8 labels per sheet with separation because it makes it easier to cut out and you can more cards on a page.
You will select your desired Spreadsheet from Drive and then it will return to Avery label merge. Make sure that you have the correct Spreadsheet listed. If you are working in a large database, you can select amongst Sheets and also decide which rows need to be generated in case you have that new student.
To get started, simply place your cursor where you want a field to be inserted and then click on the column headers on the right side. Once you have placement, you can customize with fonts, sizing, and spacing. Be mindful about long username and passwords.
I’ve included my Google Login Card template for easy login card creation but fill free to make your own. With playing with the template that is provided, try not to make the text box bigger than is provided or formatting when the cards are generating will not turn out like you want. It does take some trial and error especially with font size and inserted artwork. (I really wish you could overlay images in Google Docs).
Once you are satisfied with your template, click the blue Merge button on the bottom and Avery Label Merge will run it’s magic. It isn’t the fastest Add-On so it takes a few moments but once it is ready, it will popup a link to the new Google Doc with your beautiful new Google login Cards.
Let me know if you have any comments or suggestions on how you generate login cards for your students. How do your students manage them in their desk for safe keeping.
If you are interested in learning more about getting your students logged in easily and without tears, go check out my friend Christine Pinto’s blog at Christine Pinto- Colored Tape She uses some neat conditional formatting and colored tape to really make Chromebooks accessible for littles.
Next week, I will show how to generate a single page sign on sheet for all of your student’s logins. One page to rule them all!