Class Descriptions
Here is a description of courses offered by Data Diva, with more being added as they are created. Courses are in small groups, and include practice data, VAN access to a training account where necessary, and follow-up review materials.
VAN Basics: Running a Canvass
Prerequisite Skills: None
Get the basics of how to use VAN to canvass. Learn how to pull a list, cut the turf, print it, do the canvass, and enter the data. Vital information for anyone who wants to run a field campaign.
Creating in VAN: Survey Questions, Activist Codes, Scripts, and Formats
Prerequisite Skills: Field Organizer - level of VAN skills.
Learn how to create the tools you use in VAN to talk to your voters and record the results. These skills are vital for anyone who wants to become a Field Director on and race smaller than a statewide, because for most campaigns the Field Department is the Data Department.
Complex List Creation
Prerequisite Skills: Making a basic list
Learn how to build a multi-step list, including who you should put on them. Running in a Primary? You need to talk to different people than for a General. Learn the difference between saving a list and saving a search, and knowing when to use each. Make folders and share them with different people and groups. We'll also discuss what scores are, how to use them, and how they are made.
Basic Excel
Basic Excel
Prerequisite Skills: None, though you should have Excel on your computer. Google Sheets or Libre Office will work in most cases, but the interface may be slightly different
Skills taught:
What is a formula?
How do you drag a formula?
What is the $ used for
Creating a print area
Number formats
How dates are stored in Excel
Sum formula
Count, CountIf, and Counta formulas
Highlighting
Prerequisite Skills: None, though you should have Excel on your computer. Google Sheets or Libre Office will work in most cases, but the interface may be slightly different
Skills taught:
What is a formula?
How do you drag a formula?
What is the $ used for
Creating a print area
Number formats
How dates are stored in Excel
Sum formula
Count, CountIf, and Counta formulas
Highlighting
Intermediate Excel
Prerequisite Skills: What a formula is, How to use $, Number formats
Skills taught:
Text to columns/what delimiters are
Vlookups
Left, Right, and Middle formulas
Length and Find formulas
Row and Column formulas
Sumif Formula
Conditional Formatting
Filters and their uses