Category: Analytical Ability • Topic 4 of 4
Exam Area: Analytical Ability
Professional Only • Topic 4 of 4

Data Interpretation: Tables, Charts & Relational Logic

Sa Data Interpretation at Relational Logic Puzzles, nasa harap mo na mismo ang lahat ng datos—kailangan mo lang malaman kung aling row, column, o porsyento ang titingnan at kung paano mag-compute nang walang pagkakamali.

Learning Objectives:
  • Mabasa nang mabilis ang Data Tables, Bar Charts, at Pie/Donut Charts sa pamamagitan ng pag-check muna sa Title, Units, at Totals.
  • Makapag-compute nang tumpak ng Percentage Share of Total at Percentage Growth Rate: ((New − Old) ÷ Old) × 100%.
  • Maiwasan ang pinakamadalas na bitag sa Data Interpretation: ang pagkalito sa Raw Increase (bilang) vs. Percentage Increase (%).
  • Malutas ang Relational Ranking at Line-Ordering puzzles gamit ang visual Inequality Line (< / >).
Bakit mahalaga sa CSE: Sa Data Interpretation, huwag i-compute ang lahat ng rows! Basahin muna ang tanong at kunin lang ang 2–3 numerong kailangan sa computation.
1
Core Skill 1 • Tables & Bar Charts

Data Tables & Bar Charts: Raw Difference vs. Percentage Growth

Bakit laging ang OLD (Original) value ang nasa ibaba kapag kumukuha ng Percentage Change?

Bago mag-compute sa anumang table o chart, tingnan muna ang: (1) Pamagat at Units (hal. in thousands o in percent), at (2) ang Question Stem (tinatanong ba ay actual number o percentage growth?).

Formula & Shortcut Reference

Data Interpretation Essential Formulas

Kapag nagkukumpara ng pagtaas/pagbaba sa pagitan ng dalawang panahon o kumukuha ng bahagi sa kabuuan
% Growth = ((New − Old) ÷ Old) × 100% | % Share = (Part ÷ Total) × 100%
Kung saan (Variables):
Old (Base / Initial Value) Ang pinagmulang bilang (hal. Q1 o nakaraang taon) — LAGING ITO ANG DENOMINATOR!
New (Final Value) Ang bagong bilang (hal. Q2 o kasalukuyang taon)
New − Old Raw Change o aktwal na dami ng itinaas/ibinaba
Sample Substitution & Computation

Mula 1,200 applications noong Q1, tumaas ang Region I sa 1,500 applications noong Q2. Ano ang percentage increase?

  1. Step 1 (Kunin ang Raw Increase: New − Old): 1,500 − 1,200 = +300 applications
  2. Step 2 (I-divide sa OLD value na 1,200): 300 ÷ 1,200 = 3 / 12 = 1 / 4
  3. Step 3 (Gawing Percent): 1/4 = 0.25 × 100% = 25% increase
Result: 25% increase
Data Chart Data Dashboard: Regional Applications (Q1 vs. Q2) & IT Budget Share
Two-panel data chart na nagpapakita ng Q1 vs Q2 processed applications sa Regions I, III, IV-A, at VII sa kaliwa, at ₱12,000,000 IT Budget breakdown sa kanan
Regional Office Q1 Applications (Old) Q2 Applications (New) Raw Change (Q2 − Q1) % Change ((Q2 − Q1) ÷ Q1)
Region I 1,200 1,500 +300 +25.0% (300 ÷ 1,200)
Region III 2,000 2,400 +400 (Highest Raw) +20.0% (400 ÷ 2,000)
Region IV-A 2,500 2,800 +300 +12.0% (300 ÷ 2,500)
Region VII 1,800 1,300 −500 −27.8% (−500 ÷ 1,800)
TOTAL 7,500 8,000 +500 +6.67% (500 ÷ 7,500)
Gamitin ang datos sa kaliwang chart para sa Sample Question #1 at ang kanang chart para sa Sample Question #2.
Visual Takeaway: Kahit mas malaki ang nadagdag na bilang sa Region III (+400) kaysa sa Region I (+300), mas mataas ang PERCENTAGE GROWTH ng Region I (+25%) dahil mas maliit ang pinagmulan nitong Q1 base (1,200)!
Halimbawa / Direct Example

