CGS 2100C - Computer Applications: Syllabus

Updated August 2015

CGS2100C Computer Applications Ref 529544

Table of Contents

Faculty Contact Information Methods of Instruction
Course Description Traditional Pace Chart and Assignments
General Course Outcomes Progress and Evaluations Policies
Course Prerequisites Communication Policy
Course Attendance & Participation Policy Other Policies and Procedures
Computer Requirements Student Success Tips and Resources
Required Course Materials  

Faculty Contact Information

Course Instructor:   Prof.XXXX
Office Phone
  954-201-XXXX
Department Phone:   954-201-XXXX
Email:   All communication should be through the course email tool. Use my BC email ONLY if you are unable to access the course email:smolina@broward.edu
     I will be available live as needed.  Please email me to schedule a day / time to meet "Real Time".
BC Safety Office Phone#:   954-201-HELP (4357)

Return to Table of Contents

Course Description

This is an intermediate level course in computer applications software. Students will gain knowledge and experience in the use and capabilities of word processing, spreadsheet, database, and presentation graphics applications. Through case studies, students will learn to develop comprehensive solutions to various types of problems. Integration between applications will be emphasized.

Return to Table of Contents

General Course Outcomes

  1. Working on a Group Projects
  2. Document Formats, Columns, Charts, Special Effects, and Styles
  3. Working with Tables, Graphics, and Objects
  4. Mail Merge and Automating Mass Mailings
  5. Advanced Spreadsheet Functions
  6. Creating Spreadsheet Charts and Diagrams
  7. Working with Spreadsheet Templates and File Formats
  8. Using Spreadsheets’ Database Capabilities
  9. Building and Maintaining a Relational Database
  10. Creating Databases and Tables
  11. Sorting, Filtering, and Querying a Database
  12. Creating Database Forms and Reports
  13. Enhancing Presentations with Graphic Elements and Techniques
  14. Creating Presentations for the Web
  15. Integrating Applications

Return to Table of Contents

Course Prerequisites

To maximize your chances for success in this course, make sure that you meet the following course course prerequisites:

Return to Table of Contents

Course Attendance and Participation Policy

Attendance/Withdrawal Policy:

During the first week of class, you must complete the Course Challenge Assessment or else you will be administratively withdrawn from the course. Simply logging into the course will not satisfy your attendance during this time. As with on-campus courses, students who are reported for non-attendance in an online course and are withdrawn are still responsible for paying for the course. If you do not complete the requirements of the first week of class, you should drop the course by the official drop/add deadline or expect to pay for the course.

It is very important for you to actively participate in this online class. Students will have a maximum of 16 weeks to complete this course from the first day of registration. If the entire course, including the Course Evaluations, is not completed by the last day of the 16th week students will receive a U for the course.

Students must obtain the permission of their Academic Coach to go beyond 16 weeks in the course.

Participation:

Regular, active, and meaningful participation is a critically important component of this course and is essential to your success. It is recommended that you log into the course several times during the week. Frequency and quality of participation may affect your success in the program.

Return to Table of Contents

Computer Requirements

To complete this course, you must have access to computer hardware and software that meets the standards listed below.

System and Software Requirements for this course 
Operating System​

PC

Windows XP, Vista, 7 or 8
Windows 8 recommended

Mac

    

Mac OS X

Browser​ ​Firefox 20.0 or higher, latest recommended
Internet Explorer 9.0 or higher
Download version 10 (recommended)
Firefox 20.0 or higher, latest recommended
JAVA​ ​Java 7.0.x update 21
Download version 7.0 update 21 (recommended)
​Java SE 6.0 update 26
Download 1.6.0_26 (recommended)
The following are true for both PC and Mac​
​ ​
​Internet ​Cable modem or DSL
RAM 2 GB, 4 GB preferred​ ​
Processor ​2.0 GHz or higher ​ ​
Video​ ​SVGA monitor with minimum resolution of 1024 x 768, with 1280 x 1024 or greater recommended
JavaScript ​ ​Enabled
Cookies​ ​Enabled
Software Requirements for successful completion of this course.

 

Return to Table of Contents

Required Course Materials

Required Text:

Title: New Perspectives Office 2013, Second Course + SAM2013 Printed Access Card
ISBN: 9781133284772



Books for online courses are available at the Central Campus bookstore
A. Hugh Adams Central Campus Bookstore
Admissions & Student Service Center - Bldg. 19
Tel: (954) 201-6830
Fax: (954) 201-6895

 

In addition, this course utilizes the following required software or hardware tools:

  1. SAM Student Learning Management System.
    Please click here to see instructions for setting up your SAM account.

*The book comes bundled with the SAM2013 access code when purchased at the central campus bookstore.

Return to Table of Contents

