Fundamentals of ICT (Common) ‘I’ Scheme

Program Name : All Branches of Diploma in Engineering and Technology.

Program Code : CE/CR/CS/CH/PS/CM/CO/IF/CW/DE/EJ/EN/EQ/ET/EX/IE/MU/EE/EP/EU/IS/IC/AE
/FG/ME/PG/PT/DC/TX/TC/BC/IH
Semester : First
Couse Title : Fundamentals of ICT
Couse Code : 22001

1. RATIONALE
In any typical business setup in order to carry out routine tasks related to create business
documents, perform data analysis and its graphical representations and making electronic
slide show presentations, the student need to learn various software as office automation tools
like word processing applications, spreadsheets and presentation tools. They also need to use
these tools for making their project reports and presentations. The objective of this course is
to develop the basic competency in students for using these office automation tools to
accomplish the job.

2. COMPETENCY
The aim of this course is to help the student to attain the following industry identified
competency through various teaching learning experiences:
 Use computers for internet services, electronic documentation, data analysis and
slide presentation.

3. COURSE OUTCOMES (COs)

The theory, practical experiences and relevant soft skills associated with this course are to be
taught and implemented, so that the student demonstrates the following industry oriented
COs associated with the above mentioned competency:
a. Use computer system and its peripherals.
b. Prepare business document using word processing tool.
c. Interpret data and represent it graphically using spreadsheet.
d. Prepare professional presentations.
e. Use different types of web browsers.

4. TEACHING AND EXAMINATION SCHEME

Teaching
Examination Scheme
Scheme
Credit Theory Practical
(L+T+P)
L T P Paper ESE PA Total ESE PA Total
Hrs. Max Min Max Min Max Min Max Min Max Min Max Min
2 -- 2 4 -- -- -- -- -- -- -- 25@$ 10 25~ 10 50 20

(~1): For the courses having ONLY practical examination, the PA has two components under
practical marks i.e. the assessment of practicals (seen in section 6) has a weightage of 60%
(i.e.15 marks) and micro-project assessment (seen in section 12) has a weightage of 40%
(i.e.10 marks). This is designed to facilitate attainment of COs holistically, as there is no
theory ESE.
Legends: L-Lecture; T – Tutorial/Teacher Guided Theory Practice; P - Practical; C – Credit,
ESE - End Semester Examination; PA - Progressive Assessment; # No theory exam.

12.08.2022 Page 1 of 9 1I
Fundamentals of ICT (Common) ‘I’ Scheme

5. COURSE MAP (with sample COs, PrOs, UOs, ADOs and topics)
This course map illustrates an overview of the flow and linkages of the topics at various levels
of outcomes (details in subsequent sections) to be attained by the student by the end of the
course, in all domains of learning in terms of the industry/employer identified competency
depicted at the centre of this map.
ADO (a) - Follow
safe practices

Topic 3.2 Editing ADO (b) - Practice energy

worksheet conservation

Topic 5.1 World

Wide Web UO 3b - Explain the given
formatting feature of a
worksheet

PrO 20- Configure

browser settings and PrO 9- Create, open and
UO 5a– Explain use browsers edit worksheet
use of the given
setting option in
browsers
CO (e) - Use different CO(c) -Interpret data and
types of web browsers represent it graphically
using spreadsheet

CO (d) - Prepare
professional Competency
presentation Use computers for internet
services, electronic CO (a) - Use
documentation, data analysis computer system
and slide presentation and its Peripherals

PrO 14 - Create
slide presentation CO (b) - Prepare
business document using
word processing tool UO 1a Explain
motor the given block
PrO 1- Identify various diagram of
Input/output devices, computer system.
UO 4b - Write the PrO 3- Create, edit
connections and peripherals
steps to insert and save document.
of computer system
multiple media in the
given presentation.

UO 2b – Explain the Topic 1.1 Basics

given feature of of computer
document editing system
Topic 4.2 Inserting
media elements
Topic 2.2 Editing a
document

Legends

UO in Cognitive ADO - Affective

CO - Course Outcome PrO through Practicals Domain Domain Outcome Topic

Figure 1 - Course Map

6. SUGGESTED PRACTICALS/ EXERCISES

The practicals in this section are PrOs (i.e. sub-components of the COs) to be developed and
assessed in the student for the attainment of the competency.

