TEACHER:  Barry Specter         Steel Valley School District        DATE SUBMITTED : 1/21/11    RECEIVED : __________

CLASS/SUBJECT:    Computers/Computer Literacy            SECONDARY (9-12)                          FOR WEEK OF:     1/31/11 – 2/4/11

180 DAY PLAN DAY

DAY

DATE

DAY

DATE

DAY

DATE

DAY

DATE

DAY

DATE

NUMBER/DATE

99

1/31

100

2/1

101

2/2

102

2/3

103

2/4

TOPIC

Microsoft Word

Microsoft Excel Intro

Microsoft Excel

Microsoft Excel

Microsoft Excel

 

OBJECTIVE(S)

 

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

 

      Properly proof read a document and make corrections.

 

      Explain what a speadsheet is and what it can do

      Set up a simple spreadsheet and enter formulas.

      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.

 

 

PROCEDURES / TECHNIQUES

 

To reach objectives

 

 

      Students will be given some hints, then access to a document to proof read and correct.

      Teacher will present VIA PowerPoint.

      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.

 

RESOURCES

(Text/Materials)

 

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 participation and their ability to do the 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 directions and complete the exercise.

      Pay attention, take notes and participate in discussions.

      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

 

Complete the practice exercise.

 

 

 

ADDITIONAL NOTES:

Word 2

Practice Exercise

Excel Exercise 1

Excel Exercise 1

Excel Exercise 2

STATE STANDARDS

3.7.12.D

3.7.12.D

3.7.12.D

3.7.12.D

3.7.12.D