Scribd
Upload
196 views43 pages

FIT Record for BCA I Semester Lab

The document is a lab record for the Fundamentals of Information Technology course at Misbah Women's College, detailing practical exercises for MS Word, PowerPoint, Excel, and Access. It includes various tasks such as creating documents, presentations, worksheets, and databases, along with specific requirements for each exercise. The record certifies the completion of these practical exercises for a BCA I Semester student during the academic year 2024-25.

Uploaded by

fathimathzulfah
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
196 views43 pages

FIT Record for BCA I Semester Lab

The document is a lab record for the Fundamentals of Information Technology course at Misbah Women's College, detailing practical exercises for MS Word, PowerPoint, Excel, and Access. It includes various tasks such as creating documents, presentations, worksheets, and databases, along with specific requirements for each exercise. The record certifies the completion of these practical exercises for a BCA I Semester student during the academic year 2024-25.

Uploaded by

fathimathzulfah
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

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

[Link] 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

Common questions

Powered by AI

Animations and transitions in a business proposal presentation play a crucial role in maintain audience interest and emphasizing key points. They can guide the audience through the narrative by drawing attention to specific content or changes in topic. However, overuse might distract from the main message. Effective use involves subtle animations that enhance rather than overpower the content, contributing to a polished and professional presentation .

Mail merge in MS Word streamlines the process of sending personalized interview call letters by automating the insertion of specific details such as candidate names and interview details into a template. This process involves linking a document to a data source (like a list of names), ensuring accuracy and uniformity across all letters sent. It saves time, reduces errors from manually inputting individual information, and allows bulk distribution of personalized documents efficiently .

Formatting tools in MS Word, such as font styles, sizes, colors, table layout, and bullet points, enhance document presentation by improving readability, emphasizing key points, and organizing information clearly. In a professional setting, these features can be used to create polished reports, visually appealing presentations, and standardized organizational documents, helping to convey professionalism and clarity .

Using hyperlinks in MS PowerPoint for creating interactive quizzes allows users to navigate easily between questions and answers, creating a dynamic learning environment. By linking slides based on user choices (e.g., selecting correct or wrong answers), it enhances user engagement through a self-directed, interactive experience. This not only makes the presentation more engaging and interactive but also reinforces learning by providing immediate feedback .

Creating a pivot table in Excel involves selecting data and choosing 'Insert PivotTable'. Once the pivot table is created, employee data can be categorized by department by dragging and dropping fields into the row and values areas. To visualize this data, select 'Insert Pie Chart' from the pivot table options. This approach allows for efficient summarization and visualization of data, facilitating analysis of departmental distributions .

Electricity bills in Excel are calculated using conditional formulas based on tiered consumption rates. Data validation ensures that the current meter reading is greater than the previous, preventing errors in data entry. This is crucial for maintaining accurate billing records as it eliminates potentially incorrect data inputs, ensuring that the correct amounts are charged to customers according to their actual usage .

SmartArt and Shape tools in MS Word are crucial for visually representing data and ideas. They simplify complex information into easily understood graphics, such as flowcharts for processes and organization charts for company structure. The process involves selecting a SmartArt graphic from the 'Insert' tab, choosing a layout that fits the information, and customizing text and colors as needed. This helps in illustrating workflows or the hierarchy within organizations efficiently .

Excel formulas can categorize student grades using nested IF functions or VLOOKUP. For example, using IF statements, one could assign each student a grade by setting conditions: a value for distinction if averages are above a certain mark, lower thresholds for first and second classes, and a pass mark. This automated categorization ensures consistency and accuracy across large datasets .

Creating forms in MS Access allows users to easily input sales data into a structured format, ensuring data consistency and reducing entry errors. Generating reports enables quick visualization of sales trends by quarter or product, providing management with insights necessary for strategic planning and decision-making. This dual capability supports effective data collection and analysis, crucial for managing and understanding sales dynamics .

MS Access provides a robust platform for managing employee databases through structured storage, easy querying, and updating capabilities. Advantages include the ability to perform complex queries, such as listing employees by department or salary criteria, and efficiently updating records, such as applying salary increments, without altering the database's integrity. This enhances data management efficiency and accessibility in organizational contexts .

You might also like