Skip to main content
Skip table of contents

Assessments

This category captures assessments linked to the student including the student assessments and their properties. The Assessments category includes the following data views and resources:

Assessments

This data view represents a detailed list of Assessments successfully published to TRIG. The published view layout provides the School Name, Assessment Name, Grade Level, and Category.

Assessments

This resource represents a tool, instrument, process, or exhibition composed of a systematic sampling of behavior for measuring a student's competence, knowledge, skills, or behavior. An assessment can be used to measure differences in individuals or groups and changes in performance from one occasion to the next.

Primary PowerSchool Source Data

  • [S_SC_STU_TESTMISSED_C]

Selection Criteria

Records are published if the following criteria are met:

  • The student must not be excluded from state reporting.
  • The student’s school of enrollment must not be excluded from state reporting.
  • One or more students at the school are in the cohort.
  • The student must have an active enrollment.

    Noshow and Summer graduates are published.

Resource Output

  • A separate record is published for each Student Assessment associated with a student in PowerSchool who was included for publishing in the preceding Student Demographic data.
  • The cohort resource is dependent on the prior publishing of the following entities: students.
  • LEAs and Schools may upload (publish) data to the Ed-Fi ODS in real time or on-demand (“Run Now” button).

Note: Click Export to export the data collection results to an Excel spreadsheet.                       

Data Element

Description

[Table]Data Type

Stored in [Table]Field

Req’d

AssessmentIdentifier
String

CTE - CTE_[S_SC_Stu_CATE_C]CERT_ADMIN

Dial 3 and 4 - Concat(District code, school code, 'DIAL 4')

Acad Assistance - 'Academic Assistance'

[Assessment]AssessmentIdentifier

[s_sc_stu_testmissed_c]test_category

State-assigned number for district + [Gen]schoolid +[S_SC_STU_TESTMISSED_C]Test;

R
namespaceNamespace for the Assessment.

CTE, Dial 3 and 4, Academic Assistance - ed.sc.gov/SCDEAssessments

Student Not Tested - ed.sc.gov/SCDEAssessmentsStudentNotTest

R

AcademicSubjects


  /AcademicSubjectDescriptorThe description of the content or subject area (e.g., arts, mathematics, reading, stenography, or a foreign language) of an assessment.String

CTE - 'Career and Technical Education'

Dial 3 and 4 - 'DIAL 4'

Academic Assistance - 'Academic Assistance'

Student Not Tested -

If [S_SC_STU_TESTMISSED_C]Test is ELA/Math or SCI/SocStud then AcademicSubjectDescriptor is Composite;
If substring([S_SC_STU_TESTMISSED_C]Test,1,2) is (En) then AcademicSubjectDescriptor is English/Language Arts;
If substring([S_SC_STU_TESTMISSED_C]Test,1,3) is (Alg) then AcademicSubjectDescriptor is Mathematics;
If substring([S_SC_STU_TESTMISSED_C]Test,1,2) is (Bi) then AcademicSubjectDescriptor is Science;
If substring([S_SC_STU_TESTMISSED_C]Test,1,2) is (Hi) then AcademicSubjectDescriptor is Social Studies;
If [S_SC_STU_TESTMISSED_C]Test is 'College Readiness' or 'Career Readiness' then AcademicSubjectDescriptor is Career Activities, non-CTE;
If [S_SC_STU_TESTMISSED_C]Test is 'ALT English 1' then AcademicSubjectDescriptor is E

