Technology Topics for Customized Classes

KU Libraries Instructional Services trainers can provide training on a wide range of technology topics, including those listed below. Select from the list to begin designing your customized training session. You may select an individual topic or a combination of topics -- and if you'd like coverage of topics that you don't see listed here, ask! We may be able to accommodate.

You can filter the list by selecting filtering options from the menus to the right and clicking the Filter button.

Times listed reflect the approximate time required for adequate coverage of a topic, to assist you in designing a training session appropriate for the amount of time you want to allocate. Times are estimates only, as actual time spent varies with classroom dynamics, and do not include question and answer time. We recommend that you reserve some time for questions and answers.

Filter topic list:

When you've decided what topics you want included in your custom training session, use the Customized Class request form to request a session, or contact a trainer at training@ku.edu or 785.864.0410 to discuss your selections and make arrangements for the training to take place.

Topic	Categories	Approximate Time
Access: Database objects	Office Productivity Data Analysis and Statistics	1 hour
Access: Forms	Office Productivity Data Analysis and Statistics	1 hour
Access: Macros	Office Productivity Data Analysis and Statistics	1 hour
Access: Queries with criteria	Office Productivity Data Analysis and Statistics	45 minutes
Access: Query By Example grid	Office Productivity Data Analysis and Statistics	30 minutes
Access: Relationships	Office Productivity Data Analysis and Statistics	45 minutes
Access: Reports	Office Productivity Data Analysis and Statistics	1 hour
Access: Tables, filtering, sorting	Office Productivity Data Analysis and Statistics	30 minutes
ArcGIS: Bringing External Data into a GIS Map your data; visualize tabular or statistical data based on geography. Learn how to format and import data into a GIS, or how to 'join' tables to spatial data.	Data Analysis and Statistics	1 hour
ArcGIS: Converting Among GIS File Formats Use ArcToolbox and other methods to convert among various spatial data formats, including Arc Interchange (.e00), coverages, CAD, DEM, grid, shapefiles and more.	Data Analysis and Statistics	1 hour
ArcGIS: Creating and Editing Data Learn how to create and edit data, about basic digitizing and how to draw features such as points, lines and polygons.	Data Analysis and Statistics	1 hour
ArcGIS: Defining and Changing Projections Learn the basics of working with geographic projections, coordinate systems and spatial data. Learn how to set temporary projections in the data (mapping) window and permanently change projections of data layers.	Data Analysis and Statistics	1 hour
ArcGIS: Finding GIS Data on the Web Learn about some of the major online sources of spatial data.	Data Analysis and Statistics	1 hour
ArcGIS: Finding and Loading Extensions Learn how to find specialized tools on the web that enhance your GIS software capabilities. These tools, or extensions, provide customized functions for particular tasks or disciplines.	Data Analysis and Statistics	1 hour
ArcGIS: Formatting Data for Presentation Make a basic map using the Layout feature and elements such as legend, scale, etc. Format data for digital or print output; export map/ data as images to use in other programs.	Data Analysis and Statistics	1 hour
ArcGIS: Geocoding Learn how to write and use your own geocoding service to turn a text file containing addresses into a shapefile	Data Analysis and Statistics	1 hour
ArcGIS: Importing XY Data into a GIS Turn XY coordinates to points in geographic space. Learn associated tasks such as converting latitude/ longitude coordinates to decimal degrees format.	Data Analysis and Statistics	1 hour
ArcGIS: Moving from ArcView 3.x to ArcGIS Learn about the primary differences (tools, interface, etc.) between ArcView and ArcGIS. Find out about resources and tips for moving your data and projects to ArcGIS.	Data Analysis and Statistics	1 hour
ArcGIS: TIGER Boundaries Learn where to find and how to use the U.S. Census Bureau's Topologically Integrated Geographic Encoding and Referencing (TIGER) boundary files.	Data Analysis and Statistics	1 hour
ArcView: Bringing External Data into a GIS Map your data; visualize tabular or statistical data based on geography. Learn how to format and import data into a GIS, or how to 'join' tables to spatial data.	Data Analysis and Statistics	1 hour
ArcView: Creating and Editing Data Learn how to create and edit data, about basic digitizing and how to draw features such as points, lines and polygons.	Data Analysis and Statistics	1 hour
ArcView: Defining and Changing Projections Learn the basics of working with geographic projections, coordinate systems and spatial data. Learn how to set temporary projections in the data (mapping) window and permanently change projections of data layers.	Data Analysis and Statistics	1 hour
ArcView: Finding GIS Data on the Web Learn about some of the major online sources of spatial data.	Data Analysis and Statistics	1 hour
ArcView: Finding and Loading Extensions Learn how to find specialized tools on the web that enhance your GIS software capabilities. These tools, or extensions, provide customized functions for particular tasks or disciplines.	Data Analysis and Statistics	1 hour
ArcView: Formatting Data for Presentation Make a basic map using the Layout feature and elements such as legend, scale, etc. Format data for digital or print output; export map/ data as images to use in other programs.	Data Analysis and Statistics	1 hour
Census: U.S. Census Bureau Programs and Data The Census Bureau offers more than just decennial data! Learn more about Census programs, data releases, and where and how to extract the data you need.	Data Analysis and Statistics	1 hour
Databases: Database design	Office Productivity Data Analysis and Statistics	1 hour
Databases: Database overview	Office Productivity Data Analysis and Statistics	40 minutes
Databases: Perl DBI	Web Authoring Data Analysis and Statistics	1 hour, 45 minutes
Databases: mSQL commands	Web Authoring Office Productivity Data Analysis and Statistics	1 hour, 15 minutes
Dreamweaver: Basic HTML heading, paragraphs, lists, inserting images	Web Authoring	1 hour
Dreamweaver: CSS	Web Authoring	3 hours
Dreamweaver: Library items and templates	Web Authoring Graphics	1 hour, 30 minutes
Dreamweaver: Setting up a site and publishing (Get/Put)	Web Authoring	1 hour
Dreamweaver: Tables and table layouts	Web Authoring	1 hour
EndNote: Cite while you write citing references in Word	Office Productivity Research and Libraries	1 hour
EndNote: Connecting and importing references from bibliographic databases	Office Productivity Research and Libraries	1 hour
EndNote: Exporting formatted bibliographies, searching/sorting/working with references	Office Productivity Research and Libraries	1 hour
EndNote: Keeping current: downloading and using new EndNote import filters, connection files, and styles	Office Productivity Research and Libraries	1 hour
EndNote: Overview: demo of what EndNote can do, the basics	Office Productivity Research and Libraries	1 hour
Excel: Add-ins: Histogram and Conditional Sum loading and unloading add-ins; organizing data for, creating, and modifying histograms; conditional sum wizard	Office Productivity Data Analysis and Statistics	45 minutes
Excel: Basic formulae and data entry and manipulation pointer appearances; number, date/time, text, and formula data types; arithmetic, logical, and text operators; formulae with constants, cell references, range names, functions; formula creation manually, using Insert Function, and using auto-sum; formula edition and deletion; relative vs. absolute references; auto-fill; copying formulae and values	Office Productivity Data Analysis and Statistics	1 hour, 30 minutes
Excel: Charting	Graphics Office Productivity Data Analysis and Statistics	2 hours
Excel: Database format and data forms terminology; structure of a database/list; creating and structuring a database/list; naming, renaming, and un-naming a database/list range; adding and deleting records using data forms; searching for records using forms criteria	Office Productivity Data Analysis and Statistics	1 hour, 15 minutes
Excel: Filtering concepts and uses of filtering; auto-filter; special auto-filters; advanced filter concepts; criteria using logical operators; arbitrarily complex criteria via Boolean combination of individual criteria; filter execution; splitting windows	Office Productivity Data Analysis and Statistics	1 hour, 15 minutes
Excel: Insert function utility and useful functions review of formula syntax; the insert function utility; built-in function categories; common functions: [d]count[a \| if \| blank], concatenate, vlookup, hlookup, if, iserror	Office Productivity Data Analysis and Statistics	45 minutes
Excel: Pivot tables and array formulae pivot table concepts and uses; organizing data for, creating, laying out, and editing a pivot table; pivot table toolbar; array formula concepts, uses, and syntax	Office Productivity Data Analysis and Statistics	1 hour, 30 minutes
Excel: Sorting and subtotals simple sort; multi-column sort; first-key sort order; concepts of and data organization for subtotals; creating and removing subtotals; nested subtotals; multiple summary functions; subtotal outlines	Office Productivity Data Analysis and Statistics	1 hour, 15 minutes
Excel: Workbook and worksheet manipulation and formatting opening, closing, and saving workbooks; renaming, adding, deleting, copying, and moving worksheets; inserting and deleting cells, rows, and columns; selecting, deselecting, and moving cells, rows, and columns; formatting cells; formatting toolbar; auto-format	Office Productivity Data Analysis and Statistics	1 hour, 30 minutes
Flash: Introduction	Web Authoring Graphics Multimedia	3 hours
Graphics: Color	Graphics	30 minutes
Graphics: File formats	Web Authoring Graphics	45 minutes
Graphics: Resolution	Graphics	45 minutes
InDesign: Document setup	Graphics Office Productivity	15 minutes
InDesign: Multi-page documents (newsletters, books, etc.)	Graphics Office Productivity	30 minutes
InDesign: Paragraph styles, tabs, and other text formatting	Graphics Office Productivity	30 minutes
InDesign: Placing and manipulating graphics	Graphics Office Productivity	45 minutes
InDesign: Placing and manipulating text	Graphics Office Productivity	45 minutes
InDesign: Preparing a publication for print (build a booklet, preflight, export to PDF)	Graphics Office Productivity	45 minutes
InDesign: Single-page documents (posters, fliers, postcards)	Graphics Office Productivity	30 minutes
InDesign: Working with color (RGB, CMYK, Pantone)	Graphics Office Productivity	30 minutes
ListProc: Commands	Internet and Email	1 hour
ListProc: List configuration	Internet and Email	1 hour
ListProc: Overview	Internet and Email	20 minutes
ListProc: Owner responsibilities	Internet and Email	30 minutes
Mac OS X: Getting help	Computing Basics	10 minutes
Mac OS X: System configuration	Computing Basics	10 minutes
Mac OS X: User interface overview	Computing Basics	30 minutes
Mac OS X: Windows	Computing Basics	30 minutes
Mac OS X: Working with applications	Computing Basics	10 minutes
Mac OS X: Working with files	Computing Basics	30 minutes
Outlook: Archiving and personal folders	Internet and Email Office Productivity	1 hour
Outlook: Calendaring setting single and/or recurring appointments and meetings	Internet and Email Office Productivity	1 hour
Outlook: Contacts and distribution lists personal distribution lists and Exchange distribution lists	Internet and Email Office Productivity	15 minutes
Outlook: Email management sending/receiving, deleting, flags, signatures, address book	Internet and Email Office Productivity	1 hour
Outlook: Folder management	Internet and Email Office Productivity	10 minutes
Outlook: Granting permissions	Internet and Email Office Productivity	1 hour
Outlook: Public folders	Internet and Email Office Productivity	30 minutes
Outlook: Rules rules, out of office assistant	Internet and Email Office Productivity	20 minutes
Outlook: Tasks and Notes	Internet and Email Office Productivity	20 minutes
Outlook: Tips and tricks	Internet and Email Office Productivity	1 hour
Outlook Web Access: Introduction	Internet and Email Office Productivity	20 minutes
Photoshop: Introduction to graphical file types what is the difference between Vector and Raster graphics	Web Authoring Graphics
Photoshop: Introduction to the Photoshop environment working with the Toolbox tools	Graphics
Photoshop: Paths using masks for complex selections	Graphics
Photoshop: Web development slices, rollovers, animations	Web Authoring Graphics
PowerPoint: Action settings/buttons and working with different types of links	Multimedia Office Productivity	45 minutes
PowerPoint: Animation and slide show enhancements	Multimedia Office Productivity	45 minutes
PowerPoint: Charts	Graphics Multimedia Office Productivity Data Analysis and Statistics	45 minutes
PowerPoint: Drawing tool	Graphics Multimedia Office Productivity	30 minutes
PowerPoint: Images (clipart and pictures)	Graphics Multimedia Office Productivity	45 minutes
PowerPoint: Master slides	Multimedia Office Productivity	30 minutes
PowerPoint: Overview and basic functions toolbars, task pane, slide layouts, add/delete slides, views, and design templates	Multimedia Office Productivity	1 hour, 30 minutes
PowerPoint: Packing, printing, and presenting	Multimedia Office Productivity	30 minutes
PowerPoint: Tables and files	Multimedia Office Productivity	45 minutes
UNIX: Introduction	Computing Basics	3 hours
Web authoring: Accessibility	Web Authoring	3 hours
Web authoring: Advanced hyperlinks email hyperlinks; email links with a subject; targeted links; links to non-HTML documents; complex relative links	Web Authoring	1 hour
Web authoring: CGI scripts	Web Authoring	3 hours, 30 minutes
Web authoring: CSS: Box property styles margins, borders, spacing	Web Authoring	1 hour
Web authoring: CSS: Classes, span, and div	Web Authoring	1 hour
Web authoring: CSS: Media-specific styles set up special styles specifically for printing, viewing on a handheld computer, etc.	Web Authoring	30 minutes
Web authoring: CSS: Positioning absolute positioning and sizing	Web Authoring	30 minutes
Web authoring: CSS: Styles and images list-style-image property, background image property, etc.	Web Authoring Graphics	30 minutes
Web authoring: CSS: Syntax embedded, linked, and inline styles	Web Authoring	1 hour
Web authoring: CSS: Text-level styles font and text properties	Web Authoring	1 hour
Web authoring: Forms	Web Authoring	1 hour, 30 minutes
Web authoring: Foundations	Web Authoring	1 hour
Web authoring: HTML document basics editing tools and file saving; HTML tags, attributes, and white space conventions; HTML document skeleton: document type declaration, head, and body sections	Web Authoring	45 minutes
Web authoring: Images format, file size, and load time issues; the img tag, attributes, and alt-text; images as links; retrieving graphics from the web	Web Authoring Graphics	1 hour
Web authoring: Information design	Web Authoring	1 hour
Web authoring: Perl	Web Authoring	3 hours
Web authoring: Publishing your site criteria for publishing; account configuration; WS_FTP and Fetch; file permissions; URLs; directory structure; password restriction	Web Authoring	1 hour
Web authoring: Tables	Web Authoring
Web authoring: Text level HTML elements paragraphs; breaks; non-breaking spaces; white space conventions in HTML; horizontal rules; ordered, unordered, description, and nested lists; heading levels and usage; phrase elements; the title attribute; relative and absolute hyperlinks	Web Authoring	2 hours, 20 minutes
Web authoring: The head element and tips the <base>, <meta>, and <link> tags; meta-information and search engines; special character codes; viewing web pages source HTML in a browser; HTML comments	Web Authoring	1 hour
Web authoring: Visual design	Web Authoring Graphics	1 hour
Windows: Getting help	Computing Basics	10 minutes
Windows: System configuration	Computing Basics	10 minutes
Windows: User interface overview	Computing Basics	30 minutes
Windows: Windows	Computing Basics	30 minutes
Windows: Working with applications	Computing Basics	30 minutes
Windows: Working with files	Computing Basics	45 minutes
Word: Building an index	Office Productivity	1 hour, 30 minutes
Word: Footnotes and endnotes	Office Productivity Research and Libraries	30 minutes
Word: Headers and footers	Office Productivity	30 minutes
Word: Inserting images clipart, files, pictures, hyperlinks, and symbols	Graphics Office Productivity	30 minutes
Word: Mail merge	Office Productivity	1 hour
Word: Overview and basic functions toolbars, rulers, status bar, task pane, creating/saving/opening documents, copy/paste, rearranging text, formatting, selecting text, page setup, spell checking	Office Productivity	1 hour, 20 minutes
Word: Paragraph indentation	Office Productivity	40 minutes
Word: Tables create, modify, and apply borders/shading	Office Productivity	1 hour
Word: Tabs	Office Productivity	40 minutes
Word: Tracking and reviewing changes and comments	Office Productivity	30 minutes
Word: Using paragraph styles/Building a table of contents or figures	Office Productivity	1 hour
Word: Using section breaks/Creating sections with different page numbering styles	Office Productivity	1 hour

		Printer Friendly
		Libraries A-Z A B C D E F G H I J K L M N O P Q R S T U V W X Y Z