DATE ASSIGNED CLASS ACTIVITIES HOMEWORK ASSIGNMENT POINT VALUE DATE DUE Week 1 8/23/11 Introduction Syllabus/Course Content Review Laker-Mail NetSupport Understanding Personal Branding and developing a Bio Getting Started with Windows 7 Office Fundamentals & File Management Compressing and Extracting files Treasure Hunt Laker-Mail – attach Bio with picture to Word document. Send to instructor via Laker-Mail account. Textbook Assignments Practice Exercises: Senior Academy (pages 45 – 46) Silent Auction (pages 46 – 47) Capstone Exercise (page 49) Textbook Assignments Capstone Exercise (page 115) 10 15 20 20 8/30/11 Week 2 8/30/11 Windows/Office 2010 Screenshot Quiz (2part) Proofreader’s Marks Word: Chapter 1 – Introduction to Word MLA Basics Textbook Assignments Practice Exercises: Executive Assistant Training (pages 157 – 158) Capstone Exercise (page 161) Special Topic Assignment – Copyright & Fair Use assignment provided 40 15 9/06/11 Week 3
9/06/11 Quiz – Word Chapter 1 Word: Chapter 2 – Document Presentation Special Topic Discussion: Copyright and Fair Use Textbook Assignments Practice Exercises: Engler, Guccione, & Partners (pages 209 – 210) Queen City Medical Equipment (pages 210 – 211) Capstone Exercise (page 215) 10 15 15 9/13/11 Week 4 9/13/11 Quiz – Word Chapter 2 Word: Chapter 3 – Collaboration & Research Omit: 7. Creating MLA / APA Formatting Textbook Assignments Practice Exercises: Odom Law Firm (page 254: a – j) Capstone Exercise (page 259) Track Revisions Figure References Finish with Table of Contents and Index Research Paper & Outline assignments provided 10 15 50 9/20/11 9/20/11 Week 5 9/20/11 Quiz – Word Chapter 3 Writing a proper business letter Word: Chapter 4 – Document Productivity Special Topic The Internet and World Wide Web Textbook Assignments Practice Exercises: Marti Appraisal Company (page 302 – 304) Capstone Exercise (page 308) Create a Table Containing Therapist Information Finding Information on the Web (Assignment provided) 10 15 9/27/11 9/27/11
Week 6 9/27/11 Quiz – Word Chapter 4 Special Discussion: Finding Information on the Web Assignment 10 15 Week 7 10/04/11 Word Exam Excel: Chapter 1 – introduction to Excel Excel: Chapter 2 – Formulas and Functions Textbook Assignments Practice Exercises: Mathematics Review (pages 364 – 365) Capstone Exercise (page 371) Practice Exercises: Blue Skies Airlines (page 411 – 412) Capstone Exercise (page 419 100 15 15 10/11/11 10/11/11
Week 8 10/11/11 Quiz – Excel Chapter 1 Excel: Chapter 2 – Formulas and Functions (continued) Special Topic Chapter 3 – Charts Researching Privacy, Crime & Security Assignment (Assignment provided) Textbook Assignments Practice Exercises: Family Utility Expenses 465-466) Capstone Exercise (page 471) 10 15 10/18/11 10/18/11 Week 9 10/18/11 Quiz – Excel Chapter 2 Excel: Chapter 3 - Charts Excel: Chapter 4 – Datasets and Tables Special Topic Discussion: Privacy, Crime & Security Textbook Assignments Practice Exercises: Salary Data (page 522) Capstone Exercise (page 528) 10 15 15 10/25/11 Week 10
10/27/11 Quiz – Excel Chapter 3 Quiz – Excel Chapter 4 Special Topic Understanding the Differences between Access and Assignment (Assignment provided) 10 10 Week 11 11/01/11 Excel Exam Understanding the differences between Access and Excel discussion Access: Chapter 1 – Introduction to Access Access: Chapter 2 – Relational Databases and Queries Textbook Assignments Practice Exercises: Custom Coffee (pages 572 – 574) Capstone Exercise (page 577) Practice Exercises: Tom & Erin’s Bookstore (pages 637 – 639) Davis Insurance company (pages 639 – 641) 100 15 15 15 11/08/11 Week 12
11/08/11 Quiz – Access Chapter 1 Quiz – Access Chapter 2 Access: Chapter 3 – Customize, Analyze, and Summarize Data Access: Chapter 4 –Creating and Using Professional Forms and Reports Textbook Assignments Practice Exercises: Comfort Insurance (page 685: a – h) Practice Exercises: National Conference (pages 751 – 752) Comfort Insurance (pages 752 – 753) 10 10 10 15 11/15/11 Week 13 11/15/11 Quiz – Access Chapter 4 Access Project PowerPoint: Chapter 1 – Introduction to PowerPoint Textbook Assignments Capstone Exercise (Page 806) 10 50 10 11/22/11 Week 14 11/22/11 PowerPoint Chapter 2 – Presentation Development PowerPoint Chapter 3 – Presentation Design Textbook Assignments Capstone Exercise (page 849) Textbook Assignments Capstone Exercise (page 913) 10 10 11/29/11 11/29/11 Week 15