Skip to content Skip to main navigation Report an accessibility issue

OIT Trainings

OIT Training 

User Experience and Assessment both take specific computer and technical skills. These are some of the recommended OIT training for this program.

Microsoft Excel 1 (Worksheet Basics)

Students will learn the basics of using the Excel interface to accomplish the following tasks: create and edit worksheets, enter data and formulas, format text and values, use sort and filter tools, insert pictures, and manage a workbook.

Microsoft Excel 2 (Forms, Charts, and Macros)

The class covers topics in Microsoft Excel beyond the beginning basics. Topics include calculations, functions, and macros on a form, creating and customizing charts, and customizing the page layout. Attendees should know how to enter data, create basic formulas, sort, print, move data and add rows/columns before attending (See Excel Level 1).

Microsoft Excel 3 (Advanced Features)

This workshop should be taken after Excel 2 and covers Pivot Tables & Charts, Advanced Formatting, Advanced Filtering, and Macros from formulas. PowerPoint

SPSS 1 (Basics)

This hands-on workshop takes you from starting the package through data coding, entry and cleanup, creating new variables, how to get output for different groups, how to request analysis or a graph, manipulating the output, and where you can learn more.

SPSS 2 (SPSS Data Analysis)

This workshop shows you how to run the most widely used statistics and graphics in SPSS, as well as how to interpret the output. Topics include: exploring your data to find errors, extreme values, and sparse categories; examining the distributions of continuous variables; measuring the strength of association between two continuous variables; comparing two groups on categorical and continuous variables and where to go to learn more.

Nvivo (Coding software)

Qualitative data-analysis tools such as NVivo are immensely useful for researchers who analyze, synthesize, and write up literature reviews. This workshop will focus on using NVivo (a qualitative data-analysis tool) to organize, query, visualize, and summarize data for a literature review. Additionally, participants will learn how to annotate literature, add research notes, and integrate NVivo with bibliographic software packages such as Endnote and Zotero.