Google Docs for iwu.edu

Illinois Wesleyan has never done much in the way of collaborating with documents. We’ve shared a few spreadsheets as multi-user, but other than that we only get calls to turn off that pesky “Track Changes” feature in Word. Not many people have made an effort to use collaborative tools on the web either. A few courses incorporated wiki usage last term but I don’t think anyone has proposed to continue this year. There is a lot of untapped potential here – document collaboration via e-mail is not very efficient.

If IWU goes the Google Apps route for e-mail, we’ll have another tool available – Google Docs. Last week we took a look at this suite-within-a-suite.

Google Docs has a file-manager frontend that looks good but was a bit buggy. One document would not open from this Docs start page, and had to be opened from the Personal Start Page or from a direct share link instead.

It was very easy to create documents and have lots of people working simultaneously. Google did a great job of auto-saving most changes. One tricky part was that you could easily wind up with multiple windows and tabs with old versions of the doc being displayed. It took a vigilant eye to keep up with the current active window or tab.  The Apps did a mroe than satisfactory job of keeping track of many revisions by many people. If two people edited the same cell of a spreadsheet within a few seconds, the second user to save would be notified as such, and given the opportunity to review the changes.

There are lots of features that MS Office has that are not touched here. Don’t try to use this suite for a mail merge – there is no feature that comes close. Don’t expect all the Word formatting options either. You might try importing a Word document into Docs to take advantage of both worlds. Two problems stand in your way. Google Docs doesn’t yet support Office 2007 file importing, and Google Apps for Edu imposes a file size limitation of 500k. Apparently there is not such a low ceiling for the public version of Google Docs. Perhaps this is something we could administer once the institution is on board.

Google Spreadsheets have lots of functions, but the interface for selecting them is not as nice as Excel. You get to see the function name but not a description of what it does. For that you must open a help window. On the other hand, there are some features that are quite novel. For example, you can create a spreadsheet and then share it to other users not as a spreadsheet but as a fillable form. The data is collected into the correct columns in the corresponding sheet. What a great solution to the sticky problem of duplicate data entry (currently we set up fillable PDF forms which are collected and re-entered manually)!

 

I had a bit of trouble with data entry in Google Sheets. In Excel, you can tab between columns to enter data across a row. When you reach the end of your row, if you hit enter you are taken back to the start of the next row. In Google Sheets, you are dropped into the last cell of the next row (immediately below the one you just filled). This leads me to believe that it would be easiest to compose sheets in Excel, then import them for collaboration.

Google Docs is pretty good at printing documents and sheets if you keep one rule in mind: use “Gprint, not browser print”. In other words, if you try using the print function of your browser it will come out wrong. Use the print function within the Google Docs application instead. There are a number of export options, too, including PDF.

My favorite function was actually in Google Presentations. There is an “Insert Movie” feature that allows you to embed a YouTube movie player right into your slide. This could help many faculty who are increasingly using YouTube clips in their lectures. They could have the clips correctly placed in context rather than having to switch around between apps. I am also considering using Presentations instead of Powerpoint – I wouldn’t need to worry about Powerpoint being installed, or about packing up all the neccessary files on a disc or flash drive. To me, Presentations looks like an upgrade in convenience.

I think it is safe to say that these tools are good in general, but very good for collaboration. Again, we had some concerns about the “beta” feel of this product.  In addition to some fit-and-finish concerns, there needs to be more consistency across the Docs suite user interface. For example, everywhere we looked in Google Apps we found the “save” button in a different location. This is certainly a usability problem.

I personally plan on using the Presentation software next week for some training sessions. I hope others on campus give this a try. Just a reminder, you can join in our Google Apps @ iwu.edu group by signing up here:

http://partnerpage.google.com/iwu.edu

 

Google Apps for education

It is hard to say no to a free lunch. It is even harder when the menu contains a half-dozen tasty morsels. Google Apps for education is similarly tantalizing. They provide a ton of e-mail space, document collaboration, chat, shared calendars, and more. As more and more institutions migrate to Google- and Microsoft-hosted services we thought it would be a good idea to learn a bit more about how the Apps for Edu offerings actually measure up.

To that end, a group of IT and Library staff got together in a room for 4 hours this week to sample and test the major features of the Google Apps suite. I’ll be writing up our findings and questions still in need of an answer in a series of blog posts starting with this one.

First, I’ll set a context. Google has tons of web applications that are available to the public. However, to use them as collaboration tools in a large organization there has to be a way to systematically create accounts and group people by default. I can’t imagine taking 4,000 people through the steps required to sign up for a Gmail account, set up Google Docs, then add everyone else on campus to their contact list in Google Talk.  So we assume that everyone is going to need a new account related to iwu.edu and that everyone will be grouped together to make collaboration easier.

Google doesn’t even really care if the institution has signed up for the service. Anyone with an iwu.edu e-mail address can go out today and create a free Google Apps @ iwu.edu account:

http://partnerpage.google.com/iwu.edu

Just choose the “sign in” link and then create a new account.  Once you’ve signed up for your iwu.edu Google Apps account, you can view a document I’ve shared with everyone in our iwu.edu workgroup:

Google Apps review document

 

This document summarizes the key items we discussed during our session. A few issues applied to the full suite:

  • It doesn’t feel like a cohesive suite of apps yet. The user interface in each app is slightly different. Saving your work in Google Docs is different than Google Sites.
  • The Personalized Start Page is nice, but there are add-ins available (for example, Google Reader) that are not accessible to Google Apps @ edu user accounts. It would be really nice if your start page would allow Gadgets to be logged in to different Google accounts at the same time, or if they’d open up their other apps to Google Apps @ edu accounts.
  • There is no Gmail available via the Google Apps @ edu service until the institution signs up and starts pointing our iwu.edu e-mail to Google servers.
  • Clicking links from the Start Page or within Apps too frequently opens in a new tab or window. This means it is way too easy to have a ton of confusing windows with older versions of your work hovering about.
  • It is unclear how deeply Google services can be integrated with our own MyIWU web portal. Can the nice little Google Gadgets from the Start Page become channels within MyIWU?  We cannot get rid of MyIWU since it is our portal to registration and course management.

More posts are on the way elaborating on our work with each individual app. In the meantime, I hope everyone with an iwu.edu e-mail signs up and gives it a try. Here is the link one more time:

http://partnerpage.google.com/iwu.edu

upcoming training session

Patrick and Rick are offering an “Update your Browser Skills” training session for Faculty and Staff:

  • Keep your Operating System, your e-mail applications and your browsers updated.
  • Learn the ins and outs of using browser tabs and toolbars
  • Google Toolbar for Firefox and Windows Live Toolbar for Internet Explorer
  • Experiment with the Google Search Features and Shortcuts

This session will be offered Thursday, June 26 from 10 a.m. to noon.

Please e-mail Patrick at pmclane@iwu.edu to reserve a seat!

Moodle plus portfolios?

The MoodleMan blog recently ran a post on the integration of a new third-party tool with Moodle. Be sure to check out the embedded video at the bottom. The tool in question is an e-portfolio tool called Mahara. We have a number of groups on campus who have various portfolio needs – Art, Career Center, Ed Studies, and probably more I don’t know about. These folks have different requirements but the core need is the same. They want to collect student work over a span of time, and allow that work to be stored and displayed. Some students may need to showcase their growth as a writer or artist over four years. Others may use this as a supplement to a resume. In short, Illinois Wesleyan could use a system like Mahara.

Why does Moodle have anything to do with it?  Well, if we began to use Moodle as the course management system for campus it would be very easy to take work already handed in via Moodle and drop it into a portfolio. Presumably the Moodle courses would be wiped clean each term, so this is a way of preserving select content over a longer span of time.

I’d like to give it a try, but I think we’ll have to wait until our Fall term Moodle test is complete before we can add in another component to the mix. Moodle 2.0 is supposed to have improved APIs that will make the Mahara integration tighter anyway.

Sketchcast – fun and useful drawing tool

I learned about sketchcast.com from the Chronicle of Higher Ed’s “Wired” blog. Apparently some teachers are using this tool to some effect in their courses. Here is the nickel tour:

You draw in a small window using a pen tool, text tool, and eraser tool. You can record your voice along with your drawing or sketch. Then you click “publish” and an animated movie of your drawing process is published. It is quite easy. You can then send the web address to anyone out there in the world.

This basically is like an online whiteboard. It takes a few minutes to get used to drawing with a mouse, but with a little practice it is quite easy!

Check out the sketchcast of my cool boat drawing!

Summit summary

So I didn’t actually post anything from the conference, but I did make some notes while I was attending the Sungard Summit. This is the annual convention put on by Sungard, the people who make our Portal software, the Banner software that underpins just about every administrative function at IWU, our Content Management system, and the Advance software we use in Development. 

The conference is a huge event with people from all walks of Higher Ed in attendance. I was in the “Technical Community” which meant I was walking and talking with webmasters, instructional designers, etc. I stuck almost entirely with the Luminis Content Management product throughout the conference since that is the product I most closely support here at work. Here are a couple of interesting things I heard about:

  •  modifying the Site Studio interface using Javascript or AJAX to make the user interface much looser for content contributors. This means that certain page elements could be moved around, or that some options could be hidden or revealed as needed. These enhancements added some layout and design freedom to users that we do not currently provide. They also can be one way to integrate LCMS with existing systems (a database to track keywords, or a photo gallery app).
  • fixing the LCMS workflow system using a little bit of Java code so that it doesn’t spam content managers with incomprehensible e-mail messages.
  • there is a very easy way to integrate iTunes U with our campus portal to provide single sign-on access to shared media on Apple’s servers

Of course each of these items requires some scripting or programming, but thankfully the people who gave these presentations were quite friendly and would be willing to offer advice or help if we follow in their footsteps. 

I also learned quite a bit about the new LCMS version 3.3 which is now available. The enhancements to navigation will be quite an improvement, and I hope to see improvement for our Mac clients as well.  

I am also interested in learning a little bit about the underlying LCMS technology to see if I can make the Role Management system do a little more. After talking to one of the LCMS programmers I think it might be pretty easy…we’ll see how easy! 

More Moodle

Last time I posted about Moodle I mentioned my plans to test a third-party quiz application, and to try out the “database” activity within my fake Moodle class. I did both of these things and will now provide a brief recap.

Hot Potatoes is a quiz application that is probably mostly used in elementary and secondary ed. It generates quizzes and exercises of different formats. I tried making a crossword about potatoes.

Spud Crossword

This worked out nicely after I figured out the right format to save the crossword. The Hot Potatoes app doesn’t automatically plug in to Moodle, so I had to export as a SCORM package (SCORM is a standard e-learning specification). From there it was easy to get it into Moodle. I need to add more words next time – people seemed to think it was too hard since there weren’t a lot of words crossing.

I also created a “Database” in my Moodle course. This is really just a customizeable construct for your class. I created fields like Title, Genre, Picture, Date, and Description. Then each student enrolled in the class could add a record comprising all or some of these fields. In other words, this tool could easily be used to hand in complex assignments. Databases also allow the class to post comments on each record. This means the Database can also function much like a blog.

So far everything about Moodle suggests that it will provide an excellent set of tools to our Faculty for managing their courses. We still need to make progress in integrating Moodle with our Banner database, especially in order to synchronize class rosters.

I’ll be gone next week at a conference learning more about Luminis Content Management. I’ll try to post some interesting tidbits about LCMS while I’m there.

iPhone Test Update

Traveling with the iPhoneThe iPhone came back around to me after being evaluated by a couple other IT staff members just in time for a little traveling.  The first thing I did in preparing for my travels with the iPhone was to download a couple TV shows and some music from iTunes.  Syncing the iPhone with iTunes is straight forward and works just like an iPod sync.  The iPhone has a setting called Airplane Mode that is turned on when stewardess asks that all electronic devices must be turned off.  The Airplane Mode turns off the phone and bluetooth, allowing the other iPhone functions to work normally.  Once in the air, I turned on the iPhone and enjoyed the shows and music I had downloaded.  I also used the camera function on the plane, taking several shots out of the window.  I actually used the camera throughout my travels, easily emailing pictures of the sun and sand back to cold and gloomy Illinois just to rub it in a little.  E-mailing a photo is very simple, you can also add a message along with the photo.  Using the iPhone for Internet access was great to check on flight schedules, the weather, etc.  I used the iPhone to keep up with my IWU e-mail while I was away, so I did not have to spend a day catching up when returning to work. Another feature that I use more and more, and used while traveling, is text messaging.  I find sending a text message with the full keyboard much easier than on a standard cell phone.  With the iPhone I can easily send text messages using correct spelling and full punctuation that is usually not done when texting on a standard cell phone.  (U no what i m talking about if u send texts 2 others)

