Search for tag: "tribal environmental data"

QC Data Sheets Pt 1-Field QC Data on Paper and into Excel Overview

This video provides an overview of one way (free to anyone) to set up a form that can be accessed on a smartphone in the field, enabling users to type in the results of field QC checks, and then…

From  ITEP Team 7 plays 0  

Excel 6 Pivot Chart to Present Data

Continuing to use the minute sensor data, this demonstration is of inserting a pivot chart that can be collapsed and expanded to generate summary statistics by hour, day, month and year.

From  ITEP Team 7 plays 0  

Excel 5 Pivot Table for Summary Statistics

Demonstration of how to summarize minute sensor data by average and max, by hour and day, using a pivot table. Caution: check for gaps in your data, which may not be represented clearly in a pivot…

From  ITEP Team 10 plays 0  

Excel 4 Fun: Excel Map from Lat Long

This video demonstrates using the same sensor data that has been used in the importing videos, and excel’s ability to understand geographic identifiers and incorporate maps, to generate a map…

From  ITEP Team 11 plays 0  

Excel 3 Use Named Ranges as Brain Savers

Very brief demonstration of how to name a range of data (and if this range is in an excel Table it will automatically expand to include more rows), which allows you to refer to that range by name…

From  ITEP Team 8 plays 0  

Excel 2 Import Anything Using Power Query

Demonstration of the import of the same sensor data into excel as was demonstrated in the legacy import video, but this import is done using the self-documenting excel power query feature.

From  ITEP Team 15 plays 0  

Excel 1 Import Data Using Legacy Wizard

Demonstration of importing sensor minute data (follow along using the raw comma separated values .csv data file attached to this video) into an excel file using the excel legacy wizard. Legacy…

From  ITEP Team 20 plays 0  

QREST Agencies Meeting Feb 2023

Quality Review and Exchange System for Tribes (QREST) online meeting, including informal discussions of: 0:00 What is Polling 2:53 Raw Data 7:10…

From  ITEP Team 9 plays 0  

Tribal EN Projects Deep-dive: Region 8 & 9 Tribes

(To request closed captioning or transcripts, contact NEIEN@nau.edu with the title and URL of the video.) This presentation reviewed the Native American Environmental Protection Coalition's…

From  ITEP Team 1 plays 0  

Tribal EN Projects Deep-dive: Yakama Nation Fisheries

(To request closed captioning or transcripts, contact NEIEN@nau.edu with the title and URL of the video.) This presentation reviewed the migration of an End-to-End Digital Data Management System for…

From  ITEP Team 10 plays 0  

What Can IAASD Do For You? A Review of Online Data Analysis Services Supported by EPA

NOTE: Due to technical difficulties, the audio portion of this presentation is unavailable until approximately the 12:45 mark. (To request closed captioning or transcripts, contact NEIEN@nau.edu with…

From  ITEP Team 6 plays 0  

A Conversation with EPA OMS and Tribes on the Exchange Network

(To request closed captioning or transcripts, contact NEIEN@nau.edu with the title and URL of the video.) This listening session provided the opportunity to ask questions about the Exchange Network…

From  ITEP Team 18 plays 0  

Opening Session, Plenary Panel, and Tribal Case Studies (2022 TENC)

(To request closed captioning or transcripts, contact NEIEN@nau.edu with the title and URL of the video.) This is the kickoff session to the 2022 Tribal Exchange Network Conference (TENC) and took…

From  ITEP Team 11 plays 0  

How to Plan Ahead for Waste Management During a Disaster and be More Resilient: Waste Management Planning Tool (Mini-Workshop)

(To request closed captioning or transcripts, contact NEIEN@nau.edu with the title and URL of the video.) This tool was developed by the US EPA for state, local, and tribal planners, or any…

From  ITEP Team 9 plays 0  

Roundtable Discussion: EN Grants Best Practices and Tips for Success

(To request closed captioning or transcripts, contact NEIEN@nau.edu with the title and URL of the video.) Panelists shared their experiences working with EN grants, whether it is grant proposals,…

From  ITEP Team 6 plays 0  

Online Capacity Building & Networking Tools for Local Communities

(To request closed captioning or transcripts, contact NEIEN@nau.edu with the title and URL of the video.) With the use of EPA funding, several platforms have been developed to connect tribal…

From  ITEP Team 14 plays 0