LearningToTalk / L2TDatabase

Helper functions for working with our lab's MySQL database
GNU General Public License v2.0
0 stars 0 forks source link

create CDI tables #19

Open tjmahr opened 8 years ago

tjmahr commented 8 years ago

Six-ish tables required. Need to split main inventory from extension because there are cases where we have one but not other.

CDI Main Inventory

  1. Administrations: Date, child, notes. 1 row per administration
  2. Checklist responses: Administration, word, checked. 1 row per word in administration.
  3. Other questions: Administration, item, answer: 1 row per question in administration. Still need to think through design of this section.

CDI Extension

  1. CDI Administration. Date, child, notes. One per administration.
  2. Checklist responses. Administration, word, checked. 1 row per word in administration.
  3. Other questions: TBD Same design as above.
tjmahr commented 7 years ago

We only have item-level information for the CDI Words and Sentences, because the extension's items were not part of the Google Form. We have summary level information for both surveys.

tjmahr commented 7 years ago

First confirm with NL that she has entered all the paper survey. Send her a list with all CDIs we have.