ST.
PAUL'S SCHOOL
(JHINJHARI)
MADHYA PRADESH
INFORMATION
TECHNOLOGY (402)
Class-IX
PRACTICAL RECORD
2024-25
CERTIFICATE
This is to certify that this practical work is submitted by
____________________________________________________________________________
(R.No. __________________) to the Computer Department of
ST.PAUL’S SCHOOL, JHINJHARI, carried
out by her/him towards partial completion of Practical Exam for
class IX during academic year 2024-25.
Internal Examiner PRINCIPAL
INDEX
S.NO Practical Page No. Signature
UNIT 3 DIGITAL DOCUMENTATION
1. Practical 1: Bold Italic and Underline effects.
2. Practical 2: Demonstrate font case on Text
3, Practical 3: Spelling and Grammar Tool
4. Practical 4.: Find and Replace.
5. Practical.: 5 Managing Headers And Footers.
UNIT 4 ELECTRONIC SPREADSHEET
6. Practical: 6 Creating various Charts.
7. Practical: 7 Paragraph Alignment.
8. Practical.: 8. Performing calculations using
different functions.
9. Practical.: 9. Calculating simple interest.
UNIT 5 DIGITAL PRESENTATION
10. Practical: 10. Creating Presentation.
Practical 1: Bold Italic and Underline effects.
Date:
Aim: Demonstrate Bold Italic and Underline effects on text.
Procedure:
1. Select the paragraph and click on B in the Font group on the Home tab.
2. Select the paragraph and click on I in the Font group on the Home tab.
3. Select the paragraph and click on U in the Font group on the Home tab.
Result:
Bold:
On the Insert tab, the galleries include items that are designed to coordinate
with the overall look of your document. You can use these galleries to insert
tables, headers, footers, lists, cover pages, and other document building
blocks.
Italic:
On the Insert tab, the galleries include items that are designed to coordinate with
the overall look of your document. You can use these galleries to insert tables,
headers, footers, lists, cover pages, and other document building blocks.
Underline:
On the Insert tab, the galleries include items that are designed to coordinate with
the overall look of your document. You can use these galleries to insert tables,
headers, footers, lists, cover pages, and other document building blocks.
Practical 2: Demonstrate font case on Text.
Date:
Aim: Applying various font case.
Procedure:
Change Text to Sentence Case
Step 1 − Select the portion of text that that needs to be put in sentence case. We can use
any of the text selection methods to select the portion of text.
Step 2 − Click the Change Case button and then select the Sentence Case option to
capitalize the first character of every selected sentence. Change Text to Lower case
Step 1 − Select the portion of text that needs to be put in lower case. We can use any of
the text selection methods to select the portion of text.
Step 2 − Click the Change Case button and then select Lower case option to display all
the selected words in lower case. Change Text to Uppercase
Step 1 − Select the portion of text that we want to change to a bold font. We can use any
of the text selection method to select the portion of text.
Step 2 − Click the Change Case button and then select UPPERCASE option to display
all selected words in all caps. All characters of every selected word will be capitalized.
Capitalize Text
Step 1 − Select the portion of text that needs to be capitalized. We can use any of
the text selection method to select the portion of text.
Step 2 − Click the Change Case button and then select the Capitalize Each Word
option to put a leading cap on each selected word.
Toggle the Text
Step 1 − Select the portion of text that we want to change to a bold font. We can
use any of the text selection method to select the portion of text.
Step 2 − Click the Change Case button and then select the tOGGLE cASE option
to change all the words in lower case into words in uppercase; the words in
uppercase words change to words in lowercase.
Result:
Sentence Case
Provide solutions that utilize machine learning, artificial intelligence and internet of things
technologies to provide enhanced insights with real-time situational intelligence and improved
business outcomes. Lower case
provide solutions that utilize machine learning, artificial intelligence and internet of things
technologies to provide enhanced insights with real-time situational intelligence and improved
business outcomes.
Capitalize each word:
Provide Solutions That Utilize Machine Learning, Artificial Intelligence And Internet Of Things
Technologies To Provide Enhanced Insights With Real-Time Situational Intelligence And Improved
Business Outcomes.
Upper Case
PROVIDE SOLUTIONS THAT UTILIZE MACHINE LEARNING, ARTIFICIAL INTELLIGENCE AND
INTERNET OF THINGS TECHNOLOGIES TO PROVIDE ENHANCED INSIGHTS WITH REAL-TIME
SITUATIONAL INTELLIGENCE AND IMPROVED BUSINESS OUTCOMES.
Toggle Case
pROVIDE SOLUTIONS THAT UTILIZE MACHINE LEARNING, ARTIFICIAL INTELLIGENCE AND
INTERNET OF THINGS TECHNOLOGIES TO PROVIDE ENHANCED INSIGHTS WITH REAL-TIME
SITUATIONAL INTELLIGENCE AND IMPROVED BUSINESS OUTCOMES.
Practical 3: Spelling and Grammar Tool
Date:
Aim: To use spelling and grammar tool to correct the text .
Procedure:
1. Go to the Review tab.
2. Click on the Spelling & Grammar command.
3. The Spelling and Grammar dialog box will open. For each error in your
document, Word will try to offer one or more suggestions. We can select a
suggestion and click Change to correct the error.
Result:
Original Paragraph with error:
Machine learning is closely related to computational sttistics, which focuses on making
predictions using computers. The study of mathmatical optimization delivers methods, theory
and application domains to the field of machine learning. Data mining is a field of study within
machine learning, and focuses on exploratry data analysis through unsuprvised learning. In
its application across business problems, machine learning is also referred to as predictve
analytics.
Corrected Paragraph:
Machine learning is closely related to computational statistics, which focuses on making
predictions using computers. The study of mathematical optimization delivers methods,
theory and application domains to the field of machine learning. Data mining is a field of study
within machine learning, and focuses on exploratory data analysis through unsupervised
learning In its application across business problems, machine learning is also referred to as
predictive analytics.
Practical 4.: Find and Replace.
Date:
Aim: To replace word using find and replace tool.
Procedure:
To find text:
1. From the Home tab, click the Find command. The navigation pane will
appear on the left side of the screen.
2. Type the text we want to find in the field at the top of the navigation
pane.
3. If the text is found in the document, it will be highlighted in yellow, and
a preview will appear in the navigation pane.
4. If the text appears more than once, we can click the arrows on the
navigation pane to step through the results. We can also click the result
previews on the navigation pane to jump to the location of a result in
your document.
5. When we close the navigation pane, the highlighting will disappear.
To replace text:From the Home tab, click the Replace command. The Find and Replace
dialog box will appear.
1. Type the text we want to find in the Find what field.
2. Type the text we want to replace it with in the Replace with field.
3. Click Find Next and then Replace to replace text. We can also click
Replace All to replace all instances within the document.
Result:
Paragraph with word you in Bold
On the Insert tab, the galleries include items that are designed to
coordinate with the overall look of your document. You can use these
galleries to insert tables, headers, footers, lists, cover pages, and other
document building blocks. When you create pictures, charts, or
diagrams, they also coordinate with your current document look. You
can easily change the formatting of selected text in the document text by
choosing a look for the selected text from the Quick Styles gallery on
the Home tab. You can also format text directly by using the other
controls on the Home tab.
Replaced word you to we in bold
On the Insert tab, the galleries include items that are designed to
coordinate with the overall look of your document. We can use these
galleries to insert tables, headers, footers, lists, cover pages, and other
document building blocks. When we create pictures, charts, or diagrams,
they also coordinate with your current document look. We can easily
change the formatting of selected text in the document text by choosing
a look for the selected text from the Quick Styles gallery on the Home
tab. We can also format text directly by using the other controls on the
Home tab.
Practical.: 5 Managing Headers And Footers.
Date:
Aim :- To create headers and footers for a document.
Procedure :-
▪ Click Insert tab.
▪ In the Header and Footer group click Header
▪ In the drop down menu select Header from
various Built-in header options.
▪ In the Header and Footer group click Footer
▪ In the drop down menu select footer from various
▪ Built-in header options.
Result :-
Header
Footer
Practical: 6 Creating various Charts.
Date:
Aim :- To create charts in spreadsheet .
Procedure :-
▪ Select the cells you want to chart, including the column titles and
row labels ▪ Click the Insert tab.
▪ In the Charts group, select the desired chart category.
Result :-
Column
Percentage
100
90
80
70
60
Subjects Percentage
50
Percentage
40 Hindi 80
30 English 75
20
Maths 90
10
0 Science 85
Hindi English Maths Science Computer Computer 95
Line
Percentage
100
90
80
70
60
50
Percentage
40
30
20
10
0
Hindi English Maths Science Computer
Pie
Percentage
Hindi
English
Maths
Science
Computer
Practical: 7 Paragraph Alignment
Date:
Aim :- To demonstrate Left, Right, and Center alignment of the
paragraphs.
Procedure :-
Left-Aligned Text
▪ Click anywhere on the paragraph you want to
align and click the Align Text Left button
available on the Home tab or simply press the Ctrl
+ L keys.
Center Aligned Text
▪ Click anywhere on the paragraph you want to
align and click the Center button available on the
Home tab or simply press the Ctrl + E keys.
Right-Aligned Text
▪ Click anywhere on the paragraph you want to
align and click the Align Text Right button
available on the Home tab or simply press the Ctrl
+ R keys.
Result:
Left-Aligned Text
Center Aligned Text
Right Aligned Text:
Practical.:8.Performing calculations using different functions.
Date:
Aim :- To calculate total, percentage, average, maximum, and minimum
of the five subjects marks for five students record.
Procedure :-
▪ Enter data in sheet for five subjects.
▪ Select five subjects marks and click on Auto Sum.
▪ In cell next to the total, click and write formula for
percentage (==G6*100/500)
▪ In cell next to the percentage type the following formula
(=G6/5).
▪ In cell J6 type this
(=MAX(B6:F6)) formula.
▪ In cell K6 type this
(=MIN(B6:F6)) formula.
Result:
Name Hindi English Math Science Computer Total Percentage average Maximum Minimum
Adam 90 55 64 61 73 343 68.6 68.6 90 55
Tom 80 60 68 63 77 348 69.6 69.6 80 60
Nick 85 65 72 65 81 368 73.6 73.6 85 65
George 95 70 76 67 85 393 78.6 78.6 95 67
William 70 75 80 69 89 383 76.6 76.6 89 69
Stephen 75 80 84 71 93 403 80.6 80.6 93 71
Practical.: 9. Calculating simple interest.
Date:
Aim :- Calculate simple interest using spreadsheet .
Procedure :-
▪ Enter Principal amount , rate , and time in sheet.
▪ Create a row for Simple Interest.
▪ Click on cell next to SI and write formula P*R*T/100
(==D16*D17*D18/1000)
Result:
Principal 5000
Rate 8
Time 3
SI 1200
Practical: 10. Creating Presentation.
Date:
Aim :- To create a simple presentation in PowerPoint and apply slide
transition and animation effects.
Procedure :-
• Click the File tab. This takes you to Backstage view.
• Select New.
• Select Blank presentation under Available Templates and Themes. It will be
highlighted by default.
• Click Create. A new blank presentation appears in the PowerPoint window.
• Create your own presentation .
❖ Transitions
• Select the slide you want to modify.
• Click the Transitions tab.
• Locate the Transition to This Slide group. By default, None is applied to each
slide.
• Click the More drop-down arrow to display all of the transitions.
• Click a transition to apply it to the selected slide. This will automatically
preview the transition as well.
❖ Animations
• Go to the Animation ribbon and click on the Animation Pane to display the
animation sidebar.
• Select one of the objects in the slide and click on the Add Animation menu
• . Choose from one of the Animation options
