I found this activity very challenging once I got to working on the spreadsheet and using the formulas. For creating the form I used a section quiz I just gave my students a few weeks before school was out that dealt with the civil war. To gain the responses I asked my wife, brother and nephew to complete the quiz.
Creating the quiz was very simple as I just finished the previous activity that helped get us started with Google Forms. Working with the spreadsheet though was something that was new to me, it was not new in using a spreadsheet it was new as in using the formulas in the spreadsheet. I made a few mistakes but the spreadsheet was quick to show a red color to show an error so it was easier for me to pinpoint where the mistake was and correct it. I found myself referring to the Easy way to create a self-correcting Google Form often as I set up the formula to both correct and to average the grades. I went away from the instructions given in the video as when I clicked to sum the columns I saw that you could also average, once I clicked that I highlighted the cells I wanted averaged and then clicked enter.
Using this in the classroom would benefit the teacher greatly as it makes the time spent grading papers free up for planning or other activities. On the part of the student I can see them enjoying this more than simply passing out the papers. Since completing this project I am now wanting to use it for a chapter test of sorts in my classroom. The only issue I see that could arise would be trying to have students complete an essay question, that is something that would be hard pressed to be self graded as the students answer would not match the key perfectly.
Chapter 19 Section 5 Quiz
Self Grading Spreadsheet
ISTE NETS*T
As for NETS*T standards I feel the following applies.
1. Facilitate and Inspire Student Learning and Creativity
A. Promote, support, and model creative and innovative thinking and inventiveness
D. Model Collaborative knowledge construction by engaging in learning with students, colleagues, and others in face-to-face and virtual environments
2. Design and Develop Digital-Age Learning Experiences and Assessments
A. Design or adapt relevant experiences that incorporate digital tools and resources to promote student learning and creativity
C. Develop technology-enriched learning environments that enable all students to pursue their individual curiosities and become active participants in setting their own educational goals, managing their own learning, and assessing their own progress.
D. 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.
3, Model Digital-Age Work and Learning
A Demonstrate fluency in technology systems and the transfer of current knowledge to new technologies and situations.
C. Communicate relevant information and ideas effectively to students, parents, and peers using a variety of digital-age media and formats
D. Model and facilitate effective use of current and emerging digital tools to locate, analyze, evaluate, and use information resources to support research and learning.
4. Promote and Model Digital Citizenship and Responsibility
B. Address the diverse needs of all learners by using learner-centered strategies and providing equitable access to appropriate digital tools and resources.
I feel that these standards are hit because we are taking a standard item such as a quiz and changing it to meet the needs of a variety of situations or student needs. By creating these assessments and placing them online and instructing students that they have a timeline when it comes to completing them we are having students take charge for themselves in their learning instead of us telling them that on Monday we are taking a quiz. By taking a quiz I had given previously and changing it to a digital format I am able to access tools that will help me analyze student progress efficiently.
No comments:
Post a Comment