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
namespace	Namespace for the Assessment.		CTE, Dial 3 and 4, Academic Assistance - ed.sc.gov/SCDEAssessments Student Not Tested - ed.sc.gov/SCDEAssessmentsStudentNotTest	R
AcademicSubjects
/AcademicSubjectDescriptor	The 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
AssessmentCategoryDescriptor	Indicates 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
/AssessmentPeriodDescriptor	Indicates 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 Codes	The 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
/educationOrganizationId	Indicates 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.
assessedGradeLevelDescriptor	The 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
/SchoolYear	The 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		Numeric	1 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
/SchoolYear	The 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')
AdministrationDate	The 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
ResultDatatypeTypeDescriptor	The 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
/SchoolYear	The 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
AdministrationDate	The 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
ResultDatatypeTypeDescriptor	The 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
/SchoolYear	The 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)
AdministrationDate	The 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)
ReasonNotTestedDescriptor	Indicates 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'

Student Assessment Registration

AssessmentCustomization

Primary PowerSchool Source Data

[S_SC_STU_X]

Selection Criteria

Records are published if the following criteria are met:

Must have active student records in PK4
Excluded - Delete assessmentcustomization records for students after transfer out

Data Element	Description	Stored in [Table]Field
classroom	The identification	S_SC_STU_X.Home_Room
districtname	The name of the district.	Prefs.Value
schoolname		Schools.Name
classroomname
studentfirstname		[StudentCoreFields]Legal_Last_Name
studentlastname		[StudentCoreFields]Legal_First_Name
studentdob		[Student]DOB
SCHOOLID		Prefs.Value Schools.School_Number
teachlname		CC.Course_Number
teachfname		CC.Course_Number
classid		Users.TeacherNumber


middleinitial		StudentCoreFields.Legal_Middle_Name
stateid		Students.State_StudentNumber
studentid		Students.Student_Number
genderID		StudentCoreFields.Gender
birthdate		StudentCoreFields.Gender
raceID		StudentRace.RaceCD
ethID		Students.FedEthnicity
languageid		S_SC_STU_X.First_Lang_Spoken

AssessmentCustomization

Primary PowerSchool Source Data

S_SC_STU_X.AltAssessCde =1

Selection Criteria

Records are published if the following criteria are met:

Students with enrollment in CC.course_code 48530000 (English for SC Alt)
Students with enrollment in CC.course_code 48540000 (Algebra for SC Alt)
Students with enrollment in CC.course_code 48550000 (Biology for SC Alt)
Students with enrollment in CC.course_code 48560000 (U.S. History and Constitution for SC Alt)
Student's S_SC_STU_X.NinthGradeCode must not be null
Students must not have S_SC_STU_X.Grade_Level and S_SC_STU_X.True_Grade null

Data Element	Description	Stored in [Table]Field
schoolyear	The identification	Prefs.Value
districtname	The name of the district.	Prefs.Value
schoolname		Prefs.Value; Schools.Name
		Prefs.Value Schools.School_Number
		StudentCoreFields.PSCore_Legal_Last_Name
		StudentCoreFields.PSCore_Legal_First_Name
		StudentCoreFields.PSCore_Legal_Middle_Name
		Students.Student_Number
		Students.State_StudentNumber
		Students.DOB
		StudentCoreFields.PSCore_Legal_Gender
		S_SC_STU_X.Grade_Level
		S_SC_STU_ X.TrueGrade
		Students.FedEthnicity
		StudentRace.RaceCD
		StudentRace.RaceCD
		StudentRace.RaceCD
		StudentRace.RaceCD
		S_SC_STU_X .Engl_Prof; .engProfDecimal: Prof8_status
		S_SC_STU_X.migrant
		S_SC_STU_X.NinthGradeCode
		S_SC_STU_X.AltAssessTA_FirstName
		S_SC_STU_X.AltAssessTA_LastName
		CC.Course_code
		CC.Course_code
		CC.Course_code
		CC.Course_code

Student Assessment Registration

AssessmentCustomization

Primary PowerSchool Source Data

[S_SC_STU_X]

Selection Criteria

Records are published if the following criteria are met:

Must have active student records in PK4
Excluded - Delete assessmentcustomization records for students after transfer out

Data Element	Description	[Table]Data Type	Stored in [Table]Field	Req’d
classroom			S_SC_STU_X.Home_Room
districtname			Prefs.Value
schoolname			[Schools]Name
classroomname			[S_SC_Sec_X]sc_homeroom
studentfirstname			[StudentCoreFields]Legal_Last_Name
studentlastname			[StudentCoreFields]Legal_First_Name
studentdob			[Student]DOB
studentid			Students.Student_Number
studentgender			StudentCoreFields.Gender
studentellstatus			[S_SC_STU_X]Eng_Prof
studentiepstatus			[S_SC_STU_X]InstrSetting
agegroup			[S_SC_STU_X]Grade_Level
studentethnicity			[StudentRace]RaceCD; [Students]FedEthnicity
studenthomelanguage			[S_SC_STU_ X]First_Lang _Spoken
districtid			[Prefs]Value
districtid_districtname			[Prefs]Value
schoolid			[Schools]school_Number
schoolid_schoolname			[Schools]Name-[Prefs]Value+[Schools]School_Number
schoolid			[Schools]School_Number
classroomid			[CC]Course_Number
studentid2			[Students]Student_Number
literacy
numeracy			[S_SC_STU_X]Precode1
classuniqueid			Find the student enrollment in this set of course codes at CC.Course_Number. If enrolled in 1750, publish a composite value from [Sections]schoolid - [Sections]course_number - [Sections]section_number - [Sections]dcid.
teacheremail			teacher email published in classroomid