Saturday, May 17, 2014

AISD teacher salaries among lowest in Travis County

EDITOR'S NOTE: A final project from the Spring 2014 course.

By Charity Lee and Chris Caraveo

Evidence shows that the rich only get richer when it comes to management versus the teachers who work for them in Austin schools.

The Austin Independent School District recently released the first draft of next year’s salary schedule for teachers. It depicts a 3 percent raise for teachers since last year, which is a one time thing according to the board. This document could particularly catch the eye of millennials moving into the teaching field who want to find economic stability in their field. This could also echo the concern of parents who want to make sure that educators are happy so their child does better in class.

There has been a substantial amount of debate and legislation centered around district progress of its students and the compensation of the teachers. Upon surveying records for AISD salaries there is a large gap between what educators and administrators earn. A teacher can come into the field making $43,286, which is more than decent but as time goes on room for growth proves to be incredibly slow. A teacher in the system who has taught for 5 or more years can only expect to earn about $1,000 more than that. However, make the leap to management and you can expect to earn more than half of that. There is ample room for improvement.

Angelica Evans, director of career services at the University of Texas Law School, is a parent of two kids who have experienced AISD education. Evans says that the teachers who care about their students must often dip into precious personal funds to get the job done.

“In general, many teachers are underpaid and not provided with the resources they need to effectively do their jobs. Those that really care end up spending a good amount of their personal funds for school supplies.”

The Texas Tribune compiled an extensive list of AISD employee salaries, from the superintendent and principals to teachers. This data was gathered in the summer of 2013, and so represents salaries from the 2012-2013 school year. The graphic below displays the salary gap between administrators (superintendent, principals, etc.) and teaching positions (teachers, assistants, etc.)

Click for visualization

An articled posted by the Statesman this year points out that those earning six-figures in AISD management have increased 65% in the past five years. According to AISD 74% of the budget goes to salaries. When taking even a closer look, you will see that former superintendent, Meria Carstarphen, are among the districts highest earners.

This is particularly alarming when you consider the fact that out of the 10 school districts in Travis County, Austin ranks a low eighth when it comes to teacher compensation. AISD must also issue about $160 million to the state for recapture, a process set in place also nicknamed “Robin Hood,” where wealthy districts must submit money to surrounding areas with less property to profit from.

Overall, core class teachers (math, science, English, social studies) are not making near as much as non-core subjects. Elective class teachers are earning a higher average salary than those who teach the topics that students will be tested on.

Click for visualization

Millennials should not worry too much about starting salaries coming out of college. Mario Pina, a fourth grade teacher at Perez Elementary School, graduated last year and immediately got hired after his interview at Perez went better than the rest. He found a principal and teachers who shared the same philosophy of student individualization, and the interview went beyond that. His current co-workers cared about him as a person and his personality suited the position best.

Though this is his first year teaching, Pina said he is not concerned about his current salary.

“I’m not worried about money at the moment,” Pina said. “I do think about the future and once I get into a relationship and have a family. How is my salary going to affect the way I’m living now and is it going to be a sufficient amount depending on how much my spouse makes? Those are the kind of decisions we’ll have to make.”

All that is far from now. Today Pina just focuses on individualizing each student to provide the best instructional methods for each of them.

While Pina may not be concerned about his income right now, that does not mean other teachers are affected by their earnings. It all comes down to lifestyle. Pina selected his apartment before he knew where he would work.

“I’m a single male teacher with no children,” Pina said. “So other teachers who have children definitely have to plan where they live and what kind of luxurious life they want to live.”

Click for visualization

Concerning salaries and benefits, teachers opt into a certain benefits plan at the beginning of the school year. Coverages such as health, dental and vision are available in various packages. Whichever plan a teacher enrolls in at the start of the year determines how great his or her benefits are as the year progresses.

When asked about whether teacher benefits should be modified, Pina said “As far as insurance policies, no. As far as salaries, that’s a whole different subject.”

The gap between teacher and administration salaries has long been an important discussion. Teachers want better wages in the event that resources like books and supplemental materials are scarce. Administrative positions, however, remain the overseers of the schools and districts, so with more responsibility comes a higher income than teachers.

As the salary gap continues, teachers will have to manage more frugal lives and wait for the day when money is not the problem it is now.

Sunday, April 13, 2014

QGIS: Save to KML

QGIS is free, open source, multi-platform. Download at qgis.org. It has lots of prerequisites, so be patient and methodical.

