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

BDM · End Term · 31 Aug 2025 (Afternoon)

22 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 (Afternoon)

Official Paper

Examination Instructions & Guidelines

Solve on notebook/paper first before checking solutions.
MCQ: Exactly 1 option is correct. Negative marking applies.
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
Key ↓
What happens to the demand curve when consumer income increases for a normal good?
1. AShifts to the left
2. BShifts to the right
3. CRemains unchanged
4. DBecomes steeper
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
Key ↓
Which of the following is primarily used as a surrogate indicator?
1. ADirect sales data
2. BNumber of vehicle registrations to estimate automobile market size
3. CCustomer survey responses
4. DCompany financial statements
Q4MCQ1 Mark·Choose one option
Asked 2 times Key ↓
A niche market strategy focuses on:
1. ABroad customer segments with general needs
2. BSpecific customer groups with specialized needs
3. CMass production for cost efficiency
4. DGeographic expansion
Q5MCQ1 Mark·Choose one option
Key ↓
For a company facing declining market share, which strategy would be most appropriate?
1. AMaintain current pricing
2. BReduce marketing spend
3. CAnalyze competitors and differentiate offerings
4. DExit the market immediately
Q6MCQ1 Mark·Choose one option
Key ↓
ABC Analysis primarily categorizes inventory based on:
1. APhysical size of items
2. BAlphabetical order
3. CAnnual monetary usage/value
4. DStorage location
Q7MCQ1 Mark·Choose one option
Key ↓
Which is NOT a benefit of implementing an ERP system?
1. AImproved data accuracy
2. BIncreased data redundancy
3. CBetter process efficiency
4. DEnhanced business visibility
Q8MCQ1 Mark·Choose one option
Key ↓
For analyzing seasonal sales patterns, which approach is most effective?
1. AMaintain constant inventory levels
2. BAdjust inventory based on historical seasonal trends
3. CIgnore seasonal variations
4. DFocus only on peak season data
Q9MCQ1 Mark·Choose one option
Asked 2 times Key ↓
In an A/B test for a mobile app redesign, the control group should receive:
1. AThe new app design
2. BThe current/original app design
3. CA mix of old and new designs
4. DNo app access
Q10MCQ1 Mark·Choose one option
Asked 3 times Key ↓
A document outlining job requirements, budget, and skills needed is called:
1. AJob Description
2. BIndent
3. CAppraisal Form
4. DPerformance Review
Q11MCQ1 Mark·Choose one option
Key ↓
When should A/B testing ideally be conducted?
1. AAfter full deployment to all users
2. BBefore developing the solution
3. CBefore full deployment to validate changes
4. DOnly during system maintenance
Q12MCQ1 Mark·Choose one option
Key ↓
E-commerce platforms use scarcity nudges by:
1. AShowing unlimited stock availability
2. BDisplaying 'Only 3 left in stock' messages
3. CHiding product information
4. DRemoving time limits on offers
Q13MCQ1 Mark·Choose one option
Key ↓
If a company identifies a strong seasonal pattern in sales data, the optimal inventory approach is to:
1. AKeep inventory constant all year
2. BIncrease inventory uniformly
3. CAdjust safety stock and reorder levels based on seasonal forecasts
4. DEliminate safety stock entirely
Read the passage below, then answer Q14–Q15
Smartphone Sales Analysis (Units in thousands):
Based on the above data, answer the given subquestions.
Q14MCQ2 Marks·Choose one option
Asked 4 times Key ↓
Which brand has the highest total annual revenue?
1. ASamsing
2. BOrange
3. CTwoPlus
4. DZiome
Q15MCQ1 Mark·Choose one option
Asked 5 times Key ↓
What is Orange's market share by revenue?
1. A18.5%
2. B21.2%
3. C32.0%
4. D36.4%
Read the passage below, then answer Q16–Q18
TechCorp Manufacturing Data for March 2024:
Week 1: Planned 500 units, Produced 480 units, Defects 24
Week 2: Planned 520 units, Produced 500 units, Defects 20
Week 3: Planned 480 units, Produced 465 units, Defects 18
Week 4: Planned 550 units, Produced 530 units, Defects 25
Based on the above data, answer the given subquestions.
Q16NAT2 Marks·Write the number
Asked 3 times Key ↓
Calculate the overall Quality percentage for March (in %)
Your answer:
Q17MCQ2 Marks·Choose one option
Key ↓
Which week had the best Performance percentage?
1. AWeek 1
2. BWeek 2
3. CWeek 3
4. DWeek 4
Q18NAT2 Marks·Write the number
Asked 2 times Key ↓
What is the average Availability assuming 8-hour shifts with 0.5 hours lost time per day? (in %)
Your answer:
Q19MCQ2 Marks·Choose one option
Key ↓
For the given data, which formula correctly calculates total sales for 'Electronics' category sold by 'John'? Data Range A2:C10 contains: Column A: Salesperson names Column B: Category Column C: Sales amount
1. A=SUMIFS(C2:C10,A2:A10,"John",B2:B10,"Electronics")
2. B=SUMIF(A2:A10,"John",C2:C10)+SUMIF(B2:B10,"Electronics",C2:C10)
3. C=VLOOKUP("John",A2:C10,3,FALSE)
4. D=COUNTIFS(A2:A10,"John",B2:B10,"Electronics")
Q20MCQ2 Marks·Choose one option
Asked 3 times Key ↓
E-commerce A/B Test Results: Version A (Control): 1000 visitors, 50 purchases, Avg order value Rs.1,200 Version B (Treatment): 1000 visitors, 65 purchases, Avg order value Rs.1,150 Which metric shows improvement in Version B?
1. AConversion rate only
2. BAverage order value only
3. CBoth conversion rate and total revenue
4. DNeither metric improved
Q21MCQ2 Marks·Choose one option
Asked 2 times Key ↓
1. APriya > Raj > Nina > Sam
2. BPriya > Sam >Raj >Nina
3. CSam > Priya > Raj > Nina
4. DNina > Priya > Raj > Sam
Q22NAT2 Marks·Write the number
Asked 3 times Key ↓
DigitalPay earns revenue as follows: - 2.5% transaction fee on all payments - 15% annual interest on credit transactions - 8% loss rate on credit (unpaid amounts) March transactions: Debit payments: Rs.10,00,000 Credit payments: Rs.5,00,000 Credit defaults: Rs.40,000 Calculate net profit for March:
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

Q3B

Q4B

Q5C

Q6C

Q7B

Q8B

Q9B

Q10B

Q11C

Q12B

Q13C

Q14B

Q15C

Q1695 to 96

Q17C

Q1893.2 to 94.2

Q19A

Q20C

Q21B

Q2240550

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