Practical Assignments
Information Technology Tools and Network
Basics (M1-R5)
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.
O-Level Practical Exam Old Paper
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
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.
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
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 |
|
|
|
|
|
501 |
|
|
|
|
|
504 |
|
|
|
|
|
513 |
|
|
|
|
|
511 |
|
|
|
|
|
516 |
|
|
|
|
|
532 |
|
|
|
|
|
504 |
|
|
|
|
|
432 |
|
|
|
|
|
501 |
|
|
|
|
|
510 |
|
|
|
|
|
517 |
|
|
|
|
|
479 |
|
|
|
|
|
494 |
|
|
|
|
|
498 |
|
|
|
|
(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
(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
(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 |
|
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:
•
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:
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;
){kind=link}