Students have engineered a user-friendly web interface, facilitating educators in seamlessly inputting data regarding their school's environmental footprint and initiatives. This comprehensive database encompasses narratives, photographs, videos, and participation records. It serves as a centralized repository for information on energy utilization, waste handling, water consumption, carbon footprint, and an array of eco-friendly endeavors such as recycling programs, composting initiatives, sustainability campaigns, and outdoor educational ventures. Furthermore, a dynamic dashboard has been integrated to present statistical analyses, enabling accurate presentation to the district board and stakeholders.
Here is the link to the demo video
Here is the link to the website
You can find our code for the notebook of overall project analysis and food waste analysis. We did not post the ipynb files as it previews personal information.
For access to the dataset or inquiries regarding data usage, please contact one of the team members or Dr. Anca Doloc-Mihu.
You can find our final report here.
- Team Manager👍
- Visualization⚜️
- Data Modeler💻
- Client Liaison😎
- Data Analyzer💻
- Project Documentation📖
STaRS - Georgia Gwinnett College - April 11, 2024
CREATE Symposium - Georgia Gwinnett College - April 25, 2024
- Educators: Teachers can use the web interface to submit data regarding their school's environmental initiatives and activities on a quarterly basis. They can access the dynamic dashboard to view statistical analyses and trends related to environmental education activities in their school and compare them with other schools. Educators can utilize the insights generated from the project to inform curriculum development, identify areas for improvement, and track progress towards environmental sustainability goals.
- Administrators: School administrators and district officials can access the centralized database to review comprehensive information on energy utilization, waste handling, water consumption, and other eco-friendly endeavors across schools. They can use the dashboard to generate reports and presentations for district board meetings, stakeholders, and policymakers to advocate for funding and support for environmental initiatives. Administrators can identify schools with successful composting practices or lacking initiatives despite having outdoor spaces, allowing targeted interventions and resource allocation.
- Future Research: Researchers and academics can utilize the project's dataset and findings as a valuable resource for further analysis and research on environmental education, sustainability practices, and school-based interventions. The project's open-access nature and comprehensive dataset make it a valuable resource for longitudinal studies, comparative analyses, and interdisciplinary research collaborations.
- Real-time Database Updates: The project successfully utilizes Firebase as a backend database, enabling real-time updates. Any changes made to the database reflect immediately in the system.
- Web-Based Questionnaire: The web-based questionnaire feature is fully functional, allowing users to input data seamlessly. Responses are stored in the Firebase database in real-time.
- Dashboard Integration: A dashboard interface is implemented, providing a visual representation of the data stored in the Firebase database. The dashboard refreshes every 15 minutes to ensure up-to-date information.
The dataset used in this project contains sensitive personal information and is therefore not publicly available. We are committed to protecting the privacy and confidentiality of individuals whose data is included in the dataset.
For access to the dataset or inquiries regarding data usage, please contact one of the team members or Dr. Anca Doloc-Mihu.
- Data Processing: Preprocessed the raw data collected from schools to prepare it for analysis
- Removed any duplicate or null values to ensure data quality
- Converted categorical variables into numerical formats
- Other necessary operations
- Exploratory Data Analysis: Conducted exploratory analysis to gain insights into the relationships and patterns within the dataset
- Created plots and charts to visualize distributions, correlations, and trends in the data
- Calculated summary statistics to describe the characteristics of the data
- Correlation Analysis: Investigated correlations between different variables to identify potential relationships and dependencies
- Calculated correlation coefficients to measure the strength and direction of linear relationships between pairs of variables
- Generated a correlation matrix to visualize the correlations between multiple variables simultaneously
- Regression Analysis: Conducted regression analysis to analyze the relationship between student enrollment, staff numbers, and environmental education activities
- Fitted linear regression models to explore the association between enrollment, staff numbers, and environmental education activities
- Evaluated model assumptions and checked for outliers, multicollinearity, and heteroscedasticity
- Contingency Table Analysis: Used contingency tables to analyze the relationship between outdoor spaces and composting practices in schools
- Applied chi-square tests to determine if there was a significant association between outdoor spaces and composting practices
- Examined the distribution of schools across categories of outdoor spaces and composting practices to identify patterns and trends
Result 1: The graph shows that fourth graders consume the highest amount of fruits and vegetables compared to other grades, indicating potential trends in dietary habits among different age groups.
Result 2: The contingency table reveals a clear connection between the presence of outdoor spaces and composting practices in schools. Most schools lacking composting initiatives have green areas, except for one school, suggesting a potential target for focused intervention and further research.
Result 3: The regression lines disprove the hypothesis that student enrollment significantly impacts environmental education activities, with the only positive correlation found between 'Number of Students Enrolled in School' and 'Number of Teachers and Support Staff'.
- Expand Database for Additional Inputs
- Incorporate Media File Submission
- Organize Media Files by Project Category
- Expand Dashboard with Additional Filters
More information can be found in the TODO document