Thursday, May 28, 2015

Data Analysis - Survey data

I would like to take a moment and profess my continuing love of Excel. I first fell in love as an associate account manager who put together sales reports and audited tens of thousands of lines of data for my accounts (VLookup, pivot tables, conditional formatting, and nestled IF statements!) But I'm falling in love all over again with descriptive statistics, correlations, paired t-tests, and ANOVAs. Now onto the data...I used descriptive statistics as well as looked to see if there were any correlations in my survey answers. Here's what I came up with.

Table 2

Student Survey Responses

Storytelling Lesson
TPR & Song Lesson
Questions
Mean
SD
Mean
SD
1. I get really involved in classroom activities
4.5
0.64
4.6
0.74
2. I actively participate in classroom discussions
4.2
0.86
4.3
1.10
3. I form new  questions in my mind as I join class activities
3.9
0.92
3.3
1.45
4. I compare things I am learning with things I already know
3.9
0.80
3.8
1.37
5. I work with other students and we learn from each other
4.1
1.03
4.3
0.88
6. I can understand the meaning of the lesson even though it's in Spanish
4.1
1.06
4.3
1.10



















There was a strong correlation between the male students’ responses to the survey question “I compare things I am learning with things I already know” (r=.54, p < .05) for the TPR & Songs lesson. There was also a high correlation between male students’ responses to the survey question “I work with other students and we learn from each other” (r=0.51, p < .05) for the TPR & Songs lesson. For both questions the male students in the class responded with Strongly Agree.

I was happy to see that students answered Agree (4) on question 6 "I can understand the meaning of the lesson even though it's in Spanish" for both lessons. I work hard to make sure that I'm giving students comprehensible input or Krashen's i+1. My literature review suggests that students who cannot understand are much more likely to become behaviorally disaffected so in both cases students reported that they understood what was going on during class.

No comments:

Post a Comment