Conditional Formatting + Colored Tape + AutoCrat = Easy Logging in for K2 Students
Younger students can have difficulty logging in to computers, especially if they don't have prior experience with computers. By using a modified version of Christine Pinto's template, you can create a bunch of cards at one time.
- Excel (must be Excel) Spreadsheet of student usernames and passwords
- Autocrat Template (force copy available at the link)
- 'To Merge' Template (force copy available at the link)
- CombineSheets Sheets Add On
Skill Level/Time required:
- 30 minutes
- Be sure that usernames and passwords are on two different sheets within your Excel spreadsheet.
- On your usernames tab, navigate to Data --> Text to Columns.
- Choose Fixed Width --> Next.
- Click between each character to draw a line. Hit Finish.
- Repeat this on the passwords tab.
- On 'To Merge' Template, input students' first and last names.
- From your Excel sheet, copy character-separated usernames and paste them into the Google Sheet in the cells entitled "un1 to un19". Repeat this for passwords in the cells "pw1-pw5." Add or subtract cells as needed, and be sure to update any changes on your Autocrat template.
- Install/run AutoCrat in your 'To Merge' Template. For explicit directions on AutoCrat, click here for an overview or watch the video directions below.
- Open one of the newly-minted sheets. Install/run the CombineSheets add on. Combine all of the Sheets you just created.
- Open the same Sheet from step nine. Click the down arrow on the tab and choose 'Copy to...' the new Sheet you created in step 9.
- Use the format painter to 'grab' the format from the new tab. Apply it to the entire sheet.
- Format as necessary.
- Print and (laminate, if desired).
Implementing with your students:
- Color code your keys according to the directions in Christine Pinto's original blog post.
- The numbers are red taped, the QWERTY row is yellow, the ASDFG is green, and the ZXCV row is purple (or pink if your color printer went rogue like mine!)