Karuna - MBA IT Lab Record

KARUNA P.G.
COLLEGE OF
COMPUTER APPLICATIONS
Koheda Road, Mangalpally (V), Ibrahimpatnam (M), R.R.Dist. 501 510.
This is to certify that Mr/Ms. ____________________,

of MBA I Year I Semester, bearing Hall Ticket Number
2356-12-672-______has
successfully
completed
his/her
practical record work on Information Technology Lab(IT

Lab) in the academic year 2012-13.
Internal
Examiner
External
Examiner
KARUNA P.G. COLLEGE OF

BUSINESS MANAGEMENT
Koheda Road, Mangalpally (V), Ibrahimpatnam (M), R.R.Dist. 501 510.
This is to certify that Mr/Ms. ____________________,

of MBA I Year I Semester, bearing Hall Ticket Number
2130-12-672-______has
successfully
completed
his/her
practical record work on Information Technology Lab(IT

Lab) in the academic year 2012-13.
Internal
Examiner
External
Examiner
INDEX
SNO
NAME OF THE PROGRAM
MS EXCEL
1
CREATING EXCEL WITH EDITING, COPY

AND PASTE
CREATE STUDENT DATA IN EXCEL FIND

SUM,AVG ,RESULT AN D DIVISION
CREATE A PIE CHART
FILL THE DATA
CREATE A MACRO
NPV CALCULATION
MS ACCESS
7
CREATE A EMPLOYEE TABLE
CREATE A QUERY
CREATE A EMPLOYEE FORM
10
CREATE A EMPLOYEE REPORT
11
TRANSFER A DATA FROM ACCESS TO

EXCEL
EXCERCISE:-1
Create an Excel Sheet in the Name of xyz show the functioning

of Editing and Printing of Excel Sheet.
Procedure
STEP-1: Open a Excel Sheet by following procedure.
Go to
START MENU=>
PROGRAMS=>
MSOFFICE=>
OPEN MS EXCEL.
STEP-2: Create an Excel Sheet with the Name of xyz by the
Field Names.
S.L.no Name of the
Address of employee
employee
STEP-3: Insert 5 records according to the requirement.
STEP-4: The Excel Sheet can be Edited and Printed by the
Following procedure.
EDITING:
CUT OPTION
Go To EDIT MENU=>Click on CUT (ctrl+X)

COPY OPTION
Go To EDIT MENU=> Click on COPY (ctrl+C)
PASTE OPTION
Go To EDIT MENU=> Click on PASTE (ctrl+V)
PRINTING:
PRINT OPTION
Go To FILE MENU=> Click on PRINT(ctrl+P)

STEP-5: Save the excel sheet after completion.
OUTPUT-:
Output showing functions of

Editing and Printing.
EXCERCISE:-2
Create an Excel Worksheet with the Following Particulars using

Formula Functions
ROLL NO, NAME, MARKS, AVERAGE, RESULT&DIVISION?
PROCEDURE
STEP-1: Open a Excel Sheet by following procedure.
Go to
START MENU=>
PROGRAMS=>
MSOFFICE=>
OPEN MS EXCEL.
STEP-2: Create columns with the following field names given
below.
ROLL NO
NAME
MARKS
AVERAGE
RESULT
DIVISION
STEP-3: Insert the 5 records with values.

STEP-4:
Calculation of Total
TOTAL=SUM (C2:E2)
Calculation of Average
AVERAGE=F2/3
Calculation of Result
RESULT=IF (AND (C2>=40, D2>=40, E2>=40),"pass,
fail")
Calculation of Division
DIVISION=IF (H2="pass, IF(G2>=70,"FD",
IF (G2>=60,"FC", IF (G2>=50,"SC","TC"))),
"Fail")
OUTPUT-:
Output showing calculation of

TOTAL, AVERAGE, RESULT, DIVISION.
EXCERCISE:-3
Illustrate the Creation of Pie-chart in MS-Excel for total

