OnBlog: The Onboard Informatics Blog

Conversations on the Art and Science of Information

Posts Tagged ‘schools

Why More Data Makes People Happier

leave a comment »

When potential buyers consider what they want in a community, what comes to mind? Are they young hipsters looking for an apartment closest to the most live music venues? Or are they looking for a chiropractor in the vicinity? The priorities consumers have when buying are as varied as the consumers themselves, and it takes a warehouse full of information to satisfy them all.

Local Amenities, one of the most important products and services Onboard Informatics provides for its customers, is the transformation of raw data into meaningful information about the services available in a particular community. Each month sees new additions to the data records we maintain, meaning that the overall picture of a community that can be created is even more inclusive.

Last year at this time, Onboard was supplying 2,221,609 Amenities records to its clients. Currently that number stands at 4,084,253 records, almost double that.  New categories have been added that give a more comprehensive overview of community offerings. If you can think of something you’d want to have in the place you live, chances are that the data is there to tell you whether or not it’s available.

In 2007, if you were a health nut looking for eating and drinking establishments that specifically sold health foods, you were out of luck. But organic food fans, never fear — new Amenities records can help you find the nearest Whole Foods. Working parents who need childcare services? The most recent Amenities data lets you search for nearby Gymborees.

As for education, new data about student housing and vocational schooling has been added to existing records on Catholic, public, and private schools (as well as higher education). In addition to the information Onboard offers about education under Amenities, clients also have access to School Profiles and Reviews. The increase in data records can be seen here, too, since we’ve added about 5,600 reviews over the most recent month.

The more data you have, the more informed you are. As data records in areas like Local Amenities and School Reviews continue to increase, the results can only be more knowledgeable and more satisfied clients. Plus, now they’ll be able to search for the nearest spas in a community — does it get any better?

Written by Tara Powers

August 5, 2008 at 6:19 pm

Bulldog Pride! …Or Why I Will Never Look at School Mascots the Same Way Again

with 2 comments

bow wow wow

I’ll bet you thought your school mascot was pretty awesome. No other school’s paltry representative could hold a candle to your Mustangs or Lions or Wildcats.

Well, guess what? There are hundreds and thousands and millions (okay, maybe I’m exaggerating) of other Mustangs, Lions, and Wildcats out there. How do I know this? Because I’ve tracked down all of their Web sites.

Well, maybe not all of them (although at times it felt like that). For the past several weeks, part of my work here at Onboard Informatics has included updating our (rather extensive) list of invalid school Web site URLs.

For instance, a link to Willow Grove Elementary School may not lead where it’s supposed to because:

a) there might be a misspelled or incorrect address in our database,

b) the link was correct at one time, but now isn’t because the school district has updated or moved its Web sites, or

c) it actually does lead where it’s supposed to, but takes longer to load and so is coming up invalid.

What to do? Well, since Onboard has the school name, address, and district information available as well, we go out to the Internet to search for that school’s current, working Web site. Oftentimes, searching by district is the easiest way to go about tracking down these schools. Since the data is grouped by district in our file, a group of schools that all come from the same district can be taken care of by finding just one district home page.

But of course, nothing is as easy as it sounds.

For one thing, did you ever stop to think about exactly how many Springfield School Districts there are? (Answer: A lot more than you’d think. One in Massachusetts, Oregon, New Jersey, Missouri, and Illinois, and that’s just the first page of Google results.)

What about those pesky Colorado school districts that follow every normal name with an alpha-numeric code? And don’t even get me started on Missouri and its Roman numerals (Harrisburg R-VIII? Really?).

Then there are the schools that, try as you might, you just can’t find. Maybe they’ve closed, or the district’s Web site really isn’t functioning, or they’re in a rural area whose schools may not have set up Web sites yet. In cases like those, we delete the invalid URL that had previously been misdirecting users, but we leave the field blank — from a data perspective, it’s better not to have a Web site listed for a particular school than to supply an incorrect one.

___________

When the sons of Eli break through the line

All of these school URLs are helpful to have on hand when providing information about the offerings of districts in a particular neighborhood. At Onboard, we have valid, school-specific URLs populated for almost 40,000 of our schools — roughly 33 percent of our total listings. We also have a school or district URL populated for close to 80 percent, or 100,000 schools.

Out of about 36,000 distinct total school URLs that were validated, 3,500 changed their URLs over the last year. Of the remainder, we were able to provide valid URLs for about 15,000 schools for which we previously had no information.

After going through all 36,000+ of those school URLs, we ran the modified data through a check to pull out any links that were still broken — only about 1,000 (a much more manageable number, relatively speaking). And when that 1,000 is compared to the approximately 6,000 invalid URLs we finished with last quarter, that averages out to around 3,500 broken links Onboard deals with over a quarter.

Making sure that the data out there is as clean and accurate as possible is a vital part of what we do at Onboard, and keeping data that is constantly being modified, the way school data is, up-to-date is an ongoing task.

So maybe your school’s mascot isn’t the one-of-a-kind Golden Eagle (or other unstoppable creature) you thought it was, but you can still take pride in the fact that your school has a fully functioning website. Just do all of us data collectors a favor — don’t set all 25 links on your home page to blink simultaneously. Trust me, that’s never a good design…

___________

Quick and Random (and not statistically accurate) Fun Facts:

Most popular mascots — Bulldogs, Eagles, Tigers, Lions
Most unique mascots — Winged Beavers, Atom Smashers, Awesome Blossoms, Fighting Quakers, Cheese Makers
Most “interesting” school names — Slaughter Elementary School, Stalker Elementary School

Written by Tara Powers

July 30, 2008 at 10:41 pm