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

CLASS/SUBJECT:    Computers/Computer Literacy            SECONDARY (9-12)                          FOR WEEK OF:     9/20/10 – 9/24/10

180 DAY PLAN DAY

DAY

DATE

DAY

DATE

DAY

DATE

DAY

DATE

DAY

DATE

NUMBER/DATE

17

9/20

18

9/21

19

9/22

20

9/23

21

9/24

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:

 

      Modification of a spreadsheet

      Insert rows

      Merge and centering titles

      Editing formulas

      Modification of a spreadsheet

      Insert rows

      Merge and centering titles

      Editing formulas

      Multiplcation in a spreadsheet

      Percentages in a spreadsheet

      Insert rows into a spreadsheet

      Multiplcation in a spreadsheet

      Percentages in a spreadsheet

      Insert rows into a spreadsheet

      Multiplcation in a spreadsheet

      Percentages in a spreadsheet

      Insert rows into a spreadsheet

 

PROCEDURES / TECHNIQUES

 

To reach objectives

 

 

      Students will work together, following the demo.

      Student will practice the skills on their computers.

      Students will work together, following the demo.

      Student will practice the skills on their computers.

      Students will demonstrate their skills on their computers

      Students will demonstrate their skills on their computers

      Students will demonstrate their 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 spreadsheet

      Students will be evaluated by their completed spreadsheet

      Students will be evaluated by their completed spreadsheet

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.

      Focus on their spreadsheet. Complete their practical, print and copy the file to the student server.

      Focus on their spreadsheet. Complete their practical, print and copy the file to the student server.

      Focus on their spreadsheet. Complete their practical, print and copy the file to the student server.

HOMEWORK ASSIGNMENT

 

 

 

 

 

ADDITIONAL NOTES:

Excel Exercise 3b

Excel Exercise 3b

Excel Exercise 4 - Practical

Excel Exercise 4 - Practical

Excel Exercise 4 - Practical

STATE STANDARDS

3.7.12.D

3.7.12.D

3.7.12.D

M11.A.1.2

3.7.12.D

M11.A.1.2

3.7.12.D

M11.A.1.2