Methods of Instruction

This is a 3-credit hour fully online course. Normally, a 3-credit hour on-campus course would meet two times each week (during a 16 week term) for a total of 3 hours per week or 48 hours per term. This is a self paced fully online course so students will have to guide themselves accordingly. There is a pace chart included below that will show you how to successfully complete this course in a 4 week period.

Return to Table of Contents

Traditional Pace Chart - 4 week completion goal

Read and refer to this document regularly. It will tell you what assignments you should complete, and how to complete them.

Purpose

The purpose of this Pace Chart is to give students in this course an indication of how long they will on average spend to complete this course. This Pace Chart is only a guideline and depending on a students' proficiency with computers, learning style, prior knowledge of the subject and personal motivation, actual times may differ widely from the guidelines given.

Entire Course

The entire course should be completed within a six (6) week time frame. Students who can demonstrate competencies faster than the recommended time could complete the course in a four (4) week period.

Section 1

All modules in Section 1 should take at most two (2) weeks assuming at least twelve (12) hours per week are spent on each module.

Section 2

All modules in Section 2 should take at most two (2) weeks assuming at least twelve (12) hours per week are spent on each module.

Week/Section/Learning Outcomes Learning Materials Assignments & Assessments
Week 1/Section 1    
Course Challenge    

Upon successful completion of this section, the student shall be able to:

  1. Create a Document Using a Template
  2. Use existing styles
  3. Create and modify new styles
  4. Use existing themes
  5. Create and modify existing themes
  6. Create a multi-column document
  7. Review and modify document properties
  8. Use comments in a document
  9. Track changes in a document
  10. Circulate documents for review
  11. Compare and merge documents
  12. Create labels using the Mail Merge wizard
  13. Create a form letter
  14. Merge letters with records from the data source
  15. Create a bookmark
  16. Create a table of contents
  17. Insert and edit hyperlinks
  18. Save a document as a web page
  19. Create and publish a document online

D2L:

Word Review: Tutorials 1-4

Word Tutorial 5 Notes

Word Tutorial 5 PPT

Word Tutorial 6 Notes

Word Tutorial 6 PPT

Word Tutorial 7 Notes

Word Tutorial 7 PPT

SAM:

Word Tutorials 5 - 7 Training

Word Tutorial 5 Practice Test

Word Tutorial 5 Training

Word Tutorial 5 Project

Word Tutorial 6 Practice Test

Word Tutorial 6 Training

Word Tutorial 6 Project

Word Tutorial 7 Practice Test

Word Tutorial 7 Training

Word Tutorial 7 Project

Week 2/Section 1    
Upon successful completion of this section, the student shall be able to:
  1. Plan and create an Excel table
  2. Work within an Excel table
  3. Create totals in Excel tables
  4. Sort and filter data
  5. Create and modify a PivotTable
  6. Apply PivotTable styles and formatting
  7. Create a PivotChart
  8. Use multiple worksheets and 3-D references
  9. Create Excel templates
  10. Prepare a worksheet to share with others
  11. Create a workbook based on a template
  12. Create range names
  13. Create an Excel application
  14. Create validation rules for data entry
  15. Protect the contents of worksheets and workbooks
  16. Create and run a macro
  17. Save and open a workbook in a macro-enabled format
  18. Use range names in a formula
  19. Create Statistical functions
  20. Create Date and Time functions
  21. Create Financial and Logical functions

 

 

D2L:

Excel Review: Tutorials 1-4

Excel Tutorial 5 Notes

Excel Tutorial 5 PPT

Excel Tutorial 6 Notes

Excel Tutorial 6 PPT

Excel Tutorial 7 Notes

Excel Tutorial 7 PPT

Excel Tutorial 8 Notes

Excel Tutorial 8 PPT

SAM:

Excel Tutorials 5 - 8 Training

Excel Tutorial 5 Practice Test

Excel Tutorial 5 Training

Excel Tutorial 5 Project

Excel Tutorial 6 Practice Test

Excel Tutorial 6 Training

Excel Tutorial 6 Project

Excel Tutorial 7 Practice Test

Excel Tutorial 7 Training

Excel Tutorial 7 Project

Excel Tutorial 8 Practice Test

Excel Tutorial 8 Training

Excel Tutorial 8 Project

