Query patterns - AI Developer Tools for Education

Basic node queries

Fetch lessons by grade level

query {
  lessons(where: { gradeLevel_INCLUDES: "K" }, limit: 10) {
    identifier
    name
    gradeLevel
    courseCode
    timeRequired
  }
}

Relationship queries

Find activities and their materials

query {
  activities(limit: 5) {
    identifier
    name
    hasPartMaterials {
      identifier
      name
      materialType
      content
    }
  }
}

Get educational alignments

query {
 lessons(limit: 3) {
   identifier
   name
   hasEducationalAlignmentStandardsFrameworkItems {
     identifier
     description
     gradeLevel
   }
 }
}

Advanced filtering

Multiple grade levels

query {
  lessons(where: {
    gradeLevel_INCLUDES: "K"
  }, limit: 10) {
    identifier
    name
    gradeLevel
  }
}

Filter by subject and author

query {
  courses(where: {
    academicSubject: "Mathematics",
    author_CONTAINS: "Illustrative Mathematics"
  }, limit: 5) {
    identifier
    name
    author
    academicSubject
  }
}

Illustrative Math (IM) curriculum course level queries

List all courses in IM

Return all IM courses in the Knowledge Graph.

{
  courses(where: { author: "Illustrative Mathematics" }) {
    name
    identifier
    gradeLevel
  }
}

MATCH (c:Course {author:'Illustrative Mathematics'}) RETURN c.name, c.identifier, c.gradeLevel

List all units in a course

Get all units for Grade 6.

{
  courses(where: { name: "Grade 6", author: "Illustrative Mathematics" }) {
    hasPartLessonGroupings(where: { curriculumLabel: "Unit" }) {
      ordinalName
      name
      identifier
    }
  }
}

MATCH (:Course {name: "Grade 6", author:'Illustrative Mathematics'})-[:hasPart]->(u:LessonGrouping {curriculumLabel: "Unit"}) RETURN u.ordinalName, u.name, u.identifier

List all sections in a course

Return all sections for each Unit in grade 6.

{
  courses(where: { name: "Grade 6", author: "Illustrative Mathematics" }) {
    hasPartLessonGroupings(where: { curriculumLabel: "Unit" }) {
      ordinalName
      hasPartLessonGroupings(where: { curriculumLabel: "Section" }) {
        ordinalName
        name
        identifier
      }
    }
  }
}

MATCH (:Course {name: "Grade 6", author:'Illustrative Mathematics'})-[:hasPart]->(u:LessonGrouping {curriculumLabel: "Unit"}) -[:hasPart]->(s:LessonGrouping {curriculumLabel: "Section"}) RETURN u.ordinalName AS unit, s.ordinalName AS section, s.name AS sectionName, s.identifier AS sectionId

List all lessons in a course

Return all lessons for each section of each unit in Grade 6.

{
  courses(where: { name: "Grade 6", author: "Illustrative Mathematics" }) {
    hasPartLessonGroupings(where: { curriculumLabel: "Unit" }) {
      ordinalName
      hasPartLessonGroupings(where: { curriculumLabel: "Section" }) {
        ordinalName
        hasPartLessons {
          ordinalName
          name
          identifier
        }
      }
    }
  }
}

MATCH (:Course {name: "Grade 6", author:'Illustrative Mathematics'})-[:hasPart]->(u:LessonGrouping {curriculumLabel: "Unit"}) -[:hasPart]->(s:LessonGrouping {curriculumLabel: "Section"}) -[:hasPart]->(l:Lesson) RETURN u.ordinalName AS unit, s.ordinalName AS section, l.ordinalName AS lesson, l.name AS lessonName, l.identifier AS lessonId

List all instructional routines in a course

Return all instructional routines used in Grade 6.

{
  courses(where: { name: "Grade 6", author: "Illustrative Mathematics" }) {
    usesRoutineInstructionalRoutines {
      name
      identifier
    }
  }
}

MATCH (:Course {name: "Grade 6", author:'Illustrative Mathematics'})-[:usesRoutine]->(ir:InstructionalRoutine) RETURN DISTINCT ir.name, ir.identifier

List all common core math standards (CCSS) aligned to a course

Return all CCSS math standards that have educational alignment with Grade 6.

{
  courses(where: { name: "Grade 6", author: "Illustrative Mathematics" }) {
    hasEducationalAlignmentStandardsFrameworkItemsConnection(
      where: { node: { statementType: "Standard" } }
    ) {
      edges {
        properties {
          curriculumAlignmentType
        }
        node {
          statementCode
          description
          identifier
        }
      }
    }
  }
}

MATCH (:Course {name: "Grade 6", author:'Illustrative Mathematics'})-[a:hasEducationalAlignment]->(cfi:StandardsFrameworkItem) WHERE cfi.statementType = "Standard" RETURN DISTINCT cfi.statementCode, cfi.description, cfi.identifier, a.curriculumAlignmentType

Get the course guide for a course

Return course guide information for grade 6.

{
  courses(where: { name: "Grade 6", author: "Illustrative Mathematics" }) {
    hasPartMaterials(where: { name: "Course Guide" }) {
      identifier
      content
    }
  }
}

MATCH (:Course {name: "Grade 6", author:'Illustrative Mathematics'})-[:hasPart]->(m:Material) WHERE m.name = 'Course Guide' RETURN m.identifier, m.content

Get the course by the course ID

Return metadata and content for the course ID [xxxxx].

{
  courses(
    where: {
      author: "Illustrative Mathematics"
      identifier: "im:01dac62a-f836-5da5-bae4-1df14f1dfa8f"
    }
  ) {
    name
    courseCode
    hasPartMaterials {
      content
    }
  }
}

MATCH (c:Course {author:'Illustrative Mathematics', identifier: "im:01dac62a-f836-5da5-bae4-1df14f1dfa8f"})-[:hasPart]-(m:Material) RETURN c.name, c.courseCode, m.content

IM unit-level queries

List all sections in a unit

Return all sections for Unit 1 of Grade 6.

{
  courses(where: { name: "Grade 6", author: "Illustrative Mathematics" }) {
    hasPartLessonGroupings(
      where: { ordinalName: "Unit 1", curriculumLabel: "Unit" }
    ) {
      hasPartLessonGroupings(where: { curriculumLabel: "Section" }) {
        ordinalName
        name
        identifier
      }
    }
  }
}

