A wiki spreadsheet.

I have to say that up until recently I didn’t see what was so great about spreadsheets. I have been using them for years to analyze student achievement data and present findings to others, but the didn’t seem like the “killer-app” that so many others seem to be thinking about.
 
On the other hand, my wife speaks in spreadsheets and she can really make them sing. She can have fields reference across fifteen different sheets and set up a budget in a matter of moments.
 
This is extremely cool if all you want to do is present information or figure out what makes sense in terms of data, but as a collaborative process, I just didn’t see it.
 
That was until Google Spreadsheets started opening up anonymous access to spreadsheet using forms and protected links. I started using google forms in order to record interest in our district’s online school (http://edcsd.org). This proved an effective way of collecting specific information and storing it in a place that could be accessed from everywhere. So, in this sense, it was a mass collaboration that was added to with every entry. No one really is able to see the scale of the collaboration, that is, except for me.
 
Well that was a neat trick, but it is nothing compared to the idea of a spreadsheet wiki. One feature that was just added to google spreadsheets is the ability to share a link with others that will let others edit it without having to sign up for a google account.
 
This means that students could record data on the same spreadsheet without having to sign in. It means that achievement data (not on specific students, though) could be aggregated in one place, all without having to teach an entire staff about a new service. It means that you could keep track of all of your school’s goals with everyone adding their notes, never having to go through the extra hoop of remembering a password.
 
Perhaps best of all, it would allow all of those who do not yet see the value of massively-collaborative projects to participate in one without ever knowing about it and by using a tool they already recognize as important: spreadsheets.
 
Perhaps I am making too much out of this. Perhaps there are other tools that do this already, but as I am on a search for ways to eliminate as many logins as possible, this is one great step in the right direction.
 
Do you see any new ways of using this? Are spreadsheets more valuable now?
Sent from my Verizon Wireless BlackBerry

Posted via email from olco5′s posterous

Create your own MobileMe (Sync Everything, at all times).

An aside: it is too bad that every post I write seems like an attempt to get back into the habit of posting, but I suppose until I start blogging consistently again, that is just how it is going to have to be. I have missed way too many things that I have been thinking about to ever fully catch up, but perhaps I can start anew. Anyway, here are my latest thoughts.

Before I go into the details of how to sync yourself completely, I want to tell you why I even undertook this idea. Well, our school system uses an extremely proprietary e-mail and calendaring system called firstclass. Every person that uses firstclass in our schools is locked in to using the firstclass calendar for appointments and things of that nature. But, because I have seen the light of using Google Calendar (open API, shared calendars, embedding, etc), I refuse. In fact, I was so obsessed with the idea of converging the two that I speant an entire weekend (when I wasn’t having fun with my family) on getting Firstclass to sync with Google Calendar, and then eventually my new blackberry that the school district provided for me.

So, this is how you sync everything:

Calendars:

Contacts:

Now, for the details…

(Update: I didn’t put this in the initial post, but I think it is worth mentioning that Firstclass does have a way to sync with both Palm Desktop Software and SyncML directly, but since my district hasn’t set either of these up, I thought it was important to try and find a better way of doing things… there are also third party services that do some of this, but I want a FREE workflow)

In order to get your first class calendar to talk to anything else, you will need to export it as a iCal file:

Now, you may look at this picture and ask, why I wouldn’t just export it as a blackberry file and skip all of the steps in the middle. Well, there are a few reasons. One, if I did this, all of the events would be duplicated every time I exported and imported. Two, because I am on a Mac I do not have any blackberry desktop software to make this sync work.

So, onward we go to iCal. First, you will need to set up your Google Calendar to sync with iCal, using this handy dandy tutorial from Life Hacker.

Now that you have your Google Calendar set up to sync, simply import into iCal your latest and greatest export from Firstclass:

Now, if this isn’t your first time doing this, you will end up with a lot of duplicates. If that is the case, just use the iCal Dupe Deleter. This is also a good tool for deleting duplicates from Google Calendar if you have ever found yourself with too many of one item.

Now, you have synced completely to your Google Calendar and you are ready to sync to your blackberry. Simply point your device to this address and download your over-the-air sync application.

You can now enter an event in Firstclass, iCal, Google Calendar, or on your blackberry and they will sync with one another. Pretty cool, right. But, we are not done. If you would like to have your calendar in an even more universal Format, you can put it on a SyncML server, like Funambol.

All you have to do is download their blackberry application and you can sync to your heart’s content there.

For Contacts:

I understand that MobileMe does a lot more than this, but I believe that if we can create a FREE workflow for each one of our teachers, students, and administrators that syncs information to the place that they need it, we will be able to have the conversations that truly matter. We will no longer be stuck trying to find information, it will always be ours. Although you may not geek out at all that I am proposing, I think there are some pretty heavy implications for continuity in the systems that we are creating. If you have figured out any more syncing tricks, please leave a comment and add to the value of our collective research.

The Ripe Environment: Connecting more than two dots.

There is a severe lack of time in the air. It pervaides every conversation I hear on many days:

“No, I don’t have time for that collaboration right now. Maybe after this quarter is over.”
“Are you sure that it has to be due tomorrow. I really think that having the weekend when I don’t have games or practices or school would make more sense.”
“I don’t even have time to think.”

Hyperbole aside, this lacking is palpable. I think it is one of the only times that a lack of something can be more heavily felt and deeply understood than the presence of it. Many people, though, have just gotten used to having no time to connect the disparate parts of their working or waking lives. It has become the film upon our skin that always coats our interactions but can’t be rubbed or cleaned off.

I am not one of those people, however. I believe that connecting the dots and creating time for that process is possible. I believe that it is all about creating a Workflow of Passion (requires a better name, but that’s all I’ve got).

When I say passion, I do not mean that you must be equally in love with every assignment or task that you come across. Instead, I mean that there is something meaningful within each thing that you do. There is some meat there, no matter how hidden it may be in the luke-warm soup of “other stuff.” The only way to craft the time to connect that meat to something else equally meaty is to plunge your spoon in and not be satisfied with the carrot or water chestnut you come up with the first time. (I would like to apologize to both the literary crowd who sees the metaphor being stretched thin and the vegetarian crowd who beleives that no one should be looking for meat within a vegetarian soup.)

So, what does this spoon plunging action look like. Well, I have recently taken to a maxim for resolving the issue of time suckage and distraction in the classroom and out.

“Use the tool that has everything you want, and nothing you don’t.”

Although the different image settings in Photo Booth are cool, the distraction factor is so high that it is nearly impossible to use it as an instructional tool (for kids or adults).

Wikipedia provides a cornocopia of educational resources, but blind searches are still stabs in the soup that lead to less than appetizing results.

The Ripe Environment is anywhere that makes information clickable, that sets the path of least resistance to learning as the norm. The Ripe Environment is a place that doesn’t waste time on stuff that doesn’t matter. It is a place that the workflow always works for the user, according to their needs and passions.

The Most Change For The Most Kids

The most change for the most kids Play Now | Play in Popup | Download (136)

June 27, 2007 12:30PM

It is with some hesitation that I post this podcast. I am a teacher, and I will always be a teacher. However, I have been given the opportunity to do more. I have been recruited (although not formally given the position) for a Technology Integration Position in a nearby school district. This podcast is all about coming to terms with the idea of leaving the classroom so that I might create change and achieve School 2.0 in a larger way. At this point, I am very much interested in following my passion for finding solutions, and if this job provides solutions for more teachers and more students and also for my family, I don’t know that I can do anything other than pursue it. I am, however, still looking for others who have either made this transition or who have rejected it in favor of the classroom. Please e-mail me at benwilkoff@gmail.com if you have any questions or ideas.

Show Notes:

• 00:00:00: Intro to the Great Transition
  The Podcast Blog
• 00:00:58: Karl Fisch put me up to it.
  The Fischbowl
• 00:01:59: Why is the first wave leaving the classroom?
  Slow Motion Distributed Car Wreck
• 00:05:28: The Long Haul Teachers
  Cool Cat Teacher
• 00:07:15: What Should School 2.0 Leadership Look Like?
  Leadership Development for Educational Technology Leaders
• 00:09:27: What happens to the classroom I leave behind?
  My classroom Website
• 00:10:51: Other Factors
  My Daughter’s blog
• 00:11:55: The most change for the most kids
  My Blog

links for 2007-11-23

• Cool Cat Teacher Blog: Free Twitter tutorial on Viddler
  A way of introducing Twitter to someone else.
  (tags: Twitter tutorials InternetandTechnologyIntroduction)

The Most Change For The Most Kids

It is with some hesitation that I post this podcast. I am a teacher, and I will always be a teacher. However, I have been given the opportunity to do more. I have been recruited (although not formally given the position) for a Technology Integration Position in a nearby school district. This podcast is all about coming to terms with the idea of leaving the classroom so that I might create change and achieve School 2.0 in a larger way. At this point, I am very much interested in following my passion for finding solutions, and if this job provides solutions for more teachers and more students and also for my family, I don’t know that I can do anything other than pursue it. I am, however, still looking for others who have either made this transition or who have rejected it in favor of the classroom. Please e-mail me at benwilkoff@gmail.com if you have any questions or ideas.

Show Notes:

• 00:00:00: Intro to the Great Transition
  The Podcast Blog

• 00:00:58: Karl Fisch put me up to it.
  The Fischbowl

• 00:01:59: Why is the first wave leaving the classroom?
  Slow Motion Distributed Car Wreck

• 00:05:28: The Long Haul Teachers

  Cool Cat Teacher

• 00:07:15: What Should School 2.0 Leadership Look Like?
  Leadership Development for Educational Technology Leaders

• 00:09:27: What happens to the classroom I leave behind?
  My classroom Website

• 00:10:51: Other Factors
  My Daughter’s blog

• 00:11:55: The most change for the most kids
  My Blog