Introduction

The assessment collection was built help answer the question: 

Are students improving in [content area e.g. reading, math, science] over time [timeframe e.g. within a school year, over three years, over last year]?  

The views are intended to simplify presenting interoperable multiple measures assessment data.  The views also provide reference to the associated learning standards, scoring, and performance levels.  These metrics can be viewed across summative, interim, or other benchmark assessments.

Views in this Collection

• AssessmentFact
• StudentAssessmentFact

The assessment collection comprises two Fact tables focused on assessments. 

The first fact table is called AssessmentFact and this view combines the granularity of the assessment found in the assessment and objective assessment table as well as the assessment's association with learning standards.  Finally, the AssessmentFact table has denormalized summary information related to descriptions and reporting methods.

The second fact table is called StudentAssessmentFact and this fact table summarizes the students' results of each assessment.  The fact table consolidates each student's reporting results and associates that information in a similar structure as AssessmentFact.  

Installation

Install using the option code "ASMT"

For more information, see the AMT Deployment Guide.

Example Queries

select
     asmt_StudentAssessmentFact.AssessmentKey,
     asmt_StudentAssessmentFact.StudentSchoolKey,
     asmt_StudentAssessmentFact.ResultDataType,
     asmt_StudentAssessmentFact.StudentScore,
     asmt_StudentAssessmentFact.PerformanceResult
from
     analytics.asmt_StudentAssessmentFact
WHERE
     ReportingMethod = 'Scale Score'
AND AssessedGradeLevel = 'Sixth grade'

select
     asmt_AssessmentFact.Title,
     asmt_AssessmentFact.[Version],
     asmt_AssessmentFact.AcademicSubject,
     asmt_AssessmentFact.Category
from
     analytics.asmt_AssessmentFact
where
     asmt_AssessmentFact.ParentObjectiveAssessmentKey is null