MATCH (:Course {name: "Grade 6", author: "Illustrative Mathematics"}) -[:hasPart]->(u:LessonGrouping {ordinalName: "Unit 1", curriculumLabel: "Unit"}) -[:hasPart]->(s:LessonGrouping {curriculumLabel: "Section"}) RETURN s.ordinalName, s.name, s.identifier

List all lessons in a unit

Return all lessons for each Section for Unit 1 of Grade 6.

{
  courses(where: { name: "Grade 6", author: "Illustrative Mathematics" }) {
    hasPartLessonGroupings(
      where: { ordinalName: "Unit 1", curriculumLabel: "Unit" }
    ) {
      hasPartLessonGroupings(where: { curriculumLabel: "Section" }) {
        ordinalName
        hasPartLessons {
          ordinalName
          name
          identifier
        }
      }
    }
  }
}

MATCH (:Course {name: "Grade 6", author: "Illustrative Mathematics"}) -[:hasPart]->(u:LessonGrouping {ordinalName: "Unit 1", curriculumLabel: "Unit"}) -[:hasPart]->(s:LessonGrouping {curriculumLabel: "Section"}) -[:hasPart]->(l:Lesson) RETURN s.ordinalName AS section, l.ordinalName AS lesson, l.name AS lessonName, l.identifier as lessonId

List all common core math standards aligned to a unit

Return all the CCSS math standards that have educational alignment with Unit 1 of Grade 6.

{
  courses(where: { name: "Grade 6", author: "Illustrative Mathematics" }) {
    hasPartLessonGroupings(
      where: { ordinalName: "Unit 1", curriculumLabel: "Unit" }
    ) {
      hasEducationalAlignmentCfItemsConnection(
        where: { node: { CASE_CFItemType: "Standard" } }
      ) {
        edges {
          properties {
            curriculumAlignmentType
          }
          node {
            CASE_humanCodingScheme
            CASE_fullStatement
            identifier
          }
        }
      }
    }
  }
}

MATCH (:Course {name: "Grade 6", author: "Illustrative Mathematics"}) -[:hasPart]->(u:LessonGrouping {ordinalName: "Unit 1", curriculumLabel: "Unit"}) -[a:hasEducationalAlignment]->(cfi:CFItem) WHERE cfi.`CASE:CFItemType` = "Standard" RETURN DISTINCT cfi.`CASE:humanCodingScheme`, cfi.`CASE:fullStatement`, cfi.identifier, a.`relationship_properties.curriculumAlignmentType`

List the prerequisite units for a unit

Return the prerequisite units for Unit 1 of Grade 6.

{
  lessonGroupings(where: { ordinalName: "Unit 1", courseCode: "im360:6" }) {
    lessonGroupingshasDependency {
      ordinalName
      name
      identifier
    }
  }
}

MATCH (u:LessonGrouping {ordinalName: "Unit 1", courseCode: "im360:6"}) <-[:hasDependency]-(prereq:LessonGrouping) RETURN prereq.ordinalName, prereq.name, prereq.identifier

List the dependent units for a unit

Return units depending on Unit 1 of Grade 6.

{
  lessonGroupings(where: { ordinalName: "Unit 1", courseCode: "im360:6" }) {
    hasDependencyLessonGroupings {
      ordinalName
      name
      identifier
    }
  }
}

MATCH (u:LessonGrouping {ordinalName: "Unit 1", courseCode: "im360:6"}) -[:hasDependency]->(dep:LessonGrouping) RETURN dep.ordinalName, dep.name, dep.identifier

Get the family materials of a unit

Return the family material information for Unit 1 of Grade 6.

{
  courses(where: { name: "Grade 6", author: "Illustrative Mathematics" }) {
    hasPartLessonGroupings(where: { ordinalName: "Unit 1" }) {
      hasPartMaterials(where: { name_CONTAINS: "Family Materials" }) {
        name
        identifier
        content
      }
    }
  }
}

MATCH (:Course {name: "Grade 6", author: "Illustrative Mathematics"}) -[:hasPart]->(u:LessonGrouping {ordinalName: "Unit 1"}) -[:hasPart]->(m:Material) WHERE m.name CONTAINS 'Family Materials' RETURN m.name, m.identifier, m.content

Get the unit overview of a unit

Return the unit overview information for Unit 1 of Grade 6.

{
  courses(where: { name: "Grade 6", author: "Illustrative Mathematics" }) {
    hasPartLessonGroupings(where: { ordinalName: "Unit 1" }) {
      hasPartMaterials(where: { name_CONTAINS: "Overview" }) {
        name
        identifier
      }
    }
  }
}

MATCH (:Course {name: "Grade 6", author: "Illustrative Mathematics"}) -[:hasPart]->(u:LessonGrouping {ordinalName: "Unit 1"}) -[:hasPart]->(m:Material) WHERE m.name CONTAINS 'Overview' RETURN m.name, m.identifier

List the end-of-unit assessments of a unit

Return the end-of-unit assessments for Unit 1 of Grade 6.

{
  courses(where: { name: "Grade 6", author: "Illustrative Mathematics" }) {
    hasPartLessonGroupings(where: { ordinalName: "Unit 1" }) {
      hasPartAssessments(where: { curriculumLabel_CONTAINS: "End-of-Unit" }) {
        name
        identifier
      }
    }
  }
}

MATCH (:Course {name: "Grade 6", author: "Illustrative Mathematics"}) -[:hasPart]->(u:LessonGrouping {ordinalName: "Unit 1"}) -[:hasPart]->(a:Assessment) WHERE a.curriculumLabel CONTAINS "End-of-Unit" RETURN a.name, a.identifier

List the Check Your Readiness assessments for a unit

Return the Check Your Readiness assessments for Unit 1 of Grade 6.

{
  courses(where: { name: "Grade 6", author: "Illustrative Mathematics" }) {
    hasPartLessonGroupings(where: { ordinalName: "Unit 1" }) {
      hasPartAssessments(
        where: { curriculumLabel_CONTAINS: "Check Your Readiness" }
      ) {
        name
        identifier
      }
    }
  }
}

MATCH (:Course {name: "Grade 6", author: "Illustrative Mathematics"}) -[:hasPart]->(u:LessonGrouping {ordinalName: "Unit 1"}) -[:hasPart]->(a:Assessment) WHERE a.curriculumLabel CONTAINS "Check Your Readiness" RETURN a.name, a.identifier

