Archive for July 20, 2008

Mahlum Architects

Here’s a shot of the Mahlum Architects offices, where I am waiting for our 9:00 meeting for the Catlin Gabel Creative Arts
Center. Note the central tables for discussion and sharing documents. The staff rearrange themselves periodically so that architects sit with their project teams.

Today, we take planning for data and audiovisual support to the next level. We are seeking to plan for future capacity without exceeding the budget, include flexible audiovisual solutions for classroom and gallery space, and ensure sufficient power everywhere for the laptop program.

To start the project, we will need to meet specific fundraising goals this year.

MacOS class

Today, I led day one of our MacOS class. I was pleased that five teachers and staff members chose to spend time learning more about an operating system. I wish more would seek such professional develoment, since good practice with one’s OS can make a huge difference. Four of the participants were switchng to a Mac at school or at home, and only one just wanted to better get to know their computer.I used an emergent curriculum approach, which worked well for day one. A brief introduction, prompt about challenges faced or problems solved, and then we spent the rest of the time rolling with the questions encountered as the participants toyed with their machines.We also discovered that any Mac loaner laptop user could control the screen of any other’s, because we used shared login credentials for our shared machines! We will have to change the remote management preferences, finding a way to allow screen sharing when useful and prevent it when not.

Converting Excel dates and times to SQL

Dates and times look great in Excel until you try to concatenate them within a formula. Then you see Excel’s messy raw date and time values. I have found it necessary to use the YEAR, MONTH, DAY, HOUR, and TIME functions to extract these values and then format them for a SQL query.

For example:

date and time

First attempt (didn’t work)
="INSERT INTO `tour_dates` SET `datetime`='"&D2&" "&E2&"';"

The result:

INSERT INTO `tour_dates` SET `datetime`='38260 0.375';

Boo!

Second attempt (worked!)

="INSERT INTO tour_dates SET `datetime`='"&YEAR(D2)&"-"&MONTH(D2)&"-"&DAY($D2)&" "&HOUR(E2)&":"&MINUTE(E2)&":00"&"';"

The result:

INSERT INTO tour_dates SET `datetime`='2008-10-1 9:0:00';

Yay!

Summer Workshops Begin

We have started our summer tech training workshops, classes that the IT staff and our media arts instructor teach on topics that our employees select. These require a lot of time and preparation from our staff, but our employees highly value the opportunity to learn. Our offerings this year include workshops on desktop publishing, Excel, iPhoto, Picasa, Mac OSX and Windows XP Pro. I am pleased that operating systems were a popular choice this year, given how overall proficiency with basic features is pretty low. I blame the software companies for annually rolling out new eye candy that help them market the products while underemphasizing fundamentals that help people work better. I wish that more people wanted to work on web technologies in the classroom, but we will have more opportunities to work on that once the school year begins.

Excel class

One challenge is the wide range of skill levels present in each class. Each teacher handles this challenge in her own way. I make the workshop highly project based and let the curriculum emerge from student interests and questions. This does leave me scampering around the room a lot answering questions and solving problems, but it keeps everyone working all the time at their level. This disappoints some students who come to the class expecting a lot of direct instruction, but most participants leave happy. I will teach the MacOS and iPhoto workshops. Do send any killer activity ideas that you have organized or encountered.

InDesign class

Flip Mino Reviewed

The Flip Mino has the potential to be useful in our school, especially for students creating work for immediate review or sharing. The Flip seems highly compatible with efforts to encourage student construction of knowledge, visual literacy, and multiple forms of representation. I can see teachers and students using these devices to practice foreign language recitation, interview subjects for a variety of purposes, and gather material for oral history projects. I can imagine huge impact during our international trips. With a portable digital video recorder, students could turn their view outward, collecting sounds, scenes, and interviewing people to include in a presentation or learning portfolio upon their return. Multimedia art students should have a blast with the devices.

