Full Project File of PC

INDEX
S.NO. PARTICULARS REMARKS SIGN.

1.

MS-WORD

Open a document. Type the text and
perform the tasks i.e., cut, copy, paste,
undo, redo, drag & drop, find & replace,
page breaks etc.

2. Type the text as shown and perform the
tasks i.e., File new, open, save, find,
replace etc.

3. Character Formatting, Paragraph
Formatting.

4. Bullets and Numbering.

5. Create the following Table.

6 Create Table as shown.

7. Write a letter to send invitation to your
friend inviting on your birthday. (Mail
Merge)

8. Create Lables for your friends address.

9. Prepare a letter as shown below.
(Formatting and Frames)

10. Create a following figure. (Shapes)

11. Type the text as shown below and insert
picture and place caption.

1.
MS-EXEL

Create the following worksheet and save
the worksheet as wages.xls.

2. Create the following worksheet.
3. Create a worksheet as follows.
4. Create the worksheet as follows.
5. Create Macro to make selected cell Bold
Italic, Outside Bordered and Centre.

6. Create Bar chart.
7. Create a table with column heading and
using Form perform data entry of
records. (Sorting)

8. Create Pivot table using Data of exercise
7.

9. Create a table with column heading and
using Form perform data entry of
records. (Filter)

10. Import of data.
11. Create a Table using table feature.
12. Using Goal seek feature, find out the
interest rate it must be to ear interest
500.

1.
MS-POWERPOINT
Write an animated presentation about
any Three courses available in a college.

2. Write an animated presentation about
Communication of a bad news.

Q1. Open a document. Type the following text and perform the tasks as instructed below:-
Working with word processor
As already mentioned, a word processor is a package that processes textual matter and creates
organized and flawless document. In addition to it a word processor not only remote all the
limitations of typewriter but also offers various useful features that can not be even dreamt of
with typewriter
Also if same textual matter is to be reproduced with minor changes, retyping the only option in
typewriters.
The word processing (and word processor) originated way back in 1964 when special typewriters
Magnetic tapes Selectric typewriters (MIST) were launched by IBM (International Business
Machine).

SOLU:- Type the text as shown above, pressed Enter key after each
Paragraph.
Working with word processor(Enter)
As already mentioned, a word processor is package that process textual matter and creates
limitations of typewriter but also offers useful features that can not be even dreamt of with
typewriter. (Enter)

Also if the same matter is to be reproduced with minor changes, retyping the only option in
typewriters.(Enter)

The word processing (and word processor) originated way back in 1964 when special
typewriters.(Enter)
Machines).

(i) Insert the following text after first paragraph.
The main components of a word processing are listed below:-
Computer
Printer
A word processing software
Solu :- Positioned insertion point after the last character of first paragraph and pressed enter key
and typed the text as shown below.
The main components of a word processing system are listed below:-(Enter)
Computer (Enter)
Printer (Enter)
A word processing software (Enter)
Select the paragraph starting from Computertill processing software and clicked on
bullets icon on toolbar.
Output:-
As already mentioned, a word processor is package that processes textual matter and creates
limitations of typewriter but also offers various useful features that can not be even dreamt of
with typewriter.
The main components of a word processing system are listed below:-
Computer
Printer
Also if same textual matter is to be reproduced with minor changes,retyping the only option in
typewriters.
typewriters.
Machine).

(ii) Save the document as word1.doc
Solu:- Office button->Save->File name:word1->Save

