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!




Student Password Generator With Google Forms- GSuiteEdu Made Easy


As teachers get settled into the beginning of their school year, there are many different things that are stacked onto a teachers plate. Assessments, baselines, behaviors, procedures, and even instruction. One thing that gets over looked is how we teach technology specifically the process of signing inuser name and password management. One of the most important edtech skills we can teach students is password management but often times we are ordained from on high a password scheme that is either exactly the same for each student or quite difficult to memorize, it also doesn’t give any relevance to the student.

With many other trends in education, student choice is becoming key to an engaging all of our students.  I believe that giving students choice in their learning including the use of educational technology promotes personal ownership in the process. While getting ready for bed, I got a brilliant idea to help make student;s passwords personalized. (Mrs. Reed didn’t appreciate this excitement at 11:15pm at night) To provide students with a personal choice password, I set up a Google Form that is simply two questions for them to fill out.

Gsuite Password Generator-Blog

(There is no way to share a Google Form that I know of so I attached the Google Form which you can recreate easily. Let me know if there is a nifty hack to share a copy of a Google Form)

Screenshot 2017-08-24 at 7.03.46 PM

  1. Choose an animal name with a choice of 6 different animals with pictures. (I included a picture as well to allow students of all levels to access.
  2. Type in a four digit number (You can set Response Validation to Length-Minimum Character Count-4 to make sure that they have at least four digits.

You can gather the student’s emails in the Google Forms settings which listed in the response form. From the two cells from the two answers of the animal name and the number, you can combine the two cells using the following formula

=CONCATENATE(C2,D2) for example C2= Elephant D2=8831 E2 would combine to equal Elephant8831.

Screenshot 2017-08-24 at 7.39.31 PM

From here you can collect your student’s password and paste them into the Google Sheet you use to maintain user names/passwords and reset your student’s password on if you have access to this. You can adjust the animals to whatever options you want including PBIS vocabulary, scientific terms, or High Frequency Words. Let me know how you set up passwords for your students including best practices for digital citizenship.

I hope this helps and makes your Google Apps experience with the littles an experience full of creation, collaboration, and creativity.

Up next for this series on getting started with Google Apps in the new year is a post how to easily create Login cards for Google Apps with a simple extension and a Google Sheet. 

Update: Thanks to the awesome reference by Christine Pinto who pointed at an Alice Keeler article on how to share Google Forms 5 Steps to Share a Copy of a Google Form

Update 2: If you are just starting with your class on Google before initial login onto Chromebook, have a open Google Form on a laptop open for students to fill out. I would add a short form input field to collect student names which will let you update their passwords before first login.

Be mindful if your Gsuite Edu domain have a default password for first login and a setting enabled to change password after first login. This will negate customizing your student’s password on first login. I manually logged in any new Gsuite users to customize their password with this method.

Native Printing in Chromebook

It appears with update 59 of ChromeOS for Chromebooks, you can now add printers manually to a Chromebook just like you would an network printer to Windows. No longer do you have invoke the ancient scrolls of CUPS extension and perform a ritual sacrifice in order print something from your HP 14 or Acer R11. Google Cloud Print just doesn’t work all the time and is a pain to deploy across a school or group of users.

To access the print features simply go Chromebook Settings-Printer-Add Printer. Presto! Connect your classroom printers through local network configuration or USB to your hearts desire.

Another great option if you wanna throw in your bag of tricks is a great Chrome extension IPPS/CUPS printer extension for Chrome which is a simple UI that allows you to connect to a wifi enabled printer. There is also a Google Admin version for mass deployment.

Forward to your CTO and you might even get an extra mouseball or RAM stick in your Christmas stocking.

How do you manage your printers in class or at your school?


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