Lighthouse has a new layout. Prefer the old one? Return to the old layout, and switch back any time from the link at the top of each page.

look into storing historical enrollments

#598

this would by default track district as well.

The solution going forward is to start tracking enrollment history, which would allow SIMS to know what grade, school (and thus district) a student was in at any given time. This would make historical schoolwide reports and statistics possible.

Reported by shawn (at vegantech) · February 10th, 2011 @ 12:46 PM

State: new
Assigned to: shawn (at vegantech) shawn (at vegantech)

Activity

  1. shawn (at vegantech)
    shawn (at vegantech)
    • Milestone order changed from 54 to 0

    March 28th, 2011 @ 03:38 PM

  2. shawn (at vegantech)
    shawn (at vegantech)
    • Milestone changed from For Jan 2011 DPI meeting to For Apr 2011 DPI Meeting
    • Milestone order changed from 56 to 0

    March 28th, 2011 @ 03:40 PM

  3. shawn (at vegantech)
    shawn (at vegantech)
    • Tag set to today
    • Milestone order changed from 60 to 0

    Some notes

    Historical Enrollments
    track school and district changes in SIMS.

    Uses:
    Viewing data over a time period
    Reclaiming student that left district
    leaving and joining school
    leaving and joining district
    id, student_id, school_id, district_id, start_date, end_date, end_year

    [end_year matches enrollment end year, the end of the current school year]

    populate this from backups
    figure out how to do this

    Add when
    manually adding student to district or creating student
    adding student to district via CSV
    adding student to school manually
    adding school to student manually
    adding student to school via CSV

    End when
    manually removing studnet from district
    removing student from district via CSV
    removing student from school manually
    removing student from school via CSV

    Should this replace enrollments and the district_id in student?
    need to think about this, I think I will start with them separate and then think about combining them later.

    August 27th, 2011 @ 04:25 PM

  4. shawn (at vegantech)
  5. shawn (at vegantech)
  6. shawn (at vegantech)
  7. shawn (at vegantech)
    shawn (at vegantech)
    • Milestone order changed from 39 to 0

    split historical district assignments and historical (school) enrollments [#676 Historical District Assignments]

    May 11th, 2012 @ 09:41 AM

  8. shawn (at vegantech)
    shawn (at vegantech)
    • Milestone changed from For Apr 2011 DPI Meeting to Evaluate to see if applicable.
    • Milestone order changed from 34 to 0

    November 9th, 2012 @ 07:26 PM

  9. shawn (at vegantech)
    shawn (at vegantech)
    • Tag changed from today to tomorrow

    August 13th, 2014 @ 08:37 AM

Please Sign in or create a free account to add a new ticket.

With your very own profile, you can contribute to projects, track your activity, watch tickets, receive and update tickets through your email and much more.