English/Language Arts;
If [S_SC_STU_TESTMISSED_C]Test is 'ALT Algebra 1' then AcademicSubjectDescriptor is Mathematics;
If [S_SC_STU_TESTMISSED_C]Test is 'ALT Biology 1' then AcademicSubjectDescriptor is Science;
If [S_SC_STU_TESTMISSED_C]Test is 'ALT US History 1' then AcademicSubjectDescriptor is Social Studies;
If [S_SC_STU_TESTMISSED_C]Test is 'Listening' then AcademicSubjectDescriptor is English/Language Arts;
If [S_SC_STU_TESTMISSED_C]Test is 'Reading' then AcademicSubjectDescriptor is English/Language Arts;
If [S_SC_STU_TESTMISSED_C]Test is 'Writing' then AcademicSubjectDescriptor is English/Language Arts;
If [S_SC_STU_TESTMISSED_C]Test is 'Speaking' then AcademicSubjectDescriptor is English/Language Arts;
If [S_SC_Stu_CATE_C]CERT_ADMIN is NOT NUll then AcademicSubjectDescriptor is 'Career and Technical Education'

R
AssessmentCategoryDescriptorIndicates the category for the test that was missed.

String

Not used for CTE, Dial 3 and 4, and Academic Assistance

Student Not Tested - 

If the [S_SC_STU_TESTMISSED_C]request_exclusion is 1 then use the descriptors with "...Exclusion Requested" +[S_SC_STU_TESTMISSED_C]Test_Category, or use the descriptors without "...Exclusion Requested";

Example:

If [S_SC_STU_TESTMISSED_C]request_exlcusion is 1 and [S_SC_STU_TESTMISSED_C]test_category is ELEM_MIDDLE then AssessmentCategoryDescriptor is EM_ER, or AssessmentCategoryDescriptor is ELEM_MIDDLE;


If [S_SC_Stu_CATE_C]CERT_ADMIN is NOT NUll then AcademicCategoryDescriptor= CTE

O
PeriodReference
AcademicSubjects
   /AssessmentPeriodDescriptorIndicates the term the End of Course exam was missed.

[S_SC_STU_TESTMISSED_C]Term_Test_Missed

[AssessmentAcademicSubject]AcademicSubjectDescriptorId, DIAL 4


AssessmentTitle

The title or name of the assessment.String


CTE - [S_SC_Stu_CATE_C]CERT_ADMIN

Dial 3 and 4 - 'DIAL 4'

Academic Assistance - 'Academic Assistance'

Student Not Tested - [S_SC_STU_TESTMISSED_C]Test;

R
Identification CodesThe student's seven-digit Identification Code is a combination of three-digit District ID and four-digit School ID.Numeric

CTE - If [S_SC_Stu_CATE_C]CERTIFICATION_OWNER is null then Identification Codes  is the student's enrollment location education organization ID. If [S_SC_Stu_CATE_C]CERTIFICATION_OWNER is not null then identification codes is the entered value.

Not used for Dial 3 and 4, Academic Assistance, and Student Not Tested


EducationOrganizationReference
  /educationOrganizationIdIndicates the school number that identified the missed test and requested the exclusion.
State-assigned number for district and students.schoolid; If [S_SC_Stu_CATE_C]CERTIFICATION_OWNER is NOT NULL then replace EducationOrganizationId with the value in that field.
assessedGradeLevelDescriptorThe typical grade level for which an assessment is designed. If the test assessment spans a range of grades, then this attribute holds the highest grade assessed. If only one grade level is assessed, then only this attribute is used. For example: Adult ,Prekindergarten, First grade, Second grade.Descriptor
R
platformTypeDescriptor

If [S_SC_STU_X]ELP_Paper=1 then platformTypeDescriptor='Paper-based';
If [S_SC_STU_X]GT_Paper=1 then platformTypeDescriptor='Paper-based';
If [S_SC_STU_X]CR_Paper=1 then platformTypeDescriptor='Paper-based';
If [S_SC_STU_X]G38PaperEla=1 then platformTypeDescriptor='Paper-based';
If [S_SC_STU_X]G38PaperMath=1 then platformTypeDescriptor='Paper-based';
If [S_SC_STU_X]G38PaperScience=1 then platformTypeDescriptor='Paper-based';
If [S_SC_STU_X]G38PaperSocStu=1 then platformTypeDescriptor='Paper-based';
If [S_SC_STU_X]EOCEPPaperEla=1 then platformTypeDescriptor='Paper-based';
If [S_SC_STU_X]EOCEPPaperMath=1 then platformTypeDescriptor='Paper-based';
If [S_SC_STU_X]EOCEPPaperScience=1 then platformTypeDescriptor='Paper-based';
If [S_SC_STU_X]EOCEPPaperSocStu=1 then platformTypeDescriptor='Paper-based';

