Ishika Shikshan Prasarak Mandal, Latur
KIDEES INFO PARK
At/ Post-Peth, [Link]. 413512
PRACTICAL FILE
ON
INFORMATION TECHNOLOGY CODE: 402
SESSION: 2024-2025
SUBMITTED TO:
…………………………………………………………………………..
SUBMITTED BY:
STUDENT NAME:…………………………………………………………………….
ROLL NO.: ………...
CLASS & SECTION: ……………………..
Acknowledgement
I would like to convey my heartfelt thanks to Gauri Mam who always gave valuable
suggestions and guidance for completion of my project.
She helped me to understand and remember important details of the project. My project
has been a success only because of her guidance.
I am especially indented & I am also beholden to my friends. And finally I thank to the
members of my family for their support and encouragement.
Certificate
This is to certify that of class
of KIDEES INFO PARK School, At/Post-Peth, [Link]. Latur. 413512 has completed his/her
practical file under my supervision.
He / She has taken proper care & Shown sincerity in completion of this practical file.
I certify that this practical file is up to my expectation & as per the guideline issued by CBSE.
Mrs Gauri M. Ambegave
(IT Teacher)
INDEX
Sr. Name of the Practical Page No. Signature of the
No. (Learning Outcomes) teacher
A LibreOffice Writer(Digital Documentation)
1 Introduction to standard toolbar & formatting Toolbar
2 Applying Editing Features
3 Create & work with Tables
4 Formatting Table
5 Understand and Apply Mail Merge
B LibreOffice Calc(Electronic Spreadsheet)
1 Formatting Worksheet and save options
2 Create Mark Sheet (Using functions)
3 Pie Chart (News Paper Survey)
4 Line Chart (Mathematical Expression, Referencing)
5 Column Chart(Monthly Electricity Bill)
6 Apply Sorting, Filter, Data Validation
C LibreOffice Impress(Digital Presentation)
1 Create a Presentation
2 Working With Slides
3 Insert & Format Text & image, Apply Animations
4 Create & Use of Tables
5 What are the five views of presentation?
6 Learn about Views in Presentation
A.
LibreOffice Writer
(3. Digital Documentation)
To create, Edit & Delete the documents we are going to use LibreOffice Writer Software
application from LibreOffice Suit.
Assignment No. A1:-
Draw all the icons of standard toolbar and formatting toolbar and write its uses.
Assignment No. A2:-
Open the file my document 1 and type the text given in the box below:
The Word completion facility is little different than Auto Correct facility. While typing as
and when you type two-three characters, Writer tries to guess which word you are typing
and offers to complete the word for you. To accept the suggestion, press Enter Otherwise,
continue typing. Note that this facility is available only for those words which are already
typed in the same document that is the word completion facility is available for a word
getting typed at least for second time.
Perform the operations stated below.
(a) Write steps to count total words in a document?
(b) Is it possible to select the vertical block? If yes, then write the steps.
(c) What are the steps to select a non-consecutive text in writer?
(d) What is Special character in writer and how will you insert in a document?
Assignment No. A3:-
Create a table showing results of randomly selected 5 students of standard 9 as shown in the following
table:
[Link]. [Link]. Hindi English Maths Science SST
1 1 25 24 24 24 24
2 4 15 23 26 23 15
3 6 25 21 24 25 17
4 7 24 20 17 24 24
5 9 22 16 23 21 26
6 11 20 18 22 22 26
(a) Change the width of column to best fit the content
(b) Move the table in the Center position.
(c) Increase the row height
(d) Make the data of all the cells vertically left aligned
(e) Insert a column to the left of the last column and the total of marks obtained by all the
students
f) Split the second cell into two cells horizontally and type subject name and roll number in upper
and lower cells,
(g) Insert a column to the left column inserted and move the content of the last column to the
newly inserted column.
(h) Type the average marks in the last column.
Assignment No. A4:-
The time table prepared for Class IX using a word processor as shown below:
Time Table: Class IX-D
Class Teacher: ABC
Mon Hindi Maths Maths Eng SSC Science SUPW SUPW
Tue Science Science SSC Eng Maths Maths Hindi SS0
Wed SSC Maths Science Eng Sc. (Pr.) Sc. (Pr.) Sc.(Pr) Games
Thu IT IT Maths Eng Sc. S. Sc SSC Games
Fri Maths Maths Science Eng SSC Hindi Maths CTP
The class teacher recommended some changes in the time table to that should looks as follows:
Class Teacher: ABC
1 2 3 4 5 6 7 8
Mon Hindi Maths Eng SSC Science SUPW SUPW
B
Tue Science SSC Eng R Maths Maths Hindi SS0
Wed SSC Maths Science Eng E Sc. (Pr.) Sc. (Pr.) Games
Thu IT Maths Eng A Sc. SSC Games
K
Fri Maths Maths Science Eng SSC Hindi Maths CPT
Sat Meditation Activity House Meeting Bal Sabha
Name the word processing features that should be used to make the changes.
The changes recommended are listed below:
1. The headline should be center aligned
2. The Class Teacher's name should span along all the columns in the first row.
3. Add another row after the first row to indicate period number.
4. The day names should be in italics bold.
5. At all the places in the table where a subject occurs twice for consecutive columns, it should be
once spread over the two columns. displayed only
6. There should be a column after 4th period to accommodate 'BREAK'.
7. There should be a row for Saturday.
8. Period numbers and 'BREAK' should be in Bold.
9. Make border tick in size of BREAK.
10. The table should be center aligned
Assignment No. A5:-
What is Mail Merge? Write down the steps to create mailing labels to paste on wedding cards.
B.
LibreOffice Calc
(4. Electronic Spreadsheet)
To
1. Store data in tabular format
2. Do the mathematical calculations
3. Sort & Filter Data
4. Validate Data
5. Protect Data with Password
we are going to use LibreOffice Calc Software application from LibreOffice Suit.
Assignment No:- B1.
Create the Employee Table with 10 records & columns as follow(Use Fill handle for 1st column)
Sr. No Column Name Column Format
1 Emp_Id E001 to E010
2 Emp_Name Text only
3 Mobile no number Preceding 0
4 Address UserDefined
5 DOB D. MMM. YYYY
6 Salary In $
7 Joining Date & time D. MMMM YYYY
8 No Of days emp worked =Today()- Joining Date
Enter Data in
Cell A14: Bonus=
CellB14: 8000
Explore in how may formats can you save the Calc worksheet using the Save as option. Verify it by
opening in the software.
Assignment No:- B2.
Generate the Calc document with your in all your marks six different subjects. Make total of the marks
find out average and percentages from the data. Use functions
Assignment No:- B3.
Make a small survey in your area and find out the newspaper invited in each house for at least 10
houses. Collect data, arrange them and prepare 3D pie chart based on this.
Assignment No:- B4.
Consider a mathematical function, such as Y=3*X+1. Calculate the value of Y for each even value of X, as given in the
table below.
Value of X 2 4 6 8 10
Value of Y ? ? ? ? ?
For this do the following:
(a) Enter these values in Calc worksheets
(b) Use formula to find out the values of Y for each even value of X
(c) Plot a line chart of X and Y values together
(d) Format the chart as per your choice
Assignment No:- B5.
Collect the electricity bill of your home for each to from January month December (12 months). Create
a worksheet with the data of Name of the Month and Bill Amount as below Enter the data in a
worksheet and develop the chat of various types. Conclude your result that which type of chart will be
more appropriate for such type of data
Month Bill Amount
January
February
March
April
May
June
July
August
September
October
November
December
Assignment No:- B6.
Make a list as given below and sort the list according to class and then by names.
Name Class section Date of Birth Month of Birth Year of Birth
Khushi Class 9 D 06 February 2004
Diya Class 9 A 08 June 2006
Kushaal Class 3 C 10 July 2010
Operations to be performed on above table:
1. Apply a filter in such way, it will display only those friend’s records whose birth dates are in the
month of August.
[Link] data validation so that user can enter birth dates in between 1 to 31 st only. Other than these dates
no input is acceptable.
C.
LibreOffice Impress
(5. Digital Presentation)
To present & add data as
1. Regular text
2. List Items
[Link]
[Link] elements
5. Sound & Video
6 Animation
we are going to use LibreOffice Impress Software application from LibreOffice Suit.
Assignment No. C1.
Create a presentation which gives an overview of the science subject. This presentation should contain
the following slides:
(i) Title of the subject (use title slide layout only)
(ii) Index
(ii) Introduction of each chapter (Minimum one slide per chapter should be prepared.)
Assignment No:- C2
For the presentation created in Q.1 above, do the following:
(1) Rename each slide with the chapter name.
(ii) Change the font for the slide title.
(u) Add a footer that contains the current date and your school name.
(iv) Apply at least one master page to your presentation.
(v) Hide slides of even chapters and see the effect.
(vi) Start the slide show after setting the option as Change slides manually. (Navigator should be visible
during the presentation).
Assignment No:- C3
For the presentation created in Q.1, do the following:
(i) Convert the presentation to a PDF file
(ii) Set the Handout view such that there are 4 slides per page.
Assignment No:- C4
Create a presentation which demonstrates details of a car launched by any company of your choice.
Include the following sliders:
(i) Introduction of the company
(ii) List of cars the company sells.
(ii) Introduction of the new car launched.
Assignment No:- C5
For the presentation created in the question above, add the following functionalities:
(1) All models of the car should be displayed in tabular format. (Model name, Basic Price, Average,
Capacity)
(ii) Modify the appearance of the table and set animation effect as box
(iii) Add the image of the each model with its description
(iv) Change the background colour of each slides of your presentation.
Assignment No:- C6
What are the five views of presentation?