Section 1 Evaluation    
Week 3/Section 2    
Upon successful completion of this section, the student shall be able to:
  1. View Relationships in a Database
  2. Establish Relationships between Tables
  3. Identify and Correct Design Errors in Tables
  4. Create a Query from Joined Tables
  5. Protect and Maintain a Database
  6. Create a New Database
  7. Create a New Table
  8. Add Records to a Table
  9. Find and Edit Records in a Table
  10. Modify the Table Design
  11. Create Table Relationship
  12. Sort Records
  13. Filter Records
  14. Create a Select Query
  15. Edit an Existing Query
  16. Sort Data in a Query
  17. Specify Criteria in a Query
  18. Use Compound Criteria
  19. Create an Auto Form
  20. Use a Form to Add and Delete Records
  21. Create a Form using the Form Wizard
  22. Modify a Form
  23. Create an Auto Report
  24. Create a Report Using the Report Wizard
  25. Modify the Design of a Report
  26. Print a Report
  27. Embed Excel Charts and Data in Word and Access
  28. Use Mail Merge to Integrate Access and Word 
  29. Import Data from Excel to Access 
  30. Link an Access Form to an Excel Worksheet
  31. Import and export XML files
  32. Understand the difference between importing, embedding, and linking external objects
  33. Embed Excel Charts in an Access Form

 

D2L:

Access Review: Tutorials 1-4

Access Tutorial 5 Notes

Access Tutorial 5 PPT

Access Tutorial 6 Notes

Access Tutorial 6 PPT

Access Tutorial 7 Notes

Access Tutorial 7 PPT

Access Tutorial 8 Notes

Access Tutorial 8 PPT

SAM:

Access Tutorials 5 - 8 Training

AccessTutorial 5 Practice Test

Access Tutorial 5 Training

Access Tutorial 5 Project

AccessTutorial 6 Practice Test

Access Tutorial 6 Training

Access Tutorial 6 Project

Access Tutorial 7 Practice Test

Access Tutorial 7 Training

Access Tutorial 7 Project

Access Tutorial 8 Practice Test

Access Tutorial 8 Training

Access Tutorial 8 Project

Week 4/Section 2    
Upon successful completion of this section, the student shall be able to:
  1. Draw and Format Lines
  2. Create Basic Shapes and Text Boxes 
  3. Edit Format Drawing Objects 
  4. Create and Format Word Art 
  5. Insert Images 
  6. Embed Excel charts in PowerPoint Presentations
  7. Import Data from a Word Table to an Excel Worksheet or PowerPoint Presentation
  8. Enhance Objects with Visual Effects
  9. Apply Custom Animation
  10. Create a Design Template
  11. Enhance Presentations with Sound 
  12. Modify Presentations Using Research and Comparison Tools 
  13. Format a Presentation for the Web 

D2L:

PowerPoint Review: Tutorials 1-2

PowerPoint Tutorial 3 Notes

PowerPoint Tutorial 3 PPT

PowerPoint Tutorial 4 Notes

PowerPoint Tutorial 4 PPT

SAM:

PowerPoint Tutorials 3-4 Training

PowerPoint Tutorial 3 Practice Test

PowerPoint Tutorial 3 Training

PowerPoint Tutorial 3 Project

PowerPoint Tutorial 4 Practice Test

PowerPoint Tutorial 4 Training

PowerPoint Tutorial 4 Project

Section 2 Evaluation    
Course Evaluation    

 

Return to Table of Contents

Course Progress and Evaluations Policies

Assessment

S/U

Course Evaluation

Student will need to score 81% or higher on Course Evaluation to obtain an S for the course

Grading Scale

Grades

Percentage

Grade = S

81-100+%

Grade = U

0-80%

Return to Table of Contents

Communication Policy

Expectations for Course Communication

Return to Table of Contents

Other Policies and Procedures

Special Needs - Students having special needs as defined by the Americans with Disabilities Act should:

Academic Honesty

Changes to the Syllabus

24/7 Helpdesk Information

Return to Table of Contents

Student Success Tips

In order to be successful in this course, you need to be organized and manage your time well so that you can complete all assignments and assessments in a timely manner. Make sure that you do not allow yourself to procrastinate, and that you communicate with the instructor or your classmates via the Course Cafe if you have any questions on any course materials or need assistance completing any assignments.

Online Resources for Students

Return to Table of Contents

U.S. Department of Labor Disclaimer

This product was funded by the U.S. Department of Labor’s Employment and Training Administration. This product  was created by the grantee and does not necessarily reflect the official position of the U.S. Department of labor. The Department of Labor makes no guarantees, warranties, or assurances of any kind, express or implied, with respect to such information, including any information on linked sites and including, but not limited to, accuracy of the information or its completeness, timeliness, usefulness, adequacy, continued availability, or ownership

Creative Commons License
Except where otherwise noted, this work is licensed under a Creative Commons Attribution 4.0 International License.

The Academic Use of Textbook Material Disclaimer

The material contained in this course uses direct excerpts from the required textbook for this course: New Perspectives Office 2013, Second Course + SAM2013 Printed Access Card
ISBN: 9781133284772

The use of this material is authorized under the publisher's academic use license which requires the user to purchase the required textbook.