Finding New Students to a school

[Chasina Worman]

I have been asked the following question.  Trying to wrap my mind around the best way to find the students for the question below?  Anyone have a query to find new students to a school/district?  

I need to create a contact list for all new 2014/2015 students that are not related to to other students. How would I do that? Mr Principall would like to personally call and welcome them to the school.

Hope everyone is having a great back to school!

[Robin Gage]

The way I would do it would be a bit heavy on the number crunching in Excel, but I think it will give you what you want.

 

Export ALL students at the school; name, grade, home_phone, entrydate, transfercomment, and entrycode (and anything else you want).

 

Sort your spreadsheet by home_phone.

 

Use Excel conditional formatting to highlight duplicates in the home_phone column.

 

Then use a data filter to only show entry codes of 09.  Any highlighted number means they have the same home_phone as another student.  The ones that are not highlighted are the ones you are looking for.

 

This is assuming that the person registering the students is using the right entry code.

--
Robin Gage
PowerSchool Admin
Northwest Arctic Borough School District
907-442-1833
www.nwarctic.org

--
You received this message because you are subscribed to the Google Groups "AK PSUG" group.
To post to this group, send email to ak-...@googlegroups.com.
Visit this group at http://groups.google.com/group/ak-psug.

[Kyle Schneider]

I've got a TLIST SQL page that has a list of all students who enrolled after the beginning of the year.

[David Henson]

Here’s a quick query that utilizes the family_ident field to find all students enrolled in the last 2 weeks that don’t have a sibling defined in PS.  Not terribly complex and easy to modify.  Limits results by currently selected school unless currently selected school is district office, then returns all results.

 

select  s.student_number

        ,s.lastfirst

from    students s

left outer join

        students sm

on      sm.id <> s.id

    and s.family_ident = sm.family_ident

where   (s.schoolid = ~(curschoolid) or ~(curschoolid) = 0)

    and s.enroll_status = 0

    and sm.id is null

    and s.entrydate > sysdate – 14

 

 

David Henson

Programmer/Analyst

Kenai Peninsula Borough School District

(907) 714-8800

 

“If you ever start taking things too seriously, just remember that we are talking monkeys on an organic spaceship flying through the universe.” – Joe Rogan

 

From: ak-...@googlegroups.com [mailto:ak-...@googlegroups.com] On Behalf Of Chasina Worman
Sent: Monday, September 08, 2014 2:07 PM
To: ak-...@googlegroups.com
Subject: [AKPSUG] Finding New Students to a school

 

I have been asked the following question.  Trying to wrap my mind around the best way to find the students for the question below?  Anyone have a query to find new students to a school/district?  

I need to create a contact list for all new 2014/2015 students that are not related to to other students. How would I do that? Mr Principall would like to personally call and welcome them to the school.

 

Hope everyone is having a great back to school!

 

 

--

[David Henson]

Here is a modification If you want to limit the sibling search to just those siblings currently enrolled in the same school.  Sorry, didn’t sufficiently read your original request.  If you don’t use the sibling match feature in PS, you could always match on home_phone instead of family_ident (not perfect but closeish).

 

select  s.student_number

        ,s.lastfirst

from    students s

left outer join

        students sm

on      sm.id <> s.id

    and s.family_ident = sm.family_ident

    and s.schoolid = sm.schoolid

    and sm.enroll_status = 0

where   s.schoolid = :schoolid

    and s.enroll_status = 0

    and sm.id is null

    and s.entrydate > sysdate - 14

 

David Henson

Programmer/Analyst

Kenai Peninsula Borough School District

(907) 714-8800

 

“If you ever start taking things too seriously, just remember that we are talking monkeys on an organic spaceship flying through the universe.” – Joe Rogan

 

[Chasina Worman]

Dave,

This is great! Thanks for sharing!

Chasina Worman

Information Specialist
KGBSD Central Office Ketchikan High School Room 234
Ketchikan Gateway Borough School District

Office: (907) 247-2139
Cell: (907) 254-3323

[Suzi Israelsson]

Hi All,

This team rocks!

Great Q Chasina and impressive code work out there. 

For years I have done basically what Robin mentioned. I select all to pull all the current students at that site > Quick Export > select various student fields to include needed student info, parent fields for their names, phone numbers, and the last field as the entry date.

It exports into Excel in a snap, I sort descending by the entry date field and the new kiddos are at the top of the list. 

It is a pretty fast and efficient way for us but I can see those that are savvy with code using the other methods mentioned!

Teamwork is POWER!

(;

Suzi

Suzi Israelsson
SIS - Student Information System Coordinator
Email: SuziIsr...@gmail.com

www.lksd.org
Ph: (907) 543-4930
Fax: (907) 543-4911
Lower Kuskokwim School District
P.O. Box 305, Bethel, AK 99559  USA

Happiness is a journey, not a destination. 

Author Unknown