CLASS-X –IT(402)
BOARD PRACTICAL FILE
2024-25
SUBMITTED BY:- ALINA
CLASS AND SECTION:- X-B
ROLL NO.:- 04
TEACHER’S NAME:- Mrs.Seema Kori
TEACHER’S SIGN:-
PRINCIPLE SIGN:-
S.NO PRACTICAL TEACHER’S SIGN
1 Apply Styles
2 Insert and use images
3 Create and use
template
4 Apply subtotal
5 Link data and
spreadsheet
6 Using of scenarios
7 Aplication of goal
seek
8 SQL on table
“STUDENT”
9 SQL on table
“ADMIN”
PRACTICAL-I
AIM-Create and apply styles in digital documentation
OBJECTIVE-Using various commands to create styles in LO
writer
Task-Type a para with atleast 100 words and create a
new style
1.Font name-Arial Rounded; Size-24; Colour: Blue
2.Style name-My First Heading
Steps:-
1. Right-click on the text you want to base the style on
2. Select Styles from the mini toolbar
3. Select Create a Style
4. In the Create New Style from Formatting dialog box, name the
style
5. Select OK
PRACTICAL-II
AIM-Insert and Use image in digital documentation
OBJECTIVE-Inserting images and shapes and rearranging
them
Task-Create a new LO writer and Type a para
Steps:-
1.Insert a picture of your choice
2.Adjust the pic at top left of the para
3.Insert some shapes and write additional text into the
shapes
PRACTICAL-III
AIM-Create and use templates
OBJECTIVE-Creating templates of certificates for sport in
LO writer and saving for distribution
Task-Prepare a template for sport certificate format
Steps:-
1.Apply formatting as required
2.Set this template as a default template
3.Change the default to custom template
4.Use school logo
PRACTICAL-IV
AIM-Create and Customize table of contents
Task- Create and Customize table of contents
Steps:-
1.Prepare a document with different headings.
2.Apply a table of contents
PRACTICAL-V
AIM-Link data and spreadsheet
Task-Prepare a worksheet as following
Steps:-
1.Enter data such as roll no.,first name,last
name,DOB,father name,mother name.Enter records
for atleast 10 students
2.Rename the name as STUDENTS PROFILE
3.Insert 3 new worksheets and name as Periodic Test I,
Periodic Test II and Periodic Test III
4.In the Periodic Test I worksheet create reference for
Roll No.,First Name and Last Name columns by using
keyboard
5. .In the Periodic Test II worksheet create reference for
Roll No.,First Name and Last Name columns by using
mouse
6. .In the Periodic Test III worksheet create reference
for Roll No.,First Name and Last Name columns as your
wish.
PRACTICAL-VI
AIM-Analyze data using scenarios and goal seek
OBJECTIVE-Applying Data Consolidation in LO Calc
Task-Create a new file in spreadsheet software and enter
data for 10 students
Steps:-
1.Add 2 worksheets in file and modify the data for all 3
quarters
2.Rename all worksheets like PT-1,PT-2, Half Yearly
3.Now add one more worksheet at end and rename as
consolidate sheet
4.Now typethe serial no. and names as displayed,use sum
function to add data for PT-1,PT-2 and half yearly using
consolidation.
PRACTICAL-VII
AIM-Goal Seek Application
Task-Prepare a worksheet as following
Steps:-
1. Make a table
2. Add all value
3.Take out total marks obtained
4.Now take out overall percentage
PRACTICAL-VIII
AIM-Apply SQL commands
Task-Prepare a worksheet as following
Steps:-
1. Make a table
2. Write down all the commands as given in question
REGD.NO NAME BRANCH
0001 RAM CSE
0002 HARI MECH
0003 PRADEEP EEE
0004 DEEPAK ETC
PRACTICAL-IX
AIM-Apply SQL commands
Task-Prepare a worksheet as following
Steps:-
1. Make a table
2. Write down all the commands as given in question
DEPT_ID DEPT_NAME EMPLOYEE_NA CITY
ME
DEP101 ACCOUNTS Ram PUNE
DEP102 HR Hari DELHI
DEP103 PURCHASE Pradeep MUMBAI
DEP104 SALES Deepak CHENNAI
PRACTICAL-X
AIM-Apply SQL commands
Task-Prepare a worksheet as following
Steps:-
1. Make a table
2. Write down all the commands as given in question
PID PNAME PRICE QUANTITY CATEGORY
P01 BOARD 10000 2 OFFICE
P02 EYELINER 700 50 MAKEUP
P04 PENCIL 5 500 SCHOOL
P05 LAMP 250 10 DOMESTIC
P08 BEDSHEET 450 45 DOMESTIC
P09 LAPTOP 75000 15 OFFICE
THANK YOU
