19 Sample Practical Assignments

19.1 Information Technology Tools and Network Basics (M1-R5.1)

i. Do the following settings
a. Display pointer trails
b. Change the normal pointer of a mouse to another pointer
c. Set the date advanced by 2 months
d. Reset the system date & time
e. Set the system time late by 2 hrs: 40 minutes.
f. Set the Yesterday date and time in your Operating System.
ii. Do the followings
a. Interchange the functions of left and right mouse buttons.
b. Change the wallpaper of your computer and set it to a paint brush file made by you.
c. Change the screen saver of your computer and change it to ‘marquee’
d. Set your name as the text and wait time should be 2 minutes.
iii. Create the following folders under the specified locations using windows.
a. NIELIT on desktop
b. R1 on the c: i.e. root
c. D2 on desktop
d. R2 on the c:
e. Create a folder NIELIT-1 under the D1 folder
f. Create a folder D2-1 under the D2 folder
g. Copy this D2-1 folder and paste it under R1 folder.
h. Delete the folder D2-1 from R1 folder
i. Create the folder R1-1 under R1 folder
j. Copy R1-1 folder under the R2 folder
k. Rename folder R1-1 under R2 folder as ‘subfolder of R2’
l. From the c: copy all files to folder R2
m. Delete all the files from the folder R2
n. Recover all the deleted files
iv. Create a document in Word on a topic of your choice. Format the document with various
fonts (minimum 10, maximum 12) and margins (minimum 1.5, maximum 3). The
document should include
a. A bulleted or numbered list
b. A table containing name, address, basic pay, department as column heading
c. A picture of lion using clip art gallery
d. An example of word art
Syllabus Revision 5.1 for ‘O’ Level (IT) Under DOEACC Scheme
Page No. 34
 e. A header with student name & date
f. A footer with pagination
v. Create a document with the text given below and save it as First
A Read only Memory is a memory unit that performs the read operation only, it does not
have a write capability. This implies that binary information stored in a ROM is made
permanent during the hardware production of the unit and cannot be altered by writing
different words into it. Whereas a RAM is a general-purpose device whose contents can be
altered during the computational process, a ROM is restricted to reading words that are
permanently stored within the unit. The binary information to be stored specified by the
designer, is then embedded in the unit to form the required interconnection pattern.
Do the following
a. Count the occurrences of the word “ROM” in the above document.
b. Replace ROM with Read Only Memory in the entire document
c. Underline the text Read Only Memory
d. Make an auto correct entry for ROM and it should be replaced by Read Only
e. Memory
vi. Use the file First to perform the following operations
a. Make the first line of document bold.
b. Make the second line italic.
c. Underline the third line.
d. Align the fourth line to center.
e. Make the font color of first line as red.
f. Change the font style of fifth line to Arial.
g. Change the second line to 18 points.
h. Insert the date & time at the start of document.
vii. Use the document saved earlier and perform the page setting as follows.
a. Top Margin 1.3”
b. Bottom margin 1.4”
c. Left margin 1.30”
d. Right margin 1.30”
e. Gutter margin 1.2”
f. Header 0.7”
g. Footer 0.7”
h. Paper size executive
i. Orientation landscape

viii. Create a table in word as shown below with following fields.

Roll No Name Marks Total
Physics Chemistry Marks
1. Ritu 78 88 166
2. Amit 90 92 182
3. Rakesh 67 78 145
4. Rohit 50 50 100
5. Niti 60 65 125
6. Garima 89 67 156
ix. Do the followings.
a. In the total marks column, entries should be calculated using formulas and it is the
sum of marks in physics and marks in chemistry.
Syllabus Revision 5.1 for ‘O’ Level (IT) Under DOEACC Scheme
Page No. 35
 b. Insert a new row at the end of the table and also find grand total using formula.
c. Sort the table based on total marks
d. The date and heading should be center aligned
e. Heading should be in bold and underlined
x. Below is given a letter and some addresses. This letter is to be sent to all these addresses.
User mail merge
Addresses are:
1) Amit, H No 424 sector 8D, Lajpat Nagar, New Delhi
2) Rohit, H No 444, Sector 125C, Chandigarh
3) Jyoti,H NO 550, Sector 16A, Gomti Nagar,Lucknow

The Letter is
To
<<Name>>
<<Address>>
Dear <<Name>>
You are advised to appear for an interview on the <<Date>>at 9:00 A.M with your
original documents.
Yours Sincerely

ABC Limited,
Industrial Phase –7, New Delhi.
xi. Make a template for the bio-data with the following format
Bio-Data
Name :
Father’s Name :
Date of Birth :
Age :
Address :
Educational Qualification
Sr No Qualification Board Percentage
Work Experience:
xii. Type the following data using spreadsheet tool and save the file as First
A B C D E
513

