ALPINE PUBLIC SCHOOL
(JUNCTION ROAD, KHURJA)
UTTAR PRADESH
INFORMATION
TECHNOLOGY (402)
Class-IX
PRACTICAL RECORD
2019-20
CERTIFICATE
This is to certify that this practical work is submitted by
____________________________________________________________________________
(R.No. __________________) to the Computer Department of
ALPINE PUBLIC SCHOOL, KHURJA, UTTARP RADESH , carried
out by her/him towards partial completion of Practical Exam for
class IX during academic year 2019-20.
Internal Examiner PRINCIPAL
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 docu
ment
Procedure :-
Click Insert tab.
In the Header and Footer group click Header
In the drop down menu select Header from variou
s 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:
1. 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
50
Percentage Subjects Percentage
40
30 Hindi 80
20 English 75
10 Maths 90
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