number of accidents in Hyderabad, with the following values.
30,20,5,7,20,30,40,50,20,30,70,30
PROCEDURE
STEP-1: Open a excel sheet by following procedure.
Go to
START MENU=>
PROGRAMS=>
MS OFFICE=>
OPEN MS EXCEL.
STEP-2: Create an Excel sheet with the following field names and
Insert the data.
MONTH
ACCIDENTS
STEP-3: Select the table created and click on the chart wizard and
Select the chart type and click next.
STEP-4: The next step is selecting the Chart source and click next.
STEP-5: The next step is to select the chart options that is titles,
Legend & labels click next.
STEP-6: The next step is to give the chart location, select the
Location and click next.
STEP-7: After selecting the above options the pie-chart will be
displayed on the excel sheet, save the excel sheet.
OUT PUT-:
Output showing the pie-chart .
EXCERCISE:-4
Create a Excel Worksheet with the days of the week and time from
9:00to17:00 hrs use auto fill option to create this Work Sheet.
PROCEDURE
Go to
START MENU=>
PROGRAMS=>
MSOFFICE=>
OPEN MS EXCEL.
STEP-2: Create columns with the following field names.
STEP-3: On the worksheet in the first column insert MONDAY
And then bring the cursor on the right corner of the cell
And drag. All the days of week will be displayed
Automatically.
STEP-4: In the second cell enter the time as 9:00 and drag the Cell
In the horizontal way till 17:00 hrs are Displayed using
Auto fill features.
OUTPUT-:
Output showing the

Preparation of time table using auto fill option.
EXCERCISE:-5
Use of Macro in Excel.

PROCEDURE
Introduction: Micro are very widely used in the most of the

