Tribal Data Toolbox Version 3.1
Course overview
This online training is not an "informational course," but is a rigorous course in which participants complete work products, guided by ITEP instructional staff. Modules contain video presentations, homework assignments, discussions, and one-on-one assistance.
This course is designed for tribal environmental professionals who are currently monitoring or collecting data for at least one criteria pollutant or for meteorological conditions. It is not possible to take the course without having criteria air pollutants or meteorological data files from their air monitoring stations. Demonstrations use example data, but all assignments are individualized to each participant. Participants are expected to have intermediate-level working knowledge of Microsoft Windows. Although the course is structured around a Microsoft Access database, the database is form-driven and user-friendly; therefore, no previous Access experience is necessary.
During this training, participants will import continuous pollutant and met data, begin entering data from quality control checks performed on their air monitoring samplers, validate their data, generate reports, charts, and AQS-formatted files.
This online training is equivalent to 8 continuing education units (CEUs) and requires approximately 80 hours of total learning time.
Instructor: Angelique Maureen Luedeker, Angelique.Luedeker@nau.edu 928-282-8101
Course technical support: itep-elearning@nau.edu
Below is a preview of the course content. Enroll to access the materials.
Course Content
Course Navigation Instructions
Frequently Asked Questions and Comments
Announcements
Discussion: Introduce Yourself
Video: How to Show Full Filenames with Extensions
Course Introduction and Demonstration Notes (these accompany the videos in this module)
Module 1 Supplemental Slides
Video 1A: Introduction to Toolbox Database
Video 1B: Overview of Course Modules
Video 1C: Data File Logistics
Video 1D: Database Logbook
Video 1E: Closing Forms and Saved Data
Video: Module 1 Homework
Assignment 1A: Install the Toolbox
Assignment 1B: Designate a Database Logbook
Assignment 1C: Sample Data Files
Module 2 Demonstration Notes (these accompany the video in this module)
Video 2 Slides
Video 2: Five Functions of Toolbox
Assignment 2: Develop a Site and Sampler List
Module 3 Demonstration Notes (these accompany the videos in this module)
Video 3A: Entering Personnel Data
Video 3B: Editing Personnel Data
Video 3C: Entering Site Data
Video 3D: Editing Site Data
Video 3E: Adding Samplers
Video 3F: Editing Sampler Information
Assignment 3: Enter Personnel, Site, and Sampler Data into the Toolbox
Module 4 Demonstration Notes (these accompany the videos in this module)
QC Data Collection Sheets for Imaginary Samplers
Video 4A: Intro to QC
Video 4B: Ozone QC Data Into Toolbox
Video 4C: Data Entry of Toolbox-Calculated QC
Video 4D: 2nd Ozone QC Check
Video 4E: Continuous PM QC Data Entry
Video 4F: Closing Toolbox and Homework
Assignment 4: Enter Data from QC Checks into the Toolbox
Module 5 Demonstration Notes (these accompany the videos in this module)
Data Files from Imaginary Samplers
Example Toolbox-Ready Files
Notes for each of the videos below
Video 5A: Toolbox Import Files pt 1
Video 5B: Toolbox Ready Comma Delimited File (O3)
Video 5C: Space Delimited Dat File into Excel
Video 5D: Comma Delimited Met Data
Assignment 5: Let's Generate Toolbox-Ready Files
Tribal Data Toolbox Reflective Writing 1
Module 6 Demonstration Notes (these accompany the videos in this module)
Video 6A: Importing a Text File
Video 6B: Importing Spreadsheet File
Assignment 6: Import a Pollutant Concentration Toolbox-Ready File
Module 7 Demonstration Notes (these accompany the videos in this module)
Video 7: Importing Text File Using Example Met Data
Video 7A: Column Mapping
Assignment 7: Import a Meteorological Toolbox-Ready File
Module 8 Demonstration Notes (these accompany the videos in this module)
Video 8A: Continuous Data Validation, Individual Records
Video 8B: Bulk Invalidation of Many Records
Video 8C: Met Data Review and Invalidation
Assignment 8: Backup Your Toolbox and Validate Data
Module 9 Demonstration Notes (these accompany the videos in this module)
Video 9A: Reports and Charts
Video 9B: Reports and Charts, and Gap Filling
Assignment 9: Explore Toolbox Reports and Charts
Module 10 Demonstration Notes (these accompany the videos in this module)
Video 10A: AQS Monitor Protocol Codes Introduction
Video 10B: Importing AQS File Add AQS Monitor Protocol
Video 10C: Manually Adding Continuous PM2.5 AQS Protocol Codes
Video 10D: Manually Adding Met AQS Protocol Codes
Assignment 10: Import or Enter AQS Sampling Methodology into the Toolbox
Module 11 Demonstration Notes (these accompany the videos in this module)
Video 11A: Generating AQS-Formatted Files, Intro and Example 1
Video 11B: PM2.5 AQS-Formatted File
Video 11C: AQS Formatted Met Data Files
Discussion: What Do You Think of the Toolbox?
Assignment 11: Let's Generate AQS Files
Tribal Data Toolbox Reflective Writing 2
Tribal Data Toolbox Course Evaluation
Certificate of Completion