Technology

Technology

Thursday, October 5, 2017

Settings in Campus Instruction

changing settings in Campus Instruction.

Hide dropped students
show picture
open with CI

etc...




Wednesday, June 14, 2017

Grad Rate Calculation/Prediction

Here is my process (just FYI for you and a reference for me for next year!)

1. I ran a report for kids with a Date Entered 9th grade of 08/16/2013 to get a preliminary cohort number. (Ad Hoc titled Date Entered 9th GRAD RATE PREDICTOR)

2. I filtered on the list for withdrawal codes and totaled those per code. 

3. Change to the next year in IC and run the same report.  

4. Filter entry codes (other than C: Continuing in Same School) to get the number of students who transferred in that year. 

5. I filtered on the list for withdrawal codes and totaled those per code. 

6. Repeat steps 3-5 for junior and senior years.

7. Search GUIDE for claims for any kids listed as Dropouts and have Annette check folders for records requests. Remove any found from the denominator (or add a transfer code to the totals for the Excel calculation sheet).

8. Use those totals to fill in the DOE calculation sheet. (I also figured this by hand at a separate time and got the same number).

9. Check for No Shows in each year remembering that some kids are retained (so you can't just use cohort years).



**ALSO- I also used a Duplicate Enrollment GRAD RATE to get a list of kids who had multiple enrollments in a year (including no shows).  I ran it for each year keeping a list of names with duplicates. I then used the ad hocs listed above to add and remove enrollments to make a master list. Make sure to cross-reference with the duplicate names list.

Finally, I took this list and went kid by kid to determine end status. 


Monday, March 27, 2017

CTAE Total Data for RMF's Grant

Rebecca needs this for her grant each year. 

Here is how I ran this for future reference:

I used an export called CTAE data in my IC account. The report listed all kids and every class he/she took this year.

Then, I sorted out everything that did not have Vocational or Elective as the department. 

I went through the ones labeled Elective and determined that they were NOT CTAE classes. 

I concatenated the last name and first name into once column in Excel.

I then ran a subtotal where ever there was a change in name and got a total for each kid in the list. 

Finally, I copied and pasted the values from this subtotal into another sheet and sorted out the blanks.