IT Course in Nepal -BICT Blog || Complete Guide for IT Students


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)
                                     
  1. 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.

  1.  Course Objectives 
Following are the general objective of this course:
  • 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


  1. 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
  • Performing the word processing activities using office automation software like MS Word
  • Performing the spread sheet activities using Office automation software like MS Excel
  • Performing the presentation activities using Office automation software like MS Power Point
·         Clarify number system in computing.
·         Give examples to illustrate number system and conversion
·         Calculate in binary
Unit 4: Number System and Their Conversion             (4)                                 
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
  • Surfing web sites
  • Using Search engine
  • Creating Email
  • Using social media
·         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.

  1.  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




Google Maps

Hamro Patro

Popular Posts