{"product_id":"activity-participation-tracker-for-activity-directors-excel-and-google-sheets-resident-participation-log-nursing-home","title":"Activity Participation Tracker for Activity Directors, Excel and Google Sheets, Resident Participation Log, Nursing Home","description":"\u003cp\u003eAn Activity Participation Tracker for activity directors and life enrichment staff in nursing homes, assisted living and memory care. Log each activity once, and the spreadsheet builds your monthly totals, a year-long participation table for every resident, low-participation alerts, and a one-page report you can print for any resident. One .xlsx file works in Excel and in Google Sheets.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eHOW IT WORKS\u003c\/strong\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eLog by activity, not by person. One row is one session: pick the date and the activity, then pick a code under each resident who took part.\u003c\/li\u003e\n\u003cli\u003eFour codes: Active, Passive, Declined, Unavailable. Leave a resident blank if they did not attend.\u003c\/li\u003e\n\u003cli\u003eSummary sheet fills in by itself: monthly sessions and attendance with a chart, totals by category, every resident by month with participation percent and attendance per week, and every activity by month.\u003c\/li\u003e\n\u003cli\u003eResident Report: pick a name in one cell and the report fills in. It shows the year month by month against the facility average, attendance by category, the top 5 activities and recent notes. It prints on one US Letter page.\u003c\/li\u003e\n\u003cli\u003eAlerts you control: a resident is flagged when attendance falls below a percent of the facility average (you set it, default 50 percent) or when nothing has been logged for a number of days (you set it, default 14). Alerts are a prompt to look closer, not a judgment. The four codes and the alert rules are settings of this tool, not a CMS standard.\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003e\u003cstrong\u003eWHAT IS INSIDE\u003c\/strong\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eOne zip file with the tracker (.xlsx, six sheets: Instructions, Setup, Activity Log, Notes, Summary and Resident Report), the practice file, and the two PDFs\u003c\/li\u003e\n\u003cli\u003eRoom for 100 residents, 60 activities and 1,500 logged sessions in one year\u003c\/li\u003e\n\u003cli\u003eYour own activity list (up to 60 activities, you type them in), with a category for each\u003c\/li\u003e\n\u003cli\u003eCategories follow the eight activity topics of MDS 3.0 item F0500 (Interview for Activity Preferences), plus Other. Session formats follow 42 CFR 483.24(c)(1): group, individual and independent activities. Sources are named on the Instructions sheet\u003c\/li\u003e\n\u003cli\u003eEditable lists for session format, categories, staff and resident status, and an optional cognition note for each resident\u003c\/li\u003e\n\u003cli\u003eOptional Notes sheet for a mood change, a refusal or a family comment\u003c\/li\u003e\n\u003cli\u003eA filled-in practice file with 30 fictional residents and fictional activities, so you can see how it works before you start your own\u003c\/li\u003e\n\u003cli\u003eA Start Here page and a Read Me First PDF\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003e\u003cstrong\u003eONE FILE PER YEAR\u003c\/strong\u003e\u003c\/p\u003e\u003cp\u003eYou keep one file for the year, not 31 sheets for every month. Change the report year on Setup, save a copy, and you are ready for the next year. Steps are on the Instructions sheet.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eEXCEL AND GOOGLE SHEETS\u003c\/strong\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eExcel 2016 or newer, Windows or Mac: open the .xlsx.\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets: upload the .xlsx to Google Drive and open it with Google Sheets. Formulas, dropdowns and colors carry over.\u003c\/li\u003e\n\u003cli\u003eNo macros and no add-ons. Plain formulas only.\u003c\/li\u003e\n\u003cli\u003eExcel keeps the sheet protection on Summary and Resident Report. Google Sheets does not keep sheet protection, so do not type over the grey formula cells there. In Sheets, choose Fit to page when you print the Resident Report.\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003e\u003cstrong\u003eGOOD TO KNOW\u003c\/strong\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eDigital download. No physical item is shipped.\u003c\/li\u003e\n\u003cli\u003eThis is a record-keeping tool for your own activity records. It is not medical or legal advice, and it does not guarantee that any survey or audit will be passed. Follow your facility policy.\u003c\/li\u003e\n\u003cli\u003eUse a first name with an initial, or a resident ID, if your policy asks for it.\u003c\/li\u003e\n\u003cli\u003eOne purchase is for one facility location. Do not resell, share or upload the file.\u003c\/li\u003e\n\u003cli\u003eAttendance is stored by column position, so do not delete or re-order resident rows on Setup after you start logging.\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eQuestions? Send us a message where you purchased.\u003c\/p\u003e","brand":"BeingBrightStudio","offers":[{"title":"Default Title","offer_id":67967163433235,"sku":null,"price":8.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0978\/8732\/2387\/files\/mgNSOESIVy.jpg?v=1794121878","url":"https:\/\/www.activitydirectorspayactivitydirectors.com\/products\/activity-participation-tracker-for-activity-directors-excel-and-google-sheets-resident-participation-log-nursing-home","provider":"Activity Directors Pay Activity Directors","version":"1.0","type":"link"}