Presentations and
Coordinator Resources
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.
How-to's: Google Sheets
1) Work Hour_Wage Calculator
2) Course Number_Data Aggregation (New-8/20)
Course Number_Data Aggregation Templates
Link to template for Block Scheduling (02/02/24)
Link to template for Period Scheduling (02/02/24)
**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's: Google Maps
1) How to Create & Setup a Custom Google Map
2) How to Add a Business/Student to Google Maps
3) How to Record a Visit in Your Google Map
4) How to Share Your Google Map with Others
5) How to Move Your Map Data into a Spreadsheet
6) How to Create a Custom Route in Google Maps
How-to's: Google Forms
(online application)
(online application)
1) Basic Setup of a Google Form
2) Basic Editing & Conditions in a Google Form
3) Linking a Google Form to Google Sheets
How-to's: AutoCrat (Google Sheets)
1) Installing and Basic Setup of AutoCrat_Part 1
2) Installing and Basic Setup of AutoCrat_Part 2
Miscellaneous Videos
Adding Form/Websites to Your Phone as a Shortcut
Record of Class Visits/Presentations
Work-site Evaluations
YAP Tracking Form
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!)
EdPuzzle Video Coming Soon
Video on QR Codes Coming Soon