COMPUTER PRACTICE LABORATORY-I MANUAL
COMPUTER PRACTICE LABORATORY – I
LIST OF EXPREMENTS
a) Word Processing
1. Document Creation, Text manipulation with Scientific notations.
2. Table Creation, Table Formatting and Conversion.
3. Mail Merge and Letter Preparation.
4. Drawing - Flow Chart
b) Spread Sheet
5. Chart - Line, XY, Bar and Pie.
6. Formula - Formula editor.
7. Spread Sheet - inclusion of Object, Picture and graphics,
Protecting the document and sheet.
8. Sorting and Import / Export Features.
Simple C Programming
9. Data types, Expression Evaluation, Condition Statements.
10. Arrays
11. Structures and Unions
12. Functions
Software
- OS – Windows / UNIX Clone
- Application Package – Office suite
- Compiler – C
CONTENTS
S.No / Date /Topics
/Page No
/Marks Awarded
/Signature
Word Processing1 / Document Creation in MS word
2 / Working with Tables in MS word
3 / Mail Merge and Letter Preparation in MS word
4 / Drawing – Flow Chart in MS word
Microsoft Word Short cut keys
Spread Sheet
1 / Spread Sheet – Chart- Line, XY, Bar and Pie
2 / Formula using in excel spread sheet
3 / Inclusion of object, Picture in excel spread sheet & Protect the spread sheet
4 / Sorting and Import Features in excel sheet
Microsoft Excel Shortcut keys
C Programs
1 / Find the Size of datas
2 / Area and Circumference of the Circle
3 / Convert Binary numberintoDecimal number
4 / Find the Factorial of the given number
5 / Find the largest of the three numbers
6 / Find the sum and reverse of the given number
7 / Ascending and Descending order of the given numbers
8 / Matrix multiplication
9 / Menu Driven program
10 / Student record using pointers and structure
11 / Employee Details using Union
12 / Addition of two numbers using Function
Performance / 25
Record / 15
Viva voce / 10
Total / 50
Word Processing
Ex. No. 1DOCUMENT CREATION
Date :
AIM:
Create a document and Manipulate Text with Scientific notations.
PROCEDURE:
I. Open a new documentusing File -> New option and type the text.
II. Bold, Italic, Underline, Spell check
1. Select the word.
2. Press CTRL+B or button on the formatting toolbar.
3. Press CTRL+I or button on the formatting toolbar.
4. Press CTRL+U or button on the formatting toolbar.
5. Right click on the word, Click Spelling and Grammar on tools or
button on the standard tool bar.
III. Saving the document
1. Press CTRL+S or button on the standard tool bar or
2. Select the Save option from the File menu. It shows the Save As
dialog box. Choose a suitable file name in File name text box. Thenclick save button on Save As dialog box.
IV. Alignment
1. Select the text for alignment.
2. Left alignment: Press CTRL+L or button on the formatting toolbar.
3. Right alignment: Press CTRL+R or button on the formatting toolbar.
4. Center alignment: Press CTRL+E or button on the formatting toolbar.
5. Justification: Press CTRL+J or button on the formatting toolbar.
V. Bullets and Numbering
1. Select the text.
2. Click Bullets button on the formatting tool bar or choose Bullets and Numbering option from the Format menu. The following dialog box appears.
3. Choose required Bullet from the Bullet tab for Bullets.
4. Choose Numbering button on the formatting tool bar or choose required number series from the Numbered tab in the Bullets and Numbering dialog box.
VI. Line Spacing
1. Select the paragraphs of the document or choose Select All option from the Edit menu or by pressing CTRL + A.
2. Choose paragraph option from the Format menu. A paragraph dialog box appears.
3. Select the line spacing that is required then click ok.
VII. Font Type and Size
1. Select the required text.
2. Choose Font option from the Format menu. The Font dialog box appear as shown below.
3. Choose the required font type from the Font drop down list box and therequired size from the Size list box on the Font Dialog box. Then click OK.
VIII. Inserting Symbols
1. Type the text, then put the cursor where the symbol is to be inserted.
2. Choose Symbols option from the Insert menu.
3. It shows the Symbol dialog box. Then choose the appropriate Font type.
4. Then choose the required symbol from the Symbols dialog box. Thenclick OK.
IX. Adding Animation to the text
1. Type and select the required text.
2. Choose Format -> Font option.
3. Font dialog box is displayed, choose Text Effects tab.
4. Choose the required animation and click OK.
X. Highlighting the Words in a Document
1. Select the Text Highlight Color option from Font tool Bar.
2. Select the word/ Text which you want to change the color.
OUTPUT
Characteristics of computers
- Speed
Computers process data at extremely fast rate, at millions of instructions per second. A computer can perform a huge task that a normal human being may take days or even years to complete. The speed of a computer is calculated in MHz (MegaHertz)ie. One Million instructions per second. At present, a powerful computer can perform Billions of instructions per second.
- 2. Accuracy
Computers are very accurate. The level of accuracy depends on the instructions and type of machine being used. Faulty instructions for data processing lead to faulty results. This is calledGIGO(Garbage In Garbage Out).Computer’s physical circuits rarely make errors, if the data and instruction are correctly fed. Most of the errors occurring in computers are either hardware errors or human errors.
Scientific Notation
- C2H6 + 3.5 O2 2 CO2 + 3 H2O
- (X + Y)2= X2 + Y2 + 2XY
Performance / 25
Record / 15
Viva voce / 10
Total / 50
Result:
Thus the document has been created as per the format given.
Ex. No. 2TABLE CREATION AND MANIPULATION
Date :
AIM:
To Create the Table Creations, Table formatting and Table Conversion using Ms – Word.
PROCEDURE:
I. Table Insertion
1. Choose Table -> Insert ->Table option.
2. It displays Insert Table dialog box.
3. Choose the required number of rows and columns and then click OK.
II. Split and merge cells
1. Select the cell to be splitted.
2. Click Table menu from the Menu bar.
3. Select Split cell option from the Table menu, the split cells dialog box appears.
4. Enter the choice to split cells and click OK.
5. Select the cells in the table for merging.
6. Select the Merge cell option from the Table menu or click on the Merge cells button in the Tables and Borders toolbar.
III. Sorting the table contents
1. Select the table to be sorted and choose Sort option from the Table menu.
2. The sort dialog box is displayed.
3. Choose the required column for sorting in the Sort list box and click OK.
IV. Splitting the table
1. Select the row from which the table is to be divided.
2. Choose Split table option in the Table menu.
V. Calculations using formula
1. Insert the table & type the required information.
2. Place the cursor in the cell at which calculation result is to be displayed. For example, finding the maximum in a column).
3. Choose Formula option from the Table menu, Formula dialog box is displayed.
VI. Auto formatting the table
1. Select the table.
2. Choose Table AutoFormat option in the Table menu which shows the Table Autoformat dialog box.
3. Choose the required format from the Formats list box and click OK.
VII. Converting the table to text
1. Select the table.
2. Choose the Convert - > Table to Text options from the Table menu.
3. Now it shows the Convert table to text dialog box.
4. Choose the separator of the text and click OK.
VIII. Converting the text to table
1. Select the text to be converted to table.
2. Choose the Convert -> Text to Table option from the Table menu which shows the convert text to table dialog box.
3. Choose the table size and separator text option and click OK.
OUTPUT
(I) Table Insertation
(II) Split Cell and Merge Cell
(III) Sorting the Table Content
SLNO / NAME / MARK1 / MARK2 / MARK3 / TOTAL08CS05 / Arunkumar / 58 / 89 / 78 / 225
08CS26 / Prasath / 45 / 90 / 75 / 210
08CS43 / Sivakumar / 50 / 95 / 96 / 241
08CS58 / Abdul / 52 / 87 / 98 / 237
(IV) Split the Table
(V) Calculation Using Formula
SLNO / NAME / MARK1 / MARK2 / MARK3 / TOTAL08CS05 / Arunkumar / 58 / 89 / 78 / 225
08CS26 / Prasath / 45 / 90 / 75 / 210
08CS43 / Sivakumar / 50 / 95 / 96 / 241
08CS58 / Abdul / 52 / 87 / 98 / 237
(VI) Auto formatting the Table
SLNO / NAME / MARK1 / MARK2 / MARK3 / TOTAL08CS05 / Arunkumar / 58 / 89 / 78 / 225
08CS26 / Prasath / 45 / 90 / 75 / 210
08CS43 / Sivakumar / 50 / 95 / 96 / 241
08CS58 / Abdul / 52 / 87 / 98 / 237
(VII) Convert the Table to Text
SLNO, NAME, MARK1, MARK2, MARK3, TOTAL
08CS05, Arunkumar, 58, 89, 78, 225
08CS26, Prasath, 45, 90, 75, 210
08CS43, Sivakumar, 50, 95, 96, 241
08CS58, Abdul, 52, 87, 98, 237
(VIII) Convert the Text to Table
SLNO / NAME / MARK1 / MARK2 / MARK3 / TOTAL08CS05 / Arunkumar / 58 / 89 / 78 / 225
08CS26 / Prasath / 45 / 90 / 75 / 210
08CS43 / Sivakumar / 50 / 95 / 96 / 241
08CS58 / Abdul / 52 / 87 / 98 / 237
Performance / 25
Record / 15
Viva voce / 10
Total / 50
Result:
Thus the table has been created, formatted and converted.
Ex.No. 3MAIL MERGE AND LETTER PREPARATION
Date :
AIM:
To do mail merge and prepare letters using MS-Word.
PROCEDURE:
I. Mail Merge
A. Creating the main document
1. on the menu bar, click on Tools-> Letters & Mailings-> Mail Merge...
2. A task pane will appear on the right of the word document.
3. Under Select document type, choose Letters
4. Click on Next: Starting document at the bottom of the task pane
B. Selecting the starting document
1. Under Select starting document, select Use the current document will allow you to start from the current document shown on the screen.
2. Click on Next: Select recipients at the bottom of the task pane
C. Selecting recipients
1. Under Select recipients, click Type a new list.
2. Click Create..., the following window will appear.
3. In the New Address List window, type the data you want to Includeunder Enter Address information; for example, title, names, and address information.
4. To make another entry, click New Entry.
5. Repeat steps 3 and 4 until you've added all the entries you want, and then click Close.
6. In the Save Address List window, type a name for the data list in the File name field, and select a folder to save the list.
7. Click Save.
8. Click on Next: Write your letter.
D. Formatting letter
1. Type the text that you want to appear in every form letter.
2. Insert merge fields where you want to merge names, addresses, andOther data from the data source (i.e. recipient list) by clicking anywhere you want in the main document to insert the field.
3. Then click on More Items and insert individual field.
4. click Next: Preview your letters.
E . Preview letters
1. To preview the items in order, click the arrows under the Preview Your letters heading.
2. To locate a specific item, click Find a recipient..., and then enter the criteria in the Find field.
3. To change the list of recipients, click Edit recipient list..., and make Your changes in the Mail Merge Recipients window.
4. Click on Next: Complete the Merge at the bottom of the task pane.
F. Complete the merge
1. Click Edit individual letters
2. In the Merge to New Document window, select the records you want To merge.
3. Click OK.
II. Printing Labels
1. Choose Tools->Envelopes and Labels option.
2. It displays Envelopes and Labels dialog box.
3. Type the Label Address in the Address box.
4. Click on Full page of same label option.
5. Click on New document.
III. Letter Wizard
1. Choose Tools->Letter Wizard.
2. It displays Letter Wizard Dialog box.
3. Choose the appropriate page design and Letter style and click OK.
OUTPUT:
(I)Mail Merge
Mail merged document 1 (Main document merged with the data source)
From:
The Manager,
Madhu Systems,
No. 21 – 30, Third Floor,
MirindaTowers,
Adyar,
Chennai – 600 020.
To:
S. Ajith,
No 25, Second Cross Street,
Radha Nagar, Anna Nagar,
Chennai – 600 040
Dear Sir / Madam,
Sub: Interview call letter, requested regarding.
You are requested to attend the interview, for the post of Project Trainee, in our concern on the 21st of may at 10.00 A.M. Please bring all your original certificates for the interview along with 2 copies of your updated resume.
Thanking You,
Your sincerely,
(ForMadhu Systems)
Mail merged document 2 (Main document merged with the data source)
From:
The Manager,
Madhu Systems,
No. 21 – 30, Third Floor,
MirindaTowers,
Adyar,
Chennai – 600 020.
To:
A. Vijay,
No 32 / A, Third Main Road,
Krishna Nagar, Egmore,
Chennai – 600 08
Dear Sir / Madam,
Sub: Interview call letter, requested regarding.
You are requested to attend the interview, for the post of Project Trainee, in our concern on the 21st of may at 10.00 A.M. Please bring all your original certificates for the interview along with 2 copies of your updated resume.
Thanking You,
Your sincerely,
(For Madhu Systems)
(II) Printing Labels
Performance / 25Record / 15
Viva voce / 10
Total / 50
Result:
Thus the letter has been created for multiple recipients using mail merge.
Ex.No. 4DRAW - FLOWCHART
Date :
AIM:
Draw a flowchart for addition of two numbers in MS word.
PROCEDURE:
1. Choose Flowchart option in the Autoshapes menu of the Drawing toolbar.
2. Choose the appropriate flowchart symbol. Then drag the Symbol in the document.
3. Type the text in the symbol by Right-clickthen choose Add Text.
4. Using the Arrow button Line style button Arrow style in the Drawing toolbar. Draw the lines connecting to the different flowchart symbols.
5. Select all the flowchart symbols and lines in the document using the select object button, then Right-clickto choose Grouping->Group.
Sample Output :
(I) Addition of Two Numbers
(II) Software Development Life Cycle (SDLC)
Performance / 25Record / 15
Viva voce / 10
Total / 50
Result:
Thus the flowchart has been drawn using Auto shape tools.
Microsoft Word shortcut keys
Below is a listing of all the major shortcut keys in Microsoft Word. See our main shortcut page if you're looking for other shortcut keys used in other programs.
Shortcut Keys / DescriptionCtrl + A / Select all contents of the page.
Ctrl + B / Bold highlighted selection.
Ctrl + C / Copy selected text.
Ctrl + E / Aligns the line or selected text to the center of the screen.
Ctrl + F / Open find box.
Ctrl + I / Italic highlighted selection.
Ctrl + J / Aligns the selected text or line to justify the screen.
Ctrl + K / Insert link.
Ctrl + L / Aligns the line or selected text to the left of the screen.
Ctrl + M / Indent the paragraph.
Ctrl + P / Open the print window.
Ctrl + R / Aligns the line or selected text to the right of the screen.
Ctrl + T / Create a hanging indent.
Ctrl + U / Underline highlighted selection.
Ctrl + V / Paste.
Ctrl + X / Cut selected text.
Ctrl + Y / Redo the last action performed.
Ctrl + Z / Undo last action.
Ctrl + Shift + F / Change the font.
Ctrl + Shift + > / Increase selected font +1pts up to 12pt and then increases font +2pts.
Ctrl + ] / Increase selected font +1pts.
Ctrl + Shift + < / Decrease selected font -1pts if 12pt or lower, if above 12 decreases font by +2pt.
Ctrl + [ / Decrease selected font -1pts.
Ctrl + Shift + * / View or hide non printing characters.
Ctrl + <left arrow> / Moves one word to the left.
Ctrl + <right arrow> / Moves one word to the right.
Ctrl + <up arrow> / Moves to the beginning of the line or paragraph.
Ctrl + <down arrow> / Moves to the end of the paragraph.
Ctrl + Del / Deletes word to right of cursor.
Ctrl + Backspace / Deletes word to left of cursor.
Ctrl + End / Moves the cursor to the end of the document.
Ctrl + Home / Moves the cursor to the beginning of the document.
Ctrl + Spacebar / Reset highlighted text to the default font.
Ctrl + 1 / Single-space lines.
Ctrl + 2 / Double-space lines.
Ctrl + 5 / 1.5-line spacing.
Ctrl + Alt + 1 / Changes text to heading 1.
Ctrl + Alt + 2 / Changes text to heading 2.
Ctrl + Alt + 3 / Changes text to heading 3.
Ctrl + F1 / Open the Task Pane.
F1 / Open Help.
Alt + Ctrl + F2 / Open new document.
Ctrl + F2 / Display the print preview.
Shift + F3 / Change the text in Microsoft Word from upper to lower case or a capital letter at the beginning of every word.
Shift + Insert / Paste.
F4 / Repeat the last action performed (Word 2000+)
F5 / Open the find, replace, and go to window in Microsoft Word.
Ctrl + Shift + F6 / Opens to another open Microsoft Word document.
F7 / Spell and grammar check selected text and/or document.
Shift + F7 / Runs a Thesaurus check on the word highlighted.
F12 / Save as.
Shift + F12 / Save.
Ctrl + Shift + F12 / Prints the document.
Alt + Shift + D / Insert the current date.
Alt + Shift + T / Insert the current time.
Ctrl + Shift + = / For Supercript
Ctrl + = / For Subscript
In addition to the above shortcut keys users can also use their mouse as a method of quickly do something commonly performed. Below some are examples of mouse shortcuts.
Mouse shortcuts / DescriptionClick, hold, and drag / Selects text from where you click and hold to the point you drag and let go.
Double-click / If double-click a word, selects the complete word.
Double-click / Double-clicking on the left, center, or right of a blank line will make the alignment of the text left, center, or right aligned.
Double-click / Double-clicking anywhere after text on a line will set a tab stop.
Triple-click / Selects the line or paragraph of the text the mouse triple-clicked.
Ctrl + Mouse wheel / Zooms in and out of document.
Spread Sheet
Ex.No: 5 Spread Sheet - Chart- Line, XY, Bar and Pie
Date:
AIM:
To draw Line, XY, Bar and Pie charts using MS- Excel.
PROCEDURE:
I. Line Chart
1. Enter the data in the spreadsheet.
2. Choose Chart option from the Insert menu or choose the chart Wizard button from the standard tool bar.
3. It shows the chart wizard step 1 0f 4 – chart type dialog box.
4. Choose the Line chart from the chart type list box. Then click Next.
5. It shows the chart wizard step 2 0f 4 – chart type dialog box.
6. Click on data range to select the required data.
7. Click on series tab to enter the X- axis values and click Next.