CCOG for CIS 121 Spring 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
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 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: 26- Construct databases from Entity Relationship Diagrams
- Analyze 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.
- 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