Thursday, November 5, 2009

Data Management

Because of the type of CMO our CMO was Data Management was deemed the most important bucket. We focus on on ample, intensive, traditional learning to get our students from behind the curve and close the achivement gap. Our CMO felt the best way to do this was to focus on data driven instruction and operation. However given the fact that we had an organically grown infrastructure ecosystem, limited human resources, and a grant to implement a specific Student Information Management System our options for that first summer were very limited in our approach to addressing Data Management.

Our newly hired Director of Operations and a summer fellow we had on Staff dealt with the brunt of implementing the new Student Information System for our CMO and all of our schools. On the positive side of what we had to address, technically, the SIS we were encouraged to utilize via the grant was backended by an enterprise class database and the system was recognized as one of the market leaders. The reality was neither of those factors really meant much.

I did some very brief research on the solution we were about to take on and some research on the SIS market on a whole. It became readily apparent that the market, especially for our scale (more than 1 school but not a large district), was very nacent. The solution we were implementing was also known to be problematic in working with the data, it seemed like a black hole that sucked the data in but didnt let it back out. However it was backended by a major player in the sql market (although it was only recently moved the that back end the year we started implementing) so i thought we could always build our own systems to query the data if needed.

When we started the technical provisioning for the servers we found out 2 strange things. The first being even though we were a young organization at the time and not serving too many students the requirements (at the time) were astronomical for a server to run the application, 4GB of RAM, Dual processor box with 2GHz or above processors in the slots and a minimum of 512k cache on each processor (what was listed on their office spec guide said 512MB), 200GB of free space, etc.

When i saw those specs i said to myself wow what are we going to do send our students to Mars with an SIS?

The outrageous specifications (including the typos on their official spec sheet) was compounded by the fact that they said we needed 2 servers, because our schools spanned 2 states...yeah...

Such began our long and contentious relationship with our SIS.

Friday, October 30, 2009

Infrastructure

From the title you can tell what was determined to be the most important thing to tackle. We determined that while we would not obtain appreciable competitive advantage (read not the most important thing to help our kids learn) via our infrastructure, a solid infrastructure was determined to be the core building block for our IT environment.

Because of these we decided to commoditize our infrastructure. The 3 maxims were standardization, mobility (work anywhere/anytime) and simplicity. We developed core standards across the environment for all software and hardware that we were responsible for (we took on literally everything except copy machines). We also decided that since we were commoditizing our infrastructure, and due to the fact that the organization was in its infancy and would be going through some serious growth periods, we would "single source" outsource the management and maintenance of our entire tech infrastructure end to end.

The work anywhere/anytime mandate added some complexity to the equation. We were very early adopters of RPC over HTTPS in Outlook, getting all admin staff blackberry's with a BES and the ability to tether, pervasive wireless in all schools and offices with unified credentials, and a laptop for all staff including all teachers. We also implemented an Asterisk system that was both a great blessing and a great pain point. The Asterisk and RPC over HTTPS implementations expended some of the capital that we accrued through the Website development project.

One key thing to note is that we decided due to the way our schools operate we would have 49 weeks of absolute change control lockdown. The only time we would allow for execution on technology projects would be during the 3 weeks our teachers would have off. Of course the first year that was completely unrealistic given the nascent stage of our outsourcing agreement and our large project to implement the across the board standards while opening 2 new schools and moving 1 into a brand new facility. We were well short on our time and quality metrics for our summer infrastructure projects but in the end we did complete all of our objectives. The problem is that we left alot of pain in our wake.

The outsourcer we chose was great to us in our initial growth phase, though they had their hands full.

The work required alot of heroic actions and one of the things that i stated when i was interviewed is "we don’t want heroes". If we need heroes then we did something wrong.

After a few years we felt we had outgrown our outsourcer's service capacity, and moved on to another service provider which we are currently experiencing some growing pains with but we are hopeful that they can see us to scale.

To date the biggest challenge with our Infrastructure has been management of our outsourcer and management of our carriers. I have a vent session about ILEC's in poor neighborhoods on the docket for this blog.

Thursday, October 29, 2009

The first 100 days

When i was first hired at a Charter School Management Organization (herein Our CMO), in 2005 the organization was young in its incarnation as a CMO but it already had started 3 schools. The oldest was several years old at the time. Technology at the schools grew organically.

The key projects we identified to accomplish in the first 100 days were:
1) Get a handle on ERate and submit our applications that were due in the next month
2) Redesign our website and the websites of our schools to match our new branding initiative
3) Develop a framework for how Our CMO engages with Technology

Number 1 was tough but extremely important. Our CMO is a nonprofit CMO that opens schools in poor neighborhoods with the goal to close the achievement gap for our students.
This makes us a perfect fit for ERate. However our prior access to the funds were spotty. This project was a trial by fire. I went to USAC's fairly good website and proceeded to familiarize myself with the process. I had a limited window as the first form (form 470) was due shortly after i joined. Due to our prior spotty record filling out applications (best intentions but the process is complicated) we were hit with a Selective Review Information Request for all of our applications. Thankfully due to my strict adherence to the guidelines we passed our SRIR and were eventually approved for all of the funding we requested. Unfortunately the hard part was actually getting those approved monies disbursed in a timely manner, but that is a later discussion.

Number 2 will probably go down as my most successful endeavor in my role at this organization (for good or bad). My overall technology philosophy is KIS, or Keep it Simple (most people know the acronym has an additional S however i try to exempt negativity from all that i do whenever possible). While many of the stakeholders were dreaming of a Java enabled website with rolldown menus and fancy doodads i wanted a simple HTML site that worked well in any browser but leveraged the beautiful collateral that was available to us. In the end my adherence to design philosophy while compromising in areas that did not impact design made for a successful project. For example one school wanted cycling images and quotes on its main page. We did this with a very simple Javascript (instead of going the route of using Flash or other similar tool) and isolated the request to the home page in a way that did not impact navigation or design. This overall success, with my grasp of technical knowledge that was displayed in meetings, built up some organization capital for our new IT department of 1, capital that would soon be quickly depleted.

Number 3. The next large task was to develop a framework for how the organization viewed IT and to begin to identify projects within that frame work. We broke down technology at Our CMO into 3 areas (its always 3 isnt it). Infrastructure, Data Management, Technology in the Classroom. Prioritization decisions were made to determine which of those buckets were most important to address at the time, which projects we would attempt to tackle, and the desired timeframe to tackle them in. Oh and we needed to open 2 new schools and move one other during the summer, and manage growth in every school as well...but that is for a later article...