Nov 21, 2024  
2023-2024 College Catalog 
    
Catalog Navigation
  Catalog Home
  Message from the Chancellor
  Mission and Vision
  All Programs
  Course Descriptions
  General Education Courses
  Academic Departments
  Admissions, Registration and Records
  Selective Admissions
  Earning a Degree or Certificate
  Faculty
  Historical Catalogs
HELP
2023-2024 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.

Button linking to AZ Transfer course equivalency guide  

Course Learning Outcomes
  1. Demonstrate proficiency with spreadsheet software to solve business problems. 
  2. Demonstrate proficiency with using visual presentation software, word processing documents and database management software to organize, present and store business solutions and information.
  3. Use the Internet to research and analyze information and data in case studies.
  4. Discuss laws and ethics related to computer use.
  5. 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  

Effective Term:
Fall 2023