List the mid-unit assessments of a unit

Return the mid-unit assessments for Unit 1 of Grade 6.

{
  courses(where: { name: "Grade 6", author: "Illustrative Mathematics" }) {
    hasPartLessonGroupings(where: { ordinalName: "Unit 1" }) {
      hasPartAssessments(where: { curriculumLabel_CONTAINS: "Mid-Unit" }) {
        name
        identifier
      }
    }
  }
}

MATCH (:Course {name: "Grade 6", author: "Illustrative Mathematics"}) -[:hasPart]->(u:LessonGrouping {ordinalName: "Unit 1"}) -[:hasPart]->(a:Assessment) WHERE a.curriculumLabel CONTAINS "Mid-Unit" RETURN a.name, a.identifier

List the glossary terms referenced by a unit

Return the glossary terms referenced by Unit 1 of Grade 6.

{
  courses(where: { name: "Grade 6", author: "Illustrative Mathematics" }) {
    hasPartLessonGroupings(where: { ordinalName: "Unit 1" }) {
      hasPartLessonGroupings {
        hasPartLessons {
          referencesGlossaryTerms {
            name
            description
            identifier
          }
        }
      }
    }
  }
}

MATCH (:Course {name: "Grade 6", author: "Illustrative Mathematics"}) -[:hasPart]->(u:LessonGrouping {ordinalName: "Unit 1"}) -[:hasPart*]->(l:Lesson)-[:references]->(g:GlossaryTerm) RETURN DISTINCT g.name, g.description, g.identifier

Get the unit by unit ID

Return metadata and content for the unit ID [xxxxx].

{
  lessonGroupings(
    where: { identifier: "im:a0e15ae9-dd70-5df0-93ad-9d6b99fc5ad2" }
  ) {
    name
    ordinalName
    hasPartMaterials {
      content
    }
  }
}

MATCH (u:LessonGrouping {identifier: "im:a0e15ae9-dd70-5df0-93ad-9d6b99fc5ad2"}) -[:hasPart]-(m:Material) RETURN u.name, u.ordinalName, m.content

IM section-level queries

List all lessons in a section

Return all lessons for Section A of Unit 1 of Grade 6.

{
  courses(where: { name: "Grade 6", author: "Illustrative Mathematics" }) {
    hasPartLessonGroupings(
      where: { ordinalName: "Unit 1", curriculumLabel: "Unit" }
    ) {
      hasPartLessonGroupings(
        where: { ordinalName: "Section A", curriculumLabel: "Section" }
      ) {
        hasPartLessons {
          ordinalName
          name
          identifier
        }
      }
    }
  }
}

MATCH (:Course {name: "Grade 6", author: "Illustrative Mathematics"}) -[:hasPart]->(u:LessonGrouping {ordinalName: "Unit 1", curriculumLabel: "Unit"}) -[:hasPart]->(s:LessonGrouping {ordinalName: "Section A", curriculumLabel: "Section"}) -[:hasPart]->(l:Lesson) RETURN l.ordinalName, l.name, l.identifier

List all common core math standards aligned to a section

Get all the CCSS math standards that have educational alignment with Section A of Unit 1 of Grade 6.

{
  courses(where: { name: "Grade 6", author: "Illustrative Mathematics" }) {
    hasPartLessonGroupings(
      where: { ordinalName: "Unit 1", curriculumLabel: "Unit" }
    ) {
      hasPartLessonGroupings(
        where: { ordinalName: "Section A", curriculumLabel: "Section" }
      ) {
        hasEducationalAlignmentStandardsFrameworkItemsConnection(
          where: { node: { statementType: "Standard" } }
        ) {
          edges {
            properties {
              curriculumAlignmentType
            }
            node {
              statementCode
              description
              identifier
            }
          }
        }
      }
    }
  }
}

MATCH (:Course {name: "Grade 6", author: "Illustrative Mathematics"}) -[:hasPart]->(u:LessonGrouping {ordinalName: "Unit 1", curriculumLabel: "Unit"}) -[:hasPart]->(s:LessonGrouping {ordinalName: "Section A", curriculumLabel: "Section"}) -[a:hasEducationalAlignment]->(cfi:StandardsFrameworkItem) WHERE cfi.statementType = "Standard" RETURN DISTINCT cfi.statementCode, cfi.description, cfi.identifier, a.curriculumAlignmentType

Get the section narrative of a section

Return the section narrative information for section A of unit 1 of grade 6.

{
  courses(where: { name: "Grade 6", author: "Illustrative Mathematics" }) {
    hasPartLessonGroupings(where: { ordinalName: "Unit 1" }) {
      hasPartLessonGroupings(where: { ordinalName: "Section A" }) {
        hasPartMaterials {
          name
          identifier
          content
        }
      }
    }
  }
}

MATCH (:Course {name: "Grade 6", author: "Illustrative Mathematics"}) -[:hasPart]->(u:LessonGrouping {ordinalName: "Unit 1"}) -[:hasPart]->(s:LessonGrouping {ordinalName: "Section A"}) -[:hasPart]->(m:Material) RETURN m.name, m.identifier, m.content

List the section checkpoint assessment of a section

Return the section checkpoint assessment for Section A of Unit 1 of Grade 6.

{
  courses(where: { name: "Grade 6", author: "Illustrative Mathematics" }) {
    hasPartLessonGroupings(where: { ordinalName: "Unit 1" }) {
      hasPartLessonGroupings(where: { ordinalName: "Section A" }) {
        hasPartAssessments(where: { curriculumLabel_CONTAINS: "Checkpoint" }) {
          name
          identifier
        }
      }
    }
  }
}

MATCH (:Course {name: "Grade 6", author: "Illustrative Mathematics"}) -[:hasPart]->(u:LessonGrouping {ordinalName: "Unit 1"}) -[:hasPart]->(s:LessonGrouping {ordinalName: "Section A"}) -[:hasPart]->(a:Assessment) WHERE a.curriculumLabel CONTAINS "Checkpoint" RETURN a.name, a.identifier

Get the section-by-section ID

Return metadata and content for the section ID [xxxxx].

{
  lessonGroupings(
    where: { identifier: "im:0908dab1-c834-5194-947b-492a1348a403" }
  ) {
    identifier
    name
    ordinalName
    hasPartMaterials {
      content
    }
  }
}

