DIRECTORATE OF TECHNICAL EDUCATION

Guindy, Chennai -25.

LABORATORY RECORD BOOK SUBMITTED IN PARTIAL

FULFILLMENTFOR THE AWARD OF THE CERTIFICATE OF

Certificate Course
in
Computer on Office Automation

Name : SATHASRINATH S
Registration Number :
Name of centre :
 DIRECTORATE OF TECHNICAL EDUCATION
Guindy, Chennai -25.

Certificate Course
in
Computer on Office Automation

CERTIFICATE

Certified that this is the bonafide record of work done by

SATHASRINATH S____________Reg. No _________________ in the

certificate course in Computer on Office Automation Laboratory and

submitted for the August 2022 examination held at the

Examination centre ___________________________________

Submitted for the practical examination held on ____________

Staff Incharge

Record marks

Internal Examiner External Examiner

 CONTENTS
Page
Sl.No Date Name of the Exercise Signature
no.
OPERATING SYSTEM
1 26/10/2022 Starting a program, running a program 3
Running multiple programs and switching
between windows Running a program from
explorer

2 29/10/2022 Customizing the Task bar, Making the 9

taskbar wider Controlling the size of start
menu options
Adding a program to the start menu

3 01/11/2022 Recycle bin, restoring the deleted files 15

Arranging icons on the Desktop
Creating Shortcuts. Adding a program
shortcut in the Desktop

4 04/11/2022 Creating and removing folders, renaming 21

folders and files Expanding and collapsing
a folder
Sorting a folder

5 07/11/2022 Displaying the properties for a file or folder 27

Using cut and paste operations to move a
file Using copy and paste operations to
copy a file

6 10/11/2022 Moving and copying files with mouse 30

Searching a file or folder by using search
command Recognizing File types using
icons
 Page
Sl.No Date Name of the Exercise Signature
no.
7 13/11/2022 35
Recording and saving an audio file
Connecting a printer to the PC
Capturing and saving entire monitor screen
& active program window as images

MS OFFICE: MS-WORD & OPEN OFFICE: WRITER

8 16/11/2022 Preparing a Govt. Order / Official Letter / 43
Business Letter / Circular Letter- Covering
formatting commands - font size and styles
- bold, underline, upper case, lower case,
superscript, subscript, indenting
paragraphs, spacing between lines and
characters, tab settings etc.

9 19/11/2022 Preparing a newsletter: To prepare a 49

newsletter with borders, two columns text,
header and footer and inserting a graphic
image and page layout.

10 22/11/2022 Creating and using styles and templates: 51

To create a style and apply that style in a
document
To create a template for the styles created
and assemble the styles for the template.

11 25/11/2022 Creating and editing the table : 57

To create a table using table menu
To create a monthly calendar using cell
Editing operations like inserting, joining,
deleting, splitting and merging cells
To create a simple statement for math
calculations viz. totaling the column.
 Page
Sl.No Date Name of the Exercise Signature
no.
12 28/11/2022 Creating numbered lists and bulleted lists: 63
To create numbered list with different
formats (with numbers, alphabets, roman
letters)
To create a bulleted list with different bullet
characters.

13 01/12/2022 Printing envelopes and mail merge: 67

To print envelopes with from addresses
and to addresses
To use mail merge facility for sending a
circular letter to many persons To use mail
merge facility for printing mailing labels.

14 04/12/2022 Using the special features of word: To find 77

and replace the text
To spell check and correct.
To generate table of contents for a
document To prepare index for a
document.

15 07/12/2022 Create an advertisement Prepare a 85

resume.
Prepare a Corporate Circular letter inviting
the shareholders to attend the Annual
Meeting.

MS OFFICE: MS-EXCEL & OPEN OFFICE: CALC & MATH

16 10/12/2022 Using formulas and functions: 95

To prepare a Worksheet showing the

monthly sales of a company in different
branch offices (Showing Total Sales,
Average Sales).
 Page
Sl.No Date Name of the Exercise Signature
no.
Prepare a Statement for preparing Result
of 10 students in 5 subjects (using formula
to get Distinction, I Class, II Class and Fail
under Result column against each student).

17 13/12/2022 Operating on the sheets: 99