Syllabus Revision 5.1 for ‘O’ Level (IT) Under DOEACC Scheme
Page No. 36
 501
504
513
511
516
532
504
432
501
510
517
479
494
498

Do the following
(a) Highlight column A and copy it to column C
(b) Sort the data in column C in ascending order
(c) What is the lowest number in the list (use a function)
(d) Copy the data in column A to column E and sort it in descending order
(e) What is the highest number in the list (use a function)
(f) How many numbers in this list are bigger than 500 (use a database function)
(g) How many numbers in column A are between 520 and 540 inclusive
(use a database function),
xiii. Type the following data in spreadsheet and save it as Second.
A B C D
370 70.5
61166 53.5
684 65
449 76.5
643 70
1551 71
616 60.5
403 51.5
Do the following
(a) Complete column C for finding product x * y
(b) Find sum of x column at the end of data
(c) Find sum of y column at the end of data
Syllabus Revision 5.1 for ‘O’ Level (IT) Under DOEACC Scheme
Page No. 37
 (d) Find sum of x * y column at the end of data
(e) Find sum of x^2
(f) Find sum of y^2

xiv. Enter the following data using spreadsheet tool and save it in Grade
Name Marks1 Marks2 Marks3 Total Percentage
Amit 80 70 80
Renu 70 60 90
Rajeev 87 89 65
Munish 76 67 44
Sanjeev 98 76 78
Anita 65 76 87

Do the following.
(a) Compute the total marks and percentage of each student by entering appropriate
formula.
(b) Compute the grades based on following criteria
If percentage >= 90 then grade = A
If percentage >= 80 and <90 then grade = B
If percentage >= 70 and <80 then grade = C
If percentage >= 60 and <70 then grade = D
If percentage < 60 then grade = E
(c) Draw a border around the worksheet
(d) Change the font size of heading to 14 points and underline it and hide column c
(e) Increase the width of column A to 15 characters
(f) Right Align the values in column B, C, F

xv. A university maintains a year wise result for four courses and then generates an average
report as given below.

Sr. No. Year Course1 Course2 Course3 Course4 Average

1 2013 650 675 666 456
2 2014 600 700 656 765
3 2015 677 655 765 400
4 2017 400 400 400 400
5 2018 560 760 467 737
Total
(a) Complete the report to calculate the course wise average in row 6
(b) Provide formula to calculate year wise average in column G
(c) Generate a column chart to compare data.

xvi. A person wants to start a business and he has four schemes to invest money according to
profit and years. Find out which scheme is the most profitable using scenario manager.
Investment Amount Percentage for profit No. of years
20000 10 6
40000 20 5
14000 30 4

Syllabus Revision 5.1 for ‘O’ Level (IT) Under DOEACC Scheme
Page No. 38
 12000 15 5

xvii. A company records the details of total sales (in Rs.) Item and month wise in the following
format
Sector Jan Feb March April
PCs 12000 17000 15000 20000
Laptops 14000 18000 15000 16000
Printers 15000 18000 13000 12000
Scanners 16000 15000 14000 23000
(a) Enter the data using spreadsheet and save it as sector
(b) Using appropriate formula, calculate total sale for each sector
(c) Create a 3-D column chart to show sector wise data for all four months
(d) Create a 3-D pie chart to show sales in Jan in all sectors
xviii. Type the following data and save it in employee file using spreadsheet tool.

Name Department Designation Salary Address

Anju TRG MD 100000 CHD
Amit TRG AD 200000 MOHALI
Renu BILL MD 300000 CHD
Anita BILL AD 20000 MOHALI
Shivani S/W MD 10000 CHD
Do the following
a) Count the total no. of employees department wise
b) List the name of employees whose designation is ‘MD’
c) List the name and department of employees whose address is Chandigarh
d) List the name of employees whose salary is greater than 5000
e) List the Address of employees whose department is ‘TRG’
xix. Set up a new presentation of three slides.
1. On the master slide:
a) Apply a theme of your choice to the master slide.
b) Include an automated page number in the bottom left of the footer
c) Place a clipart image of a pen or pencil as a logo in the top right corner.
2. Add the following text in slide 1
Heading: Hothouse Design (Red, 25 point, Arial font, Left Aligned)
3. On the second slide type the following text where font="Arial" size="20"

