CIA 3215: COMPUTER TECHNOLOGY & DATA PROCESSING (45 LH)
PURPOSE OF THE COURSE
Provide an understanding of the functioning and application of the computer in information technology.
EXPECTED LEARNING OUTCOME
By the end of this course the learner should be able to:
- Use the basic input and out devices for a computer.
- Appropriately store and retrieve data files as well as editing them.
- Design database and manage it.
COURSE CONTENT
Fundamentals and classification of computers. Information and data. Bit and byte. Analog and digital. Hardware: input devices, output devices, storage devices, and Central Processing Unit (CPU) and control devices. Software: system software, operating systems, compiling systems and utilities. Data files: random and sequential. Disk storage: track, sector, cluster and face. Variable and character codes: American Standard Code for Information Interchange (ASCII). Numbers: fractions, integers, single precision, double precision, binary, octal and hexadecimal numbers. Operator and logical operations. Errors generated by computers. Introduction to software packages: word processing, spreadsheets and database management. Database management system: creating a database structure, entering and amending data, retrieval and manipulation of data, report production, database administration and security.