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

18

40.0

27

60.0

I know how to format cells for appropriate content (i.e. text, decimal alignment, currency, etc.).

26

38.2

42

61.8

17

37.8

28

62.2

I utilize grade book templates.

26

38.2

42

61.8

10

22.2

35

77.8

I maintain student records in a spreadsheet.

28

41.2

40

58.8

9

20.0

36

80.0

Communication through Printed Media

I know how to adjust layout and margins.

33

48.5

35

51.5

23

51.1

22

48.9

I know how to use print preview and print document with title.

45

66.2

23

33.8

25

55.6

20

44.4

I know how to set up print options for grid lines, zoom, etc.

28

41.2

40

58.8

17

37.8

28

62.2

I know how to create and edit headers, footers, and page numbers.

34

50.0

34

50.0

18

40.0

27

60.0

I know how to change page margins.

36

52.9

32

47.1

20

44.4

25

55.6

I know how to search for and replace text within a document.

32

47.1

36

52.9

17

37.8

28

62.2

I know how to print a specific range of cells, pages, and sheets.

30

44.1

38

55.9

15

33.3

30

66.7

I import/export charts and data into a word processing application.

22

32.4

46

67.6

9

20.0

36

80.0

Integration, Student Learning, and Classroom Management

I can describe the educational uses of spreadsheets.

36

52.9

32

47.1

19

42.2

26

57.8

I occasionally create new spreadsheets related to content area.

16

23.5

52

76.5

10

22.2

35

77.8

I regularly design curricular lessons requiring use of spreadsheets.

6

8.8

62

91.2

4

8.9

41

91.1

I regularly create appropriate charts for a content lesson.

8

11.8

60

88.2

2

4.4

43

95.6

Mean

30.8

45.3%

37.2

54.7%

17.5

38.8%

27.5

61.2%