Approx.
S. Unit
Practical Outcomes (PrOs) Hrs.
No. No.
required
Computer system and Operating system:
1 Identify various Input/output devices, connections and peripherals of I 1*
computer system

12.08.2022 Page 2 of 9 1I
Fundamentals of ICT (Common) ‘I’ Scheme

Approx.
S. Unit
Practical Outcomes (PrOs) Hrs.
No. No.
required
2 Manage files and folders : Create, copy, rename, delete, move files I 1
and folder
Word Processing
3 Create, edit and save document : apply formatting features on the II 2*
text - line, paragraph
4 Use bullets, numbering, page formatting II 2
5 Insert and edit images and shapes, sizing, cropping, colour, II 2
background, group/ungroup
6 Insert and apply various table formatting features on it. II 2
7 Apply page layout features II 2*
i. Themes, page background, paragraph, page setup
ii. Create multicolumn page
iii. Use different options to print the documents
8 Use mail merge with options. II 1
Spreadsheets
9 Create, open and edit worksheet III 2*
i. Enter data and format it, adjust row height and column width
ii. Insert and delete cells, rows and columns
iii. Apply wrap text, orientation feature on cell.
10 Insert formulas, “IF” conditions, functions and named ranges in III 2
worksheet.
11 Apply data Sort, Filter and Data Validation features. III 2*
12 Create charts to apply various chart options. III 2
13 Apply Page setup and print options for worksheet to print the III 1
worksheet.
Presentation Tool
14 Create slide presentation IV 2*
i. Apply design themes to the given presentation
ii. Add new slides and insert pictures/images, shapes
15 i. Add tables and charts in the slides. IV 2
ii. Run slide presentation in different modes
iii. Print slide presentation as handouts
16 Apply animation effects to the text and slides. IV 1
17 Add audio and video files in the given presentation IV 1
Internet Basics
18 Configure Internet connection V 1
19 Use internet for different web services. V 2*
20 Configure browser settings and use browsers. V 1*
Total 32
‘*’: compulsory practicals to be performed.
Note
i. A suggestive list of practical UOs is given in the above table, more such PrOs can be
added to attain the COs and competency.
ii. Hence, the ‘Process’ and ‘Product’ related skills associated with each PrOs of the
laboratory/workshop/field work are to be assessed according to a suggested sample given
below:

12.08.2022 Page 3 of 9 1I
Fundamentals of ICT (Common) ‘I’ Scheme

S. Performance Indicators Weightage in %

No.
a. Use of Appropriate tool to solve the problem (Process) 40
b. Quality of output achieved (Product) 30
c. Complete the practical in stipulated time 10
d. Answer to sample questions 10
e. Submit report in time 10
Total 100

The above PrOs also comprise of the following social skills/attitudes which are Affective
Domain Outcomes (ADOs) that are best developed through the laboratory/field based
experiences:
a. Follow safety practices.
b. Practice good housekeeping.
c. Demonstrate working as a leader/a team member.
d. Maintain tools and equipment.
e. Follow ethical practices.

The ADOs are not specific to any one PrO, but are embedded in many PrOs. Hence, the
acquisition of the ADOs takes place gradually in the student when s/he undertakes a series of
practical experiences over a period of time. Moreover, the level of achievement of the ADOs
according to Krathwohl’s ‘Affective Domain Taxonomy’ should gradually increase as planned
below:
 ‘Valuing Level’ in 1st year
 ‘Organising Level’ in 2nd year
 ‘Characterising Level’ in 3rd year.

7. MAJOR EQUIPMENT/ INSTRUMENTS REQUIRED

The major equipment with broad specification mentioned here will usher in uniformity in
conduct of PrOs, as well as aid to procure equipment by authorities concerned.

S. Exp.
Equipment Name with Broad Specifications
No. S.No.
1 Computer system with all necessary components like; motherboard, random 1
access memory (RAM), read-only memory (ROM), Graphics cards, sound
cards, internal hard disk drives, DVD drive, network interface card.
2 Double side printing laser printer. 1,6,12,13
3 Hubs, Switches, Modems. 1, 16,17
4 Any operating system. 2 to18
5 Any Office Software. 2 to 15
6 Any browser. 16,17,18
Note: There are no specifications fixed for the above listed systems, devices and instruments.
Depending on the availability in the institute they can be utilized for the purpose.

