Comments

Document Sample
Comments Powered By Docstoc
					Summarizing Students' responses to open-ended questions.
Here is an example explaining how to use an Excel spreadsheet for summarizing students' responses to open-ended questions.

                                         Students' comments




                                                                                        Categories extracted from students' responses
                                                                                      Clear
                                                                                   presentation
            Student                                                                 of course     Instructor    Good course      Prompt              Too heavy
 Stdt ID     Name Q1 - Comments about the course                    Good overall     contents       helpful      materials      feedback              workload
    1         S1    Overall this class was excellent. Professor         1               1              1
                    was very helpful in answering all our
                    questions and to get a good understanding
                    of the subject.
    2         S2    I liked how the class time was spent                1                                             1                 1
                    reviewing recent articles or other issues
                    relevant to us. I really liked the lecture that
                    went over oral presentations.
    3         S3    Best teacher ever. This guy has never               1                             1               1
                    failed to provide useful and interesting
                    information, no matter how complex the
                    question. His area of expertise extends
                    well beyond what the book covers.
    4         S4    Very helpful to students. Very intelligent          1               1
                    and explains things well.
    5         S5    Instructor teaches the subject extremely            1               1
                    well and keeps it interesting. Assignments
                    are challenging and well integrated with
                    lecture.
    6         S6    The diagrams and drawings on the board              1                                             1
                    are very good and helped me understand
                    the material very well. The lectures were
                    well-planned and good...I really enjoy this
                    class, even though I wasn't really
                    interested in it before this semester. I got
                    good insight into how computers really
                    work.




     Filename: bdd2533d-070c-4667-9ba3-58132be7da9a.xls.xls                                                Copyright (C) Center for Enhanced Learning Teaching, HKUST
                  Count                                                    6   3   2                 3                  1                 0



                                              Summing the column
                                              gives you the number of
                                              student responses that
                                              mention this conceptual
                                              category - "Good overall".




Filename: bdd2533d-070c-4667-9ba3-58132be7da9a.xls.xls                             Copyright (C) Center for Enhanced Learning Teaching, HKUST
  Coding students' responses.
  Based on students' responses, conceptual categories (or
  themes or ideas) are extracted. "1" in a cell indicates that the
  student response in that row mentions the corresponding
  concept in that column.




Filename: bdd2533d-070c-4667-9ba3-58132be7da9a.xls.xls               Copyright (C) Center for Enhanced Learning Teaching, HKUST

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:4
posted:10/15/2011
language:English
pages:3