Santa Clara University

LOWER-DIVISION COURSES

17. Introduction to Business Computing

Use of an integrated set of software tools to solve business problems and communicate results of analysis. Software tools include spreadsheets, databases, graphical tools, and presentation tools. Use of computer networks to access business information. Prerequisite: Working knowledge of one word-processing software. (4 units)

30. Structured Programming

How to develop and implement well-struc­tured programs for business applications using C. Students are required to design and develop several programming assignments using structured programming principles on a vari­ety of computer systems. Foundation for the study of database design and systems programming. (Students who receive credit for Math 10, COEN 6, COEN 11, or OMIS 31 may not take this course for credit.) (4 units)

31. Business Applications Programming

Develop and implement business applica­tion programs using software tools provided by ASP.NET environment. Software tools used will include Visual InterDev and Visual Studio Net. Programming languages used will include VB Script, Java Script, and Visual Basic Net.  Students will develop both Windows and Web-based applications. Basic concept of database and its uses for e-commerce and e-business will be exam­ined. (Students who take MATH 10, OMIS 30, COEN 6, or COEN 11 may not take this course for credit.) (4 units)

34. Management Information Systems

Basic information systems concepts and terminology including different types of information systems. The components of software and hardware systems, and the basic of communication networks as enabling technologies for business. Developing integrated business software with the use of database and/or web technologies. Exposure to how contempory business firms use information systems like ERP. (4 units)

40.  Statistics and Data Analysis I

First in a two-course sequence. Students learn to describe, summarize, and evaluate sets of data using numerical and graphical methods; to quantitatively express the probability of events and formulate the probability of joint, marginal, and conditional events; to employ probability distributions to describe the probabilities associated with discrete and continuous random variables; to design and evaluate sample data collection plans for quantitative and qualitative data; to measure and evaluate the error associated with parameter estimation using samples; and to construct interval estimates for the population mean and the population proportion.  Analysis of real-world data using spreadsheet software.  Prerequisites: MATH 12 or MATH 31 and OMIS 17, or a passing grade on a Challenge Examination. (4 units)

41.  Statistics and Data Analysis II

Second in a two-course sequence.  Students learn to formulate hypotheses about population parameters and define the errors associated with hypothesis testing; to construct confidence intervals and test hypotheses about means, proportions, and variances; to formulate and test hypotheses about multinomial data and independence; to construct and evaluate both simple linear and multiple regression models; and to predict the value of dependent variables using regression models.  Analysis of real-world data using spreadsheet software.  Prerequisite: OMIS 40. (4 units)

UPPER-DIVISION COURSES

105. Database Management Systems

Design and use a database for business applications.  A three-stage approach to databases:  conceptual design using the entity-relation­ship model, logical design using the rela­tional model, and physical design using indexes. Study of SQL, relational tables, normalization. Use of a database software is required. Prerequisite: OMIS 30 or OMIS 31 or OMIS 34. (5 units)

106. Systems Analysis and Design

Development of methods of structured systems analysis and design. Emphasis on information systems for business applications. Methods include physical modeling, logical modeling, flowcharts, data flow diagrams, hierarchy (HIPO) models, structured English, entity-relationship diagrams, and structure charts. Application of these tools to a systems anal­ysis and design project is required. (5 units)

107. Systems Programming

Discussion of the fundamental concepts of systems programming. Major focus on the overall structure and capabilities of modern operating systems (UNIX/LINUX, Windows, etc.) and how to use operating system facilities to manipulate files and processes. Also covers shells and scripting program­ming concepts for performing system-level programming assignments on dedicated com­puter systems. Development of several software assignments utilizing systems programming concepts is required. Prerequi­site: OMIS 30 or equivalent. (5 units)

108. Operations Management

Survey of analysis and design methods for business systems that produce and deliver goods and services. Topics chosen from the following: process analysis, sales forecasting, production planning and scheduling, inven­tory control, materials requirement plan­ning, quality control, ‘‘just-in-time” manufacturing techniques, and supply chain management. Prerequisites: OMIS 40 and 41. (5 units)

109. Computer Decision Models

Focus on decision-making using spreadsheets. Key elements are: formulating business decisions with spreadsheets; solution methods and sensitivity to input assumptions; assessing the impacts of uncertainty and risk on decision-making; and deriving managerial insights from spreadsheet solutions. Examples drawn from business applications including market forecasting, supply chain management, and financial analysis. Prerequisites: OMIS 40 and 41 and proficiency in Microsoft Excel. (5 units)

