Business Technology Essentials

1^st and 4^th Periods

4^th Nine Weeks

Teacher: Roseanne Mabrey Dates: 4/5/10 – 4/9/10 Grading Period: 4^th 9 Weeks

Course: Business Technology Applications Class Period: 1^st & 4^th Grade: 9

Objectives: The student should be able to…	COS Objectives	AHSGE Objectives	Evaluation:
Add records to an existing database table and database form. Create databases and tables. Create new tables in existing databases. Create queries from database tables. Create database forms. Create database reports.	7. Utilize advanced features of database software, including sorting, filtering, querying, and merging data, and creating reports. Organizing database content using formatting, editing, & records tools.		Class Work Class Participation Verbal Responses Teacher Observation Review
Activities for the Week:	Instructional Methods:	Resource Materials:	Accommodations:
Monday: MS Access 2007: Century 21 Computer Applications and Keyboarding CheckPro: Unit 34 Creating Queries and Computed Fields:. Provide instructions for creating queries for database tables. Discuss why this would be useful in the business world. Students will complete Lesson 141 B: Activities 1-3.	Bell Ringer Lecture/ Notes Class Discussion Computer Instruction	Pencil-Paper Century 21 Computer Applications and Keyboarding	Extended Time Preferential Seating Assignment Length Communication Peer Tutoring
Tuesday:		Tech Resources:	Remediation:
MS Access 2007: Century 21 Computer Applications and Keyboarding CheckPro: Unit 34 Provide instructions on creating computed fields. Students will complete Lesson 141 C: Activities 1-3		Computer Projector Citrix Microsoft Access
Wednesday:
MS Access 2007: Century 21 Computer Applications and Keyboarding CheckPro: Unit 34 Provide instructions on how to create database forms. Students will complete Lesson 142 B: Activities 1-5.
Thursday:
MS Access 2007: Century 21 Computer Applications and Keyboarding CheckPro: Unit 34 Provide instructions on creating database reports. Students will complete Lesson 143 B: Activities 1-6.
Friday:
Make-UP Day Finish any incomplete assignment from the week for MS Access.
Essential Question(s) How do you professionally create and develop electronic databases. Why is this process important?	Industry Credential: IC3	CTSO Activity:

Teacher: Roseanne Mabrey Dates: March 29 – April 2, 2010 Grading Period: 4^th 9 Weeks

Course: Business Technology Applications Class Period: 1^st & 4^th Grade: 9

Objectives: The student should be able to…	COS Objectives	AHSGE Objectives	Evaluation:
Add records to an existing database table and database form. Create databases and tables. Create new tables in existing databases. Add fields to existing databases. Edit records in a database table.	7. Utilize advanced features of database software, including sorting, filtering, querying, and merging data, and creating reports. Organizing database content using formatting, editing, & records tools.		Class Work Class Participation Verbal Responses Teacher Observation Review
Activities for the Week:	Instructional Methods:	Resource Materials:	Accommodations:
Monday: MS Access 2007: Century 21 Computer Applications and Keyboarding CheckPro: Unit 27 Review procedures for adding records to a database. Provide instructions for adding new fields to a database. Students will complete Lesson 108: Exercises B, C, D, and E. Lesson 109: Exercises B and C.	Bell Ringer Lecture/ Notes Class Discussion Computer Instruction	Pencil-Paper Century 21 Computer Applications and Keyboarding	Extended Time Preferential Seating Assignment Length Communication Peer Tutoring
Tuesday:		Tech Resources:	Remediation:
MS Access 2007: Century 21 Computer Applications and Keyboarding CheckPro: Unit 27 Provide instructions on editing records. Students will complete Lesson 109: Exercises D and E. Lesson 110: B and C.		Computer Projector Citrix Microsoft Access
Wednesday:
MS Access 2007: Century 21 Computer Applications and Keyboarding CheckPro: Unit 27 Students will complete Lesson 110: Exercises D, E, F, and G.
Thursday:	Essential Question(s)	Industry Credential:	CTSO Activity:
MS Access 2007: Century 21 Computer Applications and Keyboarding CheckPro: Unit 27 Provide instructions on creating data sorts. Students will complete Lesson 1111: Exercises B, C, D, E, and F.	How do you professionally create and develop electronic databases. Why is this process important?	IC3
Friday:
Make-Up Day Finish any incomplete assignment from the week for MS Access.

Teacher: Roseanne Mabrey Dates: 3/22/10 – 3/26/10 Grading Period: 4^th 9 Weeks

Course: Business Technology Applications Class Period: 1^st & 4^th Grade: 9

Objectives: The student should be able to…	COS Objectives	AHSGE Objectives	Evaluation:
Learn how to create spreadsheets for business and personal use. Use proofreader skills to correct and format an electronic document. Develop database skills using MS Access 2007. Add records to an existing database table and database form. Create databases and tables. Create new tables in existing databases.	7. Utilize advanced features of database software, including sorting, filtering, querying, and merging data, and creating reports. Organizing database content using formatting, editing, & records tools.		Class Work Class Participation Verbal Responses Teacher Observation Review
Activities for the Week:	Instructional Methods:	Resource Materials:	Accommodations:
Monday: MS Access 2007: Century 21 Computer Applications and Keyboarding CheckPro: Unit 27 Read and discuss the overview information on databases. (p. 321-325). Read and discuss the information about adding records to an existing database at the right and on p. 327. Students will complete Lesson 104: Exercises B, C, and D.	Bell Ringer Lecture/ Notes Class Discussion Computer Instruction	Pencil-Paper Century 21 Computer Applications and Keyboarding	Extended Time Preferential Seating Assignment Length Communication Peer Tutoring
Tuesday:		Tech Resources:	Remediation:
MS Access 2007: Century 21 Computer Applications and Keyboarding CheckPro: Unit 27 Students will complete Lesson 105: Exercises B and C.		Computer Projector Citrix Microsoft Excel
Wednesday:
MS Access 2007: Century 21 Computer Applications and Keyboarding CheckPro: Unit 27 Students will complete Lesson 106: Exercises B and C.
Thursday:
MS Access 2007: Century 21 Computer Applications and Keyboarding CheckPro: Unit 27 Students will complete Lesson 107: Exercises B and C.	Essential Question(s) How do you professionally create and develop electronic databases. Why is this process important?	Industry Credential: IC3	CTSO Activity:
Friday:
Make-UP Day Finish any incomplete assignment from the week for MS Access.