Computer Fundamentals and Applications

Course Title: Computer Fundamentals and Applications

Course No: CACS101

Nature of the Course: Theory + Lab

Semester: 1

Full Marks: 20 + 20 + 60

Pass Marks: 8 + 8 + 24

Credit Hours: 4

Course Description

This course offers fundamental concepts of computer and computing which includes introduction to computer system, computer software & database management system, operating system, data communication & computer network and contemporary technologies. 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.

Course Objectives

Upon the conclusion of the course, students should be able to: - Provide fundamental concepts of information and communication technology - Make students capable of using different application packages in their personal as well as professional life

Course Contents

1. Unit 1: Introduction to Computer System

16 hrs

1.1. Introduction to Computer, Characteristics of Computer, Applications of Computer

1.2. Classification of Computer, Mobile Computing

1.3. Anatomy of a Digital Computer, Computer Architecture

1.4. Memory & Its Classification, Input devices, Output Devices, Interfaces

2. Unit 2: Computer Software

3 hrs

2.1. Introduction to Software, Types of Software, Program vs. Software

2.2. Computer Virus and Antivirus

3. Unit 3: Operating System

4 hrs

3.1. Introduction to Operating System, Function of Operating System

3.2. Types of Operating System, Open Source Operating System

4. Unit 4: Database Management System

8 hrs

4.1. Introduction to DBMS, Database Models

4.2. SQL, Database Design and Data Security

4.3. Data Warehouse, Data Mining, Database Administrator

5. Unit 5: Data Communication and Computer Network

10 hrs

5.1. Introduction to communication system, Mode of Communication

5.2. Introduction to Computer Network, Types of Computer Network

5.3. LAN, Topologies, Transmission Media, Network Devices

5.4. OSI Reference Model, Communication Protocols

5.5. Centralized vs. Distributed System

6. Unit 6: Internet and WWW

6 hrs

6.1. Internet: Introduction to Internet and its Applications, Connecting to the Internet

6.2. Client/Server Technology, Internet as a Client/Server Technology

6.3. Email, Video-Conferencing, Internet Service Providers, Domain Name Server

6.4. Internet Address, Internet Protocols (IP, TCP, HTTP, FTP, SMTP, POP, Telnet, Gopher, WAIS)

6.5. Introduction to Intranet, Internet vs. Intranet vs. Extranet

6.6. Advantages & Disadvantages of Intranet

6.7. World Wide Web (WWW): World Wide Web and Its Evolution, Architecture of Web

6.8. Uniform Resource Locator (URL), Browsers: Internet Explorer, Netscape Navigator, Opera, Firefox, Chrome, Mozilla

6.9. Search Engine, Web Servers: Apache, IIS, Proxy Server, HTTP Protocol, FTP protocol

7. Unit 7: Contemporary Technologies

13 hrs

7.1. Multimedia, e-Commerce, e-Learning, e-Governance, e-Banking

7.2. Hypermedia, Geographical Information System, Virtual Reality, Augmented Reality

7.3. Artificial Intelligence, Ambient Intelligence, Robotics, Bit Coin

Laboratory Works

1. Operating System (10 Hrs.)
a. GUI Based OS (Windows): Interface, Task Bar, File Management, Accessories, Multimedia, Installation, etc.
b. CUI Based OS (DOS): Internal and External Commands.

2. Word Processor (12 Hrs.) - MS Word (All features: Formatting, Tables, Mail Merge, Macros, etc.)

3. Spreadsheet Package (12 Hrs.) - MS Excel (Formulas, Charts, Pivot Tables, What-if Analysis, Macros, etc.)

4. Presentation Package (6 Hrs.) - MS PowerPoint (Animations, Transitions, Multimedia, etc.)

5. Photo Editing Package (20 Hrs.) - Adobe Photoshop (All tools, Layers, Filters, Image Restoration, Web Graphics, etc.)

Text Books

1.Alexis Leon, Mathews Leon, “Fundamentals of Information Technology, 2/e”, Vikas Publishing House Pvt Limited, 2009, ISBN: 9788182092457
2.E Balagurusamy, “Fundamentals of Computers,” Tata McGraw Hill Education PVT.Ltd., 2009, ISBN: 9780070141605
3.Peter Norton’s, “Introduction to Computers”, 7th Edition, Tata McGraw-Hill, 2010, ISBN: 9780070671201

Reference Books

1.Brad Dayley & DaNae Dayley, “Adobe Photoshop CS6 Bible”, Wiley Publishing Inc., 2012, ISBN: 978-1-118-12388-1
2.Faithe Wempen, “Microsoft Office Power Point 2007 Bible (With CD)”, Wiley Publishing Inc., 2007, ISBN: 978-0470043684
3.Herb Tyson, “Microsoft Office Word 2007 Bible (With CD)”, Wiley Publishing Inc., 2007
4.Jim Boyce, “Windows 7 Bible”, Wiley Publishing Inc., 2009, ISBN: 978-0470509098
5.John Walkenbach, “Microsoft Office Excel 2007 Bible (With CD)”, Wiley Publishing Inc., 2007, ISBN: 978-0470044032
6.Pradeep Sinha and Priti Sinha, “Computer Fundamentals (with CD)”, 6th Edition, BPB Publications, 2003, ISBN: 9788176567527
7.Ramesh Rimal & et. al., “Computer Science-I, Revised Edition”, Buddha Academic Publishers and Distributors Pvt. Ltd. Nepal, 2013
8.Ramesh Rimal & et. al., “Computer Science-II, Revised Edition”, Buddha Academic Publishers and Distributors Pvt. Ltd. Nepal, 2013

Notes:

This syllabus follows the official BCA curriculum of Tribhuvan University. In case of any doubt or revision, the university's published syllabus shall be considered authoritative.

Computer & IT Fundamentals