CTA 103 - Theories and Applications of Digital Technology

• 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.