MATCH (s:LessonGrouping {identifier: "im:0908dab1-c834-5194-947b-492a1348a403"})-[:hasPart]-(m:Material) RETURN s.identifier, s.name, s.ordinalName, m.content

IM lesson-level queries

List all activities of a lesson

Return all activities that are part of lesson 1, section A, unit 1 of grade 6.

{
  courses(where: { name: "Grade 6" }) {
    hasPartLessonGroupings(where: { ordinalName: "Unit 1" }) {
      hasPartLessonGroupings(where: { ordinalName: "Section A" }) {
        hasPartLessons(where: { ordinalName: "Lesson 1" }) {
          hasPartActivities {
            name
            identifier
          }
        }
      }
    }
  }
}

MATCH (c:Course {name: "Grade 6"})-[:hasPart]->(u:LessonGrouping {ordinalName:"Unit 1"}) -[:hasPart]->(s:LessonGrouping {ordinalName:"Section A"})-[:hasPart]->(l:Lesson {ordinalName: "Lesson 1"}) -[:hasPart]->(a:Activity) RETURN a.name, a.identifier

List all cool-down assessments in a lesson

Get cool-down assessments of Lesson 1, Section A, Unit 1 of Grade 6.

{
  courses(where: { name: "Grade 6" }) {
    hasPartLessonGroupings(where: { ordinalName: "Unit 1" }) {
      hasPartLessonGroupings(where: { ordinalName: "Section A" }) {
        hasPartLessons(where: { ordinalName: "Lesson 1" }) {
          hasPartAssessments(where: { curriculumLabel: "Cool-down" }) {
            name
            identifier
          }
        }
      }
    }
  }
}

MATCH (c:Course {name: "Grade 6"})-[:hasPart]->(u:LessonGrouping {ordinalName:"Unit 1"}) -[:hasPart]->(s:LessonGrouping {ordinalName:"Section A"})-[:hasPart]->(l:Lesson {ordinalName: "Lesson 1"}) -[:hasPart]->(a:Assessment) WHERE a.curriculumLabel = "Cool-down" RETURN a.name, a.identifier

List all practice problems in a lesson

Get practice problems of Lesson 1, Section A, Unit 1 of Grade 6.

{
  courses(where: { name: "Grade 6" }) {
    hasPartLessonGroupings(where: { ordinalName: "Unit 1" }) {
      hasPartLessonGroupings(where: { ordinalName: "Section A" }) {
        hasPartLessons(where: { ordinalName: "Lesson 1" }) {
          hasPartAssessments(where: { curriculumLabel: "Practice Problems" }) {
            name
            identifier
          }
        }
      }
    }
  }
}

MATCH (c:Course {name: "Grade 6"})-[:hasPart]->(u:LessonGrouping {ordinalName:"Unit 1"}) -[:hasPart]->(s:LessonGrouping {ordinalName:"Section A"})-[:hasPart]->(l:Lesson {ordinalName: "Lesson 1"}) -[:hasPart]->(a:Assessment) WHERE a.curriculumLabel = "Practice Problems" RETURN a.name, a.identifier

List all classroom materials used in a lesson

Get all classroom materials used in Lesson 1, Section A, Unit 1 of Grade 3.

{
  courses(where: { name: "Grade 3" }) {
    hasPartLessonGroupings(where: { ordinalName: "Unit 1" }) {
      hasPartLessonGroupings(where: { ordinalName: "Section A" }) {
        hasPartLessons(where: { ordinalName: "Lesson 1" }) {
          usesClassroomMaterials {
            name
            identifier
            description
          }
        }
      }
    }
  }
}

MATCH (c:Course {name: "Grade 3"})-[:hasPart]->(u:LessonGrouping {ordinalName:"Unit 1"}) -[:hasPart]->(s:LessonGrouping {ordinalName:"Section A"})-[:hasPart]->(l:Lesson {ordinalName: "Lesson 1"}) -[:uses]->(m:ClassroomMaterial) RETURN m.name, m.identifier

List all glossary terms referenced by a lesson

Return all glossary terms referenced in Lesson 1, Section A, Unit 1 of Grade 6.

{
  courses(where: { name: "Grade 6" }) {
    hasPartLessonGroupings(where: { ordinalName: "Unit 1" }) {
      hasPartLessonGroupings(where: { ordinalName: "Section A" }) {
        hasPartLessons(where: { ordinalName: "Lesson 1" }) {
          referencesGlossaryTerms {
            name
            description
            identifier
          }
        }
      }
    }
  }
}

MATCH (c:Course {name: "Grade 6"})-[:hasPart]->(u:LessonGrouping {ordinalName:"Unit 1"}) -[:hasPart]->(s:LessonGrouping {ordinalName:"Section A"})-[:hasPart]->(l:Lesson {ordinalName: "Lesson 1"}) -[:references]->(g:GlossaryTerm) RETURN g.name, g.identifier

List all standards aligned to a lesson

Return all common core standards educationally aligned with Lesson 1, Section A, Unit 1 of Grade 6.

{
  courses(where: { name: "Grade 6" }) {
    hasPartLessonGroupings(where: { ordinalName: "Unit 1" }) {
      hasPartLessonGroupings(where: { ordinalName: "Section A" }) {
        hasPartLessons(where: { ordinalName: "Lesson 1" }) {
          hasEducationalAlignmentStandardsFrameworkItems {
            identifier
            description
            statementCode
            statementType
          }
        }
      }
    }
  }
}

MATCH (c:Course {name: "Grade 6"})-[:hasPart]->(u:LessonGrouping {ordinalName: "Unit 1"}) -[:hasPart]->(s:LessonGrouping {ordinalName: "Section A"})-[:hasPart]->(l:Lesson {ordinalName: "Lesson 1"}) -[:hasEducationalAlignment]->(cf:StandardsFrameworkItem) RETURN cf.identifier, cf.description, cf.statementCode

Get the lesson-by-lesson ID

Return metadata and content for the lesson ID [xxxxx].

{
  lessons(
    where: {
      author: "Illustrative Mathematics"
      identifier: "im:3ac685eb-79b3-5c19-952e-c1a71a5017e9"
    }
  ) {
    name
    courseCode
    hasPartMaterials {
      content
    }
  }
}

MATCH (c:Lesson {author:'Illustrative Mathematics', identifier: "im:3ac685eb-79b3-5c19-952e-c1a71a5017e9"})-[:hasPart]-(m:Material) RETURN c.name, c.courseCode, m.content

