Presentations and
Coordinator Resources

If you are looking for a presentation given by Jason, they have been moved to this page.  

This content has been delivered in various forms at numerous conferences across the U.S.  As a result, there may be a need to slightly adjust some of the scripting in the spreadsheets to fit your specific state and program needs.

Please contact me if you need help creating your own files or altering the files that I provided to function specifically with your state or school system. If there is a resource that I said would be located on this page, but isn't--please contact me to let me know and I will upload it as soon as possible. (jasonvannus@lowndes.k12.ga.us)

Below are smaller, more detailed 'How-to' videos on how to create, set up, and edit the programs covered in the presentation. Please contact me if you have trouble accessing any of the files below due to the current file permissions.

How-to Copy These Files to Your Drive

This video will show you how to copy to your drive, any of the files that I have made public so that you are the owner and so that you have editing rights.

HowTo_Copy FIles to Your Drive.mov

How-to's: Google Sheets

1) Work Hour_Wage Calculator

Template for Hour/Time Calculator Template

Google Sheets_Hour_Wage_Calculator.mov

2) Course Number_Data Aggregation (New-8/20)

Updated_Google Sheets Overview.mov

Course Number_Data Aggregation Templates

**Updated to accommodate the new GADOE course numbers for WBL, placing a "1" in the fifth spot after the decimal. Please reach out to Jason if you have any questions or issues.

Jason Van Nus
C: 229.292.1043
E: jasonvannus@lowndes.k12.ga.us



3) How to Sort Columns in the Data Sheet

How to Sort in the Data Sheet.mov

How-to's: Google Maps

1) How to Create & Setup a Custom Google Map

How to Setup Your Google Map.mov

2) How to Add a Business/Student to Google Maps

How to Add a Business and Student to Your Google Map.mov

3) How to Record a Visit in Your Google Map

How to Record a Visit on Your Google Map.mov

4) How to Share Your Google Map with Others

How to Share Your Google Map.mov

5) How to Move Your Map Data into a Spreadsheet

How to Move Your Google Map Data to a Spreadsheet.mov

6) How to Create a Custom Route in Google Maps

How to Create a Custom Route in Your Google Map.mov

How-to's: Google Forms
(online application)

1) Basic Setup of a Google Form

Basic Setup of a Google Form.mov

2) Basic Editing & Conditions in a Google Form

Basic Editing and Conditions in a Google Form.mov

3) Linking a Google Form to Google Sheets

Linking a Google form to Google Sheets.mov

How-to's: AutoCrat (Google Sheets)

1) Installing and Basic Setup of AutoCrat_Part 1

Setting up Autocrat in a Google Sheet_part1.mov

2) Installing and Basic Setup of AutoCrat_Part 2

Setting up Autocrat_part2.mov

Miscellaneous Videos

Adding Form/Websites to Your Phone as a Shortcut

Record of Class Visits/Presentations

Work-site Evaluations

YAP Tracking Form

Shortcut_to_Phone.MOV
Class Presentations.mov
Work_site Evals.mov
YAP Tracking.mov

Partner Contact Form

Digital WBL Application

Click Here to See A Copy of My WBL Application: WBL Coordinators, feel free to submit a response with fake information if you want to see all the questions--this form will not be checked. (Students, this is a sample application--PLEASE DO NOT SUBMIT your real WBL Application to this form!)

Partner Contact Form.mov
WBL Application Form.mov

EdPuzzle Video Coming Soon

Video on QR Codes Coming Soon