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 ---------------> |
|
|
|
|