The direct certification is handled by the Technology Department since it involves taking data from the SIMS database and putting it into a different format. This process is needed to get the qualifications for Free and Reduced based on state registrations. It will be ran 3 times a year to compare our students with what is on record at ODE which means uploading a student roster that will return a match of those registered for state support.
- Run the export report.
Open Excel
Click on Data
Under “Get External Data” Select From Web
Log into SIMS
Select Data/Reports –> File Download Menu
Click on the Direct Certification Data File Link
NOTE: THIS WILL POP-UP IN A NEW WINDOW… that’s ok, just copy the URL and paste it into the New Web Query address window.
You can then select the data and import it into A1.
Once you have the data, save the file as a Text (Tab Delimited) .txt file
- Upload and process the file.
Once the file is processed, it will have to be uploaded to ODE in order to get the matching results.
Connect to:
https://oh.cnpcares.com/Splash.asp
Enter the username and password.
Click on “National School Lunch Program”
Click on Direct Cert
Click on Continue to DC App
Select the School Year
Click Continue to the Direct Certification website
Upload the .txt file that you created in step #1
- Download and e-mail the results.
Once the file is processed, it will present a link to Begin Matching.
Click on the link to begin matching.
After the matching you will get 2 download files. One is in Excel and one is a text file. Download both files and e-mail them to Food Service and EMIS.