The device is small enough to take along anywhere and starts up quickly. User controls are simple, especially the big red record button in the middle. The price ($145 at Amazon) is twice that of a small digital audio recorder, about right in my opinion to gain video in such a small device.

The Flip has the potential to remove barriers to using video in classes, as the Olympus WSM-300 did for us with audio this past year. The relatively low cost makes it possible to put devices in the hands of students more often.

Flip in hand

The small size makes it easy to carry a device off-site or package a class set. You can keep the camera on you more often, since it slips into a pocket.

Flip connected

One huge key is the USB mass storage feature. Like the Olympus audio recorders, USB connectivity is built into the device. This eliminates the most time-consuming step in conventional video capture — transferring footage from camera to computer. Now, one can transfer footage as a simple file copy or using The Flip’s proprietary software. Each Flip comes with its own software installer on the device. If you want more control and flexibility, open the INSTALL folder and run the 3ivx installer. You will gain the ability for QuickTime Player (Mac) to open these compressed AVI files. An open-source decoder also exists.

In my one-day test, 2GB storage was more than adequate. I shot here and there during a three hour visit to the amusement park — 25 short clips in total — and only used 500MB.

For some reason, converting the files from compressed AVI to MOV. I am not sure whether the problem lies in the AVI conversion, the special compressed format that the Flip uses, or my slow G4 Mac!

The Flip software offers buttons to quickly post video to YouTube and other video web sites. I haven’t yet tried them, but this could be a way to quickly get a movie into FLV format for the web.

For a $170 video recorder, the quality is excellent. A couple of weak points are the audio levels and zoom. In my single day of use, I found the audio pickup a tad weak, though it should be fine for interviews and other classroom applications. I also found the image too fuzzy at 4x zoom — it may be digitally enhanced.

I wish that the Flip had multiple folders for organizing stored clips, in the manner that the Olympus digital audio recorders do. Then, two students could share one device but keep their work separate.

Flip makes less expensive video recording devices, but only the Mino has a rechargeable battery. I would like to avoid the impact of disposable batteries, even though a dead rechargeable device will then be useless for the remainder of that period. Now I need to seek a device to charge a dozen USB devices at once.

How long before this level of video recording is a standard feature on cell phones, in the way that still cameras have recently become?

Here is a sample I shot today at full size and converted from 3IVX to QuickTime H.264 at 1000kb/s in order to retain as much as possible the quality of the original shot. Or, you can download the 3ivx version directly.

Moodle: Major Assignments Calendar Idea

Our faculty wants a “major assignments” master calendar, in order to identify days on which too many teachers have scheduled major assignments before they impact students. In Moodle, students automatically see all the assignments in their courses. I want a way for each teacher to see a summary of major assignments schoolwide as they schedule their own. To complicate matters further, it would be most helpful for a teacher to automatically see what major assignments their students (not all students) have on a given day.

I am thinking about how to implement such a feature in Moodle. (I am an average programmer). Since we want to track only major assignments, we need to find a way to distinguish major from regular assignments. We also need to write a function to count major assignments for the given day only for students enrolled in the class.

Ideally, this counting function would fire as the teacher selects the assignment date. That way, the teacher could easily move the assignment from one day to another and see the impact on students’ workloads.

In our school, it would be less work to create a new assignment type called “major assignment” than it would be to add a “major” checkbox to each assignment type. In our school, major assignments are not likely to be submitted electronically, and keeping the function in a separate module would avoid making changes to Moodle core code.

I could use your advice and feedback on this idea. Is anyone else working on a similar idea? Is there a better way to approach this task? Am I missing an existing feature in Moodle that could help me achieve this end?

Many thanks.

Update

I also posted this to the Moodle forums. Here’s an encouraging reply I received only seven minutes after submitting the question. Isn’t that amazing?

Re: Idea for a “major assignments calendar”
by Gary Anderson – Sunday, 27 July 2008, 07:42 PM

Hi Richard:

We have implemented this at our school. We have teachers label assignments by putting them in bold (we have a patch that adds the tag to the title. We also have a simple block that looks for assignments that have this tag and counts the number of affected users. We have taken the extra step of having a user profile field that shows if they are in the class of 2007, etc.

It works nicely and has avoided many scheduling conflicts. While we are not prepared to put this in Contrib, hopefully the above ideas will get you started, and I can send you are code on an “as is” basis if you contact me.

–Gary

I also just figured out that Gary is from Seattle Academy of Arts and Science, which I hope to visit in October.

iPhone vs. BlackBerry

Reading edutech blogs, one might think that the iPhone is the only mobile platform out there. As a happy BlackBerry user, I have resisted the urge to try out what is apparently the greatest device ever. Nonetheless, running a school tech department, I felt an obligation to at least try one out. Fortunately, we came into a free iPod Touch as a result of our annual, huge order from Apple.

ipod blackberry

Before you get too excited, let me state for the record that the iPhone is a more capable device than the Blackberry. It can do more (and do it better). Its graphics are superior, the screen is larger, and the glass keyboard isn’t as bad as I thought it would be. The camera shoots better pictures, and you can watch TV shows on it. RSS and Twitter text is more readable and easier to navigate.

Now that we have got that out of the way (phew!), let us consider a different question. What functions do I need in my mobile device?

On my Blackberry, I run:

  1. Phone

  2. Mail
  3. Calendar
  4. Address book
  5. Notes
  6. Tasks
  7. GMail for a hosted domain
  8. Google Maps
  9. TwitterBerry
  10. Facebook
  11. Google News
  12. NewsGator Reader (RSS)
  13. Opera web browser
  14. Camera

In other words, I can interact with practically all of my information sources from this device. I can blog, twit, photo, and so on. I can pay attention to either work or personal mail, depending on the day of the week. I suppose I could play music, but ever since I shortened my commute to 5 min, I don’t need to. When consuming information, I prefer text to audio and video, or at most a page of text supplemented with other media.

I paid $0 for the Pearl with a new AT&T service contract.

Adding the handheld to our school BlackBerry Enterprise Server took about 5 minutes.

I recharge the battery every other day.

To download new BlackBerry applications, I typically just Google what I want and download it from the manufacturer’s web site (i.e., like any other download). Click Install, and I’ve got the application.

iPod Touch

I spent about 20 minutes trying to determine whether I could avoid registering the product with Apple and still download the 2.0 software update. I could not.

$9.95 for the software update for a device we just purchased? I couldn’t just pay the fee and download the software. I also had to create an iTunes Store account in order to pay the fee.

Applications are only available through Apple. That seems scary. Every installation requires my iTunes password, even for free products. Why?

Apple says that they now fully support mail for Exchange servers. Except that it doesn’t work for me. Microsoft Entourage can access our Exchange server great through HTTP. Why can’t this iPod?

If I want push email, we have to install an Exchange ActiveSync server. I doubt this is as simple as Apple’s diagram might suggest.

ActiveSync

Let’s focus on teaching and learning

It’s easy to get seduced by all the gadgetry out there, but this takes time away from our main purpose of building capacity to support teaching and learning. I’ll stick with the BlackBerry (for now).

Create

I picked up this coffee mug to remind me to always create new ideas and content. In the darkest months of winter, warm beverages will remind me that the sea of content is best navigated when we participate in the creation of that information. May you create something today.

Laptop orientation

25 students and their parents attend the first of three ninth grade laptop orientations. We take advantage of this opportunity to provide training and advice to our students. We balance a broad overview of laptop use in courses with specific technical tips and advice on appropriate use. It’s an exciting time for the kids, many of whom are receiving their own, individual laptop computer for the first time.

Presentation Slides

Training Notes

Facebook too weird for 30-somethings?

Facebook is apparently still learning how to handle married couples. Does that mean that I am too old/not in the right stage of life for it?

Facebook

In related news, my friends from outside work are increasingly getting on Facebook. It’s interesting to watch and participate.