I love the new checkboxes feature in Google Sheets, just wondering the timeline for coming to GSuite. Only seems available in me Gmail account.
Notice in this peer evaluation Form below that the students would enter the names of their peers and the project title. This has a high probability of messy data. As a teacher, you will want to sort and filter the peer evaluation results by each student’s project. For this, you will want each students name and project title spelled exactly the same.
This is another great example of the power of the URL. I love the possibilities of this, especially when combined with Google Sheets to provide a means of managing variables. Keeler also provides templates to work from.
David Krevitt walks through creating a custom formula for conditional formatting. He is correct in saying that there are not many posts or reflections written about this. The formula that he uses (which can be found here) highlights a value found in a separate list in a separate tab:
=match($F12, indirect("'rangeTab'!$B$12:$B") ,0)
I have used the following formula to highlight a whole row based on the contents of one cell:
Krevitt now has me wondering what else I could do.