Use conditional formatting in Google Sheets to analyze data and grades

Use conditional formatting in Google Sheets to analyze data and grades

Use conditional formatting in Google Sheets to analyze data and grades. After a formative assessment, you can use a Google Sheet to analyze student performance on individual items on the assessment. This will allow you to spot trends in the students answers, to which you’ll need to investigate what students answered the way they did…