Computer/Information Tech (CMPL)

#

Course numbers with the # symbol included (e.g. #400) have not been taught in the last 3 years.

CMPL 402 - Excel

Credits: 2

A comprehensive examination of spreadsheet software. Students will build a variety of spreadsheets using simple and complex formulas, functions, graphics, database features, sorts, linkages within spreadsheet and between spreadsheets, and macros. Basic Algebra and knowledge of computer operating system required. This course is valuable for all Business students and Computer Science Students. It provides competency and fluency in the standard software used for business analysis and as a link between large computer software systems and the end user.

Equivalent(s): CMPL 502G, MGMT 502G

Grade Mode: Letter Grading

View Course Learning Outcomes

  1. Design, build, edit, and format workbooks.
  2. Use spreadsheet software to present and analyze quantitative information, draw conclusions, and evaluate the reliability of those conclusions.
  3. Practice advanced Excel capabilities.

View Course Learning Outcomes

CMPL 415 - Programming Fundamentals

Credits: 4

The course is designed to provide students with a sound background in structured programming logic and design. These foundational concepts can be applied regardless of which programming languages a student eventually uses to write programs. The demonstration language for programming concepts will be Microsoft Visual Basic. The course covers the key mathematical and logical constructs that are the basis of much programming. Topics include the software development life cycle, particularly the programming phase; structured programming techniques; problem-solving and algorithm development; decision control structures, including selection (IF/CASE) and repetition (looping) structures; variables and arrays; and data structures. Proficiency in Excel is necessary for success in this course.

Prerequisite(s): MTH 402 with a minimum grade of D- or MATH 502G with a minimum grade of D-.

Equivalent(s): CMPL 515G

Grade Mode: Letter Grading

View Course Learning Outcomes

  1. Classify programming languages according to the standard programming taxonomies.
  2. Explain the software development life cycle, with focus on the programming phase.
  3. Describe how mathematical and logic constructs influence programming languages and their implementations.
  4. Demonstrate the effective use of structured programming techniques, programming selection, and repetition structures as required in basic programming projects.
  5. Develop effective algorithms containing basic selection and repetition structures, applying mathematical and logical concepts for a basic-level programming problem and implement them using Visual Basic.
  6. Read, interpret, and develop flowcharts and pseudocode.
  7. Develop complex expressions, managing different data structures in a basic programming project.
  8. Explain the functions, management strategies, and use cases for variables, constants and arrays within a programming project.
  9. Demonstrate the appropriate use of the procedures and functions within programming, along with the purpose and efficacy of modularization.
  10. Explain and apply error-trapping and debugging techniques in a selected programming problem.
  11. Design and develop programs using standard structured programming techniques.

View Course Learning Outcomes

CMPL 512 - Advanced Software Tools

Credits: 4

This is a project-oriented software applications course to help the student gain competency with advanced features of office productivity software and to introduce more advanced database application concepts. NOTE: Excel is recommended for success in this course.

Equivalent(s): CMPL 612G

Grade Mode: Letter Grading

View Course Learning Outcomes

  1. Produce a complex word processing document to include advanced features such as macros, tables, charts, drawing tools, and multi-formatting.
  2. Complete a complex project utilizing a spreadsheet to include advanced features such as multiple worksheets, formulas, functions, tables, charts, validation rules, macros, and multi-formatting.
  3. Design and implement a small database to include multiple tables, forms, reports, and SQL queries.
  4. Integrate the output of at least two of the above tools to form a complete project.
  5. Create a two-page newsletter or its equivalent using desktop publishing either in a specific package such as MS Publisher or using the advanced features of MS Word.
  6. Create, organize, and manage contacts and distribution lists.
  7. Use collaborative tools from the Office Suite and the Internet to facilitate collaboration in learning and productivity.

View Course Learning Outcomes

CMPL 525 - Foundations of Cybersecurity

Credits: 4

This course addresses the foundations of cybersecurity, including threats and vulnerabilities as well as the tools, technologies, and strategies used to manage those threats and vulnerabilities.

