De Anza logo Course Outlines

Public Search

 
 
Close Window/Tab
PRINT VIEW -- Opens in new, second window. Use browser controls to close when finished.
Credit- Degree applicable
Effective Quarter: Fall 2020

I. Catalog Information

CIS 3
Business Information Systems
4.5 Unit(s)

 

Formerly:

Requisites: Advisory: EWRT 211 and READ 211, or ESL 272 and 273.

Hours: Lec Hrs: 48.00
Lab Hrs: 18.00
Out of Class Hrs: 96.00
Total Student Learning Hrs: 162.00

CAN:

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.


Student Learning Outcome Statements (SLO)

 

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


 

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


 

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


 

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


 

• Student Learning Outcome: Solve a business data problem by utilizing database technology.


II. Course Objectives

A.Appraise the role that information systems play in business operation, management, and strategy.
B.Construct a systems development life cycle, for building business information systems.
C.Research systems and application software and types of systems software and operating systems.
D.Recommend database technology to a business problem.
E.Categorize common components of computer hardware and common information systems terminology.
F.Enumerate telecommunications hardware, media, software, and configurations.
G.Generalize important business use of the Internet.
H.Recommend effective acquisition and use of hardware, software, and information systems services.
I.Examine key business and public policy issues related to information technologies.
J.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.

III. Essential Student Materials

 None

IV. Essential College Facilities

 Access to a computer lab with suitable software (operating system, word processor, database, spreadsheet and Internet connection)

V. Expanded Description: Content and Form

A.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
B.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
C.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
D.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
E.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
F.Enumerate telecommunications hardware, media, software, and configurations.
1.Telecommunication media: wire and wireless
2.Home networking
3.Local area networks
4.Wide area networks
G.Generalize important business use of the Internet.
1.Internet/web technology: servers, software, protocols, and web pages
2.Internet/web applications: e commerce, intranets
H.Recommend effective acquisition and use of hardware, software, and information systems services.
1.Hardware
2.Software
3.Information Services
I.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
J.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

VI. Assignments

A.Required reading from text
1.Complete homework questions from each chapter assigned
2.Do study and review activities on the book webpage
B.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)
C.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.
D.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)

VII. 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

VIII. Methods of Evaluating Objectives

A.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.
B.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)
C.Participation in tutorial assignments to progressively demonstrate ability to critically evaluate the stages of the system development life cycle used in the project.
D.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)
E.Midterm examination, which appraises comprehension and requires synthesis and application of course material covered to that point in time.
F.Final examination, which appraises comprehension and requires synthesis and application of course material covered for the whole term.

IX. Texts and Supporting References

A.Examples of Primary Texts and References
1.Paige Baltzman, Amy Phillips, "Business Driven Information Systems" 6th Edition, McGraw-Hill Education, 2019
2.David T. Bourgeois PhD, "Information Systems for Business and Beyond, Legally Free Computer Books", Saylor Foundation, Textbook Equity, 2014
B.Examples of Supporting Texts and References
1.Beekman, George; Beekman, Ben, "Digital Planet: Tomorrow's Technology and You", Tenth Edition; Prentice Hall, Inc. 2011
2.Beekman, George; Quinn, Michael J, "Computer Confluence, Tomorrow's Technology and You", Eighth Edition, Prentice Hall, Inc. 2009

X. Lab Topics

A.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)
B.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)
C.Word: Students will create multiple small projects to practice formatting, importing data, and creating various types of business communication (Student Learning Outcome 2)
D.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
E.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)