Quarterly Webinar: The Utility Of Process Data

Quarterly Webinar:The Utility of Process DataC H A L L E N G E F O R A H E A LT H I E R L O U I S I A N AGrant ProgramAudio is available via conference call only: 1-866-390-1828; Access Code: 778 3033Please mute your telephone when not speaking. Thank you!

AgendaEvaluation plan review1.a)b)c)What and whyCollecting and organizing the process dataUsing process data2. Examples from granteesAudio is available via conference call only: 1-866-390-1828; Access Code: 778 3033Please mute your telephone when not speaking. Thank you!

Process DataEvaluation Plan ReviewEvaluation Question1(a) - Is a farmers market up andrunning in two locations?Time FrameApril 2012 throughSeptember 20131(b) - Does the market have a steadyQuarterly review“core” group of vendors,beginning with openingdemonstrations, customers?week1(c) – is the market base (vendorsand customers) increasing overtime?1(d) – what do the vendors and thecustomers think about the market?Every 6-months, then 12month review2(a) – Are nutrition messages beingincorporated into market andmaterials and activities?On-going, beginning withopening market week2(b) – Have nutrition/healthy eatingmessages received local air-timethroughout project period?2(c) have healthy eating messagesbeen incorporated into onlinepromotion of local activities, andcalendarsIndicatorData Source/MethodInventory of number andtype of core venders;customer and purchasecounts; number of fooddemos attendees;Observation/recordreview/countsFacility, schedule, location,pricing, qualityCustomer Service SurveyNumber and types ofmessages being promotedCopies of market brochures andrecipes; observations of cookingdemos discussion; review ofrecipesNumber and types ofmessages being promotedAir time schedule and coverageareaMarch 2012 – August 2015Number and types ofmessages being promotedObservation; review of postedcopyNameDesignatedProjectEvaluationTeam Member

Process DataEvaluationQuestionTime Frame1(a) - Is a farmers marketup and running in twolocations?April 20121(b) - Does the markethave a steady “core”group of vendors,demonstrations,customers?Quarterly reviewbeginning withopening weekIndicatorDataSource/MethodInventory of number Observation/recordreview/countsand type of corevenders; customerand purchasecounts; number offood demos attendees1(c) – is the market base(vendors and customers)increasing over time?1(d) – what do thevendors and thecustomers think aboutthe market?a 6-month, 12month, thenannual reviewFacility, schedule,location, pricing,qualityCustomer ServiceSurveyResp.PartyFarmer’sMarketTeamLead

Process DataOrganizing Collectors ofDate4/6/2014LocationHoursABC Farmer’s MarketVendor NameVendor TypeABC FM Comments:SalesVendor SheetVendor CommentsDue 4/12

SiteProcess DataOrganizing & UsingTime DateVendorsDemonstrationCustomersFood Craft ales V FRW 18 18-64 65FM #1John Rd.8-12 4/6 793,000 1FM#1Jim Rd.9-26/8 832,000FM #1Joy Rd.FM #1Joy Rd.FM #1Tom Rd.FM #29-210/5 926,000 18-12 1/4 745007-11 4/5 612 2,000111 50200100CustomerSatisfactionSurvey-DemosScheduled w/Balloon Fest11 100 500200Addeddemonstrations100Increasedpress releases100 1001Notes2510025 502050Rain

Examples from GranteesC H A L L E N G E F O R A H E A LT H I E R L O U I S I A N AGrant ProgramAudio is available via conference call only: 1-866-390-1828; Access Code: 778 3033Please mute your telephone when not speaking. Thank you!

Andy Allen and Lyndsi Lambert

How you use process data Sales Data– Collected in many forms How you use it.– Track SNAP and WIC tokens– Track credit card tokens– Track Red Stick Rewards What you have learned/are learning/expect to learnfrom it.– WIC spending is low, while Senior Coupons spending is higher (perhapstiming of markets lines up better with senior demographic thanparents/families)– Participants love the Red Stick Rewards Program and the Nutrition Tentincentives

Red Stick Farmers Market(Tues-Thurs-Sat)Tokens #Credit tokens issued #SNAP tokens issued # RSR tokens issuedOther #Fresh from the Market tokens issuedIncome POS (credit/debit, EBT) Check Cash ( 1 fee, tokens) Coffee/donations Merchandise/promotional items (total)Mobile Farmers MarketNutrition TentRewards Card Program # New Reward members # Reward cards redeemedTokens # Credit tokens issued # SNAP tokens issued # RSR tokens issuedReward Member Survey DataSign-up Survey:ProduceName & “best” contact info Amount and type of products purchased from (email/phone/address)farmers [MFM manager will track] Zip codeTotal Sales1.How many fruits and vegetables do you eat POS (Credit &SNAP tokens, credit cardper week?produce sales)2.How many meals do you prepare at home? Total sales (including farmers)3.How many times a week do you exercise?Activities # Events with community partnersDot Survey Data Are you satisfied with the location, quality,schedule, etc. of the market?Quarterly Scanning Tool # of customers transportation gender # childrenCollected:Per MarketMonthlySeasonallyAnnuallyCollected:Follow-up Survey: (end of market season)1.How many fruits and vegetables do you eatper week?2.How many meals do you prepare at home?3.How many times a week do you exercise?4.What has been the most beneficial part of thenutrition tent? (Rank: recipe cards, demos,activities, etc.)5.Has shopping at the market changed yourattitude about healthy eating? How?Educational Materials # Recipe Cards distributed # Other nutrition materials distributedActivities # Events with community partners # Fitness events at market # Incentive classes for Reward membersPer Market DayMonthlySeasonallyAnnually

Central Louisiana Local Foods InitiativeCentral Louisiana EconomicDevelopment AllianceMelissa Flurry

