PowerSchool: Community: Article Details

Fed race codes in auto send

By Greg Boettger on September 21, 2010

So, i just found out today(funny how the guys who needs to know what is going on is usually the last to find out) that we are going to use Review360 for discipline in the elementary. One part of the export they need is

Is hispanic/Latino: can use the fedthnicity code for this

How can I get the following to show up as a seperate column. I know I can go the students race table, but adding Racecd to an export gives me nothing.Anyone have an idea

American Indian or Alaskan Native

Asian

Black or African American

Native Hawaiian/Other Pacific Islander

White

Tags: Race/Ethnicity

Comments

1 Response to "Fed race codes in auto send"

Sharon VanCleave on September 21, 2010

You have so many students compared to the small schools I work with so I don't know if this is feasible or not.

Are you familiar with the =LOOKUP formula in Excel?

You can export StudentID and RaceCD from the Student Races Table. When I tested this, I exported Student_Number, lastfirst, and id from the student table. I then copied the 2nd export to the 1st export file. I copied and arranged the info to look like this:

Column A: StudentID B: RaceCD C: formula for name D: formula for student number E,F (blank) G: lastfirst H; id I (blank) J: student_number K: id

In Column C, Line 2 - I used the formula to get their name =LOOKUP(A2:A357,$H$2:$H$357,$G$2:$G$357)

In Column D, Line 2 - I used this formula to get their student number =LOOKUP(A2:A357,$K$2:$K$357,$J$2:$J$357)

That matches your student names & numbers to your StudentID and Race CD. Students who have more than one race checked will have more than one line.

You can then copy and paste Columns A-D into your file with the fedethnicity info. When you paste you will need to use the popup menu of the Past Options "clipboard" and select Values Only. You will need to sort what you pasted by same field your fedethnicity file is sorted. Then you can add/delete as needed. I don't know what format you need the file for the Review360. Is there only one field for Race?

Let me know if this doesn't make sense.

Would you like to comment? Join The PowerSchool Community for a free account, or login if you are already a member.