CGS 1100 Business Applications – Fall 2011

Course Content – CRN 10720 Tuesdays 6:30 p.m. – 9:15 p.m.

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 Tools (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 cross-references
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 Topic 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
Excel: Chapter 3 – Charts / Researching Privacy, Crime & Security Assignment (Assignment provided)
Textbook Assignments
Practice Exercises:
Family Utility Expenses (pages 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 Excel 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 Query 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
11/29/11 / PowerPoint Presentations and/or group work / 70
Week 16
12/08/11 / FINAL EXAM / 150

1