Back To Schedule
Tuesday, April 10 • 8:40am - 9:40am
Pivot Tables and DDE FILLING

Log in to save this to your schedule, view media, leave feedback and see who's attending!

Feedback form is now closed.
Limited Capacity filling up

We will use DDE (Direct Data Export)  and Quick Export to pull information out of PS then use Pivot Tables to get the data to show the findings of the fields pulled.  An example would be for pulling CTE info and then using that data to quickly total CTE minutes for each student that can then be imported back into PS.  Before I found how useful Pivot Tables could be, it would take a least a couple of days to look over the student schedules and calculate the minutes for each CTE class.  With Pivot Tables it only takes a few minutes. 

avatar for Wanda McGuire

Wanda McGuire

Secretary, Labette County High School
I'm a mother of 1 girl, 2 boys, and have 2 granddaughters. I've been a school secretary for 20 years in USD 506. The first 9 years were at one of our 5 grade schools, the remaining years I have been at the high school. I am in the PS Admin, in charge of the district state uploads... Read More →

Tuesday April 10, 2018 8:40am - 9:40am CDT
Flint Hills