CCOG for CIS 121 archive revision 201704

You are viewing an old version of the CCOG. View current version »

Effective Term:
Fall 2017 through Summer 2021

Course Number:
CIS 121
Course Title:
Computer Concepts II
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.

Intended Outcomes for the course

On completion of this course students should be able to:

  • Apply logic, business rules, and entity relationship diagrams to design 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.

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: 16

  1. Apply logic, business rules and entity relationship diagrams to design databases.
  2. Design a basic home wireless network and business network while utilizing current wireless security.
  3. Solve simple quantitative and qualitative problems using computer programming.
  4. Install and manage operating systems and applications.
  5. 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.
  • Calculating best design for database based on business rules
  • Risk analysis relating to security
  • Computing size and impact of operating systems on system performance