Competency-aligned curriculum and assessment
Traces learning evidence from submissions through rubric criteria to program competencies. Original worked design example; adapt responsibilities, thresholds and assumptions to your system.
Rendering…
What this template contains
- Diagram type
- Entity-relationship diagram
- Source
- 49 lines
Make it your own.
erDiagram
PROGRAM ||--o{ COURSE : includes
COURSE ||--o{ COURSE_COMPETENCY : targets
COMPETENCY ||--o{ COURSE_COMPETENCY : mapped_by
COURSE ||--o{ ASSESSMENT : evaluates
ASSESSMENT ||--o{ RUBRIC_CRITERION : defines
COMPETENCY ||--o{ RUBRIC_CRITERION : evidenced_by
LEARNER ||--o{ SUBMISSION : submits
ASSESSMENT ||--o{ SUBMISSION : receives
SUBMISSION ||--o{ CRITERION_RESULT : earns
RUBRIC_CRITERION ||--o{ CRITERION_RESULT : scores
PROGRAM {
string program_id PK
string name
}
COURSE {
string course_id PK
string program_id FK
}
COMPETENCY {
string competency_id PK
string statement
}
COURSE_COMPETENCY {
string course_id FK
string competency_id FK
}
ASSESSMENT {
string assessment_id PK
string course_id FK
}
RUBRIC_CRITERION {
string criterion_id PK
string assessment_id FK
string competency_id FK
}
LEARNER {
string learner_id PK
}
SUBMISSION {
string submission_id PK
string learner_id FK
string assessment_id FK
}
CRITERION_RESULT {
string submission_id FK
string criterion_id FK
string score
}