ibs docs ptu varun
TRANSCRIPT
-
8/2/2019 Ibs Docs PTU Varun
1/63
SOFTWARE LAB X CS-320
1
EXPERIMENT NO:- 1
AIM:-WRITE THE CODING FORMAT/SHEET OF COBOL.
*VARUN KUMAR
*100610391681
-
8/2/2019 Ibs Docs PTU Varun
2/63
SOFTWARE LAB X CS-320
2
EXPERIMENT NO: - 2
AIM:-WAP TO DEMONSTRATE INPUT OUTPUT VERBS.
IOVERBS.COB Mon Mar 12 21:03:39 2012 Page 1
line number source line Microsoft COBOL Version 2.20
1 *VARUN KUMAR
2 *100610391681
3 *WAP TO DEMONSTRATE INPUT OUTPUT VERBS.
4 IDENTIFICATION DIVISION.
5 PROGRAM-ID. DEMONSTRATE-INPUT-OUTPUT-VERBS.
6 AUTHOR.SIMAR.
7 ENVIRONMENT DIVISION.
8 DATA DIVISION.
9 WORKING-STORAGE SECTION.
10 01 A PIC 999 VALUE 101.
11 PROCEDURE DIVISION.
12 M-PARA.
13 DISPLAY "ENTER THE NUMBER".
14 ACCEPT A.
15 DISPLAY "ENTERED NUMBER IS= ", A.
16 STOP RUN.
-
8/2/2019 Ibs Docs PTU Varun
3/63
SOFTWARE LAB X CS-320
3
No errors or warnings
Data area size = 280
Code area size = 58
OUTPUT:-
-
8/2/2019 Ibs Docs PTU Varun
4/63
SOFTWARE LAB X CS-320
4
EXPERIMENT NO:- 3
AIM:-WAP TO DEMONSTRATE PICTURE CLAUSE.
PIC.COB Mon Mar 12 17:40:53 2012 Page 1
line number source line Microsoft COBOL Version 2.20
1 *VARUN KUMAR
2 *100610391681
3 IDENTIFICATION DIVISION.
4 PROGRAM-ID. DEMONSTRATE PICTURE CLAUSE.
5 AUTHOR. SIMAR.
6 ENVIRONMENT DIVISION.
7 DATA DIVISION.
8 WORKING-STORAGE SECTION.
9 01 A PIC 99 VALUE 77.
10 PROCEDURE DIVISION.
11 M-PARA.
12 DISPLAY "A=", A.
13 STOP RUN.
No errors or warnings
Data area size = 224
Code area size = 38
-
8/2/2019 Ibs Docs PTU Varun
5/63
SOFTWARE LAB X CS-320
5
OUTPUT:-
-
8/2/2019 Ibs Docs PTU Varun
6/63
SOFTWARE LAB X CS-320
6
EXPERIMENT NO:-4
AIM:-WAP TO DEMONSTRATE DATA MOVEMENT VERB.
MOVE.COB Mon Mar 12 17:40:06 2012 Page 1
line number source line Microsoft COBOL Version 2.20
1 *VARUN KUMAR
2 *100610391681
3 IDENTIFICATION DIVISION.
4 PROGRAM-ID. DEMONSTRATE-DATA-MOVEMENT-VERB.
5 AUTHOR. SIMAR.
6 ENVIRONMENT DIVISION.
7 DATA DIVISION.
8 WORKING-STORAGE SECTION.
9 01 A PIC 999 VALUE 101.
10 01 B PIC 999.
11 PROCEDURE DIVISION.
12 M-PARA.
13 DISPLAY "A=", A.
14 MOVE A TO B.
15 DISPLAY "MOVING VALUE OF A TO B."
16 DISPLAY "B=", B.
17 STOP RUN.
-
8/2/2019 Ibs Docs PTU Varun
7/63
SOFTWARE LAB X CS-320
7
No errors or warnings
Data area size = 256
Code area size = 76
OUTPUT:-
-
8/2/2019 Ibs Docs PTU Varun
8/63
SOFTWARE LAB X CS-320
8
EXPERIMENT NO: - 5
AIM:-WAP TO DEMONSTRATE EDITED CHARACTERS.
EDITCHAR.COB Mon Mar 12 17:39:48 2012 Page 1
line number source line Microsoft COBOL Version 2.20
1 *VARUN KUMAR
2 *100610391681
3 IDENTIFICATION DIVISION.
4 PROGRAM-ID. DEMONSTRATE-EDITED-CHARACTERS.
5 AUTHOR. SIMAR.
6 ENVIRONMENT DIVISION.
7 DATA DIVISION.
8 WORKING-STORAGE SECTION.
9 01 A PIC 999 VALUE 55.
10 01 B PIC Z99.
11 PROCEDURE DIVISION.
12 M-PARA.
13 DISPLAY "A=", A.
14 DISPLAY "IN EDITED FORM".
15 MOVE A TO B.
16 DISPLAY "B=", B.
17 STOP RUN.
-
8/2/2019 Ibs Docs PTU Varun
9/63
SOFTWARE LAB X CS-320
9
No errors or warnings
Data area size = 246
Code area size = 84
OUTPUT:-
-
8/2/2019 Ibs Docs PTU Varun
10/63
SOFTWARE LAB X CS-320
10
EXPERIMENT NO:- 6
AIM:- WAP TO DEMONSTRATE ARITHEMATIC VERB.
ARITHV.COB Mon Mar 12 17:26:43 2012 Page 1
line number source line Microsoft COBOL Version 2.20
1 *VARUN KUMAR
2 *100610391681
3 IDENTIFICATION DIVISION.
4 PROGRAM-ID. DEMONSTRATE-ARITHEMATIC-VERB.
5 AUTHOR. SIMAR.
6 ENVIRONMENT DIVISION.
7 DATA DIVISION.
8 WORKING-STORAGE SECTION.
9 01 A PIC 99.
10 01 B PIC 99.
11 PROCEDURE DIVISION.
12 M-PARA.
13 DISPLAY "ENTER VALUE FOR A".
14 ACCEPT A.
15 DISPLAY "ENTER VALUE FOR B".
16 ACCEPT B.
17 ADD A TO B.
18 DISPLAY "SUM = ", B.
19 MULTIPLY A BY 5 GIVING A.
20 DISPLAY "A MULTIPLIED BY 5 IS = ", A.
21 STOP RUN.
No errors or warnings
-
8/2/2019 Ibs Docs PTU Varun
11/63
SOFTWARE LAB X CS-320
11
Data area size = 312
Code area size = 132
OUTPUT:-
-
8/2/2019 Ibs Docs PTU Varun
12/63
SOFTWARE LAB X CS-320
12
EXPERIMENTS:- 7
AIM:- WAP TO DEMONSTRATE-CONDITIONAL-VERB.
CONDVERB.COB Mon Mar 12 17:39:33 2012 Page 1
line number source line Microsoft COBOL Version 2.20
1 *VARUN KUMAR
2 *100610391681
3 IDENTIFICATION DIVISION.
4 PROGRAM-ID. DEMONSTRATE-CONDITIONAL-VERB.
5 AUTHOR. SIMAR.
6 ENVIRONMENT DIVISION.
7 DATA DIVISION.
8 WORKING-STORAGE SECTION.
9 01 A PIC 99.
10 01 B PIC 99.
11 PROCEDURE DIVISION.
12 M-PARA.
13 DISPLAY "ENTER VALUE FOR A".
14 ACCEPT A.
15 DISPLAY "ENTER VALUE FOR B".
16 ACCEPT B.
17 IF A GREATER THAN B
18 DISPLAY "A IS GREATER THAN B"
19 ELSE
20 DISPLAY "B IS GREATER THAN A".
21 STOP RUN.
-
8/2/2019 Ibs Docs PTU Varun
13/63
SOFTWARE LAB X CS-320
13
No errors or warnings
Data area size = 320
Code area size = 100
OUTPUT:-
-
8/2/2019 Ibs Docs PTU Varun
14/63
SOFTWARE LAB X CS-320
14
EXPERIMENT NO:- 8
AIM:- WAP TO DEMONSTRATE-CONDITION-NAMES.
CONDNAME.COB Mon Mar 12 17:38:48 2012 Page 1
line number source line Microsoft COBOL Version 2.20
1 *VARUN KUMAR
2 *100610391681
3 IDENTIFICATION DIVISION.
4 PROGRAM-ID. DEMONSTRATE-CONDITION-NAMES.
5 ENVIRONMENT DIVISION.
6 DATA DIVISION.
7 WORKING-STORAGE SECTION.
8 01 AGE PIC 99.
9 88 ELLIGIBLE VALUES ARE 18 THRU 99.
10 88 INELLIGIBLE VALUES ARE 1 THRU 17.
11 PROCEDURE DIVISION.
12 M-PARA.
13 PERFORM I-PARA.
14 PERFORM O-PARA.
15 STOP RUN.
16 I-PARA.
17 DISPLAY "ENTER AGE".
18 ACCEPT AGE.
19 O-PARA.
20 IF ELLIGIBLE
21 DISPLAY "YOU HAVE RIGHT TO VOTE".
22 IF INELLIGIBLE
23 DISPLAY "YOU ARE NOT ELLIGIBLE TO VOTE".
-
8/2/2019 Ibs Docs PTU Varun
15/63
SOFTWARE LAB X CS-320
15
No errors or warnings
Data area size = 304
Code area size = 134
OUTPUT:-
-
8/2/2019 Ibs Docs PTU Varun
16/63
SOFTWARE LAB X CS-320
16
EXPERIMENT NO:- 9
AIM:- WAP TO DEMONSTRATE-PERFORM-STATEMENT.
PERTHRU.COB Mon Mar 12 20:31:15 2012 Page 1
line number source line Microsoft COBOL Version 2.20
1 *VARUN KUMAR
2 *100610391681
3 IDENTIFICATION DIVISION.
4 PROGRAM-ID. DEMONSTRATE-PERFORM-STATEMENT.
5 AUTHOR. SIMAR.
6 ENVIRONMENT DIVISION.
7 DATA DIVISION.
8 WORKING-STORAGE SECTION.
9 01 N PIC 99 VALUE 0.
10 01 I PIC 99 VALUE 1.
11 01 SUM PIC 9999 VALUE 0.
12 PROCEDURE DIVISION.
13 M-PARA.
14 PERFORM A-PARA THRU D-PARA.
15 DISPLAY "ENTER THE NUMBER".
16 ACCEPT N.
17 PERFORM SUM-PARA UNTIL I>N.
18 DISPLAY "SUM OF FIRST ", N, " NUMBERS=", SUM.
19 PERFORM L-PARA.
20 STOP RUN.
21 A-PARA.
22 DISPLAY "THIS IS A-PARA".
23 B-PARA.
-
8/2/2019 Ibs Docs PTU Varun
17/63
SOFTWARE LAB X CS-320
17
24 DISPLAY "THIS IS B-PARA".
25 C-PARA.
26 DISPLAY "THIS IS C-PARA".
27 D-PARA.
28 DISPLAY "THIS IS D-PARA".
29 SUM-PARA.
30 ADD I TO SUM.
31 ADD 1 TO I.
32 L-PARA.
33 DISPLAY "THIS IS LAST PARA".
No errors or warnings
Data area size = 364
Code area size = 252
OUTPUT:-
-
8/2/2019 Ibs Docs PTU Varun
18/63
SOFTWARE LAB X CS-320
18
EXPERIMENT NO: -10
AIM: -WAP TO DEMONSTRATE TO CREATE A TABLE AND PERFORM LINEAR SEARCH.
LINEAR.COB Sun Mar 18 09:49:57 2012 Page 1
line number source line Microsoft COBOL Version 2.20
1 *WAP TO DEMONSTRATE TO CREATE A TABLE AND PERFORM LINEAR SEARCH.
2 *VARUN KUMAR
3 *100610391681
4 IDENTIFICATION DIVISION.
5 PROGRAM-ID SIMAR.
6 ENVIRONMENT DIVISION.
7 DATA DIVISION.
8 WORKING-STORAGE SECTION.
9 01 EMP.
10 02 EMP-INFO OCCURS 3 TIMES INDEXED BY I.
11 03 EMPNAM PIC A(15).
12 03 EMPSAL PIC 9999.
13 01 ENAM PIC A(15).
14 PROCEDURE DIVISION.
15 M-PARA.
16 SET I TO 1.
17 PERFORM A-PARA VARYING I FROM 1 BY 1 UNTIL I>3.
18 PERFORM I-PARA.
19 PERFORM S-PARA VARYING I FROM 1 BY 1 UNTIL I>3.
20 A-PARA.
21 DISPLAY "ENTER NAME ".
22 ACCEPT EMPNAM(I).
23 DISPLAY "ENTER SALARY ".
-
8/2/2019 Ibs Docs PTU Varun
19/63
SOFTWARE LAB X CS-320
19
24 ACCEPT EMPSAL(I).
25 I-PARA.
27 ACCEPT ENAM.
28 S-PARA.
29 SEARCH EMP-INFO AT END PERFORM N-PARA
30 WHEN ENAM = EMPNAM(I) PERFORM F-PARA.
31 N-PARA.
32 DISPLAY "NOT FOUND".
33 PERFORM END-PARA.
34 F-PARA.
35 DISPLAY "FOUND".
36 PERFORM END-PARA.
37 END-PARA.
38 STOP RUN.
No errors or warnings
Data area size = 434
Code area size = 408
-
8/2/2019 Ibs Docs PTU Varun
20/63
SOFTWARE LAB X CS-320
20
OUTPUT: -
-
8/2/2019 Ibs Docs PTU Varun
21/63
SOFTWARE LAB X CS-320
21
EXPERIMENT NO: -11
AIM: -WAP TO DEMONSTRATE TO CREATE A TABLE AND PERFORM BINARY SEARCH.
BINARY.COB Sun Mar 18 10:43:22 2012 Page 1
line number source line Microsoft COBOL Version 2.20
1 *WAP TO DEMONSTRATE TO CREATE A TABLE AND PERFORM LINEAR SEARCH.
2 *VARUN KUMAR.
3 *100610391681.
4 IDENTIFICATION DIVISION.
5 PROGRAM-ID SIMAR.
6 ENVIRONMENT DIVISION.
7 DATA DIVISION.
8 WORKING-STORAGE SECTION.
9 01 EMP.
10 02 EMP-INFO OCCURS 3 TIMES INDEXED BY I.
11 03 EMPNAM PIC A(15).
12 03 EMPSAL PIC 9999.
13 01 ENAM PIC A(15).
14 PROCEDURE DIVISION.
15 M-PARA.
16 SET I TO 1.
17 PERFORM A-PARA VARYING I FROM 1 BY 1 UNTIL I>3.
18 PERFORM I-PARA.
19 PERFORM S-PARA VARYING I FROM 1 BY 1 UNTIL I>3.
20 A-PARA.
21 DISPLAY "ENTER NAME ".
22 ACCEPT EMPNAM(I).
23 DISPLAY "ENTER SALARY ".
-
8/2/2019 Ibs Docs PTU Varun
22/63
SOFTWARE LAB X CS-320
22
24 ACCEPT EMPSAL(I).
25 I-PARA.
26 DISPLAY "ENTER NAME TO SEARCH".
27 ACCEPT ENAM.
28 S-PARA.
29 SEARCH ALL EMP-INFO AT END PERFORM N-PARA
30 WHEN ENAM = EMPNAM(I) PERFORM F-PARA.
31 N-PARA.
32 DISPLAY "NOT FOUND".
33 PERFORM END-PARA.
34 F-PARA.
35 DISPLAY "FOUND".
36 PERFORM END-PARA.
37 END-PARA.
38 STOP RUN.
No errors or warnings
Data area size = 434
Code area size = 414
-
8/2/2019 Ibs Docs PTU Varun
23/63
SOFTWARE LAB X CS-320
23
OUTPUT: -
-
8/2/2019 Ibs Docs PTU Varun
24/63
SOFTWARE LAB X CS-320
24
EXPERIMENT NO: -12(a)
AIM: -WAP TODEMONSTRATE CREATING SEQUENTIAL FILE.
FCREATE.COB Wed Mar 14 00:07:50 2012 Page 1
line number source line Microsoft COBOL Version 2.20
1 *VARUN KUMAR.
2 *100610391681.
3 *WAP TO DEMONSTRATE CREATING SEQUENTIAL FILE.
4 IDENTIFICATION DIVISION.
5 PROGRAM-ID. GREATER.
6 AUTHOR. SIMAR.
7 ENVIRONMENT DIVISION.
8 CONFIGURATION SECTION.
9 INPUT-OUTPUT SECTION.
10 FILE-CONTROL.
11 SELECT EMP ASSIGN TO DISK
12 ORGANIZATION IS SEQUENTIAL
13 ACCESS IS SEQUENTIAL.
14 DATA DIVISION.
15 FILE SECTION.
16 FD EMP
17 LABEL RECORDS ARE STANDARD
18 VALUE OF FILE-ID IS "EMP.DAT".
19 01 E-REC.
20 02 ECODE PIC XXX.
21 02 ENAME PIC A(20).
22 02 ESAL PIC 9(5).
23 WORKING-STORAGE SECTION.
-
8/2/2019 Ibs Docs PTU Varun
25/63
SOFTWARE LAB X CS-320
25
24 01 CH PIC A VALUE 'Y'.
25 PROCEDURE DIVISION.
26 M-PARA.
27 OPEN OUTPUT EMP.
28 PERFORM A-PARA UNTIL CH EQUAL TO 'N'.
29 CLOSE EMP.
30 STOP RUN.
31 A-PARA.
32 DISPLAY "ENTER ECODE".
33 ACCEPT ECODE.
34 DISPLAY "ENTER ENAME".
35 ACCEPT ENAME.
36 DISPLAY "ENTER ESAL".
37 ACCEPT ESAL.
38 WRITE E-REC.
39 DISPLAY "ENTER Y TO CONTINUE AND N TO EXIT".
40 ACCEPT CH.
No errors or warnings
Data area size = 438
Code area size = 162
-
8/2/2019 Ibs Docs PTU Varun
26/63
SOFTWARE LAB X CS-320
26
OUTPUT: -
-
8/2/2019 Ibs Docs PTU Varun
27/63
-
8/2/2019 Ibs Docs PTU Varun
28/63
SOFTWARE LAB X CS-320
28
24 01 CH PIC A VALUE 'Y'.
25 PROCEDURE DIVISION.
26 M-PARA.
27 OPEN EXTEND EMP.
28 PERFORM A-PARA UNTIL CH EQUAL TO 'N'.
29 CLOSE EMP.
30 STOP RUN.
31 A-PARA.
32 DISPLAY "ENTER ECODE".
33 ACCEPT ECODE.
34 DISPLAY "ENTER ENAME".
35 ACCEPT ENAME.
36 DISPLAY "ENTER ESAL".
37 ACCEPT ESAL.
38 WRITE E-REC.
39 DISPLAY "ENTER Y TO CONTINUE AND N TO EXIT".
40 ACCEPT CH.
No errors or warnings
Data area size = 438
Code area size = 162
-
8/2/2019 Ibs Docs PTU Varun
29/63
SOFTWARE LAB X CS-320
29
OUTPUT: -
-
8/2/2019 Ibs Docs PTU Varun
30/63
SOFTWARE LAB X CS-320
30
EXPERIMENT NO: -12(c)
AIM: -WAP TO DEMONSTRATE READ SEQUENTIAL FILE.
FREAD.COB Tue Mar 13 00:13:02 2012 Page 1
line number source line Microsoft COBOL Version 2.20
1 *VARUN KUMAR.
2 *100610391681.
3 *WAP TO DEMONSTRATE READ SEQUENTIAL FILE.
4 IDENTIFICATION DIVISION.
5 PROGRAM-ID. READ.
6 AUTHOR. SIMAR.
7 ENVIRONMENT DIVISION.
8 CONFIGURATION SECTION.
9 INPUT-OUTPUT SECTION.
10 FILE-CONTROL.
11 SELECT EMP ASSIGN TO DISK
12 ORGANIZATION IS SEQUENTIAL
13 ACCESS IS SEQUENTIAL.
14 DATA DIVISION.
15 FILE SECTION.
16 FD EMP
17 LABEL RECORDS ARE STANDARD
18 VALUE OF FILE-ID IS "EMP.DAT".
19 01 E-REC.
20 02 ECODE PIC XXX.
21 02 ENAME PIC A(20).
22 02 ESAL PIC 9(5).
23 WORKING-STORAGE SECTION.
-
8/2/2019 Ibs Docs PTU Varun
31/63
SOFTWARE LAB X CS-320
31
24 01 CH PIC 9 VALUE 1.
25 01 COUNTER PIC 9(5) VALUE 1.
26 PROCEDURE DIVISION.
27 M-PARA.
28 OPEN INPUT EMP.
29 READ EMP AT END SET CH TO 0.
30 PERFORM A-PARA UNTIL CH EQUAL TO 0.
31 DISPLAY "NO MORE RECORDS FOUND".
32 CLOSE EMP.
33 STOP RUN.
34 A-PARA.
35 DISPLAY E-REC.
36 READ EMP AT END SET CH TO 0.
No errors or warnings
Data area size = 418
Code area size = 156
OUTPUT:-
-
8/2/2019 Ibs Docs PTU Varun
32/63
SOFTWARE LAB X CS-320
32
EXPERIMENT NO: -12(d)
AIM: -WAP TO DEMONSTRATE DELETE RECORD SEQUENTIAL FILE.
FDELETE.COB Tue Mar 13 01:48:01 2012 Page 1
line number source line Microsoft COBOL Version 2.20
1 *VARUN KUMAR
2 *100610391681.
3 *WAP TO DEMONSTRATE DELETE RECORD SEQUENTIAL FILE.
4 IDENTIFICATION DIVISION.
5 PROGRAM-ID. DELETE.
6 AUTHOR. SIMAR.
7 ENVIRONMENT DIVISION.
8 CONFIGURATION SECTION.
9 INPUT-OUTPUT SECTION.
10 FILE-CONTROL.
11 SELECT EMP ASSIGN TO DISK
12 ORGANIZATION IS SEQUENTIAL
13 ACCESS IS SEQUENTIAL.
14 SELECT TEMP ASSIGN TO DISK
15 ORGANIZATION IS SEQUENTIAL
16 ACCESS IS SEQUENTIAL.
17 DATA DIVISION.
18 FILE SECTION.
19 FD EMP
20 LABEL RECORDS ARE STANDARD
21 DATA RECORD IS E-REC
22 VALUE OF FILE-ID IS "EMP.DAT".
23 01 E-REC.
-
8/2/2019 Ibs Docs PTU Varun
33/63
SOFTWARE LAB X CS-320
33
24 02 ECODE PIC XXX.
25 02 ENAME PIC A(20).
26 02 ESAL PIC 9(5).
27 FD TEMP
28 DATA RECORD IS TE-REC
29 LABEL RECORDS ARE STANDARD
30 VALUE OF FILE-ID IS "TEMP.DAT".
31 01 TE-REC.
32 02 TECODE PIC XXX.
33 02 TENAME PIC A(20).
34 02 TESAL PIC 9(5).
35 WORKING-STORAGE SECTION.
36 01 CH PIC 9 VALUE 1.
37 01 NAME PIC A(20).
38 01 CH2 PIC 9 VALUE 1.
39 01 CH3 PIC 9 VALUE 1.
40 01 CH4 PIC 9 VALUE 1.
41 01 CON PIC A VALUE 'N'.
42 PROCEDURE DIVISION.
43 M-PARA.
44 DISPLAY "ENTER NAME YOU WANT TO DELETE".
45 ACCEPT NAME.
46 OPEN I-O EMP.
47 READ EMP AT END SET CH TO 0.
48 PERFORM A-PARA UNTIL CH EQUAL TO 0 OR CH2 EQUAL TO 0.
49 IF CH2 NOT EQUAL TO 0
50 DISPLAY "NO RECORD FOUND"
51 ELSE
52 PERFORM D-PARA.
-
8/2/2019 Ibs Docs PTU Varun
34/63
SOFTWARE LAB X CS-320
34
53 CLOSE EMP.
54 CLOSE TEMP.
55 STOP RUN.
56 A-PARA.
57 IF ENAME EQUAL TO NAME
58 DISPLAY "RECORD FOUND"
59 DISPLAY "ECODE | ENAME | ESAL"
60 DISPLAY ECODE, " " , ENAME , " " , ESAL
61 SET CH2 TO 0
62 ELSE
63 SET CH TO 1
64 READ EMP AT END SET CH TO 0.
65 D-PARA.
66 DISPLAY "DO YOU WANT TO DELETE THIS RECORD? Y/N".
67 ACCEPT CON.
68 IF CON EQUAL TO 'Y'
69 PERFORM D2-PARA.
70 D2-PARA.
71 CLOSE EMP.
72 OPEN OUTPUT TEMP.
73 OPEN INPUT EMP.
74 READ EMP AT END SET CH3 TO 0.
75 PERFORM WR-PARA UNTIL CH3 EQUAL TO 0.
76 PERFORM F-PARA.
77 WR-PARA.
78 IF ENAME NOT EQUAL TO NAME
79 MOVE ENAME TO TENAME
80 MOVE ECODE TO TECODE
81 MOVE ESAL TO TESAL
-
8/2/2019 Ibs Docs PTU Varun
35/63
SOFTWARE LAB X CS-320
35
82 WRITE TE-REC.
83 READ EMP AT END SET CH3 TO 0.
84 F-PARA.
85 CLOSE EMP.
86 CLOSE TEMP.
87 PERFORM RENAME-PARA.
88 RENAME-PARA.
89 OPEN INPUT TEMP.
90 OPEN OUTPUT EMP.
91 READ TEMP AT END SET CH4 TO 0.
92 PERFORM RENAME2-PARA UNTIL CH4 EQUAL TO 0.
93 RENAME2-PARA.
94 MOVE TE-REC TO E-REC.
95 WRITE E-REC.
96 READ TEMP AT END SET CH4 TO 0.
No errors or warnings
Data area size = 682
Code area size = 764
OUTPUT: -
-
8/2/2019 Ibs Docs PTU Varun
36/63
SOFTWARE LAB X CS-320
36
EXPERIMENT NO: -12(e)
AIM: -WAP TO DEMONSTRATE SEARCH RECORD SEQUENTIAL FILE.
FSERREAD.COB Wed Mar 14 00:24:56 2012 Page 1
line number source line Microsoft COBOL Version 2.20
1 *VARUN KUMAR.
2 *100610391681.
3 *WAP TO DEMONSTRATE SEARCH RECORD SEQUENTIAL FILE.
4 IDENTIFICATION DIVISION.
5 PROGRAM-ID. SEARCH.
6 AUTHOR. SIMAR.
7 ENVIRONMENT DIVISION.
8 CONFIGURATION SECTION.
9 INPUT-OUTPUT SECTION.
10 FILE-CONTROL.
11 SELECT EMP ASSIGN TO DISK
12 ORGANIZATION IS SEQUENTIAL
13 ACCESS IS SEQUENTIAL.
14 DATA DIVISION.
15 FILE SECTION.
16 FD EMP
17 LABEL RECORDS ARE STANDARD
18 VALUE OF FILE-ID IS "EMP.DAT".
19 01 E-REC.
20 02 ECODE PIC XXX.
21 02 ENAME PIC A(20).
22 02 ESAL PIC 9(5).
23 WORKING-STORAGE SECTION.
-
8/2/2019 Ibs Docs PTU Varun
37/63
SOFTWARE LAB X CS-320
37
24 01 CH PIC 9 VALUE 1.
25 01 NAME PIC A(20).
26 PROCEDURE DIVISION.
27 M-PARA.
28 DISPLAY "ENTER NAME YOU WANT TO SEARCH".
29 ACCEPT NAME.
30 OPEN INPUT EMP.
31 READ EMP AT END SET CH TO 0.
32 PERFORM A-PARA UNTIL CH EQUAL TO 0.
33 CLOSE EMP.
34 IF CH NOT EQUAL TO 0
35 DISPLAY "NO RECORD FOUND".
36 STOP RUN.
37 A-PARA.
38 IF ENAME EQUAL TO NAME
39 DISPLAY "RECORD FOUND"
40 DISPLAY "ECODE | ENAME | ESAL"
41 DISPLAY ECODE, " " , ENAME , " " , ESAL
42 READ EMP AT END SET CH TO 0.
No errors or warnings
Data area size = 504
Code area size = 258
-
8/2/2019 Ibs Docs PTU Varun
38/63
SOFTWARE LAB X CS-320
38
OUTPUT: -
-
8/2/2019 Ibs Docs PTU Varun
39/63
SOFTWARE LAB X CS-320
39
EXPERIMENT NO: -13(a)
AIM: - WAP TO DEMONSTRATE CREATING RELATIVE FILE.
R.COB Mon Mar 19 06:31:40 2012 Page 1
line number source line Microsoft COBOL Version 2.20
1 *VARUN KUMAR.
2 *100610391681.
3 *WAP TO DEMONSTRATE CREATING RELATIVE FILE.
4 IDENTIFICATION DIVISION.
5 PROGRAM-ID. CREATE.
6 AUTHOR. SIMAR.
7 ENVIRONMENT DIVISION.
8 CONFIGURATION SECTION.
9 INPUT-OUTPUT SECTION.
10 FILE-CONTROL.
11 SELECT REMP ASSIGN TO DISK
12 ORGANIZATION IS RELATIVE
13 ACCESS MODE IS RANDOM
14 RELATIVE KEY IS ECODE
15 FILE STATUS IS ST.
16 DATA DIVISION.
17 FILE SECTION.
18 FD REMP
19 LABEL RECORDS ARE STANDARD
20 VALUE OF FILE-ID IS "REMP.DAT".
21 01 E-REC.
22 02 ECODE PIC 999.
23 02 ENAME PIC A(20).
-
8/2/2019 Ibs Docs PTU Varun
40/63
SOFTWARE LAB X CS-320
40
24 02 ESAL PIC 9(5).
25 WORKING-STORAGE SECTION.
26 01 ST PIC X(2).
27 01 CH PIC A VALUE 'Y'.
28 PROCEDURE DIVISION.
29 M-PARA.
30 OPEN OUTPUT REMP.
31 PERFORM A-PARA UNTIL CH EQUAL TO 'N'.
32 CLOSE REMP.
33 STOP RUN.
34 A-PARA.
35 DISPLAY "ENTER ECODE".
36 ACCEPT ECODE.
37 DISPLAY "ENTER ENAME".
38 ACCEPT ENAME.
39 DISPLAY "ENTER ESAL".
40 ACCEPT ESAL.
41 WRITE E-REC.
42 DISPLAY "ENTER Y TO CONTINUE AND N TO EXIT".
43 ACCEPT CH.
No errors or warnings
Data area size = 464
Code area size = 164
-
8/2/2019 Ibs Docs PTU Varun
41/63
SOFTWARE LAB X CS-320
41
OUTPUT: -
-
8/2/2019 Ibs Docs PTU Varun
42/63
SOFTWARE LAB X CS-320
42
EXPERIMENT NO: -13(b)
AIM: -WAP TO DEMONSTRATE APPEND RELATIVE FILE.
RAPP.COB Mon Mar 19 06:41:24 2012 Page 1
line number source line Microsoft COBOL Version 2.20
1 *VARUN KUMAR.
2 *100610391681.
3 *WAP TO DEMONSTRATE APPEND RELATIVE FILE.
4 IDENTIFICATION DIVISION.
5 PROGRAM-ID. APPEND.
6 AUTHOR. SIMAR.
7 ENVIRONMENT DIVISION.
8 CONFIGURATION SECTION.
9 INPUT-OUTPUT SECTION.
10 FILE-CONTROL.
11 SELECT REMP ASSIGN TO DISK
12 ORGANIZATION IS RELATIVE
13 ACCESS MODE IS RANDOM
14 RELATIVE KEY IS ECODE
15 FILE STATUS IS ST.
16 DATA DIVISION.
17 FILE SECTION.
18 FD REMP
19 LABEL RECORDS ARE STANDARD
20 VALUE OF FILE-ID IS "REMP.DAT".
21 01 E-REC.
22 02 ECODE PIC 999.
23 02 ENAME PIC A(20).
-
8/2/2019 Ibs Docs PTU Varun
43/63
SOFTWARE LAB X CS-320
43
24 02 ESAL PIC 9(5).
25 WORKING-STORAGE SECTION.
26 01 ST PIC X(2).
27 01 CH PIC A VALUE 'Y'.
28 PROCEDURE DIVISION.
29 M-PARA.
30 OPEN I-O REMP.
31 PERFORM A-PARA UNTIL CH EQUAL TO 'N'.
32 CLOSE REMP.
33 STOP RUN.
34 A-PARA.
35 DISPLAY "ENTER ECODE".
36 ACCEPT ECODE.
37 DISPLAY "ENTER ENAME".
38 ACCEPT ENAME.
39 DISPLAY "ENTER ESAL".
40 ACCEPT ESAL.
41 WRITE E-REC.
42 DISPLAY "ENTER Y TO CONTINUE AND N TO EXIT".
43 ACCEPT CH.
No errors or warnings
Data area size = 464
Code area size = 164
-
8/2/2019 Ibs Docs PTU Varun
44/63
SOFTWARE LAB X CS-320
44
OUTPUT: -
-
8/2/2019 Ibs Docs PTU Varun
45/63
SOFTWARE LAB X CS-320
45
EXPERIMENT NO: -13(c)
AIM: -WAP TO DEMONSTRATE READ RELATIVE FILE.
RREAD.COBCOB Mon Mar 19 06:02:50 2012 Page 1
line number source line Microsoft COBOL Version 2.20
1 *VARUN KUMAR.
2 *100610391681.
3 *WAP TO DEMONSTRATE READ RELATIVE FILE.
4 IDENTIFICATION DIVISION.
5 PROGRAM-ID. READ.
6 AUTHOR. SIMAR.
7 ENVIRONMENT DIVISION.
8 CONFIGURATION SECTION.
9 INPUT-OUTPUT SECTION.
10 FILE-CONTROL.
11 SELECT REMP ASSIGN TO DISK
12 ORGANIZATION IS RELATIVE
13 ACCESS MODE IS DYNAMIC
14 RELATIVE KEY IS ECODE
15 FILE STATUS IS ST.
16 DATA DIVISION.
17 FILE SECTION.
18 FD REMP
19 LABEL RECORDS ARE STANDARD
20 VALUE OF FILE-ID IS "REMP.DAT".
21 01 E-REC.
22 02 ECODE PIC 999.
23 02 ENAME PIC A(20).
-
8/2/2019 Ibs Docs PTU Varun
46/63
SOFTWARE LAB X CS-320
46
24 02 ESAL PIC 9(5).
25 WORKING-STORAGE SECTION.
26 01 E-RECS.
27 02 ECODES PIC 999.
28 02 ENAMES PIC A(20).
29 02 ESALS PIC 9(5).
30 01 ST PIC X(2).
31 01 CH PIC 9 VALUE 1.
32 PROCEDURE DIVISION.
33 M-PARA.
34 OPEN INPUT REMP.
35 READ REMP NEXT INTO E-RECS
36 AT END SET CH TO 0.
37 PERFORM A-PARA UNTIL CH EQUAL TO 0.
38 CLOSE REMP.
39 STOP RUN.
40 A-PARA.
41 DISPLAY ECODES , ENAMES , ESALS.
42 READ REMP NEXT INTO E-RECS
43 AT END SET CH TO 0.
No errors or warnings
Data area size = 444
Code area size = 184
-
8/2/2019 Ibs Docs PTU Varun
47/63
SOFTWARE LAB X CS-320
47
OUTPUT: -
-
8/2/2019 Ibs Docs PTU Varun
48/63
SOFTWARE LAB X CS-320
48
EXPERIMENT NO: -13(d)
AIM: - WAP TO DEMONSTRATE UPDATE RELATIVE FILE.
RU.COB Mon Mar 19 06:52:44 2012 Page 1
line number source line Microsoft COBOL Version 2.20
1 *VARUN KUMAR.
2 *100610391681.
3 *WAP TO DEMONSTRATE UPDATE RELATIVE FILE.
4 IDENTIFICATION DIVISION.
5 PROGRAM-ID. UPDATE.
6 AUTHOR. SIMAR.
7 ENVIRONMENT DIVISION.
8 CONFIGURATION SECTION.
9 INPUT-OUTPUT SECTION.
10 FILE-CONTROL.
11 SELECT REMP ASSIGN TO DISK
12 ORGANIZATION IS RELATIVE
13 ACCESS MODE IS DYNAMIC
14 RELATIVE KEY IS ECODE
15 FILE STATUS IS ST.
16 DATA DIVISION.
17 FILE SECTION.
18 FD REMP
19 LABEL RECORDS ARE STANDARD
20 VALUE OF FILE-ID IS "REMP.DAT".
21 01 E-REC.
22 02 ECODE PIC 999.
23 02 ENAME PIC A(20).
-
8/2/2019 Ibs Docs PTU Varun
49/63
SOFTWARE LAB X CS-320
49
24 02 ESAL PIC 9(5).
25 WORKING-STORAGE SECTION.
26 01 E-RECS.
27 02 ECODES PIC 999.
28 02 ENAMES PIC A(20).
29 02 ESALS PIC 9(5).
30 01 ST PIC X(2).
31 01 CH PIC 9 VALUE 1.
32 01 CODE PIC 999.
33 PROCEDURE DIVISION.
34 M-PARA.
35 OPEN I-O REMP.
36 READ REMP NEXT INTO E-RECS
37 AT END SET CH TO 0.
38 PERFORM A-PARA UNTIL CH EQUAL TO 0.
39 PERFORM U-PARA.
40 CLOSE REMP.
41 PERFORM LOOP-PARA.
42 STOP RUN.
43 A-PARA.
44 DISPLAY ECODES , ENAMES , ESALS.
45 READ REMP NEXT INTO E-RECS
46 AT END SET CH TO 0.
47 U-PARA.
48 DISPLAY "ENTER THE ECODE OF EMPLOYEE THAT YOU WANT TO UP
49 ACCEPT CODE.
50 MOVE CODE TO ECODE.
51 READ REMP INVALID KEY PERFORM NOT-FOUND.
52 DISPLAY "ENTER NEW NAME".
-
8/2/2019 Ibs Docs PTU Varun
50/63
SOFTWARE LAB X CS-320
50
53 ACCEPT ENAME.
54 DISPLAY "ENTER SALARY".
55 ACCEPT ESAL.
56 REWRITE E-REC.
57 NOT-FOUND.
58 DISPLAY "RECORD NOT FOUND".
59 STOP RUN.
60 LOOP-PARA.
61 DISPLAY "DO YOU WANT TO CONTINUE?(Y/N)".
62 ACCEPT ST.
63 IF ST EQUAL TO 'Y' OR ST EQUAL TO 'y'
64 GO TO M-PARA.
No errors or warnings
Data area size = 572
Code area size = 398
OUTPUT: -
-
8/2/2019 Ibs Docs PTU Varun
51/63
SOFTWARE LAB X CS-320
51
EXPERIMENT NO: -13(e)
AIM: - WAP TO DEMONSTRATE SEARCHING RELATIVE FILE.
RS.COB Mon Mar 19 06:58:14 2012 Page 1
line number source line Microsoft COBOL Version 2.20
1 *VARUN KUMAR.
2 *100610391681.
3 *WAP TO DEMONSTRATE SEARCHING RELATIVE FILE.
4 IDENTIFICATION DIVISION.
5 PROGRAM-ID. SEARCH RELATIVE FILE.
6 AUTHOR. SIMAR.
7 ENVIRONMENT DIVISION.
8 CONFIGURATION SECTION.
9 INPUT-OUTPUT SECTION.
10 FILE-CONTROL.
11 SELECT REMP ASSIGN TO DISK
12 ORGANIZATION IS RELATIVE
13 ACCESS MODE IS DYNAMIC
14 RELATIVE KEY IS ECODE
15 FILE STATUS IS ST.
16 DATA DIVISION.
17 FILE SECTION.
18 FD REMP
19 LABEL RECORDS ARE STANDARD
20 VALUE OF FILE-ID IS "REMP.DAT".
21 01 E-REC.
22 02 ECODE PIC 999.
23 02 ENAME PIC A(20).
-
8/2/2019 Ibs Docs PTU Varun
52/63
SOFTWARE LAB X CS-320
52
24 02 ESAL PIC 9(5).
25 WORKING-STORAGE SECTION.
26 01 E-RECS.
27 02 ECODES PIC 999.
28 02 ENAMES PIC A(20).
29 02 ESALS PIC 9(5).
30 01 ST PIC X(2).
31 01 CH PIC 9 VALUE 1.
32 01 NAME PIC A(20).
33 01 CH2 PIC 9 VALUE 1.
34 PROCEDURE DIVISION.
35 M-PARA.
36 DISPLAY "ENTER NAME YOU WANT TO SEARCH".
37 ACCEPT NAME.
38 OPEN INPUT REMP.
39 READ REMP NEXT INTO E-RECS
40 AT END SET CH TO 0.
41 PERFORM A-PARA UNTIL CH EQUAL TO 0 OR CH2 EQUAL TO 0.
42 CLOSE REMP.
43 IF CH2 NOT EQUAL TO 0
44 DISPLAY "NO RECORD FOUND".
45 STOP RUN.
46 A-PARA.
47 IF ENAME EQUAL TO NAME
48 DISPLAY "RECORD FOUND"
49 DISPLAY "ECODE | ENAME | ESAL"
50 DISPLAY ECODES, " " , ENAMES , " " , ESALS
51 SET CH2 TO 0
52 ELSE
-
8/2/2019 Ibs Docs PTU Varun
53/63
SOFTWARE LAB X CS-320
53
53 SET CH TO 1.
54 READ REMP NEXT INTO E-RECS
55 AT END SET CH TO 0.
No errors or warnings
Data area size = 560
Code area size = 342
OUTPUT: -
-
8/2/2019 Ibs Docs PTU Varun
54/63
SOFTWARE LAB X CS-320
54
EXPERIMENT NO: -19
AIM: -WRITE ANY SIX TOOLS USED IN MS-WORD AND NAME ATLEAST TEN TOOLS OF
EACH.
*VARUN KUMAR
*100610391681
MS Word, the most common word processor software program, is a tool that can be used to assist withwriting tasks. Microsoft Word is full of tools that can help you work faster and smarter to enhance abilityto write. Formatting tools found in MS Word, such as centering text, columns and tables, and changingfont size and color. The following highlights specific features that can be used as strategies to supportwriting skills.
1. Spell and Grammar CheckerMS Word uses red and green underline squiggles representingspelling (red) and grammar (green) errors. For each incorrect item, the program tools offer alternativesolutions that can easily replace, or ignore the incorrect item with a click of the mouse.
2. Thesaurus and DictionaryThe thesaurus helps to refine writing as well as expose students to newvocabulary words. Students with poor spelling skills often have difficulty using a dictionary Thisfeature provides an instant definition for a highlighted word, eliminating the task of dictionarylookup.
3. Use of auto correctWhether a word is mistyped or misspelled, the auto correct feature canautomatically correct certain errors. If the first two initial letters are capitalized, auto correct willcapitalize only the first letter, as well as the first letter of a sentence. A correction can replace theerror as the student types, if so specified. Within the auto correct feature, a list of common mistakescan be added to an existing error table.
4. Use of auto summarizeAuto summarize in MS Word will summarize a document. If the text froma textbook chapter is scanned into the computer as a MS Word document, then the chapter can besummarized for the student. When enabled, a window opens to question what kind of summary isneeded, such as highlight key words in the document, create a new document with the summary,insert an abstract at the top of the document, or hide the document except for the summary.
5. Highlighting of textIn the formatting toolbar, there is an icon for highlighting text with a varietyof colors from which to select. By highlighting important passages, a student can focus on importantinformation when studying. By editing text with copy, cut and paste, a student can create a newdocument of highlighted text for study notes as well as easily reorganize the sequence of sentences asneeded.
6. Font size and background colorAdjust background color and font color and size to increasevisibility and attention to text.
7. Writing TemplatesFor those students who need additional writing support, a teacher can providestructured writing opportunities by creating writing templates that may or may not include specificprompt questions for the student to answer. MS Word does come with templates for mostly businessapplications; however, new templates can be created and stored in the template folder. For example,
-
8/2/2019 Ibs Docs PTU Varun
55/63
SOFTWARE LAB X CS-320
55
a teacher can create a template for a science or book report, a compare/contrast writing assignment,or a topic report.
8. Pictures with text - For emergent readers who benefit from symbols or pictures, pictures can beinserted anywhere in the document.
9. Text readers used in conjunction with MS Word-. Speech output provides strong reading supportas well as writing support. With speech output, students can monitor their writing by noticingomissions, incorrect grammar or misspellings as it is read aloud to them. A free text reader fromreadplease .com , E Reader from CAST, Text Assist from Mindmaker, Universal Reader fromPremier Assistive Technology ,or Screen Reader from TextHelp, can be used with MS Word in orderto provide text-to-speech capabilities. Examples ofscan and read integrated systems that interface ascanner, word processor such as MS Word, and speech output are Read and Write Gold fromTextHelp or Scan and Read Pro from Premier Assistive Technology. These program offers all thewriting tools found in MS Word, as well as text-to-speech, phonetic spell checkers, word retrieval,talking calculator, homophone assistance, and a word predictor.
10.Merge to e-mail. Mail-merging to letters and envelopes is too-too 1990s, but you may still need tosend a common message to a group of correspondents. That's no problem, since the familiar mail-merge feature in Word can also send e-mail messages. In Word 2007, complete your letter, clickFinish & Merge in the ribbon and choose Send E-mail Messages from the menu. In Word 2003 select"E-mail messages" at the very first step of the Mail Merge wizard. Either way you'll be prompted fora subject (the same for every message) and for a data field that holds e-mail addresses of therecipients.
11.Create fancy equations. Sure, you can write "the electric field equals one over the electricalconductivity times the electric current density," but is a lot more compact. To insert anequation into Word 2007 choose Equation | Insert New Equation from the Insert ribbon and use the
tools on the Equation Design toolbar that appears. In Word 2003, it's a bit more awkward. SelectInsert | Object from the menu, choose Microsoft Equation 3.0, and click OK, then use the Equationtoolbar that appears.
12.Calculate in tables. Sure, you can embed an Excel worksheet in a Word document, but if you justneed a few simple calculations, you can use Word's own math skills. Select a cell at the bottom of acolumn and click Formula on the Table Tools Layout ribbon (Word 2007), or select Formula fromthe Table menu (Word 2003). Word will suggest =SUM(ABOVE), but you can select among over adozen functions. Besides choosing ABOVE, BELOW, LEFT, or RIGHT to work with all cells in thespecified direction, you can reference individual cells and ranges as you do in Excelfor example,
=AVERAGE(A1:C3).
-
8/2/2019 Ibs Docs PTU Varun
56/63
SOFTWARE LAB X CS-320
56
EXPERIMENT NO: -20
AIM: -WRITE THE STEPS TO PERFORM MAIL MERGE OPERATIONS IN MS-WORD.
*VARUN KUMAR
*100610391681
Mail merge is a software function describing the production of multiple documents from asingle template form and a structured data source.
STEP 1: OPEN OR CREATE THE MAIN DOCUMENT
To open or create the main document, follow these steps:
1. If you already have a document that you want to use as the main document, open it now.The main document can be an existing letter, a new letter based on a letter template, or a new blank
document. If you do not yet have a document to use as the main document, you can create one instep 4.
2. Open the document in Word. On the Tools menu, click Mail Merge.The Mail Merge Helper dialog box appears.
3. Under "1. Main Document," click Create and click Form Letters.4. Word asks if you want to use the active window or a new document window. If you want to use the
document you opened in step 1, click Active Window. (The active document becomes the MailMerge main document.) If you do not have a document yet, click New Main Document. (Wordcreates a new document).
Word returns to the Mail Merge Helper.
STEP 2: OPEN OR CREATE THE DATA SOURCE
The data source contains the information that can vary in each version of the form letter. You can open anexisting data source created in Word, or you can create a new data source and fill in the addresseeinformation.
In the Mail Merge Helper, under "2 Data Source," click Get Data. The options are Create Data Source(that is, create a new data source), Open Data Source (open an existing data source), Header Options, andUse Address Book.
Use any of the following methods.Method 1: Typing the Names and Addresses for the First Time
If you haven't yet typed the names and addresses, and if you want to do so in Word, follow these steps:
1. Under "2. Data Source," click Get Data and choose Create Data Source.2. The Create Data Source dialog box contains a list of field names commonly used in form letters,
mailing labels, and envelopes. You can rename the fields and remove the fields you don't need. To
-
8/2/2019 Ibs Docs PTU Varun
57/63
SOFTWARE LAB X CS-320
57
add field names, type the name in the Field Name box and then choose the Add Field Name button.Click OK when you are finished.
3. When Word prompts you to save the data source, name the file and click OK.4. When Word asks if you want to edit the data source or set up the main document, click Edit Data
Source.5. When the Data Form dialog box appears, enter your addressee information. (If there's no
information for a particular field, leave the box blank.)
The set of information in each form makes up one data record.
After entering the information for a record, click Add New to move to the next record. Afteradding all of your data, click OK.
6. Skip to "Step 3: Edit the Main Document."
Method 2: Using a Data Source That Has Already Been Created
To open an existing data source, follow these steps:
1. In the Mail Merge Helper dialog box, click Get Data.2. Click Open Data Source.3. From the list of files, select the data source you want to use, and then click OK.
If the data source is not listed in the list of files, choose the appropriate drive and folder. Select theappropriate option in the List Files of Type box.
4. Word determines whether you need to set up the main document and displays a message. ClickEdit Main Document.
5. Skip to "Step 3: Edit the Main Document."Method 3: Using the Names and Addresses Stored in the Address Book
To use the name and addresses stored in the address book, follow these steps:
1. In the Mail Merge Helper dialog box, click Get Data, and select Use Address Book.The Use Address Book dialog box appears with the available address books listed under ChooseAddress Book.
2. Select the Address Book you want to use as your data source. Word may ask you to confirm thedata source if you have Confirm Conversions selected as an option.
If you use an address book/contact list from Schedule+, Word prompts you to log on to Schedule+and provide a password if necessary.
If you use an address book from Exchange, Word asks you to log on to the Exchange services.
Word determines whether you need to set up the main document and displays a message.3. Click Set Up Main Document.4. Continue with "Step 3: Edit the Main Document."
-
8/2/2019 Ibs Docs PTU Varun
58/63
SOFTWARE LAB X CS-320
58
STEP 3: EDIT THE MAIN DOCUMENT
Word returns to the main document. (Notice the appearance of the Mail Merge Toolbar.) From the maindocument, follow these steps:
1. Type or add any text and graphics you want to include in the letter.2. Each time you come to a place where you want to insert information from the data source, click the
Insert Merge Field button on the Mail Merge Toolbar. Choose the appropriate merge field.
Make sure you type any spaces or punctuation you want between two merge fields or after a mergefield.
3. When you finish editing the main document, click Save or Save As on the File menu. Name thefile and click Save.
STEP 4: PERFORM THE MERGE
To perform the merge, follow these steps:
1. On the Tools menu, click Mail Merge.This returns you to the Mail Merge Helper.
2. Under "3. Merge the Data with the Document," click Merge.Word displays the Merge dialog box. (If you click Query Options instead of Merge, you are giventhe option to select certain data records to include in the merge or to sort the records in the datasource.)
3. Under Merge To, select New Document to display the merged document on the screen.This allows you to view the document before printing it. (Select Printer to send the mergeddocument directly to the printer.)
4. With New Document selected in Merge To, click Merge.5. Once the merged document appears on the screen, you can save this as a separate document or you
can send the merged document to the printer by clicking Print on the File menu.
-
8/2/2019 Ibs Docs PTU Varun
59/63
SOFTWARE LAB X CS-320
59
EXPERIMENT NO: -21
AIM:-WRITE THE VARIOUS TYPES OF ADDRESSING TECHNIQUES USED IN MS-
EXCEL.
*VARUN KUMAR
*100610391681
There are three types of addressing techniques in MS-Excel. They are:
1. Relative: A relative address is a standard cell reference that appears like this: A1, E15, and M42.A relative address changes if you copy a formula that contains it to a new location on theworksheet. Think of it like saying "in two weeks" - the date will always be different (or relative)depending on the current date.
2. Absolute: An absolute address in a formula refers to a specific cell location or range. It alwayspoints to the location of a specific cell, even if you copy it. Absolute addresses are created byadding a $ sign in front of each character in the cell address. For example, $C$8 always refers tocell C8
3. Mixed: Mixed addresses are cell references that combine absolute and relative addressing,making either the row or the column absolute. Following are examples of mixed addresses:$A1,E$15,$C3. $A1 refers to an exact column, A, but leaves the row as a relative address.
-
8/2/2019 Ibs Docs PTU Varun
60/63
SOFTWARE LAB X CS-320
60
EXPERIMENT NO: -22
AIM: -WRITE ANY SIX TOOLS USED IN MS-WORD.
*VARUN KUMAR
*100610391681
Microsoft Excel is a commercial spreadsheet application written and distributedby Microsoft for Microsoft Windows and Mac OS X. It features calculation, graphing tools, pivot tables,and a macro programming language called Visual Basic for Applications. It has been a very widelyapplied spreadsheet for these platforms.
1. Worksheet: A worksheet is an electronic spreadsheet that lets you enter, analyze, and calculate data.Within a workbook, worksheets can share information, and calculations pertaining to severalworksheets can be performed at one time. The default number of worksheets in a new workbook isthree.
2. Summary function: A summary function is the workbook function used by Excel to interpret thedata in a pivot table. The Pivot Table Field dialog box lets you adjust summary functions
3. Sum: Adds the values in the function argument or the values in the cell references in the argument.
4. Pivot Table: PivotTables are interactive worksheet tables that allow you to summarize data withgreat flexibility. Their row and column headings can be adjusted to get different looks at originaldata.
5. Office Assistant: The Office Assistant gives you tips as you work, and it can be used to get helpabout Excel processes.
6. Formulas: A formula is a sequence of values, cell references, and operators that produces a newvalue from existing values. A formula always starts with an equal sign.
7. Comparison operators: Comparison operators are symbols used to specify criteria in searches andin formulas. The most common operators are, Equals, Greater than, Less than, Greater than or equalto, Less than or equal to, Not equal to.
8. Charts: Charts are graphic presentations of data from a worksheet.9. Cell Shading: Cell shading is the use of a color or a pattern to change its appearance.10.Average: Provides the average of the range of references in the argument.
-
8/2/2019 Ibs Docs PTU Varun
61/63
SOFTWARE LAB X CS-320
61
EXPERIMENT NO: -23
AIM: -WRITE STEPS TO PERFORM CONDITIONAL FORMATTING IN MS-EXCEL.
*VARUN KUMAR
*100610391681
Conditional formatting allows selecting one or more cells, and creating rules to format the cells. You cancontrol the cell font, fill color and border setting, based on the selected cell's contents, or based on thecontents of another cell.
If the rules (conditions) that you specified are met, then the formatting is applied.
For example, you can set conditional formatting so that a cell turns blue or green, based on its value.
In this example, you'll set conditional formats so that a cell:
turns blue if it contains a value higher than 75 and turns green if it contains a value lower than 50.
Follow these steps to apply conditional formatting to cells:
1. Select the cells to be formatted. In this example, cells B2:B4 are selected.
2. On the menu bar, choose Format>Conditional Formatting...
3. In the Conditional Formatting dialog box, leave the first drop-down box set to Cell Value Is
-
8/2/2019 Ibs Docs PTU Varun
62/63
-
8/2/2019 Ibs Docs PTU Varun
63/63
SOFTWARE LAB X CS-320