Earlier in the year we started to analyze the sales profile for the stationery business stream
within Hothouse. The areas of initial investigation were selected as the management of
our sales team, our customer base, website effectiveness, and an analysis of our most
successful product lines.
4. On the third slide where font="Arial” size="20"
Possible timings for these bonuses include:
Syllabus Revision 5.1 for ‘O’ Level (IT) Under DOEACC Scheme
Page No. 39
 • Weekly
• Monthly
• Quarterly
• Annually.
xx. Set up a new presentation consisting of 3 slides
1. On the first slide
a) Type Telephone Analysis for the title, using any word Art option.
b) Insert any appropriate image below the title and apply an Animation effect to the
image.
c) Insert a Sound from the Clip Organizer.

2. On the second slide:

a) create a pie chart using the following data:

Call type Minutes

International 1640
Peak Rate 7842
Cheap Rate 1543
Internal 16805
b) Insert the chart title “Telephone Analysis”.
3. On the third slide:
Enter the following text: (font style="Times new roman", font size= "24")
As you can see that our vast majority of calls are internal. These figures are the average
values per day for all departments, using a monitoring period of 2 weeks.
4. Use the same transitional effect between each slide.
5. Play a slide show.
xxi. Set up a new presentation consisting of 4 slides
1. On the first slide
d) Include an automated slide number left aligned.
e) Enter the heading New Website.
f) Enter the sub heading Proposed Web Pages.
g) Insert any appropriate image below the sub heading and apply an Animation effect
to the image.
h) Create the following hyperlink http://www.google.com on the image
i) Insert a Sound from the Clip Organizer.
2. On the second slide:
c) create a pie chart using the following data:

Type of Trip 2008 Dives

Go deep 2512
Wreck Week 12680
Shark Experience 940
Cave Dives 353
3. On the third slide:
Syllabus Revision 5.1 for ‘O’ Level (IT) Under DOEACC Scheme
Page No. 40
 Enter the following text: (font style=Times New Roman, font size= 24)
During the development of this new website, we have realized that the proposed design
brief may need to be amended.
4. On the fourth slide:
Insert a Movie from a File on Your Computer
5. Use a picture as background in all your slides.
6. Use the same transitional effect between each slide.
7. Play a slide show.
xxii. Write a paragraph on each of followings.
a) List five popular Browser Names.
b) What are Cookies, and Why Should I Enable Them?
c) How to delete History in Web Browser?
xxiii. Write a paragraph on each of followings.
a) What is difference between IPv4 and IPv6 Address?
b) How to set IP IPv4 address in your computer?
c) What is gateway?
xxiv. Write a paragraph on each of followings.
a) What is MPIN?
b) What are the requirements for using UPI App?
c) Explain the Work of BHIM App. How to install in Mobile.
d) What is the difference between RTGS and IMPS Service?
xxv. Write a paragraph on each of followings.
a) What is IOT; List the name of some IOT related device which we use in our daily
life.
b) What is Big Data Analytics? Where it is used.
c) What is Robotics;

19.2 Web Designing and Publishing (M2-R5.1)

i. Create an HTML file (e.g. first_page.html) that specifies a page that contains a heading
and two paragraphs of text. As the texts in the heading and paragraphs you can use any
texts you like
ii. Write a HTML program to design a form which should allow to enter your personal data (
Hint: make use of text field, password field, e-mail, lists, radio buttons, checkboxes,
submit button)
iii. Write html code to generate following output.
1.Coffee
2.Tea
3.Black Tea
4.Green Tea
5.Milk
iv. Write HTML Code to demonstrate the use of Anchor Tag for the Following: -
1. Creating a web link that opens in a new window.
2. Creating a web link that opens in the same window.
Syllabus Revision 5.1 for ‘O’ Level (IT) Under DOEACC Scheme
Page No. 41
 3. C Reference within the same html document.
4. Reference to some image.
5. Making an image a hyperlink to display second image
v. Create an html page with following specifications
Title should be about my City. Place your City name at the top of the page in large text and
in blue color. Add names of landmarks in your city each in a different color, style and
typeface. One of the landmark, your college name should be blinking. Add scrolling text
with a message of your choice
vi. Create an html page with 7 separate lines in different colors. State color of each line in its
text.
vii. Create an html page containing the polynomial expression as follows:
a0 + a1x+ a2x 2 + a3 x3
viii. Write a HTML code to generate following output

