This course addresses the fundamental concepts of computerized database management and database design, with emphasis on the relational model. It includes hands-on experience using MS Access in creating databases, forms, reports, and queries.
CAPP 266 Advanced MS Excel Applications (Old Course: CIS 285)
3 semester credits
Lecture: 3 Hours
Fall Semester
This class includes theory and applications of spreadsheet software. Also included are advanced features such as, programming, web linking, scripting, goal seeking, solver, application integration, list management, complex models, macro implementation, graph creation, and graphic presentation of analyzed data will be covered.
Prerequisites: CAPP 120 or higher, M 121 or higher.
This course is an introduction to computer programming and problem solving techniques. Stresses modularity and structured techniques. Structured program design using design tools is heavily stressed. Programming structures including looping, sequence, and decision are thoroughly examined. Students will be exposed to the BASIC programming language with an overview of the language and specific implementation examples.
This course focuses on intermediate computer program design and development using structured techniques. Includes small project development. Stresses modularity, program design, implementation, and testing. Object oriented programming/object oriented design (OOP/OOD) techniques will be utilized.
This is an advanced object oriented programming and application development course using Java, a continuation of CIS 155, Java Programming. This course will expand the student’s knowledge of object oriented programming to include graphical user interface development utilizing programming language libraries. Advanced computer programming topics including arrays and mathematical topics including matrix multiplication and basic trigonometric functions used in graphics programming will be covered.
CIS 360 Business Telecommunications and Networking
3 semester credits
Lecture: 3 Hours
Fall Semester
This course is an overview of network and communications using the internet and LAN, WAN and MAN configurations. This class will stress TCP/IP in relation to the OSI model. Hubs, switches, and NIC’s will be configured and tested. Students will be required to perform both out-of class and in-class homework using Windows NT, Windows 2000 and Unix computers. Students will be required to install and set-up software on a network. Some work will be performed in teams.
Prerequisites: CAPP 120 or higher, CIS 155, CIS 350
This class covers the application of selected behavioral and quantitative decision support tools, emphasizing problem identification, technique selection, and results or computerized solution interpretations. Topics include: decision models, resource allocation models, project management models, and forecasting models including software contracts, proposals, data warehousing and data mining.
Prerequisites: CAPP 120 or higher competencies, M 145 or M 121.
Introduction to the basic principles of how operating systems function. Concepts cover single user operating systems and multi-user operating systems including the programming requirements and considerations under each.
Prerequisites: CAPP 120 or equivalent competencies, CIS 115, CIS 155 and CIS 350
This is an advanced programming techniques course and a survey of fundamental data structures. It covers pointers, arrays, user defined data structures, abstract data types, time-space complexity, algorithm proofs, program testing, and operating system interactions. Computability and intractable problems are discussed. Object oriented programming and object oriented design techniques will be utilized.
In this course, the Oracle database server will be used for application creation including analysis, design, implementation, and testing of large scale, enterprise database oriented projects. It covers advanced database concepts including relational databases, client-server applications and Oracle Database Administration.
This course will continue on the network course. It will include using routers. The students will see why and when to use routers and they will hook them up in the lab. It will provide a basic overview of routing. Security policy will be covered including common threats and attacks and the technologies that can address network security issues. It also covers installation, configuration and basic troubleshooting of security solutions. Students will be required to successfully install and configure equipment in a pre-determined lab environment.
Prerequisites: Junior/Senior status in CIS, EET; completion of CIS 300 and CIS 360 or similar courses.
This course applies WWW and internet presentation and programming techniques for providing quality information content on internet and in house networks, including dynamic information generation and dissemination through the use of interactive database links, client-server connections, and distributed software architectures.