It’s the last week of the on-line Instructional Media course that I’ve been taking as part of the BC Provincial Instructor Diploma Program. For our final project, students create a choice of an educational blog, wiki, podcast, video, or any other digital media artefact. Having had some experience with most of those, I decided to tackle something new for me: a screencast.

For added challenge, I also chose not to produce a narrated screencast, but instead one that uses text to explain the proceedings. That turned out to be much more difficult than I first imagined.

The topic of my screencast is “What If?” analysis using spreadsheets. It’s a simple enough concept — play with the numbers until the spreadsheet calculates an appealing result — but it’s a good introduction to the power of spreadsheets for students that previously used them to store checklists or addresses, if they used them at all. “What If?” analysis also demonstrates everything that computers are good at: repetition, calculation, and graphical presentation. That’s really the underlying theme of the Practical Computer Fluency course that I regularly teach at the College.

The product of my efforts is below. The text is a bit small, so you may instead want to view the full-size version. In either case, you can click the little button at the bottom-right of the player to expand the video to the entire screen.

I’m pleased with the outcome, even though its educational value is limited. You will notice that it’s quite difficult to follow in places; my test audience had to repeat sections over and over again.

If you find that the tune begins to wear after some six minutes, try editing a video with that as the soundtrack. Makes one pine for the dulcet tone of a vuvuzela.

By my count, I’ve quit jobs at Yukon College twice before. So the fact that I start teaching a class this afternoon must mean that I’m a very bad quitter.

“Poor quitting skills,” it reads on my permanent file. “Shows a marked inability to resign, abdicate, decamp, vacate, withdraw, knock off, terminate, desist, or just plain give over already. Criminy.”

My yo-yo relationship with the College makes it a little unnerving to enter the building. Fortunately, I have a course to absorb all of my attention. It’s well within my competency to teach one or two courses. Beyond that, the Peter Principle takes effect.

So, while it is true that I am wholly and singularly to blame for any and all mistakes made before and because I quit, I take heart that I am not to blame for the many more mistakes that would’ve surely been made had I not quit. I mean, had I not quit that second time, after that first time I quit but before I unquit the time before this. Or something.

For one final time, I will be teaching the COMP210: Database Design course this fall at Yukon College. The curriculum changes the following year; database courses will still be offered, but more likely in an online format.

So now is your best chance to learn about relational database design and the SQL query language in a conveniently located (if you happen to reside in Whitehorse) cozy classroom with an exceptional student-to-teacher ratio.

Who should take the course? Simple: anyone with a problem involving data. You can bring your problem to class and we’ll convert it into a living, breathing database that you can manipulate and query with abandon. Each student completes a term-long project (ignore the course outline page that mentions five projects), and real-world projects are the most satisfying to complete.

I also build a small database project each term to give students a feel for how their own projects will evolve.

You should be comfortable using a computer to take the course. You don’t need a programming or math background, although familiarity with things like Excel functions or filling out income tax forms is of definite benefit.

All of the notes for the course are available online. Previous years’ notes as well: 2006, 2004, 2003, and 2002.

The course is scheduled for Monday mornings 10am to noon, and Tuesday mornings 9am to noon. If the students all agree, we may be able to change that to be more accommodating.

The first class will be on Monday, September 8th, and you can register up until the 5th.

If you have any questions, please contact me at the College: drogers at yukoncollege dot why-kay dot see-ay (those last two groups are letters, not Pig Latin — sheesh, the hoops we jump through to avoid spam).

As of today, Carole has completed all of the requirements for the Yukon Native Teacher Education Program (YNTEP). On her way home from school — a four-month student-teacher internship at Hidden Valley — she picked up a letter from the department asserting that the University of Regina, in conjunction with Yukon College, will confer upon her a Bachelor’s degree in Education. The formal ceremony will be in June, but she can begin teaching right away in the territory (and Saskatchewan, for that matter) at the full BEd rate.

Carole’s the first person in her family to earn a university degree, and we couldn’t be more proud of her.

As befits the approach of mid-life, I’m starting something new this fall. Thing is, I don’t exactly know what that will be. What it won’t be is something at Yukon College: neither teaching nor computing.

There are a number of reasons for my leaving the College, paramount of which is the answer to this question:

When I look back in five years time, will I be glad that I chose well-paying system maintenance in a windowless basement?

Teaching is a separate issue. Unfortunately, there just aren’t enough students. Not for what I teach, anyhow. While I could keep my hand in for one course per term, that’s too low a job-satisfaction-per-unit-union-nonsense ratio for my tastes.

No, it’s to be a clean break from the College for me. That is, after one more month of part-time contract work in the aforementioned basement. Then begins a German course I’ve had my eye on. Perhaps even a spot of welding next spring.

My “something new” may just be a career as a Mercedes mechanic. I know of at least one in the Territory — and wouldn’t you know it — it’s usually parked at the College.

It took me a while to thumbnail-ify it, but this is the poster that I submitted as the major assignment in last term’s SOCI209: Society, Technology, and Values (PDF) course.

Click to see the full-size ~380KB version. I don’t think I’ll link to the 8MB PNG original.

My goal in creating the poster was to show that the value we place on privacy is in a steady state of decline since the advent of digitized persistent storage — the Network — and increases only transiently through public shocks of violation.

I was never entirely satisfied that the poster’s narrative was sufficiently persuasive, and visually it’s too wordy, but I still think it looks pretty sweet. The glossy 2′ x 3′ version hangs over my desk at the College and never fails to impress…me.

I created it using Macromedia Adobe Fireworks, the only graphics program I’ve ever even partly glommed. Probably the trickiest bit was drawing the green circuit-board-ey border.

Of course, the day after I dropped it off at Staples to be printed, Google announced their acquisition of DoubleClick. One more slight upward blip in our value of privacy before the bottom drops out.

