Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Question: Could this be the beginnings of mapping to dashboards?

We need to document fields used to integrate student (West Windsor specific) and assessment information (NWEA for all future NWEA clients) from secondary sources to our MTSS Platform.

West Windsor has NWEA for reading and math grades K-12, Attendance, Behavior and uses Genesis for everything

Question: Could this be the beginnings of mapping to dashboards?

We need to document fields used to integrate student (West Windsor specific) and assessment information (NWEA for all future NWEA clients) from secondary sources to our MTSS Platform.

  • West Windsor has NWEA for reading and math grades K-12, Attendance, Behavior and uses Genesis for everything.

RethinkEdStudents_Export.csv

Field Name: School Year

Data Areas: All

Locations in MTSS Dashboard: All

Description: Contains school year,

Value: shown as YYYY-YY. Example: 2023-24

UI

Image Added

Acceptance Criteria

  • Used in all areas to contain data sets to a specific school year within the year drop down.

Field Name: Enrollment Status

Data Areas: All

Locations in MTSS Dashboard: All

Description: confirms student is enrolled,

Values: Active

UI

  • No UI.

Acceptance Criteria

  • Used in all areas to denote if student is Enrolled.

  • Used in conjunction with other fields to tie to student to correct information.

  • Question: Is this field used to eliminate a student from counts in graphs so that proper counts of students are included with no duplicates

Field Names: First Name, Last name

Data Areas: All

Locations in MTSS Dashboard: Classroom, Student

Description: Student’s first name, Student’s last name

Values: Text varies

UI

Image Added

Image Added

Acceptance Criteria

  • Used in conjunction with other fields to identify student and tie to student to correct information.

Field Name: Grade Level

Data Areas: All

Location in MTSS Dashboard: All

Field Description: Student’s grade level

Values: Integer

  • No UI

Acceptance Criteria

  • Used in conjunction with other areas to place student within the correct grade level and correct school year.

Field Name: State IDNumber

Data Areas: All

Location in MTSS Dashboard: All

Field Description: Unique Student Identifier for the state in which the student lives

Values: Integer

  • No UI

Acceptance Criteria

  • Used in conjunction with other fields identify the correct student and tie student to correct information

Field Name: Spec Ed, Gender, Ethnicity Primary, Date of Birth

Data Areas: All

Location in MTSS Dashboard: All

Field Description: Demographic information

Values:

Spec Ed = No, Yes

Gender: Male, Female, Non-binary, Not specified

Ethnicity Primary: American Indian or Alaska Native, Asian, Black or African American, Hispanic or Latino, Native Hawaiian or Other Pacific Islander, Two or More Races, White

Date of Birth: MM/DD/YYYY

  • Shows up within Student Profile and in filters

Image Added

Image Added

Acceptance Criteria

  • Used in conjunction with other fields identify the correct student and tie student to correct information

  • Values used to fill filters in all areas of the dashboard.

ReThinkEdStudent_school_enrollment.csv

Field Name: School Year

Data Areas: All

Location in MTSS Dashboard: All

Field Description: Names the school year

Values: shown as YYYY-YY, Example 2023-24

UI

Image Added

Acceptance Criteria

  • Used in all areas to contain data sets to a specific school year within the year drop down. (Not sure which we follow as school year is shown in multiple data sets)

Field Name: Enrollment Status

Data Areas: All

Location in MTSS Dashboard: All

Field Description: Tells if student is Active

Values: shown as Active

UI

  • No UI

Acceptance Criteria

  • Used in all areas to denote if student is Enrolled.

  • Used in conjunction with other fields to tie to student to correct information. (Not sure which we follow for Enrollment Status since it is shown in multiple data sets)

Field Name: Student ID

Data Areas: All

Location in MTSS Dashboard: All

Field Description: Unique student identifier

Values: Interger

UI

  • Student ID is shown in Student Dashboard

Image Added

Acceptance Criteria

  • The unique student identifier must be the same across the different types of data so that RethinkEd can link all data types back to the same student in our platform

  • Used in conjunction with other fields to tie to student to correct information. (Not sure which we follow for Student ID since it is shown in multiple data sets)

Field Name: Current Entry in District

Data Areas: All

Location in MTSS Dashboard: All

Field Description: Tells the date student entered the district

Values: Date, shown as MM/DD/YYYY

UI

  • No UI

Acceptance Criteria

  • This field could be used to keep graphs up to date.

Field Name: Current Withdrawal Date

Data Areas: All

Location in MTSS Dashboard: All

Field Description: Tells the date student left the district

Values: unknown; no entries are in the data set

UI

  • No UI

Acceptance Criteria

  • This field could be used to keep graphs up to date, it could also help to ensure that students are not counted multiple times.

Integration Fields (West Windsor)

Rethink Ed Field Name:StudentNumber

West Windsor Field Name: StudentID

Data Area: Attendance

Field Description: child/student identifier

