Let me preface this post by saying that I am not particularly knowledgeable at sifting through data nor am I a spreadsheet ninja. That said, I want to share a couple tips that I’ve found helpful since, as of late, we’ve spent a lot of time talking about data in my district.
CSV Export is Your Friend
If your learning management system allows you to export reports to CSV then you can take your class roster, grade data, etc. and put it in a spreadsheet program like excel or Google Sheets. You can also paste multiple classes into one spreadsheet making it easier to look at trends across classes.
Conditional Formatting is also Your Friend
The GIF below shows how to turn on conditional formatting to make it easy to visualize your data in Google sheets. I set two conditions, one to make cells green if the percentage was greater than 80% and red if it’s below 80%. This makes it easy to quickly look at long lists of data to see general trends.
Like I said, I just wanted to share these for anyone just getting started in looking at and analyzing data. You can see/copy the spreadsheet shown in the GIF here. Let me know if you have any beginner tips you’d like to share in the comments!