Crystal oscillator circuit in PCB Design - Real Business Scenario

Scenario Mode

👤 Your Role: You are an electronics design analyst at a manufacturing company.

📋 Request: Your manager wants a report on the performance and reliability of the crystal oscillator circuits used in recent PCB designs.

📊 Data: You have data on oscillator frequency stability, power consumption, failure rates, and production batch details for 10 recent PCB designs.

🎯 Deliverable: Create a dashboard showing frequency stability trends, power consumption comparisons, and failure rates by production batch.

Sample Data

PCB_ID	Batch	Frequency_MHz	Frequency_Stability_ppm	Power_mW	Failures	Total_Units
PCB001	BatchA	16.000	5	10	1	100
PCB002	BatchA	16.001	4	11	0	100
PCB003	BatchB	15.999	6	9	2	100
PCB004	BatchB	16.002	5	10	1	100
PCB005	BatchC	16.000	3	12	0	100
PCB006	BatchC	16.001	4	11	1	100
PCB007	BatchD	15.998	7	10	3	100
PCB008	BatchD	16.000	6	9	2	100
PCB009	BatchE	16.002	5	10	0	100
PCB010	BatchE	16.001	4	11	1	100

1

Step 1: Calculate the average frequency stability (in ppm) for each production batch.

Group data by Batch, then calculate AVG(Frequency_Stability_ppm) for each group.

Expected Result

BatchA: 4.5 ppm, BatchB: 5.5 ppm, BatchC: 3.5 ppm, BatchD: 6.5 ppm, BatchE: 4.5 ppm

2

Step 2: Calculate the average power consumption (in mW) for each production batch.

Group data by Batch, then calculate AVG(Power_mW) for each group.

Expected Result

BatchA: 10.5 mW, BatchB: 9.5 mW, BatchC: 11.5 mW, BatchD: 9.5 mW, BatchE: 10.5 mW

3

Step 3: Calculate the failure rate (%) for each batch as (SUM(Failures) / SUM(Total_Units)) * 100.

Group data by Batch, then calculate failure rate = (SUM(Failures) / SUM(Total_Units)) * 100.

Expected Result

BatchA: 0.5%, BatchB: 1.5%, BatchC: 0.5%, BatchD: 2.5%, BatchE: 0.5%

4

Step 4: Create a dashboard with three charts: a bar chart for average frequency stability by batch, a bar chart for average power consumption by batch, and a line chart for failure rate by batch.

Configure bar charts with X-axis=Batch, Y-axis=Average Frequency Stability and Average Power Consumption respectively; configure line chart with X-axis=Batch, Y-axis=Failure Rate.

Expected Result

Dashboard shows clear comparison of frequency stability, power consumption, and failure rates across batches.

5

Step 5: Add filters to the dashboard to allow viewing data by individual PCB_ID or by batch.

Add slicers or dropdown filters for PCB_ID and Batch fields.

Expected Result

User can filter dashboard to see detailed data for specific PCBs or batches.

Final Result

Frequency Stability (ppm) by Batch

BatchA |■■■■■     4.5
BatchB |■■■■■■■   5.5
BatchC |■■■■      3.5
BatchD |■■■■■■■■  6.5
BatchE |■■■■■     4.5

Power Consumption (mW) by Batch

BatchA |■■■■■■    10.5
BatchB |■■■■■     9.5
BatchC |■■■■■■■   11.5
BatchD |■■■■■     9.5
BatchE |■■■■■■    10.5

Failure Rate (%) by Batch

BatchA |--■       0.5%
BatchB |----■■■    1.5%
BatchC |--■       0.5%
BatchD |----■■■■■  2.5%
BatchE |--■       0.5%

✓Batch D has the highest failure rate at 2.5%, indicating potential quality issues.

✓Batch C shows the best frequency stability with the lowest average ppm of 3.5.

✓Power consumption varies slightly, with Batch C consuming the most power on average.

✓Filtering by PCB_ID helps identify specific units contributing to failures.

Bonus Challenge

Add a time series analysis to track frequency stability changes over production dates if date data is available.

Show Hint

Use production date as X-axis and average frequency stability as Y-axis in a line chart to observe trends over time.

Practice

1. What is the main purpose of a crystal oscillator circuit in electronics?

easy

A. To amplify weak signals

B. To store electrical energy

C. To convert AC to DC power

D. To provide a precise and stable clock signal