UI

Acceptance Criteria:

  • The unique student identifier must be the same across the different types of data so that RethinkEd can link all data types back to the same student in our platform

Rethink Ed Field Name:AttendanceDate

West Windsor Field Name: Attendance Date

Data Area: Attendance

Field Description: date of attendance event, shown as M/DD/YYYY

Note: The date remains the same but the attendance code and attendance code description can change.

UI

Acceptance Criteria:

Rethink Ed Field Name:AttendanceCode

West Windsor Field Name: Attendance Code

Data Area: Attendance

Field Description: code category for different types of attendance events (tardy, absence.

Note Examples: E=Early Dismissal-Excused, U=Tardy Unexcused, EX=Early Dismissal Unexcused, 1=Absent Full day Unexcused, A=Absent Full Day Excused, SRE=Present School Related with Time, ABU=Absent Unverified)

UI

Acceptance Criteria:

1 or A or ABU = absence, U or T = tardy, exclude SRE and 6 and other values not listed here from attendance metrics

Rethink Ed Field Name:Description

West Windsor Field Name: Attendance Code Description

Data Area: Attendance

Field Description: Written info on type of attendance event

Note (See above): How will we show the Attendance Code Description?

UI

Acceptance Criteria:

Rethink Ed Field Name:Student Number

West Windsor Field Name: Student ID

Data Area: Behavior

Field Description: child/student identifier

UI

Acceptance Criteria:

  • The unique student identifier must be the same across the different types of data so that RethinkEd can link all data types back to the same student in our platform

Rethink Ed Field Name:IncidentDate

West Windsor Field Name: Infraction Date

Data Area: Behavior

Field Description: Date of behavior incident

UI

Acceptance Criteria:

Rethink Ed Field Name:BehaviorCode

West Windsor Field Name: Infraction code

Data Area: Behavior

Field Description: code categorizing different types of behavior incidents (e.g, disruptive behavior, cell phone use)

Note: Probably going to remove this field

Infraction code has many listed as numbers only with the exception of: FILMING, HIBCONFIRM, KNIFE, ALCOHOL, MARIJUANA. We would have to use another sheet to translate the number codes to the description?

UI

Acceptance Criteria:

Rethink Ed Field Name:Enrolled

West Windsor Field Name: Enrollment Status

Data Area: School enrollment

Field Description: whether student is enrolled; Example: Active

UI

Acceptance Criteria:

Rethink Ed Field Name:Student Number

West Windsor Field Name: Student ID

Data Area: School enrollment

Field Description: child/student identifier

UI

Acceptance Criteria:

  • The unique student identifier must be the same across the different types of data so that RethinkEd can link all data types back to the same student in our platform

Rethink Ed Field Name:EntryDate

West Windsor Field Name: Current Entry in District

Data Area: School enrollment

Field Description: Date student enrolled in/entered the district

UI

Acceptance Criteria:

Rethink Ed Field Name:ExitDate

West Windsor Field Name: Current Withdrawal Date

Data Area: School enrollment

Field Description: Date student withdrew from the district

UI

Acceptance Criteria:

Rethink Ed Field Name:SchoolCode

West Windsor Field Name: School Code

Data Area: Student export

Field Description: code identifying school student attends

UI

Acceptance Criteria:

Rethink Ed Field Name:FirstName

West Windsor Field Name: First Name

Data Area: Student export

Field Description: student’s first name

UI

Acceptance Criteria:

Rethink Ed Field Name:LastName

West Windsor Field Name: Last Name

Data Area: Student export

Field Description: student’s last name

UI

Acceptance Criteria:

Rethink Ed Field Name:Grade

West Windsor Field Name: Grade Level

Data Area: Student export

Field Description: student’s grade level

UI

Acceptance Criteria:

Rethink Ed Field Name:StateIdentifier

West Windsor Field Name: State IDNumber

Data Area: Student export

Field Description: child/student state identifier

UI

Acceptance Criteria:

  • Either this state identifier or the Student ID for this file must be the same across the different types of data so that RethinkEd can link all data types back to the same student in our platform

Rethink Ed Field Name:StudentNumber

West Windsor Field Name: Student ID

Data Area: Student export

Field Description: child/student identifier

UI

Acceptance Criteria:

  • Either this student identifier or the StateIDNumber for this file must be the same across the different types of data so that RethinkEd can link all data types back to the same student in our platform

Rethink Ed Field Name:SpecialEducation

West Windsor Field Name: Spec Ed

Data Area: Student export

Field Description: whether the student receives special education services

Example: No Yes

UI

Acceptance Criteria:

  • We have different filters in Student Profile: IEP filter drop down contains: IEP, GIEP, All IEP (Check on this)

Rethink Ed Field Name:Gender

West Windsor Field Name: Gender

Data Area: Student export

Field Description: whether the student is Male or Female

UI

