Tribal Data Toolbox, (Level 3)
Finish the course with a "Toolbox" capable of producing reports, charts, and validated, AQS-ready files with your data!!

Back to Air Quality training

Course Description:
This course uses a new ITEP model of individualized homework assignments, one-on-one assistance, and "side by side" working with you on your data to provide you with a database that you know how to use for functions useful to you. The Tribal Data Toolbox is a stand-alone Microsoft Access database designed specifically for tribal air programs and available to tribes at no cost. The Toolbox can store and manage most air monitoring data, including criteria pollutants (both filter-based and continuous methods); meteorological data; QC and audit data; and administrative information such as personnel, site information, and equipment tracking. Version 3.0 includes Fast Track options for users only interested in some functions, updated Standard Operating Procedures, more customizable reports, thorough video tutorials, and updated AQS file exporting for both parameter and QC AQS files. By the end of this course, you will have a Toolbox populated with your data, know what functions you need and how to use them, be able to use those functions to generate summary data and QC reports and statistics, graphs, documentation for annual AQS certification and internal reviews, and AQS-ready files for both parameter and QC data, over customizable time periods.

Topics include:
  • Entering and modifying personnel, site, and equipment data

  • Entering and using Quality Control (QC) data

  • Importing continuous data files

  • Importing meteorological data files

  • Qualifying (flagging) and invalidating data

  • Generating reports and charts both as summary information and to assist in interpreting data

  • Generating AQS-formatted files from raw data files


Who Should Attend:
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. This is an advanced course; applicants should have completed ITEPís Air Pollution Technology (TECH) course before attending. A critical prerequisite is that participants provide the instructors with an example data file prior to the course, just as the participant routinely obtains it (off analyzer, datalogger, network, or web portal). It is not possible to take the course without supplying such an example dataset, as the assignments are built around each individualís files. Instructors can consult with you about formats of data files before the course, as needed.

Course Structure and Approach:
This course takes a radically different approach, and uses participantsí own data, directly from their own analyzer, datalogger, or network, and builds a data management system using a database created specifically for tribal air programs. Demonstrations use example data that has been provided by tribal programs, but all assignments are individualized to each participant. Instructors teach via live webcam internet sessions augmented by one-on-one assistance. A complete video library is available at any point during or after the course, and course materials are available online and on DVD.

Each module in the course builds upon the previous module, and as the course progresses participants populate their own database with their own data, learn to use functions as they occur in the normal operation of an air monitoring program, learn the SOPs relevant to those functions, customize reports and charts to suit their own management and needs, so that by the end of the course participants will have a documented, fully functioning air monitoring database. The final module includes how to produce, using participantsí own AQS protocol codes, data files for AQS. Supplementary material includes SOPs for exporting reports to MS Word and data and charts to MS Excel. Participants who miss the weekly (Tuesday morning) webinars can download the video(s) and exercise instructions, then complete the exercise on their own computer and email it to the instructor. Participants are expected to have an 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.

Contact:
» Melinda.ronca-battista@nau.edu
» Angelique.Luedeker@nau.edu

Back to Air Quality training


Last updated: April 20, 2015

 

© 2007 Arizona Board of Regents.
Northern Arizona University, South San Francisco Street, Flagstaff, Arizona 86011