The Computer Studies department at the College set its second-year program of courses for the upcoming academic year. The normal slate would consist of five courses each term, but only three will be offered in the fall, and just two come winter. The reason? Only two of the sixteen students that started in September remain in the program.

The first-year program will again run full-bore, assuming someone registers.

The second-year of the program ran partially this past year, and not at all the year before (due to an alternate-year student intake). As someone who teaches second-year material exclusively — more an artefact of scheduling than advanced content — my full-time employment prospects are dim.

The problem stems from a simple lack of students. My first year at the College, I was spoiled by an exceptionally strong group of twelve. The number dwindled to five the following year, and just a couple since then. It does make for a superb student-teacher ratio, one that betters Oxford’s tutorial system.

There was, and still is, great hope for the recent accreditation awarded the program by the Canadian Information Processing Society (CIPS): graduates can transfer their two-year diplomas toward a computer science degree down south.

So where are the students? I can think of a few explanations (none substantiated):

• Alberta. Although our students can fetch about $46K upon graduating, that’s peanuts compared to someone with a pipe trades ticket in the oil patch.
• Whitehorse. There aren’t all that many IT employers in town, and the College may have simply saturated the market, particularly for network positions.
• The Tech Bust/Offshoring. Ever since 2001, fewer and fewer students have enrolled in IT programs, fearing that the jobs are gone and won’t come back.
• University Computer Science. High-school seniors with geek tendencies are very likely to enrol in a university program — go Outside and see the world a bit.
• Admission Requirements. Those that didn’t have the prerequisites for university, or returning mature students, tend to be put off by the math component.
• CIPS Accreditation. To meet their standards, the program had to incorporate more programming courses and eliminate electives. Traditionally, more students have pursued the networking stream. Programming increasingly seems to be an “either you have it or you don’t” type of endeavour.

What I can’t think of are solutions, so my imminent career plans don’t include much teaching. Oddly enough, I don’t seem to have any trouble finding programming work. What I can’t seem to do is train anyone else for these jobs.

Eugene Wallingford of the University of Northern Iowa writes about teaching computer science and — yawn — marathon running. A posting of his dating from June crystallizes my every thought on textbooks, especially those intended for CS courses. In Picking a Textbook for Fall, Wallingford writes:

I don’t like textbooks.

That’s what some people call a “sweeping generalization”, but the exceptions are so few that I’m happy to make one.

For one thing, textbooks these days are expensive…

…[one-semester textbooks are] written specifically not to serve as a useful reference book for later…

…I want to teach my course, and more and more the books just seem to get in the way…

…By and large, these books aren’t about anything.

[emphasis in the original]

Wallingford concludes by announcing that he has chosen a multimedia-oriented trade paperback for his Java-based CS1 course. For one thing, it should make the programming exercises more meaningful to the students, and for another, it will stay out of the way when he fills in the theory gaps with his own notes.

For my own courses, I either eschew textbooks entirely, or use them selectively for portions of the curriculum. And “textbook” isn’t the correct term, as I tend to choose trade books from either O’Reilly or Peachpit Press. These are much less expensive — I once inherited a database course with a $180 hardcover text that was all but useless — and will serve as references for students who continue in the field after graduation (we’re always going to lose a few to Alberta’s tar sands).

Teaching sans textbook does add to the instructor’s responsibilities: not only to provide sufficiently detailed lecture notes, but also to assign readings that address the topics in an alternate voice. And there is more effort required in developing a course without an accompanying text; we can assume that the writers of these tomes have expended a great deal of effort into the incremental organization of the material — that, and writing out the answers to the odd-numbered questions.

The textbook publishing industry plays an expected role: distributing free samples of the latest glossy hectodollar opus. As of the present, I haven’t been swayed by such enticements, but then with titles like Spacial Databases, Fundamentals of Database Systems, and Administrator’s Guide to SQL Server 2005, they may yet bore me into submission before the next academic year.

We’ve all enrolled in these: 3-day training courses on some fad software package or newfangled programming paradigm. I’ve taken ‘em. I’ve taught ‘em.

I’d like to create and teach more of these in the future, but only under the condition that I define what such a course should be in the first place.

Paying for a typical training course entitles one to periods of enforced playtime, snacks in the morning, and a nap in the darkened lab following a chicken luncheon. In other words, your $2,000 has bought you three days of kindergarten.

The true benefit of these courses is that you’re made to think about the subject material for a period of time in an environment with fewer distractions than the office. And you may even learn something, most likely disjoint facts without any organizing narrative or context.

And let’s not forget the laser-printed graduation certificate!

Leaving aside this ready-for-framing certificate, you would derive the identical benefit by reading a trade softcover on the subject and actually trying out the exercises listed therein.

My definition of a course is one that starts at that point: students have read the book and experimented with the concept before enrolling. The course is now less about spoon-feeding the basics and covering the installation two-step, and more about answering the questions that arose during the students’ experimentation and demonstrating the practical avenues for future experimentation. The instructor’s role is then to impart experience (something that can’t be learned from a book) rather than knowledge (something that can).

Naturally, my perfect course is nigh impossible: people shelling out for training do so precisely because they don’t want to have to read or learn on their own, organizations running such courses don’t want to forgo income by enforcing prerequisites, and the instructors must command a wealth of experience — instead of having simply read the book and been given advance possession of the curriculum materials — and therefore command higher rates.

Of the many folks that exit a traditional training course muttering, “That’s nothing I couldn’t have learned from a book,” there must be a niche demographic willing to pony up for something better.

We were exploring abstract data types one day in class, when a student looked up from his notes and asked, “How do you spell ‘queue‘?”

“Oh that’s easy,” I answered, “F-I-F-O.”

He failed to see the humour.