This has been pretty much a research week which hasn't felt really productive, although it has been time consuming. In my last post, I mentioned that I was going to be trying to create a pivot table for an excel spreadsheet. It turns out that this just isn't easy. I'm really having a hard time with this one. Sonny and I worked on it some as well, but it's not really something he's done either. He did show me how to include the totals in the spreadsheet to create the basic information needed though. Anyway, we've both been looking at this this week, so hopefully we'll be ready to actually do something with the spreadsheet next week. Andrew won't have the finalized spreadsheets with the data from the field offices until then anyone.
Anyway, in addition to this, I also found a chart and video to send to Sonny showing the differences between Windows XP and Windows 7.
Friday, October 28, 2011
Saturday, October 22, 2011
EDUC 6000 - Week 8
I met with Sonny this week to discuss the powerpoint presentation on Microsoft Office 2010. He likes the presentation, but he suggested some things be added. He liked the use of the picture at the beginning of the presentation as a hyperlink, so he wanted make other pictures throughout the presentation changed to hyperlinks to the online help. I also added shapes to those slides that included instructions on clicking on the picture to go to the website. He also suggested adding a video to the presentation that compared 2010 to 2007. I found a video at Microsoft's site that showed a side-by-side comparison, but I had a problem embedding it into the presentation. For some reason, the embed code provided just wouldn't work. Since that didn't work, I went to YouTube and found one that I really liked better than the one on Microsoft's site. It's about 6 minutes long and gives an overview of the differences between Microsoft Office 2010 and 2007 in each of their applications. I didn't have any problem embedding that video into the presentation using the Old Embed code. I think that may have been the problem with using the embed code on the other video. It was like it just wasn't recognized. Any suggestions on that is appreciated!
Anyway, I think I'm pretty much done with this, so I'm working on my next project which is create something showing the difference between Windows 7 and XP. I'm also researching the use of pivot tables, pivot charts, and slicers to use in a spreadsheet. This goes back to a spreadsheet that I worked on in Week 5, and Sonny wants to see if this would work instead of creating an Access database to work with the Excel spreadsheet. I think that's going to be a challenge!
Anyway, I think I'm pretty much done with this, so I'm working on my next project which is create something showing the difference between Windows 7 and XP. I'm also researching the use of pivot tables, pivot charts, and slicers to use in a spreadsheet. This goes back to a spreadsheet that I worked on in Week 5, and Sonny wants to see if this would work instead of creating an Access database to work with the Excel spreadsheet. I think that's going to be a challenge!
Tuesday, October 11, 2011
EDUC 6000 - Week 7
This is a continuation of last week's project. I'm still working on the powerpoint training for Microsoft Office 2010. When I started this, Sonny said he had done some work on the project before, but he couldn't find his work. So last week, I started a new powerpoint using hyperlinks and the screencapture function in Powerpoint as well as instructions to explain the illustrations. Since then, Sonny found his work. After reviewing what he had done, I integrated it into what I did last week and made some changes to make the presentation flow better. This took about three hours. I've sent it to him again to review. I'll let you know what he thinks when I find out.
Monday, October 3, 2011
EDUC 6000 - Week 6
I finally got to work on the training document for Microsoft Office 2010 this morning. Viewlet Builder turned out to be a bust. Neither Sonny nor I could get it to work. However, Sonny discovered that the 2010 version of Microsoft Office Powerpoint has a screenshot function. I used it to start a Powerpoint presentation on using both the regular help function and the interactive tutorial. I've been using the 2010 version personally for a while now and have found it to be somewhat difficult to navigate. What I found out this morning is that I should have used HELP! I'm going to be playing with this a lot more to discover all the bells and whistles in the tutorial. If I had used this before doing some past projects, I would have been a lot less frustrated! I've sent what I've done so far to Sonny to review. We'll discuss it next week and make any needed changes or additions.
Subscribe to:
Posts (Atom)