110. Computer Simulation Modeling

Examination of computer simulation modeling for the design and operation of complex processes or systems. Theory and techniques of simulation and simulation languages such as SLAM, GPSS, and GASP; inventory control; assembly and job-shop scheduling; and manufacturing process design. Prerequi­sites: OMIS 40 and 41, and OMIS 30 or 31. (5 units)

111. Computer Communications Systems

Designed to provide the IS professional with a basic literacy in communication technologies driving the digital economy. Basics of data- and tele-communications, LANs, WANs, broadband, analog and digital communications, Internet architecture and concepts, wireless including cellular and wlans, and market and regulatory issues are covered. Emphasis on being able to assess the business impact of networking technologies; covers state-of-the-art. Prerequisite: OMIS 30, or OMIS 31, or OMIS 34. (5 units)

112. Artificial Intelligence for Business

The applications of artificial intelligence techniques for designing and implementing expert systems for business and industrial applications. Experience in building simple knowledge-based systems using AI programming languages. Prerequisite: OMIS 30 or OMIS 31. (5 units)

113. Data Warehousing and Business Intelligence

Examination of a broad collection of software tools and analytical applications that allow enterprises to analyze data maintained in data warehouses and operational databases for business intelligence. Topics include data storage and data integration architecture, enterprise analytics, business intelligence tools and presentations. Hands-on experiences in building business intelligence applications. Prereq­uisite: OMIS 30 or OMIS 31. (5 units)

117. Software Development Project

Integration of system and programming concepts to develop a comprehensive soft­ware system. Also presents an overview of software development methodology. Prereq­uisite: OMIS 30 or 31. (5 units)

135. Enterprise Resource Planning Systems

Study of data and process integration across a company onto a single computer system.  Analysis of ERP system technologies, including databases. Class project requires setting up an ERP system module using Oracle E-Business Suite.  Case studies and guest speakers from industry.  Prerequisites: Experience with data­bases is required; OMIS 105 or COEN 178, or instructor’s approval. (5 units)

137. Object-Oriented Programming

Introduction to object-oriented design methodology. Discussion of different programming paradigms, concepts of data abstraction, inheritance, and encapsulation. Topics include an overview of Java Programming language, classes and objects, data abstraction, inheritance, I/O packages, Exceptions, Threads and GUI. Develop­ment of several programming assignments using Java is required. Prerequisite: OMIS 30, or OMIS 31, or equivalent. (5 units)

145. Competitive Quality

Slogans like "Quality is job1" highlight the importance of quality in commercial competition. Course explores how quality contributes to competitiveness. Definitions of quality and methods for measuring. Variation in quality and effect on firm performance. Methods for monitoring and controlling quality including control charts and sampling inspection. Strategic supply chain issues associated with quality in light of operations theory and tracking technology. Includes case studies and field trips. Prerequisites: ECON 1 and OMIS 108. (5 units)

150. Financial Information Systems

Course focuses on computer-based financial information systems that allow finance and accounting professionals to acquire and manage a company’s financial system. Topics include the business func­tions of a financial information system, the technical aspects of the system, and the management issues of implementing such a system. Conceptual under­standing, and hands-on experience with Oracle E‑Business Suite Financials. Prerequisites: OMIS 30 or 31. (5 units)

170. Physical Database Design

Methodology for design of physical file structures to support single-and multiple-file applications. Query optimization using indexes. Data structures, file struc­tures, file access methods, file manipulation, and algorithmic analysis. Prerequisite: OMIS 105.   (5 units)

173. E-Commerce Technologies

An integrated course discussing topics needed to build, operate, and maintain e-businesses. Topics include scripting languages, mark up languages, security, online transaction, and multimedia operation. Prerequisites: OMIS 30 or 31. (5 units)

198. Internship

Opportunity for selected upper-division students to work in local businesses or government units or firms. Prerequisite: Upper-division standing and approval of the Undergraduate Commit­tee. (1 to 3 units)

199. Independent Study

Independent projects undertaken by upper-division students with a faculty sponsor.  Prerequisite:  Written proposal must be approved by instructor and chair one week prior to registration. (1-5 units)