Computer Fundamentals and Applications

Course Title: Computer Fundamentals and Applications

Course No: BCA 101

Nature of the Course: Theory + Lab

Semester: 1

Full Marks: 60 + 20 + 20

Pass Marks: 24 + 8 + 8

Credit Hours: 3

Course Description

This course covers the concepts of basic computer fundamental knowledge and its application to solve real life problems. This course including basic introduction, its types and Application various types in various fields, computer software and hardware, operating system, database management system and computer networks and recent trends technology developed and used in computer and ICT. It also aims at helping students convert theoretical concept into practical skill through the use of different application packages including word processor, spreadsheet package, presentation package and photo editing graphical package and others tools and application use in computer.

Course Objectives

The main aims of this course are to provide fundamental concepts of information and communication technology and to make students capable of using different application packages in their personal as well as professional life. The general course objectives of this course are outlined as: To familiarize students with fundamental knowledge about computer system; To make students understand software, hardware and their working procedure; To enhance student's knowledge about various software and its types; To provides the knowledge about database management system and nature of data use in computer; To provide knowledge about computer networking knowledge and internet use; To enhance students' knowledge about computer security and computer threat; To provide the knowledge about the recent trends and technologies use in ICT.

Course Contents

1. Introduction to computer

5 hrs

1.1. Definition, characteristics of computer

1.2. Anatomy of computer

1.3. Types of computers (size, principle, brand and purpose)

1.4. History of computer and generation

1.5. Application of computer

2. Computer Hardware

10 hrs

2.1. Basic computer Organization and Architecture

2.2. Component of computer (hardware, software, user, data and procedure)

2.3. Component of CPU (ALU, CU and RA)

2.4. Computer memory, Memory Hierarchy, Primary and Secondary memory

2.5. Motherboard and its parts, slots, ports, interface, processor, memory chips

2.6. BIOS, SMPS, CMOS, and Microprocessor chips

3. Computer software

10 hrs

3.1. Introduction to Software, program

3.2. Types of Software (System and Application)

3.3. Operating System (Function and types)

3.4. Utility Software, Virus and Antivirus Software

3.5. Programming language and Types of language Translator

4. Database management System

5 hrs

4.1. Introductions to data, database and DBMS

4.2. Database system Architecture

4.3. Database Model, database Application

4.4. SQL and No SQL concepts

4.5. Introduction to data warehousing

4.6. Data mining and concept of big data

5. Computer Network and Internet

5 hrs

5.1. Introductions to Network, Intranet, Internet

5.2. Types of networks, LAN Topologies

5.3. Transmission media, Network devices

5.4. Data Communication, Transmission Mode

5.5. OSI reference model, Network Protocol

5.6. Concept of web, and www, URL, DNS, client server

6. Computer Security

8 hrs

6.1. Introduction: security Threat and security attacks

6.2. Malicious Software and types of viruses

6.3. Security Mechanisms (Cryptography, Digital Signature)

6.4. Firewall, users Authentication, intrusion Detection System

6.5. Security Awareness and Security Policy

7. Contemporary Technology

5 hrs

7.1. Introduction to AI, AI and Its applications

7.2. Machine Learning, Neural network (basic concepts)

7.3. Blockchain Technology and bitcoin

7.4. IoT, cloud computing and its use

7.5. Virtual and Augmented Reality

Laboratory Works

Laboratory works of 48 hrs covering: Office automation, Word-processor, Spreadsheet, Presentation, Basic DOS commands, Basics of window and user interface, and Computer communication and Internet.

1.Office automation
2.Word-processor
3.Spreadsheet
4.Presentation
5.Basic DOS commands
6.Basics of window and user interface
7.Computer commination and Internet

Text Books

1.Goel, A. (2010). Computer fundamental, Pearson Education India.
2.Leon, A. & Leon (2010). Fundamental of information technology. Leon Techworld
3.Norton, P. (2017). Introduction to computer, 7th Edition, McGraw Hill Education.
4.Sinha, P.K. (2003). Computer Fundamentals, BPB Publication

Information Technology

Information Technology

Select University

Select Program

TabFlux . Computer Fundamentals and Applications . TU . BCA

Computer Fundamentals and Applications

Course Description

Course Objectives

Course Contents

Laboratory Works

Text Books