Spread Sheets, not bed sheets!

[RN_Rabbit]

Can anyone recommend a good online class, book, video, etc.that teaches how to extract healthcare data, and put it into Excel? We must build scorecards for different measures in our hospital, and I need some assistance with data abstraction,building scorecards, making spreadsheets, interpreting and graphing data, and then explaining the results to the safety and quality committees. Thank you in advance for your suggestions!

[delphine22]

I can't really recommend a particular book because the spreadsheets are 100% what you make them.

The point of the spreadsheet is to take all those different random points of "data" so you can turn that data into "information," something your colleagues can use and act upon.

Besides dashboards provided to me by my corporate overlords, from which I can download large raw data Excel files, I make my own sheets for concurrent review. I only include what I need to know -- and as the months have gone on and priorities have shifted I've added and removed columns when I realized I needed certain data I wasn't collecting. I get my data from going into the EMR every single day. There are some reports that can pull the info I need but a lot of it is just digging.

Any Excel Dummies book or online site can show you how to quickly make a pretty chart out of your data. I pull the data out separately and make it into some rows and columns, then highlight them all and right click to select which chart or graph I need. Then it's easy to play with colors and styles.

[K+MgSO4, BSN]

Do you have a business intelligence unit?

These are the people you need to talk to....

[Double-Helix, BSN, RN]

IHI (Institute for Healthcare Improvement) Open School has some great modules. Some are free, some are not. If you work in a hospital they may already have a log-in you can use, or have the resources to purchase one.