Excel Magic
July 2, 2008 — Vanessa RileyI’m the first one to admit that “knowledge of Excel” will never be a bullet point on any of my résumés, but after playing around with Eduphoria today, I (with help from Breanna and Gregg, that is) exported the school’s TAKS data to an Excel spreadsheet, figured out a way to color code scores, and wrote a script to organize the data by color coding. I am going to focus mainly on the first time test takers. I color coded the scores thusly:
- score over 2200 = green (strong pass)
- 2100 – 2199 = pink (passed, but might not pass the Exit test)
- 2000-2099 = yellow (failed, but is close)
- 1999 and under = blue
Obviously, this is not a scientific method of organization, but with so few students, I had to give myself a broad enough range to identify who would benefit from this pilot.
This is starting to be a time-consuming process. I was up here two days last week to play with the equipment and talk to Derek. I was up here yesterday from around 8:00 to 3:00 and I’m estimating that today is going to look the same. But I’m with Stacey and Peggy brainstorming and it’s a very energetic, creative process. I love it!
Still no mic – I need to call the company and see where they are. Stacey brought up one of her own mics today so I’m hoping that we’ll be able to play around today. If we get anything, we’ll post it up here.