IM activity-level queries

List all instructional routines in an activity
”Which routines are used in activity ID [xxxxx]?”

{
  activities(where: { identifier: "im:44adb838-f550-5efc-a875-6a991b52b7ae" }) {
    usesRoutineInstructionalRoutines {
      name
      identifier
      description
    }
  }
}

MATCH (a:Activity {identifier: "im:44adb838-f550-5efc-a875-6a991b52b7ae"})-[:usesRoutine]->(r:InstructionalRoutine) RETURN r.name, r.identifier, r.description

List all common core math standards aligned to an activity
”Return all common core standards educationally aligned with Activity ID [xxxxx]“

{
  activities(where: { identifier: "im:44adb838-f550-5efc-a875-6a991b52b7ae" }) {
    hasEducationalAlignmentStandardsFrameworkItems {
      identifier
      description
      statementCode
      statementType
    }
  }
}

MATCH (a:Activity {identifier: "im:44adb838-f550-5efc-a875-6a991b52b7ae"}) -[:hasEducationalAlignment]->(cf:StandardsFrameworkItem) RETURN cf.identifier, cf.description, cf.statementCode

Get the activity by its activity ID

Return metadata and content for the activity ID [xxxxx].

{
  activities(where: { identifier: "im:44adb838-f550-5efc-a875-6a991b52b7ae" }) {
    name
    ordinalName
    hasPartMaterials {
      identifier
      content
    }
  }
}

MATCH (s:Activity {identifier: "im:44adb838-f550-5efc-a875-6a991b52b7ae"})-[:hasPart]-(m:Material) RETURN m.identifier, s.name, s.ordinalName, m.content

Academic standard query patterns

List all standards documents

Return all standard documents available in the Knowledge Graph.

{
  standardsFrameworks {
    identifier
    name
  }
}

MATCH (doc:StandardsFramework) RETURN doc.identifier, doc.name

Find documents by subject or state

Return all Math standards documents from California.

{
  standardsFrameworks(
    where: { academicSubject: "Mathematics", jurisdiction: "California" }
  ) {
    identifier
    name
  }
}

MATCH (doc:StandardsFramework) WHERE doc.academicSubject = "Mathematics" AND doc.jurisdiction = "California" RETURN doc.identifier, doc.name

Get document by document ID

Return standards document with identifier [xxxxx].

{
  standardsFrameworks(
    where: { identifier: "2d08331b-3769-5b2b-981c-52b03c5e73d1" }
  ) {
    identifier
    name
  }
}

MATCH (doc:StandardsFramework {identifier: "2d08331b-3769-5b2b-981c-52b03c5e73d1"}) RETURN doc.identifier, doc.name

Get all standards in a document

Return all standards that are part of a standard document ID [xxxxx].

{
  standardsFrameworks(
    where: { identifier: "2d08331b-3769-5b2b-981c-52b03c5e73d1" }
  ) {
    hasChildStandardsFrameworkItems {
      identifier
      description
      statementType
      statementCode
    }
  }
}

MATCH (:StandardsFramework {identifier: "2d08331b-3769-5b2b-981c-52b03c5e73d1"})-[:hasChild]->(ci:StandardsFrameworkItem) RETURN ci.identifier, ci.description, ci.statementCode

List child standards for a standard

Return all standards that are children of standard ID [xxxxx].

{
  standardsFrameworkItems(
    where: { identifier: "ef129d7a-3f29-58ed-80e3-ba5186af5872" }
  ) {
    hasChildStandardsFrameworkItems {
      identifier
      description
      statementCode
    }
  }
}

MATCH (:StandardsFrameworkItem {identifier: "ef129d7a-3f29-58ed-80e3-ba5186af5872"})-[:hasChild]->(ci:StandardsFrameworkItem) RETURN ci.identifier, ci.description, ci.statementCode

Get the parent standard for a standard

Return the immediate parent standard of standard ID [xxxxx].

{
  standardsFrameworkItems(
    where: {
      hasChildStandardsFrameworkItems_SOME: {
        identifier: "ef129d7a-3f29-58ed-80e3-ba5186af5872"
      }
    }
  ) {
    identifier
    description
    statementCode
  }
}

MATCH (ci:StandardsFrameworkItem)-[:hasChild]->(:StandardsFrameworkItem {identifier: "ef129d7a-3f29-58ed-80e3-ba5186af5872"}) RETURN ci.identifier, ci.description, ci.statementCode

Get the standard-by-standard code

Return content and metadata for standard code ‘7.G.A.1.”

{
  standardsFrameworkItems(where: { statementCode: "7.G.A.1" }) {
    identifier
    description
    statementType
  }
}

MATCH (ci: StandardsFrameworkItem{statementCode: "7.G.A.1"}) RETURN ci.identifier, ci.description

Get a standard-by-standard ID

Return content and metadata for standard ID [xxxxx].

{
  standardsFrameworkItems(
    where: { identifier: "ef129d7a-3f29-58ed-80e3-ba5186af5872" }
  ) {
    identifier
    description
    statementType
    statementCode
  }
}

MATCH (ci:StandardsFrameworkItem {identifier: "ef129d7a-3f29-58ed-80e3-ba5186af5872"}) RETURN ci.identifier, ci.description, ci.statementCode

Get standards for a grade

Return all math standards from grade level 6.

{
  standardsFrameworkItems(
    where: { gradeLevel_INCLUDES: "6", academicSubject: "Mathematics" }
  ) {
    identifier
    statementCode
    description
  }
}

MATCH (cfi:StandardsFrameworkItem) WHERE "6" in cfi.gradeLevel AND cfi.academicSubject = 'Mathematics' RETURN cfi.identifier, cfi.statementCode, cfi.description

Learning progression query patterns

List standards that build toward a standard

Return all standards that build toward standard 6.NS.B.3.

{
  standardsFrameworkItems(
    where: {
      buildsTowardsStandardsFrameworkItems_SOME: { statementCode: "6.NS.B.3" }
    }
  ) {
    identifier
    statementCode
    description
  }
}

MATCH (s:StandardsFrameworkItem)-[:buildsTowards]->(d:StandardsFrameworkItem) WHERE d.statementCode = "6.NS.B.3" RETURN s.identifier, s.statementCode, s.description

Return all standards that relate to standard 6.NS.B.3.

