Thursday, October 5, 2017

Settings in Campus Instruction

changing settings in Campus Instruction.

Hide dropped students
show picture
open with CI


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. 

Thursday, November 3, 2016

Chromebook and iPad Information

Here is the link to all the Chrombook and iPad inventory and repair tickets that were done at district level.

Tuesday, October 4, 2016

Chromebook Touchpad Reset Procedure

Reset Procedure for Touchpad Issue
Chromebook model, XE500C13-K01US and K02US

how to fix the chromebook trackpad issue. You take the back cover off, disconnect and reconnect the battery cable, and put the cover back on.
Just make sure you don't scuff it up while taking it off. If they know we've been in them it will void the warranty.
Here's a vid showing how to take it apart.

Thursday, July 21, 2016

Linking Google Spreadsheets

Youtube video on linking Google spreadsheets

use formula

=ImportRange("copy sheet link from / to #","sheetname!range:range")