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