TEACHER:  Barry Specter         Steel Valley School District        DATE SUBMITTED : 9/11/10    RECEIVED : __________

CLASS/SUBJECT:    Computers  All                                       SECONDARY (9-12)                          FOR WEEK OF:     9/13/10 – 9/17/10

180 DAY PLAN DAY

DAY

DATE

DAY

DATE

DAY

DATE

DAY

DATE

DAY

DATE

NUMBER/DATE

12

9/13

13

9/14

14

9/15

15

9/16

16

9/17

TOPIC

Microsoft Excel

Microsoft Excel

Microsoft Excel

Microsoft Excel

Microsoft Excel

 

OBJECTIVE(S)

 

At the end of the lesson each student should be able to:

 

      Enter data into a spreadsheet.

      Enter formulas for addition, subraction and averages into a spreadsheet.

 

      Enter data into a spreadsheet.

      Enter formulas for addition, subraction and averages into a spreadsheet.

 

      Create a spreadsheet from written directions.

      Enter formulas for addition, subraction and averages into a spreadsheet.

 

      Create a spreadsheet from written directions.

      Enter formulas for addition, subraction and averages into a spreadsheet.

 

      Multiplication in a spreadsheet

      Insert rows

      Percentages in worksheets

      Create a Pie Chart

 

PROCEDURES / TECHNIQUES

 

To reach objectives

 

 

      Students will work on their own, following written instructions.

      Student will practice the skills on their computers.

      Students will work on their own, following written instructions.

      Student will practice the skills on their computers.

      Students will work on their own, following written instructions.

      Student will practice the skills on their computers.

      Students will work on their own, following written instructions.

      Student will practice the skills on their computers.

      Students will work together, following the demo.

      Student will practice the skills on their computers.

 

RESOURCES

(Text/Materials)

 

LCD projector and screen.

Computers, Apple System 10 operating system, student accounts, Microsoft Office

LCD projector and screen.

Computers, Apple System 10 operating system, student accounts, Microsoft Office

LCD projector and screen.

Computers, Apple System 10 operating system, student accounts, Microsoft Office

LCD projector and screen.

Computers, Apple System 10 operating system, student accounts, Microsoft Office

LCD projector and screen.

Computers, Apple System 10 operating system, student accounts, Microsoft Office

HOW AND WHEN WILL

OBJECTIVE(S) BE EVALUATED

 

 

 

      Students will be evaluated by their completed exercise.

      Students will be evaluated by their completed exercise.

      Students will be evaluated by their completed exercise.

      Students will be evaluated by their completed exercise.

      Students will be evaluated by their completed exercise.

STUDENT ACTION

 

During this class, students

will be expected to:

 

      Follow the written directions and complete the exercise.

      Follow the written directions and complete the exercise.

      Follow the written directions and complete the exercise.

      Follow the written directions and complete the exercise.

      Follow the written directions and complete the exercise.

HOMEWORK ASSIGNMENT

 

 

 

 

 

ADDITIONAL NOTES:

Excel Exercise 1

Excel Exercise 1

Excel Exercise 2

Excel Exercise 2

Excel Exercise 3a

STATE STANDARDS

3.7.12.D

3.7.12.D

3.7.12.D

3.7.12.D

3.7.12.D