Springforth University (SpU) Food Bank is a collaborative initiative between Springforth University and the United Nations Educational, Scientific and Cultural Organization (UNESCO) to address food insecurity among students. This repository contains the code and resources for the web application of the SpU Food Bank.
- User-friendly web interface to register, access, and manage food bank services.
- Online food request system allowing students to request food packages based on their specific dietary needs.
- Integration with Springforth University's student database to verify student eligibility for food bank services.
- Dashboard for administrators to track food inventory, manage donations, and generate reports on food distribution and impact.
The data analysis conducted by Nafisa Lawal Idris, revealed the prevalence of food insecurity among students and its detrimental impact on academic performance. These insights informed the decision to establish the SpU Food Bank in collaboration with UNESCO.
This repository contains the code and resources for performing descriptive analysis using Excel and visualizing the data using Power BI. The analysis focuses on food insecurity and its impact on students' academic performance at Springforth University. The goal is to provide insights and recommendations for the establishment of a food bank on campus in collaboration with the United Nations Educational, Scientific and Cultural Organization (UNESCO).
data.xlsx: The Excel file containing the dataset of student responses on food insecurity and related factors.analysis.xlsx: The Excel file containing the descriptive analysis performed on the dataset, including calculations, charts, and pivot tables.report.pdf: A PDF report summarizing the key findings, insights, and recommendations derived from the analysis.visualizations.pbix: The Power BI file containing the visualizations created using the dataset to gain a deeper understanding of the data.
- Data Preparation: The dataset of student responses was collected and stored in the
data.xlsxfile. The data was cleaned and organized for analysis. - Descriptive Analysis using Excel: Excel was used to perform descriptive analysis on the dataset. Various calculations, charts, and pivot tables were created to explore the relationships between food insecurity, academic performance, and other factors. The results were documented in the
analysis.xlsxfile. - Visualization using Power BI: Power BI was employed to create interactive visualizations based on the dataset. These visualizations offer a comprehensive view of the data, allowing for deeper insights and facilitating data-driven decision-making.
- Insights and Recommendations: Based on the descriptive analysis and visualizations, key insights were derived regarding the prevalence of food insecurity, its impact on academic performance, and other factors contributing to the issue. Recommendations were formulated to justify the establishment of a food bank on campus in collaboration with UNESCO.
- Open the
data.xlsxfile to access the dataset of student responses. Update or modify the data as needed for further analysis. - Open the
analysis.xlsxfile to explore the descriptive analysis performed on the dataset using Excel. Review the calculations, charts, and pivot tables to gain insights into the relationships between variables. - Open the
visualizations.pbixfile in Power BI to interact with the visualizations created based on the dataset. Customize the visualizations or create new ones to suit your specific needs. - Refer to the
report.pdffile for a detailed summary of the analysis findings, insights, and recommendations.
Contributions to this repository are welcome. If you have any suggestions for improvements or additional analysis techniques, please feel free to open an issue or submit a pull request.
This repository is licensed under the MIT License.
