Purple spring flowers with C4C in focus in the background

Our mission is to facilitate a culture of continuous improvement in the Division of Student Affairs. We support Division staff in collecting, analyzing, reporting and sharing meaningful data that inform and enhance their programs, services, and physical spaces. We lead Division-level strategic planning to prioritize and align the work of our diverse units with campus-level priorities.

The Office of Assessment and Planning supports Student Affairs units in gathering and analyzing data to inform meaningful changes to their activities, services and facilities. We provide the following services to the Division of Student Affairs:

  • Consultation with Student Affairs units to develop and implement unit-level assessment plans
  • Providing expertise to units on outcomes, methods, instrument development, analysis, reporting and use of results to drive improvement
  • Leading the Division’s Strategic Plan development, implementation and reporting processes
  • Disseminating relevant data and reports to Division, campus and other stakeholders
  • Coordinating requests for institutional data
  • Representing the Division on committees related to assessment, planning, institutional data, campus surveys, and accreditation


The Office of Assessment and Planning works closely with staff in the Division of Student Affairs to support assessment planning and practice. Assessment consultations can be team-based work on specific initiatives within or across units, as well as individual staff members working on behalf of their units.

Your consultant will seek a comprehensive understanding of your assessment needs, asking questions such as:

  • What are the key questions you want to answer?
  • How would you be able to act upon what you learn from this assessment project?
  • What data, if any, do you already have available about this program or service?
  • How does this project align with your unit’s mission, goals, and outcomes?

Consultants then provide recommendations, offer technical and content expertise, assist with data collection and analysis, and offer additional services to support the specific project and unit. 

The Office of Assessment & Planning (OAP) has created a program that is comprised of nine essential components for conducting assessment in SA higher education. Each component includes a training provided by OAP, a quiz to demonstrate knowledge and an application requirement. Together, these pieces are known as the Assessment, Evaluation, and Data Analytics Boards (AEDA Boards).

Upon successful completion of each component, the participant will receive an AEDA Board certificate. The certificate will designate to the Division that the individual is capable of carrying out assessment with minimal support from OAP, and their findings should be considered accurate. 

Who it's for: Student Affairs staff who would like to increase skills and competence around data and assessment.

Training Dates: July 9 and 10

Learn more and register

Data Storytelling 2.0 | Monday, Sept. 27 | 10 a.m. - 11 a.m.
Telling stories is an effective way to communicate data. Join us in this intermediate data storytelling training as we explore design thinking models and other useful ways to tell our stories. Participants will leave with strategies to use in their work.

Scale Development | Tuesday, Sept. 28 | 10 a.m. - 11 a.m.
One of the most challenging aspects of survey development is developing the scale for various questions. The focus of the training is on developing reliable and valid survey questions (technically called measures, scales, or instruments) that differentiate between different levels of perceptions, experiences, attitudes, for example, sense of belonging, confidence, roommate congeniality, etc. We will discuss a variety of examples and methods for selecting an appropriate scale.

Qualitative Working Group | Monday, Oct. 4 & Monday Oct. 18 | 9:30 a.m. - 11 a.m.
This hands-on experience will help staff to develop their skills in qualitative analysis. Staff will receive qualitative analysis training and then, using real data, staff will practice coding open response questions, identifying themes and making recommendations based upon the data. Staff must attend both group meetings and complete some tasks outside of trainings.

Introduction to Lay Theory Strategies | Tuesday, Oct. 12 | 10 a.m. - 11 a.m.
What underlies our psychology, our naïve understandings, are called lay theories. Students’ lay theories of willpower, resilience, belonging, and intelligence…can significantly influence their behavior, academic performance, and retention. This training provides a list of effective strategies that can be integrated into mentoring, (in)formal conversations, and structured programming to improve students’ responses to academic and social challenges.

Program Evaluation Using a Regression Discontinuity (RD) Design | Tuesday, Nov. 16 | 10 a.m. - 11 a.m.
The Regression Discontinuity (RD) design is an alternative to Random Control Trial (RCT). It can provide strong evidence of causal impact of student support programs/services while overcoming the ethical concerns associated with RCT. This training provides an introduction to RD for Student Affairs practitioners on how to incorporate the RD design into program planning/implementation and into the available data analysis to explore causal relationship.

Formative and Summative Assessment | Monday, Nov. 29 | 10 a.m. - 11 a.m.
There are often numerous opportunities to collect data within a single experience. The challenge is deciding when and how to do so. This training will help staff to understand the difference between formative (in-process) and summative (post-experience) assessments and offer guidance and best practices on when and how to use each.

