Nursing Informatics Competencies
Spreadsheet Knowledge Rubric
Name: ________________________ Self Assessment

 

Criteria
4-Always
3- Most Of The Time
2- Some Of The Time
1- Seldom

Structure:

Do you understand what the difference between rows and columns is?

       

Cells:

Can you identify and manipulate (resize, highlight) individual cells in a spreadsheet?

       

Graphs:

Can you create graphs from highlighted rows and columns?

       

Operations:

Can you mentally calculate the following? =2+2*6

       

Addition:

Do you know how to write the formula to sum a column of numbers?

       

Formula:

Do you know how to calculate the average of a row of numbers?

       

Statistics:

Do you know how to calculate a t value in Excel?

       

Text:

Do you know how to format text lists on a spreadsheet (font selection, cell width, bold, italic)?

       

Moving Columns:

Do you know how to copy a column of figures into a second column?

       

Importing:

Do you know how to merge other program documents into a spreadsheet (eg. Word, Access, visual)?

       
Add Up Overall Scores --------------->      

Total Score___________



If you score above 32 points, you probably have the skill level you need.

If you score between 20 and 30, you have some skill but need more practice.

If you score below 20, you need more training and practice.



Self Assessment Reflections
:

 

 

 

nursing-informatics.com - a professional development initiative 2000 - 2006