Student Assessments

This data view represents a detailed list of Student Assessments and their relationship to the student successfully published to TRIG. The published view layout provides the School Name, Student Number, Student Name, UIC, Assessment Name, Administration Date, and Assessment Reason.

studentAssessments

This resource represents the analysis or scoring of a student's response to an assessment. The analysis results in a value that represents a student's performance on a set of items on a test.

  • CTE
  • Dial 3 & 4
  • Academic Assisstance
  • Student Not Test

Primary PowerSchool Source Data

  • [S_SC_STU_TESTMISSED_C]
  • [S_SC_STU_X]

Selection Criteria

Records are published if the following criteria are met:

  • The student must not be excluded from state reporting.
  • The student’s school of enrollment must not be excluded from state reporting.
  • One or more students at the school are in the cohort.
  • The student must have an active enrollment.

    Noshow and Summer graduates are published.

Resource Output

  • A separate Student Assessment Association record is published for each unique Student/Assessment combination.
  • The cohort resource is dependent on the prior publishing of the following entities: students and assessments.
  • LEAs and Schools may upload (publish) data to the Ed-Fi ODS in real-time or on-demand (“Run Now” button).

Note: Click Export to export the data collection results to an Excel spreadsheet.

Assessement Name - CTE

Data Element

Description

[Table]Data Type

Stored in [Table]Field

Req’d

assessmentReference

A reference to the related assessment resource.

R

/AssessmentIdentifier

The state-assigned number for the district.String

'CTE'_[S_SC_Stu_CATE_C]CERT_ADMIN

[Assessment]AssessmentIdentifier

R
      /Namespace

ed.sc.gov/SCDEAssessments

R
     /SchoolYearThe current school year. For example, 2023.Numeric
R

studentReference

A reference to the related student resource.

   /studentUniqueId

The student associated with the assessment.String

StudentAssessment.studentusi

[students]state_studentnumber

R
StudentAssessmentIdentifier
String

Concat (District code, school code, [S_SC_Stu_CATE_C]CERT_ADMIN, studentsDCID)

[StudentAssessment]AssessmentIdentifier

R
AdministrationDate
String

[StudentAssessment]AdministrationDate

For [S_SC_Stu_CATE_C]CERT_ADMINYEAR and values that begin with "SP..." use 3/1/'cat('20',substring(cert_adminyear,3,2)'

For [S_SC_Stu_CATE_C]CERT_ADMINYEAR and values that begin with "FA..." use 11/1/'cat('20',substring(cert_adminyear,3,2)'

R
PerformanceLevels
/assessmentReportingMethodDescriptor
String

[StudentAssessmentPerformanceLevel]AssessmentReportingMethodDescriptorId

'Pass-Fail'

R
/performanceLevelDescriptor
String

[StudentAssessmentPerformanceLevel]PerformanceLevelDescriptorId

If [S_SC_Stu_CATE_C]CERT_PASSED ='Y' then performanceLevelDescriptor='Pass'
If [S_SC_Stu_CATE_C]CERT_PASSED ='N' then performanceLevelDescriptor='Fail'

R
/performanceLevelMet
Numeric1 for all records R

Assessement Name - Dial 3 and 4

Data Element

Description

[Table]Data Type

Stored in [Table]Field

Req’d

assessmentReference

A reference to the related assessment resource.

R

/AssessmentIdentifier

The state-assigned number for the district.String

[Assessment]AssessmentIdentifier

Assessment identifier is DIAL 4

R
      /Namespace

