Our nurse would like to have some summary statistic reports available. For instance, she would like to know how many visits she has had for this school year by grade level. I pulled the Medical Visit Worklist and did a quick pivot table for her with these stats, but pulling a pivot table is beyond our nurse's computer skills. I would think she may also like to see a frequency graph....i.e. time of day by grade that come into the clinic, or high frequency dates of clinic visits.
The ability to do summary reporting at both the school/division and at the child level is important. Our nurse is asked for a summary for a specific child for various reasons, and it is not easy to get a report of a child's visits. I worked with her to get a Work List together, but we had to filter it in Excel for the specific child. Excel doesn't print up well for somethings, so we then had to do a mail merge. She should not have to outreach to me each time she needs a medical visit report.
I would like to be able to run reports and pull graphs on various data points. Specifically, I would like to look at trends in office visits – so a scatterplot or line graph of office visit dates (x axis would be dates, y axis would be # of visits). This would tell me, for example, which days of the week tend to be busiest, which time of the month are busiest, and are there any trends (like are there more or less visits before or after breaks or long weekends), etc.
Currently, the only way to do this through Blackbaud Medical (Nurse's Office view) making a “medical list” and export that as an excel sheet and trying to graph off of that. However, the dates from Blackbaud export to excel in a way that is incompatible with graphing, so essentially I have to retype each date.
This feature would be valuable in helping to better arrange our academic calendar and determine breaks, would help with staffing and supply ordering schedules, and would be helpful for Nursing staff to identify periods that could use some more preventative health promotion interventions. Please let me know what you think. Thanks, Jackie Martin, School RN