CURRICULUM MAP: 10264.map

Advanced Computer Applications (SCP) 615
Unit--Excel

TIME FRAME: 8 Weeks
GRADE: 9-12
CONTACT:

         MAP LEVEL: 2

12.0 BUSINESS EDUCATION --- 12.0.5.9.1 --- 12.0.5.9.2 --- 12.0.5.9.3 --- 12.0.5.9.5 --- 12.0.8.9.5 --- 12.0.8.9.6
04.2 LRIT - COMPUTER TECHNOLOGY --- 04.2.1.9.2 --- 04.2.3.9.1 --- 04.2.5.9.7 --- 04.2.5.9.9 --- 04.2.3.9.3



1. How do you choose and apply effective Excel features for increased productivity?
2. How do you input technologies appropriately and accurately to enter and manipulate text and data?
3. How do you apply Excel features to solve mathematical problems, analyze and interpret data, and apply sound decision-making skills?




1. Excel basics.
2. Changing the appearance of a worksheet
3. Organizing the worksheet
4. Worksheet formulas
5. Function formulas
6. Making the worksheet useful
7. Working with multiple worksheets
8. Worksheet charts



Students will be able to:
1. Enter and edit data, save and print.
2. Change appearance of the worksheet for function, use, appeal.
3. Copy/move data, insert/delete columns/rows, freeze headings, protect worksheets.
4. Create formulas and perform calculations.
5. Create templates, cell comments, format painter, sort, filter, insert pictures.
6. Work with more than one worksheet in a workbook.
7. Create a variety of charts from data contained in a worksheet .




1. Students will realize that knowledge and mastery of specific hardware or software skills are not the end-goals of information technology courses.
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.

(National Standards for Business Education, 2001)



1. Teacher-led/student-created step-by-step activities w/computer LCD projector
2. Projects.
3. Critical thinking activities.
4. Sam and Tom (on-line tutorial and test).




1. Templates (Student Data Files).
2. Textbook/Workbooks.
3. On-line/networked tutorial and testing.
4. Teacher-created projects.




Students may opt to test into this course to fulfill the technology graduation requirement in place of Foundations of Technology.