Attributes: Environment,TechSociety(Disc)

Equivalent(s): CMPL 525G

Grade Mode: Letter Grading

View Course Learning Outcomes

  1. Define key concepts and terminology in cybersecurity.
  2. Identify threats to cybersecurity.
  3. Articulate strategies to identify and remediate vulnerabilities in information assets.
  4. Discuss the systemic components (including personnel) necessary for an effective cybersecurity program.
  5. Apply appropriate solutions to cybersecurity incidents.

View Course Learning Outcomes

CMPL 530 - Introduction to Programming with Python

Credits: 4

In this introductory programming with Python course, students will have the opportunity to learn about data types, control flow, object-oriented programming, and graphical user interface-driven applications. The examples and problems used in this course are drawn from diverse areas such as text processing, simple graphics creation, and image manipulation. This course will explore the large standard library of Python 3, which supports many common programming tasks.

Prerequisite(s): CMPL 415 with a minimum grade of D- or CMPL 515G with a minimum grade of D-.

Equivalent(s): CMPL 530G

Grade Mode: Letter Grading

View Course Learning Outcomes

  1. Demonstrate the fundamentals of writing Python scripts.
  2. Develop a program using core Python scripting elements such as variables and flow control structures.
  3. Discover how to work with lists and sequence data.
  4. Write Python functions to facilitate code reuse.
  5. Use Python to read and write files.
  6. Develop robust code by handling errors and exceptions properly.
  7. Utilize the Python standard library.
  8. Explore Python's object-oriented features.
  9. Search text using regular expressions.

View Course Learning Outcomes

CMPL 540 - Best Practices in Website Design

Credits: 2

This hands-on course outlines the fundamentals of web design. Students consider ethical use of information and best practices when creating websites using free web page design programs. Working with a basic design program, students explore layout, graphics, text, color, links, tables, frames and content. Students use website design software to create a simple website of their own, as well as examine publication and promotion options. NOTE: Basic computer competence is required. This course is not appropriate for Information Technology majors and may not be combined with other Information Technology courses to satisfy degree requirements.

Equivalent(s): CMPL 540G

Grade Mode: Letter Grading

View Course Learning Outcomes

  1. Develop familiarity with best practices in web design.
  2. Discuss the ethical use of information regarding copyright, intellectual property, etc. in web design.
  3. Design and lay out an effective website using a web page design program for a specific audience.
  4. Import/draw graphics and write effective copy.
  5. Create text/graphics combinations and use color in the design process.
  6. Incorporate in-demand keywords into the site to get a better search engine ranking.

View Course Learning Outcomes

CMPL 544 - Special Topics: Lower Level

Credits: 1-4

A study of current and variable topics in Computer Science. Course content changes from term to term.

Repeat Rule: May be repeated up to unlimited times.

Equivalent(s): CMPL 544G

Grade Mode: Letter Grading

CMPL 614 - Computer and Network Systems

Credits: 4

This course offers a practical study of the hardware and software of modern computing systems and networks. Course topics include operating system software by studying the functions and interactions of computer and peripheral components such as central processing units (CPU), memory, storage, print engines, etc. Learners also study the workings of network components such as protocols, hubs, routers, and switches. Through exposure to a mix of theory, extensive vocabulary, and specific knowledge about trends in contemporary systems, learners develop skills to effectively communicate with others regarding the specification, purchase, and installation of an office or home computer system/network.

Prerequisite(s): CMPL 415 with a minimum grade of D- or CMPL 515G with a minimum grade of D- or CMPL 512 with a minimum grade of D- or CMPL 612G with a minimum grade of D-.

Equivalent(s): CMPL 614G

Grade Mode: Letter Grading