Finding, deleting and adding records,
formatting columns, row height, merging,
splitting columns etc. Connecting the
Worksheets and enter the data.

18 16/12/2022 Creating a Chart: 103

To create a chart for comparing the
monthly sales of a company in different
branch offices.

19 19/12/2022 Using the data consolidate command: 105

To use the data consolidate command to
calculate the total amount budgeted for all
departments (wages, travel and
entertainment, office supplies and so on) or
to calculate the average amount budgeted
for – say, department office expenses.

20 22/12/2022 Sorting Data, Filtering Data and creation of 107

Pivot tables.

MS OFFICE: MS-ACCESS OPEN OFFICE: BASE

21 25/12/2022 Creating Student’s address Database and 117
then list the data on the screen in
alphabetical order.

22 28/12/2022 Performing various queries. 123

 Page
Sl.No Date Name of the Exercise Signature
no.
23 31/12/2022 Generating Query in Access 129
24 03/01/2023 Generating the Report from Database 133
25 06/01/2023 Importing and exporting data. 139

MS OFFICE: MS-POWER POINT & OPEN OFFICE: IMPRESS

26 09/01/2023 Creating a new Presentation based on a 147
template – using Auto content wizard,
design template and Plain blank
presentation.

27 12/01/2023 Creating a Presentation with Slide 151

Transition – Automatic and Manual with
different effects.

28 15/01/2023 Creating a Presentation applying Custom 153

Animation effects –Applying multiple effects
to the same object and changing to a
different effect and removing effects.

29 18/01/2023 Creating and Printing handouts. 155

INTERNET & INTRODUCTION TO VARIOUS DEVICES AND TOOLS

30 21/01/2023 Searching for a web site / application / text 161
documents viewing and downloading.

31 24/01/2023 Create an E-mail account, Retrieving 165

messages from inbox, replying, attaching
files filtering and forwarding

32 27/01/2023 Create Google form to collect data 171

33 30/01/2023 Create Google sheet to collect data 175

34 02/02/2023 Scan a photo using scanner and edit it 179

using tools available in operating system by
default.
OPERATING SYSTEM

1
Ex No: 1 Date:04/06/2022

a. Starting a program, running a program

b. Running multiple programs and switching between windows
c. Running a program from explorer

AIM : Starting a program, running a program

Procedure:

Step 1 : Click Start  Button

Step 2: Type the Application Name in Search Box. Excel

Step 3: Right-Click on the Excel Application and Click on

Open file location.

Step 4: Click on the Microsoft Excel 2010 icon then Press Keys + (Copy).

Step 5 : Press Keys Start  + 

Step 6 : In the box type shell:startup  OK

2
Step 7: Open Startup folder Press Keys +  (Paste.)

Step 8: Automatically run the Excel program after Restarting Computer.

Result:

The program was Executed Successfully and output is verified.

Output:

3
AIM : Running multiple programs and switching between windows

Procedure:

Step 1 : Press Keys Start  + 

Step 2 : In the box type Mspaint  OK and Calc OK.(Open More Application)

Step 3 : Press key +. Now you can easily switch from one application to

another application.

Step 4 : Press and hold +. A small box reveals all opened programs.

Step 5 : Release the  key but keep  pressed down; press  until you reach the

program you want.

Step 6 : Each time you press , you cycle through the icons representing open

programs.

Step 7 : Release the  key. Windows 10 switches to whichever program is selected.

Step 8 : To switch back to the last program that was active, simply press +

That program becomes the active program once again.

4
Result :

The program was Executed Successfully and output is verified.

Output:

5
AIM : Running a program from explorer

Procedure:

Step 1: Press Keys Start  + (Open Run window)

Step 2: In the box type explorer  OK

Step 3: Press Key (Start)  + My Computer - explorer will be Open.

Result:

The program was Executed Successfully and output is verified.

Output:

6
Ex No: 2 Date:07/06/2022

A. Customizing the Task bar, Making the taskbar wider

B. Controlling the size of start menu options
C. Adding a program to the start menu
AIM : Customizing the Task bar, Making the taskbar wider

Procedure:

Step 1:Right-click any empty area of the taskbar and click “Taskbar Settings” to

change taskbar settings.

Change Customizing the Task bar

