IT and Applications BBA I/I
Lab Topics: IT and Applications
EXERCISE: BASIC COMPUTER OPERATION
1. Discuss the steps used in booting process.
2. Explain the steps used during restart and shut down of computer.
3. Describe the operation of different keys available in a keyboard.
4. Explain the operation of an inkjet printer and laser printer.
5. Explain the working principle of scanner.
6. Write down the lab safety measures.
EXERCISE: COMPUTER COMPONENTS
1. What is SMPS? Explain its operation.
2. Explain the various components available on mother board.
3. List and describe the different ports present in the motherboard.
4. Explain the CMOS set up and ROM BIOS.
5. Describe the various types of expansion slots.
6. Explain the working principle of A/D and D/A converters.
EXERCISE: MS DOS COMMANDS AND WINDOWS OS
1. Write the DOS commands for doing the following with proper syntax:
a. Create a directory named BBA under C:\
b. Change the directory to BBA.
c. Display all the files and sub directories in C:\ starting with a particular letter.
d. Create a file under the directory BBA and enter the address in to it.
e. Copy the file with a specific extension name from one directory to the other.
f. Display the date and time information.
g. Rename the file.
h. Delete all the files starting with a specific letter in a directory.
i. Delete all the files in a directory.
j. Remove a directory.
2. Start the PC to get the windows desktop. Identify all the components of the desktop and
write them.
Lab Topics Page | 1 Er. Sanjay Kumar Sah
IT and Applications BBA I/I
3. Perform the following in windows operating system and show them to the teacher.
a. Create a folder.
b. Create a shortcut to an item on the desktop.
c. Quickly find files and folders.
d. Open file explorer.
e. Change windows taskbar properties and restore them.
f. Change system date and time and restore them.
g. Pin and unpin the items to the task bar.
h. Open and work with Notepad.
i. Open and work with MS Paint.
j. Open and work with Media Player.
k. Open and work with system tools.
4. Write down the steps to install windows operating system in a PC.
EXERCISE: MS WORD
1. Perform the following using the MS Word and show them to the teacher.
a. Create a new document
b. Open an existing document
c. Save the document
d. Exit Word
2. Study and write the purpose of the following menu items.
a. Style Menu
b. Font Menu
c. Font size
d. Alignment
e. Line spacing
f. Making lists with Numbering
g. Making lists with Bullets
h. Highlight
3. Study and write the purpose of the following text formatting items in the MS Word.
a. Text Font
b. Font style
c. Font color
d. Making text Bold/Italic/Underline
e. Strikethrough
f. Subscript/Superscript
g. Outline
h. Sentence case
Lab Topics Page | 2 Er. Sanjay Kumar Sah
IT and Applications BBA I/I
4. Study and write the purpose of the following paragraph formatting items in the MS Word.
a. Text Alignment
b. Indenting a paragraph
c. Align left
d. Line spacing
e. Justify
5. Perform the following tasks in the MS Word and write the steps.
a. Insert a symbol in a word document.
b. Insert a clipart in a word document.
c. Insert a picture in a word document.
d. Create a header and footer in a word document.
e. Create a Table in a word document.
f. Add rows and columns to the table.
g. Perform spell check in a document.
PROJECT WORK: Using MS Word perform the following projects
1. Create your resume with the following specifications and submit the print out to your
teacher.
a. Table to show qualifications with heading.
b. Left & Right margins
c. Page numbers in the footer on the right side.
d. Use Watermark.
2. Prepare a class timetable using merge rows, split row, insert rows, columns and submit the
print out to your teacher.
EXERCISE: MS EXCEL
1. Perform the following in the MS Excel and show them to your teacher using Excel.
a. Open an existing workbook.
b. Select a cell in a worksheet.
c. Copy the text in the cell to another cell.
d. Wrap text.
e. Delete a cell entry
f. Save a file.
g. Create a new workbook.
2. Prepare a class timetable using merge rows, split row, insert rows, columns and submit the
print out to your teacher.
Lab Topics Page | 3 Er. Sanjay Kumar Sah
IT and Applications BBA I/I
PROJECT WORK: Using MS Excel perform the following projects
1. Create a spreadsheet to calculate HRA, DA, TA, PF, LIC. Gross Salary, Net Salary from
the below given data:
HRA=18% of basic Pay
TA=12% of Basic Pay
DA=15% of Basic Pay
PF =10% of Basic Pay
LIC =7% of Basic Pay
Deduction= PF + LIC
Gross Salary = Basic Pay + HRA + DA + TA
Net Salary = Gross Salary – Deduction
2. Create an EXCEL worksheet to analyze the marks of the students of a class using various
Charts (Line, XY, Bar and Pie).
EXERCISE: MS POWERPOINT
1. Perform the following tasks and show them to your teacher using power point.
a. Create a new presentation.
b. Open an existing presentation.
c. Save a presentation.
d. Add new slides.
e. Show the different views.
f. Delete a slide.
g. Reposition a slide.
h. Hide a slide during slide show.
i. Insert animation.
j. Advance slides automatically.
k. Exit MS PowerPoint
l. Take a print out.
PROJECT WORK: Using MS PowerPoint perform the following projects
1. Create a presentation of your institute showing the departments, faculties and facilities
available in your institute. Insert images of your institute and also use animations.
2. Create a presentation for introducing yourself showing your details, photo, education,
Reference etc. using the various features studied above.
3. Create a presentation of any company showing its various functionalities using the various
features studied above.
Lab Topics Page | 4 Er. Sanjay Kumar Sah
IT and Applications BBA I/I
EXERCISE: INTERNET AND EMAIL
1. Define internet and explain how do computer connects to the internet.
2. What is the difference between webpage and website?
3. Write short notes on
a. URL
b. E-Mail
c. Pop-up
d. HTTP
e. IP Address
f. MAC Address
4. Explain the steps to create an account in Gmail?
5. Explain the steps to send an E-Mail?
6. How to change a Google (Gmail) account password? Explain.
Lab Topics Page | 5 Er. Sanjay Kumar Sah
