FUNDAMENTALS

OF
INFORMATION
TECHNOLOGY

LAB RECORD

1|Page
 MISBAH WOMEN’S COLLEGE
Katipalla – 575030

This is to certify that

Ms._______________________________________________ has satisfactorily
completed the list of Practical Exercises in BCA I Semester (FIT) as prescribed
by the Mangalore University for the Degreecourse,conducted in this college
during the year 2024-25.

Principal Lecturer in Charge Head of the Department

Date: ____________

Name of the Candidate:

Register No. :

Examination Centre:

Date of Examination :

EXAMINERS

1.

2.

2|Page
 Index
Part-A MS WORD
Ex. Title Page
no No.
1 Prepare a document using different formatting tools
2 Prepare a Document Using Smart Art And Shape tools
a) flowchart
b) organization chart
3 a) Prepare a document with a table to store sales details of company for different
quarters and calculate total, average and find maximum, minimum sales value.
b) Create a timetable
4 Prepare interview call letters for five candidates describing about the company
and instruction about the interview. Use mail merge feature.

Part-B MS POWERPOINT
Ex. Title Page
no No.
1 Create a presentation (minimum 5 slides) about your college. It should contain
images, chart, bulleted text, ...
2 A simple quiz program. Use hyperlinks to move another slide in the presentation
to display the result and correct answer/wrong answer status. Use at least four
questions
3 Create a presentation for a business proposal.
4 Create a presentation for a college project.

Part-C MS EXCEL
Ex. Title Page
no No.
1 Create a worksheet to maintain student information such as Roll no, Name, Class,
Marks in Three Subject Of 10 Students. Calculate Total Marks, Average And Grade.
Find grade for distinction, first class, second class, pass and fail using normally used
conditions.
2 Prepare a worksheet to store details of electricity consumed by customers. Details
are consumer number, customer name, meter no, previous meter reading, current
meter reading of 10 customers. Calculate total number of units consumed and total
amount to be paid by each consumer using following condition:
3 Create employee worksheet having Emp No, Emp Name, Doj, Department,
Designation And Basic Pay Of 8 Employees. Calculate DA, HRA, Gross Pay,
Profession Tax, Net Pay, Provident Fund as per the rule.
4 Create another sales in the same worksheet to store Salesman Name, Zone Name,
Place, Name Of The Item Sold, Rate Per Unit, Quantity Sold. Calculate Total Sales
Amount Of Each Salesman. Referring The Commission Table, write the formula to
compute the commission to be given.

3|Page
 Part-D MS ACCESS
Ex. Title Page
no No.
1 Create Employee Database And Table Emp Using Ms Access With Following
Structure.
2 Create the 'order' database and a table 'orderdtl' having following records
3 Create a 'stock' database 'inventory' table:
4 Create a “company” database having “sales” table with field salid, quarter,
product, no_of_sales.

4|Page
 PART A
MS WORD

5|Page
1. PREPARE A DOCUMENT USING DIFFERENT FORMATTING TOOLS

6|Page
2. PREPARE A DOCUMENT USING SMART ART AND SHAPE TOOLS.

a)FLOWCHART

7|Page
b) ORGANIZATION CHART

3. a)Prepare a document with a table to store sales details of company for different quarters and
calculate total, average and find maximum, minimum sales value.

8|Page
b) Create a timetable

4. Prepare interview call

letters for five candidates
describing about the
company and
instruction about the
interview. Use mail
merge feature.

9|Page
10 | P a g e
11 | P a g e
 PART B
MS
POWERPOIN
T

12 | P a g e
1. Create a presentation (minimum 5 slides) about your college. It should contain images,
chart, Bulleted text, ….

13 | P a g e
14 | P a g e
2. A simple quiz program. Use hyperlinks to move to another slide in the presentation to
display the result and correct answer/wrong answer status. Use at least four questions

15 | P a g e
16 | P a g e
17 | P a g e
18 | P a g e
19 | P a g e
20 | P a g e
21 | P a g e
22 | P a g e
23 | P a g e
3. Create a presentation for a business proposal (minimum 5 slides). ❖ Slides must include
company logo in header ❖ A title slide with table of contents ❖ Financial data of the
company in the table ❖ Company sales and profit in charts ❖ Make use of animation and
transition