View Course Learning Outcomes

  1. Demonstrate a deeper understanding of electronic data processing and data transport, developing both conceptual knowledge and practical skills.
  2. Explain the relationships that exist between performance considerations of the hardware and software components of a computer system.
  3. Describe representative network protocols, the constraints that system software and device selection may impose on protocol selection and the problems engendered by multiple (incompatible) protocols within an organization.
  4. Demonstrate a practical knowledge that focuses on the typical advanced user, types of questions pertaining to hardware and system-level software of common personal computers, its applications software, and its connections to a network.
  5. Use the vocabulary of the field to communicate effectively with technical professionals.
  6. Recognize the potential benefits and dangers of intranet/internet implementations.
  7. Identify and use current trade and professional resources to keep abreast of trends in the field.

View Course Learning Outcomes

CMPL 620 - Virtualization and Cloud Computing

Credits: 4

In this course students will have the opportunity to learn the fundamental concepts, components, infrastructure, as well as security and privacy considerations of cloud computing and virtualization systems. Course activities will address the skills and knowledge necessary to install, configure, and manage virtual environments and how to effectively plan, implement, and manage cloud computing.

Prerequisite(s): (CMPL 614 with a minimum grade of D- or CMPL 614G with a minimum grade of D-) and (CMPL 525 with a minimum grade of D- or CMPL 525G with a minimum grade of D-).

Equivalent(s): CMPL 620G

Grade Mode: Letter Grading

View Course Learning Outcomes

  1. Identify the components of the cloud infrastructure and their functions.
  2. Examine service models such as Software-as-a-Service, Platform-as-a-Service, and Infrastructure-as-a-Service.
  3. Describe deployment models of the cloud.
  4. Create, manage, and troubleshoot virtual machines.
  5. Describe virtual networks and configure virtual switches and virtual storages.
  6. Examine the features and functions of different storage protocols, such as FC, FCoE, iSCSI, and NFS.
  7. Use troubleshooting methodology to fix issues in a virtualized environment.

View Course Learning Outcomes

CMPL 622 - Human Computer Interaction

Credits: 4

This course builds an understanding of human behavior with interactive objects, focusing on how to develop and evaluate interactive software using a human-centered approach. This includes examining the many different types of interactive software, understanding the principles of effective graphical user interface design, evaluating human-centered software and software development and exploring aspects of collaboration and communication as they affect individual and group interaction with software systems.

Attributes: Environment,TechSociety(Disc); Writing Intensive Course

Equivalent(s): CMPL 622G

Grade Mode: Letter Grading

View Course Learning Outcomes

  1. Articulate how different disciplines (human factors, cognitive psychology, engineering, graphics design) influence the design of computer systems.
  2. Classify input/output devices and techniques and their effect on human-computer interaction.
  3. Specify human-computer interaction dialogues.
  4. Describe the main concepts (conceptual model, metaphors and paradigms) that influence human-computer interaction) and demonstrate that influence.
  5. Describe the main theories of cognition and demonstrate how these are used when designing interactive systems.
  6. Describe and apply the process for designing interaction.
  7. Demonstrate why a user-centered approach is preferred.
  8. Choose the appropriate method for evaluating an interactive system.
  9. Model problems.

View Course Learning Outcomes

CMPL 637 - Intermediate Programming with Python

Credits: 4

Students will have the opportunity to take their Python programming skills to the next level with this intermediate course. This course includes a review of basic concepts such as lists, strings, and dictionaries, and more advanced topics such as threading, multiprocessing, context managers, and generators.

Prerequisite(s): CMPL 530 with a minimum grade of D- or CMPL 530G with a minimum grade of D-.

Equivalent(s): CMPL 537G

Grade Mode: Letter Grading

View Course Learning Outcomes

  1. Write Python applications for data-analysis problems.
  2. Apply the concepts and use the constructs of Python libraries, including numpy, pandas, and the re (regular expression) package in a course project.
  3. Demonstrate ability to load, cleanse, and process data according to accepted professional standards.
  4. Use Web APIs and/or web scraping to download data.
  5. Create, load, and process data in a relational database.
  6. Write object-oriented programs.

View Course Learning Outcomes

CMPL 641 - Database Management Systems

Credits: 4

