Catalog Description

Formerly known as CIS 62
Advisory: Eligibility for ENGL 1A
Hours: 72 (54 lecture, 18 laboratory)
Description: Examination of information systems and their role in business. Focus on information systems, database management systems, networking, e-commerce, ethics and security, computer systems hardware and software components. Application of these concepts and methods through hands-on projects developing computer-based solutions to business problems. (C-ID ITIS 120) (CSU)

Course Student Learning Outcomes

  • CSLO #1: Research, analyze and evaluate information to solve business problems using business information systems concepts.
  • CSLO #2: Design and produce business information systems solutions incorporating current trends, security, and best practices.
  • CSLO #3: Employ business information systems concepts and terminology in professional communication.
  • CSLO #4: Demonstrate marketable business information systems career skills.

Effective Term

Fall 2023

Course Type

Credit - Degree-applicable

Contact Hours

72

Outside of Class Hours

90

Total Student Learning Hours

162

Course Objectives

Lecture Objectives:
1. Describe existing and emerging technologies and their impact on organizations and society.
2. Describe the development and use of information systems in business.
3. Solve common business problems using appropriate information technology applications and systems.
4. Evaluate various security issues that affect today's business systems technology.
Laboratory Objectives:
1. Analyze data using spreadsheet and database tools.
2. Analyze a system for potential security issues such as determining what if any firewalls are in use, check anti-virus & anti-spyware installations, password policies and macro settings.
3. Develop a database, data storage system, and transfer existing data from various spreadsheets to populate it.
4. Explore ways businesses are using e-commerce sites as well as social media sites to improve customer relations.

General Education Information

  • Approved College Associate Degree GE Applicability
    • CSU GE Applicability (Recommended-requires CSU approval)
      • Cal-GETC Applicability (Recommended - Requires External Approval)
        • IGETC Applicability (Recommended-requires CSU/UC approval)

          Articulation Information

          • CSU Transferable

          Methods of Evaluation

          • Objective Examinations
            • Example: Weekly chapter review questions will be used to help students determine if they are gaining a clear understanding of topics covered. Sample question: 1) What is fault tolerance? a. An exact copy of a system's information b. The ability to get a system up and running in the event of a system crash or failure and includes restoring the information backup c. A computer system designed that in the event a component fails, a backup component or procedure can immediately take its place with no loss of service d. A backup operational mode in which the functions of a computer component (such as a processor, server, network, or database) is assumed by secondary system components when the primary component becomes unavailable through either failure or scheduled down time
          • Problem Solving Examinations
            • Example: Students will be graded on the weekly hands-on labs for completion, correctness, and clarity. For example, read the end of chapter case study on information systems security and write your response to the issue provided by the case study based upon the ethics discussed in the chapter and class discussions.
          • Projects
            • Example: Students will read assigned material and write a short analysis paper on the systems development lifecycle. Writing will be assessed based on a rubric developed by the instructor and shared with students.
          • Skill Demonstrations
            • Example: After reading the chapter on databases students will be required to complete the end of chapter ERD exercise, designing an ERD for a doctor’s office database. Grading will be based on how well they displayed an understanding of the use of relationships between tables to meet the needs of the fictitious business.

          Repeatable

          No

          Methods of Instruction

          • Laboratory
          • Lecture/Discussion
          • Distance Learning

          Lab:

          1. Following an instructor lecture on databases, students will be provided with a set of spreadsheet files that contain fake customer information in various formats and be asked to migrate that data into a single data store while insuring data consistency and accuracy. (Lab Objective 3)

          Lecture:

          1. After students read the assigned chapter on "Internet Usage and e-Business Systems" and complete the review questions, the instructor will lead students through a discussion for that chapter and review the key concepts of the week. (Lab Objective 4)

          Distance Learning

          1. Through the LMS, the instructor will us a slide lecture presentation on existing and emerging technologies and their impact on organizations and society. Students will be divided into small groups to discuss potential new technologies based upon course reading and their own experiences. In a whole-class discussion students will present and discuss their small-group findings. (Lecture Objective 1)

          Typical Out of Class Assignments

          Reading Assignments

          1. Students will be required to read from the assigned course text on the "systems development life cycle" and submit a short description of the cycle. 2. Students will use internet resources to research security issues effecting today's businesses and be prepared to discuss in class.

          Writing, Problem Solving or Performance

          1. Students will complete hands-on lab computer assignments applying the weekly concepts. Ex: Open the database and generate a query to analyze the data set using specific selection criteria. Generate a report based on the results of the query. 2. Use the prescribed spreadsheet program to evaluate various loan options for a business and find the long term cost of each. 3. Write a research paper on evolving trends in business systems.

          Other (Term projects, research papers, portfolios, etc.)

          Required Materials

          • Introduction to Information Systems
            • Author: Rainer, Prince, Cegielski
            • Publisher: Wiley and Sons
            • Publication Date: 2021
            • Text Edition: 9th
            • Classic Textbook?: No
            • OER Link:
            • OER:

          Other materials and-or supplies required of students that contribute to the cost of the course.