Active Outline

General Information

Course ID (CB01A and CB01B)
CISD003.
Course Title (CB02)
Business Information Systems
Course Credit Status
Credit - Degree Applicable
Effective Term
Fall 2023
Course Description
This is an introductory course to business information systems, systems design and development life cycle, data communications, data management, office automation, computer hardware and software concepts. The use of common software packages for business applications including word processing, spreadsheets, database, and internet web tools will be covered.
Faculty Requirements
Course Family
Not Applicable

Course Justification

This course is CSU and UC transferable. It is also part of the following degrees/ certificates: CIS-Business Programming (AA Degree). Business students work in environments where technology drives many aspects of the organization. This course prepares the students to be able to use the most common office software and to be able to make decisions about technology to be used in their work environment.

Foothill Equivalency

Does the course have a Foothill equivalent?
No
Foothill Course ID

Course Philosophy

Formerly Statement

Course Development Options

Basic Skill Status (CB08)
Course is not a basic skills course.
Grade Options
  • Letter Grade
  • Pass/No Pass
Repeat Limit
0

Transferability & Gen. Ed. Options

Transferability
Transferable to both UC and CSU
C-IDArea(s)StatusDetails
BUSBusinessApprovedC-ID BUS 140

Units and Hours

Summary

Minimum Credit Units
4.5
Maximum Credit Units
4.5

Weekly Student Hours

TypeIn ClassOut of Class
Lecture Hours4.08.0
Laboratory Hours1.50.0

Course Student Hours

Course Duration (Weeks)
12.0
Hours per unit divisor
36.0
Course In-Class (Contact) Hours
Lecture
48.0
Laboratory
18.0
Total
66.0
Course Out-of-Class Hours
Lecture
96.0
Laboratory
0.0
NA
0.0
Total
96.0

Prerequisite(s)

Corequisite(s)

Advisory(ies)

ESL D272. and ESL D273., or ESL D472. and ESL D473., or eligibility for EWRT D001A or EWRT D01AH or ESL D005.

Limitation(s) on Enrollment

Entrance Skill(s)

General Course Statement(s)

Methods of Instruction

Lecture and Visuals

Discussion of Assigned Reading

Discussion and Problem Solving Performed in Class

In-Class Exploration of Case Studies

Examination Review

Collaborative Projects

Collaborative Learning and Small Group Exercises

Collaborative Lab Assignments

Assignments

  1. Required reading from text
    1. Complete homework questions from each chapter assigned
    2. Do study and review activities on the book webpage
  2. Application software
    1. Create, edit, and store a document using word processing software. (Student Learning Outcome 2)
    2. Design, develop, and document a relational data base for a business application requiring a least 3 tables and 2 reports. (Student Learning Outcome 5)
    3. Use a spreadsheet to model a common business problem with at least five variables. Modify variables to simulate varying business conditions. (Student Learning Outcome 3)
    4. Collect information on the Internet resulting in a presentation about a business technology implementation utilizing presentation software: graphics, tables, process flow diagrams and text. (Student Learning Outcome 4)
  3. Tutorials instructing students on how to do perform activities related to the project, like process flow, cost/benefit analysis, will be conducted during class time, having the students complete in-class group assignments for each tutorial.
  4. Term project of several pages, created with application software, and dealing with a significant business improvement based on technology. Students will be graded based on selecting a problem that can be solved with a technology we learned about in class and using the Systems Development Life Cycle in its entirety. (Student Learning Outcome 1)

Methods of Evaluation

  1. Participation in class discussion of business case studies to progressively demonstrate ability to critically evaluate the system development life cycle and recommend appropriate course of technical implementation.
  2. Participation in class of lab assignments in various software applications to progressively demonstrate ability to critically evaluate scenarios addressed in the system development life cycle. (Student Learning Outcomes 2,3,4,5)
  3. Participation in tutorial assignments to progressively demonstrate ability to critically evaluate the stages of the system development life cycle used in the project.
  4. Written project demonstrates critical thinking regarding the technical implementation analyzed, as well as comprehension and application of the system development life cycle. (Student Learning Outcome 1)
  5. Midterm examination, which appraises comprehension and requires synthesis and application of course material covered to that point in time.
  6. Final examination, which appraises comprehension and requires synthesis and application of course material covered for the whole term.

Essential Student Materials/Essential College Facilities

Essential Student Materials: 
  • None.
Essential College Facilities:
  • Access to a computer lab with suitable software (operating system, word processor, database, spreadsheet and Internet connection)

Examples of Primary Texts and References

AuthorTitlePublisherDate/EditionISBN
Paige Baltzman, Amy Phillips, "Business Driven Information Systems" 6th Edition, McGraw-Hill Education, 2019
David T. Bourgeois PhD, "Information Systems for Business and Beyond, Legally Free Computer Books", Saylor Foundation, Textbook Equity, 2014