{
  standardsFrameworkItems(
    where: {
      relatesToStandardsFrameworkItems_SOME: { statementCode: "5.NBT.B.7" }
    }
  ) {
    identifier
    statementCode
    description
  }
}

MATCH (s:StandardsFrameworkItem)-[:relatesTo]->(d:StandardsFrameworkItem) WHERE d.statementCode = "5.NBT.B.7" RETURN s.identifier, s.statementCode, s.description

Learning Component Queries

List all learning components

Return a list of all learning components in Knowledge Graph.

{
  learningComponents {
    identifier
    description
    academicSubject
  }
}

MATCH (n:LearningComponent) RETURN n.identifier, n.description, n.academicSubject

Get learning component by ID

Return a learning component that matches the ID [xxxxx].

{
  learningComponents(
    where: { identifier: "4219c4aa-da1f-5f0f-bca8-0482f1d5a02b" }
  ) {
    identifier
    description
    academicSubject
  }
}

MATCH (n:LearningComponent{identifier: "4219c4aa-da1f-5f0f-bca8-0482f1d5a02b"}) RETURN n.identifier, n.description, n.academicSubject

Standards + curriculum query patterns

List all courses aligned to a specific standard

Return the courses aligned with standard ID [xxxxx].

{
  standardsFrameworkItems(
    where: { identifier: "62508493-c9ae-5c4a-b317-94d80fe6d775" }
  ) {
    courseshasEducationalAlignment {
      name
      identifier
    }
  }
}

MATCH (c:Course)-[:hasEducationalAlignment]->(:StandardsFrameworkItem {identifier: "62508493-c9ae-5c4a-b317-94d80fe6d775"}) RETURN c.name, c.identifier

List all units aligned to a specific standard

Return the units aligned with standard ID [xxxxx].

{
  standardsFrameworkItems(
    where: { identifier: "62508493-c9ae-5c4a-b317-94d80fe6d775" }
  ) {
    lessonGroupingshasEducationalAlignment(where: { curriculumLabel: "Unit" }) {
      name
      ordinalName
      identifier
    }
  }
}

MATCH (u:LessonGrouping {curriculumLabel: "Unit"})-[:hasEducationalAlignment]->(:StandardsFrameworkItem {identifier: "62508493-c9ae-5c4a-b317-94d80fe6d775"}) RETURN u.name, u.identifier

List all sections aligned to a specific standard

Return the sections aligned with standard ID [xxxxx].

{
  standardsFrameworkItems(
    where: { identifier: "62508493-c9ae-5c4a-b317-94d80fe6d775" }
  ) {
    lessonGroupingshasEducationalAlignment(
      where: { curriculumLabel: "Section" }
    ) {
      name
      ordinalName
      identifier
    }
  }
}

MATCH (s:LessonGrouping {curriculumLabel: "Section"})-[:hasEducationalAlignment]->(:StandardsFrameworkItem {identifier: "62508493-c9ae-5c4a-b317-94d80fe6d775"}) RETURN s.name, s.identifier

List all lessons aligned to a specific standard

Return the lessons are aligned with standard ID [xxxxx].

{
  standardsFrameworkItems(
    where: { identifier: "62508493-c9ae-5c4a-b317-94d80fe6d775" }
  ) {
    lessonshasEducationalAlignment {
      name
      ordinalName
      identifier
    }
  }
}

MATCH (l:Lesson)-[:hasEducationalAlignment]->(:StandardsFrameworkItem {identifier: "62508493-c9ae-5c4a-b317-94d80fe6d775"}) RETURN l.name, l.identifier

List all activities aligned to a specific standard

Return the activities are aligned with the standard ID [xxxxx].

{
  standardsFrameworkItems(
    where: { identifier: "62508493-c9ae-5c4a-b317-94d80fe6d775" }
  ) {
    activitieshasEducationalAlignment {
      name
      ordinalName
      identifier
    }
  }
}

MATCH (a:Activity)-[:hasEducationalAlignment]->(:StandardsFrameworkItem {identifier: "62508493-c9ae-5c4a-b317-94d80fe6d775"}) RETURN a.name, a.identifier

List all assessments aligned to a specific standard

Return the assessments aligned with standard ID [xxxxx].

{
  standardsFrameworkItems(
    where: { identifier: "6998c1e0-d5d3-5f9b-9bb6-f167772a499f" }
  ) {
    assessmentshasEducationalAlignment {
      name
      identifier
    }
  }
}

MATCH (assess:Assessment)-[:hasEducationalAlignment]->(:StandardsFrameworkItem {identifier: "6998c1e0-d5d3-5f9b-9bb6-f167772a499f"}) RETURN assess.name, assess.identifier

Learning component + standards query patterns

List all learning components in a grade

Return all learning components that support all standards from Grade 6.

{
  standardsFrameworkItems(where: { gradeLevel_INCLUDES: "6" }) {
    learningComponentssupports {
      identifier
      description
    }
  }
}

MATCH (cfi:StandardsFrameworkItem)-[:supports]-(l:LearningComponent) WHERE "6" in cfi.gradeLevel RETURN l.identifier, l.description

List learning components supporting a standard

Return all learning components that support standard ID [xxxxx].

{
  standardsFrameworkItems(
    where: { identifier: "ef129d7a-3f29-58ed-80e3-ba5186af5872" }
  ) {
    learningComponentssupports {
      identifier
      description
    }
  }
}

MATCH (cfi:StandardsFrameworkItem)-[:supports]-(l:LearningComponent) WHERE cfi.identifier = "ef129d7a-3f29-58ed-80e3-ba5186af5872" RETURN l.identifier, l.description

List standard(s) supported by a learning component

Return all standards that are supported by learning component ID [xxxxx].

{
  learningComponents(
    where: { identifier: "0013fbee-3e76-500f-9978-42aa1a65f105" }
  ) {
    supportsStandardsFrameworkItems {
      identifier
      description
    }
  }
}

MATCH (cfi:StandardsFrameworkItem)-[:supports]-(l:LearningComponent) WHERE l.identifier = "0013fbee-3e76-500f-9978-42aa1a65f105" RETURN cfi.identifier, cfi.description

Learning component, standards, IM curriculum query patterns

List all LCs supporting an IM lesson

Return all learning components that support lesson ID [xxxxx].

