Computer Concepts II

Course Number: CIS 121
Transcript Title: Computer Concepts II
Created: September 1, 2012
Updated: June 7, 2016
Total Credits: 4
Lecture Hours: 30
Lecture / Lab Hours: 0
Lab Hours: 30
Satisfies Cultural Literacy requirement: No
Satisfies General Education requirement: No
Grading options: A-F (default), P-NP, audit
Repeats available for credit: 0

Prerequisites

Course Description

Covers evaluation, selection and application of computer technology to solve practical problems in database design, web page design, networking and programming. Addresses ethical issues associated with technology. Prerequisite: CIS 120. Audit available.

Intended Outcomes

  1. Apply logic, business rules and entity relationship diagrams to design databases.
  2. Create web sites using latest HTML and CSS standards.
  3. Design a basic home wireless network and office 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 ethical issues related to technology including viruses, spyware, hacking and risk assessment.

Outcome Assessment Strategies

Assessment may include:  Projects with original work, computer problem solving exercises, web page design, journals, case studies, group discussions, and open ended assessments.

Course Activities and Design

Activities may include: online readings and videos, class discussions, reflection writings, open ended assignments such as creating an installation, how it works or training material for some aspect of computer technology.

Course Content (Themes, Concepts, Issues and Skills)

  • Hardware
    • How data is represented in hardware
    • Number systems and coding schemes
  • Software
    • Operating Systems
      • Stand-alone, Network, Embedded
      • Shell, GUI and Command Line
      • Services
    • Spreadsheets
      • Numeric modeling and analysis
    • Database Management Systems
      • Data Models including Hierarchical, Network and Relational
      • Client-server vs. local Database Management Software¬†(DBMS) applications
    • Integration of Productivity Software
      • Integrated Development Environments (IDE's)
      • Programming Languages
      • Markup Languages (XML)
      • Career-specific software
  • Society
    • Risks
      • Malware (viruses, spyware, hacking)
      • System failure
      • Security
    • Future/Trends of Computer Technology
      • Robotics/Automation
      • Artificial Intelligence
      • Expert Systems
  • Integration
  • Introduction to Networks and Data Communications
    • Local Area Networks
    • Wide Area Networks
    • Network Security
    • Wireless
    • Home Networks
    • IP Protocols (FTP, HTTP)
  • Using the Internet Effectively
    • Enterprise Systems
    • Automation
    • Portals
    • Web Services
    • Virtual Private Networks (VPN's)
    • Enterprise Hardware
    • Concepts and Theoretical Models
  • Project Management