Vacation So, the iPhone worked very well for me while traveling, and it allowed me to travel without the laptop computer I normally drag along. The iPhone provided me with all of the communication and computer functionality I needed.  With all of the positives, the iPhone does not yet work with the IWU wireless network. The other down side is that the iPhone is not supported by our shared calendaring system.  These are two significant support issues for campus use.  If you are currently looking for a wonderful and easy to used mobile device for your personal use, I can highly recommend the iPhone. Integration with campus services should improve as upgrades to both the iPhone and campus systems are rolled out.

a new way to edit photos online

I’ve used Picasa and Flickr, a pair of excellent web-based photo organizers. They give users a way to sort and share large numbers of digital pictures. One downside has been the ability to edit images. I tend to use Photoshop Elements to do the editing I need because the online tools don’t give me all the options I need.

Adobe has released a potential remedy to this problem: Photoshop Express. It is currently in beta form, which means it is still officially in “test” mode. Patrick and I took a look at this beta today and found it to be quite nice! You can preview the effect of a potential edit by hovering a mouse over a thumbnail. Cropping, distortion, filters, color sampling and replacement, redeye reduction, and lighting fixes are all included.

photoshop express screenshot

Adobe is currently giving users 2GB of space on their servers, and the best part of all: integrated access to Facebook, Picasa, and Photobucket. I was able to edit pictures and upload pictures directly to my Facebook profile with a minimum of fuss. I had to log into Facebook to tag them and correct the captions though.

A couple of downsides: there is currently no way to order prints online (I can only imagine this will come in time) and you are currently limited to JPG images of 10MB or less. Not a big limitation but a notable one.

I for one am totally thrilled with this application. It offers me the ability to do moderately sophisticated editing from anywhere, with direct access to web photo sites. I wonder how it will hold up with thousands of people creating accounts to try out this beta software…

Moodle for Fall?

So we are working on a plan to pilot-test Moodle in the upcoming Fall term. Patrick and I are trying to learn the software now so we can support a few faculty in trying it out. Then we’ll make a decision about whether we will make Moodle a supported service, perhaps even an opt-in alternative to the Luminis course tools we have now.

Today Patrick and I looked at the Assignment module. There are a few different options for teachers to select from. Students can type text directly online (called “Online Text”). This is very easy for students to use, and it allows a teacher to grade them directly online as well. There is another option called “Upload a Single File.” This is simply a hand-it-in tool. “Advanced Upload” allows students to hand in multiple files along with notes for the teacher. Here is a screenshot of a teacher grading a student’s submission and providing feedback. Notice that I have the option to turn the files back over to the student to redo (“Revert to draft”):

Grading an Advanced Upload

 Finally, “Offline Activity” is a tool for any assignment that needs a grade. That way you could assign a presentation, or give credit for going to a guest lecture and continue to use Moodle for grading.

A few notable details regarding these Assignment options:

  • The teacher can set start and end dates for submission, and disallow late submissions entirely
  • It is possible to allow resubmission – so draft papers can be handed in, responded to, then handed in again
  • Students can include web links in the notes on “Advanced Upload” assignments
  • Files don’t have to be Word – you can upload movies, audio, pictures, whatever – as long as it is not too big

We’ve tried this a few times along with a few quizzes. Moodle does a nice job of collecting everything into a central gradebook which can then be downloaded in Excel or Text format.

Next I’m going to play with a module called “Database” and try importing a quiz from third-party software called Hot Potatoes.