Steps

Here are some steps you can take to make a basic comment generator. Once you're comfortable, you can try out some more advanced concepts. These steps specifically use Google Sheets.

1. Create a new spreadsheet.

2. Create two tabs: one labelled "data" and another entitled "comments."

3. On the data tab, populate a column with your most often-used comments.

4. Create an outline on the comments tab with a title and general information every student will receive.

5. Below your outline, select a cell and then choose menu options Data > Data validation.

6. Choose "Add a rule" and select "Dropdown (from a range)" in the Criteria field.

7. Then, select your data range, and you're done!