Title of Material: Recommended Approval _____ yes _____no
Author:
Publisher:
ISBN #:
Reviewer:
Correlation Percentage to course requirements:
Spreadsheet = 76 Points
(Number of Yes checks divided by 76 = percentage)
Idaho Professional-Technical Education
Business, Marketing and Computer Applications
Spreadsheet
Course Requirements
Grades 9 - 12
Spring 2008
COMPATIBILITY WITH PROFESSIONAL-TECHNICAL EDUCATION – BUSINESS OFFICE MARKETING TECHNOLOGY CONTENT REQUIREMENTS
SPREADSHEET
Skills and Knowledge Comments YES NO
1. Access spreadsheet software Indicate Page No.
2. Remove cell contents Indicate Page No.
3. Use auto complete function Indicate Page No.
4. Insert borders Indicate Page No.
5. Label chart rows Indicate Page No.
6. Recognize an active cell Indicate Page No.
7. Create formulas Indicate Page No.
8. Use auto fill function Indicate Page No.
9. Remove borders Indicate Page No.
10. Place as a new sheet a chart Indicate Page No.
11. Identify spreadsheet screen parts Indicate Page No.
Spring 2008 page 1 of 7
COMPATIBILITY WITH PROFESSIONAL-TECHNICAL EDUCATION – BUSINESS OFFICE MARKETING TECHNOLOGY CONTENT REQUIREMENTS
SPREADSHEET
Skills and Knowledge Comments YES NO
12. Edit cell contents Indicate Page No.
13. Use select all button Indicate Page No.
14. Change type of chart Indicate Page No.
15. Place as an object in a sheet a chart Indicate Page No.
16. Use all movement keys in a spreadsheet Indicate Page No.
17. Adjust column widths Indicate Page No.
18. Edit in the formula bar mistakes Indicate Page No.
19. Use color fill button Indicate Page No.
20. Use the current date function Indicate Page No.
21. Move cell insertion point Indicate Page No.
22. Enter labels Indicate Page No.
Spring 2008 page 2 of 7
COMPATIBILITY WITH PROFESSIONAL-TECHNICAL EDUCATION – BUSINESS OFFICE MARKETING TECHNOLOGY CONTENT REQUIREMENTS
SPREADSHEET
Skills and Knowledge Comments YES NO
23. Use currency formatting button Indicate Page No.
24. Label X axis Indicate Page No.
25. Identify column labels Indicate Page No.
26. Use numeric labels Indicate Page No.
27. Sort data Indicate Page No.
28. Label Y axis Indicate Page No.
29. Select range of cells Indicate Page No.
30. Set column size Indicate Page No.
31. Use best fit option Indicate Page No.
32. Label chart columns Indicate Page No.
33. Select single cell Indicate Page No.
Spring 2008 page 3 of 7
COMPATIBILITY WITH PROFESSIONAL-TECHNICAL EDUCATION – BUSINESS OFFICE MARKETING TECHNOLOGY CONTENT REQUIREMENTS
SPREADSHEET
Skills and Knowledge Comments YES NO
34. Define the term range Indicate Page No.
35. Center horizontally spreadsheet Indicate Page No.
36. Use decrease decimal button Indicate Page No.
37. Select entire data areas Indicate Page No.
38. Format cell or a range of text Indicate Page No.
39. Center vertically the spreadsheet Indicate Page No.
40. Use increase decimal button Indicate Page No.
41. Define spreadsheet vocabulary Indicate Page No.
42. Change to landscape print orientation Indicate Page No.
43. Use absolute formulas Indicate Page No.
44. Select entire columns Indicate Page No.
Spring 2008 page 4 of 7
COMPATIBILITY WITH PROFESSIONAL-TECHNICAL EDUCATION – BUSINESS OFFICE MARKETING TECHNOLOGY CONTENT REQUIREMENTS
SPREADSHEET
Skills and Knowledge Comments YES NO
45. Insert deleted cells Indicate Page No.
46. Create data series Indicate Page No.
47. Select entire rows Indicate Page No.
48. Insert new cells Indicate Page No.
49. Develop data for doing payroll Indicate Page No.
50. Utilize horizontal scroll bars Indicate Page No.
51. Insert deleted rows Indicate Page No.
52. Utilize vertical scroll bars Indicate Page No.
53. Insert deleted columns Indicate Page No.
54. Use paste function Indicate Page No.
55. Merge cells Indicate Page No.
Spring 2008 page 5 of 7
COMPATIBILITY WITH PROFESSIONAL-TECHNICAL EDUCATION – BUSINESS OFFICE MARKETING TECHNOLOGY CONTENT REQUIREMENTS
SPREADSHEET
Skills and Knowledge Comments YES NO
56. Use cut or copy function Indicate Page No.
57. Copy formulas Indicate Page No.
58. Identify row labels Indicate Page No.
59. Cut and paste formulas Indicate Page No.
60. Adjust row widths Indicate Page No.
61. Use automatic adding function Indicate Page No.
62. Enter values Indicate Page No.
63. Enter values Indicate Page No.
64. Use relative formulas Indicate Page No.
65. Show gridlines Indicate Page No.
66. Show on the worksheet gridelines Indicate Page No.
Spring 2008 page 6 of 7
COMPATIBILITY WITH PROFESSIONAL-TECHNICAL EDUCATION – BUSINESS OFFICE MARKETING TECHNOLOGY CONTENT REQUIREMENTS
SPREADSHEET
Skills and Knowledge Comments YES NO
67. Change margins Indicate Page No.
68.Show in printing the worksheet the row and column Indicate Page No.
headings
69. Use text wrap option Indicate Page No.
70. Print spreadsheet page Indicate Page No.
71. Change to portrait print option Indicate Page No.
72. Utilize print preview Indicate Page No.
73.Set row size Indicate Page No.
74. Print whole spreadsheet Indicate Page No.
75. print partial spreadsheet Indicate Page No.
76. Create new worksheet Indicate Page No.
Spring 2008 page 7 of 7