Sample Data Interpretation Question #1 (Percentage Growth vs. Raw Increase)

Based on the Regional Applications table above, which Regional Office recorded the HIGHEST percentage increase in processed applications from Q1 to Q2, and what Share (%) of the total Q2 applications came from Region III?
A Region III (20% growth) — and 24% share of Q2 total
B Region I (25% growth) — and 30% share of Q2 total
C Region IV-A (12% growth) — and 35% share of Q2 total
D Region I (20% growth) — and 30% share of Q2 total
Tamang Sagot: Choice B (Region I with 25% growth; Region III has 30% share of Q2 total)
Paliwanag: (1) Highest % increase: Region I = (1,500 − 1,200) ÷ 1,200 = 300 ÷ 1,200 = 25% (mas mataas sa 20% ng Region III). (2) Share ng Region III sa Q2 Total: 2,400 ÷ 8,000 = 24 ÷ 80 = 3/10 = 30%.
Dalawang Bitag sa Percentage Growth Calculations
Pansinin na inilagay sa Choice D (`Region I — 20% growth`) ang eksaktong maling sagot kung sa 1,500 (New) ka nag-divide sa halip na sa 1,200 (Old)!
Mali / Huwag Gagawin:
1) Pinili ang Region III dahil +400 ang nadagdag (Raw Increase trap). | 2) Nag-divide sa NEW value (300 ÷ 1,500 = 20%) sa halip na sa OLD value (300 ÷ 1,200 = 25%).
Tama / Gawin Ito:
Kapag 'percentage increase from Q1 to Q2' ang tanong, laging i-divide ang (Q2 − Q1) sa Q1 (ang pinagmulang bilang)!
2
Core Skill 2 • Pie / Donut Charts

Pie Charts & Percentage Difference Shortcut

Paano makatipid ng kalahating minuto kapag nagkukumpara ng dalawang slices sa Pie Chart.

Kapag tinanong kung gaano kalaki ang agwat (difference) ng dalawang bahagi sa isang Pie Chart, huwag nang kunin nang hiwalay ang peso value ng bawat isa! Ipares o ibawas muna ang kanilang percentages bago i-multiply sa Total Budget.

Sitwasyon sa Opisina / Real-Life Scenario

Sample Data Interpretation Question #2 (IT Modernization Budget: ₱12,000,000)

Refer to the IT Modernization Budget breakdown (Total Budget = ₱12,000,000): Hardware Upgrade (40%), Software Licensing (25%), Staff Training (20%), and Maintenance Reserve (15%).

How much more is allocated to Hardware Upgrade than to Staff Training?
A ₱1,800,000
B ₱2,400,000
C ₱3,000,000
D ₱4,800,000
Tamang Sagot: Choice B (₱2,400,000)
Paliwanag: Hardware Upgrade (40%) minus Staff Training (20%) = 20% difference. Kunin lang ang 20% ng ₱12,000,000: ₱12,000,000 × 0.20 = ₱2,400,000.
Solving Options

Subtract Percentages First vs. Compute Each Amount First

Tingnan kung gaano kabilis ang Method 1 sa Pie Chart comparison problems:

Alternative / Traditional 2-Step Computation Kung gusto mong i-verify ang halaga ng bawat slice

Method 2: Compute Individual Peso Amounts, Then Subtract

Kunin ang 40% at 20% nang hiwalay at pagbawas-bawasin.

₱4,800,000 − ₱2,400,000
  1. Hardware Upgrade (40%): 0.40 × ₱12,000,000 = ₱4,800,000.
  2. Staff Training (20%): 0.20 × ₱12,000,000 = ₱2,400,000.
  3. Ibawas: ₱4,800,000 − ₱2,400,000 = ₱2,400,000.
Sagot: ₱2,400,000
3
Core Skill 3 • Relational Logic Puzzles

Relational Logic: Ranking & Line-Ordering Puzzles

Paano lutasin ang 'Who is tallest / fastest / seated in the middle?' gamit ang Inequality Chain.

Sa Relational Logic Puzzles (pagkukumpara ng tangkad, edad, bilis, o palapag ng opisina), huwag itong lutasin sa isip lang. Gumamit ng > (mas mataas/mabilis) sa scratch paper para makabuo ng isang linya!

Halimbawa / Direct Example

Sample Relational Ranking Puzzle

Five division chiefs—Lara, Mico, Nina, Owen, and Pia—submitted their annual reports on different days from Monday to Friday (one per day):
• Lara submitted her report earlier than Mico, but later than Owen.
• Nina submitted her report earlier than Owen.
• Pia submitted her report later than Mico.

Who submitted the report on Wednesday (the 3rd day)?
A Owen
B Lara
C Mico
D Nina
Tamang Sagot: Choice B (Lara)
Paliwanag: Kapag inayos mula pinakamaaga (Monday) hanggang pinakahuli (Friday): Nina (Mon) → Owen (Tue) → Lara (Wed) → Mico (Thu) → Pia (Fri). Si Lara ang nasa gitna (Wednesday).
'Nauna si Owen kay Lara, at nauna si Lara kay Mico.', 'math' => 'Owen → Lara → Mico', ], [ 'title' => 'Isalin ang Clue #2 ("Nina earlier than Owen")', 'detail' => 'Ilagay si Nina sa unahan ni Owen.', 'math' => 'Nina → Owen → Lara → Mico', ], [ 'title' => 'Isalin ang Clue #3 ("Pia later than Mico")', 'detail' => 'Ilagay si Pia sa hulihan ni Mico para mabuo ang 5 araw (Mon to Fri).', 'math' => 'Mon: Nina | Tue: Owen | Wed: LARA | Thu: Mico | Fri: Pia', ], ]" finalAnswer="Lara (Choice B — Wednesday)" />

Short Recap: Data Interpretation & Relational Logic

  • Sa Data Tables at Charts, basahin muna ang Title, Units, at Question Stem bago mag-compute.
  • Sa Percentage Growth/Change, laging ang OLD (initial) value ang nasa denominator: ((New − Old) ÷ Old) × 100%.
  • Sa Pie Charts, kapag hinahanap ang difference ng dalawang slices na may parehong Total Base, ibawas muna ang percentages bago i-multiply sa Total.
  • Sa Relational Ranking Puzzles, gumuhit ng isang chain (A → B → C) sa scratch paper sa halip na sauluhin sa isip.
Supplementary Video References

Want Another Explanation?

Sometimes, learning a topic becomes easier when you hear it explained in a different way. Here are some independently selected videos that may help you understand this lesson better.

These videos are independently selected by ToolBayan for supplementary educational purposes. All videos remain the property of their respective creators and channels. ToolBayan is not affiliated with, sponsored by, or officially endorsed by the featured creators or channels.

CSE Reviewer Practice

Palawakin Pa ang Iyong CSE Practice

Natapos mo na ang huling module sa bahaging ito! Ipagpatuloy ang pagsasanay sa CSE Reviewer gamit ang mga tanong mula sa available question bank. Random ang pagpili ng mga tanong kaya maaari kang makatagpo ng iba't ibang CSE topics sa bawat session.

Mag-practice sa CSE Reviewer
CSE Professional Level
Community Credits

ToolBayan is still running, and its purpose lives on because of these people:

Special thanks to everyone who helps keep our free office tools online.

Yasmin First supporter
Jessa Deloy First supporter
Rica Mae Ramos Nice Work ❤️
Shaina Mae Ventrusa Good job!
MARY GRACE T. SIBAYAN First supporter
2×
Diana Jane Macion Returning Supporter
Yasmin First supporter
Jessa Deloy First supporter
Rica Mae Ramos Nice Work ❤️
Shaina Mae Ventrusa Good job!
MARY GRACE T. SIBAYAN First supporter
2×
Diana Jane Macion Returning Supporter
Yasmin First supporter
Jessa Deloy First supporter
Rica Mae Ramos Nice Work ❤️
Shaina Mae Ventrusa Good job!
MARY GRACE T. SIBAYAN First supporter
2×
Diana Jane Macion Returning Supporter