This codebook.txt file was generated on <20180924> by <Zhiyuan Yao>


-------------------
GENERAL INFORMATION
-------------------


1. Title of Dataset 
Airborne Manganese at Warren Elementary School, Marietta

2. Author Information


  Principal Investigator Contact Information
        Name: Erin Haynes
           Institution: University of Cincinnati
           Address: G32A Kettering Building, 160 Panzeca Way, Cincinnati, OH 45267
           Email: erin.haynes@uc.edu


  Associate or Co-investigator Contact Information
        Name:
           Institution:
           Address:
           Email:


  Associate or Co-investigator Contact Information
           Name:
           Institution:
           Address:
           Email:


3. Date of data collection (single date, range, approximate date) <suggested format YYYYMMDD>
20090817-20120225

4. Geographic location of data collection (where was data collected?): 
16855 OH-550, Marietta, OH 45750

5. Information about funding sources that supported the collection of the data:




--------------------------
SHARING/ACCESS INFORMATION
-------------------------- 


1. Licenses/restrictions placed on the data:


2. Links to publications that cite or use the data:


3. Links to other publicly accessible locations of the data:


4. Links/relationships to ancillary data sets:


5. Was data derived from another source?
           If yes, list source(s): https://www3.epa.gov/air/sat/WarrenElemAddl.html


6. Recommended citation for the data:




---------------------
DATA & FILE OVERVIEW
---------------------


1. File List
   A. Filename: Marietta_WarrenElementraySchool.mp4       
      Short description: The video shows the changes of the monthly average of airborne manganese in 
                         Warren Elementary School, Marietta.        

        
   B. Filename:  Marietta_WarrenElementraySchool.ppt       
      Short description: This file shows how the video is created in PowerPoint.      

        
   C. Filename:  Marietta_WarrenElementraySchool_Processed.csv        
      Short description: This file gives the processed monthly averages of airborne manganese.


   D. Filename:  Marietta_WarrenElementraySchool_Raw.csv     
      Short description: This file gives the raw data of airborne manganese.     

        
   E. Filename:  Marietta_WarrenElementraySchool_WorkingFile.xlsx        
      Short description: This file shows how data are processed.


2. Relationship between files:        
Marietta_WarrenElementarySchool_raw.csv is the raw data. Marietta_WarrenElementarySchool_Processed.csv is
the aggregated monthly averages of the raw data. Marietta_WarrenElementarySchool_WorkingFile.xlsx shows how the raw
data are processed into monthly averages. Marietta_WarrenElementarySchool.ppt illustrates how the video is 
generated. Marietta_WarrenElementarySchool.mp4 is the video generated from Marietta_WarrenElementarySchool.ppt.  

3. Additional related data collected that was not included in the current data package:




4. Are there multiple versions of the dataset? no
   If yes, list versions:
           Name of file that was updated:
                     i. Why was the file updated? 
                ii. When was the file updated?
           Name of file that was updated:
                      i. Why was the file updated?
                    ii. When was the file updated?






--------------------------
METHODOLOGICAL INFORMATION
--------------------------


1. Description of methods used for collection/generation of data: 
<Include links or references to publications or other documentation containing experimental design or protocols used in data collection>


2. Methods for processing the data: <describe how the submitted data were generated from the raw or collected data>
The daily airborne manganese data are aggregated into monthly averages.

3. Instrument- or software-specific information needed to interpret the data:


4. Standards and calibration information, if appropriate:


5. Environmental/experimental conditions:


6. Describe any quality-assurance procedures performed on the data:


7. People involved with sample collection, processing, analysis and/or submission:


-----------------------------------------
DATA-SPECIFIC INFORMATION FOR: [Marietta_WarrenElementaySchool_Raw.csv]
-----------------------------------------
<create sections for each dataset included>


1. Number of variables:
5

2. Number of cases/rows: 
80

3. Missing data codes:
        --                 Sample not taken or invalid