Step 2: Lock the taskbar OFF / ON

Step 3: Automatically hide the taskbar in desktop mode OFF / ON

Step 4: Use small taskbar buttons OFF / ON

Step 5: Place your mouse at the top edge of the taskbar and drag to resize it.

7
 Making the taskbar wider

Step 6: Taskbar location on Screen Bottom or Left or Top or Right

Result:

The program was Executed Successfully and output is verified.

Output:

Change Task bar Size & location on right side

8
Aim: Controlling the size of start menu options

Procedure:

Step 1: Press Keys Start  Button .

Step 2: Select the top or side border, and then drag to your desired size.

Step 3: Right-click any empty area of the taskbar and click “Taskbar Settings” to

change taskbar settings  Personalization  Start, and then turn on Use Start

full screen.

Step 4: Show app list in Start menu ON/ OFF

Step 5: Show recently added apps ON/ OFF

Step 6: Show most used apps ON/ OFF

Step 7: Show suggestions occasionally in Start ON/ OFF

Step 8: Use Start full screen ON/ OFF

Step 9: Show recently opened items in Jump Lists on Start or the taskbar and File

9
Explorer Quick Access ON/ OFF

Result:

The program was Executed Successfully and output is verified.

Output:

Start Menu full screen.

10
AIM : Adding a program to the start menu

Procedure:

Step 1: Right-Click any Shortcut Icon on the Desktop

Step 2: Select on pop Menu Pin to Start.

Step 3: Click Start  Button

Step 4: See Now Shortcut Icon add on to the start menu

Step 5: If remove the Icon from Start Menu Right-Click any Shortcut Icon on the start

menu.

Step 6: Select on pop Menu Unpin from Start.

11
Result:

The program was Executed Successfully and output is verified.

Output:

12
Ex No: 3 Date:10/06/2022

A. Recycle bin, restoring the deleted files

B. Arranging icons on the Desktop
C. Creating Shortcuts. Adding a program shortcut in the Desktop

AIM: Recycle bin, restoring the deleted files

Procedure:

Deleted files or folders.

Step 1: Select file the files or folders you want to delete

Step 2: Press Delete Key and Click Yes.

Step 3: The files or folders Move to Recycle Bin.

Step 4: If need Permanent Deleted then Press Shift + Delete Key

+and Click Yes. Note : After Recover Not Possible.

Restoring files or folders.

Step 1: Open the Recycle Bin by double-clicking on its icon.

Step 2: Locate the items that you want to recover.

Stepp 3: Check the box next to the files or folders you want to

retrieve.

Step 4: Right-click and select restore to recover the items to their original locations.

Step 5: Select restore all items to restore everything in your recycle bin.

13
Result:

The program was Executed Successfully and output is verified.

Output:

Empty Recycle Bin – All File or Folder Move Source Location

Delete – All File or Folder Deleted to Permanent

14
AIM : Arranging icons on the Desktop

Procedure:

Auto Arrange Icons

Step 1: Press Click Start  +or navigate to the Windows desktop.

Step 2: Right-click a blank area on the desktop, Select View

Step 3: View  Auto arrange icons

Sort by Arrange Icons

Step 4: Right-click a blank area on the desktop, Select Sort by

Step 5: Arrange icons by Name, Type, Size or Date modified and then click

Arrange Icons.

Step 6: Auto Arrange want to arrange the icons on your own, click Auto Arrange to

remove the check mark.

15
Result:

The program was Executed Successfully and output is verified.

Output:

Right-click a blank area on the desktop, Select Sort by Arrange icons by Name,

Type, Size or Date modified and then click Arrange Icons.

16
AIM : Creating Shortcuts. Adding a program shortcut in the Desktop

Procedure:

Step 1: Press Click Start  Button.

Step 2: Browse to the Office program for which you want to create a desktop

shortcut.

Step 3: Left-click the name of the program, and drag it onto your desktop.

Step 4: Shortcut for the program appears on your desktop

Step 5: Right-click the program name or File or Folder and then click Send To 

Desktop (Create shortcut).

Step 6: A shortcut for the program appears on your desktop.

Result:

The program was Executed Successfully and output is verified.

Output:

17
Ex No: 4 Date: 13/06/2022

