BTechibtechi.in
Loading Loading
Free IIT Madras BS notes, PYQs and mock tests at btechi.in

BDM · End Term · 31 Aug 2025 (Forenoon)

23 questions · 30 marks · 90 min

Answer key Take as mock

Indian Institute of Technology Madras

BS Degree Programme · Examination & Study Paper

Business Data Management

End Term · 31 Aug 2025 (Forenoon)

Official Paper

Examination Instructions & Guidelines

Solve on notebook/paper first before checking solutions.
MCQ: Exactly 1 option is correct. Negative marking applies.
MSQ: One or more options correct. Select all to score.
NAT: Numerical response. No negative marking.
Scientific calculator allowed for all calculations.
Official answer key is sealed at the end of this sheet.

Q1MCQ1 Mark·Choose one option
Asked 2 times Key ↓
In the context of economic circular flow, what do firms primarily provide to the factor market?
1. AGoods and services
2. BWages and rent
3. CRaw materials
4. DCapital investment
Q2MCQ1 Mark·Choose one option
Asked 3 times Key ↓
Which Excel function would you use to find a value in the first column of a table and return a value from a specified column?
1. AINDEX
2. BMATCH
3. CVLOOKUP
4. DHLOOKUP
Q3MCQ1 Mark·Choose one option
Asked 2 times Key ↓
Which of the following is a non-government source of economic data in India?
1. ANational Sample Survey (NSS)
2. BEconomic Census
3. CCentre for Monitoring Indian Economy (CMIE)
4. DAnnual Survey of Industries (ASI)
Q4MCQ1 Mark·Choose one option
Asked 2 times Key ↓
What does a bimodal distribution in consumer spending data typically indicate?
1. AUniform spending across all consumers
2. BTwo distinct consumer groups with different spending patterns
3. CRandom spending behavior
4. DDeclining consumer confidence
Q5MCQ1 Mark·Choose one option
Asked 2 times Key ↓
In a saturated market where 75% of existing customers show upgrade interest but new customer acquisition is limited, what should companies prioritize?
1. AAggressive new customer acquisition campaigns
2. BGeographic expansion to untapped markets
3. CUpgrade incentives and retention programs for existing customers
4. DPrice reduction strategies
Q6MCQ1 Mark·Choose one option
Key ↓
Days Sales Outstanding (DSO) primarily measures:
1. AAverage time to convert inventory to sales
2. BAverage time to collect accounts receivable
3. CAverage time to pay suppliers
4. DAverage production cycle time
Q7MCQ1 Mark·Choose one option
Asked 3 times Key ↓
Which chart type is most appropriate for showing the relationship between two continuous variables?
1. ABar chart
2. BPie chart
3. CScatter plot
4. DHistogram
Q8MCQ1 Mark·Choose one option
Key ↓
Internal Pool Sourcing refers to:
1. AHiring external consultants
2. BFilling positions from within the organization
3. COutsourcing recruitment processes
4. DCreating talent pools for future hiring
Q9MCQ1 Mark·Choose one option
Asked 2 times Key ↓
To reduce credit losses, a FinTech company should:
1. ADecrease credit score approval threshold
2. BIncrease credit score approval threshold
3. CEliminate credit checks
4. DApprove all applications
Q10MCQ1 Mark·Choose one option
Key ↓
A customer purchases on ClipKart using HFCD Credit Card via PayBlade. What is the correct payment flow sequence?
1. ACustomer → HFCD → ClipKart
2. BCustomer → HFCD → PayBlade → ClipKart
3. CCustomer → PayBlade → HFCD → ClipKart
4. DCustomer → ClipKart → HFCD → PayBlade
Q11MCQ1 Mark·Choose one option
Key ↓
Personalized recommendations on e-commerce platforms primarily aim to:
1. AIncrease website traffic
2. BReduce server load
3. CImprove conversion rates based on user behavior
4. DStandardize user experience
Q12MCQ1 Mark·Choose one option
Key ↓
Which of the following best describes a lead indicator?
1. AA metric that reflects past performance
2. BA measure used to predict future trends
3. CA statistic that measures current output
4. DA financial result already realized
Q13MCQ1 Mark·Choose one option
Asked 3 times Key ↓
Which Excel function would you use to calculate the average of a filtered range, ignoring hidden rows?
1. AAVERAGE
2. BSUBTOTAL
3. CAGGREGATE
4. DFILTER
Q14MCQ1 Mark·Choose one option
Asked 2 times Key ↓
What is the primary objective of conducting an A/B test?
1. ATo test system scalability
2. BTo compare performance of two or more variants
3. CTo validate data quality
4. DTo measure user satisfaction
Q15MSQ2 Marks·Choose all correct options
Asked 3 times Key ↓
Which of the following is NOT a typical function of pivot tables?
1. ASummarizing large datasets
2. BCreating new records in source data
3. CGrouping data by categories
4. DCalculating aggregated values
Q16MCQ2 Marks·Choose one option
Asked 3 times Key ↓
1. ATreatment improved both metrics
2. BTreatment improved conversion but reduced transaction value
3. CControl performed better on all metrics
4. DNo significant difference between groups
Q17MCQ2 Marks·Choose one option
Asked 2 times Key ↓
1. ACampus Hiring
2. BJob Portal
3. CEmployee Referral
4. DSocial Media
Read the passage below, then answer Q18–Q19
Based on the following sales data, answer the given subquestions
Product Sales Data (Rs. in thousands):
Product A: 45,000
Product B: 32,000
Product C: 58,000
Product D: 28,000
Product E: 37,000
Q18MCQ2 Marks·Choose one option
Asked 5 times Key ↓
What is the market share of Product C as a percentage?
1. A27.5%
2. B29.0%
3. C30.5%
4. D32.0%
Q19MCQ1 Mark·Choose one option
Asked 5 times Key ↓
Which product has the second-highest market share?
1. AProduct A
2. BProduct B
3. CProduct D
4. DProduct E
Read the passage below, then answer Q20–Q21
Q20NAT2 Marks·Write the number
Asked 4 times Key ↓
What is the total monthly revenue?
Your answer:
Q21MCQ1 Mark·Choose one option
Asked 2 times Key ↓
Which product has the highest Days of Inventory?
1. AAlpha
2. BBeta
3. CGamma
4. DDelta
Read the passage below, then answer Q22–Q23
Based on the following product data, answer the given subquestions:
Planned Production Hours: 480
Lost Time Hours: 48
Design Speed: 200 units/hour
Actual Speed: 180 units/hour
Total Units Produced: 77,760
Good Units: 74,772
Q22NAT2 Marks·Write the number
Asked 2 times Key ↓
Calculate Availability (in %)
Your answer:
Q23NAT2 Marks·Write the number
Asked 4 times Key ↓
Calculate Overall Equipment Effectiveness (OEE) (in %)
Your answer:

Official Key

Master Answer Key & Explanations

Official answer keys from IIT Madras BS past papers. Click any question to review.

Reveal Key

Q1B

Q2C

Q3C

Q4B

Q5C

Q6B

Q7C

Q8B

Q9B

Q10C

Q11C

Q12B

Q13B

Q14B

Q15B

Q16B

Q17C

Q18B

Q19A

Q201088000

Q21B

Q2290

Q2377 to 78

Questions and answer keys are reproduced from the official IIT Madras BS papers. BTechi is not affiliated with IIT Madras.