4. Variable List

    Example. Name: Gender 
             Description: Gender of respondent
                    1 = Male
                    2 = Female
                    3 = Other                

    A. Name: <Date>
       Description: <The day when data were collected>
                    Value labels: 8/17/2009, et al.

    B. Name: <Lead Non-FRM/FEM (Nanograms/cubic meter)>
       Description: <Airborne lead>
                    Value labels: 6.13, et al.

    C. Name: <Manganese (Nanograms/cubic meter)>
       Description: <Airborne manganese>
                    Value labels: 380, et al.

    D. Name: <Lead Sample Screening Level>
       Description: <Lead Sample Screen Level>
                    Value labels: 150.

    E. Name: <Manganese Sample Screening Level>
       Description: <Manganese Sample Screen Level>
                    Value labels: 500.

-----------------------------------------
DATA-SPECIFIC INFORMATION FOR: [Marietta_WarrenElementaySchool_Processed.csv]
-----------------------------------------
<create sections for each dataset included>


1. Number of variables:
5

2. Number of cases/rows: 
32

3. Missing data codes:
        --                 Sample not taken or invalid


4. Variable List

    Example. Name: Gender 
             Description: Gender of respondent
                    1 = Male
                    2 = Female
                    3 = Other                


    A. Name: <Date_Month>
       Description: <The month when the data were collected>
                    Value labels: 2009 Aug., et al. 


    B. Name: <Month_Average (ug/m3)>
       Description: <The monthly average of the airborne manganese>
                     Value labels:0.134636667, et al.

    C. Name: <EPA Standard (ug/m3)>
       Description: <EPA reference for airborne manganese>
                    Value labels: 0.05, et al. 


    D. Name: <ATSDR Standard (ug/m3)>
       Description: <ATSDR Standard for airborne manganese>
                     Value labels: 0.3, et al.

    E. Name: <WHO Standard (ug/m3)>
       Description: <WHO Standard for airborne manganese>
                    Value labels: 0.15, et al.

-----------------------------------------
DATA-SPECIFIC INFORMATION FOR: [Marietta_WarrenElementaySchool_WorkingFile.xlsx]
-----------------------------------------
<create sections for each dataset included>


1. Number of variables:
10

2. Number of cases/rows: 
For variables, Date_Day, Manganese (Nanograms/cubic meter), Manganese (ug/m3) and Month， there are 79 rows.
For variables, Date_Month, Month_Average (ug/m3), EPA Standard (ug/m3), ATSDR Standard (ug/m3), WHO Standard (ug/m3), and Month_condition,
there are 32 rows.

3. Missing data codes:
        --                 Sample not taken or invalid


4. Variable List

    Example. Name: Gender 
             Description: Gender of respondent
                    1 = Male
                    2 = Female
                    3 = Other                


    A. Name: <Date_Day>
       Description: <The month when the data were collected>
                    Value labels: 08/17/2009, et al. 

    B. Name: <Manganese (Nanograms/cubic meter)>
       Description: <Airborne manganese>
                     Value labels:380, et al.

    C. Name: <Manganese (ug/m3)>
       Description: <Airborne manganese>
                     Value labels:0.38, et al.

    D. Name: <Month>
       Description: <The month when the data were collected>
                     Value labels: 1, 2, et al.
    E. Name: <Date_Month>
       Description: <The month when the data were collected>
                    Value labels: Aug-09, Sep-09, et al. 

    F. Name: <Month_Average (ug/m3)>
       Description: <The monthly average of the airborne manganese>
                     Value labels:0.134636667, et al.

    G. Name: <EPA Standard (ug/m3)>
       Description: <EPA reference for airborne manganese>
                    Value labels: 0.05, et al. 

    H. Name: <ATSDR Standard (ug/m3)>
       Description: <ATSDR Standard for airborne manganese>
                     Value labels: 0.3, et al.

    I. Name: <WHO Standard(ug/m3)>
       Description: <WHO Standard for airborne manganese>
                    Value labels: 0.15, et al.

    J. Name: <Month_condition>
       Description: <The condition variable for calculating monthly averages>
                    Value labels: 8, 9, et al.