(iii) Move the second paragraph to the end of document, using drag & drop. And undo
the operation.
Solu :- After drag and drop,
Output:-
As already mentioned, a word processor is a package that processes
Textual matter and creates organized and flawless document. In addition to it a word processor
not only remote all the limitations of typewriter but also offers various useful features that can
not be even dreamt of with typewriter.
Also if same textual matter is to be reproduced with minor changes, retyping the only option in
typewriters.
typewriters.
Machines).
Computer
Printer
STEPS :- Select the second paragraph text and after selection hold down the left mouse button
and drag the insertion point at the end of document and release the left mouse button.
To perform undo operation use undo command next to save option.
After undo operation,
(OUTPUT)
organized and flawless document, In addition to it a word processor not only remote all the
limitations of typewriters but also offers various useful features that can not be even dreamt of
with typewriter.
Computer
Printer
Also if same textual matter is to be reproduced with minor changes, retyping the only options in
typewriters.
typewriters.
Machines).
(iv) Move the second paragraph in the end of the document using cut, paste Operation.
Select the second paragraph text and use cut command by right clicking of the mouse
button.
Position insertion point at the end of document and use paste command by right clicking
of the mouse button.
(v) Undo the above action.
Solu :- To perform undo operation use undo command next to the office command
button.
(vi) Now uses redo action.
Solu :- To perform redo operation use redo command next to the undo command
button.
(vii) Go to the End of the document (in one step).
Solu :- To go to the End of the document use Control+End.
(viii) Go to the beginning of the document (in one step).
Solu :- To go to the beginning of the document use Control+Home.
(ix) Insert page break before the third paragraph.
Solu :- Position insertion point after last character of second paragraph and use Insert->Page
break->OK
(x) Search the word computer in your document with options Match case, find whole
words only.
Solu :- Use Hone->Find->Find what: Computer->More->tick whole words only-> go on
clicking find next button.

(xi) Replace the word typewriters with word processor.
Solu :- Use Home->Replace->Find what: typewriters->Replace with: word processor->Replace
all->Close.

(xii) Undo the above action.
Solu :- To perform undo operation use Undo command next to the save command button.
(xiii) Remove all page break from your document to different percentages using zoom
features.
Solu :- Use Home->Replace->Click on find->Special->Manual page break->Replace all-
>Close.

(xiv) Format the above written paragraph using given options as follows:
(a) Alignment: justified
(b) Indentation: left 0.2 right: 0.2
(c) Spacing: before 6pt after: 6pt.
(d) Special: first line by: 0.4
(e) Line spacing 1.5 lines
Solu :- (i) Use Home->Paragraph->Alignment: justified.
(ii) Indentation left: 0.2->indentation right: 0.2
(iii) Spacing: before 6pt->spacing after: 6pt.
(iv) Special: first line 0.4.
(v) Line spacing: 1.5->OK.

(xv) Set the default tab stop to 0.7.
Solu :- Use Home->Paragraph->Tabs->Default tab stops: 0.7.

(xvi) Format the page using.
(a) Left margin: 0.5, right margin: 0.5
(b) Top margin: 1.5, bottom margin: 0.5.
(c) Gutter margin: indentation: left 0.2 right: 0.2.
(d) Header margin: 0.5.
Solu :- (i) Use Page layout->Page setup.
(ii) Left: 0.5->right: 0.5.
(iii) Top: 1.5->bottom: 0.5right: 0.5.
(iv) Gutter left: 0.2->right: 0.2.
(v) Click on layout tab->header: 0.5->OK.

(xvii) Format the each occurrence of group of words Word Processor as bold, italic,
under line and replace formatting options.
Solu:- Use Home->Replace->Find what: Word Processor->Replace with: Word Processor-
>More->Format->Font->bold italic->Under line->Small caps->OK->Replace all->Close.
(xviii) Align the heading to center and make it bold, underline and italicized.
Solu:- Select the heading line->Home->Font->Bold Italic->Underlined->OK->, then click on
centre align icon on paragraph toolbar.
OUTPUT:-

Working with Word Processor
As already mentioned, a word processor is a package that process textual matter and creates
limitations of typewriters but also offers various useful features that cannot be even dreamt of
with typewriters.