A. Creating and removing folders, renaming folders and files

B. Expanding and collapsing a folder
C. Sorting a folder

AIM : Creating and removing folders, renaming folders and files

Procedure:

Creating New Folder

Step 1: The fastest way to create a new folder in Windows is with the ++

Ctrl+Shift+N shortcut.
Step 2: Right-click on a blank space in the folder location.

Step 3: Select New  Folder from the contextual menu. Windows will create the

new folder at your current location.

Step 4: Enter your desired folder name to replace "New folder" and hit Enter.

Removing Files or folders

Step 1: Select file the files or folders you want to delete

Step 2: Press Delete Key and Click Yes.

Step 3: The files or folders Move to Recycle Bin.

Step 4: If need Permanent Deleted then Press Shift + Delete Key

18
+and Click Yes. Note : After Recover Not Possible.

Renaming Folders and Files

Step 1: Press Click Start  +  Button.

Step 2: Go to the location where stores your file or folder.

Step 3: Right click the name of the file or folder you wish to rename.

Step 4: Click Rename (on the menu that opens up).

Step 5: The fastest way to rename a folder or File Click File and Press Key

Step 6: Type a new name for the file or folder and press  Enter Key.
Result:
The program was Executed Successfully and output is verified.
Output:

19
AIM : Expanding and collapsing a folder

Procedure:

Step 1: Press Click Start  +  Button.

Step 2: View Navigation Pane  Show all folders (Click)

Step 3: Click the > (plus symbol) in the folder tree to expand a folder.

20
Step 4: You can also double-click a parent folder in the left or right pane to expand it.

Step 5: Click the V (minus symbol) in the folder tree to collapse a folder.

Result:

The program was Executed Successfully and output is verified.

Output:

 Expand One Level

 Expand Two Levels

 Expand Three Levels

 Expand All Levels

 Collapse All

21
AIM : Sorting a folder

Procedure:

Step 1: Press Click Start  +  Button.

Sort by Arrange folder

Step 2: Right-click a blank area on the file Explore, Select Sort by

Step 3: Select an option, such as name, Date, Size, Type, Date modified, and

Dimensions.

Step 4: The available options vary depending on the selected folder type.

 Ascending. Select to sort items in ascending order A-Z.

 Descending. Select to sort items in descending o

 rder Z-A.

Group by Arrange folder

22
Step 1: Right-click a blank area on the file Explore, Select Group by

Step 2: Select an option, such as Name, Date, Size, Type, Date modified.

Result:

The program was Executed Successfully and output is verified.

Output:

The File Explore, Select Sort by Arrange icons by Name, Type, Size or Date

modified click Arrange File and Folder. (Start  +  View Sort by)

23
Ex No: 5 Date:16/06/2022

A. Displaying the properties for a file or folder

B. Using cut and paste operations to move a file
C. Using copy and paste operations to copy a file

AIM : Displaying the properties for a file or folder

Procedure:

Step 1: Press Click Start  +  Button.

Step 2: To view information about a file or folder, Right-click it and select Properties.

Step 3: The fastest way to you can also select the file and press key Alt+ Enter.

Result:

The program was Executed Successfully and output is verified.

Output:

The file properties window shows you information like the type of file, the size of the

file, and when you last modified it. , Parent Folder, Free Space, Accessed.

24
AIM : Using cut and paste operations to move a file

Procedure:

Step 1: Press Click Start  +  Button.

Step 2: To cut file or folder Select then Right-click it and select Cut.

Step 3: The fastest way to you can also select the file and press key +

Step 4: Right-click a blank area on the file Explore, Select Paste.

Step 5: The fastest way to you can also select the file and press key +

Result:

The program was Executed Successfully and output is verified.

Output:

+  +

25
AIM : Using copy and paste operations to copy a file

Procedure:

Step 1: Press Click Start  +  Button.

Step 2: To Copy file or folder Select then Right-click it and select Copy.

Step 3: The fastest way to you can also select the file and press key +

Step 4: Right-click a blank area on the file Explore, Select Paste.

Step 5: The fastest way to you can also select the file and press key +

Result:

The program was Executed Successfully and output is verified.

Output:

+  +

26
Ex No: 6 Date:19/06/2022

