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 2015

I. Catalog Information

CIS 3
Business Information Systems
4.5 Unit(s)

 

Formerly:

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

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 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 on a technology topic utilizing presentation software incorporating graphics and text.


 

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


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.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.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. (SLO 1)

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 by completing short reading-based questions for each module.
B.Complete in class lab assignments and show the resulting files on various software applications. (SLO 2 - SLO 5)
C.Complete in class tutorial assignments and show the resulting files on topics related to the system development life cycle used in the project.
D.Complete term project with a 10 pages paper write-up on technology implementation based on the system development life cycle. (SLO 1)
E.Complete a midterm examination, which tests the material in the first half of the course. Questions are given from the chapters studied and the grading is based on the percentage of correct answers on a standard scale.
F.Complete a final examination, which tests the material of the entire course. Questions are given from the chapters studied and the grading is based on the percentage of correct answers on a standard scale.

IX. Texts and Supporting References

A.Examples of Primary Texts and References
1.Beekman, George; Quinn, Michael J, "Computer Confluence, Tomorrow's Technology and You", Eighth Edition, Prentice Hall, Inc. 2009
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

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