2. Type the text as shown below and perform the tasks as directed:-
Computers
COMPUTER is an electronic that process data gives meaningful information.
Computer are being used in almost all the fields today.
EXPERT SYSTEMS
HUMAN THINKING AND ARTIEICAL INTELLIGENCE
Can computer think?
AI at work Today: Natural Language programs and Expert System.
THE IMPACT OF COMPUTER ON PEOPLE
The positive Impact
The potential Dangers
THE IMPACT OF COMPUTER ON ORGANIZATION
The information processing Industry
The Positive impact on Using Organizations
The Potential Dangers on using organizations
(i) Search for the word Computer in the entire document. All the occurrences of the
given word are to be searched irrespective of the case.
Solu :- Use Home->Find->Find what: computer->Select match case->Go on clicking find next
at last close the dialog box.
(ii) In the above question note that word also searches computerization and
computerizations . Now make sure that this time word searches only for the word
computer in the entire document.
Solu :- Use Home->Find->Find what: computer->Select whole words only->Go on clicking
find next. At last close the dialog box.

(iii) Change the entire uppercase letter to lowercase.
Solu :- Use Home->Font->Change case->Lowercase->OK.

(iv) Give a heading to the above written text COMPUTERS IN TODAYS WORLD.
Solu:- Position insertion point before first character of first line and press enter to make Room
and use up arrow key then type COMPUTERS IN TODAYS WORLD.

(v) Centers align the heading text computer which appears in first line.
Solu :- Position insertion point on the heading text then click on center alignment icon on
format toolbar.
(vi) Apply outside border to entire document.
Solu :- Use Page layout->Page Borders->OK.

(vii) Apply outside border to the just heading text.
Solu: - Use->Page Layout->Page Border->Apply to: text->OK.
(viii) Change page setup according to the following specifications.
Top margin: 1.5, bottom margin: 1.5 gutter, left margin: 1.5
Right margin: 1, page width: 7.5, page height: 6.5, orientation: portrait.
Solu :- (i) Page Layout->Page Setup->Top: 1.5->bottom: 1.5.
(ii) Gutter: 1->Left: 1.5->Right: 1.
(iii) Page width: 7.5->Page height: 6.
(iv) Orientation: portrait->OK.

(ix) Give header creations and footer The school of computing. The footer should also
consist of page nos.
Solu:- Use Insert->Header and footer->Type text: creation->Click on switch header/footer icon-
>Type the footer text: The school of computing->Click on page no. Icon no header/footer
toolbar.

(viii) Insert page break before THE IMPACT OF COMPUTERS ON PEOPLE.
Solu :- Place insertion point before THE IMPACT.ON PEOPLE. Then use Insert->Page
break.
(ix) Appropriate commands for giving different header and footer for first page and odd
and even pages.
Solu: Use Insert->header and footer->Select different even and odd->Select different first page-
>OK, then type text for different text for header footer for first page, even page and odd page.
(x) Save and close the document.
Solu :- Use Office button->Save->Filename: type filename->Save.

Character Formatting , Paragraph Formatting
3. Type and format the text as shown below if any spelling or grammar mistake occurs
correct it using spelling and grammar facility.

DELHI
New Delhi, the capital and largest city of India is a fusion of the ancient and modern. The
remains of the Muslim dynasties with its architectural delights, give the majestic ambience of the
bygone era.
On the other side New Delhi, The imperial city built by British, reflects the fast paced present.
The most fascinating of all is the character of Delhi which varies from the 13th century
mausoleum of the Lodi kings to ultra modern glass skyscrapers.
Solu:- (i) Type the text as shown, pressing enter key after each paragraph.
(ii) Select the text DELHI and use Home->Font->Bold->Italic->OK.

(iii) Select the two paragraphs and use Home->Paragraph->indent left: 0.5->OK.

Character Formatting
4. Type text and format the text as shown below:-
C
2
H
5
OH+ PCL
5
= C
2
H
5
CL+POCL
3
+HCL
4H
3
PO
3
=3H
3
PO
4
+PH
3
PCL
3
+CL
2
=PCL
5

Solu:- Type the text then after typing text select the digits (firstly select any digit then hold
down control and go on selecting remaining digits). Use Home->Font->Subscript->OK.

