I wanted to share some excellent tools that I’ve recently learned about. One is a free statistical analysis add-in program for Excel. Greg McFadden from Internal Medicine shared his knowledge with us in a mini-session a couple of weeks ago. To use this add-in:
- Select Excel Options (available from the Office button in Excel 2007 or File menu in Excel 2010).
- Click Add-ins and select Go (toward bottom of add-ins window)
- Place a check on the Analysis ToolPak and click OK. You may get a prompt asking to install it, and you may need the installation disk (although I didn’t with Excel 2010).
- After it has been installed, the analysis features are available on the far right of the Data tab. Some of the analysis tools available are: anova, correlation, covariance, descriptive stats (wonderful), F-test, histogram, fourier analysis, regression and more.
This site recently came to my attention from Teri Hartman, from McGoogan Library. Here you will find described a number of on-line programs that can be used to create charts and graphs of all types, including drawing tools, mind mapping, flow charts, organizational charts, iPhone chart application and more! I haven’t tried any of them yet, but I can’t wait to try out the mind mapping tools!
Thanks Greg and Teri for sharing your great finds!
Question: I just changed departments and will be working on a Mac. It’s brand new and is supposed to be set up this Tuesday. I haven’t used one regularly for a very long time. Do you have any training available for the basics and/or advanced Mac info?
Answer: We don’t offer hands-on training on Macs since we don’t have Macs in our training room, however there are several self-study resources available:
Question: I don’t have time during the semester to attend 3 hr classes. Do you ever offer short sessions at the end of the semester?
Answer: We certainly do! In fact this May we are offering a marathon of 30-minute mini-sessions on a variety of topics. They will be 30 minute sessions followed with Questions and Answers. You can bring in questions unrelated to the topic too, if time allows. We are offering these sessions so that faculty and students, in particular, can enhance their basic PC skills. See the schedule and register online at this link. In addition, we’ll show how to access additional resources for those who want more in depth training and assistance.
Many of these sessions are scheduled throughout the year, but we’re trying this min-marathon this semester and depending on how it goes, will offer at the end of the fall semester.
Question: Do you ever provide training for Mac Office users?
Answer: Unfortunately, we seldom offer classes for Mac users, primarily because we do not have Macs in our training room. We will consider offering some future demonstration sessions for Mac users, however. In the meantime, check out this Microsoft website for Mac Office 2008 resources http://www.microsoft.com/mac/products/Office2008/default.mspx . It is a great “secret.” We also have staff at our Helpdesk 559-7700 or email@example.com who have access to a Mac and are eager to help you.
Question: Do you have classes that are geared toward researchers? We have very specific needs for grant submission and data collection, etc and would like to get more assistance on this.
Answer: Even though we teach several classes which can assist researchers in their computer needs, none have really been targeted to researchers, so we are establishing a new “IT for Researchers User Group” which will address researcher’s needs. Apparently there is great interest in this, as our first meeting is scheduled for 3/24/09 from 2-3:30 in Eppley Science Auditorium room 3010, and we have had an overwhelming response. (We even had to find a larger room). The first few minutes of the meeting will discuss the goals of the group and then spend the remainder of the time discussing converting documents to PDFs for grant submission. Several research support staff will share their “tricks of the trade” and how they are able to successfully submit grants. We anticipate that the Group will have two tiers of members – students/researchers and research administrative support staff. Other topics to be addressed will be illustrations and graphics, data collection, scientific posters, presentations, etc.
Question: I haven’t seen your Bits, Byte and Bells class schedule for January/February? Where can I find it?
Answer: The reason why our schedule isn’t available is because the Campus Training Center building is slated to be demolished in early 2009 and the training room has been moved to the 8th floor of the UNMC Library, room 8011, which was previously the Library Computing Cluster. The Cluster has moved to room 8012. While equipment is being relocated and set up, classes are on hold. However, training presentations in departments can be scheduled through Kim Laursen at 559-5674. The new schedule should be available in early to mid-January at http://info.unmc.edu/helpdesk/16.htm