Madan Bhandari Memorial College

New Baneshwor, Kathmandu

“Lab Report on IIT”

Submitted By: Submitted To:

Ashwin Pandey Phul Babu Jha
Roll no: 04 Madan Bhandari Memorial
Section: „B‟ College
Bsc.CSIT 1st Semester
 Table of Contents

Lab Details Submission Grade Signature

Date
1 1. MS-DOS

1.1. To create directory using Cd

and Md.

1.2. To make directory in C root,

create a file, type your
information, save and edit it.

2 2. Excel

2.1. Result Ledger of 10 students.

2.2. Customer Purchase Bill.

2.3. Bar Graph of Marks.

2.4. Pie-Chart of Companies

Count.

2.5. Pie-Chart of Amount.

2.6. Salary sheet using nestedif,

counta, countif, sumif, sum,
vloopup.

2.7. Electricity Bill of NEA.

3
LAB -1: MS-DOS

1.1. Create directory of your name and use the following commands.
i. CD
ii. RD

Result:
Steps Used:
1. Created a directory using MD.
C:\Users\Dell>md Ashwin

2. Went to created directory using CD.

C:\Users\Dell>cd Ashwin

3. Moving out from recently created directory using CD.

C:\Users\Dell\Ashwin>cd..

4. Remove a directory using RD.

C:\Users\Dell>rd Ashwin

5. To check whether the file has been deleted/removed by

using „dir‟ command.
C:\Users\Dell>dir
 1.2. Make a directory of your name in C root. Also, create a file on it
and type your information on it, save it and edit it.

Result:
Steps Used:
1. Got into C root by using Cd.. twice.
C:\Users\Dell>cd..
C:\Users>cd..

2. Created a directory using MD.

C:\>md Ashwin

3. Went to created directory using CD.

C:\>cd Ashwin

4. To create a file inside the created directory.

C:\Ashwin>copy con (file name).txt

5. Saving the file using Ctrl+Z.

^Z
1 file(s) copied.

6. To open the saved file.

C:\Ashwin>type (file name).txt
7. To edit the saved file.
C:\Ashwin>(file name).txt

Before editing:

8. To open the edited file.

C:\Ashwin>type (file name).txt

After editing:
LAB - 2: Microsoft Excel

2.1. Prepare a result ledger of 10 students.

Given:

o Total number of subjects = 5

o Each subject pass marks= 40 and full marks = 100

Calculate the following using formula:

1. Total marks obtained.
2. Percentage obtained.
3. Result (Pass/Fail) and
4. Grades
Grades condition:
i. 90 and above = A+
ii. 80-90 = A
iii. 60- 80 = B
iv. 40-60 = C

Result:
Formula Used:
1) To calculate Total Marks Obtained.

2) To calculate Percentage.

3) To calculate Grade.

4) To calculate Result.
 2.2. Prepare following customer purchase bill in MS-Excel.
Calculate the following using formula:

i. Discount (10%)
ii. Net Amount
iii. VAT (13%)
iv. Service Charge
v. Grand Total

Result:
Formula Used:
1) To calculate Amount.

2) To calculate Total.

3) To calculate Discount.

4) To calculate Net Amount.

5) To calculate VAT.

6) To calculate Service Charge.

7) To calculate Grand Total.

.
 2.3. Make a bar graph of a table data provided:

Bar Graph:

Steps Used:
1. To convert table in Bar Graph, select the entire table and
click insert and then insert the Bar Chart.
 2.4. Make a Pie-Chart of a data provided:

Pie-Chart:

Steps Used:
1. To place a data in Pie-Chart, select the entire table and click
insert and then insert the Pie-Chart.
 2.5. Make a Pie-Chart of a data provided:

Pie-Chart:

Steps Used:
1. To place a data in Pie-Chart, select the entire table and click
insert and then insert the Pie-Chart.
2.6. Mark a salary sheet by using of formula.
Sum, Nestedif, Counta, Countif, Sumif, Vlookup

1. How many employees in computer, finance, electrical

department?
2. How many basic salaries in computer department only?
3. Manoj, Ashish post.
4. If total salary is greater than 20000 then “A”, If total salary
is greater than 10000 then “B”, otherwise “C”.
Result:
Formula Used:
1) To calculate Dearness Allowances.

2) To calculate House Rent Allowances.

3) To calculate Provident Fund.

4) To calculate Total.

5) To calculate Grade.

6) To calculate Number of People in Computer Department

using Countif.

7) To calculate Number of People in Electrical Department using

Countif.

8) To calculate Number of People in Finance Department using

Countif.

