| At line 2 added 41 lines. |
| + The following use cases and database requirements come from weekly meetings of the Database Development Team. |
| + |
| + ||No.||Status||Meeting Date||Use Case Description||Decision Made?||dBase as Test Bank||User training/\\documentation||Content metadata||Course Metadata||Query related||System Requirement||Must/Should/Nice to have |
| + |1|partial|April 13, 2007\\September 18, 2007\\June 19, 2007|[Tagging assessment items|Use Case 3]: with Blooms data, concept categories, learning objective, some other taxonomy\\tag in multiple ways\\tag with multiple raters|yes - will support| | |x| | | |Must |
| + |2|partial|July 3, 2007|[Assessment items will be tagged according to a domain specific ontology|Use Case 4]\\Biology ontology: NBII Biocomplexity Thesaurus\\Ontologies must not be rigid -- must allow for additions.|yes - will support|x| |x| |x| |Must |
| + |3|drop|February 4, 2007\\MU-L\\JLM|[Rubrics|Use Case 5]: database must support multiple rubrics for an assessment item\\multiple scores for an assessment item\\multiple raters of an assessment item|yes - will support|x| |x| | | |Must |
| + |4|partial|April 13, 2007|[Data storage|Use Case 11]: Must store raw response data for assessment items\\point values for assessment items and assessments (i.e., entire exams)\\student grade on assessment item|yes - will support| | |x| | | |Must |
| + |5|complete|December 4, 2007|[Data return format|Use Case 6]: rectangular|yes - will support| | | | | |x|Must |
| + |6|incomplete|February 4, 2008|[Return of assessment items|Use Case 12]: We will use a shopping cart model for users to choose assessment items\\Returned questions will be in QTI format; faculty can use other software to translate to exam|pending|x| | |x| | |Must |
| + |7|incomplete|May 18, 2007\\October 9, 2007|[Data upload|Use Case 13]: non-MC exams and student responses.\\Student responses are a scanned image -or- electronic.|yes - will support| | | | | | |Must |
| + |8|complete|February 7, 2008|[Security|Use Case 7]: Faculty who upload data must agree that any identifying information in student responses has been removed\\any identifying information in their syllabus that they do not wish to be published in the dBase has been removed.|yes - will support -- how?| | | | | |x|Must |
| + |9|complete|April 13, 2007\\May 4, 2007|[Security|Use Case 7]: Student ids will be hashed with a unique identifier\\Faculty and university ids could also be hashed.\\data is returned completely anonymous\\queries are constrained so as to not return a limited dataset that could identify a student.|yes - will support| | | | |x|x|Must |
| + |10|partial|July 3, 2007\\November 6, 2007|I have [additional data/metadata|Use Case 14] I would like to upload. Where can I do that?|yes - will support|x|x|x|x| | |Must |
| + |11|verify|February 18, 2008\\MU-L\\JLM|[Editing environment|Use Case 15] for data: how can faculty fix errors in data they have uploaded?|yes - will support| | | | | |x|Must |
| + |12|complete|April 13, 2007\\September 18, 2007\\KBS|[Minimum metadata requirements|Use Case 8]|yes - will support\\have been defined| | | | | |x|Must |
| + |13|complete|May 4, 2007|I would like to [import student response data|Use Case 16] directly from my excel workbook|yes - will support| | | | | |x|Must |
| + |14|incomplete|June 19, 2007|[Demographic data|Use Case 9] will be available for all queries.\\Faculty uploaded demographic data must be tagged with the date they were current.|yes - will support| | | |x| | |Must |
| + |15|complete|August 30, 2007|The database must handle [multiple instructors|Use Case 17] for a class.|no| | | |x|x| |Must |
| + |16|complete|August 30, 2007|Faculty members must be able to indicate pages on an exam that are blank, devoted to a figure, picture or formula|yes - completed?| | | | | |x|Must |
| + |17|complete|September 11, 2007|Database will treat [sections of a course as separate courses|Use Case 18].\\How can we alleviate work for a faculty member uploading the same assessment for 60 sections of a very large course?|yes| | | |x|x| |Must |
| + |18|complete|October 9, 2007|[Query: track students over time.|Use Case 10]|yes - will support| | | |x|x| |Must |
| + |19|drop|May 18, 2007\\June 19, 2007|Metadata query: Query for common misconceptions|yes - will support|x| |x| | | |Must |
| + |20|complete|July 31, 2007|[Non-traditional assessments|Use Case 19]: Scientific reasoning instruments, concept inventories, published assessment\\Assessment items will not fit a discipline-based ontology|yes|x|x|x| |x| |Must |
| + |21|partial|June 12, 2007|I would like to [query across data levels|Use Case 20] (i.e. query for particular assessment items at an institution over time and courses|yes - will support| | |x|x|x| |Must |
| + |22|partial|August 30, 2007|There will be two levels of data access: Private (visible only to the individual who uploaded the data) and Public (visible to all registered users)|yes - will support|x|x| | | | |Should |
| + |23|-|November 6, 2007|Multiple taxonomies: the database will support multiple taxonomies. All taxonomies will be viewable by all registered users; however, some taxonomies can only be implemented by specific individuals (e.g., professional society tags of 'good' assessment items)|yes - will support|x| |x| |x| |Should |
| + |24|-|December 4, 2007|Query: Search database on a paticular type of institution, based on the Carnegie classification system.|pending| | | | |x| |Should |
| + |25|-|December 4, 2007|Save search history syntax in order to repeat search at some point in the future.\\Alternatively, return search syntax with query results.|pending| | | | |x|x|Should |
| + |26|-|KBS|I would like to filter out low-level Bloom questions, multiple choice questions, essay questions, etc.|pending| x| | | |x| |Should |
| + |27|-|KBS|Fostering collaboration: Faculty contact information will be available for all faculty who opt to provide such information.|yes - will support| | |x|x|x| |Should |
| + |28|-|KBS|Unconventional assessment items: database will store the item\\Student response data (excel, word files, etc) will also be stored.|yes - will support|x| | | | |x|Nice |
| + |29|-|November 6, 2007|I have no idea how to classify my assessment items.|no| |x| | | | |Nice |
| + |30|-|May 18, 2007|Query: Find questions based on format (clicker, mc, short answer, etc)\\Find questions that include a particular format element (graph, image, model)|pending -- can this information be gleaned from the parsing software?|x| |x| |x| |Nice |
| + |31|-|June 19, 2007|Query: What concepts are considered difficult across disciplines. Will the database compute dynamic metadata such as the difficulty of an item? Such data would change based on the data from the students. Difficulty and other performance metrics should be dynamic, rather than asking faculty to upload them.|pending - will we provide simple analysis?|x| |x| |x| |Nice |
| + |32|-|December 4, 2007|Data analysis: simple analysis of change over time returned with the data.|pending| | | |x|x| |Nice |
| + |33|-|January 10, 2008|Syllabus: Will not be query-able and will only be anonymous if the faculty uploading removes identifying information.|yes - will support| | | |x| | |Nice |
| + |34|-|Purdue|Who can access data across courses/faculty members? Adiminstrator use to demonstrate compliance of accreditation standards.|pending| | | | | | |Nice |
| + |35|-|November 27, 2007|User will be able to search nbii thesaurus and with a mouse click, add that concept tag to their assessment item(s).|yes?|x| |x| | | |Nice |
| + |36|-|April 13, 2007|I would like to import data directly from my course management software (e.g. Angel, Blackboard, WebCT, etc)|outside current scope| | | | | |x|Nice |
| + |
| + ---- |
| Lines 26-81 were replaced by line 67 |
| - ---- |
| - The following use cases and database requirements come from weekly meetings of the Database Development Team. |
| - ||No.||Meeting Date||Use Case Description||Decision Made?||dBase as Test Bank||User training/\\documentation||Content metadata||Course Metadata||Query related||System Requirement||Must/Should/Nice to Have |
| - |1|June 19, 2007\\KBS|I would like to consolidate and archive my data and metadata.|n/a| | |x|x| | |Must |
| - |2|April 13, 2007\\September 18, 2007\\June 19, 2007|Tagging assessment items: with Blooms data, concept categories, learning objective, some other taxonomy|yes - will support| | |x| | | |Must |
| - |19|July 3, 2007|Assessment items will be tagged according to an ontology|yes|x| |x| |x| |Must |
| - |33|November 27, 2007|Database will use the NBII Biocomplexity thesaurus as the Biology ontology.|yes|x| |x| | | |Must |
| - |32|November 27, 2007|User will be able to search nbii thesaurus and with a mouse click, add that concept tag to their assessment item(s).|yes?|x| |x| | | |Should |
| - |34|November 27, 2007|Ontology for a discipline must not be rigid - additions must be possible.|yes?|x| |x| | |x|Must |
| - |52|February 4, 2008\\MU-L|Must be able to use different content metadata by discipline. While we can use the NBII thesaurus for biology, we need to have an API that can be used to define other metadata for other disciplines.|yes - will support| | |x| | |x|Must |
| - |3|April 13, 2007\\May 22, 2007|Rubric: I would like to upload or download a rubric for this assessment item(s)|yes - will support|x| |x| | | |Must |
| - |4|February 4, 2007\\MU-L\\JLM|This assessment (or assessment item) has multiple rubrics)|yes - will support|x| |x| | | |Must |
| - |55|February 4, 2008\\MU-L\\JLM|This assessment has been scored in multiple ways (see above).|yes - will support| | |x| | | |Must have |
| - |56|February 4, 2008\\MU-L\\JLM|This assessment has multiple and different raters on two (or more) different rubrics|yes - will support| | |x| | | |Must have |
| - |5|May 18, 2007\\June 19, 2007|I would like to find assessment items that address a particular misconception|n/a|x| |x| | | |Must |
| - |7|May 18, 2007\\October 9, 2007|I would like to upload my non-MC exams and student responses.\\Student responses are a scanned image -or- electronic.|yes - will support| | | | | | |Must |
| - |8|February 7, 2008|Faculty who upload data must agree that any identifying information in student responses has been removed|yes - will support -- how?| | | | | |x|Must |
| - |18|July 3, 2007\\November 6, 2007|I have additional data/metadata I would like to upload. -or- I made a mistake. Where can I do that?|n/a|x|x|x|x| | |Must |
| - |9|April 13, 2007\\May 4, 2007|Identifying information of students, faculty and universities must be removed|yes - will support| | | |x| | |Must |
| - |10|April 13, 2007|I would like to import data directly from my course management software (e.g. Angel, Blackboard, WebCT, etc)|outside current scope| | | | | |x|Should |
| - |11|May 4, 2007|I would like to import student response data directly from my excel workbook|yes - will support| | | | | |x|Must |
| - |12|April 13, 2007\\September 18, 2007\\KBS|There must be a minimum level of data/metadata included for a submission to be accepted into the database|Must define minimum metadata standards| | | | | |x|Must |
| - |13|May 18, 2007|Find questions based on format (clicker, mc, short answer, etc)|pending?|x| |x| |x| |Nice |
| - |14|May 18, 2007|Find questions that include a particular format element (i.e. graph, particular model or image, etc).|outside current scope| | | | | | |Nice |
| - |15|June 12, 2007|I would like to query across data levels (i.e. query for particular assessment items at an institution over time and courses|yes - will support| | |x|x|x| |
| - |16|June 19, 2007|I would like demographic data returned.|yes - will support| | | |x| | |Must |
| - |17|June 19, 2007|I would like to see what concepts are considered difficult across disciplines. Are we going to compute dynamic meta data such as the difficulty of an item that would change based on the data from the students? Difficulty and other performance metrics should be dynamic, rather than asking faculty to upload them.|pending - will we provide simple analysis?|x| |x| |x| |Nice |
| - |20|July 31, 2007|I would like to upload my scientific reasoning instrument.\\Questions do not fit a discipline-based ontology\\This instrument is administered at multiple institutions.|yes|x|x|x| |x| |Must |
| - |21|August 30, 2007|Each student, class, course, institution, faculty member must have a unique identifier.|yes - will support| | | | |x|x|Must |
| - |22|August 30, 2007|Faculty members must be able to indicate pages on an exam that are blank, devoted to a figure, picture or formula|yes - completed?| | | | | |x|Must |
| - |23|August 30, 2007|Who can access the database? -- One solution: Two levels of data: Personal data (visible only to the individual who uploaded) and Public (visible to everyone)|pending|x|x| | | | |Should |
| - |24|August 30, 2007|The database must handle multiple instructors for a class -and- visiting instructors (i.e. faculty who are not officially on staff at an institution)|no| | | |x|x| |Should |
| - |25|September 11, 2007|Database must deal with multiple sections of a single course.|yes| | | |x|x| |Must |
| - |26|October 9, 2007|Data is returned completely anonymized/partially anonymized/not anonymized.|yes - completely anonymized| | | |x| |x|Must |
| - |27|October 9, 2007|I would like to track a cohort of students over time.|yes - will support| | | |x|x| |Must |
| - |29|November 6, 2007|Query returns must be constrained so as not to return a limited dataset that could result in the identification of a student.|yes - will support| | | |x|x| |Must |
| - |30|November 6, 2007|I would like to find assessment items tagged as 'good' - search quality tags by a professional society.|yes - will support|x| |x| |x| |Should |
| - |31|November 6, 2007|I have no idea how to classify my assessment items.|no| |x| | | | |Must - user documentation |
| - |35|December 4, 2007|I would like data returned in a simple, rectangular format.|yes - will support| | | | | |x|Must |
| - |36|December 4, 2007|I would like data returned in some other format (what might those be?)|pending| | | | | |x|Must? |
| - |37|December 4, 2007|I would like to query all R1 institutions, based on the Carnegie classification system.|pending| | | | |x| |Should |
| - |38|December 4, 2007|I would like a simple analysis of change over time returned with the data.|pending| | | |x|x| |Nice |
| - |39|December 4, 2007|I would like my search history saved. Are we saving the query syntax or are we expecting to be able to reproduce the exact dataset? Can probably reproduce the dataset if the date that the data were uploaded is stored in the database and can be made part of the query.|pending| | | | |x|x|Should |
| - |40|December 4, 2007|I would like the details of my query returned with the results.|pending| | | | | |x|Should |
| - |41|January 10, 2008|Instead of answering a litany of questions, I will upload my course syllabus.|pending| | | |x| |x|Must |
| - |42|January 10, 2008|I would like my syllabus to be anonymized when uploaded.|pending| | | |x| | |Nice |
| - |43|February 7, 2008|User uploading data takes responsibility for anonymizing their syllabus.|yes - will support| |x| | | | |Must |
| - |44|February 4, 2008\\MU-L\\JLM|Will the syllabus be query-able? Doesn't seem likely. Need to revisit minimum metadata standards.|pending| | | | | | |Nice |
| - |45|KBS|I would like to filter out low-level Bloom questions, multiple choice questions, essay questions, etc.|pending| x| | | |x| |Should |
| - |46|KBS|I would like to find other faculty who are similar to me in teaching approach/assessment items/Bloom's level/etc.|pending| | |x|x|x| |Should |
| - |47|KBS|I would like to upload a published assessment (e.g. Concept Inventory).|pending|x|x|x| | | |Must |
| - |48|KBS|Database must store unconventional assessments (models, pictures, diagrams, etc).|yes - will support|x| | | | |x|Must |
| - |49|Purdue|I am an administrator and would like to use the database.|pending| | | | | | |Nice |
| - |50|Purdue|Administrator: would like to compare faculty based on:\\-student scores\\-average Bloom level per exam\\-average number of students taught a semester\\-course level taught|n/a| | |x|x|x| |Nice |
| - |51|February 4, 2008\\MU-L\\JLM|Administrator would like to show their program has met specific accreditation standards.|n/a| | |x|x|x| |Should |
| - |53|February 4, 2008|How will assessment items be returned? Will users pick out one question at a time, or will they check off those questions they are interested in downloading? What format will questions be returned - xml, QTI, etc?|pending|x| | |x| | |Must |
| + |
