Generating Easy GSuiteEdu Login Cards

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 PasswordScreenshot 2017-09-02 at 9.06.16 AM

Once you populate your students’ information into the Google Sheet,  you will need to go download the Avery Label Merge Google Docs Add-on


Screenshot 2017-09-02 at 9.34.57 AM

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.

This slideshow requires JavaScript.

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). Screenshot 2017-09-02 at 9.19.02 AM

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.

Screenshot 2017-09-02 at 9.32.12 AM

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!




Chromebook Gestures


Today’s blog post is a request from Carol McLaughlin who asked if there was an easy list for Chromebook gestures. I am a huge fan of shortcuts, gestures, and hit keys that make using computers, laptops, and tech hardware easier to use with less clicks per task.

Chromebooks generally have a single touchpad which is different than Windows PCs who have a touchpad and two physical buttons that are synonymous with a physical mouse. One of the great things that Chromebooks have done is incorporated gestures into the ChromeOS to navigate native apps and Chrome browser. Google released a nice list of gestures for Chromebooks found here. Chromebook Gestures List



Getting used to gestures and incorporating them into your work flow make tasks more efficient, less time consuming, and sometimes even seem like magic. One of my favorite gestures I discovered in accident as a secondary feature to the 3 finger tap. The three finger tap is magical when using it correctly. The primary feature of the 3 finger tap to open up a hyperlink in a new tab. As a teacher, every morning I open my Chrome browser on my Chromebook to access the 5-7 apps and websites that I need on a daily basis for my lessons. This was a time consuming task when so I had so many other things things to do in the morning before students walk through that door. I managed the bookmarks by keeping them in a Bookmark folder called “Daily” on the bookmark bar which I clicked each individual link with ctrl+click. This took time and was extremely annoying.

While listening to Google Teacher Tribe, Math Miller stated his favorite hack was a OSX feature that allow you to open up all bookmarks in a folder in one shortcut but there was no Chromebook gesture or shortcut. There had to be a better way for the sake of Chromebooks. One day I realized through an accident triple tap that all of my links opened in tabs and this became my new favorite gesture.

As I am teaching my students best practices with technology, I love to teach shortcuts and gestures that will make their workflow on a laptop or computer easy and efficient. My students find shortcuts with Chromebooks like a magical spells that I have bestowed upon them from Hogwarts. First graders and second graders are completely capable of using shortcuts and gestures on a Chromebook to navigate. This generation is a touchscreen generation so gestures are second nature when utilizing a Chromebook. Heck, my students love to show me new and faster ways to complete tasks on a Chromebook. In our classroom, we celebrate this new light bulb moments and make them the expert of that hack. This is all apart of our growth mindset classroom culture.

“Too easy Mr. Reed. Too EASY!”

For more info on Chromebook shortcuts, check out out one of my favorite blogs on Google Apps for Education, who had an awesome guest post on this topic including teaching how to use a trackpad to littles.

Go #gafe4littles and #2ndchat

Let me know what is your favorite gesture on a Chromebook is and what useful ways do you use the 3 finger tap gesture to open up Bookmarks.

Thanks for reading..Shawn