8. UNDERPINNING THEORY COMPONENTS

The following topics/subtopics are to be taught and assessed in order to develop UOs for
achieving the COs to attain the identified competency.

12.08.2022 Page 4 of 9 1I
Fundamentals of ICT (Common) ‘I’ Scheme

Unit Unit Outcomes (UOs) Topics and Sub-topics

(in cognitive domain)
Unit – I 1a. Explain the given block 1.1 Basics of Computer System: Overview of
Introducti diagram of computer Hardware and Software: block diagram of
on to system. Computer System, Input/Output unit CPU,
Computer 1b. Classify the given type Control Unit, Arithmetic logic Unit (ALU),
System of software Memory Unit
1c. Explain characteristics of 1.2 Internal components: processor,
the specified type of motherboards, random access memory
network. (RAM), read-only memory (ROM), video
1d. Describe procedure to cards, sound cards and internal hard disk
manage a file /folder in drives)
the given way. 1.3 External Devices: Types of input/output
1e. Describe application of devices, types of monitors, keyboards,
the specified type of mouse, printers: Dot matrix, Inkjet and
network connecting LaserJet, plotter and scanner, external
device storage devices CD/DVD, Hard disk and pen
drive
1.4 Application Software: word processing,
spreadsheet, database management systems,
control software, measuring software,
photo-editing software, video-editing
software, graphics manipulation software
System Software compilers, linkers, device
drivers, operating systems and utilities
1.5 Network environments: network interface
cards, hubs, switches, routers and modems,
concept of LAN, MAN, WAN, WLAN, Wi-
Fi and Bluetooth
1.6 Working with Operating Systems:
Create and manage file and folders, Copy a
file, renaming and deleting of files and
folders, Searching files and folders,
application installation, creating shortcut of
application on the desktop.

Unit– II 2a. Write steps to create the 2.1. Word Processing: Overview of Word
Word given text document. processor Basics of Font type, size, colour,
Processing 2b. Explain the specified Effects like Bold, italic, underline, Subscript
feature for document and superscript, Case changing options,
editing. Previewing a document, Saving a document,
2c. Explain the given page Closing a document and exiting application.
setup features of a 2.2. Editing a Document: Navigate through a
document. document, Scroll through text, Insert and
2d. Write the specified table delete text, Select text, Undo and redo
formatting feature. commands, Use drag and drop to move text,
Copy, cut and paste, Use the clipboard, Clear
formatting, Format and align text, Formatting
Paragraphs, Line and paragraph spacing,
using FIND and REPLACE, Setting line

12.08.2022 Page 5 of 9 1I
Fundamentals of ICT (Common) ‘I’ Scheme

Unit Unit Outcomes (UOs) Topics and Sub-topics

(in cognitive domain)
spacing, add bullet and numbers in lists, add
borders and shading, document views, Page
settings and margins, Spelling and
Grammatical checks
2.3. Changing the Layout of a Document:
Adjust page margins, Change page
orientation, Create headers and footers, Set
and change indentations, Insert and clear
tabs.
2.4. Inserting Elements to Word Documents:
Insert and delete a page break, Insert page
numbers, Insert the date and time, Insert
special characters (symbols), Insert a picture
from a file, Resize and reposition a picture
2.5. Working with Tables: Insert a table,
Convert a table to text, Navigate and select
text in a table, Resize table cells, Align text
in a table, Format a table, Insert and delete
columns and rows, Borders and shading,
Repeat table headings on subsequent pages,
Merge and split cells.
2.6. Working with Columned Layouts and
Section Breaks: a Columns, Section breaks,
Creating columns, Newsletter style columns,
Changing part of a document layout or
formatting, Remove section break, Add
columns to remainder of a document,
Column widths, Adjust column spacing,
Insert manual column breaks.