[Assessment]Namespace

ed.sc.gov/SCDEAssessments


     /SchoolYearThe current school year. For example, 2023.Numeric

studentReference

A reference to the related student resource.

   /studentUniqueId

The student associated with the assessment.String

StudentAssessment.studentusi

[students]state_studentnumber

R
StudentAssessmentIdentifier

[StudentAssessment]AssessmentIdentifier

CONCAT (District code, school code, 'DIAL 4')


AdministrationDateThe date on which an assessment is administered or first day of administration if over multiple days.Date

[S_SC_STU_X]dial_test_date

[StudentAssessment]AdministrationDate

O
PerformanceLevels
/assessmentReportingMethodDescriptor

[StudentAssessmentPerformanceLevel]AssessmentReportingMethodDescriptorId

'Number Score'

R
ScoreResult
AssessmentReportingMethodDescriptor

If [S_SC_STU_X]DIAL_MOTR_SubScaleNum IS NOT NULL then AssessmentReportingMethodDescriptor='Scale score'
If [S_SC_STU_X]DIAL_MOTR_SubScalePer IS NOT NULL then AssessmentReportingMethodDescriptor='Other'
If [S_SC_STU_X]DIAL_CONC_SubScaleNum IS NOT NULL then AssessmentReportingMethodDescriptor='Scale score'
If [S_SC_STU_X]DIAL_CONC_SubScalePer IS NOT NULL then AssessmentReportingMethodDescriptor='Other'
If [S_SC_STU_X]DIAL_LANG_SubScaleNum IS NOT NULL then AssessmentReportingMethodDescriptor='Scale score'
If [S_SC_STU_X]DIAL_LANG_SubScalePer IS NOT NULL then AssessmentReportingMethodDescriptor='Other'
If [S_SC_STU_X]DIAL_SELF_SubScaleNum IS NOT NULL then AssessmentReportingMethodDescriptor='Scale score'
If [S_SC_STU_X]DIAL_SELF_SubScalePer IS NOT NULL then AssessmentReportingMethodDescriptor='Other'
If [S_SC_STU_X]DIAL_SEmot_SubScaleNum IS NOT NULL then AssessmentReportingMethodDescriptor='Scale score'
If [S_SC_STU_X]DIAL_SEmot_SubScalePer IS NOT NULL then AssessmentReportingMethodDescriptor='Other'

Result

[S_SC_STU_X]DIAL_MOTR_SubScaleNum
[S_SC_STU_X]DIAL_MOTR_SubScalePer
[S_SC_STU_X]DIAL_CONC_SubScaleNum
[S_SC_STU_X]DIAL_CONC_SubScalePer
[S_SC_STU_X]DIAL_LANG_SubScaleNum
[S_SC_STU_X]DIAL_LANG_SubScalePer
[S_SC_STU_X]DIAL_SELF_SubScaleNum
[S_SC_STU_X]DIAL_SELF_SubScalePer
[S_SC_STU_X]DIAL_SEmot_SubScaleNum
[S_SC_STU_X]DIAL_SEmot_SubScalePer

ResultDatatypeTypeDescriptorThe data type of the published result. For example, numbers, percentages, etc.
If [S_SC_STU_X]DIAL_MOTR_SubScaleNum IS NOT NULL then ResultDatatypeTypeDescriptor='Integer'
If [S_SC_STU_X]DIAL_MOTR_SubScalePer IS NOT NULL then ResultDatatypeTypeDescriptor='Percentage'
If [S_SC_STU_X]DIAL_CONC_SubScaleNum IS NOT NULL then ResultDatatypeTypeDescriptorr='Integer'
If [S_SC_STU_X]DIAL_CONC_SubScalePer IS NOT NULL then ResultDatatypeTypeDescriptor='Percentage'
If [S_SC_STU_X]DIAL_LANG_SubScaleNum IS NOT NULL then ResultDatatypeTypeDescriptor='Integer'
If [S_SC_STU_X]DIAL_LANG_SubScalePer IS NOT NULL then ResultDatatypeTypeDescriptor='Percentage'
If [S_SC_STU_X]DIAL_SELF_SubScaleNum IS NOT NULL then ResultDatatypeTypeDescriptor='Integer'
If [S_SC_STU_X]DIAL_SELF_SubScalePer IS NOT NULL then ResultDatatypeTypeDescriptor='Percentage'
If [S_SC_STU_X]DIAL_SEmot_SubScaleNum IS NOT NULL then ResultDatatypeTypeDescriptor='Integer'
If [S_SC_STU_X]DIAL_SEmot_SubScalePer IS NOT NULL then ResultDatatypeTypeDescriptor='Percentage'