Bullets and Numbering
5. Write text and format as shown below:-
1) Own house
2400 square feet living area
Separate bungalow
Car shed available

2) Car
Maruti omni van
Registration number TN 728195
1994 model

Solu:- (i) While typing sub items within own house you have to press tab key once, similarly
; before typing sub items within car you have to press tab key once.
(ii) Select the whole text and use bullets and numbering->click on list style tab->add-> Apply
formatting to: 1
st
level-> click on number icon, apply formatting to: 2nd level-> click on bullets
icon->OK->OK.

Table
6. Create a following table.
Admission 2005-06
Course OC BC MBC SC/ST TOTAL
Computer science

Commerce
9 18 5 5 37
14 25 6 5 50
Grand Total 87

Solu:- (i) Insert->Table-> insert->no. Of columns: 6, no. Of rows: 4-> press ok button.
(ii) Click on cell and type text for cells except for the last row. Use tab key to navigate.

(iii) To fuse border the last row select first 5 cell from the last row and use merge cells by right
click of the mouse button then type text Grand Total, then click align centre.

(iv) Position insertion point on the last cell of the last row use Layout-> Formula.

Table
7. Create Table as shown

Solu:- Table->Insert table->no. Of columns: 3, no. Of rows: 5->Press OK button.

Car Price

Maruti
Omni van 200000
Maruti 800 242000

Tata
Sumo 390000
Sierra 447000
Mail merge, mailing label
8. Write a letter to send invitation to your friend inviting on your birthday.
Solu:- 1. Use Mailings->Start mail merge->Step by step mail merge wizard. Mail
merge box is open.

Step 1:- SELECT DOCUMENT TYPE
Click next to continue.

Step 2:- SELECT STATING DOCUMENT.
Click next to continue.

Step 3:- SELECT RECIPIENTS.
Click on TYPE A NEW LIST->then choose Create data source.
New Address List box opens. Now, enter the names. Delete field names that
you dont want, by using Customize option.

Click OK when you are finished entering field names and are ready to save the
file
Enter the filename in Save as Dialog box. Click save.

STEP 4:- WRITE YOUR LETTER.
Click on more items->select->insert->OK.

STEP 5:- PREVIEW YOUR LETTERS
Click next.
STEP 6:- COMPLETE THE MERGE.
Click Mailings->Finish & merge->Edit individual documents->All->OK.

TO,

DEAR USHA,

HI, how are you. I am fine here. You are hearty invited on my birthday which is on
31-march. Please, try to come on my birthday.
YOURS LOVINGLY
SWETA NAGDEV
9. Create labels for your friends address.
Solu:- Mailings->Create Labels.

Select document type: Labels->next
Select starting document: use the current document->next.
Select recipients: type a new list: type a new list->create->type recipients list->close.
File name: give file name->save->click on insert merge field on tool bar and place
merge field one by one->click on printer.

FORMATTI NG AND FRAMES

10. Prepare a letter as shown below

To,

The Principal,
ABC College, ABC Nagar,
Raipur (C.G)

Sub:- Leave
Respected sir,

This is to bring to your kind notice that due to reasons mentioned below, I am unable
to attend the college/I could not attend the college.

As such, I request you to kindly grant me leave for
Thanking You

Yours Faithfully
Raipur;
Dated: Signature
Name
Designation

Solu:-
Text add: Principal, press enter->tab->ABC College, ABC Nagar->enter->tab->text
add: Raipur (C.G.)->enter.
Sub:-leave->enter->respected sir->enter->type the text as shown above then->enter
Tab setting->press tab .5->center alignment->then text add yours faithfully->enter-
>tab->add: signature->enter->tab .5 add Raipur->name->enter, Dated->tab -4-
>designation.

Shapes
11. Create Following Figures

W

Solu:- Insert->Shapes->Stars and Banners.
Insert->Shapes->Select the text box->Draw->Type the text: Welcome to MS Word->Bring to
font setting (Center).

Welcome to MS WORD

