Addressing Shortages in Classroom Space Using Tableau To

Addressing Shortages in Classroom Space Using Tableau To Develop a Model of Classroom Utilization – by Govind Acharya, Principal Analyst, gacharya@ucdavis. edu 1 6/17/2021

Takeaways From Today’s Presentation • • IR’s Role in Classroom Utilization Leveraging the Data Visualizing the Results Communicating Recommendations From the Data 2 6/17/2021

BIA’s Role in Classroom Utilization • • • Provided analytics by developing a unique data set. Assemble a series of visualizations depending on the audience. Navigate the multiple stakeholders desires. Made recommendations on future needs. Be willing to change course on direction of the project. 3

What’s the Problem That We Need To Address? 4

What Data Do You Need? • Every classroom with the type of room, seats, which department controls it, and any other information you can grab. • Coursework with enrollment, schedule, whether it’s a lecture or discussion section or lab, who teaches the section (faculty or instructor). • When the course takes place: days of the week and time, the scheduling context over the years. 5

4. How do we illustrate the issues • Capacity Utilization: How full a room is for a particular class • Time Utilization: How often a room is used • Define the time period: daytime class starts between 8 am to 6 pm 6

What about benchmarks? WHAT ABOUT THEM? 7

Challenges and Opportunities • Challenges • Distribution/audience • Interpretation • Refreshability & Lag • Opportunities • Collaboration • Extensibility 8

QUESTIONS? You can also contact me at gacharya@ucdavis. edu 9 6/17/2021