University of Gujrat
Faculty of CS & IT
Title Introduction to Information and Communication Technologies
Code IT-109 and IT-110
Credit hours 3 (2+1)
Prerequisite None
Course This is an introductory course on Information and Communication Technologies. Topics include ICT terminologies,
Description hardware and software components, the internet and world wide web, and ICT based applications
Understand different terms associated with ICT
Identify various components of a computer system
Identify the various categories of software and their usage
Define the basic terms associated with communications and networking
Understand different terms associated with the Internet and World Wide Web.
Objectives Use various web tools including Web Browsers, E-mail clients and search utilities.
Use text processing, spreadsheets and presentation tools
Understand the enabling/pervasive features of ICT
a) course will be evaluated on the following basis’s:
Mid term 25%
Sessional work 25%
Final term 50%
Grading Policy b) To pass a course, student must obtain at least ‘D’ grade (50% marks)
c) The final term examination will cover the entire course.
Marks in Letter Grade Numeric Value of Grade Description
Percentage
85 and above A+ 4.00 Exceptional
80-84 A 3.70 Outstanding
Grading System 75-79 B+ 3.40 Excellent
70-74 B 3.00 Very Good
65-69 B- 2.50 Good
60-64 C+ 2.00 Average
55-59 C 1.50 Satisfactory
50-54 D 1.00 Pass
49 and below F 0.0 Fail
W Withdrawal
I Incomplete
Class
Attendance A minimum of 70% attendance is required for a student to be eligible to sit in the final examination
A-Introduction to Computers by Peter Norton. 7th Edition or the latest available edition
Text Book
B-Discovering Computers 2011: Complete (Shelly Cashman)
Reference Books
C-Microsoft Office 2007 by Greg Perry
Course
Coordinators
The following is a tentative weekly breakdown for this course. This is subject to future modifications. The references within
parenthesis is to reference section of the textbook (Introduction to Computers - by Peter Norton; 6th Edition)
THEORY/
Week Lecture # TOPICS Book Chapter LAB
Exploring Computers and Their Uses:
Course Introduction, ICT: Computer and Communication Technology, Analog and Digital Computers, Lesson 1 A THEORY
Computers for Individual Users (Desktop Computers, Workstations, Notebook Computers, Tablet PCs,
Handheld PCs, Smart Phones)
1 1&2
Exploring Computers and Their Uses:
Computers for Organizations ( Network Servers , Mainframe Computers , Minicomputers ,
Supercomputers), Computers in Society, The applications of ICT
Lesson 1 A THEORY
2 3&4 Looking Inside the Computer System:
Lesson 1 B THEORY
Parts of the Computer System: Hardware, Software, Data, User; The Information Processing Cycle;
Essential Computer Hardware: Processing Devices, Memory Devices, Input Devices.
Lesson 1 B THEORY
Looking Inside the Computer System:
Output Devices, Software Brings the Machine to Life: System Software, Application Software,
Computer Data: Computer Users, The User’s Role, “User less” Computers.
THEORY
The Internet and the World Wide Web: Lesson 8 A
What Is the Internet? The Internet’s History, The Internet’s Major Services, Understanding the World
Wide Web, Using Your Browser and the World Wide Web, Searching the Web
3 5&6
More Features of the Internet: News, Internet Relay Chat (IRC) and Web-Based Chat, Instant THEORY
Messaging, Online Services, Peer-to-Peer Services Lesson 8 B
Introduction to HTML, examples of HTML scripts
Processing Data:
Lesson 4 A
Transforming Data into Information THEORY
7&8 The Difference between Data and Information: How Computers Represent Data, Number Systems,
4 Bits and Bytes, Text Codes, Text Codes.
How Computers Process Data: The CPU, Machine Cycles, Memory; Factors Affecting Processing
9 Lesson 4 A
Speed; The Computer’s Internal Clock; The Bus. THEORY
5 Modern CPUs; Microcomputer Processors, Extending the Processor’s Power to Other Devices: Lesson 4 B
Different Computer ports and slots. THEORY
10
Measuring and Improving Drive Performance:
Average Access Time, Data Transfer Rate, Optimizing Disk Performance
Storage Devices: Lesson 5 A THEORY
CD-ROM, DVD-ROM, Flash Memory, Smart Cards
11
6 Measuring and Improving Drive Performance:
Average Access Time, Data Transfer Rate, Optimizing Disk Performance
12 MS Power Point: Introduction, slides creation, Insert tables, Fonts, Figures THEORY
13 MS Power Point: themes, Templates, Downloading templates, Auto Review, Adding audio and video THEORY
7 MS Power Point: Animations, Slides transition, Basic principles of good presentation (Exposure to THEORY
14
slide share online presentations)
BS program structure
2686_it-curriculum-09 / 2688_cs-curriculum-09 THEORY
15
8 http://www.hec.gov.pk/InsideHEC/Divisions/AECA/CurriculumRevision/Pages/RevisedCurricula.aspx
Computing Curricula The Joint Task Force for Computing Curricula
16 http://www.acm.org/education/curric_vols/CC2005-March06Final.pdf/view THEORY
Mid Term Exam
Operating System Basics: Lesson 6 A THEORY
17 Types of Operating Systems, User Interface, Enhancing an OS with Utility Software
9
Operating Systems: Lesson 6B THEORY
18
PC Operating Systems, Network Operating Systems, Embedded Operating Systems
Exposure to Hardware Systems, Internet Networking Devices Orientation THEORY
19
10
20 Working with Application Software: Productivity Software Lesson 10 A THEORY
Database Management:
Databases and Database Management Systems: Flat-File and Relational Database Structures, The Lesson 11 A. B THEORY
21 DBMS, Working with a Database
Survey of Database Systems, Databases at Work, Common Corporate Database Management
11 Systems, Introduction to Data-warehousing and Data-mining
Software Programming and Development: Lesson 12 B
What Is a Computer Program? Hardware/Software Interaction, Code ,Machine Code , Programming THEORY
22
Languages, Compilers and Interpreters , Planning a Computer Program , How Programs Solve
Problems,
MS Word THEORY
23 Cover the following tabs: Home, Insert Figures, Tables, Other shapes, Page Layout, Cover page
Task: Create Cover Page of Assignment
12 THEORY
MS Word
24 Footer, Header, Page Numbering, Referencing
Task: Create Auto Table of Content page, Table of Pictures, Referencing, Glossary
MS Word THEORY
25
Cover the following tabs : Mailing, Review, View, Design, Layout
13 THEORY
MS Word
26
Task: Complete report generation of final year project template
Networking Basics: Lesson 7 A, B
The Uses of a Network, Common Types of Networks, Hybrid Networks
THEORY
How Networks Are Structured, Network Topologies and Protocols: Network Media, Network
27 Hardware
Data Communications:
Data Communications with Standard Telephone
14 Lines and Modems, Broadband Connections, Wireless Networks
Understanding the Need for Security Measures:
Basic Security Concepts, Threats to Users, Online Spying Tools, Computer-Related Injuries, Threats to Lesson 13 A, B
THEORY
Hardware, Understanding the Need for Security Measures, Threats to Data, Cyber terrorism,
28
Taking Protective Measures
Avoiding Identity Theft, Protecting Your Privacy, Managing Cookies, Spyware, and Other “Bugs”,
Evading Spam, Keeping Your Data Secure, Safeguarding Your Hardware
MS Excel: THEORY
29 Cover the following tabs: Home, Insert Shapes and Tables, Page Layout
Tasks: Excel sheet Formatting, Creating Pivot Tables.
15 THEORY
MS Excel:
30 Practice of formulas and different types of charts, Data, Review and View
Task: Creating Budget/Activity Manager
MS Excel:
16 31 THEORY
Task: Use of Sort and Filter, Printing options, Mail Merge
32 Revision and Feedback about Course THEORY
Lab # Topics
Lab 1 Introduction to Lab policy and Ethics:
Lab rules, lab ethics, introduction to computer hardware
Typing: Typing practice using tutorials, practice on windows keyboard shortcuts.
Lab 2 E-Mail:
Using and Exploring E-Mail, Creating Email Account,
Use of Cc and Bcc, Adding Subject, Drafts, Inbox, Sent, Outboxes, Categories, move to Function, Creating
Labels, Adding Signatures.
Lab 3 Using Internet Explorer.
Add-ins
Searching in web sites
How to use Google Drive
Lab 4 Google Applications
Lab 5 Using files, zip Unzip, Folder options,
Lab 6 Introduction to social media and Windows Installation
Lab 7 Basics of antivirus software and computer maintenance
Lab 8 MS Power Point: Introduction, slides creation, Insert tables, Fonts, Figures
Lab 9 MS Power Point: Introduction, slides creation, Insert tables, Fonts, Figures
Lab 10 MS Word
Cover the following tabs: Home, Insert Figures, Tables, Other shapes, Page Layout, Cover page
Task: Create Cover Page of Assignment
Lab 11 MS Word
Task: Complete report generation of final year project template
Lab 12 MS Excel:
Cover the following tabs: Home, Insert Shapes and Tables, Page Layout
Tasks: Excel sheet Formatting, Creating Pivot Tables.
Lab 13 MS Excel:
Practice of formulas and different types of charts, Data, Review and View
Task: Creating Budget/Activity Manager
Lab 14 Introduction to database Management System, MS access or SQL
Lab 15 Presentations
Lab 16 Revision
