About the Spring Technical Workshop Series

Our Spring Technical Workshop Series features five lessons: two Excel, one VBA, and two R. Each workshop will be accompanied by an interactive worksheet to follow along with the lesson and will be followed by some homework to help apply the concepts learned in the workshop. The series will end with a final project used to demonstrate all the skills learned over the course of the training. Completion of each lesson worksheet, homework, and final project will result in proficient skills in excel, VBA, and R. Additionally, completion of the training will be advertised in the resume book to showcase the skills acquired throughout the program to recruiters. ​

Syllabus

This is the syllabus that outlines the workshop series: Syllabus

Important Information

• Below is the past technical workshop from 2021 and will be available to still complete
• The technical workshop for 2022 will be in TIA Skills Courses and if you are interested in this please submit your response in this survey:
  • Survey for TIA Skills Course
• The first availability of the 2022 technical workshop will be from mid-May to the end of June
  • So if you are interested fill out the Survey before May!
• Those who complete a part of the TIA Skills Course will be mentioned in the Resume Book!

Recordings

Recording for Excel Workshop #1: Zoom
Recording for Excel Workshop #2: Zoom
Recording for VBA Workshop #1: Zoom
Recording for R Workshop #1: Zoom
Recording for R Workshop #2: Zoom

Files

Here is where you can find the Worksheets and Homework Assignments that will be used throughout the Spring Technical Workshop Series

• Excel Workshop #1
  • Excel Workshop #1 Worksheet
  • Excel Workshop #1 Homework
• Excel Workshop #2
  • Excel Workshop #2 Worksheet
  • Excel Workshop #2 Homework
• VBA Workshop #1
  • VBA Class File
  • VBA Completed Class File
  • VBA Power Point
  • VBA Homework Instructions
  • VBA Homework File#1 - Maze
  • VBA Homework File#2 - CAE
  • VBA Homework File#3 - Animals
• R Workshop #1
  • R Presentation Work-Along #1 (.Rmd)
    • State Abbreviations (.csv)
    • Vaccine Data (.csv)
  • R Homework #1 (.Rmd)
    • 2008 Election Data (.csv)
    • 2012 Election Data (.csv)​
• R Workshop #2
  • R Presentation Work-Along #2 (.Rmd)
    • State Abbreviations (.csv)
    • Vaccine Data (.csv)
    • Salary Data (.csv)
  • R Homework #2 (.Rmd)
    • Final 2008 Election Data (.csv)
    • Final 2012 Election Data (.csv)
• Final Project
  • Excel
    • Excel Final Project (.xlsx)
  • R
    • R Final Project (.Rmd)

Submissions 

Below are the links to submit your homework for the Spring Technical Workshop Series

• Excel Workshop #1 Worksheet
• Excel Workshop #1 Homework
• Excel Workshop #2 Worksheet
• Excel Workshop #2 Homework
• VBA Workshop Homework
• R Workshop #1 Homework
• R Workshop #2 Homework
• Final Project