Examples of Supporting Texts and References

AuthorTitlePublisher
Beekman, George; Beekman, Ben, "Digital Planet: Tomorrow's Technology and You", Tenth Edition; Prentice Hall, Inc. 2011
Beekman, George; Quinn, Michael J, "Computer Confluence, Tomorrow's Technology and You", Eighth Edition, Prentice Hall, Inc. 2009

Learning Outcomes and Objectives

Course Objectives

  • Appraise the role that information systems play in business operation, management, and strategy.
  • Construct a systems development life cycle, for building business information systems.
  • Research systems and application software and types of systems software and operating systems.
  • Recommend database technology to a business problem.
  • Categorize common components of computer hardware and common information systems terminology.
  • Enumerate telecommunications hardware, media, software, and configurations.
  • Generalize important business use of the Internet.
  • Recommend effective acquisition and use of hardware, software, and information systems services.
  • Examine key business and public policy issues related to information technologies.
  • Concoct an integrated document, including graphics and a decision support system using a spreadsheet and database, including graphics to highlight data in a visual manner.

CSLOs

  • Create and execute a plan to improve success factors in a business, using software and hardware.

  • Produce a business document utilizing word processing tools to show use of various formatting, such as columns, outlline, and numbering.

  • Design a model for business decision making utilizing spreadsheet software and incorporating charts, formulas, and formatting.

  • Create a presentation about a business technology implementation utilizing presentation software incorporating graphics, tables, process flow diagrams and text.

  • Solve a business data problem by utilizing database technology.

Outline

  1. Appraise the role that information systems play in business operation, management, and strategy.
    1. First level of IT: Strategic applications in information systems for competitive advantage
    2. Second level of IT: Management applications
    3. Third level of IT: Operations and transaction processing
  2. Construct a systems development life cycle, for building business information systems.
    1. Problem/opportunity identification
    2. Alternate solutions
    3. Cost/benefit analysis
    4. Design and Development
    5. Implementation
    6. Maintenance
    7. Retirement
  3. Research systems and application software and types of systems software and operating systems.
    1. Software selection: packages, programming languages, and end user tools
    2. Managing decision making
    3. Manufacturing: robotics, computer aided design and computer aided manufacturing
    4. Home office automation and telecommuting
    5. Artificial intelligence
    6. Education/training technologies and applications
  4. Recommend database technology to a business problem.
    1. File Management vs. DBMS
    2. Database structures
    3. Data modeling
    4. Database administration
    5. Trends: Data Mining
  5. Categorize common components of computer hardware and common information systems terminology.
    1. System software: operating systems and utilities
    2. Programming languages: compilers, interpreters
    3. System devices: processing, input, output, storage, telecommunications
  6. Enumerate telecommunications hardware, media, software, and configurations.
    1. Telecommunication media: wire and wireless
    2. Home networking
    3. Local area networks
    4. Wide area networks
  7. Generalize important business use of the Internet.
    1. Internet/web technology: servers, software, protocols, and web pages
    2. Internet/web applications: e commerce, intranets
  8. Recommend effective acquisition and use of hardware, software, and information systems services.
    1. Hardware
    2. Software
    3. Information Services
  9. Examine key business and public policy issues related to information technologies.
    1. Public issues: privacy, digital divide, free speech and press, crime
    2. Organizational issues: IS planning, IS security. control, and crime, health issues (repetitive stress injuries), ethics
    3. Information systems organization and careers
  10. Concoct an integrated document, including graphics and a decision support system using a spreadsheet and database, including graphics to highlight data in a visual manner.
    1. Use an operating system, such as Windows
    2. Use a word processor product, such as Word
    3. Use a spreadsheet product, such as Excel
    4. Use a database product, such as Access
    5. Use an Internet browser, such as Navigator or Internet Explorer
    6. Integrated use of these products

Lab Topics

  1. Excel: A spreadsheet for a company budget and a Mortgage spreadsheet will be created in lab. Both will be converted to various data formats for better transmission (Student Learning Outcome 3)
  2. Access: A small customer database will be created in lab. The students will use the database to do various transactions such as queries, reports, sorting, and editing. Data conversion and importing of the database to other application will be learned (Student Learning Outcome 5)
  3. Word: Students will create multiple small projects to practice formatting, importing data, and creating various types of business communication (Student Learning Outcome 2)
  4. Internet: Searches for business information, articles, in addition to learning to navigate and locate various types of locations, like .gov, .edu, and other types of sites
  5. Power Point: Two presentations will be created, one for teaching a small subject to the class, and one for presenting the final project, using various formatting and practicing good presentation creating techniques (Student Learning Outcome 4)
Back to Top