Friday, October 25, 2013
5-2 Activity: Organizing Data 5-1 Discussion: Debriefing
https://docs.google.com/spreadsheet/ccc?key=0Ag9CXUpMSG3JdDl3LXAyczBnYWhMenlHSWJlY1lQamc&usp=sharing
Which spreadsheet tool did you use?
• Google Docs
What do you see as its strengths and weaknesses?
• Strengths: The fact that you can edit the spreadsheet is very useful in that the shared documents can be manipulated and used by others. You don’t have to install it on your computer, Google docs is a web 2.0 tool that anyone with access to the Internet can use it.
• Weaknesses: It would have been great if it had graph capability to revel patterns in student learning.
Did adding color to the spreadsheet help identify any potential problem areas?
• Yes. After adding color to the spreadsheet it was evident that fifty percent of incorrect answers were with in four five and six. These findings would allow the teacher to reflect and possibly create new customized follow-up lessons.
How could you apply spreadsheet functionality to authentic classroom or school-wide scenarios?
• Attendance spreadsheets can keep tally on students tardy and attendance. Spreadsheets giving data on grouping in contrast to individual learning.
• Developing a spreadsheet on the integration of a particular technology into a classroom vs. traditional lesson.
Debrief and report on any observations or trends that you discovered in at least one paragraph. Offer some thoughts to help the instructor with how to help best serve her students.
• While interring the data into the spreadsheet it was evident that a couple students were defiantly struggling with the material. There may be many reasons for this. Possibly a behavior issue, disability or just the lack of interest, etc. I would suggest that the instructor research why these students are failing and then as a team come up with some sort of intervention. Possibly integrating a type of technology to increase engagement.
• As the spreadsheet developed it was also apparent that the class as a hole needed retaught standards within questions four five and six. I would suggest revisiting the lessons and then compare and contrast with standards taught with in questions one two and three.
Subscribe to:
Post Comments (Atom)
Jason, there are ways to insert graphs (charts) into a Google Spreadsheet, I just don't know enough about the formulas yet to know how. I also know that if you use a form to collect the data, you can make a chart out of its data. I don't know how reliable it is, but I know it can be done. Wish I knew more about the formulas, maybe I should take a spreadsheeting tutorial!
ReplyDeleteGreat post,
Megan
Thanks Megan.
Delete