Excel Pivot Tables ('sigh of relief')
Oh, I am pleased for pivot tables! They make your life soooo much easier. I am not an expert on pivot tables or excel, in fact, I am an absolute pivot table beginner. But this is pretty easy and worth the hour it has taken me tonight to figure out how to solve the problem. It won't take you this long, because I have the solution right here! My goal : I wanted to analyse the student success data from NCEA results that NZQA offers which is 2004-2014. I wanted to find out if the changes I had made since becoming HOD of our department in 2007, had long term effects on our student outcomes. I already had many years worth of NCEA data but made sure I had all of it. I had to edit the format of the data to make sure it was uniform in format. Problem : to get the averages of % achieved, % merit, % excellence for each subject, for each level, for each year WITHOUT calculating it all by hand. I figured it was worth spending time ...