100 10264 120 Advanced Computer Applications (SCP) 615 130 Unit--Excel 140 8 Weeks 150 9-12 160 170 2 180 210 12.0 Business Education 211 5.9.1 212 5.9.2 213 5.9.3 214 5.9.5 215 8.9.5 216 8.9.6 220 04.2 LRIT - Computer Technology 221 1.9.2 222 3.9.1 223 5.9.7 224 5.9.9 225 3.9.3 226 230 231 232 233 234 235 236 240 241 242 243 244 245 246 250 251 252 253 254 255 256 300 1. How do you choose and apply effective Excel features for increased productivity? 300 2. How do you input technologies appropriately and accurately to enter and manipulate text and data? 300 3. How do you apply Excel features to solve mathematical problems, analyze and interpret data, and apply sound decision-making skills? 300 400 1. Excel basics. 400 2. Changing the appearance of a worksheet 400 3. Organizing the worksheet 400 4. Worksheet formulas 400 5. Function formulas 400 6. Making the worksheet useful 400 7. Working with multiple worksheets 400 8. Worksheet charts 500 Students will be able to: 500 1. Enter and edit data, save and print. 500 2. Change appearance of the worksheet for function, use, appeal. 500 3. Copy/move data, insert/delete columns/rows, freeze headings, protect worksheets. 500 4. Create formulas and perform calculations. 500 5. Create templates, cell comments, format painter, sort, filter, insert pictures. 500 6. Work with more than one worksheet in a workbook. 500 7. Create a variety of charts from data contained in a worksheet . 500 600 1. Students will realize that knowledge and mastery of specific hardware or software skills are not the end-goals of information technology courses. 600 2. Students will develop the ability to analyze, synthesize, and evaluate situations at home, school, or work and then apply technology to solve problems and complete tasks effectively and efficiently. 600 600 (National Standards for Business Education, 2001) 700 1. Teacher-led/student-created step-by-step activities w/computer LCD projector 700 2. Projects. 700 3. Critical thinking activities. 700 4. Sam and Tom (on-line tutorial and test). 700 820 1. Templates (Student Data Files). 820 2. Textbook/Workbooks. 820 3. On-line/networked tutorial and testing. 820 4. Teacher-created projects. 820 840 Students may opt to test into this course to fulfill the technology graduation requirement in place of Foundations of Technology.