companies where one step has to be done repeatedly is acts like a tape
recorder and also used for the automation of some manual work which
can be done through the
System using Macro function (like copying, pasting, retrieval of the
data from the database.

Go to
START MENU=>
PROGRAMS=>
MS OFFICE=>
OPEN MS EXCEL.
STEP-2: Recording a Macro; Go to Tools, select Record
New
Macro.
STEP-3: Give name to Macro name.
STEP-4: Click on the record button and perform the task as
required And reclick to stop recording of the same.
STEP-5: Run macro; To run macro, go to tools then select macro
and again select macros from the cascading menu. It will give u list
of existing macros. Select the one you need to run. It will
automatically do the task to be performed at the active or the
selected cells.
OUT PUT-:
EXCERCISE:-8
NPV calculation
Data
Description
10%
Annual discount rate
10,00
0
Initial cost of
investment
3,000
Return from first year
4,200
Return from second

year
6,800
Return from third year
.
PROCEDURE
Go to
START MENU=>
PROGRAMS=>
MS OFFICE=>
OPEN MS EXCEL.
STEP-2:
NPV is given by:-$1 n years from now = 1/(1+r)n ,$today.

(assume r=1)For both the investments enter the data in the first
rowAnd Second row.
The syntax for the Npv function is:
Npv( discount_rate, value1, value2, ... value_n )
discount_rate is the discount rate for the period.
value1, value2, ... value_n are the future payments and income for the investment (ie: cash
flows).
Output:
MS Access
Access is a database program that stores information that can be manipulated,
sorted, and filtered to meet your specific needs.
A database is a collection of related information.

An object is a competition in the database such as a table, query, form, or
macro.
A table is a grouping of related data organized in fields (columns) and
records (rows) on a datasheet. By using a common field in two tables, the
data can be combined. Many tables can be stored in a single database.
A field is a column on a datasheet and defines a data type for a set of values
in a table. For a mailing list table might include fields for first name, last
name, address, city, state, zip code, and telephone number.
A record in a row on a datasheet and is a set of values defined by fields. In
a mailing list table, each record would contain the data for one person as
specified by the intersecting fields.
Tables
1. Create a Employee table in Ms-access with Field names Empid, Ename,

Eadd, Edeptno.
Step: 1
Create a table in Design View
Step.2:
Give the field names with data types and save the table.
Step 3: Enter the table fields
Queries
Queries select records from one or more tables in a database so they can be
viewed, analyzed, and sorted on a common datasheet. The resulting collection of
records, called a dynaset (short for dynamic subset), is saved as a database object
and can therefore be easily used in the future. The query will be updated whenever
the original tables are updated.
Creating a Query in Design View

2. Create a Query in Ms-access
Step: 1 In the object field select create Query
Step 2: Add a table
Step 3: Select the fields to display
Step 4: select Empid,Ename from the table
Step 5: After selecting the fields you have to execute the Query in Tools Menu Select
Run Command to Run the Query.
Step 6: After displaying the query you have to save the query.
Forms
Forms are used as an alternative way to enter data into a database table.
Creating a Form by Using Wizard

3. Create a form in Ms-access
Step 1: In the Object Field Select a Form and click on Creating form by Using Wizard.
And select the Field Names.
Step 2: Select Layout of Your Form
Step 3: Select the style of the form
Step 4: Give the title Name for the Form
Step 5:
After giving the title name Click next Button it displays the form
Reports
Reports will organize and group the information in a table or query and provide a
way to print the data in a database.
Creating a Report by Using the Wizard

4. Create a Report for a Table
Step: 1 In the Object Field select Report and Click Create a Report by Using Wizard
Step 2: Select the Fields and Click Next
Step 3: Do you want to sort the data if you need select sort option, if you dont need
Click Next Button.
Step 4: Select the report Style
Step 5: Give the title for your Report
Step 6: And Click Next to Display the form
5. Transfer a Data from Access to Excel

Step: 1
Step: 2
Create Data Base

create a table in Design View
Step.2:
Give the field names with data types and save the table.
Step 3:
Open Excel Document
Click Data Menu
Click Import External Data
Step 4: Select Data Base Name

Karuna - MBA IT Lab Record

Uploaded by

Copyright:

Available Formats

Karuna - MBA IT Lab Record

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Karuna - MBA IT Lab Record

Uploaded by

Copyright:

Available Formats

KARUNA P.G.

This is to certify that Mr/Ms. ____________________,

practical record work on Information Technology Lab(IT

KARUNA P.G. COLLEGE OF

This is to certify that Mr/Ms. ____________________,

practical record work on Information Technology Lab(IT

NAME OF THE PROGRAM

CREATING EXCEL WITH EDITING, COPY

CREATE STUDENT DATA IN EXCEL FIND

CREATE A PIE CHART

FILL THE DATA

CREATE A EMPLOYEE TABLE

CREATE A EMPLOYEE FORM

CREATE A EMPLOYEE REPORT

TRANSFER A DATA FROM ACCESS TO

Create an Excel Sheet in the Name of xyz show the functioning

Go To EDIT MENU=>Click on CUT (ctrl+X)

Go To FILE MENU=> Click on PRINT(ctrl+P)

Output showing functions of

Create an Excel Worksheet with the Following Particulars using

STEP-3: Insert the 5 records with values.

STEP-5: Save the excel sheet after completion.

Output showing calculation of

Illustrate the Creation of Pie-chart in MS-Excel for total

Output showing the pie-chart .

Output showing the

Use of Macro in Excel.

Introduction: Micro are very widely used in the most of the

STEP-1: Open a excel sheet by following procedure.

STEP-3: Give name to Macro name.

STEP-4: Click on the record button and perform the task as

required And reclick to stop recording of the same.

STEP-5: Run macro; To run macro, go to tools then select macro

Annual discount rate

Return from first year

Return from second

Return from third year

NPV is given by:-$1 n years from now = 1/(1+r)n ,$today.

A database is a collection of related information.

1. Create a Employee table in Ms-access with Field names Empid, Ename,

Create a table in Design View

Step 3: Enter the table fields

Creating a Query in Design View

Step 2: Add a table

Step 3: Select the fields to display

Step 4: select Empid,Ename from the table

Creating a Form by Using Wizard

Step 2: Select Layout of Your Form

Step 3: Select the style of the form

Step 4: Give the title Name for the Form

Creating a Report by Using the Wizard

Step 2: Select the Fields and Click Next

Step 4: Select the report Style

Step 5: Give the title for your Report

Step 6: And Click Next to Display the form

5. Transfer a Data from Access to Excel

Create Data Base

Step 4: Select Data Base Name

You might also like