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.
Integration Fields (West Windsor)
RethinkEdStudents_Export.csv
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
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:
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
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:
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
West Windsor Field Name: Infraction Date
Data Area: Behavior
Field Description: Date of behavior incident
UI
Acceptance Criteria:
Rethink Ed Field Name:BehaviorCodeWest 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:EnrolledWest 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 NumberWest Windsor Field Name: Student IDData Area: School enrollment
Field Description: child/student identifier
UI
Acceptance Criteria:School Year
Data Areas: All
Locations in MTSS Dashboard: All
Description: Contains school year,
Value: shown as YYYY-YY. Example: 2023-24
UI
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
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
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
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: Integer
UI
Student ID is shown in Student Dashboard
Acceptance Criteria
West WindsorThe 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 Area: School enrollmentAreas: All
Location in MTSS Dashboard: All
Field Description: Date student enrolled in/Tells the date student entered the district
Values: Date, shown as MM/DD/YYYY
UI
No UI
Acceptance Criteria:Rethink Ed Field Name:ExitDateWest Windsor
This field could be used to keep graphs up to date.
Field Name: Current Withdrawal Date
Data Area: School enrollmentAreas: All
Location in MTSS Dashboard: All
Field Description: Date student withdrew from the district
UI
Acceptance Criteria:
Rethink Ed Field Name:SchoolCodeWest Windsor Field Name: School Code
Data Area: Student export
Field Description: code identifying school student attends
UI
Acceptance Criteria:
Rethink Ed Field Name:FirstNameWest Windsor Field Name: First Name
Data Area: Student export
Field Description: student’s first name
UI
Acceptance Criteria:
Rethink Ed Field Name:LastNameWest Windsor Field Name: Last Name
Data Area: Student export
Field Description: student’s last name
UI
Acceptance Criteria:
Rethink Ed Field Name:GradeWest Windsor Field Name: Grade Level
Data Area: Student export
Field Description: student’s grade level
UI
Acceptance Criteria:
Rethink Ed Field Name:StateIdentifierWest 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 fileTells 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.
ReThinkEdBehavior_Export.csv---Genesis Data?
Field Name: School Year
Data Areas: Behavior
Location in MTSS Dashboard: Behavior
Field Description: Tells the school year the behavior occurred
Values: shown as YYYY-YY, Example 2023-24
UI
Acceptance Criteria
Used in Behavior Section to contain data within a specific year.
(Not sure which we follow as school year is shown in multiple data sets)
Field Name: Student ID
Data Areas: Behavior
Location in MTSS Dashboard: Behavior
Field Description: Unique student identifier
Values: Integer
UI
No UI
Acceptance Criteria
Used in Behavior Section to match student to Infraction Date
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: 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
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)
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 MInfraction Date
Data Areas: Behavior
Location in MTSS Dashboard: All Graphs at all levels (District, Classroom, Student)
Field Description: Date the infraction
Values: shown as MM/DD/YYYY
UI
Acceptance Criteria
This shows without the use of our Behavior Incidents
Student View (Behavior Tab)
Show the infraction date in the chart
Used in conjunction with Student Id to match student with infraction
Used to calculate the number of infractions for determining Tiers
Used to calculate the number of infractions for determining when to send Tier Notices when no intervention plan exists.
Used to calculate the number of infractions for determining At Risk indicators.
Used to calculate the span of time between infractions as determined in Setting for when a student is returned to Tier 1.
Student View (Overview Tab)
Used to determine a count of students within the grade level for each of the tiers within the graph
Classroom Dashboard (Overview Tab)
Used to determine the counts for each tier level shown in the graph for the selected classroom
Classroom Dashboard (Behavior Tab)
Used in conjunction with Define School year to determine placement in the appropriate graph for the classroom
District View (Overview Tab)
Used to determine the counts for each tier level shown in the graph for the entire district
District View (Behavior Tab Selected)
Used in conjunction with Define School year to determine placement in the appropriate graph for the entire district
ReThinkEdAttendance_Export.csv---Genesis Data?
Field Name: School Year
Data Areas: Attendance
Location in MTSS Dashboard: Attendance Graphs in overview and Tabs in all areas: District, Classroom, Student
Field Description: Tells the school year of the Attendance records
Values: shown as YYYY-YY, Example 2023-24
UI
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: Student ID
Data Areas: Attendance
Location in MTSS Dashboard: Attendance Graphs in overview and Tabs in all areas: District, Classroom, Student
Field Description: Unique student identifier
Values: Integer
UI
No UI
Acceptance Criteria
Used in Attendance Section to match student to the date an Absence or Tardy occurred
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
Field Name: Date
Data Areas: Attendance
Location in MTSS Dashboard: Attendance Graphs in overview and Tabs in all areas: District, Classroom, Student
Field Description: Date the Absence or Tardy occurred
Values: show as MM/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)
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?Used in Attendance Section to match student to the date an Absence or Tardy occurred
Used in conjunction with the Attendance Code to determine if an Absence or a Tardy is to be recorded for that date.
Field Name: Attendance Code
Data Areas: Attendance
Location in MTSS Dashboard: Attendance Graphs in overview and Tabs in all areas: District, Classroom, Student
Field Description: Code to determine if the date shown is an absence or a tardy
Values: show as MM/DD/YYYY
UI
Acceptance Criteria
Used in Attendance Section to match student to the date an Absence or Tardy occurred
1 or A or ABU = absence, U or T = tardy, exclude SRE and 6 and other values not listed here from attendance metrics
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: OverallRITScoreData 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 PercentileData 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.We do not have a reliable field for date the test was given. West Windsor provided a second set of data that includes the field: Administered but that date appears to be the same for all students and does not agree with the field: Month . Suggest waiting on another data set or get a list of fields and descriptions from NWEA before including the field Administered into our product.
We do not have a field for Extra Time or Duration like Renaissance or iReady in the data set provided by West Windsor but such field exists in NWEA. Suggest waiting on another data set or get list of fields/descriptions for NWEA.
Multiple data sets for Reading and Math in grade ranges K-12.
Field Name: Test
Data Areas: Academic Assessments
Location in MTSS Dashboard: All
Field Description: names the test
Values: show as Mapp
UI
Acceptance Criteria
Used in Student View Math Tab and becomes part of data collection for Classroom and District reports
Essential field if not evident from data file name (e.g. “ELA assessment results”)
Field Name: Exam
Data Areas: Academic Assessments
Location in MTSS Dashboard: All
Field Description: Names the test
Values show as: Math K-12
UI
Acceptance Criteria
Used in Student View Math Tab and becomes part of data collection for Classroom and District reports
Essential field if not evident from data file name (e.g. “ELA assessment results”)
Field Name: Month
Data Areas: Academic Assessments
Location in MTSS Dashboard: All
Field Description: Shows the month a test was taken
Values show as: various months
UI
Acceptance Criteria
Used in Student View Math Tab and becomes part of data collection for Classroom and District reports
Field Name: Year
Data Areas: Academic Assessments
Location in MTSS Dashboard: All
Field Description: Shows the year the test was taken
Values show as: 2023
UI
Acceptance Criteria
Used in Student View Math Tab and becomes part of data collection for Classroom and District reports
Used in conjunction with the field: Month to place data into the correct year.
Field Name: State ID
Data Areas: Academic Assessments
Location in MTSS Dashboard: All
Field Description: Unique identifier for the student
Values show as: integer
UI
Acceptance Criteria
Used in Student View Math Tab and becomes part of data collection for Classroom and District reports
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.
Field Name: Enrollment
Data Areas: Academic Assessments
Location in MTSS Dashboard: All
Field Description: Tells if the student is enrolled
Values show as: Active, Inactive
UI
Acceptance Criteria
Used in Student View Math Tab and becomes part of data collection for Classroom and District reports
Value of Inactive could be used to remove a student from a list of students qualifying for a Tier 2 or Tier 3 Intervention plan and not receiving one.
Value of Inactive could remove the student’s results from graphs showing the Tier levels.
Field Names: First Name, Last name
Data Areas: Academic Assessments
Locations in MTSS Dashboard: Classroom, Student
Description: Student’s first name, Student’s last name
Values: Text varies
UI
Acceptance Criteria
Used in Student View Math Tab and becomes part of data collection for Classroom and District reports
Repeats from other data sources, not sure which data source is used as the “Source of Truth”
Field Name: Gender, Ethnicity, Low Income, LEP, SpecEd, Migrant, Military Connected, Homeless, 504, Gifted and Talented
Data Areas: Math, All
Location in MTSS Dashboard: All in the filters
Field Description: Demographic information
Values:
Gender: Female, Male
Ethnicity: Varies-Asian, White, Multiple Categories Reported, Hispanic or Latino, Black or African American,
Low Income: FI, DC, FT, FE, R, or left blank
LEP: F3, F2, 2, F1, 1, F4, <, left blank
Spec Ed: 1, 2 or left blank
Migrant: left blank
Military Connected: Left blank
Homeless: Left blank
504: Y or left blank
Gifted and Talented: Y or left blank,
UI
Acceptance Criteria
Used in Student View Math Tab and becomes part of data collection for Classroom and District reports
Used in filters
Repeats from other data sources, not sure which data source is used as the “Source of Truth”
The categories and values differ from other data sets.
Field Names: Current Grade
Data Areas: Academic Assessments
Locations in MTSS Dashboard: Classroom, Student
Description: Student’s current grade for the data set
Values: integer
UI
Acceptance Criteria:
Tells the current grade of the data set, used to place the data into the correct year.
Field Names: Assessment Grade
Data Areas: Academic Assessments
Locations in MTSS Dashboard: Student Dashboard, Content Tab in the chart
Description: ?
Values: integer
UI
Acceptance Criteria:
This is included in the Student View within the content tab (Reading and Math) in the chart. (See heading in chart labeled: Assessment Grade)
Need to find out more about this field; suspect that it is indicating an overall test result that is NOT the same as the student’s chronological (current) grade. Some of the data sets for Reading and Math leave it blank and others have filled in a value.
Field Names: OverallRITScore
Data Areas: Academic Assessments
Locations in MTSS Dashboard: Student View
Description: scale or raw score for the assessment
Values: integer
UI
See image above
Acceptance Criteria:
Essential field
See image above for heading: Overall RIT Score
Field Names: Test Percentile
Data Areas: Academic Assessments
Locations in MTSS Dashboard: Student View
Description: percentile rank
Values: integer
UI
See image above
Acceptance Criteria:
Essential field
See image above for heading: Overall RIT Score