ix. Create an html page with red background with a message “warning” in large size blinking.
Add scrolling text “read the message” below it.
x. Write a HTML page to print Hello world in bold & Italic Form.
xi. Design a HTML page to display a picture. The picture should be removed from the screen
after a mouse click on the picture.
xii. Create a HTML Document with JavaScript code that has three Textboxes and a button.The
details should be accepted using textboxes are principal, rate of interest, and duration in
years. When user clicks the OK Button a message box appears showing the simple interest
of principal amount.
xiii. Write a HTML Script to insert a hyperlink. Create a hyperlink in html which when clicked
links to www.google.com in a new window
xiv. Create a HTML file which displays three images at LEFT, RIGHT and CENTER
respectively in the browser.
xv. Create table with ROWSPAN and COLSPAN attribute of TABLE in HTML(Prepare
timetable of your class). Include CELLSPACING & CELL PADDING.
xvi. Create a web page, divide the web page into four frames. In one frame create three links that
will display different HTML forms in the remaining three frames respectively. Write a
program in Java Script to print factorial.
xvii. With CSS use the shorthand background property to set background image to eg."xyz.png",
show it once, in the top right corner.
xviii. Write a program in javascript to generate series of prime numbers.
Syllabus Revision 5.1 for ‘O’ Level (IT) Under DOEACC Scheme
Page No. 42
 xix. `Write a JavaScript program to display the current day and time in the following format.
Sample Output: Today is: Tuesday.
Current time is: 10 PM: 30:38
xx. Write a program to sum and multiply of two numbers using JavaScript.
xxi. Write a program to redirect, popup and print function in JavaScript.
xxii. Create your first "Hello world" application in AngularJS.
xxiii. HTML page which has a title of "Event Registration" and has references to important
libraries such as Bootstrap, JQuery and Angular.
xxiv. Write a code to display the words "AngularJS" in both text format and in a text box when the
page is viewed in the browser.
xxv. Create a sample form program that collects the first name, last name, email, user id, password
and confirms password from the user. All the inputs are mandatory and email address entered
should be in correct format. Also, the values entered in the password and confirm password
textboxes should be the same. After validating using JavaScript, in output display proper
error messages in red color just next to the textbox where there is an error.
19.3 Programming and Problem Solving Through Python (M3-R5.1)
i. Write a program to print all Armstrong numbers in a given range. Note: An Armstrong
number is a number whose sum of cubes of digits is equal to the number itself. E.g.
370=33+73+03
ii. Write a function to obtain sum n terms of the following series for any positive integer value
of X
X +X3 /3! +X5 /5! ! +X7 /7! + …
iii. Write a function to obtain sum n terms of the following series for any positive integer value
of X
1+x/1!+x2/2!+x3/3!+…
iv. Write a program to multiply two numbers by repeated addition e.g.
6*7 = 6+6+6+6+6+6+6
v. Write a program to compute the wages of a daily laborer as per the following rules: -
Hours Worked Rate Applicable Upto first 8 hrs Rs100/-
a) For next 4 hrs Rs30/- per hr extra
b) For next 4 hrs Rs40/- per hr extra
c) For next 4 hrs Rs50/- per hr extra
d) For rest Rs60/- per hr extra
vi. Accept the name of the labourer and no. of hours worked. Calculate and display the wages.
The program should run for N number of labourers as specified by the user.
vii. Write a function that takes a string as parameter and returns a string with every successive
repetitive character replaced by? e.g. school may become scho?l.
viii. Write a program that takes in a sentence as input and displays the number of words, number
of capital letters, no. of small letters and number of special symbols.

Syllabus Revision 5.1 for ‘O’ Level (IT) Under DOEACC Scheme
Page No. 43
 ix. Write a Python program that takes list of numbers as input from the user and produces a
cumulative list where each element in the list at any position n is sum of all elements at
positions upto n-1.
x. Write a program which takes list of numbers as input and finds:
a) The largest number in the list
b) The smallest number in the list
c) Product of all the items in the list
xi. Write a Python function that takes two lists and returns True if they have at least one common
item.
xii. Write a Python program to combine two dictionary adding values for common keys.
d1 = {'a': 100, 'b': 200, 'c':300}
d2 = {'a': 300, 'b': 200, 'd':400}
Sample output: Counter({'a': 400, 'b': 400, 'd': 400, 'c': 300})
xiii. Write a program that takes sentence as input from the user and computes the frequency of
each letter. Use a variable of dictionary type to maintain and show the frequency of each
letter.
xiv. Apply recursive call to do the following:
a) Product of two numbers using repetitive addition
b) Print Fibonacci series up to term n
xv. Write a program to input two numbers as input and compute the greatest common divisor
xvi. Write a function that takes two filenames f1 and f2 as input. The function should read the
contents of f1 line by line and write them onto f2.
xvii. Write a function that reads the contents of the file f3.txt and counts the number of alphabets,
blank spaces, lowercase letters, number of words starting with a vowel and number of
occurrences of a work “hello”.
xviii. Write a program to replace ‘a’ with ‘b’, ‘b’ with ‘c’,….,’z’ with ‘a’ and similarly for ‘A’
with ‘B’,’B’ with ‘C’, …., ‘Z’ with ‘A’ in a file. The other characters should remain
unchanged.
xix. Write a NumPy program to find the most frequent value in an array.
xx. Take two NumPy arrays having two dimensions. Concatenate the arrays on axis 1.
19.4 Internet of Things and Its Applications (M1-R5.1)
i. Write a program to Blink default Light Emitting Diode(LED) on Arduino board with the
delay of 2 sec.
ii. Write a program to interface LEDs on pin no. 10,11,12,13 and blink alternatively at the
delay of 1 sec.
iii. Write a program to run pattern(s) on LEDs connect at pins 10,11,12,13.
Pattern example:

on, off, off, off on, on, off, off

off, on off, off off, on, on, off
off, off, on, off off, off, on, on
off, off, off, on
Syllabus Revision 5.1 for ‘O’ Level (IT) Under DOEACC Scheme
Page No. 44
 iv. Write a program to interface buzzer with Arduino board to buzz on/off with the delay of
1sec.
v. Write a program to interface LED and Buzzer with Arduino board, so that buzzer is put on
whenever LED is on and Buzzer is put off when LED is off.
vi. Write a program to interface Button and LED, so that LED blinks/glow when button is
pressed.
vii. Write a program to interface Button, buzzer and LED, whenever the button is pressed the
buzzer gives beep for 100ms and LED status is toggled.
viii. Write a program to interface LEDs at pins 10,11,12,13 and buttons at pins 7,8. When first
time button at pin 7(increment button) is pressed first LED at pin 10 is switched on, when
second time button is pressed the next LED at 11 is switched on. Similarly, when the button
at pin 8 (decrement button) is pressed the LEDs are switched off sequentially.
ix. Write a program to interface LEDs at pins 10,11,12,13 and button at pins 7. The press of
button changes the pattern of LED glow. (considering four patterns of LED glow)
x. Write a program to interface Light Dependent Resistor (LDR) and display the values read
on the Serial monitor after delay of 2 seconds each.
xi. Write a program to interface Light Dependent Resistor (LDR) and LED with Arduino board.
Whenever there is sufficient light falls on LDR the LED is off and when there is dark around
LDR the LED is put on.
xii. Write a program to interface LEDs at any two PWM pins and exhibit LED fading.
xiii. Write a program to interface LED at PWM pin and LDR, in such a way that when the light
intensity falling on LDR rises the LED glow should be reduced and after a threshold value
the LED should be put off. (representing smart street light concept)
xiv. Write a program to interface LEDs at any two PWM pins and button, to exhibit LED fading
at the click of button
xv. Write a program to interface any analog (pollution) sensor and display the values read on
Serial monitor.
xvi. Write a program to interface LCD with Arduino board and display ‘Hello world’ on it .
xvii. Write a program to interface keypad with Arduino board and display the key pressed on
Serial monitor.
xviii. Write a program to interface LCD and keypad with Arduino board and display the key
pressed from keypad on LCD.
xix. Write a program to interface LCD and keypad (4 X 4) , to exhibit the functionality of a basic
calculator.

1 2 3 4
5 6 7 8
9 0 + -
/ * Clear enter
xx. Write a program using LCD, LEDs, Buzzer and keypad to simulate a password based
security lock system. User enters 4-digit password and if the password is correct buzzer and
Green LED is put on. But if the password is incorrect Red LED is put on. After three
incorrect attempts Red LED along with buzzer blinks continuously.

Syllabus Revision 5.1 for ‘O’ Level (IT) Under DOEACC Scheme
Page No. 45
 xxi. Write a program to interface LCD and DHT11, displaying the value read from sensor DHT
on LCD.
xxii. Write a program to interface DHT11 or any other temperature sensor, DC Motor, to exhibit
a real life situation that whenever temperature rises above a threshold value the DC motor
(representing fan) starts and when temperature falls below a value, the motor stops.
xxiii. Write a program to interface LCD and Bluetooth module, to exhibit the values received
from mobile handset via Bluetooth on LCD.
xxiv. Write a program to interface LED and Bluetooth module, to switch on the LED if 1 is passed
through Bluetooth and switch off the LED if 0 is send.
xxv. Write a program to interface Relay and Bluetooth module to switch on AC load (5W LED
bulb, table lamp, etc) connected to relay if 1 is passed through Bluetooth and switch off the
AC Load if 0 is send.

Syllabus Revision 5.1 for ‘O’ Level (IT) Under DOEACC Scheme
Page No. 46