10:51 AM
Course Title: Introduction to Information Technology
Course No. : ICT Ed
411 Nature of Course: Theoretical + Practical
Level: B.Ed.
Credit Hours: 3 (2T+1P)
Semester: First Teaching Hours: 80 (32T+48P)
- Course Description
This course aims to provide the students with the
foundation knowledge of contemporary Information Technology areas, software,
applications and job skills required to enter the IT market. It covers a broad
range of introduction of Information Technology concepts, operating system, and
office automation tools such as word processor, spreadsheet, database and presentation.
It also covers the telecommunication and computer network, internet, email, web
and ethical issues in information technology.
- Course Objectives
- To familiarize the
students with computer and its applications in the relevant fields
- To enhance the skill
of students in Information Communication and Technology (ICT) uses and operating system
- To make the students
competent in office automation system application.
- To enable the
students to use Internet and www
- To make the students
knowledgeable about telecommunication industries.
- To make the students able
to use computer system in a safe and secure way
- Specific Objectives
and Contents
Specific Objectives
|
Contents
|
· State scope and importance of IT
· Differentiate a system from computer
system in terms of characteristics, capabilities and limitations
· Identify the types of computers and memory devices used in different
generation
· Illustrate configurations and
specifications of PCs
· State computer system architecture
· Identify basic components of a computer
system
· Distinguish between primary and secondary
memories along the dimension of speed, cost and capacity.
|
Unit 1 : Fundamentals of Computer (12)
1.1
Scope of IT and its importance
1.2
Computer system concepts, characteristics, capabilities
and limitations
1.3
Generations of computers
1.4
Types of computers
1.5
Personal computer
(PCs)
1.5.1
Configurations of
PCs
1.5.2
PCs specifications.
1.6
Computer system architecture
1.7
Basic components of a computer system
1.7.1 Input devices
1.7.2 Output devices
1.7.3 CPU and its components
1.7.4
Memory: RAM, ROM, EPROM, PROM
1.7.5
Secondary storage device
Lab Work
·
Demonstration of PC components
·
Prepared specification of PC system
|
·
Explain
concept of software along with its need
·
Differentiate
main categories of computer software.
·
Explore
the importance of programming languages in software development.
·
Analyze
the trends of new software and mobile computing.
·
List
all the major operating system
·
Illustrate
file allocation table
·
Describe
window operating system
·
Perform
the window based operating system
|
Unit 2 : Computer Software and Classification (8)
2.1
Software and its need
2.2
Types of software
2.3.1
System Software
·
System, Utility Program
·
Programming languages
·
Assemblers
·
Compilers
·
Interpreter
2.3.2
Application Software
2.3
Programming languages machine, assembly, high Level, 4GL
2.4
Trends in software
2.5
Introduction to Disk Operating System: internal and external
commands
2.6
File Allocation Table (FAT & FAT 32)
2.7
Introduction to Window Operating System
2.7.1 GUI environments
2.7.2 Working with Files & Folders
2.7.3 Working with windows application programs
2.7.4 Customizing the taskbar and desktops
2.7.5 Customizing windows
2.7.6 Use of accessories.
2.7.7 Working with control panel
2.8 Mobile Computing
Lab work
· Performing 2.7 activities
using window based operating system
· Demonstration of the mobile
operating system
|
·
Execute
word processor by identifying basic word processing tools
·
Identify
special features commonly found in modern word processor such as editing,
formatting, mail merging etc.
·
Execute
some financial tools such as spreadsheet.
·
Differentiate
the terms worksheet and spreadsheet.
·
List
the types of data analysis tools commonly found in spreadsheet and describe
their uses.
·
Execute
presentation program.
·
Create
and format slides.
·
Design
and animate the slide
|
Unit 3: Office Automation Software (20)
3.1
Word processor
3.1.1
Characteristics
of word processor
3.1.2
Creating
and formatting documents
3.1.3
Managing
page numbers, header and footer
3.1.4
Proofing
a document
3.1.5
Inserting
citation in APA and table of contents
3.1.6
Inserting
objects from other applications
3.1.7
Mail
merge
3.1.8
Printing
documents
3.2
Spreadsheet
Application
3.2.1
Characteristics
of Spreadsheet
3.2.2
Creating,
formatting and printing worksheets.
3.2.3
Financial
and statistical Functions in Excel
3.2.4
Creating,
formatting and printing graphs
3.3
Presentation Application
3.3.1
Characteristics
of presentation
3.3.2
Creating
and save presentations
3.3.3
Applying
template
3.3.4
Design
slides.
3.3.5
Animation
on slide
3.3.6
Inserting
hyperlink, slide number, date and time
3.3.7
Slide
Transactions
3.3.8
Master
Slides
3.3.9
Slides
printing
Lab
Work
|
·
Clarify
number system in computing.
·
Give
examples to illustrate number system and conversion
·
Calculate
in binary
|
4.1
Introduction of Number
System
4.2
Decimal, Binary, Octal,
Hexadecimal Number System and Conversion
4.2 Calculation
in Binary – addition, subtraction
|
·
Describe
computer network and its types
·
Identify
topologies commonly used in networks.
·
Describe
communication channels and types of network connections
·
Illustrate
different network components.
·
Explain
the importance of telecommunication systems in Nepal
·
State
internet services and convergence of technologies.
|
UNIT 5: Telecommunication and Computer Network (8)
5.1 Introduction of computer network
5.2 Types of network - LAN, WAN,
MAN
5.3 Topologies of LAN - Ring,
Bus, Star, Mesh and Tree topologies
5.4 Communication Channels -
Twisted, Coaxial, and Fiber Optic
5.5 Components of LAN - Media,
NIC, Bridges, HUB, Routers, Repeater and Gateways.
5.6 Introduction to telecommunication.
5.7 Telecommunication systems in
Nepal.
5.8 Internet services and convergence
of technologies.
|
·
Explain
database and its types
·
Illustrate
database management system and its applications
·
List out the DBMS software
·
Create a data base with table, relationships, queries, form, report
and macro.
|
UNIT 6 : Database Management System
(14)
6.1 Introduction to database
6.2 Types of database
6.3 Database Management System (DBMS)
6.4 Application of DBMS
Lab Work
·
Creating database using
DBMS software like MS Access
·
Creating tables with its
properties
·
Creating relation between
two or more tables
·
Creating form
·
Creating queries
·
Creating reports
·
Creating macro
|
·
Explain
evolution of internet and world wide web
·
Distinguish
between internet, intranet and extranet
·
Demonstrate
the use of web technology
·
Describe
social media and e-mail services
·
Explain
cloud, green and virtual computing
·
State
different e-Services
·
Surf
web sites, use search engine, create e-mail and use social media
|
Unit 7 : Internet Web and Emerging Technology (10)
7.1
Internet and Its Evolution
7.2
World Wide Web
7.3
Internet, Intranets and Extranet
7.4
Search Engine and Web Browser
7.5
Social Media
7.6
e-Mail Services
7.7
Web 2.0
7.8
Cloud Computing
7.9
Green Computing
7.10 Virtual Computing
7.11 e-Services
7.11.1
e-Commerce
7.11.2
e-learning
7.11.3
e-Health
7.11.4
e-Government
7.11.5
e-Library
Lab work
|
·
Define
computer virus and threats
·
Explain
the ways of protecting computer virus
·
Identify
the security and ethical issues in IT.
·
State
computer crime
·
Define
privacy and intellectual property
·
Install
antivirus and scan computer system
|
UNIT 8 : Security and Ethical Challenges (4)
8.1 Computer Virus and threats
8.2 Protection from computer virus
8.3 Security and Ethical issues in Information Technology
8.4 Computer crime
8.5 Piracy issues and intellectual property
Lab Work
·
Installing antivirus and scan
computer system
|
Note: The figures
in the parentheses indicate the approximate teaching hours
for the respective units.
- Instructional Techniques
The instructional techniques for this course are
divided into two groups. First group
consists of general instructional techniques applicable to most of the units.
The second group consists of specific instructional techniques applicable to
particular units.
4.1 General
Instructional Techniques
Reading materials will be provided to students in each
unit. Lecture preferably with the use of multi-media projector, demonstration,
practical classes, discussion, and brain storming are used in all units.
4.2
Specific Instructional Techniques
Demonstration
is an essential instructional technique for all units in this course during teaching-learning process. Specifically, demonstration with
practical works will be specific
instructional technique in this course. The details of suggested instructional techniques are presented below:
Units
|
Activities
|
Unit 2:
For Window Operating
System
|
· Demonstration
by the teacher on different types of operation system (Working with files & folders, working
with windows application programs, customizing the taskbar and desktops,
customizing windows, use of accessories and working with control panel)
·
Individual lab work of those operation system by
each student
·
Monitoring of students' work by reaching each
student and providing feedback for improvement
·
Presentation by students followed by peers'
comments and teacher's feedback
|
Unit 3: For Word
Processing
|
· Demonstration by
the teacher on word processing
-
Formatting
text
-
editing
document
-
tab
setting,
-
paragraph
alignment
-
inserting
table and objects
-
managing
table of contents, page setup, proof reading the document
·
Lab work in pairs in a task assigned by the
teacher using word processing
·
Monitoring of students' work by reaching each pair
and providing feedback for improvement
·
Presentation by students followed by peers'
comments and teacher's feedback
|
Unit 3: For Spread Sheet
|
Spread
Sheet
· Demonstration
by the teacher on spread sheet
-
Naming
cell and cell range, use of formula and different types of functions
-
Inserting
chart and objects
-
Renaming
worksheet and workbook
-
Handling
cell formatting such as alignment, numbers, currency, font colour, merger and
centre
-
Applying
autofill features to customise tasks
-
Design
a bill of supermarket, mark sheet of school and college,
mark ledger book, line graph, column
chart, pie chart, 3D view chart using title, Axis, Gridlines, Legend, Data
level and data table
-
Develop
different types of tables
-
Use
different types of functions, Formulas and subtotals.
-
Use
colours, Font, Currency, Subtotal, Sort, Auto filter, etc.
·
Lab work in pairs in different tasks assigned by
the teacher
·
Monitoring of students' work by reaching each pair
and providing feedback for improvement
·
Presentation by students followed by peers'
comments and teacher's feedback
|
Unit 3: For Presentation Package
|
· Demonstration
by the teacher on presentation package
-
Create
different types of presentation slides
-
Apply
a design temples
-
Use
formatting, Alignments, Bullet, Insert picture, Organization charts, Word
Art, Diagram Gallery display box, 3-D style, Rotating objected. Create/types
of charts and Data sheet. Chart with title, Axis, Gridlines, Legend, Data
labels and data table
-
Insert
the different types of custom animation and movie.
-
Create
different type of slides to use in the teaching and learning process
·
Individual lab work of those operation system by
each student
·
Monitoring of students' work by reaching each
student and providing feedback for improvement
·
Presentation by students followed by peers'
comments and teacher's feedback
|
Unit 6: For Data Management System
|
· Demonstration by the teacher about
creating and maintaining the database using MS-Access.
· Pair works to design a database using DDL
and DML commands for creating Students and staffs profile, Telephone
Directory Etc.
· Monitoring of students' work by reaching
each pair and assist them to complete the assignment
· Presentation by
students followed by peers' comments and teacher's feedback
|
Unit 7: For E-Mail
|
· Demonstration by the teacher on
-
creating
a mailing list for communicating students or teachers
-
using
e-mail to search to download and to send; to receive, to attach file and to
send copies of e-mail documents.
· Individual lab
work of those operation system by each student
·
Monitoring of students' work by reaching each
student and providing feedback for improvement
·
Presentation by students followed by peers'
comments and teacher's feedback
|
Unit 7: For Internet
|
· Demonstration by the teacher on searching
the web site, downloading the file, uploading the files, and creating a block
· Individual lab
work of those operation system by each student
·
Monitoring of students' work by reaching each
student and providing feedback for improvement
·
Presentation by students followed by peers'
comments and teacher's feedback
|
5.
Evaluation
Evaluation of students' performance is
divided into parts: Internal assessment and internal and external practical
examination and theoretical examinations. The distribution of points is given
below:
Internal
Assessment
|
External
Practical Exam/Viva
|
Semester
Examination
(Theoretical
exam)
|
Total
Points
|
40
Points
|
20
Points
|
40
Points
|
100
Points
|
Note:
Students must pass separately in internal assessment, external practical exam
and semester examination.
5.1 Internal Assessment (40
Points)
Internal assessment will be conducted by subject teacher based on
following criteria:
1)
Class Attendance 5
points
2)
Learning activities and class performance 5 points
3)
First assignment ( written assignment) 10
points
4)
Second assignment (Case Study/project work with
presentation ) 10 points
5)
Terminal Examination
10 Points
Total 40 points
|
5.2 Semester Examination (40 Points)
Examination
Division, Dean office will conduct final examination at the end of semester.
Objective question (Multiple
choice questions 10 x 1 point) 10 Points
Short answer questions (6 questions x 5 marks) 30 Points
|
Total
40 points
|
5.3 Practical
Exam/Viva (20 Points)
Examination
Division, Dean Office will conduct final practical examination at the end of
semester. Practical record book, practical written test, demonstration of
practical activities and viva are assessment indicators.
6. Recommended
Books and References materials
(including relevant published articles in national and international journals)
Recommended Books:
Alexis Leon & Mathews Leon (2009). Fundamentals
of Information Technology, 2/e. New Delhi. Vikas Publishing House (unit 1-5)
Turban, R. R. (2014). Introduction
To Infromation Technology. John Wiley and Sons (Asia) Pvt. Ltd. (For unit 6
to unit 8)
References materials:
Sinha, P. K., & Sinha, P. (2007). Computer
fundamentals: concepts, systems & applications. New Delhi: BPB
Publications.
Norton, P. (2006). Peter Norton's computing
fundamentals. Boston, Mass: McGraw-Hill Technology Education.
Morley, D. &. (2013). Understanding
Computers Today and Tomorrow. Cangage Learning.
V. Rajaraman, Neeharika Adabala (2014).Fundamentals of
Computers 6th Edition. New Delhi: PHI
Cox, J., Lambert, J., & Frye, C. (2011). Microsoft
Office Professional 2010 step by step. Redmond, Wash: Microsoft.
Melton, B. (Ed.). (2013). Microsoft Office
Professional 2013. Sebastopol, Calif: O’Reilly Media.
Melton, Beth, Dodge, Mark,(2013),Microsoft Office Home and Student 2013
Step By Step, PHI India.
Patrice-Anne Rutledge(2014),Office 2013 All-In-One Absolute Beginner's
Guide ISBN:9789332539372 , Pearson India