Assessment Reporting Series 
Reporting is critical in Student Affairs as it takes information and knowledge and transmits it to others in a meaningful and persuasive way. During the fall semester, OAP will provide a four-part training series focused on reporting. Each element of the series will focus on an aspect of reporting that participants need to create successful reports. The elements include training related to products, content, DEI practices, and alignment with initiatives. These can be taken individually, but we encourage folks to take them all. All reporting series trainings will be held virtually via Zoom.

  • Monday, Oct.11 | 10 a.m. - 11 a.m | Products
  • Monday, Oct. 25 | 10 a.m. - 11 a.m |  Content
  • Monday, Nov. 8 | 10 a.m. - 11 a.m | DEI Practices
  • Monday, Nov. 15  | 10 a.m. - 11 a.m | Alignment with Division & University Initiatives

Microsoft Excel Training Series
The Office of Assessment and Planning will be offering a series of Microsoft Excel trainings during the fall semester. These can be taken individually, but we encourage folks to take as many as applicable to their work with data.

  • Thursday, Oct. 7 | 3 p.m. - 4 p.m. | Basic Formula: Statistical Analysis - This hands-on training introduces basic formulas in excel to conduct simple data analysis and to summarize data information. Staff will use real data to calculate frequency/count, average, std dev, and to create plots of histograms, clustered bar graphs, and line charts, etc.
  • Thursday, Oct,14 | 3 p.m. - 4 p.m. | Intermediate Formulas: Data Manipulation - Intermediate level of formulas are used to clean, filter, and sort through data based on given priority and conditions. Staff will receive hands-on practices of data manipulation such as Filter, Unique, Sort, data consolidation, data separation, and conditional formatting.
  • Thursday, Oct. 21 | 3 p.m. - 4 p.m. | Advanced Formulas: Condition and vlookup - Advanced formulas are introduced to find specific information from an array of student survey data and discover any potential insights and patterns. The training will help staff to generate new datasets through conditions using If statements, or iterate through data using Vlookup, Match, and Index functions.
  • Thursday, Oct. 28 | 3 p.m. - 4 p.m.| Creating Pivot Table Analysis - The Pivot Table in Excel is a powerful tool for us to see the comparisons, trends, and patterns in our data. This training uses real data to demonstrate how to use the tool to summarize, sort, filter, organize and group our data and how to use a variety of calculations on our data to obtain descriptive information by just simply clicking and dragging. 
  • Thursday, Nov. 4 | 3 p.m. - 4 p.m. | Macros and Automation - Macros can be used to automate repeated processes of data cleaning, data filter, and data analysis in Excel. This can expedite the timeline when working with datasets of similar properties and structures. Staff will receive practices on how to record and execute macros to perform the same tasks across several different datasets.
  • Thursday, Nov. 11 | 3 p.m. - 4 p.m. | Simple Predictive Analysis - Data analysis tools in excel can be used to conduct simple predictive analysis using regression. The training provides hands-on opportunities to learn and practice predictive analysis using excel.
  • Thursday, Nov. 18 | 3 p.m. - 4 p.m. | Creating Dashboards and Reports - VBA and Pivot Table are incorporated to create presentation-style dashboards in Excel. Staff will be able to create dashboards featuring interactive reports and summaries from student data.

Data Crossroads Discussions
The Office of Assessment and Planning will be hosting informal conversations about data collected across the university and in the division. These conversations will feature data sets and literature that bring to the forefront interesting combinations that inspire discovery and meaning-making. We will rely on participants to bring their unique perspectives and engage in these conversations. The general topic has been selected for each discussion but is subject to change. Participants will be notified of changes.

  • Friday, Oct. 8 | 10 a.m. - 11 a.m. | Purpose
  • Friday, Nov. 12 | 10 a.m. - 11 a.m. | Authentic Friendships in College
  • Friday, Dec. 10 | 10 a.m. - 11 a.m. | Building Trust with College Students

Register for a staff development & training session

The 2017-2020 Division of Student Affairs Strategic Plan aligns closely with the Chancellor’s Strategic Imperatives and will serve as the Division’s guiding framework to accomplish the Imperatives and contribute to other high-level university initiatives, such as Inclusive Excellence.


  • General: Qualtrics is licensed to the University of Colorado Boulder to support staff and students. The Office of Information Technology provides several resources, including an FAQ and guide to activating a Qualtrics account.
  • Webinars: There are a number of webinars available for all users, such as “Advanced Survey Building,” “Reporting Your Insights Using Qualtrics,” and “Quick Start with Qualtrics.” 
  • Qualtrics Support: Do you have a question about Qualtrics that you have not been able to answer? Contact OAP staff or the Qualtrics support team.

External Assessment Organizations & Resources


Kimberly Kruchen, Manager of Assessment and Planning

Crystal Cyr, Assessment Specialist

Ling Ning, Quantitative Research Analyst