This video series, example data files, and tips sheets (see attachments in video descriptions) is a compilation of principles and excel procedures useful for tribal environmental agencies who manage data, whether in a short term project involving only a few dozen data values and locations, to programs gathering data every minute from many monitoring stations.
It is loosely organized into the operations that most environmental data management systems must use: planning, importing (from websites, pdf reports), cleaning, charting, sorting, filtering, merging, flagging, appending, using datetimes, summarizing, automating data flow, and using a self-documenting system so that there is a clear and transparent trail of operations and decisions from each raw data point and QC check result.
For more information on this series, contact NEIEN@nau.edu.
It is loosely organized into the operations that most environmental data management systems must use: planning, importing (from websites, pdf reports), cleaning, charting, sorting, filtering, merging, flagging, appending, using datetimes, summarizing, automating data flow, and using a self-documenting system so that there is a clear and transparent trail of operations and decisions from each raw data point and QC check result.
For more information on this series, contact NEIEN@nau.edu.