This course provides prospective users of data base management systems with a solid theoretical and practical foundation for using these systems in a variety of contemporary organizational environments. The course traces the nature of DBMS from general conceptual structures, through the design, interface and implementation of actual database systems. The course includes a mix of classical database theory with practical hands-on application using state of the art DBMS packages; similar to those used today by large and small organizations alike to run their information systems.

Prerequisite(s): (CMPL 415 with a minimum grade of D- or CMPL 515G with a minimum grade of D-) and (CMPL 512 with a minimum grade of D- or CMPL 612G with a minimum grade of D-).

Equivalent(s): MGMT 622G

Grade Mode: Letter Grading

View Course Learning Outcomes

  1. Describe classical database theory and the conceptual structures that underlie database management systems.
  2. Demonstrate a working knowledge of the function, role, and structure of database systems from start to finish.
  3. Design, build, modify, normalize, and generate queries (QBE) on database tables.
  4. Design and generate reports for a variety of functional areas of business and facilitate end user access.
  5. Set up interfaces with in-house or point of sale database software.
  6. Analyze data security and integrity including back up strategies.
  7. Develop familiarity with both small office database systems (ie.MS Access) and with a "big system" database (Oracle).

View Course Learning Outcomes

CMPL 642 - Systems Analysis and Design

Credits: 4

This hands-on course introduces students to the role of the systems analyst in the development of information systems for organizations. The systems analyst is a problem-solver. As such, this course emphasizes development of effective solutions and communicating those solutions to the development team. Use of accepted design techniques, project management approaches, written and verbal communication, collaboration and teamwork, and organizational tools prepares the learner for the many demands of an entry-level systems analyst.

Prerequisite(s): (MTH 504 with a minimum grade of D- or MATH 504G with a minimum grade of D-) and (CMPL 512 with a minimum grade of D- or CMPL 612G with a minimum grade of D- or CMPL 415 with a minimum grade of D- or CMPL 515G with a minimum grade of D-).

Equivalent(s): MGMT 623G

Grade Mode: Letter Grading

View Course Learning Outcomes

  1. Describe the role of systems analyst within the organization.
  2. Demonstrate the skills required to conceptualize an information system.
  3. Successfully complete the initial analysis, problem definition, requirements definition, process modeling, and design phases of a realistic information systems case.
  4. Communicate the nature and requirements of the information system to all colleagues, regardless of their technology orientation or knowledge, through written and verbal proposals.
  5. Demonstrate the skills required to translate user requirements into concepts understood by designers/technicians.
  6. Use collaborative tools and techniques to function as an effective member of the information technology team in order to achieve system objectives. Of particular importance is the use of Web-based technologies to participate in team activities.
  7. Complete limited prototyping and programming associated with a project.
  8. Design high level database requirements for the information system, and develop the analytical skills necessary to evaluate vendor designs. These requirements include, but are not limited to, conceptual design and logical design documents resulting in entity-relationship diagrams and identification of key attributes.
  9. Present recommendations and findings in a public face-to-face or online forum and facilitate ensuing discussions.

View Course Learning Outcomes

CMPL 643 - Managing Information Technology

Credits: 4

This course helps students understand the important role of information technology in business strategy. Emphasizing the management of information technology rather than specific technical aspects, students explore the alignment of information technology with organizational goals, efficiencies gained through technology solutions, project management and the implementation of information technology, and organizational and industry changes driven by information technology. Investments in information technology for competitive advantage, the positioning of information technology in the organization, the pace of innovation in a digital economy, and emerging trends in information technology are discussed.

Prerequisite(s): MGMT 410 with a minimum grade of D- or MGMT 500G with a minimum grade of D- or PADM 500 with a minimum grade of D- or PADM 500G with a minimum grade of D- or MGMT 501G with a minimum grade of D- or MGMT 566 with a minimum grade of D- or MGMT 566G with a minimum grade of D-.

Equivalent(s): MGMT 624G

Grade Mode: Letter Grading

