Technology

Technology

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.