umd campus pantry
play

UMD Campus Pantry Quest Group Project - BMGT438A Agenda 2 4 6 - PowerPoint PPT Presentation

UMD Campus Pantry Quest Group Project - BMGT438A Agenda 2 4 6 8 Goals and Objectives Recommendations Questions Who does the Pantry serve? Meet the Team Data Analysis Approach Trends Since 2014 Impact 1 3 5 7 2 Meet the Team


  1. UMD Campus Pantry Quest Group Project - BMGT438A

  2. Agenda 2 4 6 8 Goals and Objectives Recommendations Questions Who does the Pantry serve? Meet the Team Data Analysis Approach Trends Since 2014 Impact 1 3 5 7 2

  3. Meet the Team Christopher Mavrikes Yonatan Ferneau Marguerite Gelinas Alyssa Miller Maddie Ford

  4. Goals and Objectives 1. Find out who the Campus Pantry serves. 2. Find trends in the Campus Pantry Data. 3. Compare to the campus-wide food insecurity study. 4. Provide recommendations for tracking moving forward.

  5. 1. Data Analysis Approach

  6. Approach 1. Clean the data 2. Identify total client breakdown 3. Identify client trends since 2014 4. Group clients into clusters

  7. Data Format Excel Semesterly vs. Entered spreadsheets Yearly manually by Campus Pantry

  8. Data Collection ID Race/Ethnicity Gender UMD Affjliation (student or faculty/stafg) Full time or part time student/stafg Student classification (grad vs undergrad) Dependents (yes or no) Number of Dependents Allergies or dietary restrictions Cooking appliance access Weekly distribution attendance

  9. Data Cleaning Client did not Combine Many rows have attend any distributions by empty values distributions month Drop columns that Remove these are overwhelmingly Combine client clients because we empty, then drop distributions by do not know if they rows with empty month for used the pantry’s values standardization services

  10. 2. Who Does the Campus Pantry Serve?

  11. Study Comparison Campus-Wide Food Insecurity Study Study Data Pantry Data Undergraduate student 65.2% 61.05% Graduate student 34.8% 38.95% Female 73.9% 68.80% Male 21.7% 28.10% Other 4.3% 3.10% Asian/Asian American 39.1% 28.80% Black/African American 17.4% 33.70% Hispanic/Latino 17.4% 26.30% White 43.5% 6.70% Other 26.0% 4.50%

  12. Data Clusters Main Client Demographics (K-Mode Analysis) 66% 13% 21% Cluster Size Race/Ethnicity African Hispanic, Hispanic or American or Latino, or Asian Latino Asian Gender Female Male Female UMD Affjliation Student Faculty/Stafg Faculty/Stafg Number of 0 0 1-2 Dependents Distributions 1-3 4-6 1-3 Attended

  13. 3. Trends Since 2014

  14. Number of Clients Served

  15. Client Race/Ethnicity Hispanic or Latino Clients African-American or Black Clients k

  16. Client Race/Ethnicity Asian Clients

  17. UMD Affjliation

  18. Student Status

  19. Student Status

  20. 4. Recommendations

  21. Phase 1 Data Collection Standardization (1-2 year period) Standard information form → Reduce room for interpretation Data will become easier to analyze → More data can/should be collected

  22. Phase 1 (Example) “Please list any dietary restrictions.” Before “Please list any dietary restrictions.” After - Nuts? - Dairy? - Shellfish? - Kosher? - Gluten? - Halal? - vegetarian/vegan? - other?

  23. Phase 2 Swipe or QR Code System (2-5 year period) Work with the offjce of the registrar to use UID’s Data security is a major factor : Each user will be identified with a randomly generated ID number or last 4 digits of UID Save time and improve time-series data

  24. 5. Impact

  25. Impact: User Intake (Current Process) Start: Create Intake Form Multiple YES Choice Returning Question? Client? Client Fills out Form NO Choose accurate NO option YES Provide Users with Printed Forms Write in answer Client Fills out Retrieve Forms (End of Form Again Semester) Applicable Answer Select Option Import Complete YES Available? Data into Excel YES Accurate and Complete? NO Collect and Store NO User Submits End: Manually Input Forms Select “other” Form and Analyze all and Write in Intake Forms in Input Partial Answer Excel Data into Excel

  26. Impact: User Intake (Ideal Process) Start: Create Visit Client Makes Digital NO Automatically Account/ Fills Account Recorded in Returning out Digital Intake Form Google Sheet Client? Form Analyze Standardized YES Data on Google Sheet (End of Provide Users Client Account Info Semester) Client Swipes with Digital Form Automatically Student ID to Sign Link Inputted in Google In Sheet

  27. THANK YOU! Any questions? 27

Recommend


More recommend