Category
7: Spreadsheets
|
Urban
Dreams Teachers
N=68 |
Non
Urban Dreams Teachers N=45 |
||||||
|
Yes |
%
Yes |
No |
%
No |
Yes |
%
Yes |
No |
%
No |
|
|
General Knowledge and
Skills |
|
|
|
|
|
|
|
|
|
I
can define spreadsheet terms (i.e. cells, alignment, formula, etc). |
38 |
55.9 |
30 |
44.1 |
26 |
57.8 |
19 |
42.2 |
|
I
know how to create, open, and save a spreadsheet. |
42 |
61.8 |
26 |
38.2 |
24 |
53.3 |
21 |
46.7 |
|
I
know how to navigate using the mouse and tabs. |
47 |
69.1 |
21 |
30.9 |
25 |
55.6 |
20 |
44.4 |
|
I
know how to undo unwanted changes. |
45 |
66.2 |
23 |
33.8 |
26 |
57.8 |
19 |
42.2 |
|
I
know how to move or copy sheets between spreadsheet files. |
30 |
44.1 |
38 |
55.9 |
15 |
33.3 |
30 |
66.7 |
|
I
know how to locate cells based on column/row addresses. |
42 |
61.8 |
26 |
38.2 |
24 |
53.3 |
21 |
46.7 |
|
I
know how to select, move, copy, delete, clear and insert cells. |
40 |
58.8 |
28 |
41.2 |
27 |
60.0 |
18 |
40.0 |
|
I
know how to change typeface, font size and other cell attributes. |
37 |
54.4 |
31 |
45.6 |
21 |
46.7 |
24 |
53.3 |
|
I
know how to sort cells. |
28 |
41.2 |
40 |
58.8 |
17 |
37.8 |
28 |
62.2 |
|
I
know how to replicate a formula or range of cells (i.e.
"fill"). |
24 |
35.3 |
44 |
64.7 |
17 |
37.8 |
28 |
62.2 |
|
I
know how to align and rotate text and numbers within a cell. |
23 |
33.8 |
45 |
66.2 |
15 |
33.3 |
30 |
66.7 |
|
I
know how to create simple bar or pie charts, create a variety of charts
and label graphs appropriately. |
31 |
45.6 |
37 |
54.4 |
17 |
37.8 |
28 |
62.2 |
|
I
know how to select charts for appropriate data representation. |
29 |
42.6 |
39 |
57.4 |
17 |
37.8 |
28 |
62.2 |
|
I
know how to change size, placement, and title of charts. |
27 |
39.7 |
41 |
60.3 |
15 |
33.3 |
30 |
66.7 |
|
I
know how to import/export charts and data into other applications (i.e.
word processing, etc). |
23 |
33.8 |
45 |
66.2 |
13 |
28.9 |
32 |
71.1 |
|
I
know how to select an entire column or row. |
43 |
63.2 |
25 |
36.8 |
26 |
57.8 |
19 |
42.2 |
|
I
know how to resize cells and rows. |
38 |
55.9 |
30 |
44.1 |
23 |
51.1 |
22 |
48.9 |
|
I
know how to add shading and borders. |
35 |
51.5 |
33 |
48.5 |
19 |
42.2 |
26 |
57.8 |
|
I
know how to change text cell alignment and justification. |
27 |
39.7 |
41 |
60.3 |
14 |
31.1 |
31 |
68.9 |
|
I
know how to save in a variety of formats (i.e. Tab Delimited, CSV, DBF,
DIF, SYLK, etc). |
15 |
22.1 |
53 |
77.9 |
6 |
13.3 |
39 |
86.7 |
|
Manage Records |
|
|
|
|
|
|
|
|
|
I
know how to enter text and data into specific cells. |
45 |
66.2 |
23 |
33.8 |
26 |
57.8 |
19 |
42.2 |
|
I
know how to create formula cells (i.e. sums, average, etc). |
26 |
38.2 |
42 |
61.8 |
||||