View Course Learning Outcomes

  1. Describe the importance of information technology as inextricable from business strategy and competitiveness.
  2. Review case studies and research from the field to discuss drivers of success and failure in information technology innovation, project management, and business implementation.
  3. Explore the history of technological innovation and its ongoing central role in business and management, from operational efficiency gains to change management paradigms.
  4. Analyze the impact of information technology on specific industries and within the global economy.
  5. Discover emerging trends in information technology and theorize about their potential impact on current practices and assumptions.

View Course Learning Outcomes

CMPL 644 - Special Topics: Upper Level

Credits: 1-4

The study of current and variable topics in Computer Science. Course content changes from term to term. It is expected that the learner will have prior coursework or experience in the subject area.

Repeat Rule: May be repeated up to unlimited times.

Equivalent(s): CMPL 644G

Grade Mode: Letter Grading

CMPL 660 - Mobile Application Development

Credits: 4

This course introduces students to programming technologies, design, and development related to mobile applications. Topics include application user interfaces, styling, navigation, simple animation, and Android and iOS-specific components and APIs. Students will program cross-platform mobile applications using JavaScript and React Native, an open-source user interface framework. Through course activities, students will have the opportunity to develop the skills needed to create basic applications for mobile devices.

Prerequisite(s): CMPL 530 with a minimum grade of D- or CMPL 530G with a minimum grade of D-.

Equivalent(s): CMPL 633G

Grade Mode: Letter Grading

View Course Learning Outcomes

  1. Describe the benefits and drawbacks of cross-platform mobile application development technologies.
  2. Explain the concepts and processes of mobile application development.
  3. Articulate the main design and development issues specific to mobile applications.
  4. Install and configure mobile application development tools and frameworks.
  5. Design and develop mobile application user interfaces.
  6. Utilize Android, iOS and other third-party APIs to enhance mobile application user experience. 
  7. Apply JavaScript programming concepts to mobile application development.

View Course Learning Outcomes

CMPL 665 - Web Application Development

Credits: 4

This course covers modern website design and development using Hypertext Markup Language (HTML), Cascading Style Sheets (CSS), and JavaScript. Students will learn the history and overall structure of the Internet and its key paradigms and technologies. Students will also learn how to design and code websites for various audiences and client technologies. The course will also cover current website management technologies including content management systems, JavaScript libraries, and website development frameworks.

Prerequisite(s): CMPL 530 with a minimum grade of D- or CMPL 530G with a minimum grade of D-.

Equivalent(s): CMPL 638G

Grade Mode: Letter Grading

View Course Learning Outcomes

  1. Describe how key paradigms, technologies, and culture in Internet history inform the design of features, functions, and engagement in Web application design.
  2. Create websites according to the principles of usability, use case, and W3C accessibility standards.
  3. Develop functional websites using appropriate HTML, CSS, and JavaScript markup.
  4. Employ the website development process, according to the principles of planning, design, development, and maintenance stages.
  5. Employ visual design, multimedia resources, dynamic content, and interactive elements as components of optimized user experience in a Web application.
  6. Describe how CMS are used to manage and maintain website content, security, and shared responsibilities.

View Course Learning Outcomes

CMPL 725 - Advanced Programming with Python

Credits: 4

This course introduces advanced programming skills and focuses on the core concepts of object-oriented programming (OOP) using Python, a high-level language. OOP shifts the focus from thinking about code as a sequence of actions, to looking at your program as a collection of objects that interact with each other. The course focuses on the understanding and practical mastery of object-oriented concepts such as classes, objects, data abstraction, methods, and the three tenets of OOP: encapsulation, inheritance, and polymorphism.

Prerequisite(s): CMPL 637 with a minimum grade of D- or CMPL 537G with a minimum grade of D-.

Equivalent(s): CMPL 625G

Grade Mode: Letter Grading