Unit– III 3a. Write steps to create the 3.1. Working with Spreadsheets: Overview of
Spreadshe given spreadsheet. workbook and worksheet, Create Worksheet
ets 3b. Explain the specified Entering sample data, Save, Copy
formatting feature of a Worksheet, Delete Worksheet, Close and
worksheet. open Workbook.
3c. Write steps to insert 3.2. Editing Worksheet: Insert and select data,
formula and functions in adjust row height and column width, delete,
the given worksheet. move data, insert rows and columns, Copy
3d. Write steps to create and Paste, Find and Replace, Spell Check,
charts for the specified Zoom In-Out, Special Symbols, Insert
data set. Comments, Add Text Box, Undo Changes, -
3e. Explain steps to perform Freeze Panes, hiding/unhiding rows and
advance operation on the columns.
given data set. 3.3. Formatting Cells and sheet: Setting Cell
Type, Setting Fonts, Text options, Rotate
Cells, Setting Colors, Text Alignments,
Merge and Wrap, apply Borders and Shades,
Sheet Options, Adjust Margins, Page

12.08.2022 Page 6 of 9 1I
Fundamentals of ICT (Common) ‘I’ Scheme

Unit Unit Outcomes (UOs) Topics and Sub-topics

(in cognitive domain)
Orientation, Header and Footer, Insert Page
Breaks, Set Background.
3.4. Working with Formula: Creating Formulas,
Copying Formulas, Common spreadsheet
Functions such as sum, average, min, max,
date, In, And, or, mathematical functions
such as sqrt, power, applying conditions
using IF.
3.5. Working with Charts: Introduction to
charts, overview of different types of charts,
Bar, Pie, Line charts, creating and editing
charts. Using chart options: chart title, axis
title, legend, data labels, Axes, grid lines,
moving chart in a separate sheet.
3.6. Advanced Operations: Conditional
Formatting, Data Filtering, Data Sorting,
Using Ranges, Data Validation, Adding
Graphics, Printing Worksheets, print area,
margins, header, footer and other page setup
options.

Unit– IV 4a. Write the steps to create 4.1 Creating a Presentation: Outline of an
Presentatio the specified slide effective presentation, Identify the elements
n Tool presentation. of the User Interface, Starting a New
4b. Write the steps to insert Presentation Files, Creating a Basic
multiple media in the Presentation, Working with textboxes, Apply
given presentation. Character Formats, Format Paragraphs,
4c. Write steps to apply View a Presentation, Saving work, creating
table features in the new Slides, Changing a slide Layout,
given presentation Applying a theme, Changing Colours, fonts
4d. Write steps to manage and effects, apply custom Colour and font
charts in the given theme, changing the background, Arrange
presentation Slide sequence,
4.2 Inserting Media elements: Adding and
Modifying Graphical Objects to a
Presentation - Insert Images into a
Presentation, insert audio clips,
video/animation, Add Shapes, Add Visual
Styles to Text in a Presentation, Edit
Graphical Objects on a Slide, Format
Graphical Objects on a Slide, Group
Graphical Objects on a Slide, Apply an
Animation Effect to a Graphical Object, Add
Transitions, Add Speaker Notes, Print a
Presentation.
4.3 Working with Tables: Insert a Table in a
Slide, Format Tables, and Import Tables
from Other Office Applications.

12.08.2022 Page 7 of 9 1I
Fundamentals of ICT (Common) ‘I’ Scheme

Unit Unit Outcomes (UOs) Topics and Sub-topics

(in cognitive domain)
4.4 Working with Charts: Insert Charts in a
Slide, Modify a Chart, Import Charts from
Other Office Applications.

Unit– V 5a. Explain use of the given 5.1 World Wide Web: Introduction, Internet,
Basics of setting option in Intranet, Cloud, Web Sites, web pages, URL,
Internet browsers. web servers, basic settings of web browsers-
5b. Explain features of the history, extension, default page, default
specified web service. search engine, creating and retrieving
5c. Describe the given bookmarks, use search engines effectively
characteristic of cloud. for searching the content.
5d. Explain the specified 5.2 Web Services: e-Mail, Chat, Video
option used for effective Conferencing, e-learning, e-shopping, e-
searching in search Reservation, e-Groups, Social Networking.
engine.
Note: To attain the COs and competency, above listed UOs need to be undertaken to achieve
the ‘Application Level’ and above of Bloom’s ‘Cognitive Domain Taxonomy’

9. SUGGESTED SPECIFICATION TABLE FOR QUESTION PAPER DESIGN

- Not Applicable -

10. SUGGESTED STUDENT ACTIVITIES

