The ECEC’s Assessment and Data Analytics Team offers seminars on data-related topics throughout the academic year. Sessions range from beginner to advanced and typically focus on a specific software tool. Upcoming sessions will be posted once they are announced.
N2Data Recording Library
Browse recordings from past N2Data sessions on topics like survey design and Qualtrics, Excel fundamentals, and institutional data. Use the sections below to find a session by topic and skill level, then open the recording that fits what you need.
Survey Design & Qualtrics
Level: Intermediate
Designing High-Quality Surveys
In this session, we will discuss guidelines for survey design, ways to avoid getting “bad data” from your respondents, principles for writing good survey items, and how (and when and why) to find existing survey items to use in your survey. We will end with a step-by-step demonstration of the process of creating a basic survey in Qualtrics.
RecordingLevel: Basic
Basic Survey Customization
As a follow-up to Getting Started with Qualtrics, this session will teach you how to customize features of basic item types, format item text, require items, set response validation, and use display and skip logic. Prior attendance at Getting Started with Qualtrics is not required but is recommended for anyone new to Qualtrics.
RecordingLevel: Basic
Qualtrics 101
This session covers everything you need to know to get started in Qualtrics. You will learn how to claim your university Qualtrics account, build a survey using common item types, set response validation, use display logic, learn key survey settings, change basic visual styling options, and decide between options for sharing your survey.
RecordingLevel: Intermediate
Advanced Survey Customization
In this session, we will build on Basic Survey Customization as we cover advanced question types, text piping, blocks and survey flow, and response recoding. Prior experience with Qualtrics or prior attendance at Basic Survey Customization is recommended.
RecordingLevel: Intermediate
Qualtrics 102
In this session, we will build on Qualtrics 101 as we cover advanced question types, question libraries, text piping, advanced survey flows, response recoding, response scoring, and advanced options for sharing your survey.
RecordingLevel: Intermediate
Other Useful Features of Qualtrics
In this session, we will cover a variety of other good-to-know features and functions in Qualtrics including setting a custom end-of-survey message, sharing a survey with collaborators, closing and later reactivating a survey, exporting and importing qsf files (Qualtrics survey files), downloading data and options for doing so, and viewing and exporting individual responses.
RecordingLevel: Basic
Getting Started with Qualtrics
This session will cover everything you need to know to get started in Qualtrics. You will learn how to claim your university Qualtrics account, build a survey using common item types, adjust key survey settings, and share your survey.
RecordingLevel: Advanced
Qualtrics Directories, Libraries, and Workflows
In this session for aspiring power-users, we will cover using directories to distribute your survey, making use of your Qualtrics Library, and setting up workflows. Substantial prior experience with Qualtrics or attendance at prior sessions is strongly recommended.
RecordingExcel Fundamentals
Level: Basic
Getting Started with Excel
In this session, we will review the basics of Excel, including using features within Excel's menus, inserting data into a sheet, using keyboard shortcuts, and customizing your experience with Options that can reduce headaches.
RecordingLevel: Intermediate
Features and Formulas for Working with Your Data
In this session, we will continue working with formulas as we explore absolute cell references and nesting formulas, and we will review other features within Excel that can help you make use of your data.
RecordingLevel: Basic
Getting Started with Formulas
In this session, we will review the basics of using formulas within Excel, including using relative cell references, commonly used formulas, features of the Forumlas tab, and accessing and interpreting formula "help" documentation.
RecordingLevel: Advanced
Working Across Sheets
In this session, we will tackle approaches for working across multiple spreadsheets and Workbooks as we explore advanced formulas (like lookups), cross-sheet cell references, approaches to combining datasets, and tools for viewing multiple sheets.
Level: Basic
Getting More from Your Data
In this session, we will start our work using a data file that is exported from a Qualtrics survey, and we will discuss how the structure of a Qualtrics survey impacts the structure of the data you can export. From there we will cover different types of data, ways to structure data within a worksheet and within a workbook, shortcuts for checking your data’s quality, the basics of data transformation, and some common data analysis steps.
RecordingLevel: Advanced
Strategies for Quality Checking your Data
In this session we will explore strategies for quality checking and cleaning data.
RecordingLevel: Basic
Getting a Handle on Your Spreadsheets
In this session, we will dive further into data structures as we work through the many questions you should ask yourself as you set up a new spreadsheet, set out to create a new data/documentation system, or redesign your personal data landscape to increase your own efficiency. This session will equip you to save yourself time later by planning ahead for the ways you might need to use your data.
RecordingLevel: Intermediate
Pivot Tables
In this session, we will learn how to use pivot tables! We will cover using pivot tables for summary and subgroup statistics.
RecordingInstitutional Data
Level: Basic
Everything You Didn’t Know You Need to Know About Institutional Data
In this session, we will cover a range of topics related to UNL’s institutional data. If you’ve ever asked, “Why don’t these numbers match what I saw in that other presentation?” this session is for you. If you ever make data requests related to student enrollment or graduation counts, this session is for you. We will review several important institutional data concepts, key points in time during the academic year, and discuss how institutional metrics (like retention and graduation rates) are defined so that you can be a more informed data consumer. We will also discuss how the organizational set up of the College of Engineering makes our data landscape particularly unique.
Recording