COMPUTER PRACTICE LABORATORY – I
Exercise No: 1
Title : Document creation, Text manipulation with Scientific Notations
1. Perform the following in MS-Word
i. Create a new word document and type the following text:
A ROBOT IN THE HOUSE
Corection. You are in error. You are misinforming your father. Correction. The work has not been done. Your computer has not been used. ERROR, ERROR”. The robot’s voice was metallic.
TARUN: You are so lucccky Aditi! Manku can do so many things. It can clean the house. It can answer the telephone, call the doctor and it can even open the door.
ADITI: Wait! There are so many things it can’t do. It can’t laugh. It can’t do MY HOMEWORK FOR ME. It can’t even help me decide what should I wear for the party.
ii. Save the document as DOCUMENT.DOC
iii. Insert the following text before the conversation between Aditi and Tarun
“Oh! Stop interrupting, Manku”. Aditi said angrily. “You’re are not supposed to participate in every conversation”
iv. Make the story heading bold, italic and 14 pts.
v. Change the font style of entire story to MS-Comic Sans
vi. Select the heading of the document, cut and paste it at the end of the document
vii. Undo the previous action
viii. Select the first two lines of the paragraph and convert it to uppercase ix. Change all the uppercase letters to lowercase and vice-versa
x. Change the font style of the last paragraph 12 pts bold italic xi. Copy this format to the first paragraph using format painter
xii. Highlight the second paragraph (Hint: use highlighter or formatting toolbar)
xiii. Change the font size of the entire text to 14 pts
xiv. Make a copy of this document with a different name (MYBOOK.DOC)
xv. Select the second paragraph of DOCUMENT.DOC and delete it xvi. Undo the above action and see the effect
xvii. Redo the above action and see the effect
xviii. Delete the entire document(DOCUMENT.DOC)
xix. Open the document MYBOOK.DOC
xx. Show all the nonprinting characters in this document.
2. Open document MYBOOK.DOC and perform the following task.
i. Note down the default margins of MYBOOK.DOC
ii. Format the first paragraph with the following measurements: Alignment:justified
Indentation:Left:0.4”, Right:0.4” Special: First line by 0.5”
Line spacing: 1.5 lines
iii. In the end of MYBOOK.DOC type:
MANKU IS A ROBOT NOT A HUMAN BEING.
Make 12 copies of the statement written above and apply all the text attributes
iv. Using different tab stops type the following data in the next page of
1292, Jawahar Colony
19/AZ, Dr.Mukherjee Nagar
v. Give a border to the above written text
vi. Search for the word ROBOT and replace it with ‘ROBOT machine’
vii. Write the following text in the next page of the same document (MYBOOK.DOC)
viii. Insert a page break before the conversation between Tarun and Aditi
ix. Open a new document and insert the table with the following data:
First Name Last Name Phone Address
x. Save and close the document with address.doc
xi. Again open the document MYBOOK.DOC and go to the end of the document in one step
xii. Print preview the page containing the drawing features and use the zoom feature to view this in different percentages.
xiii. Print only this page of your document
xiv. Use the auto correct feature of work to add short forms for: I. AP Apex Polymers
II. V & A Vicky & Associates
III. BPL British Petroleum Limited
IV. PACE PACE Academy of Computer Education
V. IP Informatics Practices
xv. Provide headers and footers in MYBOOK.DOC (headers should be different for first page, even and odd pages). For first page give header “A ROBOT IN THE HOUSE”. For even page give header “MY DOCUMENT” and right align it, for odd pages give header “ODD PAGE” page and left align it. Also provide page numbers as footer(centrally align)
xvi. Type in the following contents in the same document MYBOOK.DOC
A word processor (such as MS Word) is a computer program that enables you to create, edit, print and save documents for future retrieval and revision.
In case of typewriter, input and output are inseparable. It means, whenever a key is depressed i.e., input is fed to machine, a character is printed on the sheet i.e, an output is generated. Thus, one is denied the facility to shape the output separately. Even in the case of electronic typewriters with memory, the storage capacity for text an facilities for its manipulation are extremely limited. Facility for storing the input to some external medium before producing the output provided an ideal solution to this problem.
Convert the above text in two column text.
xvii. Spell check your document an correct all the grammatical as well as spelling mistakes
xviii. Close your document
· Include the Formula Editor
· Edit the above formulas
· Save the document
· Close the documents
Exercise No: 2
Title : Table creation, Table formatting and Conversion
i. Open a new document and insert a table with the following data: First Name Last Name Phone Address
Sangeeta Malik 5236987 32/8,Dr.Mukherjee Nagar Preeti Ahuja 1457896 A-E/269,Shalimar Bagh Meenu Kataria 3205623 B-P/81,B.P.Colony Mandeep Kaur 4579681 25/K9,Outram Lines
Teena Gulati 1257936 SU-23,Dr.Mukherjee Nagar ii. Save the document with address.doc
iii. Select the first Row and Bold the Text.
iv. Align the text in the first row to “Center” and align the text in the remaining rows to “Left”.
v. Insert a New Column to the beginning of the table with the following data. S.No
vi. Add a New Row to the End of the Table. vii. Insert a New Row between 3 and 4
viii. Insert a New Column between 4th and 5th Column. ix. Change the size of the second column’s width.
x. Sort the data according to alphabetical order of “First Name”. xi. Delete the third row and third Column from the table.
xii. Create a new row at the top of your table, merge the cells, and add a title to the table.
xiii. Convert the given text into a table. Color, Style, Item
Blue, A980, Van Red, X023, Car Green, YL724, Truck Name, Age, Gender Madhumitha, 23, F Venkatesh, 31, M Veena, 29, F
xiv. Split the above table into two tables
xv. Apply Borders, Shading and Color to the table.
xvi. Spell check your document and correct all the grammatical as well as spelling mistakes
xvii. Save the above document as table.doc. xviii. Close your document.
EX NO : 3
Title : Advertisement
Create the above advertisement in word.
1.Open a new word document.
2.Type the heading and select the font as Times New Roman, font style as Title color and the font size as appropriate.
3.Insert the appropriate picture.
4.Select any one WordArt Style and insert in the document.
5.Type the given article and make it into two columns.
6.Insert the given shapes.
7.Apply border to the entire page.
8.Insert header and footer and add the necessary details.
9.Save the document as advertisement.doc.
EX No: 4
Title : Mail Merge
i) Open a new document and type the following letter.
Sep 15, 2008,
Sri Ranga Apartments,
No: 120, II Avenue,
T. Nagar. Chennai-17.
With the current slow down in hiring within the high- tech field, you must be flooded with resumes from out-placed software engineers such as myself. Please take a moment to consider my qualifications. I believe in particular is highly marketable in this tight market:
I worked on the team that pioneered the technology that put the PalmPilot on the map.
In today’s increasingly mobile society, this technology has places to go, and I have ideas that could take us to the next step in office independence.
Please call me with prospective job opportunities. I am interested in a project management position in the $95K range.
i. Save the document as “Letter.doc.”
ii. Send the document to 10 recipients using Mail merge. (Use 10 different addresses)
iii. Close the document.
Exercise No: 5
Title : Drawing Flowcharts
Draw flowcharts for the following:
a. To find largest of three numbers A, B and C. b. To find the sum of first 50 natural numbers. c. To generate prime numbers up to N.
d. To generate the Fibonacci series of N numbers.
e. To compute factorial N (N!) where N! = 1*2*3*....*N
f. To find whether the given number is an Armstrong number or not. g. To arrange the given data in ascending order using function.
h. To read a number N and print it’s all divisors.
Exercise No: 6
Title : CHARTS – Line, XY, Bar and Pie
To analyze the marks of I year IT students
i) Enter the above data in a worksheet and save the workbook as student.xls ii) Calculate total and average for each student.
iii) Save the workbook again.
iv) Draw a pie chart to denote the names Vs total marks. v) Try out various charts.