Sent:	Tuesday, March 23, 2010 12:25 PM


Categories:	Important

 

To – District Administrators and Open Enrollment Coordinators
 
From – Mary Jo Cleaver and Merry Larsen, Open Enrollment Consultants
 
Subject:  Exporting Application Information from OPAL into Excel
 
 
You can now select specific fields to export when downloading application information from OPAL into Excel.  
 
To check this out, go to the Applications page.  Right above the Data Entry tab, click on Export to Excel.  
 
This will take you to a page that lists all of the fields that are in the application (including approval and denial 
information and school assignment information).  The default download contains the student’s full name,  
birthdate, grade, resident and nonresident school districts.  You can select any other fields you want to download (or 
“unselect” any of the default fields).    Please note that a number of fields are collapsed.  To expand them, click on 
the plus sign; to collapse them, click on the minus sign.  
 
Thanks to Donna Wood for another enhancement to OPAL!      
 
As always, if you have any questions, please contact us.  
 
Mary Jo Cleaver
Public School Open Enrollment Consultant
Department of Public Instruction
608-267-9101 or toll-free 888-245-2732
fax:  608-267-9207
email: maryjo.cleaver@dpi.wi.gov
website: http://dpi.wi.gov/sms/psctoc.html 
 
Merry Larsen
Public School Open Enrollment Consultant
Department of Public Instruction
608-266-2146 or toll-free 888-245-2732
fax:  608-267-9207
email: merry.larsen@dpi.wi.gov
website: http://dpi.wi.gov/sms/psctoc.html