CCOG for CIS 121 Fall 2024


Course Number:
CIS 121
Course Title:
Information Systems and Programming
Credit Hours:
4
Lecture Hours:
30
Lecture/Lab Hours:
0
Lab Hours:
30

Course Description

Covers evaluation, selection and application of computer technology to solve practical problems in web page design, database design, networking and programming. Addresses security and ethical issues associated with technology. Recommended: CIS 120. Audit available. Prerequisites: WR 115, RD 115 and MTH 20 or equivalent placement test scores.

Intended Outcomes for the course

Upon completion of the course students should be able to:

  • Construct databases from Entity Relationship Diagrams.
  • Analyze databases.
  • Create web sites using current HTML and CSS standards.
  • Design a basic home wireless network and business network while utilizing current wireless security.
  • Solve simple quantitative and qualitative problems using computer programming.
  • Install and manage operating systems and applications.
  • Weigh security issues related to technology including viruses and spyware.
  • Identify ethical issues relating to the IT professional.

Quantitative Reasoning

Students completing an associate degree at Portland Community College will be able to analyze questions or problems that impact the community and/or environment using quantitative information.

General education philosophy statement

CIS 121 provides a survey of Information Technology topics. This relates to the Gen Ed Philosophy that Gen Ed courses should further students’ “understanding of themselves and their natural and technological environments.” In particular, CIS 121 covers how computers function, the ethical and security concerns of computer use, and how databases affect students’ lives. CIS 121 also covers fundamental programming concepts, which relates to the Gen Ed principle that students should be able to reason qualitatively and quantitatively.

Course Activities and Design

Web (HTML / CSS)

  • CSS box model
  • Lists and Tables

Ethics for IT Professionals

  • Responsibilities to Employers, Clients, Society

Security

  • Risks
  • Malware (viruses, spyware, hacking)
  • Security strategy

Software

  • Integrated 欧洲杯决赛竞猜app_欧洲杯足球网-投注|官网ment Environments (IDEs)
  • Programming Languages
  • Simple coding exercises

Database Management Systems

  • Data Models including Hierarchical, Network, Relational and Big Data
  • Client-server vs. local Database Management Software (DBMS) applications
  • Entity Relationship Diagrams
  • Database creation

I

Networks and Data Communications

  • Networking Hardware
  • Networking Models
  • OSI, TCP/IP
  • Virtualization

Outcome Assessment Strategies

In satisfying the assessments, students must demonstrate at least 3 of the following:

  • Service Learning
  • Contextual written tasks in or outside of class.
  • Written case study analysis.
  • Individual or team projects.
  • Presentations
  • Quizzes and/or examinations.
  • In-class interactive role-plays
  • Participation
  • Self-Assessment
  • Create installation, how it works or training material for some aspect of computer technology

Related Instruction

Computation
Hours: 26

  1. Construct databases from Entity Relationship Diagrams
  2. Analyze databases
  3. Design a basic home wireless network and business network while utilizing current wireless security.
  4. Solve simple quantitative and qualitative problems using computer programming.
  5. Install and manage operating systems and applications.
  6. Weigh security issues related to technology including viruses, spyware

Direct instruction (+ study time) in discipline-related computations involving:

  • Boolean algebra and arithmetic expression construction and evaluation as applied in programming and networking.
  • Analyzing databases
  • Constructing a database from an Entity Relationship Diagram
  • Analyzing datasets for their impact on community
  • Risk analysis relating to security
  • Computing size and impact of operating systems on system performance