24 | P a g e
25 | P a g e
4. Create a presentation for a college project (minimum 5 slides) ➢ Master slide ➢ Add
comments for each slide ➢ Add header and footer ➢ Add source citation ➢ Make use of
animation and transition

26 | P a g e
27 | P a g e
28 | P a g e
PART C
29 | P a g e
 MS EXCEL

1. Create a worksheet to maintain student information such as RollNo, Name, Class, Marks in
three subjects of 10 students. Calculate total marks, average and grade. Find grade for
Distinction, First class, Second class, Pass and Fail using normally used conditions. • Using
custom sort, sort the data according to class Distinction first, First Class next, and so on.
Within each class, average marks should be in descending order. • Also draw the Column
Chart showing the RollNo versus Average scored

30 | P a g e
2. Prepare a worksheet to store details of Electricity consumed by customers. Details are
Customer No, Customer Name, Meter No, Previous meter reading, Current meter reading of

10 customers. Calculate total number of units consumed and total amount to be paid by
each consumer using following conditions: • If unit consumed is up to 30, charge is 100. • 31
to 100 units, 4.70 per unit • 101 to 200 units, 6.25 per unit • Above 200 units, 7.30 per unit.

31 | P a g e
 Use Data validation to see that current reading is more than previous reading.

Arrange the records in the alphabetic order of names

Filter the records whose bill amount is more than Rs.1500.

3. Create Employee worksheet having EmpNo, EmpName, DOJ, Department, Designation and
Basic Pay of 8 employees. Calculate DA, HRA, Gross Pay, Profession Tax, Net Pay, Provident
Fund as per the rule
 DA = 30% of basic pay
 HRA = 10% of basic pay if basic pay is less than 25000, 15% of basic pay otherwise.
 Gross =DA +HRA+ Basic pay
 Provident fund =12% of Basic pay or Rs.2000, whichever is less.

32 | P a g e
  Profession Tax= Rs.100 if Gross pay is less than 10000, Rs.200 otherwise.
 NetPay = Gross - (Professional tax + Provident Fund)

 Using Pivot table, display the number of employees in each department and represent it
using Pie chart.

4. Create a table COMMISSION containing the percentage of commission to be given to

salesmen in different zones as follows:

Create another table SALES in the same worksheet to store salesman name, zone name, place,
name of the item sold, rate per unit, quantity sold. Calculate total sales amount of each salesman.
Referring the COMMISSION table, write the formula to compute the commission to be given.
(Hint: Use if function and absolute cell addresses)

33 | P a g e
 Using

advanced filtering show the result in other parts of the worksheet.

SHOW THE RECORDS OF EAST AND WEST ZONES.

34 | P a g e
Show the records of various zones separately

35 | P a g e
Display the details of the items sold more than 50, in South or North zones.

36 | P a g e
 PART D
MS ACCESS

1.Create Employee database and table Emp using MS ACCESS with following Structure.

37 | P a g e
 Perform following operation

a)List all the Employees who are working in Dept no.10

b)
List
all
the

Employees who get less than 20000 Salary

38 | P a g e
c). Update Salary by adding the increments as per the following:-

i. 10% Increment in Basic Salary who get < 20000

ii. 5% Increment in Basic Salary who get >=20000.

2.
Create
the “
Order”
database and a table “Orderdtl‟ having following records:

39 | P a g e
Execute following Query

a) Display all the Order No. which have not been yet Delivered.

40 | P a g e
b) Display all the Orders of LED Monitor and CPU.

C) Display all the Orders of LED Monitor and CPU which are not have been delivered yet

3. Create a “Stock‟ database having “Inventory‟ table.

41 | P a g e
Execute following Query

a) Calculate the closing stock of each item (Closing Stock = Opening Stock + Purchase – Sales)

b) Display all the Items which has closing stock < 100

c) If closing stock is less than 100 then set the remark as “Re-Order Level” otherwise “Enough Stock”

4. Create a “Company” database having “Sales” table with fields sale ID, quarter, product,
no_of_sales.

42 | P a g e
Perform the following:

A. Design a form to insert records to sales table

B. Generate a report to display sales details of product based on quarters

43 | P a g e