View Course Learning Outcomes

  1. Describe how object-oriented programming solves some key problems inherited in procedural programming.
  2. Demonstrate how classes are the basis of OOP code.
  3. Design a program that demonstrates how the methods of an object work with their instance variables.
  4. Apply the techniques used for managing any number of objects instantiated from the same class.
  5. Build interactive programs with a graphical user interface (GUI) using pygame.
  6. Use OOP techniques effectively within the pygame framework.
  7. Demonstrate how standard widgets such as images, buttons, and input or output fields can be built as classes, and how client code uses them.
  8. Implement the three main tenets of object-oriented programming (Encapsulation, Polymorphism, and Inheritance) in Python.

View Course Learning Outcomes

CMPL 795 - Integrative Capstone: Internship in Computer Information Tech and Tech Management

Credits: 4

This upper level course is a field-based experience designed to develop and hone the practical application skills of students in a Computer Information Technology or Technology Management major. Students apply for an internship at a self-selected site and negotiate the terms of the internship experience with a site supervisor under the auspices of their GSC internship mentor. The internship requires documented evidence of eighty hours of supervised experience and practice in a field setting where Computer Information Technology or Technology Management knowledge and skills are applied. This course is the capstone for the BS in Computer Information Technology and BS in Technology Management. NOTE: Registration for this course as an internship is by permission of the Office of Academic Affairs. Early registration deadlines may apply. Prior to capstone enrollment, students are expected to complete the majority of their required major courses. Students should consult with their advisor regarding specific major courses that may be completed with their capstone. NOTE: Students who were admitted to the college before Fall 2019 and have remained active in their original catalog year are not required to take IDIS 601.

Attributes: Writing Intensive Course

Prerequisite(s): (CRIT 602 with a minimum grade of D- or CRIT 602G with a minimum grade of D- or CRIT 502G with a minimum grade of D-) and (IDIS 601 with a minimum grade of D- or IDIS 601G with a minimum grade of D-).

Equivalent(s): CMPL 651G

Grade Mode: Letter Grading

View Course Learning Outcomes

  1. Apply knowledge of technology and research within the context of an individually developed project.
  2. Acquire and complete an in-depth supervised experience in a field setting that is related to the student's technology major and their chosen career path, thus bolstering their professional development.
  3. Integrate and apply technology skills and methods to a specific field setting, client population, or service clientele.
  4. Recognize the internship site's mission and identify how the organization and its services serve the community and its designated clientele.
  5. Acquire an experientially based knowledge foundation to inform and guide the student’s future career choices in a technology-related field.
  6. Demonstrate professionalism and standards of ethics while working in a field setting and articulate the nature and importance of ethical practice in the internship setting.
  7. Identify, document, and carry out performance objectives related to their job assignment.

View Course Learning Outcomes

CMPL 797 - Integrative Capstone: Best Practices in Information Technology

Credits: 4

This course is a project-oriented capstone learning experience that is designed to integrate learning from coursework with related work or other experience. Students focus on best practices in information technology and project management, with specific attention to their area of specialization. Students will complete an integrative project related to their program option and career interests. Prior to capstone enrollment, students are expected to complete the majority of their required major courses. Students should consult with their advisor regarding specific major courses that may be completed with their capstone. NOTE: Students who were admitted to the college before Fall 2019 and have remained active in their original catalog year are not required to take IDIS 601.

Attributes: Writing Intensive Course

Prerequisite(s): (CRIT 602 with a minimum grade of D- or CRIT 602G with a minimum grade of D- or CRIT 502G with a minimum grade of D-) and (IDIS 601 with a minimum grade of D- or IDIS 601G with a minimum grade of D-).

Equivalent(s): CMPL 650G

Grade Mode: Letter Grading

View Course Learning Outcomes

  1. Conceptualize the independent project including problem definition, general scope, and possible approaches.
  2. Compile a project plan for completing the independent aspect of the study.
  3. Develop functional and design specifications appropriate to the area of specialty.
  4. Analyze theory to select and document best practices for the independent project.
  5. Create a prototype of a specified portion of the independent project.
  6. Develop a test plan.
  7. Integrate design principles with methodology to create an implementation plan.
  8. Demonstrate an appropriate level of expertise in the professional application of tools in the area of specialty.
  9. Produce effective documentation for all aspects of the project.

View Course Learning Outcomes