BBA-407: Computer Oriented Practical & Viva Voce
Cover Page
College Name: _______________________
Student Name: _______________________
Enrollment No.: _____________________
Course: Bachelor of Business Administration (BBA)
Subject Code: BBA-407
Subject Name: Computer Oriented Practical & Viva Voce
Submitted To: _______________________
Session: 2024-25
BBA-407: Computer Oriented Practical & Viva Voce
Index
Index
1. Introduction to MS Word ............................................. 1
2. Creating a Resume in MS Word .................................. 3
3. Working with Spreadsheets in MS Excel ..................... 5
4. Payroll Calculation using Excel .................................. 7
5. Creating Charts in Excel ............................................. 9
6. Introduction to PowerPoint ......................................... 11
7. Creating a Business Presentation in PowerPoint ......... 13
8. Basic Internet Usage & Email ..................................... 15
9. Online Forms & Google Docs ...................................... 17
10. Viva Voce Preparation ................................................ 19
BBA-407: Computer Oriented Practical & Viva Voce
Practical 1: Introduction to MS Word
Objective: To learn the basic interface and functions of Microsoft Word.
Tools Used: Microsoft Word
Procedure:
- Open MS Word
- Learn to create, save, and open documents
- Learn formatting: font, paragraph, bullets, alignment
Result: Successfully created a formatted document.
BBA-407: Computer Oriented Practical & Viva Voce
Practical 2: Creating a Resume in MS Word
Objective: Design a professional resume
Tools Used: Microsoft Word
Procedure:
- Use a resume template
- Add personal, academic, and skill details
- Use table and formatting
Result: Resume created and saved as PDF.
BBA-407: Computer Oriented Practical & Viva Voce
Practical 3: Working with MS Excel
Objective: Learn Excel interface, formulas, and functions
Tools Used: Microsoft Excel
Procedure:
- Create a table of student marks
- Use SUM, AVERAGE, MAX, MIN functions
Result: Computed student performance successfully.
BBA-407: Computer Oriented Practical & Viva Voce
Practical 4: Payroll Calculation
Objective: Calculate employee salary
Tools Used: MS Excel
Procedure:
- Input: Basic Pay, HRA, DA, Bonus
- Formula: Gross Pay = Basic + HRA + DA + Bonus
Result: Payroll generated automatically.
BBA-407: Computer Oriented Practical & Viva Voce
Practical 5: Creating Charts
Objective: Present data visually
Tools Used: MS Excel
Procedure:
- Use existing data
- Create pie chart, bar chart, and line chart
Result: Data visualized with appropriate charts.
BBA-407: Computer Oriented Practical & Viva Voce
Practical 6: Introduction to MS PowerPoint
Objective: Understand PowerPoint basics
Tools Used: MS PowerPoint
Procedure:
- Create slides
- Add text, images, transitions
Result: Presentation with 5 slides created.
BBA-407: Computer Oriented Practical & Viva Voce
Practical 7: Business Presentation
Objective: Design a business topic presentation
Tools Used: PowerPoint
Procedure:
- Choose a topic (e.g., Digital Marketing)
- Add 6-8 slides with animations
Result: Professionally designed business presentation.
BBA-407: Computer Oriented Practical & Viva Voce
Practical 8: Internet Usage & Email
Objective: Learn safe and effective browsing & emailing
Tools Used: Web Browser, Gmail
Procedure:
- Use Google Search
- Send and receive email with attachment
Result: Email sent with proper subject and file.
BBA-407: Computer Oriented Practical & Viva Voce
Practical 9: Google Forms & Docs
Objective: Learn to create online forms
Tools Used: Google Forms, Google Docs
Procedure:
- Create a survey form
- Share link and collect responses
Result: Form created and responses recorded.
BBA-407: Computer Oriented Practical & Viva Voce
Practical 10: Viva Voce Preparation
Sample Questions:
1. What is the difference between hardware and software?
2. What are the basic components of MS Excel?
3. How do you insert a chart in Excel?
4. What are formulas and functions in Excel?
5. Explain the difference between Save and Save As.
6. What is the use of MS PowerPoint in business?
7. Name three email service providers.
8. What is the internet and how does it work?
9. How can you protect your computer from viruses?
10. What are cloud services? Give examples.
