Week 6 / 16 WEEKLY LESSON PLAN OVERVIEW
Date: April 27 – May 1
Topic/concepts to be covered this week:
Students will use the Microsoft Works Database to set up and manipulate a
database.
Objective(s) related to the topics:
3.b, 3.c, 3.d
Students will understand terms associated with a database and recognize its uses.
Method of Teaching:
(checked)
[ ] Audiovisual [x] Interactive
[x] Discussion [x] Reading/Comprehension
[x] Lecture [x] Large group
[ ] Small group [x] Other - Demonstration - hands on computer
Date of Evaluation:
Hands on Test grade next Friday from all printouts.
SUMMARY OF OBJECTIVES AND POSSIBLE HOMEWORK ASSIGNMENTS:
Monday:
Define the structure, enter data, search, sort, and print database according
to given specifications.
Tuesday:
Define the structure, enter data, search, sort, and print database according
to given specifications.
Wednesday:
Define the structure, enter data, search, sort, and print database according
to given specifications.
Thursday:
Define the structure, enter data, search, sort, and print database according
to given specifications.
Friday:
Project Due.
Week 5 / 15 WEEKLY LESSON PLAN OVERVIEW
Date: April 20 - 24
Topic/concepts to be covered this week:
Students will use the Microsoft Works Database to set up and manipulate a
database.
Objective(s) related to the topic:
3.b, 3.c, 3.d
Students will understand terms associated with a database and recognize
its uses.
Method of Teaching:
(checked)
[ ] Audiovisual [x] Interactive
[x] Discussion [x] Reading/Comprehension
[x] Lecture [x] Large group
[ ] Small group [x] Other - Demonstration - hands on computer
Date of Evaluation:
Daily participation grades for taking notes, staying on task and following
instructions.
Written Test (60 points) Tuesday.
Hands on Quiz grade Wednesday.
Hands on Test (40 points) Friday
SUMMARY OF OBJECTIVES AND POSSIBLE HOMEWORK ASSIGNMENTS:
Monday:
Complete Baseball Cards.
Hand back Quiz and review for Test.
Tuesday:
Written Test (60 points)
Hands on Quiz
Wednesday:
Complete Hands on Quiz
Thursday: Progress Reports go home.
Complete all databases.
Hand out and discuss Access Project that will be a major test grade.
Begin the project. Due May 1.
Friday: Hands on Test (40 points)
Work on Project
Long - Term Assignments
Be preparing a list on 10 people with the following information about each:
Name, address, Phone #, Favorite food, Favorite color, number of siblings,
birthday.
Week 4 / 14 WEEKLY LESSON PLAN OVERVIEW
Subject:
Computer Applications
Teacher:
Lunceford
Date:
April 13 - 17
Topic/concepts to be covered this week:
Students will use the Microsoft Works Access to set up, manipulate, and print
a database.
Objective(s) related to the topic:
3.a, 3.b, 3.c, 3.d
Students will understand terms associated with a database, recognize its uses,
and design and manipulate a database.
Method of Teaching:
[ ] Audiovisual [x] Interactive
[x] Discussion [x] Reading/Comprehension
[x] Lecture [x] Large group
[ ] Small group [x] Other - Demonstration - hands on computer
Date of Evaluation:
Daily participation grades for taking notes, staying on task and following
instructions.
Printout grades will add up to a major grade.
Written Test - Friday
SUMMARY OF OBJECTIVES AND POSSIBLE HOMEWORK ASSIGNMENTS:
Monday:
Give back and discuss Quiz
Complete “Singers”database
Discuss “Car” and “Baseball Cards” databases
Tuesday:
Begin “Baseball Cards” database
Wednesday: Give back and discuss “Singers” database
Continue “Baseball Cards” database – 7 printouts
Thursday:
Complete “Baseball Cards” database – 7 printouts
Friday: Written Test
Begin “Cars” database
Long - Term Assignments
Be preparing a list on 10 people with the following information about each:
Name, address, Phone #, Favorite food, Favorite color, number of siblings,
birthday.
Week 3 / 13 WEEKLY LESSON PLAN OVERVIEW
Subject:
Computer Applications
Teacher:
Lunceford
Date:
April 6 - 9
Topic/concepts to be covered this week:
Students will use the Access database to set up and manipulate a database.
Objective(s) related to the topic: 5.1.1, 5.2.1, 5.3.1
Students will understand terms associated with a database and recognize its uses.
Method of Teaching:
[ ] Audiovisual [x] Interactive
[x] Discussion [x] Reading/Comprehension
[x] Lecture [x] Large group
[ ] Small group
[x] Other - Demonstration - hands on computer
Date of Evaluation
Daily participation grades for taking notes, staying on task and following
instructions.
Written quiz grade Thursday
SUMMARY OF OBJECTIVES AND POSSIBLE HOMEWORK ASSIGNMENTS:
Monday:
Take notes on Report and Query
Discuss database
Continue with “Class” database
Tuesday:
Complete notes and discussion
Review for Quiz
Wednesday:
Review terms and processes - search, sort and print.
Homework: Prepare a list of 5 "singers" with the following information about
each: name (first and last), type (of music they sing), age and gender.
Thursday:
Set up a sample database from instructions given - SINGERS.
Written Quiz
Friday:
Holiday
Long-term assignments:
Be preparing a list on 10 people with the following information about each:
name, address, phone #, favorite food, favorite color, number of siblings,
birthday.
Week 2 - 12 WEEKLY LESSON PLAN OVERVIEW
Subject: Computer Applications
Teacher: Lunceford
Date: March 30 – April 3
Topic/concepts to be covered this week:
Students will be introduced to the MicroSoft Access Database.
Objective(s) related to the topic:
5, 5.1.1, 5.2.1
Students will understand terms associated with a database and recognize its uses.
Students will create a table, enter records, change the column width, add and
delete fields, and change field properties.
Method of Teaching:
[ ] Audiovisual [x] Interactive
[x] Discussion [x] Reading/Comprehension
[x] Lecture [x] Large group
[ ] Small group [x] Other - Demonstration - hands on computer
Date of Evaluation:
Daily participation grades for taking notes, staying on task and following
instructions.
SUMMARY OF OBJECTIVES AND POSSIBLE HOMEWORK ASSIGNMENTS:
Monday:
Begin discussion of Access – p.1000
RDBMS, FDBMS, object, tables, criteria, queries, record, field, open
Tuesday:
Identify parts of the screen – Title bar, Menu bar, Database toolbar, Objects
bar, Objects buttons, minimize, Restore or Maximize, Close
Wednesday:
Identify the seven types of objects
Tables, Queries, Forms, Reports, Pages, Macros, Modules
Thursday:
Look through a sample database discussing the types of objects.
Friday:
Print Exercises 1-19 ► 1-22, pages 1035 & 1036 OR
Set up a Class database by my instructions
Long-term assignments:
Week 1 / 11 WEEKLY LESSON PLAN OVERVIEW
Subject:
Computer Applications
Teacher:
Lunceford
Date:
March 23 - 27
Topic/concepts to be covered this week:
Students will differentiate between documents set up with tabs versus a
document set up with a table.
Objective(s) related to the topic:
4.a, 4.b, 4.f
Students will use Word to format documents with tabs and tables.
Method of Teaching:
(checked)
[ ] Audiovisual [ X ] Interactive
[ X ] Discussion [ ] Reading/Comprehension
[ X ] Lecture (note taking) [ ] Large group
[ ] Small group [ X ] Other Hands on
Date of Evaluation:
Daily participation grade for class work.
Quiz grade for schedules.
SUMMARY OF OBJECTIVES AND POSSIBLE HOMEWORK ASSIGNMENTS:
Monday: Discuss Tables
Insert, format rows and columns
Borders and shading
Tuesday: Review tabs.
Set up a table.
Illustrate basic table editing features
Wednesday: Discuss the baseball schedule - spacing, font sizes, full use of
the page.
Thursday: Begin producing 3 schedules - tabs, table with lines and table
without lines.
Friday:
Complete, print, and turn it schedules
Week 9 WEEKLY LESSON PLAN OVERVIEW
Subject:
Computer Applications
Teacher:
Lunceford
Date:
Mar 2 - 6
Topic/concepts to be covered this week: Editing Tools
Objective(s) related to the topic: 4.1.1, 4.2.1
Students will edit a document using spell and grammar checker, the thesaurus,
and find and replace.
Method of Teaching:
[ ] Audiovisual
[X] Discussion [ ] Reading/Comprehension
[X] Lecture [ ] Large group
[X ] Interactive [ ] Small group
[X] Other - Illustrating use of Express Publisher
Date of Evaluation: Document packet – Major Test grade
SUMMARY OF OBJECTIVES AND POSSIBLE HOMEWORK ASSIGNMENTS:
Monday:
Discuss Document packet
Hand back and discuss Hands on Quiz
Tuesday:
Begin a document packet that will utilize all editing features. Students will
produce documents from given specifications (margins, tabs, spacing, typeface
characteristics and editing tools) that will count as a major test grade.
Wednesday:
Continue Document Packet
Thursday:
Continue Document Packet
Friday:
Continue Document Packet
Long Range Exams March 10 – 13.
Week 8
WEEKLY LESSON PLAN OVERVIEW
Subject:
Computer Applications
Teacher:
Lunceford
Date:
Feb 23 – 27
Topic/concepts to be covered this week: Editing Tools
Objective(s) related to the topic: 4.1.1, 4.2.1
Students will edit a document using spell and grammar checker, the thesaurus,
and find and replace.
Method of Teaching:
(checked)
[ ] Audiovisual
[X] Discussion [ ] Reading/Comprehension
[X] Lecture [ ] Large group
[X ] Interactive [ ] Small group
[X] Other - Illustrating use of Express Publisher
Date of Evaluation:
Unit 2 Test Wednesday – Lessons 4 - 8
Hands on Quiz Thursday
Document packet – Major Test grade
SUMMARY OF OBJECTIVES AND POSSIBLE HOMEWORK ASSIGNMENTS:
Monday: Review Find and Replace
Discuss and begin Practice Business Letter
Tuesday:Complete Practice Business Letter
Review for Unit 2 Test
Wednesday:Unit 2 Test
Thursday:Hands on Quiz
Discuss Document packet
Friday: Continue Document Packet
Long Range Major Test grade for Hands on Packet – Due March 4
Exams March 10 - 13
Week 7 WEEKLY LESSON PLAN OVERVIEW
Subject: Computer Applications
Teacher: Lunceford
Date: Feb 16 - 20
Topic/concepts to be covered this week: Editing Tools
Objective(s) related to the topic: 4.1.1, 4.2.1
Students will edit a document using spell and grammar checker, the
thesaurus, and find and replace.
Method of Teaching:
[ ] Audiovisual [X] Discussion
[ ] Reading/Comprehension [X] Lecture
[ ] Large group [X] Interactive
[ ] Small group [X] Other - Illustrating use of Express Publisher
Date of Evaluation: Test Friday
SUMMARY OF OBJECTIVES AND POSSIBLE HOMEWORK ASSIGNMENTS:
Monday:
Complete Exercises from the book:
1. Ex. 6-9 → 6-10, pp 157 → 159 and print
2. Ex. 6-13 → 6-15, pp 162 → 167 and print
3. Ex. 7-1 → 7-2, pp 183 → 185 , NO print
4. Ex. 8-14 → 8-15, pp 235 → 238 and print
Tuesday:
Discuss format of a business letter and memo
Discuss cut/copy and paste (again)
Discuss find and replace (again)
Wednesday:
Review for Unit 2 test
Discuss parts of a Business Letter
Thursday:
Format and print a Business Letter
Friday:
Unit 2 test
Begin second set of printouts that demonstrate these editing tools
Week 6 WEEKLY LESSON PLAN OVERVIEW
Subject:
Computer Applications
Teacher:
Lunceford
Date:
Feb 9 - 13
Topic/concepts to be covered this week: Editing Tools
Objective(s) related to the topic: 4.1.1, 4.2.1
Students will edit a document using spell and grammar checker, the
thesaurus, and find and replace.
Method of Teaching:
[ ] Audiovisual
[X] Discussion [ ] Reading/Comprehension
[X] Lecture [ ] Large group
[X ] Interactive [ ] Small group
Date of Evaluation: Test Friday
SUMMARY OF OBJECTIVES AND POSSIBLE HOMEWORK ASSIGNMENTS:
Monday: Complete Lesson 4 and 5 printouts
Begin Lesson 6 – Writing and Editing Tools
Tuesday: Discuss checking spelling and grammar p 153.
Discuss using the Thesaurus p 155.
Discuss Finding and replacing Text p 156
Print Exercises 6-7, p 153 → 6-10, p 159.
Wednesday: Complete Exercises from the book:
1. Ex. 6-9 → 6-10, pp 157 → 159 and print
2. Ex. 6-13 → 6-15, pp 162 → 167 and print
3. Ex. 7-1 → 7-2, pp 183 → 185 , NO print
4. Ex. 8-14 → 8-15, pp 235 → 238 and print
Thursday: Continue exercises
Review for Unit 2 Test
Friday: Complete printouts
Unit 2 Test
Week 5 WEEKLY LESSON PLAN OVERVIEW
Subject:
Computer Applications
Teacher:
Lunceford
Date:
Feb 2 - 6
Topic/concepts to be covered this week:
Formatting paragraphs
Objective(s) related to the topic: 4.1.1, 4.2.1
Students will align paragraphs, change line spacing, set indents using the
ruler, create a bulleted or numbered list, set tabs and tab leaders
Method of Teaching:
[ ] Audiovisual
[X] Discussion [ ] Reading/Comprehension
[X] Lecture [ ] Large group
[X ] Interactive [ ] Small group
[X] Other -
Date of Evaluation: Written quiz Friday
SUMMARY OF OBJECTIVES AND POSSIBLE HOMEWORK ASSIGNMENTS:
Monday: Discuss alignment, line and paragraph spacing and indents – pages 91 – 97.
Show examples of each
Tuesday: Discuss indents and bulleted and numbered lists
Pages 97-98, 105 – 109.
Show examples of each
Wednesday: Discuss tabs and tab leaders
Page 124 – 138.
Show examples
Thursday: Hand out Progress Reports
Review for quiz
Print out examples of all features
Friday:
Written Quiz
Print out a document that uses all features discussed this week.
Week 4 WEEKLY LESSON PLAN OVERVIEW
Subject:
Computer Applications
Teacher:
Lunceford
Date:
Jan 26 - 30
Topic/concepts to be covered this week:
Changing fonts and sizes
Edit a document
Objective(s) related to the topic:
4.1.1, 4.2.1
Students will utilize text functions to enhance a document.
Method of Teaching:
[ ] Audiovisual
[X] Discussion [ ] Reading/Comprehension
[X] Lecture [ ] Large group
[X ] Interactive [ ] Small group
[X] Other - Illustrating use of Express Publisher
Date of Evaluation:
Wednesday and Thursday - Hands on Test
Friday – Written Test
SUMMARY OF OBJECTIVES AND POSSIBLE HOMEWORK ASSIGNMENTS:
Monday:
Complete chapter 2 exercises (Quiz Grade)
Tuesday:
Discuss Lesson 3
Hand back Lesson 2 Quiz
Wednesday:
Review for Unit 1 test
Begin Exercises 3-16 through 3-19, pp. 85-87 – Hands on Test
Thursday:
Complete Hands on Test – Exercises 3-16 through 3-19
Friday:
Unit 1 Written Test
Week 3 WEEKLY LESSON PLAN OVERVIEW
Subject:
Computer Applications
Teacher:
Lunceford
Date:
Jan 20 - 23
Topic/concepts to be covered this week:
Moving within a document
Undo and Redo
Select, adjust and edit text
Objective(s) related to the topic:
4.1.1, 4.2.1
Students will utilize text functions to enhance a document.
Method of Teaching:
[ ] Audiovisual
[X] Discussion [ ] Reading/Comprehension
[X] Lecture [ ] Large group
[X ] Interactive [ ] Small group
[X] Other - Illustrating use of Express Publisher
Date of Evaluation:
Printout / classwork grade for exercises
Hands on test – Wednesday through Friday
Quiz on Lesson 2, Friday
SUMMARY OF OBJECTIVES AND POSSIBLE HOMEWORK ASSIGNMENTS:
Tuesday: Open a template, p34
Discuss pp 34 – 40
Allow class time to copy notes from book
Wednesday: Do now – Exercise 2-4
Work through p 45 – 54 on your own
Copy summary pp53 – 55
Begin Exercises 2-16 through 2-19 as a hands on test grade
Thursday: Review for Lesson 2 quiz
Continue hands on test
Friday: Written Quiz
Continue hands on test
Week 2 WEEKLY LESSON PLAN OVERVIEW
Subject:
Computer Applications
Teacher:
Lunceford
Date:
January 12 – 16, 2009
Topic/concepts to be covered this week:
Introduction to Microsoft Word
Objective(s) related to the topic:
4.1.1, 4.4.1
Students will learn to use basic editing features to enhance a document –
tabs, typefaces, sizes, alignment, margins
Method of Teaching:
(checked)
[ ] Audiovisual
[X] Discussion [ ] Reading/Comprehension
[X] Lecture [ ] Large group
[X ] Interactive [ ] Small group
[X] Other - Hands on
Date of Evaluation:
Wednesday, Quiz on all topics covered thus far.
SUMMARY OF OBJECTIVES AND POSSIBLE HOMEWORK ASSIGNMENTS:
Monday: “Do as I say” – set margins, tabs, fonts and sizes
Review for Quiz
Tuesday: Discuss and begin “FONTS” printout
Wednesday: Written quiz
Continue printouts
Thursday: Begin Page 30, Exercise 1-13 through 1-16
Friday: Continue printouts.
Week 1 WEEKLY LESSON PLAN OVERVIEW
Subject:
Computer Applications
Teacher:
Lunceford
Date:
January 6 - 9, 2009
Topic/concepts to be covered this week:
General computer terms
Introduction to Word
Objective(s) related to the topic:
1.2.1, 1.3.1, 2.1.1, 2.3.1, 3.2.1
Students will become familiar with our computer system and terms associated
with it.
Students will become familiar with the parts of the Word display.
Method of Teaching:
[ ] Audiovisual
[X] Discussion [X ] Reading/Comprehension
[X] Lecture [ ] Large group
[X ] Interactive [ ] Small group
Date of Evaluation:
Friday – Quiz on Tutorial worksheet
SUMMARY OF OBJECTIVES AND POSSIBLE HOMEWORK ASSIGNMENTS:
Tuesday:
Take notes to begin Tutorial worksheet.
Begin Tutorial
Wednesday:
Continue Tutorial
Log in and introduce Word.
Look at the parts of the screen.
Discuss the Tool Bar. Look at each command.
Thursday:
Complete Tutorial.
Continue discussion of Word. Open and save a file. Differentiate insert and
overstrike. Spell check. Edit a document with cut or copy and paste.
Friday: Quiz on Tutorial worksheet.
Open a document from a template, edit and print.