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 -- Students will apply basic mathematical operations to solve problems

12.0.5.9.2 -- Students will solve problems involving whole numbers, decimals, fractions, percents, ratios, averages, and proportions.

12.0.5.9.3 -- Students will use algebraic operations to solve problems.

12.0.5.9.5 -- Students will analyze and interpret data using common statistical procedures.

12.0.8.9.5 -- Students will identify, evaluate, select, install, use, upgrade, and customize application software; diagnose and solve problems resulting from an application software’s installation and use.

12.0.8.9.6 -- Students will use input technologies appropriately to enter and manipulate text and data.

04.2 LRIT - COMPUTER TECHNOLOGY

04.2.1.9.2 -- Students will produce a variety of products using the advanced features of personal productivity software

04.2.3.9.1 -- Students will use technology tools and resources for managing and communicating personal/professional information

04.2.5.9.7 -- Students will demonstrate the ability to solve problems by collecting, analyzing and interpreting data through the use of data management software (databases, spreadsheets, etc.)

04.2.5.9.9 -- Students will use technology tools to generate findings and organize results for presentation

04.2.3.9.3 -- Students will create written, oral, numeric and visual communications using appropriate applications (spreadsheet, database, hypermedia, etc.) to construct, organize, and analyze and interpret ideas and data, and present conclusion



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.