Pre-College Reporting

Pre-College Reporting:

Each year you will create a copy of the USE ME (make a copy for new years) Master Precollege Stats spreadsheet (The only tabs on the spreadsheet should be titled precollege Report and contact hours).

1. Total # of K-12 Students Served: This number is found in the report called Pre-college K-12 Students Served. You will just have to add all the grades K-12 or subtract Pre-K, N/A and empty to get the total number of K-12 students served.

2. Contact Hours: This is the amount of hours we had contact with the participants.This will require many steps. DO NOT ENTER ANY NUMBER ON THE PRECOLLEGE REPORT TAB, YOU WILL ONLY ENTER INFORMATION ON THE CONTACT HOURS TAB AND IT WILL POPULATE ON THE PRECOLLEGE REPORT TAB FOR YOU.

   1. Open ideal-logic and the Precollege Report spreasheet (and go to the contact hours tab).

   2. In Column A you will see all the Programs we run listed. You will not touch any of the numbers in columns A-E these will populate as you fill in the information in Colums I-V (It is important that you do not delete any rows as it will mess up the formulas.

   3. Fill in all of the programs by going to ideal-logic and getting the information needed.

      1. For all of the programs you can find the information needed by going to the Program Dashboard and using the drop down tab above the participant name which says Schedule Option (ACES and Summer Day Camp), Level (Gymnastics), Current (Open Gymnastics, and Private Lessons).

      2. For ACES and Summer camp you can find the number of students who are in pre-care, lunch care, or after care by going to the groups and filtering for each group. Drop in pre-care, lunch care or after care can be found by clicking the blue option on the Dashboard that says Admin Charges (This is second from the bottom right next to the balance due location).

   4. If your number is below 90,000 then double check you got all of the programs

3. Total Students you have demographic Data For - This information will be collected from the report on Ideal-logic calledPre-College Demographic Report

4. Female Participants - This information will be collected from the report on Ideal-Logic called Pre-College Gender Distribution Report

5. Race of Participants (Line 17-21) - This information will be collected from the report on Ideal-Logic called Pre-College Demographic Report

6. Free/Reduced Lunch Participants - This information will be collected from the report on Ideal-Logic called Pre-College Free/Reduced Lunch Report. You will only count the families who qualify and are utilizing the services, not the families who qualify and are not using the services.

7. K-12 Teachers - Ask Karen or the hiring staff for this information. This is the number of teachers who work during the summer/school year.

8. Parent/Guardians - This information will be collected from the report on Ideal-logic called Pre-College Parent/ Guardian.

9. OSU Faculty/Staff Involved & OSU Students (Undergrad + Grad) Involved - Ask Karen or the hiring staff for this information. They will know this based off who was hired for the period of the report and where they went to school.

10. OSU Student Contact Hours - Ask Karen for this information, she will need to download a report from EMPcenter with the number of hours that the staff worked over the whole year.

11. Can your program uniquely identify Participants - This answer will always be yes.