{
  lessons(where: { identifier: "im:ecf6aa89-0fc9-501c-a4ae-531d9faf8c39" }) {
    hasEducationalAlignmentStandardsFrameworkItems {
      learningComponentssupports {
        identifier
        description
      }
    }
  }
}

MATCH (l:Lesson{identifier:"im:ecf6aa89-0fc9-501c-a4ae-531d9faf8c39"})-[:hasEducationalAlignment]->(c:StandardsFrameworkItem)-[:supports]-(lc:LearningComponent) RETURN lc.identifier, lc.description

Standard crosswalk query patterns

Get all crosswalks

“Return all state to CCSSM standard alignments ordered by Jaccard similarity score.

{
  standardsFrameworkItems {
    statementCode
    jurisdiction
    hasStandardAlignmentStandardsFrameworkItemsConnection {
      edges {
        node {
          statementCode
          jurisdiction
        }
        properties {
          jaccard
          stateLCCount
          ccssLCCount
          sharedLCCount
        }
      }
    }
  }
}

MATCH (state:StandardsFrameworkItem)-[r:hasStandardAlignment]->(ccss:StandardsFrameworkItem)
RETURN
  state.statementCode AS state_standard_code,
  state.jurisdiction AS state_jurisdiction,
  ccss.statementCode AS ccss_standard_code,
  ccss.jurisdiction AS ccss_jurisdiction,
  r.jaccard,
  r.stateLCCount,
  r.ccssLCCount,
  r.sharedLCCount
ORDER BY r.jaccard DESC

Get crosswalks for a state

Return all crosswalks for Texas standards to CCSSM with full metadata.

{
  standardsFrameworkItems(
    where: { jurisdiction: "Texas", academicSubject: "Mathematics" }
  ) {
    jurisdiction
    statementCode
    gradeLevel
    description
    academicSubject
    hasStandardAlignmentStandardsFrameworkItemsConnection {
      edges {
        node {
          statementCode
          gradeLevel
          description
          academicSubject
        }
        properties {
          jaccard
          sharedLCCount
          stateLCCount
          ccssLCCount
        }
      }
    }
  }
}

MATCH (state:StandardsFrameworkItem)-[r:hasStandardAlignment]->(ccss:StandardsFrameworkItem)
WHERE state.jurisdiction = 'Texas' AND state.academicSubject = 'Mathematics'
RETURN
  state.jurisdiction AS state_jurisdiction,
  state.statementCode AS state_standard_code,
  state.gradeLevel AS state_grade_level,
  state.description AS state_description,
  state.academicSubject AS state_academic_subject,
  ccss.statementCode AS ccss_standard_code,
  ccss.gradeLevel AS ccss_grade_level,
  ccss.description AS ccss_description,
  ccss.academicSubject AS ccss_academic_subject,
  r.jaccard,
  r.sharedLCCount,
  r.stateLCCount,
  r.ccssLCCount
ORDER BY state.statementCode, ccss.statementCode, r.jaccard DESC

Filter crosswalks by similarity threshold

Return all Texas crosswalks with Jaccard score of 0.7 or higher.

{
  standardsFrameworkItems(
    where: {
      jurisdiction: "Texas"
      hasStandardAlignmentStandardsFrameworkItemsConnection_SOME: {
        edge: { jaccard_GTE: 0.7 }
      }
    }
  ) {
    jurisdiction
    statementCode
    hasStandardAlignmentStandardsFrameworkItemsConnection(
      where: { edge: { jaccard_GTE: 0.7 } }
    ) {
      edges {
        node {
          statementCode
        }
        properties {
          jaccard
          sharedLCCount
          stateLCCount
          ccssLCCount
        }
      }
    }
  }
}

MATCH (state:StandardsFrameworkItem)-[r:hasStandardAlignment]->(ccss:StandardsFrameworkItem)
WHERE r.jaccard >= 0.7 AND state.jurisdiction = 'Texas'
RETURN
  state.jurisdiction AS state_jurisdiction,
  state.statementCode AS state_standard_code,
  ccss.statementCode AS ccss_standard_code,
  r.jaccard,
  r.sharedLCCount,
  r.stateLCCount,
  r.ccssLCCount
ORDER BY ccss.statementCode, r.jaccard DESC

Find the best state match for a CCSS standard

Return the top Texas standards that best match CCSS standard ‘6.EE.B.5’ with full metadata.

{
  standardsFrameworkItems(
    where: { statementCode: "6.EE.B.5", jurisdiction: "Multi-State" }
  ) {
    statementCode
    description
    gradeLevel
    jurisdiction
    academicSubject
    standardsFrameworkItemshasStandardAlignmentConnection(
      where: { node: { jurisdiction: "Texas" } }
    ) {
      edges {
        node {
          statementCode
          description
          gradeLevel
          jurisdiction
          academicSubject
        }
        properties {
          jaccard
          sharedLCCount
          stateLCCount
          ccssLCCount
        }
      }
    }
  }
}

MATCH (state:StandardsFrameworkItem)-[r:hasStandardAlignment]->(ccss:StandardsFrameworkItem)
WHERE ccss.statementCode = '6.EE.B.5'
  AND ccss.jurisdiction = 'Multi-State'
  AND state.jurisdiction = 'Texas'
RETURN
  ccss.statementCode AS ccss_standard_code,
  ccss.description AS ccss_description,
  ccss.gradeLevel AS ccss_grade_level,
  ccss.jurisdiction AS ccss_jurisdiction,
  ccss.academicSubject AS ccss_academic_subject,
  state.statementCode AS state_standard_code,
  state.description AS state_description,
  state.gradeLevel AS state_grade_level,
  state.jurisdiction AS state_jurisdiction,
  state.academicSubject AS state_academic_subject,
  r.jaccard,
  r.sharedLCCount,
  r.stateLCCount,
  r.ccssLCCount
ORDER BY r.jaccard DESC
LIMIT 10

Learner variability navigator queries

List all learner models

Return all learner models available in the Knowledge Graph.

{
  learnerModels {
    identifier
    name
    description
    academicSubject
    gradeLevel
  }
}

MATCH (lm:LearnerModel)
RETURN
  lm.identifier,
  lm.name,
  lm.description,
  lm.academicSubject,
  lm.gradeLevel

Get factors for a learner model

Return all factors associated with the ‘Portrait of a Learner 4-8’ learner model.

{
  learnerModels(where: { name: "Portrait of a Learner 4-8" }) {
    name
    identifier
    description
    hasFactorFactors {
      identifier
      name
      description
      category
      gradeLevel
    }
  }
}

