If you’re familiar with Google Sheets formulas, you can use unique() and vlookup() to write a solution that works for your sheet. If you previously copied the old version, you’ll need to make a new copy to get the updates.ĭuplicates are still possible if you generate passwords at several different times unless you replace the previous passwords. I’ve updated the code to check for and prevent duplicates when generating passwords. I found about 5-6 duplicates per 1,000 passwords when I tested it. Preventing duplicatesĬraig Ham pointed out that in the original version of the template, it was possible to get duplicate passwords when generating in bulk. Changing the initial list of words from which passwords are generated (see below) may slightly improve security, but is not a substitute for a strong, randomly-generated password. These are more secure than sharing the same password with everyone or assigning passwords in a predictable/numeric way, but they are not on par with modern best security practices. ![]() These passwords should not be used for high-security purposes. If you notice any problematic combinations, let me know and I’ll revise the code. However, once your passwords are generated, I’d recommend double checking them before giving them to students. I’ve done my best to make sure the word combinations and numbers are school appropriate kid-friendly. Here's an interactive tutorial for the visual learners If you don't see it for a while, refresh the page.Ħ The first time you run the add-on, you'll need to authorize it.ĩ Now you'll see a list of fun, unique passwords in the cells you selected. This menu sometimes takes a few extra seconds to show up after the spreadsheet loads. You can select as many rows/columns as you'd like. type a column header for passwords)ģ Select the cells you'd like to fill with passwords. Click here to open the tutorial in a separate window.ġ Make a copy of the Password Generator Template.Ģ Set up your spreadsheet however you'd like (e.g. See the following tutorial for a demonstration. I created an add-on for Google Sheets that generates passwords in a similar style to DinoPass. This makes the process quick and painless once you have a list of passwords, but manually copying and pasting from DinoPass for an entire class, grade, or school would get extremely tedious. ![]() Some services (such as Scratch) allow you to upload a CSV file with usernames and passwords. It’s quick and easy, and the kids absolutely love the crazy combinations it creates.īut sometimes, I need to create accounts in bulk. When I’m creating a handful of accounts for kids to use, this is my go-to source for passwords. Each password follows the format NounAdjectiveNumber (all lowercase). To help solve this problem, Codemoji built a tool called DinoPass to generate passwords that meet all these requirements. They should be unique, hard to guess, and easy to type. ![]() When creating accounts for younger students, passwords can be a hassle.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |