E-Learning
Making Microsoft Office Sing
Mar 12th
Are you one of the lucky ones tasked with training Microsoft Office products? Does the thought of doing so overwhelm you? Relax, there are a ton of resources available to help you put together a suite of training that will knock anyone’s socks off!
First, I know this is a bit late, but at MPOW a few of us are just now moving to Office2007. We are planning on moving the whole system to Office2010 eventually. For now, my challenge was helping the few of us moving to 2007 without launching an entire training program since everyone else is still using 2003. I was so happy to find the Guides to the Ribbon on Microsoft’s site.
The most challenging part of moving from Office2003 to Office2007 is the Ribbon. I’m still not thrilled with the thing, but I can see that if I were a brand new user who hasn’t been a slave to the Office Suite for more years than I care to count, it is probably a bit easier to learn. My brain to hand movements for making Office work are automatic after years of using and training on the software. I love the Interactive Guides that you can run right from the page or, even better, download to have with you at any time. I have the guides on my computer’s desktop so I can get to them quickly and I also carry them around on my thumb drive to use when helping people on location.
Here is a quick screencast of what the guides look like in action:
Now let’s look at all of the various resources out there that can help you put together that awesome training program for your staff or patrons.
The obvious place to start is Microsoft Office’s site itself. They have many free, self-paced online training courses. They’ve just launched an awesome tool called the Enterprise Learning Framework. This helps you to develop a training and communication plan during deployments of upgrades. You choose the topics you want people to learn and it will create a customized email with links to all of the online training available. Very cool! There are also free training presentations, and the Unlimited Potential Curriculum which is free for non commercial use in nonprofits. I still have more to explore in Microsoft’s resources. Check them out and please let us know in comments other tools you may have used from this rich collection.
Next stop is WebJunction’s Technology area. There are a wealth of resources there. When focusing on Office, be sure to see the Office Applications area. Don’t reinvent the wheel, there are many others who have already done this.
I also like the stuff put out by GCF Learn Free a part of the Goodwill Community Foundation, Inc. They have a YouTube channel that I subscribe to that puts out quick and easy tutorials on a variety of topics including Office.
Don’t forget a Google search on free microsoft office training!
If you’re willing to spend some money, there are many companies that have already done the hard work of creating the curriculums needed for Office training. Again, a Google search on microsoft office training curriculum will get you started.
Personally, I had to go the route of putting out some cash to save me the hours of time it would take to build my own curriculum. It would have been more expensive for my system to pay me to do that than it is for me to renew my license with CustomGuide every year. The price is very minimal for a non profit. Their courseware is totally customizable and includes online learning as well. They have pre-assessments and post assessments to help as well.
I hope you have fun building your own Office Training Program. It’s amazing how you can make someone’s day by showing them an easier and more efficient way to get the job done using Office.
Please let us know what you’ve done and share your links with us!
Transfer of Training in a 2.0 World
Mar 10th
If you follow ALA Learning, you’ve probably realized by now that I’m an e-learning addict. In my last post, Fighting for Attention, I shared some insight into how to add digital pizzazz to your e-learning efforts. Today I want to invite you to come and play inside my digital sandbox, and check out three intriguing tools I’ve been tinkering with to help with transferring knowledge from the classroom back to the work environment.
Twitter Gaming
I was a huge fan of Terminator and Terminator II: Judgment Day. Needless to say that was I stoked to learn that Sony would release another Terminator flick after the apocalyptic letdown that was Terminator III. Before the launch of Terminator Salvation, Sony cooked up Resistance 2018, an elaborate game using Twitter, in which members of the human resistance army were using Twitter to decode messages from Skynet. Players earned points by decoding the messages. As players earned points, they rose up the leader boards on the Resistance 2018 website and achieved higher rank in the army.
I’ve been experimenting with the setup of how to make a Terminator-esque Twitter game for my library. A spiel of this sort can be used as a follow up exercise for any class where you need to do a knowledge check. For example, I’ve created a basic reference e-learning module, and the “homework” portion of the class is a massive set of reference questions. While I believe in the value of having folks new to libraries demonstrate an understanding of reference resources, I heard seen in my evaluation surveys that new hires really dislike the chore answering the questions. For my next batch of new hires, I plan to use a Twitter game like Resistance 2018 in which I invite the new hires to use their Twitter accounts to answer reference questions sent by me. As in Resistance 2018, the person who answers a question the quickest with the correct answering (citing their source along the way) will receive the most points. I’ll set up a leader board on a private Sharepoint blog so the newbies can compete for bragging rights.
ExitReality
For years companies have valiantly attempted to transform casual web-browsing into an interactive 3D experience. Platforms like GoGoFrog and 3dxplorer can give you an overall feel for the web in three dimensions. Both sites have potential, but by and large, the result is a clunky 3D browser that subtracts – not add – value to your web surfing experience. ExitReality is one of those tools that I find absolutely useless when used as a method for web surfing; however, ExitReality serves as an outstanding three dimensional meeting platform.
ExitReality is a small plugin that, once downloaded onto a computer, turns any webpage into a 3D space based on a theme of your choosing. Turn a webpage into an apartment, dojo, movie theater, etc. The list goes on. Users can select from more than 100 available avatars and then begin chatting immediately – either with text or through VoIP, thanks to the dynamo that is Flash 10. Rooms vary in size, but most are large enough to comfortably handle a small group of 5-7 participants with plenty of space to move around.
Since the plugin automatically renders websites, you will find that pages that have many links on them are somewhat difficult to use in 3D. As a work around, I recommend designing your own simple webpage using Microsoft Word. Include a few links to material that supplement what was taught in class and then publish your site online using a free web hosting site, like X10 Hosting.
Consider using ExitReality as a live, real-time discussion forum for your learners to meet after class and discuss concepts or ask additional questions of instructors. The added layer of interactivity is nice, and the core functionality of multi-user chat with VoIP is well worth this 4.5mb download.
Bubblr is an easy to use, web-based program that allows users to create comic strips from Flickr photos. After a strip is published, it can be printed, shared by email, or embedded in a blog. I envision Bubblr as a tool to where you can invite learners to demonstrate comprehension of class concepts by synthesizing their knowledge through a comic strip. For instance, I’ll be conducting an orientation soon to provide new employees with an overview of the library. As a follow up exercise, the new employees will need to create a short comic strip that demonstrates that they understand how our branches are arranged. Here is a quick strip that I put together to showcase this neat tool.
What online tools are you using to maximize training transfer?
Fighting for Attention: Engaging E-Learning Hacks
Dec 21st
Designing e-learning is my creative passion. I get stoked at the prospect of authoring a course that is fun, engaging, and appealing to learners. As an erstwhile student and current professional, I’ve taken scores of self-paced e-learning courses over the years. I’m often astonished by how static and dull most of these presentations are. Granted, there are technical limitations (and in some cases, design standards) that dictate how much multimedia can be used in self-paced course modules. However, smart uses of multimedia in online courses can help capture attention, which is fundamental to facilitating the learning process. Below you’ll find some of my favorite hacks for adding pizzazz to online presentations. Be sure to adhere to the terms of service of each resource listed… and be a good librarian by respecting copyright.
Let’s Get Visual
If you are in need of fun photorealistic visuals, but you are not a Photoshop pro, check out 3dVia’s 3D Collage app. This neat Facebook application allows you to design hybrid 2D/3D images by using a photograph as a backdrop and importing 3D models into the scene. 3D Collage is fast, fun, and free. Simply upload your own 2D image into the program or snag one from Flickr, locate a 3D model from inside the app’s library, and then publish the output to your Facebook profile. Once the picture has been published, simply save a copy of it and paste it into your e-learning course. I’m currently working on a point-and-click adventure about customer experience, and I’ve used 3D Collage to develop all the in-game images.