Solution

1. Step 1: Understand the role of oscillators

   Oscillators generate repetitive signals used as timing references in circuits.

2. Step 2: Identify crystal oscillator function

   Crystal oscillators use a quartz crystal to produce a very stable and precise frequency.

3. Final Answer:

   To provide a precise and stable clock signal -> Option D

4. Quick Check:

   Crystal oscillator = precise clock signal [OK]

Hint: Crystal oscillators give stable timing signals [OK]

Common Mistakes:

• Confusing oscillator with amplifier
• Thinking it stores energy
• Mixing power conversion with timing

2. Which of the following is the correct way to connect the crystal in a typical Pierce oscillator circuit?

easy

A. Between the power supply and ground without capacitors

B. Directly in series with the power supply

C. Between the input and output of the inverter with capacitors to ground

D. In parallel with the load resistor only

Solution

1. Step 1: Recall Pierce oscillator configuration

   In a Pierce oscillator, the crystal is connected between the inverter input and output pins.

2. Step 2: Confirm capacitor placement

   Capacitors connect from these points to ground to form the feedback network.

3. Final Answer:

   Between the input and output of the inverter with capacitors to ground -> Option C

4. Quick Check:

   Pierce oscillator crystal connection = input-output with capacitors [OK]

Hint: Crystal goes between inverter input and output with caps to ground [OK]

Common Mistakes:

• Connecting crystal directly to power
• Omitting capacitors to ground
• Placing crystal only in parallel with load

3. Given a crystal oscillator circuit with a 10 MHz crystal and capacitors of 20 pF each, what is the expected output frequency?

medium

A. 5 MHz

B. 10 MHz

C. 20 MHz

D. Depends on capacitor values only

Solution

1. Step 1: Understand crystal frequency role

   The crystal sets the fundamental frequency of oscillation, here 10 MHz.

2. Step 2: Recognize capacitor effect

   Capacitors fine-tune frequency slightly but do not double or halve it.

3. Final Answer:

   10 MHz -> Option B

4. Quick Check:

   Crystal frequency = output frequency [OK]

Hint: Output frequency equals crystal frequency, capacitors adjust tuning [OK]

Common Mistakes:

• Assuming capacitors double frequency
• Confusing frequency division
• Ignoring crystal's dominant frequency

4. A crystal oscillator circuit is not oscillating. Which of the following is the most likely cause?

medium

A. Incorrect capacitor values causing no feedback

B. Crystal frequency too high for the circuit

C. Power supply voltage is too high

D. Using a resistor instead of a crystal

Solution

1. Step 1: Check feedback network

   Oscillation requires proper feedback; wrong capacitor values can break this loop.

2. Step 2: Evaluate other options

   Crystal frequency mismatch or power issues usually cause distortion, not no oscillation; resistor cannot replace crystal.

3. Final Answer:

   Incorrect capacitor values causing no feedback -> Option A

4. Quick Check:

   No oscillation often means feedback failure [OK]

Hint: No oscillation? Check capacitor feedback network first [OK]

Common Mistakes:

• Blaming crystal frequency without checking feedback
• Ignoring capacitor role
• Replacing crystal with resistor

5. You want to design a crystal oscillator circuit for a microcontroller that requires a 16 MHz clock. Which combination is best to ensure stable oscillation?

hard

A. Use a 16 MHz crystal with two 22 pF capacitors connected to ground

B. Use a 16 MHz crystal with no capacitors

C. Use a 8 MHz crystal with two 22 pF capacitors connected to ground

D. Use a 16 MHz crystal with one 100 pF capacitor in series

Solution

1. Step 1: Match crystal frequency to microcontroller clock

   The crystal frequency must be 16 MHz to match the required clock.

2. Step 2: Choose proper capacitor values and placement

   Two capacitors (~22 pF) connected from crystal terminals to ground stabilize oscillation.

3. Step 3: Evaluate other options

   No capacitors or wrong crystal frequency cause instability; one large capacitor in series is incorrect.

4. Final Answer:

   Use a 16 MHz crystal with two 22 pF capacitors connected to ground -> Option A

5. Quick Check:

   Correct crystal + proper capacitors = stable oscillation [OK]

Hint: Match crystal freq and use two small caps to ground [OK]

Common Mistakes:

• Skipping capacitors
• Using wrong crystal frequency
• Incorrect capacitor placement