Data Dictionary
Organisation
An "Organisation" represents a school or any other institution that uses Komodo.
Relationships
- Organisations have 0-N Groups
- Organisations have 0-N Students
- Organisations have 0-N Years
- Organisations have 0-N Survey Blueprints
Student
A "Student" represents a student that an Organisation has.
Relationships
- Students belong to 1 Organisation
- Students belong to 0-N Groups
- Students belong to 0-N Years
- Students have 0-N Normalised Survey Responses
Group
A "Group" represents a grouping of Students that an Organisation has, e.g. a school house.
Relationships
- Groups belong to 1 Organisation
- Groups have 0-N Students
Year
A "Year" represents a year grouping of Students that an Organisation has, e.g. 1st year, 2nd year.
Relationships
- Years belong to 1 Organisation
- Groups have 0-N Students
Metric
A "Metric" represents a metric that may be associated with a given Survey Library Question, e.g. Homesickness, School Workload.
Relationships
- Metrics belong to 1 Metric Theme
- Metrics have 0-N Survey Library Questions
- Metrics have 0-N Normalised Survey Responses
Metric Theme
A "Metric Theme" represents a grouping of Metrics, e.g. Achievement & Learning, Emotional Wellbeing.
Relationships
- Metric Themes have 0-N Metrics
Survey Library Question
A "Survey Library Question" represents a survey question that is set up in Komodo, e.g. "I enjoy learning at school".
Relationships
- Survey Library Questions belong to 1 Metric
Survey Library Question Answer
A "Survey Library Question Answer" represents a survey question's possible answers, e.g. "Agree", "Strongly Agree".
Relationships
- Survey Library Question Answers belong to 1 Survey Library Question
- Survey Library Question Answers have 0-N Survey Responses
Survey Blueprint
A "Survey Blueprint" represents a survey that an Organisation has set up in Komodo.
Relationships
- Survey Blueprints belong to 1 Organisation
- Survey Blueprints have 0-N Surveys
Survey Blueprint Question
A "Survey Blueprint Questions" represents a Survey Library Question that has been added to a Survey Blueprint.
Relationships
- Survey Blueprint Questions belong to 1 Survey Blueprint
- Survey Blueprint Questions belong to 1 Survey Library Question
- Survey Blueprint Questions have 0-N Survey Responses
Survey
A "Survey" represents a Student's requirement to complete a Survey Blueprint between during a specific date range.
Relationships
- Surveys belong to 1 Student
- Surveys belong to 1 Survey Blueprint
Survey Response
A "Survey Response" represents a Student's response to a survey question for a specific Question in a specific Survey.
Relationships
- Survey Responses belong to 1 Student
- Survey Responses belong to 1 Survey
- Survey Responses belong to 1 Survey Blueprint Question
- Survey Responses belong to 1 Survey Library Question Answer
Normalised Survey Response
A "Normalised Survey Response" represents a Student's responses to a survey, aggregated by the relevant metric(s).
Example
If a Student responded to a survey on June 15th with 3 questions associated with the Happiness Metric, 1 Normalised Survey Response record would be created for Happiness. That record would contain the average score of those 3 questions.
Relationships
- Normalised Survey Responses belong to 1 Metric
- Normalised Survey Responses belong to 1 Student
- Normalised Survey Responses belong to 1 Survey
Check-in
A "Check-in" represents a student either requesting a check-in with a staff member, or a check-in automatically generated based on their recent survey responses.
Examples
Generated check-in
If a Student responded with a low score for the Happiness Metric in their most recent 3 surveys, a check-in would be generated to let staff know to talk to the student.
Requested check-in
A Student is able to request a check-in with one or more staff members, letting them know they need somebody to talk to.
Relationships
- Check-ins belong to 1 Student
- Check-ins have 0-N Check-in Reasons
Check-in Reason
A "Check-in Reason" is a reason that a student has had a "Generated check-in" automatically created for them.
Examples
A Student responds with a low score to a given Metric to several Surveys. Komodo Wellbeing will automatically generate a check-in for them, with a reason attached to it linked to that Metric.
Relationships
Check-in Follow Up
A "Check-in Follow up" represents a staff member recording that they have talked to a student regarding a given Check-in.
Relationships
- Check-in follow ups belong to 1 Check-in