Every other assessment grabbed those substring values correctly except for this one. Then I looked to the right and saw that they all shared the same assessment source. So when I saw the blank in Grade and 201 in Academic Year, there was something goofy going on with my calculated fields and translation.
#Sketchup thumbsup dll failed to register download
I added translations for all three values, making 2014 = 2015, 2015 = 2016, and 2016 = 2017 so that at the very least, when I download the data, it’ll look right and I can do additional manipulation after that. In comes the translation feature in the advanced menu. Those values are the start of the school year, when I want the end. I wasn’t done yet, because those don’t really represent the academic year the way we need it to. That formula was SUBSTRING (G FROM 1 FOR 4), so taking the first four characters of that same column, resulting in values of 2014, 2015, and 2016. Then, I created a second calculation column for Academic Year. To get around that, I created the Grade column as a calculation, using the formula SUBSTRING(G FROM 19 FOR 1), which means “take Column G (the one titled Assessment Grade/Administration) and starting at position 19, grab 1 character.” Because all of the assessments are named according to the same convention, that position would be the grade value (K, 1, 2, etc.). I needed to somehow grab the grade level of the student and the academic year in order to get some kind of separation in my BI report, but that information isn’t stored within the assessment itself because of how Illuminate manages student visibility to users, depending on permissions and filters. The reason this jumped out at me is because of the use of calculations and translations in the Advanced menu of the report builder. I sorted by academic year to see where that 201 was coming from. So I went back to Illuminate to look at the custom report that created that data file. Where is the 2016 academic year for 1st grade? And what the hell is that 201 doing there? I clearly had bad data in the source file. That’s when I noticed something weird:Īt the same time, I loaded the file into Excel to start a pivot chart, and saw the same thing:
#Sketchup thumbsup dll failed to register pro
I created the source table in Illuminate and downloaded it to prepare to use JasperSoft Studio Pro to create a BI analysis of performance over time. The challenge: put together the assessments from 6 grade levels over 3 years in 2 test periods per year into one table (so a total of 36 separate sources into one). The project: aggregate Fountas & Pinnell performance results for the past three school years.
0 kommentar(er)
