CGS1100

Microcomputer Applications for Business and Economics

Course Code: CGS 1100

Credit Hours: 3

Effective beginning: 2020-21

 

Course Description:
This course provides a survey of current microcomputer applications software, including general terminology, features and operating procedures for specific tasks. The student will acquire operational skills for using microcomputers in support of business and personal tasks

Course Details

Prerequisites:

A grade of ā€œCā€ or better in CGS 1060 or CIS 1000 or an acceptable score on the CGS 1100 Screening Exam.

Instructors:

Glenda Bethel

 

Required textbooks/ course materials:

Cengage Unlimited: 4-month subscription or 1-year subscription

Add Product to Cengage MyHome:  SAM 365 & 2016 Assessment, Training, and Projects Instant Access with 1 MindTap Reader

ISBN-13: 9781337113922 OR 9781337113939

 

Assignment/course outline:

The following topics will be covered in this course at the discretion of the instructor:

  • Windows File Management
  • Microsoft Excel - Getting Started with Excel, Formatting Workbook Text and Data, Calculating Data with Formulas and Functions, Analyzing and Charting Financial Data
  • Microsoft Access - Creating a Database, building a Database and Defining Table
  • Relationships, Maintaining and Querying a Database, Creating Forms and Reports
  • Microsoft Word - Creating and Editing a Document, Navigating and Formatting a Document, Creating Tables and a Multipage Report, Enhancing Page Layout and Design

See your Instructor First Day Handout for individual instructor assignment schedule.

 

Discipline-level learning outcomes:

CGS 1100 is not a General Education Core course.  However, it does address several discipline-specific competencies in the Technology Area.

T-1 Apply appropriate technologies to a range of tasks.

T-2 Communicate, collaborate, and create content effectively, using state-of-the-art information technologies.

T-3 Locate, access, evaluate, and use information from digital/electronic sources.

T-4 Identify ethical, social, and legal issues related to information technology.

T-5 Identify essential issues related to information security.

 

Associate in Science degree in Business Administration Learning Outcomes:

B-1 Demonstrate knowledge of the principles, practices and supervisory responsibilities of management, and ethical and legal issues in a business environment.

B-2 Apply general business work place competencies, including employability skills and office computer skills.

B-3 Perform accounting tasks and understands business accounting concepts. 

B-4 Communicate effectively in oral and written form, exhibit college level computation and problem-solving skills, and interact appropriately with people of other cultures or backgrounds. [Gen. Ed.]

 

Associate in Science degree in Computer Information Technology Learning Outcomes:

CIT-1 Understand, install, configure, monitor, use, and troubleshoot computer hardware and software. [1.0, 2.0, 3.0, 4.0, 6.0, IT Support 12.0, 13.0]

CIT-2 Understand, install, configure, monitor, use, and troubleshoot network hardware and software. [8.0, 9.0]

CIT-3 Demonstrate general computing workplace competencies, including employability skills, interpersonal & customer service skills, and user support skills. [11.0, IT Support 12.0, 13.0, 14.0, 15.0]

CIT-4 Demonstrate project management skills. [10.0]

CIT-5 Perform database management and design tasks. [7.0]

 

Associate in Science degree in Network Systems Technology Learning Outcomes:

NST-1 Understand, install, configure, monitor, use, and/or troubleshoot computer hardware and software. [1.0, 3.0]

NST-2 Understand, install, configure, monitor, use, and troubleshoot network hardware and software. [2.0, 4.0]

NST-3 Demonstrate general computing workplace competencies, including employability skills, interpersonal & customer service skills, and user support skills. [5.0, Server Admin 18.0]

NST-4 Demonstrate project management skills. [6.0] NST-5 Depends on Specialization:

  • Server Administration (Program Code 2181): Demonstrate advanced understanding of networked environments and perform network administration activities. [Server Admin Specialization 7.0-8.0]
  • Network/Cybersecurity (Program Code 2182): Demonstrate proficiency in securing networks and data, including performing penetration testing and responding to cybersecurity incidents. [Network/Cybersecurity Specialization 7.0-9.0
  • Digital Forensics (Program Code 2183): Demonstrate understanding of forensic casework procedures and perform computer and mobile device forensic investigations. [Digital Forensics Specialization 7.0-14.0]

 

 

Course-level student learning outcomesDiscipline-level learning outcomesAssessment methods
Evaluate terms which describe computer equipment, personnel, or processes used for business and personal tasks

B-2, B-4, CIT-1, NST-1, T-1, T-2,T-3, T-4

Homework, tests, quizzes
Contrast relevant business application software packages according to type

B-2, B-4, CIT-1, NST-1, T-1, T-2,T-3, T-4

Homework, tests, quizzes
Propose situations in which computers could potentially be used to improve worker productivity

B-2, B-4, CIT-1, NST-1, T-1, T-2,T-3, T-4

Homework, tests, quizzes
Formulate how to use current productivity software applications

B-2, B-4, CIT-1, NST-1, T-1, T-2,T-3, T-4

Homework, tests, quizzes
Construct and manipulate Desktop area of the Microsoft OS

B-2, B-4, CIT-1, NST-1, T-1, T-2,T-3, T-4

Homework, tests, quizzes
Synthesize tasks using current computing technologies and data storage techniques

B-2, B-4, CIT-1, NST-1, T-1, T-2,T-3, T-4

Homework, tests, quizzes
Evaluate basic folder management by renaming, copying, moving, and deleting files and folders

B-2, B-4, CIT-1, NST-1, T-1, T-2,T-3, T-4

Homework, tests, quizzes

Formulate documents, construct worksheets, and create databases

B-2, B-4, CIT-1, NST-1, T-1, T-2,T-3, T-4

Homework, tests, quizzes

 

 

  1. Attend and participate in class regularly.
  2. Read all assigned material before class.
  3. Study in-class notes and online (Canvas) materials.
  4. Complete assigned projects in a timely manner to enable reflections and revisions on the final product.
  5. Participate in discussions.
  6. Demonstrate your mastery of the required skills on quizzes, exams, etc.
  7. Complete all assignments with promptness and accuracy.
  8. All written documents as well as online assignments must be completed using correct grammar, spelling, and structure.

 

The grading breakdown is subject to change at the discretion of the instructor.

Quizzes

up to 40%

Test (which includes Midterm and Final) 

up to 60%

Assignments, Projects and/or Labs     

up to 40%

Participation

up to 20%

 

Please see your first day handout for individual instructor grading schemes.

College-wide policies and resources

For more specific information on Chipola's college-wide academic policies and resources available to students, visit the link below.