Sep 23, 2020  
2016-2017 Catalog 
    
2016-2017 Catalog [PAST CATALOG]

CTA 103 - Theories and Applications of Digital Technology

4 credit hours - Four hours of lecture and directed laboratory weekly; one term.
(formerly CSI 113 - Theories and Applications of Digital Technology)

This course meets the Computer Technology General Education Requirement. This course meets the Computing and Information Technology Competency Requirement.

Learn digital representation of information, data communications, computer networks, database systems, and security. Learn computer hardware and software, the Internet and Web technologies, operating systems, software development, information systems, computer ethics, and social issues.   Use hands-on lab experiences to incorporate the knowledge of hardware and software.  Lab fee $25.

Prerequisite(s): Eligibility for ENG 111  or ENG 115  or ENG 121 .

Crosslisted: Also offered as CTA 103H ; credit is not given for both CTA 103 and CTA 103H .

Note: This is the first course in computing for students planning to major in a technology field and an excellent choice for students interested in science, engineering and mathematics. Credit is not given for both CTA 100  and CTA 103 .

Course Outcomes
Upon successful completion of this course, students will be able to:
 

  • Explain the functionality of the hardware and software components of a computer system.
    • Define hardware and software components
    • Define binary and digital concepts
    • Discuss history of computing to include diversity topics
    • Define primary storage to include RAM, ROM and cache
    • Define the Arithmetic/Logic Unit (ALU) and Control unit
    • Define input, output and secondary storage
    • Discuss different types operating systems
    • Define file management systems such as NTFS and FAT
    • Discus operating system functions such as management of memory, resources, tasks and scheduling.
  • Debate environmental and safety issues related to computer technology.
    • Discuss safety issues
    • Discuss green technology to include disposal, recycling, energy cost and emissions
  • Identify methods for securing hardware, software and information.
    • Discuss securing hardware using surge protectors, uninterruptable power supplies (UPS), and batteries
  • Explain the purpose and functions of data communications and networks.
    • Define data communications and networks
    • Define physical attributes such as topology
    • Define media transmission: wired and wireless
    • Define and discuss Local Area Networks and Wide Area Networks
    • Discuss OSI model and  TCP/IP  layer protocols and standards
    • Discuss performance characteristics such as bandwidth and latency
    • Discuss peer to peer networks and client/server networks
  • Describe the history, services, impact, security, and uses of the Internet.
    • Discuss the history of the Internet
    • Discuss the social networking, business/E-commerce and Global learning
    • Discuss search engines and perform searching using Boolean logic
    • Assess information quality and use correct citation
    • Discuss Browsers and browser security and use hardware and software filters to limit Web access and accessibility
    • Create a web page using proper design, coding and implementation.
  • Explain the structure, purpose, and use of databases.
    • Define the purpose of a Database system
    • Define relational and object oriented model
    • Define classification data types and indexing
    • Create queries using Structured Query Language (SQL) and Query by Example (QBE)
    • Create forms and reports
    • Discuss data entry techniques and verify the data integrity
  • Create a database applying appropriate design and development techniques.
    • Design and build tables using data hierarchy, entity relations diagrams and normalization
    • Create queries using Structured Query Language (SQL) and Query by Example (QBE)
    • Create forms and reports
  • Explain the process and terminology associated with developing a computer program
    • Define an algorithm and a program
    • Define program interpretation such as compilers and interpreters
    • Define structure theorem (sequence, selection and repetition
  • Develop a working computer program using a programming language and applying the structure theorem.
    • Define variables and constants
    • Discuss programming languages
    • Discuss secure programming
  • Describe the phases in the Systems Development Life Cycle and the role and characteristics of information systems in organizations.
    • Define the role Information systems in organizations
    • Define TPS and other types of information systems
    • Define systems analysis and design as it relates to the steps in the System Development Life Cycle
    • Define information assurance, security and resource management
    • Discuss the role of the Chief Information Officer and other Information Technology Careers
  • Describe ethical, social, and emerging issues related to computer technology.
    • Discuss ethics and ethical decision making as it pertains to privacy, social and security issues
    • Define intellectual property such as digital rights management and fair use
    • Discuss the code of conduct
    • Define cybercrime and cyberterrorism
    • Define assistive technology and ergonomics
  • Use the basic features of word processing, spreadsheet, Internet search, presentation, e-mail and database management software.
Core Competencies
Core 4 Personal Wellness Core 8 Social and Civic Responsibility