Apr 15, 2024  
2022-2023 College Catalog 
    
2022-2023 College Catalog [ARCHIVED CATALOG]

CIS 120 - Computer Applications for Business [SUN# CIS 1120]

4 Credits, 5 Contact Hours
3 lecture periods 2 lab periods

Introduction to computer information systems and applications with an emphasis on Microsoft applications, especially Microsoft Excel. Students will develop an awareness of the critical thinking, quantitative analysis and qualitative assessment skills that serve as the foundation for the effective and ethical use of information as part of an informed business or personal decision.

Prerequisite(s): MAT 092  or higher or satisfactory score on the mathematics assessment exam.
Gen-Ed: Meets AGEC - Options; Meets CTE - Options.




Course Learning Outcomes
  1. Demonstrate problem solving using application software, and the Internet.
  2. Demonstrate proficiency with spreadsheet software (Microsoft Excel) to solve business problems. This proficiency will be demonstrated by multiple lab assignments which will focus on business problem solving with an emphasis on analysis techniques, algorithmic design, and implementation.
  3. Demonstrate proficiency with using visual presentation software (Microsoft PowerPoint), word processing documents (Microsoft Word) and database management software (Microsoft Access) to organize, present and store business solutions and information.
  4. Use the Internet to research and analyze information and data in case studies.
  5. Demonstrate proficiency in building a basic Web page.
  6. Discuss laws and ethics related to computer use.
  7. Discuss network topology and security; explain the Internet effect on the globalization of business and social networks from the perspective of business.

Outline:
  1. Business Application Tools -Excel
    1. Create, edit and format spreadsheets
    2. Create and modify formulas using absolute, mixed and relative cell reference
    3. Use Excel functions
    4. Create and modify charts
    5. Name cells and ranges
    6. Table management
      1. Sort
      2. Filter
      3. Import data
    7. Database functions
    8. Create, refresh, and delete
      1. Pivot tables
      2. Pivot charts
    9. Business problem solving
      1. Analysis of problems
      2. Critical thinking
      3. Design of charts, and tables to highlight business information
      4. Analysis of existing data represented in excel
  2. Business Application Tools -Access
    1. File management
    2. Create, design, normalize, join tables
    3. Design, manage, filter, sort data
    4. Query using Structured Query Language (SQL)
    5. Report generation
    6. Pivot table
    7. Chart
  3. Business Application Tools -Word
    1. Editing and formatting
    2. Importing/Inserting
      1. Pictures
      2. Excel Charts
      3. Tables
    3. Creating and modifying
      1. Styles
      2. Table of content
      3. Index
    4. Labels and mailers for business literature
  4. Business Application Tools -PowerPoint
    1. Create
      1. Slideshows
      2. Templates and master slides
      3. Outlines
    2. Modify
      1. Slideshows
      2. Templates
      3. Outlines
    3. Importing/inserting
      1. pictures
      2. graphs
      3. slides
  5. Other topics
  1. Network Security and data integrity
  2. Information systems role in business
  3. Research using the Internet
  4. Planning and implementing technology solutions  
  5. Ethics
  6. Social Networking as a business tool
  7. Internet Security
  1. Viruses and malware
  2. Internet fraud
  3. Spam
  4. Identify theft
  5. Intellectual property rights
  6. Privacy
  1. Internet Case studies
    1. E-Commerce
    2. Principles of e-commerce
    3. Effect on business
    4. Cloud computing
    5. Social and ethical issues