Other than the classroom and laboratory learning, following are the suggested student-related
co-curricular activities which can be undertaken to accelerate the attainment of the various
outcomes in this course:
a. Prepare journal of practicals.
b. Prepare a sample document with all word processing features.(Course teacher shall
allot appropriate document type to each students)
c. Undertake micro projects

11. SUGGESTED SPECIAL INSTRUCTIONAL STRATEGIES (if any)

These are sample strategies, which the teacher can use to accelerate the attainment of the
various outcomes in this course:
a. Massive open online courses (MOOCs) may be used to teach various topics/sub
topics.
b. ‘L’ in item No. 4 does not mean only the traditional lecture method, but different types
of teaching methods and media that are to be employed to develop the outcomes.
c. About 15-20% of the topics/sub-topics which is relatively simpler or descriptive in
nature is to be given to the students for self-directed learning and assess the
development of the COs through classroom presentations (see implementation
guideline for details).
d. With respect to item No.10, teachers need to ensure to create opportunities and
provisions for co-curricular activities.
e. Guide student(s) in undertaking micro-projects.
f. Guide student(s) in undertaking various activities in the lab/workshop.
g. Demonstrate students thoroughly before they start doing the practice.
h. Show video/animation films for handling/functioning of instruments.
i. Observe continuously and monitor the performance of students in Lab.

12.08.2022 Page 8 of 9 1I
Fundamentals of ICT (Common) ‘I’ Scheme

12. SUGGESTED MICRO-PROJECTS

Only one micro-project is planned to be undertaken by a student assigned to him/her in the
beginning of the semester. S/he ought to submit it by the end of the semester to develop the
industry oriented COs. Each micro-project should encompass two or more COs which are in
fact, an integration of PrOs, UOs and ADOs. The micro-project could be industry application
based, internet-based, workshop-based, laboratory-based or field-based. Each student will
have to maintain dated work diary consisting of individual contribution in the project work
and give a seminar presentation of it before submission. The total duration of the micro-
project should not be less than 16 (sixteen) student engagement hours during the course.

In the first four semesters, the micro-project could be group-based. However, in higher
semesters, it should be individually undertaken to build up the skill and confidence in every
student to become problem solver so that s/he contributes to the projects of the industry. A
suggestive list is given here. Similar micro-projects could be added by the concerned faculty:
a. Word documents: Prepare Time Table, Application, Notes, Reports .(Subject teacher
shall assign a document to be prepared by the each students)
b. Slide Presentations: Prepare slides with all Presentation features such as: classroom
presentation, presentation about department, presentation of report. (Subject teacher
shall assign a presentation to be prepared by the each student).
c. Spreadsheets: Prepare Pay bills, tax statement, student’s assessment record using
spreadsheet. (Teacher shall assign a spreadsheet to be prepared by each student).

13. SUGGESTED LEARNING RESOURCES

S.
Title of Book Author Publication
No.
1 Computer Fundamentals Goel, Anita Pearson Education, New Delhi,
2014, ISBN: 978-8131733097
2 Computer Basics Absolute Miller, Michael QUE Publishing; 8th edition August
Beginner's Guide, Windows 10 2015, ISBN: 978-0789754516
3 Linux: Easy Linux for Alvaro, Felix CreatevSpace Independent
Beginners Publishing Platform- 2016, ISBN:
978-1533683731
4 Microsoft Office 2010: On Johnson, Steve Pearson Education, New Delhi India,
Demand 2010; ISBN: 9788131770641
5 Microsoft Office 2010 for Schwartz, Steve Pearson Education, New Delhi India,
Windows: Visual Quick 2012, ISBN:9788131766613
Start
6 OpenOffice.org for Leete, Gurdy, Wiley Publishing, New Delhi, 2003
Dummies Finkelstein ISBN: 978-0764542220
Ellen, Mary Leete
7 Computer Fundamentals Dr. Rajendra Devraj Publications, Dist Solapur,
Kawale Maharashtra

14. SOFTWARE/LEARNING WEBSITES

a. https://www.microsoft.com/en-in/learning/office-training.aspx
b. http://www.tutorialsforopenoffice.org/
c. https://s3-ap-southeast-1.amazonaws.com/r4ltue295xy0d/
Special_Edition_Using_StarOffice_6_0.pdf

12.08.2022 Page 9 of 9 1I