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