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 2010

I. Catalog Information

CIS 3
Business Information Systems
4.5 Unit(s)

 

Requisites: Advisory: English Writing 211 and Reading 211 (or Language Arts 211), or English as a Second Language 272 and 273.

Formerly:

Hours: Four hours lecture, one and one-half hours laboratory (66 hours total per quarter).

CAN:

Description: Introduction to management information systems, systems design and development, data communications, data management, office automation, computer hardware and software concepts. Use of common software packages for business applications including word processing, spreadsheets, database, and Internet web tools.


Student Learning Outcome Statements (SLO)

 

• Student Learning Outcome: Create a plan to improve a business using software and hardware.


 

• Student Learning Outcome: Produce a word processing document utilizing columns, formatting, 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 utilizing presenation software incorporating graphics and text.


 

• Student Learning Outcome: Apply database technology to a business problem.


II. Course Objectives

A.Describe the role that information systems play in business operation, management, and strategy.
B.Describe the procedure, systems development life cycle, for building business information systems
C.Compare systems and application software; describe types of systems software and operating systems
D.Apply database technology to a business problem
E.Describe common components of computer hardware; define common information systems terminology
F.Describe and evaluate telecommunications hardware, media, software, and configurations
G.Describe important business use of the Internet
H.Discuss effective acquisition and use of hardware, software, and information systems services
I.Discuss key business and public policy issues related to information technologies
J.Design and create a word processing document, including graphics and a decision support system using a spreadsheet, including graphics

III. Essential Student Materials

 None

IV. Essential College Facilities

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

V. Expanded Description: Content and Form

A.Describe the role that information systems play in business operation, management, and strategy.
1.Three levels of business and information systems
a.Strategic applications in information systems for competitive advantage
b.Management applications
1.Reporting
2.Queries
3.Decision support
4.Executive information
c.Operations and transaction processing
B.Describe the procedure, systems development life cycle, for building business information systems
1.Problem/opportunity identification
2.Alternate solutions
3.Cost/benefit analysis
4.Design
5.Implementation
6.Maintenance
7.Retirement
C.Compare systems and application software; describe 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.Apply 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.Describe common components of computer hardware; define 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.Describe and evaluate telecommunications hardware, media, software, and configurations
1.Telecommunication media: wire and wireless
2.Home networking
3.Local area networks
4.Wide area networks
G.Describe important business use of the Internet
1.Internet/web technology: servers, software, protocols, and web pages
2.Internet/web applications: e commerce, intranets
H.Discuss effective acquisition and use of hardware, software, and information systems services
1.Hardware
2.Software
3.Information Services
I.Discuss 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.Design and create a word processing document, including graphics and a decision support system using a spreadsheet, including graphics
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.
2.Design, develop, and document a relational data base for a business application requiring a least 3 tables and 2 reports.
3.Use a spreadsheet to model a common business problem with at least five variables. Modify variables to simulate varying business conditions.
4.Access information on the Internet
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.

VII. Methods of Instruction

 Lecture and Visuals
Discussion of Assigned Reading
Discussion and Problem Solving Performed in ClassIn-Class Exploration of Case Studies
Examination Review
Collaborative Projects
Collaborative Learning and Small Group Exercises
Collaborative Lab Assignments

VIII. Methods of Evaluating Objectives

A.Successful completion of reading based homework assignments
B.Complete in class lab assignments on various software applications
C.Complete in class tutorial assignments on topics related to the system development life cycle used in the project.
D.Complete term project on technology implementation based on the system development life cycle.
E.Complete a midterm examination
F.Complete a final examination

IX. Texts and Supporting References

A.Required Texts
1.Beekman, George; Quinn, Michael J, "Computer Confluence, Tomorrow's Technology and You", Eighth Edition, Prentice Hall, Inc. 2009
B.Supporting Texts and References
1.None

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
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
C.Word: Students will create multiple small projects to practice formatting, importing data, and creating various types of business communication
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