12. Type the text as shown below and insert picture any picture you have place caption.
organized and flawless documents.

In addition to it a word processor not only remote all the limitations of typewriter but also offers
various useful features that can not be dreamt of typewriter.
Solu:- Use Insert->Clipart->Click on search button->Right click on the image and select-
>Insert.
OUTPUT:-

Question1. Create the following worksheet and save the worksheet as wages.xls.
PACE COMPUTERS (ATC CEDE). Govt. of India
Payroll for Employee (Temporary)
Today date 3-Jul-08
Pay rate 95
Workers name Hired on Days worked Gross wages
Kushagra 3-Mar-07
Pradeep 4-Mar-07
Puneet 5-Mar-07
Rajeev 6-Mar-07

Answer:-

(i) Calculate days work and gross wages.
Formula used in cell to Calculate Days Work:-
C6=B3-B6=488
C7=B3-B7=487
C8=B3-B8=486
C9=B3-B9=485
Formula used in cell to Calculate Gross Wages: -
D6=B4*C6=46360
D7=B4*C7=46265
D8=B4*C8=46170
D9=B4*C9=46075

Question2. Create the following worksheet and save the worksheet as wages.xls.
Name
Basic
(monthly)(RS)
HRA(%of
basic)
DA(Rs)
Total
salary
(1997)
Bonus(Rs)
Total
salary
(1998)
%(increase)
Shiromani 5000 10 450 1200
Somya 9000 15 800 200
Tanya 7000 12 900 1800
Answer:-

(i) Calculate the total salary as sum of basic, HRA, DA, for each employee
for 1997.
Ans. Calculation: -
E2 =SUM (B2:D2) =5950
E3 =SUM (B3:D3) =11150
E4 =SUM (B4:D4) =8740
(ii) Calculate total salary for year 1998 as sum of 1997 and bonus.
Ans. Calculation: -
G2 =SUM (E2:F2) =7150
G3 =SUM (E3:F3) =11350
G4 =SUM (E4:F4) =10540
(iii) Calculate % increase in from 1997 to 1998.
Ans. Calculation: -
H2 =(G2-E2)/100 =12
H3 =(G3-E3)/100 =2
H4 =(G4-E4)/100 =18

Question3. Create a worksheet as follows: -
Pace computer(atc. cedt) govt. Of India
Payroll for employee (permanent)
Empcode Name Doj Salary Bonus Net salary
E001 Meenu 3-Mar-95 5000
E002 Manoj 4-Mar-95 4000
E003 Preeti 5-Mar-06 4800
E004 Sumita 6-Mar-05 7500
Answer :-

(i) Allow bonus 8000 to employee having service> 2 year otherwise
allow bonus 3000.
Calculate bonus: -
E3 = if(year (B1)-year(C3)>2,8000,3000)
E4 = if(year (B1)-year(C4)>2,8000,3000)
E5 = If(year (B1)-year(C5)>2,8000,3000)
E6 = if(year (B1)-year(C6)>2,8000,3000)
(ii) Find net salary as sum of bonus and salary.
Calculate net salary: -
D3+E3=13000
D4+E4=12000
D5+E5=7800
D6+E6=10500

Question4. Create a table with column heading as shown below and using perform data
entry of records.
Zone Department Employee Salary
East Sales Rahul 20000
North Marketing Anju 25000
North Sales Ajay 8000
South Marketing Suresh 50500
South Marketing Mahesh 70500
South Sales Neeraj 8000
West Marketing Mukesh 10500
West Sales Rajesh 40500
Answer:-
(i)Used group and outline feature to sort the data according to zone by department.
Select a column of data in a range of cell.
On the home tab, in the Editing group, click sort & filter, and then click
custom sort.

The sort dialog box is display.

Under column, in the sort by box select the zone and then by box select the
department to sort by a custom list.
Under order, select A to Z
Click OK
(ii) Show and hide details .
Select the Zone column in the cell.
Click on the data tab and click group option.
And then open the group dialog box.
And then choose Rows or column option button.
And then click OK button.
And show the outline area.