9) To calculate Total Basic Salary in Computer Department.

10) To find post of Manoj.

11) To find Grade of Manoj.

12) To find post of Ashish.

13) To find Grade of Ashish.

 2.7. Make an electricity bill of NEA-New Baneshwor Branch
with following condition:
i. Cost up to 25 units: Rs.125
ii. VAT =13%

Result:
Formula Used:
1) To find Payable Unit.

2) To calculate Total.

3) To calculate Total Amount.

4) To calculate VAT.

5) To calculate Net Payable Amount.

LAB -3: MS-ACESS

THEORY:

Microsoft Access is a powerful and user-friendly database management

system that allows users to organize and manipulate large amounts of data.
With Access, users can create tables, forms, reports, and queries to efficiently
store, input, and retrieve information. Access also offers a range of advanced
features such as data validation, multi-user access, and the ability to create
custom functions using Visual Basic for Applications. One of the key benefits
of Access is its integration with other Microsoft Office applications, allowing
for easy data sharing and analysis. However, Access has its limitations, such
as a maximum file size of 2GB and the potential for data corruption if not
properly maintained. Despite these drawbacks, Microsoft Access remains a
popular choice for small to medium-sized businesses and individuals looking
for a cost-effective and customizable database solution.

Basic parts of MS Access window:

The following are the basic parts of the Microsoft Access Window:
1. Tables
2. Queries
3. Forms
4. Reports
5. Macros
6. Modules
7. Relationships
 3.1. Create a database given below.

Steps:

1. Open Microsoft Access and click on "Blank Database" to

create a new database.

2. Give name for Database “Student” and choose location to

save it.

3. In the Navigation Pane on the left side of the screen, click on

“Table Design” to create a new table.
4. In the “Table Design” view, create fields for the
student‟s information such as “Class”, “Section”, “Roll
No”, “Name”, “Status”, “DOB” and “Remarks.”

5. Save the table and fill the table with 5 data.

6. In the "Queries" group, click on "Query Design" and select the

table and click add.

7. Then add the contents of table and sort name column in the
ascending order and save it.

8. The table will look like:

9. Similarly, create query named “Senior” and in the
status column: criteria row type “Senior” and save
the query.

10. To prepare form simply click on “form” and access

will create based on your design. Save the form.
 3.2. Create a database given below.

Steps:

1. Open Microsoft Access and click on "Blank Database" to

create a new database.

2. Give name for Database “Library” and choose location to

save it.

3. In the Navigation Pane on the left side of the screen, click on

"Table Design" to create a new table.
4. In the "Table Design" view, create fields given in question and
save it as “Book”.

5. Fill at least 5 data records.

6. In the "Queries" group, click on "Query Design" and select the

table and click add.

7. Then add the required contents on table and give name “qbook”
and save it.
 To display all records on the basics of price more than $10.

1. Click on "Query Design" in the "Queries" group to enter the query

design view.

2. In the "Query Design" view, locate the "Price" field from the book
table and drag it onto the query design grid.

3. In the "Criteria" row under the "Price" field, enter " >10 "
(without quotes) to specify the condition that the price should be
greater than 10.

4. Give the name and save the query.

5. The query results will display the books with a price greater than
10.

 Prepare a form on the basis of table.

1. To prepare form simply click on “form” and access will create

based on your design and save the form.
 Prepare a report on the basis of query named "q book".

1. To prepare report simply click on “report” and access will

create based on your design. Save the report on the name of
“q_book”.
LAB -4: MS-POWERPOINT

THEORY:

MS-PowerPoint is a presentation software that helps us to create

combination of various slides depicting a graphical and visual
interpretation of data, to present information in a more creative and
interactive manner. By default, presentations are saved with the .pptx
extension.

This is how a PowerPoint window looks like when the application

is first opened.
 4.1. How to create PowerPoint presentation and mention the
following.

a) Add transition effect

b) Custom Animation
c) Insert master slide
d) Insert speaker notes
e) Apply design

Step 1: The presentation is created in the PowerPoint. So, the first step
is to launch the application. You can directly search the
application or use run to open PowerPoint.

Here is how to open MS PowerPoint using RUN.

o Click the button windows + R at the same time.

o Write PowerPoint in open option in run file.
o Press OK button and now MS-PowerPoint file is open.

Step 2: When you launch the PowerPoint program you may be

prompted to pick what kind of document you want to create.
But you can choose blank presentation. Then you can choose
the design you want.
MS-PowerPoint has various themes using which background
color and designs or textures can be added to a slide. This
makes the presentation more colorful and attracts the attention
of the people looking at it.

