Excel-based dashboard tools that read in a TOMS student score data file and generates data visualizations

Source: Sacramento COE (Lead: Sattik Ghosh)

This hands-on lab introduces participants to Excel’s VLOOKUP function, demonstrating its utility in merging two data sets into a cohesive table. Participants will practice using the function to combine student information with test scores. This is a foundational skill and while it may look different in other applications, like SQL, Python, or Power Query, the end result is the same. 

Source: CCEE (Lead: Sehrish Anjum)

This hands-on lab introduces participants to Excel Power Query, demonstrating a common task in data merging and blending — creating a multi-year dataset of chronic absenteeism data. Participants will practice building a workflow and returning the results to Excel. 

Source: CCEE (Lead: Sehrish Anjum)

This hands-on lab introduces participants to RStudio to combine multiple years of CDE public data files and narrow down the data for specific schools, districts, or counties. Participants will learn the basics of RStudio, including how to use common libraries and commands with a focus on tidyverse and dplyr. After the basics are reviewed, participants will have an opportunity to practice writing an R script to import, clean, and manipulate data.

Source: CCEE (Lead: Sehrish Anjum)

This Excel file walks users through making different (and rare) chart types – specifically those called out by Stephanie Evergreen.

Source: Sacramento COE (Lead: Nikki Antonovich)