Process Data – Farm EntrepreneurshipCoaching Tool: Web Portal and Database How we use it.– Coaches log-in online and enter coaching notes and sales information for eachclient coached– Track client progress via sales growth versus prior period and coaching notes– Track client representation geographically– Look for common training needs to develop workshops or coaching/consultantexpertise Lessons learned– In reviewing the notes, we saw that most farm clients lacked more business skillsthan anticipated– As a result, we have adapted our first steps with them. For example, rather thanstarting with Quickbooks, we’re helping them start keeping a paper, farm log first.– We are also helping them develop crop plans for their farms.

BAS DatabaseCoaching Notes

Growing LAMarianne Cufone

How you use process data Type of tool.– Brief expectations survey How you use it. Examples:– Measure participants understanding– Measure participant interests– Identify ways to improve What you have learned/are learning/expect tolearn from it. This could be in progress or anticipated.Examples:– Appropriateness of presenters.– Participants feel materials was useful and appropriate– What people would like to see in the future.

Cap i t al Ar ea Pat h w ay s Pr o j ec tPresented byBrett Wallace, Landscape Architect

How you use process data Type of tool.– Infrared trail use counter by TRAFX– Three placed strategically along thetrail. How will we use it?– Track the number of Uses of the trail.– Time stamps each use count.– Will allow us to track peak use for the following: hour of the day, day ofthe week, seasonal usage, etc What do we expect to learn from it?– What time of year sees the most use on the trail?– What days and times of day see the most use on the trail?– How do outside factors (Weather, Holidays, Special events, Etc )effectusage rates?– This data will help us to plan special events and help with the planningand fundraising process for future segments of the trail.

OUACHITA WELLPam Barton: Project DirectorName of ProjectName of grantee/presenter

The Evaluation Plan is Cornerstone

Mid Year Report Reflects the Evaluation Plan

Data Collection Continues the Reflection

Easy online tool

GeneratesaRandomList

08: Healthy Living ClubJoan B Landry

Use of Process Data Type of tool is highly dependant on the reporting practices of the partner––Spreadsheet and or Table – a spreadsheet or table snap shot of that partners process evaluation fromor from our larger process evaluation spreadsheetBrief survey – we started with taking the original spreadsheet and converting it to a survey with littlesuccess. We have attempted to put the survey into a “Survey Monkey” format but have not finalizedthis type of survey yet. If all else fails we email or call for responses directly. We use it in several ways:–––Track attendance at events, progress of meetings, planning and program movementIdentify barriers in communication and record keeping that may require action and or supportMonthly brown bag lunch meetings are often our mode of providing support for identified issues fromthe reporting tools We have learned/are learning:––––Attendance was not being recorded by demographics monthly reporting questions are now much more specificPartnering with City Parish Government is a complex relationship requires much more sit and wait time than originally planedProgress slowed in with some programs who believed they serviced our projects target population,from requiring zip code of clients, it was determined that our target population would not be reachedby this particular activity update our process evolution and number of surveys to more feasible numbersRecruitment slowed down as the newness of the project has worn off Now focusing on more media and social marketing efforts

Sample Excel/TableversionThis is what we started with and askedthat each month they respond to eachquestion (4b, etc.)IV.Breastfeeding Coalition(#9)4(a) - TrainLactationConsultants toLead Mother/BabyGet-Togethers4(b) - HostMother/Baby GetTogethers toprovide educationto mothers lead byLactationConsultants.4(c) - PurchaseBreastfeedingPumps for areaHospitals for useby NICU motherswhile they awaitWIC4(d) - PurchaseTent/Banner toprovide place forbreastfeedingmothers at publicevents4(e) - Develop andprint Signage,Billboard, andBrochures toeducate the publicon health benefitsof breastfeeding.4(a) - Lactationconsultantstrained to leadMother/Baby Gettogethers4(b) - Secured sitefor Mother/Babyget-togethers4(c) - Localhospitals haveBreastfeedingpumps availablefor NICU mothersawaiting WIC4(d) - Tent/Bannerdisplayed atpublic events fordesignatedbreastfeedingareas.4(e) - Communityis provided withinformation onthe healthbenefits ofbreastfeeding formother and babyMother/BabyGet-Togethershosted in thecommunity toprovideeducation tobreastfeedingmothers.NICU mothersreceiving WIChave earlieraccess toBreastfeedingpumpsDesignatedareas at publicevents forbreastfeedingmothersEducation to thecommunity onthe healthbenefits ofbreastfeeding tomother andbaby

Project 10 GRoWKyle Hucke PhD

How we use process data Type of tool.– Fidelity Monitoring Form How you use it.– Assure quality classes at GRoW– Engage College age volunteers– Provide feedback to our providers What you have learned/are learning/expect tolearn from it.– We will use it to track our promotion of the healthy challenges– We will track trends in class usage (gender or age)– We have learned that by keeping the form simple we can get newvolunteers started right away with minimal training

GRoW Fidelity Monitoring ToolWrite InInstructorName:ActivityDescription:Activity 1No.MalesNo.FemalesAgeGroupNumber 10 10M:F:Total: 10Was thedietaryhealthychallengementioned duringthisactivity?(Tallyeachinstance)Was thephysicalactivityhealthychallengementioned duringthisactivity?(Tallyeachinstance)Describe Physical Activity ExerciseEg. Slow to Mod. SMPAorMod to Vigor. MVPATime Record:If a physicalactivity, recordstart, end, totalTime. If healthyeating activityrecord start, end,and total time ofnutritioninstructionB:E: 10Total:Was thefacilitatorPrepared?Did theycoordinatelessons?Have materialsneeded.Wereyouthengaged?