Data Analysis

The 7th grade is back in the tech lab, ready to go in 2010. We spent our first period together reflecting on Fall Semester.
On the last day of school in December, students took an online self-reflection survey to share their experience with the first 3 months of iCLAST (integrated class of language arts, science and technology).
Today we took the anonymous quantitative data from that survey and explored trends between student submissions. Students were also given a data set from the 08-09 school year for comparison.
The QOD (Question of the Day): Based on student ratings, was last school year’s iCLAST more difficult than this year?
Aaron came closest to cracking the data. He used a formula to figure out how many students assigned each rating and then graphed the results.
The formula: =COUNTIF(Sheet1!$A$2:$A$38, “1″) and repeat while replacing the “1″ with the rating given.
His resulting charts looked like this – enjoy drawing your own conclusions:

Comments are closed.
