Solved

Office 2007 Training with tracking

Posted on 2008-10-22
3
376 Views
Last Modified: 2012-05-05
Hey all,

We are looking to upgrade to office 2007 from 2003.  I am looking for a training interactive site that will

1) Keep the training to at or just under 1 hour - the end users simply do not have the time and patience to do more than this.

2)Touches mainly on what is different between 2003 and 2007

3)Allows me to track who has completed the training

and the big one...

4)Will not cost a Whole Lota Money!

Thanks in advance for looking
0
Comment
Question by:geekhelp4u
  • 2
3 Comments
 
LVL 23

Expert Comment

by:redrumkev
Comment Utility
geekhelp4u,

How are you doing?

I would actually do this on the REAL CHEAP (that is, the free way)! Microsoft has some great help for just this situation, see the following:

http://office.microsoft.com/en-us/word/HA100484691033.aspx?pid=CH101030941033
http://office.microsoft.com/en-us/help/HA100742241033.aspx?pid=CL100605171033
http://office.microsoft.com/en-us/training/HA102155661033.aspx

The above are specific to Word for the most part (I am not sure what your users actually use in their daily work). So for most people, a brief intro to both Word and Excel is what is needed and these are provided for free. What I have done in the past is create a cheat sheet or two that has links to all the topics that your users might need, then I make that into a PDF file. This way, they can go back to it if needed at a later date and also they can use it to work at their own pace. Once they get use to the new location of items on the ribbon, using the 2007 suite is actually easier than 2003!

Here is something to think about. Say there are 10 major instructional video's and text walk throughs you find in the links above that are needed and say you have 10 employees. I can bet that at most, 1 of these people will need to see all of the 10 video's, where most will only need to see 3-4, because they don't do the other things.

So you can build a quick matrix, of A-J (10 videos) and users 1-10, then assign as needed:
1 - A,B,C,E
2 - B,C,D,G
3 - A,B,D,F
and so on.

Go to this page (and use the screen shot below to see what areas I have pointed out): http://office.microsoft.com/en-us/help/FX100485361033.aspx?pid=CL100605171033

These are were you can find "exactly what your users need", general office tutorials are nice, but since you have time limited users, I think it is better to get the training they specifically need, rather than waste time on "general overviews".

Good luck and hope this helps!
Kevin

Office-Help---How-To.jpg
0
 
LVL 1

Author Comment

by:geekhelp4u
Comment Utility
That was my initial plan, however we are talking about a thousand employees not 10.  We need a way to track who has taken the course before we deploy office 2007 to their machine.  We do not want them simply saying "yea i did it, i need the newer office please" and then calling us 3 times a day because they can't find the option to like it used to be.

Thanks for answering though, more than anyone else did!  If I get no more responses, I will assign the points to you - and if I do get a better one, I will throw you some partial points.
0
 
LVL 23

Accepted Solution

by:
redrumkev earned 125 total points
Comment Utility
Geekhelp4u,

First of all, I did not know the number of employees, a thousand (WOW I FEEL FOR YOU)! Actually, I would contact MS directly and ask them to provide something for you, since you are going to be purchasing so many licenses (if you haven't done so already).

At this scale for your project, I would look at something like Sharepoint and the auditing features that it has. What I am suggesting here is that you could take those files (download and save the ones you want to show people, even using the A,B,C,D,E... etc plan, whatever you select from above your own ideas) and put them on the server. Then follow some of these links and their ideas (I am just getting into sharepoint, so you would want to ask some questions in the MOSS or sharepoint forums, as I can't help you much there, but I know a bunch of experts over there are GREAT!).

Basically you can log that the people accessed the files and I am sure you can even see if they watched the entire video (or tell them you can see that they went through it at regular speed from beginning to end and that no other windows were above it, so they don't open it, play it and put it in the back ground, etc.) Most users will "believe" you have these god like abilities, even if you don't, plus you get the log of yes, user 1, did watch A,B,C and E, etc.

See these links for some ideas:
http://admincompanion.mindsharp.com/BillBlog/Lists/Posts/Post.aspx?List=2d22afa2%2D592b%2D471a%2D9cd1%2D4e8de8a2abc0&ID=18
http://www.sterling-consulting.com/Downloads/TheDefinitiveGuideToSPSLogging.pdf

I think you can get sharepoint for free (I know there is a free 90-day trial, which might be long enough to get this project completed), all you need is some server space and your good!

Another thing that might be a bit "crazy" but could really do some good, specific to your organization is to get a copy of camtasia (http://www.techsmith.com/camtasia.asp) and record your own videos. These work right off your desktop, so in a loss-less compression format, users see exactly what you do. Perhaps individual departments could create their own video's to show only what users need to know. Plus, as new issues come up (or even new solutions) you can add videos to the library. When new employees are hired, they can watch the videos and get up to speed quickly and current employees can go back to the video at anytime (intranet, sharepoint server, etc) if they need a refresher for something they don't do all the time.

Recently my company started outlook web access and screenshots with text to explain how to configure IE5, 6 and 7, plus basic how-to's ended up with a 15-20 page word document. The video can show people the same stuff in a few minutes and they can even watch it on one monitor while doing it on the other (we have dual monitors for all employees). Just some things to think about, and camtasia is only $300.00 USD.

Hope this helps and thank you for the comments above!
Kevin
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

This article will show you how to use shortcut menus in the Access run-time environment.
Outlook Free & Paid Tools
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …
XMind Plus helps organize all details/aspects of any project from large to small in an orderly and concise manner. If you are working on a complex project, use this micro tutorial to show you how to make a basic flow chart. The software is free when…

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now