Employment Background Check Guidelines: Complying with the Fair Credit Reporting Act, conducting credit background checks and running a criminal check to avoid negligent-hiring lawsuits.

Can Excel easily track nursing competencies?

Question: “I work for a rural hospital and struggle every year on the best way to track and file nursing competencies. Does anyone have any ideas on how to track nursing competencies easily by using software such as Excel?” — Tracy Fehd

 

See Comments Below



Employment Background Check Guidelines: Complying with the Fair Credit Reporting Act, conducting credit background checks and running a criminal check to avoid negligent-hiring lawsuits.


4 Responses to "Can Excel easily track nursing competencies?"

 
Fellow Admin Asst
said this on 14 Aug 2009 5:26:03 PM EST
Go to Google and search "nursing compentencies" - a lot of sites come up and you can probably find something in there to help you out and you can tailor it to your needs.

 
Lisa
said this on 17 Aug 2009 11:19:51 AM EST
For those of us who don't work in health care, you might have to explain what that consists of to get advice. Is it one score? Or one line of data? Then of course you can use excel. If it is more complicated data, you might try access or another database - you don't have to build it from scratch - you can find one of their templates that is pre-designed for a similar use.

 
Ilja Kraag
said this on 21 Aug 2009 3:55:34 PM EST
Yes, I can help you build an Excel track sheet. On the left hand side type in the names of the individuals. Type the names of each competency in a seperate column going to the right. Turn the typing vertical so the columns don't get too wide. After each individuals name put a 1 (one) in each cell for each competency she/he has. You can put in a formula to count all the numbers which shows you on a simple way how many competencies each person has.
If some competencies are valued higher than others you can add a formula to increase the value of the compentency so the end result will be higher. You can also put dates in the columns if you need to keep track of whether they have a specific competency and/or when they received this. You can tally this way horizontal and vertical. Horizontal will give you the value per individual; vertical will show you how many individuals have a specific competency.
If you need an example, email me at ilja.p.kraag@kp.org

 
Becky
said this on 25 Aug 2009 4:18:15 PM EST
Ilja, could you please send me an example of the "track" sheet?
Thanks, Becky




Leave a reply:
Your Name *: Email (private): Website:
Please copy the characters from the image below into the text field below. Doing this helps us prevent automated submissions.
Security Code: img