Use Google Sheets to create a set of passwords for bulk user upload

We look at how to create a large number of randomised passwords for our younger students.

  1. (manually) put together a list of common easy to spell 5-8 letter words

  2. Use 'LEN' and 'CONCATENATE' and 'RANDBETWEEN' to generate a word+number combination to a specific length

  3. Paste values only into another column to store a larger set of passwords for bulk upload.