For this exercise, we are opening a file with all counties in Texas, then selecting the five in our MSA (Travis, Williamson, Hays, Bastrop, Caldwell) and saving them out separately as its own KML file.

This is a QGIS lesson on how to convert a .shp file to .kml to be used with Fusion Tables.



Download the zip file tl_2010_48_county10.zip. Unzip the file so you have a folder of contents. Note there are five files, including one .shp

In QGIS, go to Layer > Add Vector Layer. (Or look for the icon at left.)  Browse to your .shp file. 



Use the selection tool (pictured at left) to select Travis county, then hold the Command key (Mac) and select on Bastrop, Caldwell, Hays and Williamson counties. This should allow you to add them to your selection. It will look something like the photo at right, through your colors may be different, since QGIS picks them at random.









In the layers panel at left, right-click on the layer and choose Save Selection As ...
















Click on the Format option and then change the format option to "Keyhole Markup Language (KML).












Next, you need to choose where to save the file, and what to name it. Under Save As, click the Browse button, name your file in the Save As window what you want to name it, then negotiate to the folder where you want to save your file. Click "Save" to set the settings.








Then you'll need to check your CRS, or Coordinate Reference System. I've been OK using the NAD83:4269 setting, though I've seen some references suggest that Google wants WGS84:4269. Type the number into the Filter field and you'll see your's listed. Choose the one in the bottom window.






Once all of those are set, you can hit OK on the "Save vector layer as" window, and your new KML file will be saved. It is that new AustinMSACounties file that you can upload into Google Fusion Tables.


Online charting tools

Online charting tools
There are a lot of online tools to help you create simple data visualizations and embed them in your story, with more cropping up every day. Most of them are built upon Mike Bostock’s Data-Driven Documents, a powerful javascript library for visualizations.


These tools can be both easy and powerful, but they do have some disadvantages:
  • You are dependent on their hosting. If their site goes down or their business fails, your visualization and your data are gone.
  • Tools that start free may not always remain so. Some begin charging as you add more graphics, or after a period of time, or by the internet traffic that comes to your chart.
  • You can only do what the tool can do. If the tool doesn’t have the feature you need, it may not be extensible enough for you to add or create your feature.


But there is a lot of good, too. All these tools are easy to use and can be easily embedded in your story online.

DATAWRAPPER

Datawrapper.de is a German-built, free, open source charting service built upon D3 that has improved significantly over the past year. It’s listed first here for a reason: It powerful and easy to use. It has bar charts, pie charts, line charts, tables and even maps. The Guardian is a heavy user of datawrapper, hosting their own instance.

VIDA.IO

Vida.io is similar to Datawrapper, but using Google’s chart API as a back end.

INFOGR.AM

Infogr.am is a new, freemium tool to create online information graphics that allow you to mix text, photos and data. The charts you can create are professional looking.

INFOACTIVE

Infoactive is a freemium interactive infographic and data visualization service that is in open beta (as of 7/7/2014). It allows two free graphics before a subscription is required.

CHARTBUILDER

Chartbuilder is a static chart creator built by the Quartz.com website. It uses D3 to make the graphics, but they are not interactive at all. Benefits are the software is open source, so with effort you could create a version with your own styles. See an example on qz.com.

TABLES

If you are starting from scratch, my favorite table maker is TablesGenerator, which also has data to other formats. Tableizer is a dirt-simple spreadsheet-to-table converter from data. The columns are not sortable, nor is there any other interactivity, but it is a start.


There are probably dozens more services. The Google gives us ChartGo, OnlineChartTool, and Hohli. Use at your own risk or pleasure.

OTHER TOOLS

  • Timeline tools
    • TimelineJS: A timeline tool that’s as easy as filling out a Google Docs Spreadsheet.
    • StoryMap: TimelineJS + location. Nicer display than TimeMapper.
    • TimelineJS w/ Gigapixel: Zoom around a single image to tell as story.
    • TimeMapper: TimelineJS + location, but StoryMap is cooler.
    • Maptal.es: Another geographic timeline
  • SoundCite: Inline audio to support a story. (Not really a visualization tool, but still cool.)

Wednesday, April 9, 2014

Datawrapper graphic published

  Datawrapper.de is a pretty simple yet powerful visualization service. It can make bar graphs, pie charts, maps, tables and more.
  Here is an example map that was created using their sample data. After I copied the iframe code from Datawrapper, in Blogger I had to go to the HTML window to paste it in.

Wednesday, March 19, 2014

A highcharts test

This is a bit of a test. Will Highcharts work? Looks like it will.

