ADVISER 2023-2024 Certification Tests Edupoint Synergy.xlsx

	A	B	C	D	E	F	G
1	IR Ref	Resource	Test	Result	Notes / Response	Unsupported Feature?	Known Issue?
2	-	-	Demonstrate how the 23-24 ADVISER connection is set up	OK
3	2.1	Location	Verify that locations are published	OK
4	2.2	ClassPeriod	Verify periods are published	OK
5	3.1	Calendar	Publish at least one calendar for each school that is being used	OK
6			Publish a 2nd calendar for one of the schools above	OK
7	3.2	CalendarDate	Dates are published for all of the calendars published above, verify that Instructional event type days are submitted and that the InstructionalDuration is filled out for appropriate dates	OK
8			After the dates have been published, update the instructional duration for a date as if it was a half snow day	OK
9	3.3	Session	Verify the expected session records (per the SIS) are published for each school	OK
10	3.4	GradingPeriod	Verify the expected grading period records (per the SIS) are published for each school	OK
11	4.1	CourseOffering	Verify that the course offerings are published	OK
12	4.2	Section	Verify that all section records are published, including career academy and distance learning SectionDelivery fields	OK
13			[CRDC] Verify the Block Schedule, Female Only, and/or Male Only SectionCharacteristics can be published if needed	N/A	Not supported	CRDC specific elements
14	12.2	StudentSchoolAssociation	Verify that enrollment records for regular students are published with all usable fields (Entry Type, grade level, residency status, FTE, reporting school, resident district, resident school, expected graduation school). Verify the new FTE format	Ok
15			Update a student to move them into a separate calendar	OK
16			Upload a contract or option in status student whose resides in another district	OK
17			Upload a summer transfer student that enters and exits without having any in-session days	OK
18			Verify that the StudentDaysEnrolled calendar override field can be published if available, and is left blank otherwise	OK
19			Check for orphaned records after deleting a student's enrollment from the district completely
20			Check for orphaned records after changing a student's state ID in the SIS
21	12.1	Student EdOrg Association	Submit a demographics record for a student that contains all usable fields, including the ImmigrantIndicator field, the local ID, multiple race codes, and each of the StudentCharacteristics	OK
22			Submit a demographics record for a 9th grader that correctly sets their graduation CohortYear	OK
23			Verify the "Test" studentCrisisEvent descriptor can be submitted, as well as the DisplacedStudentIndicator	OK
24			Verify each of the digital access Student Indicators can be published	OK
25			Verify that a student's physical or mailing+physical address can be published	OK
26	12.3	StudentSectionAssociation	Submit a record for a high school student that is enrolled for the full length of the course, including the DualCredit field	OK
27	9.1	Student SchoolAttendance Event	Verify that absence records are sent as expected for students, including partial absences. Verify all new attendance codes are usable.	OK
28			After setting up a calendar day as a half instructional day, submit an absence for a student that missed that entire day	OK
29			After setting up a calendar day as a half instructional day, submit an absence for a student that missed half of that day	OK
30	9.2	Student SectionAttendance Event	[Optional] Verify section attendance events are published, including partial absences	OK
31	11.1	DisciplineIncident	Submit discipline incidents with all core fields	OK
32			[CRDC] Submit an incident with the HomicideIndicator and ShootingIndicator flags set	N/A	Homicide flag supported	CRDC specific elements
33	11.2	StudentDisciplineIncident BehaviorAssociation	Associate a student as a perpetrator to an incident submitted above that includes all usable fields	OK
34			Associate a student as a perpetrator to an incident submitted above that includes all usable fields as well as a gun as a Weapon, plus the GunFreeSchoolViolation, ReferralToLawEnforcement, SchoolRelatedArrestIndicator, and SeriosBodilyInjury fields			ReferralToLawEnforcement, SchoolRelatedArrestIndicator
35	11.3	StudentDisciplineIncident NonOffenderAssociation	[CRDC] Associate a student to an incident that features one of the harassment or bullying behavior codes, as a victim	N/A		CRDC specific elements
36	11.4	DisciplineAction	Submit a discipline action tied to the student/incident submitted earlier, including the GFSAExpulsionModifiedToLessThanOneYear field	OK
37			Submit a discipline action ties to a SPED student that also features the UnilateralRemoval field	OK
38	14.8	RestraintEvent	Submit a restraint event for a student including multiple Restraint Categories	OK
39	13.1	Grade	Submit a Final grade for a student enrolled in a section for its full length	OK
40			[Optional] Submit a progress, quarter, and/or semester grade for a student in a section	OK
41	14.2	Student SpecialEducation Program Association	Demonstrate how districts would skip publishing this data if they wish to publish SPED data using only NE's SRS	OK
42			Submit a SPED program record for a student that was in SPED, verify that the StartDate is within the current school year, and that all SPED program fields can be submitted including Service(s), Program, Setting, PlacementType, ToTakeAlternateTest, InitialSpecialEducationEntryDate, IEPBeginDate, and PartCTransitionDelayReason	OK
43			Submit a SPED program record for a student that first enters SPED in October of the current year, and then exits SPED before the end of the year. Verify the start date, end date, and ReasonExited are valid	OK
44			Submit multiple SPED records for a student that changes their program type (Part C to B) or setting during the school year, verify the end dates and exit code are correct	OK
45			Submit a SPED program record with multiple disabilities, and that the disability orders are correct	OK
46	14.3	Student TitleIPartA Program Association	Submit a Title I program record for a student that features multiple services and includes the TitleIPartAParticipant descriptor	OK
47	14.4	Student EarlyLearning Program Association	Submit a non-Head Start EC program record for a student that includes the EarlyLearningSetting descriptor, make note if multiple EC records can be submitted for student	OK
48			Submit a Head Start EC program record for a student that includes the EarlyLearningSetting descriptor	OK
49	14.5	Student Homeless Program Association	Verify that a Homeless program record can be submitted including the PrimaryNightTimeResidence and UnaccompaniedYouth fields	OK
50	14.6	Student SchoolFoodService Program Association	Submit a Food Program record for an enrolled student including the SchoolFoodServiceProgramService descriptor	OK
51			Submit multiple Food Program records for an enrolled student who changes their FRL status during the month of October	OK
52	14.7	Student LanguageInstruction Program Association	Submit a language program record for a student that include the EL Participation, LanguageInstructionProgram services, and RedesignatedEnglishFluent fields	OK
53			Verify the "Other" option for the language instruction program has been removed	OK
54	2.4	Program	Submit a fulltime remote Learning Modality program	OK
55			Submit a hybrid Learning Modality program	OK
56			Verify that existing programs are not altered	OK
57	14.1	StudentProgramAssociation	Submit a Learning Modality program record for a students for each of the programs created above, make note of any methods for assigning multiple students to a learning modality at the same time if any	OK
58			Alter & remove a student's Learning Modality program record	OK
59			Submit a Rule 18 Interim program record for a student	OK
60			Verify that the proper EdOrg (School or LEA level) and ProgramEdOrg (LEA) references were submitted for each type of program	OK
61	15.1	StudentAcademicRecord	[Optional] Submit a record for a high school student	OK
62	15.2	CourseTranscript	[Optional] Submit course transcript records for a 12th grader, which includes multiple years of course history (9th-12th grades)	OK
63	7.1	Staff EdOrg Assignment Association	Verify that these records are published for all teachers	OK
64			[Optional] Verify these records can be published for other users that may want access to the dashboard (such as the superintendent)	OK
65			Check for orphaned records after changing a teacher's state ID in the SIS
66	7.2	StaffSchoolAssociation	Verify these records are published for all teachers at their assigned schools	OK
67	7.3	StaffSectionAssociation	Verify that primary instructor records are published for all teachers connected to a section	OK
68	7.5	Staff EdOrg Contact Association	[CRDC] Verify all fields in this resource can be published	N/A
69	5.1	Parent	[Optional] Verify a parent record can be published, make note of the method used for indicating the primary parent if any	OK
70			[Optional] Verify the parent phsyical or mailing+physical address is published	OK
71			[Optional] Verify the parent unique ID is generated properly	OK
72	5.2	StudentParentAssociation	[Optional] Verify that enrolled students can be associated with their parent records	OK
73	10.1	Cohort	Verify that a manually defined cohort (for assessment rostering purposes) can be published, demonstrate all methods available to create this	OK
74	10.2	StaffCohortAssociation	Verify that a staff member with an existing state staff ID can be assigned to a cohort	OK
75	10.3	StudentCohortAssication	Verify that a student can be assigned to a cohort	OK
76	PRIOR YEAR API
77	-	-	Demonstrate how the 22-23 ADVISER connection with the new URL is maintained separately from the 23-24 connection	OK	Users will need to enter updated URL
78	11.2	Prior Year StudentSchoolAssociation	Verify that enrollment records can be added and updated for students	OK
79			Verify that exit dates and exit withdraw codes can be updated, especially dropouts, completers, and inter-district transfers	OK
80	6.1	Prior Year PostGraduateActivity	Verify a PostGraduateActivity record can be submitted for an 22-23 senior student (due in June 2024)	OK
81	11.1	Prior Year Student EdOrg Association	Verify all fields in the demographics record can be updated for an enrolled student, including the student address (due in June 2024)	OK
82	13.2	Prior Year Student SpecialEducation Program Association	Verify that a SPED program record can be updated for a student that began before 7/1/2023	OK
83	13.3	Prior Year Student TitleIPartA Program Association	Submit a Title I program record for a student that features multiple services and includes the TitleIPartAParticipant descriptor	OK
84	4.1	CourseOffering	Verify that the course offerings are published	OK
85	4.2	Section	Verify that all section records are published, including career academy and distance learning SectionDelivery fields	OK
86	11.3	StudentSectionAssociation	Submit a record for a student	OK
87	7.3	StaffSectionAssociation	Verify that primary instructor records are published for all teachers connected to a section	OK
88
89
90
91
92
93
94
95
96
97
98
99
100