150 likes | 158 Views
Student Indicators and BeginDate / EndDate Analysis. 2 Nov 2017 5 Dec 2017 Update. Student Identification and Contact Information. Without BeginDate / EndDate. With Optional BeginDate / EndDate. Address [0..n] InternationalAddress [0..n]. BirthData Citizenship [0..1] Name
E N D
Student Indicators and BeginDate/EndDate Analysis 2 Nov 2017 5 Dec 2017 Update
Student Identification and Contact Information Without BeginDate/EndDate With Optional BeginDate/EndDate Address [0..n] InternationalAddress[0..n] • BirthData • Citizenship [0..1] • Name • ElectronicMail [0..n] • LoginId [0..1] • OtherName [0..1] • StudentIdentificationCode [0..n] • Telephone [0..n] • Optional BeginDate/EndDate could be easily added to the complex types. • History could be captured by making them [1..n] • Possible bundling of some into a Contact record Which, if any of these is it important to keep history?
Student Indicators without a BeginDate/EndDate Characteristics that should change slowly, or not at all Indicators relating to an evaluation, assessment, or program process Disability [0..n] DisplacementStatus [0..1] EconomicDisadvantaged [0..1] LearningStyle [0..1] LimitedEnglishProficiency [0..1] SchoolFoodServicesEligibility [0..1] • HispanicLatinoEthnicity [0..1] • Language [0..n] • OldEthnicity [0..1] • Race [0..n] • Sex If history is desired, could be bundled into a dated Student Record • Could make into complex types with dates • Could be bunded in an attribute of StudentSchoolAssociation • Could be bundled into a new StudentEvaluation entity associated with the StudentSchoolAssociation
Student Indicators with Optional BeginDate & EndDate • ProgramParticipation [0..n] • Note that the Student attribute ProgramParticipation is duplicative with StudentProgramAssociation • StudentCharacteristic [0..n] • StudentIndicator[0..n] • Could be bunded into attributes of StudentSchoolAssociation • Could be bundled into a new entity associated with the StudentSchoolAssociation
StudentCharacteristic (Descriptor) • Asylee • Displaced Homemaker • Foster Care • Homeless • Immigrant • Migrant* • Neglected or Delinquent* • Parent in Military • Pregnant • Refugee • Runaway • Section 504 Handicapped* • Single Parent • Unaccompanied Youth • Other * Has overlap with a Program
ProgramParticipation (ProgramType) • Prekindergarten - Extended Day • Prekindergarten - Full Day • Prekindergarten - Half Day • Preschool Special Education • Public Preschool • Regular Education • Remedial Education • Section 504 Placement • Service Learning • Special Education • Student Retention/Dropout Prevention • Substance Abuse Education/Prevention • Teacher Professional Development/Mentoring • Technical Preparatory • Title I Part A • Title I Part D Subpart 1 • Title I Part D Subpart 2 • Vocational Education Foreign Exchange Gifted and Talented Head Start Health Services Program High School Equivalency Program (HSEP) Home Visiting IDEA Immigrant Education Independent Study Indian Education International Baccalaureate Kindergarten - Extended Day Kindergarten - Full Day Kindergarten - Half Day Library/Media Services Program Magnet/Special Program Emphasis Migrant Education Neglected and Delinquent Program Optional Flexible School Day Program (OFSDP) Other • Adult/Continuing Education • Alternative Education • Athletics • Bilingual • Bilingual Summer • Career and Technical Education • Cocurricular Programs • College Preparatory • Community Service Program • Community/Junior College Education Program • Compensatory Services for Disadvantaged Students • Counseling Services • District-Funded GED • Early Head Start • Early Intervention Services Part C • English as a Second Language (ESL) • Even Start • Expelled Education • Extended Day/Child Care Services • Fee For Service We could require that Programs and StudentProgramAssociations be created
Existing Begin-End Dates Assocations Entities AcademicWeek GradingPeriod Intervention LeaveEvent (updated in 2.1) OpenStaffPosition EmploymentPeriod(DatePosted, DatePostingRemoved) Session • EducationOrganizationInterventionPrescriptionAssociation • FeederSchoolAssociation • StaffCohortAssociation • StaffEducationOrganizationAssignmentAssociation • StaffEducationOrganizationEmploymentAssociation • EmploymentPeriod (HireDate/EndDate) • StaffProgramAssociation • StaffSectionAssociation • StudentCohortAssociation • StudentParentAssociation (does not have dates, but should it?) • StudentProgramAssociation • StudentSchoolAssociation • EntryDate, Exit/WithdrawDate • StudentSectionAssociation
New Period pattern • New common type Period • Would be multi-valued attribute [0..n] or [1..n] • Best applied when you need to capture the history if the “in’s and out’s” • Semantically, a stack of the periods • Periods do not overlap • On the last (top) may have open EndDate • Use cases for API: • Get, with last Period • Get, with all Periods • Close out a current period, update with end date for last Period • Create with new Period with BeginDate • Create with new Period with BeginDate and set EndDate of previous Period
Period pattern is appropriate for associations where there are possible in’s and out’s
Existing Begin-End Dates Period Assocations Entities AcademicWeek GradingPeriod Intervention OpenStaffPosition EmploymentPeriod(DatePosted, DatePostingRemoved) Session • EducationOrganizationInterventionPrescriptionAssociation • FeederSchoolAssociation • StaffCohortAssociation • StaffEducationOrganizationAssignmentAssociation • StaffEducationOrganizationEmploymentAssociation • EmploymentPeriod (HireDate/EndDate) • StaffProgramAssociation • StaffSectionAssociation • StudentCohortAssociation • StudentParentAssociation (does not have dates, but should it?) • StudentProgramAssociation • StudentSchoolAssociation • EntryDate, Exit/WithdrawDate • StudentSectionAssociation
If Period applied to the StudentProgramAssociation, it should also be used for ProgramParticipation Is the case as strong for StudentCharacteristic and StudentIndicator?
Student Alternative Packaging of Student Attributes
Is this the right name? New Student Data Packaging StudentEvaluation[n:1] association to StudentSchoolAssociation Student Contact[n:1] association to Student Address [0..n] InternationalAddress[0..n] ElectronicMail [0..n] Telephone [0..n] BeginDate/EndDate • Disability [0..n] • DisplacementStatus [0..1] • EconomicDisadvantaged [0..1] • LearningStyle [0..1] • LimitedEnglishProficiency [0..1] • SchoolFoodServicesEligibility [0..1] • ProgramParticipation [0..n] • StudentCharacteristic [0..n] • StudentIndicator[0..n] • BeginDate/EndDate • BirthData • Citizenship [0..1] • HispanicLatinoEthnicity [0..1] • Language [0..n] • LoginId [0..1] • Name • OldEthnicity [0..1] • OtherName [0..1] • StudentIdentificationCode [0..n] • StudentUniqueId • Race [0..n] • Sex • BeginDate/EndDate
Nuances • Remove optional BeginDate/EndDate within records • Address [0..n] • InternationalAddress[0..n] • ProgramParticipation [0..n] • StudentCharacteristic [0..n] • StudentIndicator[0..n] • Provide better guidance for Programs • ProgramParticipation is used to designate an intent based upon an evaluationentered into the SIS, typically at the time of enrollment • StudentProgramAssociation is used to denote enrollment in the program entered into a specialized application or module of the SIS