Monday, March 3, 2014

Notes from NICAR 2014

This was my first NICAR conference, which has a focus on data-driven reporting and other technical aspects of our craft. The IRE conference usually has similar content, but is also broader in scope.

Here's the full schedule from NICAR 2014 and from IRE 2013 last year. This year's IRE 2014 will be in San Francisco on June 26-29.

But back to NICAR 2014. Here are the goods:


Here is a quick list of the panels I went to and what I got out of them.

Wednesday

Before NICAR in Baltimore, I also went to Tapestry, a data visualization conference sponsored by Tableau. Unlike the 900+ NICAR, Tapestry was limited to about 100 participants, all on the same tract. Speakers included Alberto Cairo, Aron Pilhofer, Fernanda ViĆ©gas and Martin Wattenberg and a host of others. It was good for inspiration, connections and a preview of Alberto's talk at NICAR, allowing me to double up on some content.

Thursday

  • Since I had seen Alberto's talk the day before, I could skip the first part of my D3 News camp to take some MySQL: I actually took two courses on this, which was more any overview of how a database manager can help you vs. Access, and an intro to Navicat, a paid tool to use a MySQL database. It went a little slow for me, but I did enjoy CIR's Chase Davis' take on it.
  • I hoped into the last part of the Intro to D3 talk, which really was a panel walk through of basic code, and I suffered from not being at the beginning. Quickly reviewed notes and hoped I would be OK for afternoon hand-on session.
  • Afternoon D3: In short, this helped me understand the structure of D3 better, but didn't build any proficiency and I would have trouble creating the most simple viz now. But it was better than not going.

Friday

  • Three hour-long sessions on statistics. The intro was really a get-to-know SPSS, a powerful and expensive statistics software package. We didn't get to the most important part of comparing two types of categorical information, so I felt like we missed out a little. The next session on comparing two continuous fields (linear regression) was awesome, and the third on comparing a categorical and continuous information (logistic regression) was also valuable.
  • Since I didn't get much actual SQL on Thursday, I chose the Intro to SQLite class and got the best tip of the conference: you can run SQLite in Firefox using the SQLite Database Manager, with no other software to install (at least on a mac.) This might be how I teach SQL in Data-Driven Reporting next year.
  • Next I helped Scott Klein (ProPublica) and Michelle Minkoff (AP) teach a session on grabbing data from the web.
  • Last was the lightening talks, 10 quick talks. It was a packed room ... well over 800 people. They were all good ... 

Saturday

  • Building a data-journalism course. One of the panelists from Maryland has his students work on the same data set so they can help each other. Amanda Hickman works to get more basic data and viz/charts in earlier courses so students have familiarity so they can get further in class. A couple have groups of students working on the same long-term project or different parts of same subject. Canadian used a donuts to describe databases (then ate them).
  • Clean, clean, clean your mess. Regular expressions class was helpful for this. I had no problem with the code, but had some problems with teaching style. Cleaning data class introduced OpenRefine and class after was helpful in reinforcing those skills. Refine is awesome.
In between all this I made spent good time with folks from the Canadian Broadcasting Company, Orlando Sentinel, Huffington Post, Pixar/Paramount, the Texas Tribune, the AJC, Dayton Daily News, Seattle Times, the Vancouver Sun, small papers in Pennsylvania, South Carolina and god knows where else. And speaking of God, some good bar time with gentleman attending a Catholic youth ministries and a different time with vets getting training at Veteran's Affairs. Also several folks from various schools and many more I'm just not remembering.

My eyes were opened to some database structures, and skills refined for Refine, which I proceeded to crash time after time for four hours straight working on a huge dataset. The statistics classes were well worth it, too ... I know I need to learn more, but that is OK.

Shaping data and the Tableau Data Shaper



Here is a good post that explains how you might want to clean up and *shape* your data for display in Tableau. How you format your data before import can determine a lot about what you can do with it once in Tableau.

The Tableau Add-in for Excel is a great help for this. Here is a post with detailed instructions about it, but I have some short cuts here, because our school machines don't give you admin access and you might not be able to download and run the .exe file.


  • Download this file (Tableau.xlam) and put it in Documents > My Tableau Repository.
  • Go into Excel > File > Options > Add-ins
  • At the bottom, choose Manage > Excel Add-ins and click Go
  • Browse to fine the Tableau.xlam file in Documents > My Tableau Repository.
  • Click OK through the boxes and you should end up with the "Tableau" menu in Excel.