When we studied media literacy, students helped design the survey about media use (including a separate survey for parents), took the survey, then analyzed the results. We did most of the activities F2F in class so we could do small group work, and also to support Excel use, which is one tool that doesn’t come easily to most students. Among our findings: kids text a great deal more than parents do, while parents watch more TV, but both groups use Facebook.
I use the free version of SurveyMonkey, which is amazingly versatile – good for gathering information, and for assessing understanding – and middle school students seem to both enjoy taking surveys and seeing the aggregate results.
The free version of SurveyMonkey is limited, though. In the past, I used a paper survey for media literacy, and was able to separate out the results by gender. I discovered this wasn’t possible using the free version, since it doesn’t allow for downloading the results. It did allow us to ask about how students use lots of media tools, though, by using the matrix of choices. Next year, I’ll use identical surveys, one for boys, and one for girls. (Good ol’ workarounds!)
As the year is winding down I’m going to use another survey, replacing the past paper survey with SurveyMonkey again. Some things I want to ask are: which activities students enjoyed the most and least, what they wished we had done but didn’t, what they thought about working with Moodle, advice for next year’s students. In the past, it took me so long to go through the year-end paper surveys, I didn’t have a chance to share the results with my students. This year, they’ll be able to see the totals right away; we can discuss the results as a class. Then we can all learn something from the survey, not just me.
Showing posts with label Excel. Show all posts
Showing posts with label Excel. Show all posts
Thursday, April 21, 2011
Thursday, April 7, 2011
Raising the bar
This year I’ve been teaching our high school 1-semester Technology course for the first time (though I’ve taught middle schoolers technology for a decade).
One thing has been apparent both semesters – it’s time to raise the bar. Our technology requirement is seriously out of date; we require students to be able to demonstrate that they can keyboard at a reasonable speed (25 wpm with no errors), and can competently use Microsoft Word, PowerPoint, and Excel.
Here’s the thing: students come into class already capable users of Word and PowerPoint, and usually able to pass the typing test without practice. Only Excel gives them problems.
But there are so many other critical skills my students need, including:
· evaluating websites and internet information for validity (a gaping skill deficit here)
· evaluating their digital footprints and online safety
· finding and figuring out how to use free internet tools
· avoiding plagiarism online
· collaborating with others using technology.
If we require that students have technology skills to graduate, shouldn't these skills be included? I teach all these skills, usually in a cross-disciplinary framework. But how should I assess them? Since these aren't part of the formal requirement, my assessments here have been formative - lots of practice and feedback.
It’s easy to do a summative assessment of whether a student knows how to use Word or Excel; I give them a task and see how well they accomplish it. Either they’ve shown me they know how to bold text or use a header, or they haven’t.
But these newer skills are based on judgment, so inevitably the assessments I use are about judgment. So how do I assess these skills?
Rubrics, here I come.
One thing has been apparent both semesters – it’s time to raise the bar. Our technology requirement is seriously out of date; we require students to be able to demonstrate that they can keyboard at a reasonable speed (25 wpm with no errors), and can competently use Microsoft Word, PowerPoint, and Excel.
Here’s the thing: students come into class already capable users of Word and PowerPoint, and usually able to pass the typing test without practice. Only Excel gives them problems.
But there are so many other critical skills my students need, including:
· evaluating websites and internet information for validity (a gaping skill deficit here)
· evaluating their digital footprints and online safety
· finding and figuring out how to use free internet tools
· avoiding plagiarism online
· collaborating with others using technology.
If we require that students have technology skills to graduate, shouldn't these skills be included? I teach all these skills, usually in a cross-disciplinary framework. But how should I assess them? Since these aren't part of the formal requirement, my assessments here have been formative - lots of practice and feedback.
It’s easy to do a summative assessment of whether a student knows how to use Word or Excel; I give them a task and see how well they accomplish it. Either they’ve shown me they know how to bold text or use a header, or they haven’t.
But these newer skills are based on judgment, so inevitably the assessments I use are about judgment. So how do I assess these skills?
Rubrics, here I come.
Labels:
Assessment,
Excel,
powerpoint,
rubric,
skills,
technology,
Word
Subscribe to:
Posts (Atom)