Case Study Analysis - Cross Tabulations

How does one collect real data from the case study and put it in a table?

The following is from the first data collected from the case study. This data was from the state and tells the number of students with different types of grades that were available to analyze.

Example of Data Collected:

  • 89 art students have math and language grades
  • 7 students have only math grades
  • 0 students have only math grades
  • 0 have both

Analysis may sound like a daunting task, but it actually is easier if one starts with breaking down the data and adding it up. Use cross tabulations or the process of counting data across a table and adding or averaging the results.

After-School Table 1: State-Collected Student Assessment Data


All categories for the fall of 2008 and the spring of 2009.

# or Regular Attendees

You have both math AND reading/language arts grades


You have ONLY math grades


You have ONLY reading/language arts grades


You have NEITHER math NOR reading/language arts grades




When counting the data, as in a cross tabulation, one is just counting, adding or averaging data and it can be done vertically and horizontally using quantitative or qualitative data.

Resulting Analysis

In the example above, count down to see the totals and this reveals there are 89 attendees who have both math and reading/language arts grades. For seven attendees, there are only math grades. Counting data vertically or horizontally produces numerical and/or categorical results. Counting data is the first level of analysis and this produces results. The result in this case is that the most useful data is for 89 attendees and not the data for 96 students because the objective of our analysis is to report on attendees who have both grades.