OnBlog: The Onboard Informatics Blog

Conversations on the Art and Science of Information

Posts Tagged ‘mascots

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