Given below are the steps to apply theme in PowerPoint:

o Click the Design ribbon.

o Select one of the themes that suit your requirements.
 o To edit the theme for a specific slide, right-click on the
desired theme and select.

You can also add different design to only one slide. To add a
different design on only one slide, select the slide want to
change which will open a pop-up as the big slide in the screen
then you can you can right click the design you want for this
slide and select „Apply to Selected slide‟.

Step 3: Create the title page for the slide.

Generally, MS-PowerPoint will give you the title page

layout where you can add title and your name. You can click the
first box that says „Click to add Title‟ and add the title of your
presentation. Click the bottom box to add your name or any
other subtitle you want. The font of text and size can be
adjusted as you want and you can move these boxes where you
prefer to make more attractive. You can also add image on it.
Step 4: Add more slide to the presentation to represent the information.
All the information or data cannot be entered on only one slide.
So, the new slide is needed to enter the data and the data not to
be congested. You can add the by right-clicking at the left slide
where the entire slide is located and select „New Slide‟. A new
slide will appear. You can also add new slide by clicking „New
Slide‟ in toolbar.

You can also use shortcut key Ctrl+M to add a new slide.

Step 5: MS-PowerPoint also have a special feature of graphical

representation. To make the presentation more attractive charts,
pictures, graphs, etc. can be inserted in the slide.
You can insert a chart, picture, graphs or any other graphics on
the slide by clicking on the „Insert‟ tab at the top of the window.
At the „Insert‟ tab you can see various options that can be
entered in the slide as show in the figure.

You can also insert pictures and graphics from the empty box.
The same option can be seen on these as the toolbar and you can
select what you want to insert.
Step 6: The transitions can be added between slides to have effect when
the slides are changed.

You can add the transitions in between the slides from the
„Transition‟ tab at the top of the page. You can scroll through
all the option of transitions and select the one you like.

You can apply different transition for each slide by selecting

transition for each slide or same transition for all by clicking the
„Apply to All‟ button. The sound can be also add to the
transition and you can also add the time to the transition to
perform the automatic transition between slides.

Step 7: Add the custom animation on objects on the slides.

PowerPoint offers animation support which can be used
effectively to add some motion in a monotonous presentation
and make it more interesting. Animation can be applied to any
object on the slide and the motions can be automated, timed or
triggered.

The following steps will help you add and preview animations
in the slide.

o Go to the Animation ribbon and click on the Animation

Pane to display the animation sidebar.
o Select one of the objects in the slide and click on Add
Animation menu option.
 o Choose one of the Animation options.

o Once you add the animation for an object, it will show up

in the animation pane.
o By default, all the animations are initiated by a click, but
you can change this.
o From the timing section, you can also manipulate the
animation timings.
o To preview the animation settings, just click Play on
animation pane.

Step 8: Adding the slide master to the slide.

You can create the slide master with nested layout slides and
apply a combination of texts, images, or videos on each slide.

On the slide master, you can define the master layout for the
presentation.
 We can insert slide master by following steps:

o After opening the presentation, click View and the Slide

Master.
o Select the master slide and click the Master Layout button on
the top ribbon.
o You can select a placeholder for the title, date, folder, or
slide number. These options are automatically applied to all
layouts and slides.

Step 9: Adding the speaker notes to the slides.

Speaker notes are a short paragraph that reminds the speaker of

the contents of the current slide in the slide shows. One of the
features of speaker note is it is not visible to the audience during
the presentation.

We can add speaker note by two simple ways. One is by using

notes pane and another is by using the note page.

a) Adding speaker notes using the notes pane

Select the slide that you want to add notes by clicking on
it on the title of slides on the left side of window. Click
on the Notes pane to position your cursor there and type
your notes in the field.

b) Adding speaker notes using the notes page

You can also add notes using the „Note page‟ that is on
the View tab of the ribbon. To add the notes click on the
View tab on the ribbon and select the „Note Page‟ then
the new window appears which shows the current slide
and a text area on which you can enter your notes.

Step 10: The end step of the presentation is to play the presentation.
Once you have completed all your slides, click the „Slide Show‟
tab at the top of the page or you can use shortcut key F5 and
select „From the Beginning‟. You can go through your entire
slideshow.
LAB - 5: Microsoft Word

5.1. Design an ID Card.

Reg No. 45780 Madan Bhandari Memorial College

New Baneshwor, Kathmandu

Student Name - Ashwin Pandey

