ITE 107: Integrated IT Systems and Emerging Technologies

Course Description

This course is designed to build upon foundational knowledge, diving deeper into complex topics such as database management, advanced networking, cybersecurity practices, systems analysis, and software development. Topics include SQL database queries, object-oriented programming concepts, network infrastructure design, risk assessment strategies, and the integration of emerging technologies into existing systems. Progress is assessed through quizzes, assignments, and a project.  (3 credits)

Prerequisite

  • ITE 105: Computer Information Systems

Student Learning Outcomes (SLOs)

Students who successfully complete this course will be able to:

  1. Analyze complex database structures and elevate your ability to manipulate and retrieve data using advanced SQL queries.
  2. Evaluate network infrastructures to identify potential vulnerabilities and formulate strategies to mitigate cybersecurity risks.
  3. Create robust and efficient object-oriented programs that solve real-world business problems, adhering to industry-standard software development practices.
  4. Synthesize knowledge of various information systems to provide comprehensive systems analysis and design sustainable and scalable solutions.
  5. Apply critical thinking to assess the impact of emerging technologies and integrate them innovatively into existing computer information systems.
  6. Demonstrate proficiency in implementing virtualization technologies, including server virtualization, network virtualization, and storage virtualization, to enhance resource utilization and flexibility.
  7. Demonstrate a comprehensive understanding of common security threats, vulnerabilities, and attack vectors relevant to software development.
  8. Achieve a proficiency level where the individual can successfully contribute to each phase of the Software Development Life Cycle (SDLC).

Course Activities and Grading

AssignmentsWeight
Discussions (Weeks 1-8)

6%

Quizzes (Weeks 1-8)

34%

Labs (Weeks 1, 3-5, 7-8)

60%

Total

100%

Required Textbooks

  • This course uses Open Educational Resources (OER). OER are openly licensed, educational resources that can be used for teaching, learning and research. OER may consist of a variety of resources such as textbooks, videos and software that are no cost for students.

Course Schedule

Week

SLOs

Readings and Exercises

Assignments

1

1

Topic: Advanced Database Concepts

  • Readings:
    • Introduction to NoSQL Databases - Modules 1-3
  • Review Getting Started information
  • Review course syllabus
  • Read assigned material
  • Review the lecture material
  • Participate in the Discussions
  • Submit the Week 1 quizzes and labs

2

3

Topic: Object-Oriented Programming and Design Patterns

  • Readings:
    • Programming in Python - Module 3
  • Read assigned material
  • Review the lecture material
  • Participate in the Discussions
  • Submit Week 2 quiz

3

8

Topic: Software Development Life Cycle

  • Readings:
    • Introduction to Agile Development and Scrum - Modules 1-3
  • Read assigned material
  • Review the lecture material
  • Participate in the Discussions
  • Submit the Week 3 quizzes and labs

4

2,7

Topic: Application Security, Risks and Threats

  • Readings:
    • Application Security for Developers and DevOps Professionals - Modules 1-4
  • Read assigned material
  • Review the lecture material
  • Participate in the Discussions
  • Submit the Week 4 quizzes and labs

5

4

Topic: Enterprise Systems and Resource Planning

  • Readings:
    • Project Management Foundations, Initiation, and Planning - Modules 1-5
  • Read assigned material
  • Review the lecture material
  • Participate in the Discussions
  • Submit the Week 5 quizzes and labs

6

5

Topic: Advanced Systems Analysis and Design

  • Readings:
    • Project Planning: Putting It All Together - Modules 1-5
  • Read assigned material
  • Review the lecture material
  • Participate in the Discussions
  • Submit the Week 6 quizzes

7

6

Topic: Cloud Computing and Virtualization

  • Readings:
    • Introduction to Cloud Computing - Modules 1-5
  • Read assigned material
  • Review the lecture material
  • Participate in the Discussions
  • Submit the Week 7 quizzes and labs

8

5

Topic: Integration of Emerging Technologies

  • Readings:
    • Machine Learning with Apache Spark - Modules 1-3
  • Read assigned material
  • Review the lecture material
  • Participate in the Discussions
  • Submit the Week 8 quizzes and labs

COSC Accessibility Statement

Charter Oak State College encourages students with disabilities, including non-visible disabilities such as chronic diseases, learning disabilities, head injury, attention deficit/hyperactive disorder, or psychiatric disabilities, to discuss appropriate accommodations with the Office of Accessibility Services at OAS@charteroak.edu.

COSC Policies, Course Policies, Academic Support Services and Resources

Students are responsible for knowing all Charter Oak State College (COSC) institutional policies, course-specific policies, procedures, and available academic support services and resources. Please see COSC Policies for COSC institutional policies, and see also specific policies related to this course. See COSC Resources for information regarding available academic support services and resources.