EXPERIMENT -1
OBJECTIVE: - To create a ppt on Competitive Programming using features like
Presentation Slides, Editing Slides, Format Editing and Slide Master.
INTRODUCTION: - Competitive programming is a coding sport that enhances
problem-solving, algorithmic thinking, and speed. It strengthens DSA knowledge, boosts
career opportunities, and prepares for contests like Codeforces, ACM ICPC, and Google
Code Jam.
TOPICS COVERED: -
What is Competitive Programming
Why should we do Competitive Programming?
Key Concept in Competitive Programming
Commonly used Data Structure
Tools and Research for Competitive Programming
Strategies to improve in Competitive Programming
CONCLUSION: - In conclusion, competitive programming is a powerful way to improve
problem-solving skills, coding efficiency, and algorithmic thinking. It not only helps in
cracking technical interviews but also fosters a passion for logical problem-solving. With
consistency and practice, anyone can excel in this field and open doors to exciting career
opportunities in tech.
EXPERIMENT -2
OBJECTIVE: - Briefly explain all the options on the menu bar of the Microsoft Excel
with the help of an example in a PowerPoint presentation.
INTRODUCTION: - The Excel Menu Bar, located at the top of the screen, provides
easy access to essential features like File, Home, Insert, and Data. It organizes commands for
tasks such as formatting, creating formulas, managing data, and printing, making it an
essential tool for efficient spreadsheet management.
TOPICS COVERED: -
Introduction
Home Tab
File Tab
Insert Tab
Page Layout
Formula Tab
Data Tab
Review Tab
View Tab
Help Tab
Examples
Conclusion
CONCLUSION: - The MS Excel Menu Bar is a powerful tool that provides access to
essential features for data management, analysis, and visualization. From the Home tab for
basic formatting to the Formulas tab for complex calculations, each menu plays a crucial role
in enhancing productivity. Understanding these menus allows users to work efficiently,
automate tasks, and create insightful reports. Mastering the Excel menu bar is a key step
toward becoming proficient in spreadsheet management and data handling.
EXPERIMENT -3
OBJECTIVE: - Write Functional and Non Function Requirements of the project.
INTRODUCTION: -
Functional Requirements:
Functional requirements define the core features and operations of a system. These are
specific tasks that the system must perform.
Non-Functional Requirements:
Non-functional requirements define the quality attributes of the system, such as performance,
security, and usability.
TOPICS COVERED: -
Functional Requirements
Non Functional Requirements
CONCLUSION: - Functional and non-functional requirements are essential for a
successful Car Rental Project. Functional requirements define key operations like booking,
payments, and user management, ensuring smooth functionality. Non-functional
requirements focus on security, performance, scalability, and user experience, ensuring
reliability and efficiency. Together, they create a robust and user-friendly system.
EXPERIMENT -4
OBJECTIVE: -
Q.1 A worksheet contains following data :
i. Filter the worksheet to show
a) Female students from Reserved
category
b) Male students from TY
c) Open category students paying fees >
3000
Q.2 A worksheet contains name and marks in 3 subjects . Calculate Total Marks
i. Construct 3D Pie Chart for Total marks
ii. Construct 2D Line Chart for Subject 1 and
Subject 3
iii. Construct 2D Column Chart for
Sub1,Sub2,Sub3
iv. Construct Stacked Column Chart for Sub1,Sub2,Sub3
Q.3. Given the table below,
i. Use hlookup function to display student's name Sok Pagan
ii. Use vlookup function to find the computer score of the students named Khorn Channa and Cheng
Sokun
Q.4. For the below table find the following:
i. TAX (If ITEM PRICE is less than 100, TAX is 50,
otherwise it should be 100).
ii. TOTAL PRICE BEFORE TAX =NO. OF ITEMS *
ITEM PRICE.
iii. TOTAL PRICE AFTER TAX = TOTAL PRICE BEFORE TAX + TAX.
iv. RATE (If TOTAL PRICE AFTER TAX > 3500 then the rate is “HIGH”, otherwise it is
REASONABLE.
v. Find Count of Items, Average of Taxes, Min Item PRICE and Max Item PRICE.
Q.5.i. Open a new workbook and create the above worksheet.
ii. Make sure that your worksheet looks like the picture (Alignment, Shedding, Borders, Wrap
text, Orientation …).
iii. Find the entire customer IDs.
iv. Format Colum E & D to Currency with dollar sign and two
decimal places.
v. Find the Total Annual Purchases for each City.
vi. Find the Average Annual Purchases for each Education.
vii. Find the total number of customers from each gender.
viii. Find the total annual salary for each gender in each city.
ix Create the following Chart:
INTRODUCTION: - Microsoft Excel is a powerful spreadsheet software used for data
management, analysis, and visualization. It offers features like formulas, functions, charts,
pivot tables, and data analysis tools, making it essential for professionals in finance, business,
research, and various industries.
TOPICS COVERED: -
Filtering, Sorting and Slicing.
MS Excel Charts
HLOOKUP and VLOOKUP
Conditional Statements
Pivot Table
CONCLUSION: -Microsoft Excel is a versatile and powerful tool for data
management, analysis, and visualization. Its wide range of features, including formulas,
functions, charts, and automation, makes it essential for professionals across industries.
Mastering Excel enhances productivity, decision-making, and efficiency in handling
complex data tasks.