Fundamental of Computer and Information System

Course Title: Fundamental of Computer and Information System

Course No: CS.Ed.111

Nature of the Course: Theory + Lab

Semester: 1

Full Marks: 40 + 40 + 20

Pass Marks: 18 + 18 + 9

Credit Hours: 3

Course Description

The idea behind this course is to explore various different ways in which information technology and Information Systems relates to system automation and goals in an organizational context, given the increasing inter-relationship between these two in today's global world. The course aims to acquaint the students with basic concepts of Computer Fundamental and Information Technology Theory and Practical. The course incorporates nine units. The first two unit's deals with the introductory part of Computer System. The Third unit concerns with practical aspects of Office Automation tools such as Word Processor, Spreadsheet, Database and Presentation. Unit four discuss the Information system and its roles in an organizations and education. Unit five introduce the Number System and concept of codes in computer system. The sixth unit deals with Telecommunication and Computer Network. The seventh unit discuss the Database Management System and its roles in organizations. The eighth unit introduce the Internet and modern computing trends. The ninth unit discuss the security threats and solutions.

Course Objectives

The main objective of this course is to introduce the students with different aspects of Information Technology and Computer System for the ease of transaction processing in an organization. The other objectives of this course are as follows: a) To know the fundamentals of computers; b) To understand how to use computer applications in day to day operations; c) Assess and explain global issues surrounding the adoption of information technology; d) To understand how to use Information Systems in an Organizations; e) To understand how to use Network, Internet and other recent trends in business; f) To gain the knowledge of computer security techniques and threat.

Course Contents

1. Fundamental of Computer

5 hrs

1.1. Computer system concepts, Computer system characteristics, Capabilities and limitations, History of Computer, Generations of computers

1.2. Types of computers (work, size, brand & model)

1.3. Basic components of a computer system – CPU (CU, ALU, RA), Input/ Output Devices and characteristics and memory (Primary (RAM, ROM, Cache) and secondary Memory)

2. Computer Software and Classification

4 hrs

2.1. Software and its Need, Types of Software - System software and Application software.

2.2. System Software - Operating System, Language Processor (Compiler, Interpreter and Assembler) Utility software.

2.3. Types and Functions of Operating System, files & directory structure and its naming rules, booting process.

2.4. Programming languages and Types: Low level (Machine and Assembly), High (Procedural and problem oriented) and Natural Language and their merits and demerits.

3. Office Automation Software

7 hrs

3.1. Introduction

3.2. Word processor

Characteristics of word processor

Creating and formatting documents

Managing page number, header and footer

Proofing a documents

Inserting Object from other applications

Mail merge, Macro, hyper link

Inserting table and other objects

Inserting citation in APA and other formats

3.3. Spreadsheet Application and characteristics

Creating, formatting and printing worksheets

Working with mathematical, logical, financial and statistical functions.

Creating, formatting and printing graphs

3.4. Presentation Software and its Characteristics

Creating presentation

Working on design, animation and slide transition

Working on template of slide

Working and master slide

4. Information System

5 hrs

4.1. Introduction to Information System

4.2. Terminologies in IS: Data, Information and Knowledge

4.3. Activities in IS: Inputting, Processing, Storing, Out putting and feed back

4.4. Components of Information System

4.5. Computer Based Information System and Components

4.6. Roles of Information System in an organization

4.7. Types of Information Systems (TPS, MIS, DSS, ESS)

5. Number System and Their Conversion

3 hrs

5.1. Binary, Octal, Decimal, Hexadecimal Number System & conversion

5.2. Calculation in Binary – addition, subtraction

5.3. Introduction to EBCDIC, ASCII, and Unicode

5.4. Unit Case Study

6. Telecommunication and Computer Network

6 hrs

6.1. Introduction Computer Network and Telecommunication

6.2. Communication Process(model)

6.3. Mode of Communication (Simplex, Half Duplex, Full Duplex)

6.4. Types of Computer Network (Based on Geographical area and Architecture)

6.5. Network Topology and Types: Bus, Ring, Star, Tree, Mesh and Hybrid with merits and demerits.

6.6. Types Transmission Media(Channel): Wired and Wireless

6.7. Networking Connecting Devices (Switch, Router, Hub, Bridge, NIC)

6.8. Business value of Telecommunications.

6.9. Telecommunication Systems in Nepal.

7. Database Management System

7 hrs

7.1. Introduction to Database

7.2. Application of Database and Database Management System

7.3. Advantages of DBMS over File System

7.4. Types of Database: Centralized, Distributed, Operational, Hypermedia and Analytical

7.5. Concepts of keys in DBMS (Primary and foreign)

7.6. Creating Database on MS-Access

7.7. Introduction to Data Warehouse and Data-Mining

8. Internet Web and Current Trends in Computing

4 hrs

8.1. Introduction and History of Internet

8.2. Internet Terminologies: Client, server, browser, web page, web site, search engine, URL, DNS, IP address

8.3. Services Provided by Internet

8.4. Cloud Computing

8.5. Green Computing

8.6. Virtual Computing

8.7. Edge Computing

8.8. Big Data Analysis

8.9. Cyber Security

8.10. IOT

8.11. E-learning, E-Library, Tele-medicine

8.12. Introduction to e-commerce and m-commerce: Types and advantages

8.13. Introduction to E-governance and Types

9. Computer Security

4 hrs

9.1. Introduction to Computer Security

9.2. Security threat and attacks: Viruses and worms, Hacking, cyber theft, cyber terrorism, unauthorized use at work, Piracy: Software and intellectual Property

9.3. Security Techniques: Cryptography, Digital Signature, Firewall, Antivirus, User Identification and Authentication, Intrusion Detection Systems

Laboratory Works

Students should write programs and prepare a lab sheet for each topic discussed in class (centered on Unit III: Office Automation tools - Word Processor, Spreadsheet, Database and Presentation). Minimum 3 lab hours per week required; nature of programming problems may be decided by the instructor. Practical examination: 3 hours, conducted by an external examiner with an internal examiner assisting. Evaluation: Practical Report Copy 5 marks, Viva 5 marks, Practical Exam 10 marks (Total 20 marks).

Text Books

1.Norton, P. (2006). Introduction to computers. McGraw-Hill. (Unit I-IX)
2.Rajaraman, V. (2018). Introduction to information technology. Prentice-Hall of India. (Unit I-IX)
3.O'Brien, J. A. (2017). Introduction to information system. Tata Mc-Graw Hill. (Unit I-IX)

Reference Books

1.Turban, E., Rainer, R. K., & Potter, R. E. (2001). Introduction to information technology. John Wiley & Sons.
2.Bhatt, B.P., Chataut, G.P., & Bhatt, H.S. (2076 B.S.). Fundamental of computer and information system. Dreamland Publication.

Notes:

Theory Period Per Week: 3. Total Periods: 45 (theory) + 15 (practical, 2 hours per period). Full Marks: 100, Pass Marks: 45. Internal Evaluation: 40%, External Theory (Final) Examination: 40%, External Practical Examination: 20%. Strict Notice: each student must secure 40% marks with 80% attendance in internal evaluation to qualify for the End-Term Examinations; otherwise the student is marked NOT QUALIFIED (NQ).

Computer & IT Fundamentals

Computer & IT Fundamentals

Select University

Select Program

TabFlux . Fundamental of Computer and Information System . FWU . B.Ed. CS

Fundamental of Computer and Information System

Course Description

Course Objectives

Course Contents

Laboratory Works

Text Books

Reference Books

Notes: