LAB FILE

Information Technology
Code: IT 402

Grade X

ACADEMIC YEAR: Session 2021-2022

NAME: …………………………………………

ROLL. NO: …………………………………………

Guided by:
Ms. Bhagyashree Chinchore
PGT Computer
 INDEX
S. Page Date of
List of Experiments Signature
No Number Submission
Write the steps to insert an image in MS
1 Word 3

Write the steps to create a template in MS

2 Word 4

Write the steps to implement mail merge in

3 MS Word 5-6

Write the steps to create table of contents

4 7
Write the steps to create reference to other
5 document by using keyboard & mouse. 8

Write the concept of Relative and Absolute

6 reference in Spreadsheet. 9

Write the syntax and example of “Create

7 Table” Command. 10-11

Write the syntax and example of “Insert

8 into” Command. 12-13

Write the syntax and example of “Select

9 Statement”. 14-15

Define Blog and write its steps

10 16-17
Program No. 1

Aim: Write the steps to insert an image in MS Word

Method 1: Use “Insert” Tab

1. To begin with, place your cursor right at the position where a picture goes.
2. Then click “Insert” tab.
3. Next, click “Picture” in “Illustrations” group.
4. Now choose a picture in “Insert Picture” window.
5. Click “Insert” button to finish the job.

Method 2: Paste a Picture

1. Locate the picture you need first.

2. Then right click it.
3. Choose “Copy”.
4. Next right click on your Word document.
5. Choose “Paste (P)” option.

Method 3: Drag and Drop

1. Similarly, locate the target picture first.

2. Then click to select it.
3. Drag and drop it on your document.

Method 4: Choose “Link to File”

1. First repeat from step 1 to step 4 in “Use ‘Insert’ Tab”.

2. Now click the upside-down triangle behind “Insert” button.
3. Next choose “Link to File” option on the menu.
4. When using the above steps to insert a picture, you can go to change the
original picture. For example, we add a rectangle mark on the picture.
5. Now you reopen the documents, and you can see the picture has been
updated.
Program No. 2

Aim: Write the steps to create a template in MS Word

In Microsoft Word, you can create a template by saving a document as a .dotx file,
.dot file, or a .dotm fie (a .dotm file type allows you to enable macros in the file).

Newer versions

1. Click File > Open.

2. Double-click This PC. (In Word 2013, double-click Computer).
3. Browse to the Custom Office Templates folder that’s under My
Documents.
4. Click your template, and click Open.
5. Make the changes you want, then save and close the template.

Office 2010

You can start with a blank document and save it as a template, or you can create a
template that is based on an existing document or template.

Start with a blank template

1. Click the File tab, and then click New.

2. Click Blank document, and then click Create.
3. Make the changes that you want to the margin settings, page size and
orientation, styles, and other formats.
4. You can also add content controls such as a date picker, instructional text,
and graphics that you want to appear in all new documents that you base on
the template.
5. Click the File tab, and then click Save As.
6. Give the new template a file name, select Word Template in the Save as
type list, and then click Save.
7. Close the template.
Program No. 3

Aim: Write the steps to implement mail merge in MS Word

Mail Merge: Mail Merge is most often used to print or email form letters to
multiple recipients. Using Mail Merge, you can easily customize form letters for
individual recipients. Mail merge is also used to create envelopes or labels in bulk.

1. In a blank Microsoft Word document, click on the Mailings tab, and in

the Start Mail Merge group, click Start Mail Merge.
2. Click Step-by-Step Mail Merge Wizard.

3. Select your document type. In this demo we will select Letters. Click Next:
Starting document.
4. Select the starting document. In this demo we will use the current (blank)
document. Select Use the current document and then click Next: Select
recipients.
o Note that selecting Start from existing document (which we are not
doing in this demo) changes the view and gives you the option to
choose your document. After you choose it, the Mail Merge Wizard
reverts to Use the current document.
5. Select recipients. In this demo we will create a new list, so select Type a
new list and then click Create.
o Create a list by adding data in the New Address List dialog box and
clicking OK.
o Save the list.
o Note that now that a list has been created, the Mail Merge Wizard
reverts to Use an existing list and you have the option to edit the
recipient list.
o Selecting Edit recipient list opens up the Mail Merge
Recipients dialog box, where you can edit the list and select or
unselect records.
o Click OK to accept the list as is.
o Click Next: Write your letter.
6. Write the letter and add custom fields.
o Click Address block to add the recipients' addresses at the top of the
document.
o In the Insert Address Block dialog box, check or uncheck boxes and
select options on the left until the address appears the way you want it
to.
o Note that you can use Match Fields to correct any problems.
Clicking Match Fields opens up the Match Fields dialog box, in
which you can associate the fields from your list with the fields
required by the wizard.

7. Press Enter on your keyboard and click Greeting line... to enter a greeting.
8. In the Insert Greeting Line dialog box, choose the greeting line format by
clicking the drop-down arrows and selecting the options of your choice, and
then click OK.
9. Note that the address block and greeting line are surrounded by chevrons («
»). Write a short letter and click Next: Preview your letters.
o Preview your letter and click Next: Complete the merge.
o Click Print to print your letters or Edit individual letters to further
personalize some or all of the letters.
Program No. 4

Aim: Write the steps to create table of contents

You cannot generate any automatic tables without first using styles effectively
throughout your document. Microsoft Word can scan your document and find
everything in the Heading 1 style and put that on the first level of your table of
contents, put any Heading 2’s on the second level of your table of contents, and so
on.
If you want an automatic table of contents you need to label all of your chapter
titles and front matter headings (e.g. “Dedication” and “Acknowledgements”) in
the style Heading 1. All major headings within your chapters should be labeled
Heading 2. All subheadings should be labeled Heading 3, and so on.
If you have used Heading styles in your document, creating an automatic table of
contents is easy.

1. Place your cursor where you want your table of contents to be.
2. On the References Ribbon, in the Table of Contents Group, click on the
arrow next to the Table of Contents icon, and select Insert Table of
Contents….
o Note: If you are using Word 2013, this option is called Custom Table
of Contents.
3. If you want to change the style of your table of contents (e.g. you want
more space between the items on level 1 and level 2 of your table of
contents, or you want all your level 1 items to be bold), click on
the Modify button, select the TOC level you want to change, then click
the Modify button to do so.
4. If you want to change which headings appear in your table of contents, you
can do so by changing the number in the Show levels: pulldown.
5. Click OK to insert your table of contents.

The table of contents is a snapshot of the headings and page numbers in your
document. At any time, you can update it by right-clicking on it and
selecting Update field. Notice that once the table of contents is in your document,
it will turn gray if you click on it. This indicates that it is getting information from
somewhere else.
Program No. 5

Aim: Write the steps to create a reference to other documents by using keyboard
& mouse.

Steps to reference from other sheet by Mouse

1. Place the cursor at required position in the cell and type "=" sign
2. Open the sheet whose data u want to insert in the cell selected in 1 point
3. Now click on the required cell in the sheet opened in point no. 2
4. After selecting the cell click on right sign near formula bar
5. The current cell value will be shown in the sheet opened in point no. 1

Steps to reference from other sheet by KB

1. Place the cursor at required position in the cell and type "=" sign
2. Open the sheet whose data u want to insert in the cell selected in 1 point
3. Now click on the required cell in the sheet opened in point no. 2
4. After selecting the cell click on right sign near formula bar
5. The current cell value will be shown in the sheet opened in point no. 1
Program No. 6

Aim: Write the concept of Relative and Absolute reference in Spreadsheet.

❖ The key difference between relative and absolute cells is that relative cell

references move when you copy them, but absolute references do not.

❖ Absolute references are noted by a dollar sign in front of the cell reference.

❖ A relative cell reference might look like =A1+A2

❖ An absolute reference might look like =$A$1+$A$2.

Program No. 7

Aim: Write the syntax and example of “Create Table” Command.

SQL DML and DDL

SQL can be divided into two parts: The Data Manipulation Language (DML) and
the Data Definition Language (DDL).

The query and update commands form the DML part of SQL:

⮚ SELECT - extracts data from a database

⮚ UPDATE - updates data in a database

⮚ DELETE - deletes data from a database

⮚ INSERT INTO - inserts new data into a database

The CREATE TABLE statement is used to create a table in a database.

SQL CREATE TABLE Syntax

CREATE TABLE table_name
(
column_name1 data_type,
column_name2 data_type,
column_name3 data_type,
....
)

The data type specifies what type of data the column can hold.
CREATE TABLE Example
Now we want to create a table called "Persons" that contains five columns: P_Id,
LastName, FirstName, Address, and City.
We use the following CREATE TABLE statement:
CREATE TABLE Persons
(
P_Id int,
LastName varchar(255),
FirstName varchar(255),
Address varchar(255),
City varchar(255)
)

The P_Id column is of type int and will hold a number. The LastName, FirstName,
Address, and City columns are of type varchar with a maximum length of 255
characters.
The empty "Persons" table will now look like this:
P_Id LastName FirstName Address City
Program No. 8

Aim: Write the syntax and example of “Insert into” Command.

The empty table can be filled with data with the INSERT INTO statement.

The INSERT INTO Statement: The INSERT INTO statement is used to insert a
new row in a table.

SQL INSERT INTO Syntax

It is possible to write the INSERT INTO statement in two forms.

1. The first form doesn't specify the column names where the data will be
inserted, only their values:

INSERT INTO table_name VALUES (value1, value2, value3,...)

2. The second form specifies both the column names and the values to be
inserted:

INSERT INTO table_name (column1, column2, column3,...)

VALUES (value1, value2, value3,...)

SQL INSERT INTO Example

We have the following "Persons" table:

P_Id LastName FirstName Address City

1 Hansen Ola Timoteivn 10 Sandnes

2 Svendson Tove Borgvn 23 Sandnes

3 Pettersen Kari Storgt 20 Stavanger

Now we want to insert a new row in the "Persons" table.

We use the following SQL statement:

INSERT INTO Persons VALUES (4,'Nilsen', 'Johan', 'Bakken 2', 'Stavanger')

The "Persons" table will now look like this:

P_Id LastName FirstName Address City

1 Hansen Ola Timoteivn 10 Sandnes

2 Svendson Tove Borgvn 23 Sandnes

3 Pettersen Kari Storgt 20 Stavanger

4 Nilsen Johan Bakken 2 Stavanger

Program No. 9

Aim: Write the syntax and example of “Select Statement”.

The SQL SELECT Statement: The SELECT statement is used to select data from a
database. The result is stored in a result table, called the result-set.

SQL SELECT Syntax

SELECT column_name(s)
FROM table_name

and
SELECT * FROM table_name

An SQL SELECT Example

The "Persons" table:
Command: Select * from persons
P_Id LastName FirstName Address City

1 Hansen Ola Timoteivn 10 Sandnes

2 Svendson Tove Borgvn 23 Sandnes

3 Pettersen Kari Storgt 20 Stavanger

Now we want to select the content of the columns named "LastName" and
"FirstName" from the table above. We use the following SELECT statement:
SELECT LastName, FirstName FROM Persons

The result-set will look like this:

LastName FirstName

Hansen Ola

Svendson Tove

Pettersen Kari
SELECT * Example
Now we want to select all the columns from the "Persons" table.
We use the following SELECT statement:
SELECT * FROM Persons

Tip: The asterisk (*) is a quick way of selecting all columns!

The result-set will look like this:
P_Id LastName FirstName Address City

1 Hansen Ola Timoteivn 10 Sandnes

2 Svendson Tove Borgvn 23 Sandnes

3 Pettersen Kari Storgt 20 Stavanger

The SQL SELECT DISTINCT Statement

In a table, some of the columns may contain duplicate values. This is not a
problem, however, sometimes you will want to list only the different (distinct)
values in a table.
The DISTINCT keyword can be used to return only distinct (different) values.
Program No. 10

Aim: Define Blog and write its steps

A blog is a discussion style site used by non-technical (or technical users) users for
creating personal web pages. Blogs are similar to an online personal diary and
simple to use.

You can use a blog to convey messages about events, announcements, news,
reviews, etc.

Blogs are usually managed using a web browser and this requires active internet
connection.

You can also use offline blog software to create content first and later publish the
content when an active internet connection is available.

Some of the popular blogs include:

• www.WordPress.com

• www.blogger.com

• www.blog.com

• www.weebly.com

• www.blogsome.com

WordPress is free web service that you can use to create a beautiful website or
blog. WordPress has support for “themes” for customizing the design of a blog.
Themes can make the blog or the webpage look attractive. Before you start using a
blog, a blog account is required. To create one, you need a web browser and an
internet connection.

• Open the Web Browser.

 • On the address bar type https://signup.WordPress.com/signup/. You should now
get to a page with the fields Blog address, Username, Password, Email Address
and Language.

❖ Blog Address: You must provide a unique address to your WordPress Blog.
This is the address which others will use to view your blog.
❖ Username: You should choose a username for managing this blog.

❖ Password: Securing your WordPress blog account with a strong password is

important. A combination of uppercase and lowercase letters with some
digits along with symbols would be a strong enough password. You need to
enter the password twice.
❖ Email Address: You must provide your Email Address here. An activation
link will be send to you from WordPress after you click “Create Blog”.
❖ Language: You can choose your own language for blogging from the list
given.
❖ Click Create Blog. On doing so, you will be sent an email for activating your
blog account. Open your email and click on the activation link. Once you
click Activate Blog, you will be redirected to your WordPress Blog