Acceptance Criteria:

  • We have different filters in Student Profile: Gender filter drop down contains: Female, Male, Non-binary, Unspecified (Check on how this is going to work for filters we show the client)

Rethink Ed Field Name: Ethnicity

West Windsor Field Name: Ethnicity Primary

Data Area: Student export

Field Description: student’s race/ethnicity

UI

Acceptance Criteria:

  • We have different filters in Student Profile: Ethnicity filter drop down contains: (Check on how this is going to work for filters we show the client)

Rethink Ed Field Name: DOB

West Windsor Field Name: Date of Birth

Data Area: Student export

Field Description: student’s date of birth; shown as M/DD/YYYY

UI

Acceptance Criteria:

  • We have different filters in Student Profile: Ethnicity filter drop down contains: (Check on how this is going to work for filters we show the client)

Rethink Ed Field Name:School Year

West Windsor Field Name: School Year

Data Area: Student export

Field Description: The school year; shown as YYYY-YY Example: 2023-24

Note: This wasn’t included-would we want to include it?

UI

Acceptance Criteria:

  • This one wasn’t included but would we want it for the year drop down?

Assessment Fields (NWEA-Map specific)

Need to add: maybe Year, School, Enrollment, Last Name, First Name, Demographics? or site theses as “checks” for other integrated fields?

Rethink Ed Field Name: CompletedDateLocal

NWEA Field Name: TBD; Use the date it came it

Data Area: Academic Assessments

Field Description: date (and time if available) stamp for when the assessment was completed

UI

Acceptance Criteria:

  • Essential field (fields marked as essential or optional for academic assessment data only; assume fields for all other data types are essential).

Rethink Ed Field Name: ScaledScore

NWEA Field Name: OverallRITScore

Data Area: Academic Assessments

Field Description: scale or raw score for the assessment

UI

Acceptance Criteria:

  • Essential field

Rethink Ed Field Name: GradeEquivalent

NWEA Field Name: Assessment Grade

Data Area: Academic Assessments

Field Description: grade level equivalent based on assessment performance

UI

Acceptance Criteria:

  • Optional field

  • note: iReady has a slightly different field than Renaissance

Rethink Ed Field Name: PercentileRank

NWEA Field Name:Test Percentile

Data Area: Academic Assessments

Field Description: percentile rank

UI

Acceptance Criteria:

  • Essential field

Rethink Ed Field Name: BenchmarkCategoryName

NWEA Field Name: use High, High Average, Average, Low Average, Low associated with Tier selection in Settings

Data Area: Academic Assessments

Field Description: benchmark category label for student (eg, “Proficient”, “Partially meeting expectations”)

UI

Acceptance Criteria:

  • Essential field

Rethink Ed Field Name: ScreeningPeriodWindowName

NWEA Field Name: TBD: Month

Data Area: Academic Assessments

Field Description: name of screening period (e.g. “Fall 2023”, “Q1 2024”)

UI

Acceptance Criteria:

  • Optional field

Rethink Ed Field Name: ExtraTime

NWEA Field Name: TBD; nothing so eliminate it.

Data Area: Academic Assessments

Field Description: whether student was given extra time to complete the assessment

UI

Acceptance Criteria:

  • Optional field

  • Note: Renaissance and iReady have a different field. We are looking for some measure of time the student used to take a test; Duration or just noting that the test time was longer or shorted than anticipated.

Rethink Ed Field Name: ScreeningWindowStartDate

NWEA Field Name: TBD; nothing so eliminate it

Data Area: Academic Assessments

Field Description: start date for the given ScreeningPeriodWindowName

UI

Acceptance Criteria:

  • Optional field

Rethink Ed Field Name: ScreeningWindowEndDate

NWEA Field Name: TBD; nothing so eliminate it

Data Area: Academic Assessments

Field Description: end date for the given ScreeningPeriodWindowName

UI

Acceptance Criteria:

  • Optional field

Rethink Ed Field Name: SubjectArea

NWEA Field Name: TBD; Exam or Test

Data Area: Academic Assessments

Field Description: subject area for assessments (e.g. “ELA”, “Math”) if not evident from data file name

UI

Acceptance Criteria:

  • Essential field if not evident from data file name (e.g. “ELA assessment results”)

Rethink Ed Field Name: StateIdentifier

NWEA Field Name: TBD: State ID

Data Area: Academic Assessments

Field Description: child/student state identifier

UI

Acceptance Criteria:

  • Important note: Either this sate identifier or the Student ID for this file must be the same across the different types of data so that RethinkEd can link all data types back to the same student in our platform.

Rethink Ed Field Name: StudentNumber

NWEA Field Name: TBD: ?

Data Area: Academic Assessments

Field Description: child/student identifier

UI

Acceptance Criteria:

  • Important note: Either this student identifer or the StateIDNumber for this file must be the same across the different types of data so that RethinkEd can link all data types back to the same student in our platform.