St. Paul Sr. Sec.
Co-Ed School
Session
2022-2023
Information Technology
Practical File
Submitted By: Class: X – ‘D’
Harsh Singh Roll No: 10411
Submitted To:
Mrs. Shikha Sharma
Acknowledgement
In the accomplishment of this project successfully,
many people have bestowed upon us their blessings
and the heart pledged support, this time I am utilizing
to thank all the people who have been concerned with
this project. I would like to thank our information
technology teacher Mrs. Shikha Sharma, whose
valuable guidance has helped me patch this project and
make it full proof success. Her suggestions and her
instructions have served as the major contributor
towards the completion of the project. Then I would
like to thank my parents, friends and classmates who,
with their valuable suggestion and guidance, have been
helpful in various phases of the project.
Certificate
This is to certify that Harsh Singhof class X – D have
successfully completed the Practical File Of Information
Technology under the guidance of subject teacher Mrs.
Shikha Sharma during the academic year 2022-23 in
partial fulfillment of Information Technology practical
examination conducted by CBSE.
Signature Signature
(Subject Teacher) (Examiner)
Signature School Seal
(Principal)
Index
1. Create a poster on COVID-19 STAY HOME STAY STAFE in MS word with the
following features
2. Type a paragraph with at least 100 words on maintaining workplace safety
and create the below-given styles as instructed:
3. Write a letter and use the concept of mail merge with 5 addresses.
4. Perform conditional formatting on a data subset a. Create a student mark list
of at least 8 students of 5 subjects. Highlight the marks of the students who got
greater than 80 with green colored text with blue fill. b. Save the worksheet as
marks_(your name)
5. Create a worksheet using the data given below of the population of Manipur in
the last 10 years
6. Consider the sales report of a marketing company for the last five years for
the first and second quarters.
7. A student is planning her goals about the marks she should attain in the
forthcoming examinations to achieve a distinction (75%). Assuming that the
examination of each subject is for 100 marks, her marks of PT 1 and Term 1 are
given as under.
8. a. Write the SQL command to create the above table.
b. write the SQL command for inserting the following values in the given table
c. To display those records whose BOOK ID is “1001”.
d. Modify the price by increasing the value from “125 to 175” for BOOK ID 1003.
e. Delete the record of BOOK ID 1004.
9. Write an SQL Query to create a table with the following structure: Emp_ no
char(4), Name Varchar(25), Salary Float, Department varchar(15)
10. Create a database table of your class that contains information about 8
students including their name, Date of birth, father’s name, email, hobby, and
phone number.
Question 1
Create a poster on COVID-19 STAY HOME STAY SAFE in MS
WORD with following features.
A. Font Size C. Font Colour
B. Font – Face D. Images
Stay Home Stay Safe
Follow these steps to fight against Covid-19
These are some precautions against Corona Virus
Question 2
Type a paragraph with at least 100 words on maintain
workplace safety and create below given styles as instructed
Workplace Safety
The signs of a “wet floor” or “danger” are something that everyone chooses to
overlook. But these things are essential. Anyone who runs a company should
know that. An organization would not want its employees to undergo any
injury and accident in the workplace. So you need to ensure proper workplace
health and safety by looking carefully now and then at the various provisions
and systems available at work. As an employer, you are vested with the
supreme responsibility of providing employees with a hazard-free
workplace.Workplace health and safety are essential regardless of the size of a
company. All companies, big or small, need to incorporate security in their
workplaces.It is not possible to measure the effects of human casualties. They
can have grave consequences for employees and their families and friends as
well. This is why workplace safety and health measures are necessary. Also,
employee protection from injuries or death leads to business success.Often, we
get so busy competing for productivity or speed that the safety part falls short
of attention. And accidents are most likely to happen then, especially since we
get complacent with the regular activities that we ignore the danger they
pose.The feeling of assurance that one has, knowing that he will return safely
from work, is more significant than anything else.Employers should also learn
the desired aspects of their employees in terms of safety and protection. This
will help increase productivity and the quality of the products and services.
Work injuries and illnesses can
affect every aspect of life for
workers and their families.
Question 3
Write a letter and use the concept of mail merge with 5
addresses
56C Indrapuri,
Bhopal, M.P.
Dear Ujjwal,
Hope you are fine. As you know my birthday is on 28th March
and you are invited. The celebration will start at 7’o clock at
my house. Hope you will join me in this celebration.
Your Friend,
Harsh
15 A Rajeev Nagar,
Bhopal, M.P.
Dear Raghav,
Hope you are fine. As you know my birthday is on 28th March
and you are invited. The celebration will start at 7’o clock at
my house 23 A Rajeev Nagar. Hope you will join me in this
celebration.
Your Friend,
Harsh
75 B Indrapuri,
Bhopal, M.P.
Dear Akshay,
Hope you are fine. As you know my birthday is on 28th March
and you are invited. The celebration will start at 7’o clock at
my house 23 A Rajeev Nagar. Hope you will join me in this
celebration.
Your Friend,
Harsh
05 C Anand Nagar,
Bhopal, M.P.
Dear Swayam,
Hope you are fine. As you know my birthday is on 28th March
and you are invited. The celebration will start at 7’o clock at
my house 23 A Rajeev Nagar. Hope you will join me in this
celebration.
Your Friend,
Harsh
69 D Awadpuri,
Bhopal, M.P.
Dear Sujay,
Hope you are fine. As you know my birthday is on 28th March
and you are invited. The celebration will start at 7’o clock at
my house 23 A Rajeev Nagar. Hope you will join me in this
celebration.
Your Friend,
Harsh
Question 4
Perform conditional formatting on a data subset
A. Create a student mark list of at least 8 students of 5
subjects. Highlight the marks of the students who got greater
than 80 with green colored text with blue fill.
B. Save the worksheet as marks_(your name)
Students Maths English Hindi S.ST Science
Ujjwal 75 66 78 68 50
Raghav 50 40 88 60 60
Akshay 77 69 79 72 60
Jasdeep 82 88 77 60 88
Utkarsh 95 78 55 66 93
Suryansh 93 68 45 79 85
Swayam 55 70 78 50 40
Gurutav 78 88 65 78 66
Question 5
Create a worksheet using the data given below of population of Manipur in
last 10 years
Year Population Growth rate%
2011 28,55,794 24.50
2001 22,93,896 24.86
1991 18,37,149 29.29
A. Create a bar line charts using this data. Enhance design of your chart to
make it more presentable.
B. Prepare a pie chart showing the growth rate of different years.
Question 6
Consider the sales report of a marketing company of the last
five years for the first
A. Open a workbook and enter the data into it.
B. Save the workbook with the name ‘SALES REPORT’.
C.By how much does the sale of the second quarter is more
than the that of the first quarter?
D. Find the total sales
F. Use the page break feature to fit the content on one page
before taking the print out
Year Quarter 1 Quarter 2 Difference in
(Jan-June) (July-Dec) sales
2013 275000 350000 75000
2014 158000 247000 89000
2015 286000 384952 98952
2016 295442 348792 53350
2017 356000 375896 19896
Total scale 1370442 1706640 336198
C. By how much do the sales of the second quarter is more
than that of the first quarter?
Ans. 336198
Question 7
A student is planning her goals about the marks she should attain
in the forthcoming. Examination in order to achieve a
distinction (75%). Assuming that the examination of each
subject is for 100 marks, her marks in PTM 1 and TERM 1 are
given as under.
ENGLISH MATH SCIENCE
PT 1 72 63 54
TERM 1 70 69 80
Find out how many marks should she obtain in TERM 2 to
secure 75%.
Answer 7
ENGLISH MATH SCIENCE TOTAL PERCENTAGE
PT 1 72 63 54 189 63%
TERM 1 70 69 80 219 73%
TERM 2 88 89 90 267 75%
QUESTION 8
FILE NAME DATA TYPE CONSTRAIN
BOOK ID NUMERIC PRIMARY KEY
SUBJECT VARCHAR (30)
BOOK PRICE NUMERIC
A. Write a SQL command to create above table.
B. Write the SQL command for inserting the following values
in the given table.
BOOK ID SUBJECT BOOK PRICE
1001 INFORMATION 108
TECHNOLOGY
1002 SCIENCE 100
1003 MATHS 125
1004 ENGLISH 150
C.To display those record whose Book ID is “1001”.
D. Modify the price by increasing value from “125” to “175”
for BOOK ID 1003.
E. Delete the record of BOOK ID 1004.
Answer 8
A. #CREATE TABLE my_data( book_id int primary key ,
subject_ varchar (30),book_price int )
B. #INSERT INTO my_data VALUES(1001 , INFORMATION
TECHNOLOGY ”, 108);
#INSERT INTO my_data VALUES(1002 ,”SCIENCE ” , 100);
#INSERT INTO my_data VALUES(1003 , “MATH’S ”, 125);
#INSERT INTO my_data VALUES(1004 , “ENGLISH”, 150);
C. #SELECT * FROM my_data WHERE book_id=1001;
D. #UPDATE my_data SET book_price=175 WHERE
book_id=1003;
E. #DELETE FROM my_data WHERE book_id = 1004;
Question 9
Write an SQL Query to create a table with the following
structure: emp_no char (4), Name Varchar (25), Salary float,
Department varchar (15).
Answer 9
Question 10
Create a database table of your class that
containsinformation about 8 students including their names,
Date Of Birth, Father’s Name, E-mail, Hobby, and Phone
number.
Answer 10
STUDENT LIST
S.NO NAME DATE OF BIRTH
1 Suryansh sarathe 09-02-2007
Vinay
2 04-07-2007
Deshmukh
3 Tanisk Sahu 01-05-2007
Jasdeep Singh
4 31-01-2007
Saini
Satyam kumar
5 12-03-2006
Sharma
6 Ujjwal Sahu 23-03-2007
7 Kapil Mehra 27-06-2006
8 Vishesh Bharti 24-07-2007
PHONE
FATHER NAME EMAIL HOBBY NUMBER
SHER SINGH SARATHE suryans@gamil.com playing cricket (982) 734-1802
Babu Rao Deshmukh vinay@gmail.com playing football (808) 509-3262
Ashok Sahu tanisq@gmail.com watching television (99) 937-7930
Raghubir Singh Saini jasdeep@gmail.com playing football (989) 310-2935
Kalmesh Kumar Sharma satyam@gmail.com reading, dancing (989) 311-0862
L. C. Sahu ujjwal@gmail.com playing football (888) 398-1941
Dinesh Mehra kapil@mail.com playing cricket (982) 649-8731
Santosh Bharti vishesh@gmail.com playing cricket (66) 056-4246
Bibliography
→ www.google.com
→ https://opentextbc.ca
→ www.brainly.com
→ www.wikipedia.com
→ www.byjus.com
→ www.vedantu.com