Que.5 Create a table with column heading as shown below and assign from performs data
entry of: -
Answer:-
(i) Use filter command to show record having zone west.
Select a range of cells containing data.
On the data tab in the sort & filter group, click filter.

Click the arrow in the column header.

(ii) Used filter command for show record having zone west and salary less than 5000.
To show record having zone west and salary less than 5000.
Click on the Zone filter button and choose the west option and click ok.
After that click on the salary filter button and then choose number filter and then
choose less than option then it opens a dialog box in which write 5000 and then click
Ok.

Question6. Create a table using feature:-
300 3 4 5
1% 45 60 75
2% 90 120 150
3% 135 180 225

Answer:-

Using formula in the table:-
D1=B1*B2*B3=300
E2=B1*D2*E1=45
F2=B1*D2*F1=60
G2=B1*D2*G1=75
E3=B1*D3*E1=90
F3=B1*D3*F1=120
G3=B1*D3*G1=150
E4= B1*D4*E1=135
F4= B1*D4*F1=180
G4= B1*D4*G1=225

Principle 1500
Rate 4%
Time 5
Question7.Create Pivot Table using data of-
South Sales Neraj 8000

Answer:-
Open the data in the worksheet.
Then click on the insert tab and then choose Pivot Table dialog box.

And then give a selected table and range.
And then click ok button to create by pivot table.
And then open the pivot table field list and then choose field to add to report.

It is create by Pivot Table.

Question8.Using seek feature find out the insert rate it must be to earn interest 5000.

Principle 1500
Rate 4%
Time 5
Interest 300

Answer:-

Interest =B1*B2*B3
Using Goal seek feature:-
Click on the data tab, in the data tools group and then choose what if Analysis
option.
And then clock goal seek option.
Option the goal seek dialog box:-

And give interest value in a set cell box, and give the To value interest 500, and then
select by changing cell rate 4%.
And then open the goal seek status:-

And then click ok button.
It is a created.

Question9. Create macro in Excel to make selected cell BOLD, ITALIC, Outside Border
and Center across selected text.
Answer:-
Selected the cell in the worksheet.
Click on the view tab, and click macros option.

And then click record macro.
Open the record macro dialog box:-

In the macro name box, type a name for the macro.
In the description box, type a description of the macro.
To assign the macro to a keyboard shortcut, click keyboard.
In the press new short key box, type the key box, type the key sequence that
you want and then click assign.
Select the cell or text or text and click BOLD, ITALIC, outline border and
center across.
To stop recording your action, click stops recording in the macros groups.
And then click view macro.

In the macro name list, select the name that want to run.
Click run.

Question10.Create a worksheet as follows:-
Roll no. Name English Maths Total Average Division
101 Sandi 70 71
102 Naresh 56 51
103 Gupendra 34 34
Class Average
Answer:-

(i) Find total of two subject for each student.
Total of subject:-
Roll number 101=sum(C2:D2)=141
(ii) Find average of two subject:-
Average of subject:-
Roll number 101=E2/2=70.5
(iii) Find class average of average column.
Average of class:-
=AVERAGE(F2:F4)=52.6
(iv) Find division of student as 1
st
, 2
nd
, 3
rd
assume percentage of division of your
own and maximum marks in each student as 100.
Find the division of student:-
Roll number 101=if(F2>60,First,if(F2>45,Second,if(F2>33,Third)))= First
Roll number 102=if(F3>60,First,if(F3>45,Second,if(F3>33,Third)))= Second
Roll number 103=if(F4>60,First,if(F4>45,Second,if(F4>33,Third)))= Third
(v) Apply condition formatting for division column,first division should be
bold, second division should be in italic and third division should be
underline.
Select the first division column and click conditional formatting option.
And then click highlight cell rule, and choose text that contain.
And then open the text contain dialog box:-

In the format cells that contain the text box write the first or second or third with
select the custom format option.
And then open the format cell dialog box:-

