Print

Print


I'm not very good at it. I get confused!


Gloria Ormsby
Student Data Manager
Burlington School District
www.bsdvt.org
802-864-8434 ext. 48002


On Tue, Oct 30, 2018 at 1:31 PM Leslie, Ben <[log in to unmask]> wrote:

> Vlookup have been my savior for many years with the SECT.
>
> On Tue, Oct 30, 2018 at 1:24 PM Gloria Ormsby <[log in to unmask]> wrote:
>
>> Great idea Ben! Thank you.
>>
>>
>> Gloria Ormsby
>> Student Data Manager
>> Burlington School District
>> www.bsdvt.org
>> 802-864-8434 ext. 48002
>>
>>
>> On Tue, Oct 30, 2018 at 12:59 PM Leslie, Ben <[log in to unmask]> wrote:
>>
>>> I was able to obtain our last census report from the state, which has
>>> the entry codes on them.  I image this should help with a large majority of
>>> your students?
>>>
>>> using this file, I was able to do an excel vlookup formula and and match
>>> students based on the PERMID
>>>
>>> On Tue, Oct 30, 2018 at 12:47 PM Gloria Ormsby <[log in to unmask]>
>>> wrote:
>>>
>>>> Hello,
>>>>
>>>> Back to this topic.....
>>>>
>>>> I'm not concerned about ExitType because it will be blank for all but
>>>> transfers and that is recorded correctly. However, the EntryType is
>>>> incorrect. We need the first EntryType from the very first enrollment for
>>>> that student. I was thinking of using MIN to grab the earliest EntryDate
>>>> and then get the code. However! Since the district was using custom
>>>> entrycodes, that could very well pull an invalid code. Should I try to
>>>> convert the code to a legal code by taking all of one custom code and
>>>> decide to put all of those into one legal code?
>>>>
>>>> Looking for ideas and SQL help.
>>>>
>>>> Thanks,
>>>>
>>>> Gloria
>>>>
>>>>
>>>> Gloria Ormsby
>>>> Student Data Manager
>>>> Burlington School District
>>>> www.bsdvt.org
>>>> 802-864-8434 ext. 48002
>>>>
>>>>
>>>> On Fri, Oct 26, 2018 at 9:36 PM Leslie, Ben <[log in to unmask]> wrote:
>>>>
>>>>> My understanding is grade changes (within the same school) or reported
>>>>> on the gradeprog report with no code (just dates and grade #s)
>>>>>
>>>>> My email on the list serv yesterday about the 06_gradeprog night
>>>>> explain it.
>>>>>
>>>>> I believe exit codes are only meant to be used when departing the
>>>>> school org
>>>>>
>>>>> But who knows?...how many schools have their guidance dept or
>>>>> registrar offices working overtime on these reports?
>>>>>
>>>>> Ben
>>>>>
>>>>>
>>>>>
>>>>> On Fri, Oct 26, 2018 at 9:15 PM Michelle Devino <
>>>>> [log in to unmask]> wrote:
>>>>>
>>>>>> Hi Ben,
>>>>>>
>>>>>> What do you do when you run the End of Year Process? Doesn't it
>>>>>> require a code to be used for each of the various student changes
>>>>>> (promoted, retained, etc.)? I started this year with generic codes too,
>>>>>> because the state codes don't make sense for the end of year rollover.
>>>>>>
>>>>>> Michelle M. Devino
>>>>>> Data Manager
>>>>>> Colchester School District
>>>>>> [log in to unmask]
>>>>>>
>>>>>>
>>>>>>
>>>>>> On Fri, Oct 26, 2018 at 9:11 PM Leslie, Ben <[log in to unmask]> wrote:
>>>>>>
>>>>>>> I’d use an exit code whenever a student leaves the school.  If the
>>>>>>> student leaves the school, their enroll org changes. And I’d say a new
>>>>>>> entry/exit date and code is needed
>>>>>>>
>>>>>>> When changing grades within a school org,(same ps#)  they're not
>>>>>>> exiting a school and no code is needed, unless it’s matriculation to
>>>>>>>  middle school  or HS with a different org#
>>>>>>>
>>>>>>> If they never attended, don’t report them, unless they withdrew over
>>>>>>> the summer (attending the year before) and then I might exit them on the
>>>>>>> first day of school
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> On Fri, Oct 26, 2018 at 6:32 PM Gloria Ormsby <[log in to unmask]>
>>>>>>> wrote:
>>>>>>>
>>>>>>>> Hello all,
>>>>>>>>
>>>>>>>> All this data collecting is a great time to review our business
>>>>>>>> practices. I started my job last January and so some things I continue to
>>>>>>>> try and understand. I'm interested in how you all maintain your exit codes
>>>>>>>> for enrollment. I know there are 19 exit codes that the state defines. My
>>>>>>>> predecessor created some additional codes which he then would move to one
>>>>>>>> of the state codes for the state reports. Many of these don't maintain the
>>>>>>>> definition of what each code is. For example, theses are a few custom exit
>>>>>>>> codes:
>>>>>>>>
>>>>>>>> Promoted to next grade
>>>>>>>> Demoted to lower grade
>>>>>>>> Transfer to BSD school
>>>>>>>> Never Attended
>>>>>>>>
>>>>>>>> So you can see it is hard to fit those into one of the 19 exit
>>>>>>>> codes. I referred to the State Register for guidance and it looks to me
>>>>>>>> like when a student transfers from one school to another, they don't get an
>>>>>>>> exit code as they haven't exited the district. Is this true? So when going
>>>>>>>> to another school or grade in the district, it is the entry code that
>>>>>>>> matters. My guess is that this would use the "Transfer from a public school
>>>>>>>> in VT." And then they only have an exit code when they leave the district.
>>>>>>>> I just don't see entry/exit codes that define a student moving from grade
>>>>>>>> to grade and school to school.
>>>>>>>>
>>>>>>>> Is this right? Interested in how you all interpret this given the
>>>>>>>> list of entry and exit codes the state provides.
>>>>>>>>
>>>>>>>> Gloria
>>>>>>>>
>>>>>>>> Gloria Ormsby
>>>>>>>> Student Data Manager
>>>>>>>> Burlington School District
>>>>>>>> www.bsdvt.org
>>>>>>>> 802-864-8434 ext. 48002
>>>>>>>>
>>>>>>>>
>>>>>>>> -----------------------------------------------------------------------
>>>>>>>>
>>>>>>>> Search <http://list.uvm.edu/archives/school-it.html> the SCHOOL-IT
>>>>>>>> Archive
>>>>>>>>
>>>>>>>> Manage <http://list.uvm.edu/cgi-bin/wa?SUBED1=SCHOOL-IT&A=1> your
>>>>>>>> Subscription to SCHOOL-IT
>>>>>>>>
>>>>>>> --
>>>>>>> Ben Leslie Battenkill Valley Supervisory Union 802-375-2589
>>>>>>> 802-375-6409
>>>>>>>
>>>>>>>
>>>>>>> -----------------------------------------------------------------------
>>>>>>>
>>>>>>> Search <http://list.uvm.edu/archives/school-it.html> the SCHOOL-IT
>>>>>>> Archive
>>>>>>>
>>>>>>> Manage <http://list.uvm.edu/cgi-bin/wa?SUBED1=SCHOOL-IT&A=1> your
>>>>>>> Subscription to SCHOOL-IT
>>>>>>>
>>>>>>
>>>>>> -----------------------------------------------------------------------
>>>>>>
>>>>>> Search <http://list.uvm.edu/archives/school-it.html> the SCHOOL-IT
>>>>>> Archive
>>>>>>
>>>>>> Manage <http://list.uvm.edu/cgi-bin/wa?SUBED1=SCHOOL-IT&A=1> your
>>>>>> Subscription to SCHOOL-IT
>>>>>>
>>>>> --
>>>>> Ben Leslie Battenkill Valley Supervisory Union 802-375-2589
>>>>> 802-375-6409
>>>>>
>>>>> -----------------------------------------------------------------------
>>>>>
>>>>> Search <http://list.uvm.edu/archives/school-it.html> the SCHOOL-IT
>>>>> Archive
>>>>>
>>>>> Manage <http://list.uvm.edu/cgi-bin/wa?SUBED1=SCHOOL-IT&A=1> your
>>>>> Subscription to SCHOOL-IT
>>>>>
>>>> -----------------------------------------------------------------------
>>>>
>>>> Search <http://list.uvm.edu/archives/school-it.html> the SCHOOL-IT
>>>> Archive
>>>>
>>>> Manage <http://list.uvm.edu/cgi-bin/wa?SUBED1=SCHOOL-IT&A=1> your
>>>> Subscription to SCHOOL-IT
>>>>
>>>
>>>
>>> --
>>> Ben Leslie
>>> *Coordinator of Technology*
>>> Battenkill Valley Supervisory Union / Arlington School District
>>>
>>> *Arlington High School*
>>> P: 802-375-2589 ext. 165
>>> *Fisher Elementary School*
>>> P: 802-375-6409 ext. 261
>>>
>>>
>>> -----------------------------------------------------------------------
>>>
>>> Search <http://list.uvm.edu/archives/school-it.html> the SCHOOL-IT
>>> Archive
>>>
>>> Manage <http://list.uvm.edu/cgi-bin/wa?SUBED1=SCHOOL-IT&A=1> your
>>> Subscription to SCHOOL-IT
>>>
>> -----------------------------------------------------------------------
>>
>> Search <http://list.uvm.edu/archives/school-it.html> the SCHOOL-IT
>> Archive
>>
>> Manage <http://list.uvm.edu/cgi-bin/wa?SUBED1=SCHOOL-IT&A=1> your
>> Subscription to SCHOOL-IT
>>
>
>
> --
> Ben Leslie
> *Coordinator of Technology*
> Battenkill Valley Supervisory Union / Arlington School District
>
> *Arlington High School*
> P: 802-375-2589 ext. 165
> *Fisher Elementary School*
> P: 802-375-6409 ext. 261
>
>
> -----------------------------------------------------------------------
>
> Search <http://list.uvm.edu/archives/school-it.html> the SCHOOL-IT Archive
>
> Manage <http://list.uvm.edu/cgi-bin/wa?SUBED1=SCHOOL-IT&A=1> your
> Subscription to SCHOOL-IT
>