Questions
Syllabus
Qns. By Syllabus

Semester

Subject

Bachelors Level/First Year/First Semester/Science bit/first semester/introduction to information technology/syllabus

Bachelors In Information Technology

Institute of Science and Technology, TU

Nature of the course: (Theory+Lab)

F.M: 60+20+20 P.M: 24+8+8

Credit Hrs: 3Hrs

Introduction to Information Technology [BIT101]
Course Objective
i.
The main objective of this course is to provide basic knowledge of fundamental concepts of computer system and Information Technology.
Course Description

This course covers basic concepts of computers, computer hardware, memory,input/output devices, computer software, data representation, database, computer networks, internet,computer security and applications of IT.

S1:Introduction to Computer[4]
1
Introduction of Computer: Definition and use of computers
2
Characteristics of Computer: Characteristics of computer (Speed, accuracy, diligence, storage capability, versatility)
3
History of Computer: History of computing of how computers evolved from their humble beginnings to the machines of today
4
Generations of Computer: Generations of computers from first to fifth with varying hardware and software technologies
5
Digital and Analog Computers: Definition and uses of digital and analog computers with example. Differences between digital, analog and hybrid computers
6
Classification of Computer based on size: Classification of computers based on size and type: super-computer, mainframe-computer, minicomputer, micro-computer. Characteristics of each class
7
The Computer System: The computer system and their components (Hardware, software, data, users)
8
Application of Computers: Applications of computers in different sectors like education, health, agriculture, entertainment, scientific research, sports etc
S2:Computer Hardware (Introduction, Computer memory, Input and Output Devices)[8]
1
Central Processing Unit; Components of CPU: CPU and its functions. Different components of CPU (arithmetic logic unit, registers, control unit)
2
Instruction Format: What is instruction format? Concept of operation code and operand code
3
Instruction Set: Definition and example of instruction set
4
Instruction Cycle: What is Instruction cycle? Fetching, decoding, executing, and storing steps of instruction cycle
5
Microprocessor: RISC and CISC based architecture. Concept of pipeline and parallel processing
6
Computer Bus: Concept and types of bus. Concept of expansion slots and ports
7
Components of Computer Cabinet: Different components inside a computer cabinet like motherboard, ports and interfaces, expansion slots, memory chips, processor, hard disk etc
8
Memory Representation: Description of bit, byte, kilobyte, megabyte, gigabyte and terabyte and Concept of memory organization as a linear array of locations for storing data
9
Memory Hierarchy: Memory hierarchy from registers to magnetic tape
10
CPU Register: Description of CPU registers as working memory
11
Cache Memory: Description cache memory and its levels
12
Primary Memory (RAM, ROM): What is primary memory? Different types of primary memory
13
Secondary Memory: Secondary memory and their types. Working characteristics and features of Magnetic Tape, Magnetic Disk, Optical Disk, Magneto-Optical Disk, Flash Memory Device
14
Access types of storage devices: Definition and characteristics of Sequential access and direct access devices
15
Input-Output Unit: Definition, uses of input/output devices and how it works
16
Input Devices: Definition of Human Data Entry Devices and Source Data Entry Devices. Features and description of Human data entry devices and Source data entry devices
17
Output Devices: Definition, uses of output devices and how it works. Classification and functional details of Output devices (Hard copy and soft copy devices)
18
I/O Port: Use of I/O ports, types I/O ports
19
I/O System: Explain the working of I/O system—I/O devices, device controller, device driver, Application Programs
S3:Computer Software (Introduction, Operating System)[6]
1
Types of Software: Classification of software (System software and Application software)
2
System Software: Functionality and purpose of system software
3
Device Drivers and Utility software: Function and example of Device Drivers and Utility software
4
Programming Languages: Definition and categories of Programming Languages. Different Generations of Programming Languages
5
Language Translators: Different kind of translator software (Assembler, Compiler, and Interpreter) and function of each
6
Application Software: Functionality and purpose of application software
7
Introduction: Explain the need of operating system in the computer system
8
Objectives of Operating System: Main key Objectives of Operating System
9
Types of OS: Single user and single task, single user and multitasking, multiuser, multiprocessing, real time, embedded OS
10
Functions of OS: Process management, memory management, file management, device management, protection and security, user interface
11
Process Management: Process states, CPU scheduling, Process synchronization, Deadlock
12
Memory Management: Memory allocation, Virtual memory
13
File Management: Files, directory structure
14
Device Management: Device drivers, I/O scheduling, buffering, spooling
15
Protection and Security: Protection mechanism of programs, processes, users and to the resources
16
User Interface: CLI, GUI
17
Examples of Operating Systems: MS-DOS, Windows family of OS, Linux
18
Software Licensing: Licensing policy concept of software
19
Open-Source Software: Definition and benefits of using Open-Source software
20
Case study: Unix Vs Windows: Difference between Unix and Windows operating system in various aspects
S4:Data Representation[5]
1
Introduction: What are various kinds of data stored in computer (Numeric, Alphabetic, Alphanumeric, symbol). Different number systems (Decimal number system, Binary number system, Octal number system, and Hexadecimal number system
2
Number System: Representation of various number systems
3
Conversion from Decimal to Binary, Octal, Hexadecimal: Method used for Conversion from Decimal to Binary, Octal, Hexadecimal
4
Conversion of Binary, Octal, Hexadecimal to Decimal: Method used for Conversion of Binary, Octal, Hexadecimal to Decimal
5
Conversion of Binary to Octal, Hexadecimal: Method used for Conversion of Binary to Octal, Hexadecimal
6
Conversion of Octal, Hexadecimal to Binary: Method used for Conversion of Octal, Hexadecimal to Binary
7
Binary Arithmetic: Binary arithmetic operations—addition, subtraction of signed and unsigned numbers
S5:Computer Networks and Internet Services[10]
1
Introduction: Brief background about data communication and the computer networks and their importance
2
Importance of Networking: Resource sharing, information sharing, as a communication medium, back-up and support
3
Data Transmission Media: Twisted pair, coaxial cable, optical fiber, RF transmission, microwave transmission, satellite transmission
4
Data Transmission across Media: Transmission modes, Transmission speed, Fundamentals of transmission
5
Data Transmission and Data Networking: Switching - Circuit switching, message switching, packet switching
6
Network Types: Network types—LAN, MAN, WAN
7
Network Topology: Network topologies—Bus, ring, star
8
Communication Protocol: Communication protocol—The seven layers of OSI model
9
Network Devices: Network devices—NIC, repeater, bridge, hub, switch, router, gateway
10
Wireless Networking: Bluetooth technology, wireless LAN, wireless WAN
11
History of Internet: TCP/IP, Internet applications, WWW, browser
12
Internetworking Protocol: TCP/IP
13
The Internet Architecture: Client, local ISP, regional ISP, backbone
14
Managing the Internet: ISOC, IAB, IETF, IESG, IRTF, IANA, InterNIC, W3C
15
Internet Connections: Dial-up access, leased line, ISDN, DSL, cable modem
16
Internet Address; WWW, Domain Name System: WWW, Domain Name System
17
Internet Services: WWW, Electronic mail, File transfer protocol, Terminal network, News, Internet relay chat
18
Web2.0: What is Web? Explain web2.0 Ver
19
Internet of Things (IoT): What is Internet of Things (IoT)?
20
Wearable computing: What is Wearable computing?
21
Cloud computing: Cloud computing and it's importance
22
Smart City: Smart cities vs ICT and it's importance
23
Case Study: ISP in Nepal and their services
S6:Database System[5]
1
Introduction: What is Database, DBMS and RDBMS?
2
Database: File-oriented approach and database approach, Characteristics, Data models, schemas and instances, Conceptual data model, Representation data model, Low level or physical data model
3
Database System: Components of database system, Architecture of database system
4
Database Management System: Data independence, Data dictionary, Database Administrator (DBA), Database languages
5
Database System Architectures: Centralized DBMS architecture, client-server architecture, and distributed database
6
Database Applications: Different purposes like personal databases, workgroup databases, departmental databases and enterprise databases
7
Introduction to Data Warehousing: Concept of Data Warehouse
8
Data mining: Concept of Data mining
9
BigData: Concept of BigData
S7:Computer Security[4]
1
Introduction: Background about why we require Computer security with different types of security attacks, mechanism available and various services provided by a system
2
Security Threat and Security Attack: Difference between Security Threat and Security Attack. Types of security attack
3
Malicious Software: Virus, worm, trojan horse, JavaScript, java applet, ActiveX control Security Services: Confidentiality, integrity, authentication, non-repudiation
4
Security Mechanisms: Cryptography, Digital Signature, Firewall, Users Authentication, Intrusion Detection Systems
5
Security Awareness: Security awareness to enhance the security of the organization's resources by improving the awareness of the need to secure the system resources
6
Security Policy: Formulating a security policy
S8:Application and Impact of IT[3]
1
Application of IT: Describe what is IT and explain various areas where IT can use
2
Impact of IT on organization and individuals: Explain how technology and information systems are essential to maintaining, supporting, and enriching many aspects of the lives of individuals, operations of organizations. Explain both Positive and negative impact
3
Societal impacts of IT: Explain society and how technology and information systems influencing many aspects of societies
4
IT Strategic Planning: Explain the concept of organization Strategic Planning and IT strategic planning to meet organization strategic objectives and business goals
5
IT and Business Alignment: Explain how IT Operational or tactical (getting technology in place) align with the business objectives and to drive business results
References
1.
Computer Fundamentals, Anita Goel, Pearson Education India
2.
Introduction to Computers, Peter Norton, 7th Edition, McGraw Hill Education
3.
Fundamentals of Information Technology, Leon and Leon
4.
Computer Fundamental, Pradeep K. Sinha and Priti Sinha
5.
Introduction to Information Technology, E. Turban
6.
Information Technology for Management, E.Turban, C. Pollard, G. Wood, Wiley Publication
7.
Information Technology for Management, Henry C. Lucas, Jr.
Labrotary Work
Practical knowledge of Hardware components of computer
1.
Explain the different components housed within desktop cabinet, various types of Expansion slots and I/O ports in Desktop computer
Operating systems (DOS and Windows Operating System)
1.
Basic DOS Commands: CLS, TIME, DATE, SET PROMPT, HELP
2.
Use of Wildcard Characters
3.
Directory Manipulation: MD or MKDIR, CD or CHDIR, TREE, RD or RMDIR
4.
File Manipulation: DIR, Wildcard characters, COPY, XCOPY
5.
Other Commands: DEL or ERASE, UNDELETE, DOSKEY, RENAME or REN, TYPE, PRINT, COPY CON, Notepad, write, ATTRIB, PATH
6.
Use of Redirection, Filters, Pipes: Redirection input and output ( <, >, >> ), Filters ( more, sort ), Pipe ( | )
Windows Operation System
1.
Different windows versions; Windows Desktop Components (start Menu, Search Box, Task View, Pinned Apps, Task Tray, Notification Tray & Clock, Action Center, Desktop Icons and Desktop); Personalize Desktop Background; add icons in desktop; Max. Min, Close buttons of windows; Start Menu, Virtual Desktops; Navigate File and Folders of computer using Search box; File Explorer to manage files and folders; Recycle Bin; Windows Security (user Account Control, Windows Defender, Firewall); Using help for Interactive Learning; Using Windows Accessories( Character Map, Paint, Notepad, Snipping Tool, WordPad etc.); Disk Cleanup; Disk Defragmenter; Windows Apps management
MS Word
1.
Microsoft office Screen elements (File tab, Ribbon tabs, Groups and Dialog box launcher, Quick access toolbar, sizing button); Creating and Saving Document; Copy, Cut and Paste, Format painter, Undo & redo; Print Preview, Printing Document; Manipulating and formatting Text, Paragraph formatting; Boarder and shading; Tabs; Styles; Page formatting; Tables; Inserting pictures, Shapes, SmartArt; Finding and Replacing text; Multiple open documents (switching between open documents; Tiling or cascading documents; Comparing documents side by side); Mail Merge; Headers, Footers and Sections; Watermarks; Manipulating styles; Text wrapping and Pictures; Using columns; footnotes and endnotes; bookmarks and cross-reference, hyperlinks; Micros; tracking and comments; Table of contents and indexes; Table of figures.
MS Excel
1.
MS Excel Screen Elements(Row numbers, Column letters, cell reference, Name Box, Active cell, Formula bar, Work area, Sheet tabs); difference between Workbook, Worksheet, Spreadsheet; Opening new worksheet; previewing and printing a worksheet; cell and cell range; different types of cell content, cell formatting, formula and functions; Copy and paste cell content, using paste special; drag and drop cell; fill handle; Find and replace; sorting; Filter; Freeze panel; Formatting/conditional formatting; protecting file and worksheet with passwords; Working with charts; Data validation, consolidating; Using What-if Analysis; Pivot Tables; Hlookup; Vlookup.
Presentation Graphics
1.
Creating presentation slides; Adding animations; Inserting Charts, Graphics, Movies and Sound Clips.
Database Management Systems
1.
Creating tables, query, reports, and forms; Understanding different data types
Internet and its services
1.
Understanding Internet and its services like WWW and E-mail; Using search engine; Managing web browsers