![]() We'll explore more charts, graphs, and add-ins in future posts. Just something to consider as you work with various projects. But they don't auto-update and can sometimes be quirky as you close/re-open a workbook. I am totally sold, so to speak, on the freeware sparklines. This is one of the reasons why I built the graphs in the "Roll Your Own Gradebook" series as full-size before minimizing. ![]() So, if you like the idea, but are nervous about being on your own, you might want to check out Microcharts. When it comes to sparklines, there are commercial options. In other words, you get what you pay for. The other downside isn't so much one associated with add-ins as it is with freeware: your options for support are pretty minimal. If you use an Add-In, keep in mind that in order for other people to use the workbook, either they have to have the add-in or you will have to save the workbook as a macro-enabled workbook (it's one of the options you have). This format would take some getting used to, but what an awesome option to include for teachers. The median for each assignment has been derived and "stop light" coding applied so a teacher can easily see how the class is doing. This graph summarizes the performance of the entire class. ![]() ![]() This is what sparklines do: they condense a lot of data into one bite (byte?) sized container.Īt the bottom of the list is a bar graph. Notice that each of the line graphs are about the size of a student's name. We can look for patterns and have a very concise view of what is going on. We get a picture of each student's performance.
0 Comments
Leave a Reply. |