Tribal Data Toolbox Version 3.1
Tribal Data Toolbox Version 3.1
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
Online platform technical support: itep-elearning@nau.edu
Below is a preview of the course content. Log in to your account and enroll to access the material.
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