Hit learners with a quick shot of fun and creativity by using any of these e-learning hacks.
Of course there are times when you may need to add video to your e-learning modules. Youtube is an excellent clearinghouse for finding video assets. Depending on your authoring tool, however, streaming videos can present a challenge. If you are using Adobe Captivate 4, there is an excellent Youtube widget that allows for streaming directly to your Captivate presentation. If you do not have Captivate 4, you can likely import the Youtube video as a Flash video file. To save Youtube video as FLV, simply go to KeepVid, enter the URL of the video you want snag, download the file, and then save it as an FLV. Voila! You should now be able to insert the Flash video into your presentation. This tip is useful for authoring tools like Articulate and the free online course builder, Udutu.
Another hack I commonly use is recording screencasts to demonstrate processes. Screencasts are digital recordings of computer screen output. You do not need anything expensive like the commercial version of Camtasia to record one. It’s possible to make a screencast directly from your browser by using Screencast-o-matic.com. Screencast-o-matic integrates with Youtube so that you have a place to host your screencasts for free, provided you have a Youtube account. After recording the screencast, simply upload it to YouTube from the Screencast-o-matic interface. You can link to the screencast, stream it during a course if you are using Captivate’s Youtube widget, or you can rip the FLV file using KeepVid.
It’s Not What You Say, but How You Say It
I prefer self-paced e-learning modules that have audio narration (with the option to mute in the event that the narrator is terrible!) When recording audio, course authors must be mindful of sound quality and audio level. A best practice that I recommend is to record the audio separately, using an editor like the freeware Audacity, and then optimize the audio before importing it into a course. This ensures that all slides have equal sound levels. You can also use Audacity for more creative purposes. Consider applying a voice filter to the narration of an objective slide for a change in pace. If you are using characters or agents in your e-learning, you can also apply filters to their voices for a bit of variety. Here are my three favorite custom filters for Audacity and directions for creating each.
Robot Voice Filter:
1. Record voice
2. Highlight selection
3. Go to Effect, then scroll down to Delay
4. Change the Decay amount 10
5. Change the Delay time to .009
6. Change the Number of Echoes to 30, then click OK
7. Go back to Effect, and repeat Delay four times.
8. Play your edited track
Chipmunk filter:
1. Record voice
2. Highlight selection
3. Go to Effect, then select Change Pitch
4. Modify the Percent Change to 117.50
5. Play your edited track
Walkie-Talkie Filter:
1. Record voice
2. Highlight selection
3. Go to Effect, then FFT Filter
4. Click on purple line and drag it up to the top (12db)
5. Click 10000Hz
6. Click OK
7. Click Effect, then High Pass Filter
8. Change Cutoff Frequency to 2000, then click OK
9. Repeat this process 2 times
10. Play your edited track
Have fun using these hacks, but resist the urge of inserting too many. There is no substitute to sound instructional design.
The Library Trainer as Constructivist eLearner
Nov 27th
Like many others I’m learning how to do most of my job on the fly. Because the precepts of my own learning require me to share, I thought I’d air my own personal learning adventures in case there are others in the same situation. Learning Just In Time, I’m grappling Andragogy (Adult Learning theory) and Instructional Design theory so that I can effectively build professional learning plans in a Learning Management System for HMCPL staff.
After my recommendation, we have a brand new installation of Moodle, the leading open source LMS application in the educational community, as the basis for what will be a series of competency-based learning plans for staff. While it’s still in the ITS testing phase, I’m trying to get in the right frame of mind before I begin. Of the three learning theories (Behaviorism, Cognitivism, and Constructivism) Moodle’s philosophy is guided by a “social constructionist pedagogy” which might be perfectly suited for library staff learning. The concept behind PLCMC’s “23 Things” seems to be an excellent example of Constructivism, in that by reflecting on our experiences, we construct our own understanding of the world we live in.
While there are There are Model-Based Usability Heuristics for Constructivist e-Learning, I do plan on submitting a budget request so that I may participate in a Moodle-based class titled “Implementing Online Teaching and Learning: Using Moodle and Other Web 2.0 Features” by Diane K. Kovaks. Until then, I’ve come up with a syllabus of my own: I’m subscribed to eLearning Learning Community’s feed for Instructional Design to keep up with the latest posts on the subject and I’m absorbing well. I’m following Thursday evenings’ #lrnchat on Twitter. Though still at the legitimate peripheral participation (lurking) stage, I spoke up just this week and was rewarded with good conversation about learning. Moodle tutorials (2 Minute Moodles) are to familiarize myself with the Moodle interface, while Martin Ryder of the University of Colorado at Denver School of Education has compiled an exhaustive list of Instructional Design Models and I’m working through those.
Interesting that Catherine Lombardozzi is studying the Constructivist theory within the ADDIE Instructional Design Model to develop a Learning Environment Design model. A more common, systematic approach to eLearning, the ADDIE model get’s it’s name from the following five components: Analysis, Design, Development, Implementation and Evaluation. Raleigh Way of Georgia Southern University’s Center for Online Learning says that ADDIE is a “strategic planning of a course. It is a blueprint that you design and follow. It helps us connect all the dots to form a clear picture of teaching and learning events” and has an excellent set of tutorials here.
Thought recently maligned, I appreciate the systemic manner and fluid hierarchy of ADDIE, and the more I study it more I feel this approach can be given to almost any talk, course or series of learning opportunities.
In TechSoup’s recent webinar Tech Training Made Simple with Online Videos with Lee Lefever (creator of those fabulous CommonCraft videos) I asked Lee if he had any tips for library trainers on teaching technology. His reply was to tell a story with a sympathetic character, then solve that character’s problem. A dominating thread in his videos, we all relate to his characters and scenarios. While there is debate among professional Instructional Designers about the lack of ID theory in CommonCraft videos, there is no doubt as to their effectiveness on the adult learner. I know I’m just at the beginning of my learning journey here and that there are many experts to learn from. but this is the level of ‘explainability’ that I hope to achieve in our staff learning plans.
Do you have recommendations for creating courseware which inspires learning at the CommonCraft level? If so, please share. If it can’t be done, then why?
Curiosity Rules!
Sep 17th
I am fascinated by brain science, or I could say my brain is fascinated. There is a heightened and growing knowledge of how that astounding organism really works. As I’m reading John Medina’s Brain Rules (the book, which goes much deeper than the website), I keep thinking of the recent study released by the Department of Education, which compares the effectiveness of face-to-face, online, and blended learning delivery. The meta-analysis of over 1000 studies conducted between 1996 and 2008 seems to provide a solid basis for the conclusion that online instruction is “more effective in improving student achievement than the purely face to face instruction.” I wasn’t all that surprised by the findings, but I wonder if the basic comparison is all that meaningful. Is it the online versus face-to-face dichotomy that is the important distinction? Or is it innovative versus traditional approaches that make a difference in a person’s learning?
There is often an underlying presumption that the traditional, on-ground classroom offers a quality instructional experience. I can attest that I have had very inferior f2f classes and I’m sure I’m not alone. Even with a good instructor, there are serious limitations to traditional teaching methods. When I returned to graduate school in mid-life, I was dismayed to realize what a struggle it is for my brain to absorb auditory information delivered in a 1-2 hour lecture format. Having read Dr. Mel Levine’s A Mind at a Time just before entering grad school, I grasped that I wasn’t stupid—it’s just that my learning strengths did not mesh with this age-old form of teaching. Levine identifies eight key neuro-developmental systems of the brain, illustrated here. Individual variation in the strength of these systems is huge; a math “genius” may be strong in sequential ordering yet dismal in social thinking; a socially gregarious person may be strong in language but weak in higher thinking. Our traditional educational system emphasizes attention controls and higher thinking and undervalues social thinking and spatial controls. As Medina says, “our schools are designed so that most real learning has to occur at home.” Levine’s work has generated a non-profit organization that seeks to deliver knowledge to All Kinds of Minds.
In the Online Learning Study, the front-runner was actually the blend of face-to-face and online. I would guess that the blended approach provides the greatest variety of learning options, allowing learners to engage their strongest neuro-developmental systems. And perhaps purely online delivery won out over f2f because instructional designers are trying harder to be innovative and deploying more tools to address different learning styles. I’m not comfortable with Secretary of Education Anne Duncan’s summary of the report that we need to “incorporate digital content into everyday classes.” It’s not the digital component alone that provides the learning magic. There are many teachers in on-ground classrooms who are experimenting with new strategies to engage students in-person.
Medina sums up his book with this declaration:
“The greatest Brain Rule of all is something I cannot prove or characterize, but I believe in it with all my heart ….it is the importance of curiosity.”
We need to be designing learning to stimulate and satisfy curiosity. Whether that is accomplished online or in-person is secondary to the essential Brain Rule.






Recent Comments