Assessement Name - Academic Assistance                  

Data Element

Description

[Table]Data Type

Stored in [Table]Field

Req’d

assessmentReference

A reference to the related assessment resource.

R

/AssessmentIdentifier

The state-assigned number for the district.String

[Assessment]AssessmentIdentifier

'Academic Assistance'

R
      /Namespace

ed.sc.gov/SCDEAssessments


     /SchoolYearThe current school year. For example, 2023.Numeric

studentReference

A reference to the related student resource.

   /studentUniqueId

The student associated with the assessment.String

StudentAssessment.studentusi

[Students]state_studentnumber

R
StudentAssessmentIdentifier

Concat (District code, school code, 'Academic Assistance')

R
AdministrationDateThe date on which an assessment is administered or first day of administration if over multiple days.

[S_SC_STU_STTESTPERF_C]TEST_DATE

[StudentAssessment]AdministrationDate


eventDescription

CONCAT(YearID,_,S_SC_STU_STTESTPERF_C,Year_ID)


ScoredResults
AssessmentReportingMethodDescriptor

HSASSESS_ELA

HSASSESS_MTH

SCPASS_ELA

SCPASS_MTH


Result

PERFORMANCE_LEVEL_HSASSESS_ELA

PERFORMANCE_LEVEL_HSASSESS_MTH

SCPASS_PERFORMANCELEVEL_ELA

SCPASS_PERFORMANCELEVEL_MATH


ResultDatatypeTypeDescriptorThe data type of the published result. For example, numbers, percentages, etc.
Integer

Assessement Name - Student Not Tested                       

Data Element

Description

[Table]Data Type

Stored in [Table]Field

Req’d

assessmentReference

A reference to the related assessment resource.

R

/AssessmentIdentifier

The state-assigned number for the district.String

[s_sc_stu_testmissed_c]test_category

R
      /Namespace

[Assessment]Namespace

ed.sc.gov/SCDEAssessmentsStudentNotTest


     /SchoolYearThe current school year. For example, 2023.Numeric

studentReference

A reference to the related student resource.

   /studentUniqueId

The student taking the assessment.String

[StudentAssessment]studentusi

[students]state_studentnumber

R
StudentAssessmentIdentifier

Concat (District code, school code, [s_sc_stu_testmissed_c]test_category)


AdministrationDateThe date on which an assessment is administered or first day of administration if over multiple days.Date

[StudentAssessment]AdministrationDate

If [s_sc_stu_testmissed_c]term_test_missed is not null then [s_sc_stu_testmissed_c]term_test_missed (assume 11/1/yr for F and 3/1/yr for S) 
(yr is the current school year) or, use 11/1/current school year

O
eventDescription

Concat (YearID,_,[S_SC_STU_TESTMISSED_C]YearID)


ReasonNotTestedDescriptorIndicates the reason the student missed the assessment.

[StudentAssessment]ReasonNotTestedDescriptorId
[S_SC_STU_TESTMISSED_C]Reason_Not_Tested

If [S_SC_STU_TESTMISSED_C]Request_Exclusion=1 then ReasonNotTestedDecriptor is'Requested Exclusion' else 'No Exclusion Requested'


JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.