A. Moving and copying files with mouse

B. Searching a file or folder by using search command
C. Recognizing File types using icons

AIM : Moving and copying files with mouse

Procedure:

Step 1: Step 1: Press Click Start  +  Button.

Step 2: To Copy file or folder Select then left-click and HOLD. (Copy)

Step 3: You release the left mouse button the file will be moved to the new location where

you released the mouse button. (Paste)

Step 4: To Copy file or folder Select then Right-click and HOLD.

Step 5: Select copy here then new location move here

Result:

The program was Executed Successfully and output is verified.

Output:

Select File or Folder Right Click Mouse Select Copy new location Right Click

Mouse Select Paste.

27
AIM : Searching a file or folder by using search command

Procedure:

Step 1: Press Click Start  +  Button.

Step 2 : Select Search Local Drive Like C:\ D:\ E:\ This PC to look in all devices or

Folder

Step 3: Right Corner show Search Quick access

Step 4: Enter Search Key word “COA” after Press Enter or Click 

Output:

28
Aim : Recognizing File types using icons

Procedure:

Step 1: Press Click Start  +  Button.

Sort by Arrange Icons

Step 2: Right-click a blank area on the file Explore, Select Sort by

Step 3: Select an option, such as name, Date, Size, Type, Date modified, and

Dimensions.

Step 4: The available options vary depending on the selected folder type.

 Ascending. Select to sort items in ascending order A-Z.

 Descending. Select to sort items in descending order Z-A.

29
Group by Arrange icons

Step 1: Right-click a blank area on the file Explore, Select Group by

Step 2: Select an option, such as Name, Date, Size, Type, Date modified.

Result:

The program was Executed Successfully and output is verified.

Output:

The File Explore, Select Group by Arrange icons by Name, Type, Size or Date
modified click Arrange Icons. (Start  +  View Group by)

30
Ex No: 7 Date:22/06/2022

A. Recording and saving an audio file

B. Connecting a printer to the PC
C. Capturing and saving entire monitor screen & active program window as
images

AIM : Recording and saving an audio file

Procedure:

Step 1: Press Click Start  Button

Step 2: Type search bar in the bottom-left corner of the Windows 10 screen

Step 3: Type “Voice Recorder”

Step 4: Click on “Voice Recorder”

Step 5 : Press key Ctrl + R Recording will be Start.

Step 4: Start speaking

Step 5: Press key Backspace Key Record will be Stop then file will save

31
automatically.

Result:

The program was Executed Successfully and output is verified.

Output:

Ctrl + R Recording Start

Backspace Key  Recording Stop

Recoding Save Automatically

32
AIM : Connecting a printer to the PC

Procedure:

Step 1: Press Click Start  Button

Step 2: Type search bar in the bottom-left corner of the Windows 10 screen

Step 3: Type “Devices and Printers”

Step 4: Click on “Printer & Scanners”

33
Step 5: Connect Printer to computer and Power ON.

Step 6: Click on Add a printer or Scanner

Step 7: Wait for it to find nearby printers, then choose the one you want to use, and

select Add device.

Result:

The program was Executed Successfully and output is verified.

Output:

34
AIM : Capturing and saving entire monitor screen & active program window as

images

Procedure:

Step 1: The PRINT SCREEN key is usually located in the upper right corner of your

keyboard. The key looks similar to the following:


Step 2: The text you see on your keyboard might be PrtSc, PrtScn, or PrntScrn. The

other text on the Print Screen key is usually SysRq.

Copy only the image of the active window

The active window is the window that you are currently working in. Only one window

can be active at a time.

Step 3: Click the window that you want to copy.

Step 4: Press ALT+PRINT SCREEN.

Step 5: Paste (CTRL+V) the image into an Office program or other application.

Copy the entire image on the screen

Step 6: Open everything you want to copy and position it the way you want.

Step 7: Press PRINT SCREEN. (If you Used Laptop then Fun or Start + PrtSC)

Step 8: Paste (CTRL+V) the image into an Office program or other application

Result:

The program was Executed Successfully and output is verified.

Output:

Alt + PrtSc – Copy Active window

35
MS OFFICE: MS-WORD

&

OPEN OFFICE: WRITER

36