Learn what are the changes to the Office applications (Word, Excel, PowerPoint and Access). The agenda will include: What we know; What we don't know; Our plans; Our recommendations; Your Questions.
Presenter: Dianne Griffin, IR Training Coordinator

Office 2007 - Getting Up to Speed PowerPoint
PowerPoint 2007: Making the Switch PowerPoint
Excel 2007: Making the Switch PowerPoint
Word 2007: Making the Switch PowerPoint

How do I learn to use Office 2007? (Document of training resources)

Office Online Training with demonstrations

Interactive Locations of 2003 commands in 2007 - available for each application

List of 2003 commands with locations in 2007 (downloadable spreadsheet) - available for each application

PDF "add in" for Office 2007

Getting Started Tab for Office 2007 - "add in"

What's new in Access 2007?

Jeff Lewis, trainer from KU main campus came over to conduct these more advanced classes.
  Excel 2003: Data Management Learn to use Excel as a database. Topics covered are: Sorting a data list; Filtering a data list according to criteria; Extracting data list information;  Using the subtotal function; Adjusting the spreadsheet windows.  
Excel 2003: Functions and Data Analysis This workshop focuses on the functions and data analysis tools of Excel. Topics included are: Terms related to using functions; Creating and editing functions using the Insert Function Utility; Loadable Add-in modules; Data analysis with the Data Analysis Toolpak, including Histogram and conditional sum; Creating and modifying pivot tables; Formula troubleshooting.  
Excel 2003: Charting This workshop covers how to use Excel to create and edit charts, modify chart options, and format chart objects, as well as use trendlines, forecasts, and error bars to present data graphically.

This hands on training will introduce the features and basic commands of Excel 2003. Participants learn to: create and save workbooks; select, copy and move data; create formulas using relative and absolute references, format worksheets, and options for printing.

Jeff Lewis, trainer from KU main campus came over to teach these classes:
Access 2003: Queries The focus of this workshop is on extracting specific records using queries and creating and utilizing pivot tables/pivot charts for data analysis. Participants will learn how to: Create and run a select query to display data from one or more related tables; sort data in a query; add criteria to a query to display specific records and create pivot tables and charts using query data
Access 2003: Forms - Access Forms are an excellent way for users of a database to add or modify data. By using forms for data entry, a database designer can validate and control the data that enters a database as well as create an "easier" method of data input. Additionally, forms can be used as a navigation object, or Switchboard, to direct a database user to the different areas of a database, even if the user has never used Access. In this workshop, participants will learn how to: Create a form from a table or query using AutoForm Create a form from a table or query using the Form Wizard Create a form directly in the Design View Modify a form in Design View Add subforms for records in a form Sort and filter records in a form Format controls conditionally.
Access 2003: Reports - Access Reports allow you to analyze the data you have collected in your database using calculations, sorting and grouping techniques, and print them in an organized format. Understanding, creating, and enhancing reports is the primary goal of this workshop. Participants will discover a variety of ways to: Create a report from a table or query using AutoReport; Create a report from a tabel or query using the Report Wizard; Create and modif in the Design View using the tools from the Formatting and Toolbox toolbars; Add grouped sections and sort fields in reports; Create calculated controls in reports.

EndNote

Link to SecureFiles:
https://securefiles.kumc.edu

Use these resources to learn how to exchange data with others both internally and with external receipents more securely without impacting your email mailbox. Works great with very large documents and multiple documents sent as one package.

PowerPoint Level 1 introduces the basic commands and features of PowerPoint 2003. Creating a simple presentation, editing slides, organizing the slide show and inserting and manipulating graphics will be included in the training.

PowerPoint 2003 Level 2 - In this workshop, participants will explore some advanced features of PowerPoint, including: Action buttons, linking to web pages, files and other slides; using charts; transitions and animations to your PowerPoint presentation.

Do you have a wireless network at home or are you thinking about buying one?
How do you know which wireless network to buy?
Is your neighbor stealing your Internet access?
Should you be concerned about using free wireless at the local coffee shop or the airport?
An how do you access the wireless network that's available on KUMC's campus?

Join Information Security staff for detailed answers to these questions and more, including a live demonstration of common attacks against a wireless network.

Presenters: Sherry Callahan, Director of Information Security; Daniel VanMeter, System Security Specialist; Kyle Crane, Network Security Specialist; Dallas Ivanko, WAN Engineer

Out of Thin Air PowerPoint

Out of Thin Air Brochure

Out of Thin Air Video
 -- large view format
 -- small view format

If you are running an application built in Microsoft Access, there's beensome significant changes in the way the new version of Access 2007 works, Internet Development sponsored this presentation to update you on our research, experiences and plans regarding Access 2007. The agenda includes: What we know; What we don't know; Our plans; Our recommendations; Your questions.

Presenter: Fritz Achen, Project Manager, Internet Development

This presentation described current publishing models in the sciences and will focus on copyright issues and open access as they relate to authors, research funders, readers, libraries, publishers and other stakeholders. The discussion included: current copyright law, Open Access publishing, Creative Commons licenses and Science Commons for sharing science data.

Presenter: Crystal Cameron-Vedros, Head, Document Delivery & Copyright Compliance.

Images can make learning more engaging and support learners’ preferred style of learning. Multimedia (including images) can increase learner’s retention and recall of the topic. In this presentation we will discuss how graphics can support or depress learning. The discussion will include: •What are the communication and psychological functions of graphics? •How do we load images into our online instruction in Angel? •How do we find and use images using the KUMC provided databases? •What are the copyright issues? •How do we use images from text books? •If the images are used on the Internet what are the Accessibility issues?

Presenters: Jill Ducey, Teaching and Learning Technologies, Educational Technologist and Jason Stirnaman, Biomedical Librarian & Digital Projects Librarian.