Browsing articles tagged with " reference"

A wiki spreadsheet.

Jan 4, 2009   //   by Ben Wilkoff   //   Uncategorized  //  No Comments

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

Share

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

Nov 12, 2008   //   by Ben Wilkoff   //   Uncategorized  //  3 Comments

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:

If you are also looking to sync your contacts, you can simply use your Blackberry or iPod touch to talk to Funambol using their built in programs (search for funambol in the App store, or use the above link to download the blackberry funambol application).

Then you can sync your contacts with the funambol server.

As for your Mac, you can use the Preference Pane sync.

This will let you put your contacts on your mac, on the funambol server, or on your blackberry and they will all sync.

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.

Share

The Ripe Environment: Backchannels exist.

Jun 26, 2008   //   by Ben Wilkoff   //   Uncategorized  //  No Comments

Whether we provide students or teachers with a backchannel, one will form. So long as there is more than one voice in a learning environment, the need to be heard will be undeniable.

Students may pass notes or they may text message in their pockets.

Teachers may point to a highlighted passage or simply make a face of disgust.

These things are not meant to stay in the background. They are essential, and as such, must be elevated to their rightful place in the classroom. The backchannel must influence the front-channel and must become the front-channel if the discussion and learning going on there is more important.

But, before I get too ahead of myself, let me set my definition of a backchannel:

A backchannel is the running commentary (critiques on, questions about, distractions from, references for, resources under) the dominant information stream. This dominant stream could be a lecture, discussion, video, or any other attention getting activity that would normally occupy the majority of the learners.

This may sound like quite a distraction. Why should we bring the note passers into the discussion? Why should we encourage distraction? Because it is how we learn.

Kelly Christopherson does a really great job of highlighting how a backchannel actually functions in a Ripe Environment, but I think the hardest thing to understand about a backchannel is balencing the two things that inherently have to go on within an classroom, but are not always so center stage. He says it this way:

Watching the crowd made me realize that we have a long way to go as educators. Many people in the room seemed to be having difficulty with the two things going on at once. Maybe that is why so many educators become frustrated with the use of cellphones or laptops in their classes; they don’t see how the two things can be going on at once.

The rapid fire writing down of resources, texts, or quotations is all well and good during a class or PD session, but what about questioning those things. When does that happen? If all learning is conversational and requires relationships, when are those relationships born and when do those conversations occur? They occur during the backchannel, if and only if one is set up and is relevant to those in the audience.

The experience that Kelly describes above is one that happens far too often. Those who do not find the backchannel relevant write it off as distracting, or worse, destructive. They want the front-channel to be the only channel, even though their brains and pens are commenting non-stopped on what is being said. We need to teach the value of commentary, fact-checking and questioning. We need to construct The Ripe Environment for the backchannel.

Share

The 1.0 to 2.0 Transformation

Jun 20, 2007   //   by Ben Wilkoff   //   Uncategorized  //  No Comments

itunes pic
Well, there are two main elements to this podcast.

1. This is my first blog post/podcast about being named the 2006 Totally Wired Teacher by Edutopia and Yahoo Teachers. I am honored, but I hope that the one thing that comes out of flying to San Fransisco is that I meet as many would-be advocates for School 2.0 as I can. I really would love to be a larger instrument for change than merely by blogging and podcasting.
2. I am challenging everyone to come up with a description for Teacher/Classroom 1.0, 1.1, 1.2, 1.3, 1.4, 1.5, 1.6, 1.7, 1.8, 1.9, and 2.0. I would really like to know what it should look like at all of these levels. What should we be striving for in our classrooms? What should a stranger be able to come in and observe?

Show Notes:

Share