MATCH (lm:LearnerModel {name: 'Portrait of a Learner 4-8'})-[:hasFactor]->(f:Factor)
RETURN
  lm.name AS learner_model_name,
  lm.identifier AS learner_model_id,
  f.identifier AS factor_id,
  f.name AS factor_name,
  f.description AS factor_description,
  f.category AS factor_category,
  f.gradeLevel AS factor_grade_level

Get strategies for a learner model

Return all strategies associated with the ‘Portrait of a Learner 4-8’ learner model.

{
  learnerModels(where: { name: "Portrait of a Learner 4-8" }) {
    name
    identifier
    description
    hasStrategyStrategies {
      identifier
      name
      description
      category
      gradeLevel
    }
  }
}

MATCH (lm:LearnerModel {name: 'Portrait of a Learner 4-8'})-[:hasStrategy]->(s:Strategy)
RETURN
  lm.name AS learner_model_name,
  lm.identifier AS learner_model_id,
  s.identifier AS strategy_id,
  s.name AS strategy_name,
  s.description AS strategy_description,
  s.category AS strategy_category,
  s.gradeLevel AS strategy_grade_level

Get factors that interact with a specific factor

Return all factors that interact with ‘Working Memory’ factor from Building Math 3-6.

{
  factors(where: { identifier: "9501e48b-c985-501f-84ad-98c3f271e322" }) {
    name
    identifier
    description
    category
    gradeLevel
    academicSubject
    interactsWithFactorFactors {
      identifier
      name
      description
      category
      gradeLevel
    }
  }
}

MATCH (f:Factor {identifier: '9501e48b-c985-501f-84ad-98c3f271e322'})-[:interactsWithFactor]->(related:Factor)
RETURN
  f.name AS factor_name,
  f.identifier AS factor_id,
  f.gradeLevel AS grade_level,
  f.academicSubject AS academic_subject,
  related.identifier AS related_factor_id,
  related.name AS related_factor_name,
  related.description AS related_factor_description,
  related.category AS related_factor_category,
  related.gradeLevel AS related_factor_grade_level

View all strategies that target a specific factor

Return all strategies that target ‘Working Memory’ factor from Building Math 3-6.

{
  factors(where: { identifier: "9501e48b-c985-501f-84ad-98c3f271e322" }) {
    name
    identifier
    category
    gradeLevel
    academicSubject
    strategiestargetsFactorConnection {
      edges {
        node {
          name
          category
        }
        properties {
          connectionType
          factorCategory
        }
      }
    }
  }
}

MATCH (s:Strategy)-[r:targetsFactor]->(f:Factor {identifier: '9501e48b-c985-501f-84ad-98c3f271e322'})
RETURN
  f.name AS factor_name,
  f.gradeLevel AS grade_level,
  f.academicSubject AS academic_subject,
  s.name AS strategy,
  s.category AS strategy_category,
  r.connectionType AS connection,
  r.factorCategory AS factor_category
ORDER BY s.name

View all standards relevant to a specific factor

Return all standards that are relevant to ‘Algebraic Thinking’ factor.

{
  factors(where: { name: "Algebraic Thinking" }) {
    name
    identifier
    category
    relevantToStandardStandardsFrameworkItems {
      statementCode
      description
      gradeLevel
      jurisdiction
      academicSubject
    }
  }
}

MATCH (f:Factor {name: 'Algebraic Thinking'})-[:relevantToStandard]->(s:StandardsFrameworkItem)
RETURN
  f.name AS factor_name,
  f.identifier AS factor_id,
  s.statementCode AS standard_code,
  s.description AS standard_description,
  s.gradeLevel AS grade_level,
  s.jurisdiction AS jurisdiction,
  s.academicSubject AS academic_subject
ORDER BY s.statementCode

Getting started

Entities and relationships

⌘I

​Basic node queries

​Fetch lessons by grade level

​Relationship queries

​Find activities and their materials

​Get educational alignments

​Advanced filtering

​Multiple grade levels

​Filter by subject and author

​Illustrative Math (IM) curriculum course level queries

​List all courses in IM

​List all units in a course

​List all sections in a course

​List all lessons in a course

​List all instructional routines in a course

​List all common core math standards (CCSS) aligned to a course

​Get the course guide for a course

​Get the course by the course ID

​IM unit-level queries

​List all sections in a unit

​List all lessons in a unit

​List all common core math standards aligned to a unit

​List the prerequisite units for a unit

​List the dependent units for a unit

​Get the family materials of a unit

​Get the unit overview of a unit

​List the end-of-unit assessments of a unit

​List the Check Your Readiness assessments for a unit

​List the mid-unit assessments of a unit

​List the glossary terms referenced by a unit

​Get the unit by unit ID

​IM section-level queries

​List all lessons in a section

​List all common core math standards aligned to a section

​Get the section narrative of a section

​List the section checkpoint assessment of a section

​Get the section-by-section ID

​IM lesson-level queries

​List all activities of a lesson

​List all cool-down assessments in a lesson

​List all practice problems in a lesson

​List all classroom materials used in a lesson

​List all glossary terms referenced by a lesson

​List all standards aligned to a lesson

​Get the lesson-by-lesson ID

​IM activity-level queries

​Get the activity by its activity ID

​Academic standard query patterns

​List all standards documents

​Find documents by subject or state

​Get document by document ID

​Get all standards in a document

​List child standards for a standard

​Get the parent standard for a standard

​Get the standard-by-standard code

​Get a standard-by-standard ID

​Get standards for a grade

​Learning progression query patterns

​List standards that build toward a standard

​List standards that are related to a standard

​Learning Component Queries

​List all learning components

​Get learning component by ID

​Standards + curriculum query patterns

​List all courses aligned to a specific standard

​List all units aligned to a specific standard

​List all sections aligned to a specific standard

​List all lessons aligned to a specific standard

​List all activities aligned to a specific standard

​List all assessments aligned to a specific standard

​Learning component + standards query patterns

​List all learning components in a grade

​List learning components supporting a standard

​List standard(s) supported by a learning component

​Learning component, standards, IM curriculum query patterns

​List all LCs supporting an IM lesson

​Standard crosswalk query patterns

​Get all crosswalks

​Get crosswalks for a state

​Filter crosswalks by similarity threshold

​Find the best state match for a CCSS standard