|
This is version 25.
It is not the current version, and thus it cannot be edited.
[Back to current version]
[Restore this version]
| Question # | Question Text | Analysis | Data Sources | How user might query |
|---|
| 1 | Have my course grades declined over the years? | ANOVA of course grades, individual exam grades | Faculty uploaded spreadsheet with records of student grades for each year | Log-in as myself, check-off my courses that I am interested in analyzing |
| 2 | Why are my course grades declining? Are more students taking AP (bio) and placing out of this course? | Relationship among ACT/SAT scores, AP bio scores, course grades | Registrar demographic data: ACT/SAT scores, AP Bio scores; course grades; Faculty uploaded spreadsheet with records of student grades for each year | Log-in as myself, check-off my courses that I am interested in analyzing |
| 3 | Has the use of clickers improved student learning in my course? | Correlation (regression) between clicker use, clicker score(s) and exam scores | Registrar demographic data; Faculty uploaded exams, tagged by topic; Faculty uploaded clicker questions, tagged by topic; Faculty uploaded spreadsheet with: Annual records of student grades, Student grades on individual assessment items, Student grades or responses on individual clicker items | Log-in as myself, check-off my courses that I am interested in analyzing. Within courses, I will mark assessment items of interest (clicker questions on topic a, assessment questions on topic a) |
The following use cases and database requirements come from weekly meetings of the Database Development Team.
| Meeting Date | Use Case Description |
|---|
| April 13, 2007 | I would like to tag these assessments with my own Blooms data |
| April 13, 2007 | I would like to code these assessments according to my own taxonomy |
| April 13, 2007 | I would like to know the answers and point values for this assessment item (or items) |
| April 13, 2007 | I would like to know the grading rubric for this assessment item (or items) |
| May 18, 2007 | I would like to find assessment items that address a particular misconception |
| May 18, 2007 | I would like to upload my non-MC exams and student responses.
Student responses are a scanned image -or- electronic. |
April 13, 2007
May 4, 2007 | Identifying information of students, faculty and universities must be removed |
| April 13, 2007 | I would like to import data directly from my course management software (e.g. Angel, Blackboard, WebCT, etc) |
| May 4, 2007 | I would like to import student response data directly from my excel workbook |
| April 13, 2007 | There must be a minimum level of data/metadata included for a submission to be accepted into the database |
| May 18, 2007 | What areas or concepts in biology/chemistry/physics are students having difficulty with? |
| May 18, 2007 | How did students do on all questions of a given topic?
-within a class
-within a course
-within an institution
-across the database |
| May 18, 2007 | How did students do on a question that required a certain level of thinking? |
| May 18, 2007 | I would like to find those questions on topic X where students did particularly well or poorly (depending on my own criteria of good and bad) |
| May 18, 2007 | Compare performance of two (or more) groups of students on an item or set of items
-over time (this year versus last year)
-gender or ethnic background
-majors or non-majors |
| May 18, 2007 | Find questions based on format (clicker, mc, short answer, etc) |
| May 18, 2007 | Find questions that include a particular format element (i.e. graph, particular model or image, etc). |
|