In the format cells dialog box, select font style that you want.
And then open the text that contain dialog box:-

Question11. Create Bar chart with given data.

(i) Provided Heading Production Detail ID.
Create a document in excel document then select.
Click the insert tab than open the insert tab in a chart gallery choose the bar option.
Then insert the chart.
(ii) Provide:- Y axis title , year and X axis title Laces metric ton.
Click the layout tab than open the layout labels gallery and then
choose to axis title then open option.
Click the primary vertical axis title then open option.
Click the vertical title an write year on y axis.
Click the layout tab than open the Layout tab labels gallery and then choose to axis
title then open option.
Click the primary horizontal axis title then open option.
Click the title below axis and write laces matrix tone on x-axis.

ACCESS
Create a table in MS access with database student containing a student table ,fees table and
grade table and creating relationship between the tables.
Sol:- steps
(i) The first step is to create a new database to store the data. Here create a
database student with 3 tables having name:-
a) Student table
b) Fees table
c) Grade table
Creating a new database:-
1) Choose new from the file menu in the access opening screen. A window is displayed
which asks for the name of new database.
2) Type the file name as student.accdb
3) Click the create button to create the database.
4) The database window is displayed on the screen. From the database window screen
double click on the table for creating table in design view.

Creating table:-
1) to create the table click on design view.
2) now type field name in field column & give the datatype.
3) save the student table.

Creating relationship between tables:-
1) Establish relationship between the roll no. field in the table, in the student, fees &
grade table. Do the following:
(i) Pick the student database to display the database window.
(ii) Use the database option on tool bar to display the show table dialog box.
Once displayed then:
a) Pick student & click add.
b) Pick fees & click add.
c) Pick grade & click add.
(iii) Close the add dialog box & drag the table boxes.
(iv) J oin the lines to establish the relationship as follows:
a) Pick the roll no. from student table & drag to roll no. within the fees
table. A line connection is there between the two tables.
b) Pick the roll no in fees table & drag to grade table. A line connection
is there between the two tables.
c) Pick the roll no in grade table & drag to student table. A line
connection is there between the two tables.
2) Click yes to save the relationship.

Q1. Write an animated presentation about any three courses available in college.

VARIOUS COURSES AVAILABLE
B.SC
BBA
BCA
PGDCA
B.COM
MCM

B.COM
ELIGIBILITY 12
TH
PASS
DURATION 3 YRS
FEES 11,000
EXAM PATTERN YEAR WISE

BCA
ELEGIBILITY
12
TH
PASS
DURATION 3 YRS
FEES 31,000
EXAM PATTERN YEARWISE

BBA
ELEGIBILITY 12
TH
PASS
DURATION 3 YRS
FEES 21,000
EXAM PATTERN SEMESTER WISE

STEPS:-
1) CLI CK ON MS-OFFI CE BUTTON.
(ii)CLI CK ON NEW. NEW SLI DE APPEARS.
(iii)SELECT THE SLI DE WI TH DESI RED LAYOUT.

2) Slide with table:
(i)click on insert menu.
(ii)When box appears ,it asks you to enter the no. of rows and columns and click OK
button.

3)For applying a design:
(i) Open the presentation you want to apply a design to. Click on design menu and
apply selected design.

4)For colour scheme:
(i)Click on design tab and click on .
(ii)select the desired colour scheme and apply.
5)For Animation:
(i)Select the slide to you want to animate.
(ii)Choose animation tab and apply the desired animation to the slide.

6)Adding transition:
(i)Select the slide for transition.
(ii)Choose a transition from the slide transition effects drop-down menu.

7)For Slide show:
(i)Click on slide show menu or Click F5.

Q2. Write an animated presentation about communication of a bad news.
Solu:

Full Project File of PC

Uploaded by

Copyright:

Available Formats

Full Project File of PC

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Full Project File of PC

Uploaded by

Copyright:

Available Formats

INDEX

S.NO. PARTICULARS REMARKS SIGN.

You might also like