IETA 2024

Everyone knows that all kinds of good information can be pulled from spreadsheets, but how do you unlock that information? Data comes alive when you can manipulate data to understand it. In this hands-on workshop, we’ll begin with a generic term final grade spreadsheet with thousands of enrollments and grades and we will use the Unique, If, and Vlookup functions in Google Sheets to sort out how individual students did. Gaining an understanding of how to use these 3 simple functions allows users to pull all kinds of information from their spreadsheets and become spreadsheet magicians. Participants will need their laptops, at least a basic knowledge of spreadsheets, and access to Google Sheets. If you are familiar with spreadsheets but would like to have more knowledge of how to manipulate them, this workshop is for you.