Thing #18 – Dig the Data

Spreadsheets and Charts from School Data!

Using Google Sheets, I was able to take a closer look at my district’s data for the 7th Grade MEAP testing in math.  I looked over a 5 year time-frame, and I was able to investigate how the economically disadvantaged students compared to those without an economic disadvantage.  I sorted the Sheet in the year column, only because it made the most sense.  You can find the Sheet as well as a bar chart by following the link.


Perception and Process Data!

I had to change the questions a bit in my Perceptions and Process data from Thing #17 in order to get some data that I could actually analyze.  I ended up re-asking teachers how many hours they spent outside of the regular class time with students per week, on average, and then what they actually did with students.  From there, I asked teachers if they felt the school was safe and how many referral forms they handed out to students, on average, per week.  The results were quite interesting.  It looks like the more teachers were involved and willing to be advisors, coaches, and tutors outside of the regular class time, the more likely they were to view the school as safe and to give out less referral forms.  I was able to sort the data by first names only, which are fictitious to protect those that were willing to help me out again, and I calculated both sums and averages of the numeric columns.  The chart gives a clear picture of the information.  You can see that they higher the time spent with students, the lower the referrals.  Also, the less time spent with students, overall, the more referrals.  You can find this information in Google Sheets.

In the Classroom!

Online polling could be used in the classroom at the end of a unit exam or test.  I could quickly ask students how much time they spent studying for the assessment, total.  I could then ask them to reveal their letter grade.  I could take those two pieces of information and quickly create a quick and easy spreadsheet and chart that would allow students to see (hopefully) that they more time spent studying does pay off in the end.  This would be done anonymously, of course, to protect student grades.  We could also collect data about how much time students spend watching tv or browsing the internet and compare that to the current grade in the classroom.  I am pretty sure the results would not be surprising to educators or parents.

ISTE Standards

1a Promote, support, and model creative and innovative thinking and inventiveness – Collecting data and analyzing into some form of useful information certainly models that creative and innovative thinking.

2d Provide students with multiple and varied formative and summative assessments aligned with content and technology standards, and use resulting data to inform learning and teaching – Taking the information from a recent test or even an informal exit slip will give the instructor enough information to inform the direction of the curriculum.

3b Collaborate with students, peers, parents, and community members using digital tools and resources to support student success and innovation – The data that is collected and analyzed could be shared with students, parents, and even members of the community so show progress.  It’s difficult to just say the students are performing better in math, but when you can show them a tangible piece of evidence that supports that claim, the results are difficult to argue.

CITW – Best Practice

Setting objectives and providing feedback – With spreadsheets, it is easy to set a specific objective and track the results.  Perhaps an instructor collects data, ensuring that all students will perform at grade level by the end of the school year.  Through frequent assessments an analysis of data, an instructor can adjust the instruction methods to make every student successful.

Reinforcing effort and providing recognition – That same spreadsheet could be used to determine which students are still struggling and need some extra help.

Cues, questions, and advanced organizers – The very format of a spreadsheet and the chart itself lend themselves to belong in the advanced organizer category.  Encouraging students to look for and understand what the spreadsheet means can allow them to begin to clarify the information.

Non-linguistic representation – The quick and easy charts that can be created with the information provided in the spreadsheet can simply tell the story of the data.

Assigning homework and practice – Students could be assigned the task of creating a spreadsheet and chart, and then analyzing the information.

Identifying similarities and differences – Through some quick analysis of the information collected in the spreadsheet and the chart, the user will easily be able to find some comparisons.  For example, in the chart provided above in part 1, a pattern quickly develops, showing that the economically disadvantaged students are doing poorly both in our district and across the state.  Gaps in the data can be found.

Generating and testing hypothesis – The analysis of this data will allow students both to make a prediction of what the data will show, and to test that prediction.  Students can predict what will happen if they study more, and when the spreadsheet and chart are created, chances are that they will see that the more you study, the better your grade on the test.


One thought on “Thing #18 – Dig the Data

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s