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.