Amy Cavender
  • Data
  • Tech
  • Teaching
  • Portfolio
Sign in Subscribe
Data

Immigration dashboard

Amy Cavender

Amy Cavender

15 Jan 2026
An image of the world with continents shown in solid white against a blue background.
Photo by Hartono Creative Studio / Unsplash

I had some fun today throwing together a Tableau dashboard showing travel and immigration visa status by country for those wishing to come to the United States.

Read more

Screen shot of the code editor in Google Apps Script

Custom functions for preparing data

Last week, I explained how I used a combination of macros in Google Sheets to clean up class lists for a project I’m working on. With that part of the project complete, the next step was to combine the individual class lists into one consolidated list that I could

By Amy Cavender 22 Nov 2024
Woman sitting at a computer working on a spreadsheet

Macros for data cleaning

Students often ask me, “What can I do with a degree in Political Science?” There are many things, of course, but one of the best ways to give students ideas about what they might do with a Political Science degree is to let them know what former students are currently

By Amy Cavender 14 Nov 2024
Gaming dice

A Shortcut for creating random groups

Just before the academic year began in late August, I found myself looking through the Shortcuts application to see whether I had any shortcuts I needed to update for the new term. I found that I was missing one: a shortcut for creating random groups of students for small group

By Amy Cavender 10 Oct 2023
Screenshot of Python script in VSCode

Python scripts for duplicating files and folders

Earlier this summer, I spent some time creating Python scripts to copy files and folders. Why do that? For me, the most common use case for copying files is that I want to have a marking sheet for each student. The starting point (the blank sheet) is the same for

By Amy Cavender 23 Aug 2023
Amy Cavender
Powered by Ghost

Amy Cavender

Data. Tech. Teaching.