Analyzing Student Data in a Spreadsheet

This was an exercise to learn Google Sheets. We were to practice altering data from a spreadsheet and create a graph from the specified data. The data in this particular spreadsheet reflects the test scores of 12 students whose scores were below the class average of 191.92, for tests 6 through 10 of the grading period.

As one notices in the Growth Trend chart below the spreadsheet, improvement is made by all. Even though a few students relapsed temporarily, they eventually rejoined the group's overall progress. This graphic and colorful charting capability will be a wonderful visual for those students and teachers wanting to quickly assess their own progress.

Here is the full data sheet.

Google Sheets reflects any updates instantly, which is of course a tremendous time saver in the world of data entry. By establishing the initial data spreadsheet, all I had to do to create a chart from that data was simply click a few times, and voila!, all the data was translated into the chart of my choice immediately. The documents you can generate; tables, charts, and graphs will surely bring any presentation to life. Having a visually graphic and colorful representation is a great reinforcer for student's learning. The fact that data reflects real life variables in useful and relevant applications is an asset in constructing engaging lessons for optimal learning plans.

Since I have no prior computer content knowledge in Excel, perhaps this will be easier than unlearning a program. I would like to think so. Yet another enticing tool to explore.

Link: