Spreadsheets let you manipulate data through formulas. If you are often looking at the same criteria for different data points, you can set up formulas that recalculate whenever you change or update data (like with a new assessment). Here's a short tutorial on simple formulas (like "sum" and "average").
At the end of the above cheat sheet is a list of frequently used formulas, and a short video on how to use them below:
To visualize data, you may want to use conditional formatting, which a tool that allows the formatting of a cell change depending on the value of the cell or the value of a formula. For example, you can have a cell appear in RED only when the value of the cell is less than 80%. This video explains that process in Sheets:
Another way to visualize data is to create a chart or graph (pie, bar or otherwise). This can help you identify trends in student performance or correlations between interventions and achievements. The first part of this video demonstrates how to create a graph:
Although Google Sheets has additional functionality (and Microsoft Excel has much more), knowing how to share, use formulas, apply conditional formatting and insert charts should cover a lot of basic data analysis for PLCs to plan effective interventions.