Code - 2279632
Batch - B.Sc. CSIT - 2079
Address - Tarkeshwor-8, Ktm
D.O.B. - 18-10-2005
Phone No. - 9843057145
Validity Date - 2083-12-30
………..…………
Signature
 5.3. Write the steps to the following with shortcut keys.

a. Cut and Paste

b. Copy and Paste
c. Find and Replace the text
d. Spelling Checking
e. Insert Chart
f. Insert Tables and Columns

THEORY:

Microsoft Word is a word processor developed by Microsoft. It

allows us to create, edit, format, save, print, delete, and view a
multidirectional text document. We can create and edit letters, reports,
invoices, emails, and books in the Microsoft word.
This is how a MS-Word window looks like when the application is
first opened.

The above example shows how the general window of Microsoft word
looks like and it can be differed from different versions of it. Generally,
the opened windows show the home section and document area of
Microsoft word as shown on the illustration above, Ms Word is divided
into various sections. Some of the basic‟s sections of MS-word are title
bar, mean bar, quick access toolbar, ribbon, ruler, document area and
status bar.
The document area is the main section of the MS-word where text is
entered and edited.

o Cut and paste

The cut and paste means moving text or image from a part of
the document area to the desirable location.

Any text or image can be cut and paste by following below

steps:
Step 1: Select the text or image that you want to cut and paste.
Step 2: You can cut the text by clicking on cut option in
home tab or shortcut can be used. the shortcut for cut
is CTRL+X.
Step 3: Place the cursor where you want to insert the image or
text.
Step 4: Image or text can be pasted by clicking on paste
option in home tab or the shortcut key can be used.
The shortcut for paste is CTRL+V.

o Copy and paste

The cut and paste means copying or making duplicate of text or

image from a part of the document area to the desirable location.
Any text or image can be copy and paste by following below
steps:
Step 1: Select the text or image that you want to copy and paste.
Step 2: You can copy the text by clicking on copy option in
home tab or shortcut can be used. The shortcut for
 cut is CTRL+C.
Step 3: Place the cursor where you want to insert the image or
text.
Step 4: Image or text can be pasted by clicking on paste
option in home tab or the shortcut key can be used.
The shortcut for paste is CTRL+V.
o Find text

Find helps in finding any word in the document.

Following are some steps to find word from the document.
Step 1: To use the find feature you can use shortcut
CTRL+F or can be used manually by clicking the
find option from home.
Step 2: The navigation pane is opened after clicking the find.
Step 3: Click in the search document and type the text you want
to find. The search runs automatically and results are highlighted
in the document.

o Replace text

If you want to replace a word from the document into another

word the replace will make it easy for you.
 Text can be replaced in word by following steps.

Step 1: To find and replace the text you can use shortcut
CTRL+H or can be used manually by clicking the find
option from home.

Step 2: The find and replace dialog box is opened.

Step 3: Type the word you need to replace in the find what
text field.

Step 4: Type the word you need to replace in the replace with
text field.

Step 5: Click on replace if you want to replace only one word

or replace all to replace all matched text.

o Spelling checking

Ms-word has a special feature called spell check that allows you
to check spelling and grammatical mistakes in the documents. In
Ms-word, word‟s spell check function is set to automatically
check spelling while you type.

The spelling can also be checked manually. Steps for checking the
spelling of word in document are:

Step 1: On the navigation menu bar click on the review

option.

Step 2: Next click on the spellings and grammar option.

 Step 3: There is a spelling mistake in the document then a
dialog box will appear with text in the red underline.

Step 4: Select the correct spelling from the suggestion menu.

o Insert chart

Microsoft word has a special feature that helps to present

the information graphically in the form of charts. Graphical
representation of data helps in much better understanding of
information than the text.

Here are some steps to insert chart in the documents.

Step 1: Place the curser where
you want to insert chart.
Step 2: Click the insert tab.
Step 3: Click the chart button in the illustrations group.
(There are varieties of charts types and some chart types
are better at displaying certain data than others)
 Step 4: Select a chart type.
(Each chart type has a few styles to choose from which
present the data differently)

Step 5: Select the chart style and click ok.

o Insert Table

A table is a structure of vertical columns and horizontal

rows with a cell at every intersection. Each cell contains text or
graphics, and you can format the table in any way you want.
Usually the top row in the table is kept as a table header and
can be used to put some informative instructions.

Steps for creating a table

Step 1: Click the Insert tab.

Step 2: After clicking on insert tab the Table button will appear.
Click on the table button.
This will display a simple grid.

Step 3: As the grid will appear, the grid can be selected to

make table of rows and columns as you like.

The table is created at the place where the cursor is at the content of
table can be entered.