Crystal oscillator circuit in PCB Design - Practice Problems & Coding Challenges

Challenge - 5 Problems

🧠 Conceptual

intermediate

Crystal Oscillator Frequency Stability

Which factor most directly affects the frequency stability of a crystal oscillator circuit?

A The quality factor (Q) of the crystal

B The color of the PCB substrate

C The length of the power supply cable

D The type of solder used on the components

💡 Hint

Think about what property of the crystal controls how steady its oscillation frequency is.

The quality factor (Q) of the crystal determines how sharply it resonates at its natural frequency, which directly affects frequency stability.

❓ dax_lod_result

intermediate

Calculate Oscillation Frequency from Crystal Parameters

Given a crystal with a nominal frequency of 10 MHz and a load capacitance of 20 pF, which DAX expression correctly calculates the approximate oscillation frequency adjustment assuming a simple load effect?

PCB Design

Oscillation Frequency = Nominal Frequency / (1 + (Load Capacitance / 1000))

A Oscillation Frequency = 10 - (20 / 1000)

B Oscillation Frequency = 10 * (1 + (20 / 1000))

C Oscillation Frequency = 10 + (20 * 1000)

D Oscillation Frequency = 10 / (1 + (20 / 1000))

💡 Hint

Load capacitance slightly lowers the frequency, so the formula should divide the nominal frequency by a value slightly greater than 1.

The load capacitance causes a small decrease in oscillation frequency, modeled by dividing the nominal frequency by (1 + load capacitance factor).

❓ visualization

advanced

Best Visualization for Oscillator Frequency Drift Over Time

You have frequency drift data of a crystal oscillator measured every hour for 24 hours. Which visualization best shows the frequency drift trend clearly?

A Line chart with time on X-axis and frequency drift on Y-axis

B Pie chart showing percentage of frequency drift ranges

C Bar chart with frequency drift values stacked by hour

D Scatter plot with frequency drift on X-axis and time on Y-axis

💡 Hint

Think about which chart type best shows changes over time in a continuous manner.

A line chart is ideal for showing trends over time because it connects data points in order, making it easy to see how frequency drift changes hour by hour.

🔧 Formula Fix

advanced

Identify the Error in Crystal Oscillator Circuit Model

Given this simplified DAX measure to calculate average frequency drift:
AvgDrift = AVERAGE('OscillatorData'[FrequencyDrift])
But the result is unexpectedly zero. What is the most likely cause?

A The table name 'OscillatorData' is misspelled

B The AVERAGE function requires a filter argument

C The 'FrequencyDrift' column contains text values instead of numbers

D The measure syntax is missing a closing parenthesis

💡 Hint

Consider what happens if numeric aggregation functions receive non-numeric data.

If the 'FrequencyDrift' column contains text, AVERAGE returns blank (not zero) because it cannot compute numeric averages on text data.

❓ data_modeling

expert

Designing a Data Model for Crystal Oscillator Testing

You need to design a data model to store test results of multiple crystal oscillators, each tested multiple times under different temperatures and load conditions. Which data model design is best?

A One table with columns: OscillatorID, TestID, Temperature, Load, FrequencyDrift

B Separate tables for Oscillators, Tests, and Conditions linked by keys

C One table with repeated columns for each test: FrequencyDrift1, FrequencyDrift2, etc.

D Store all test data as JSON strings in a single column

💡 Hint

Think about normalization and how to avoid data duplication for flexible analysis.

Using separate tables linked by keys allows efficient storage, avoids duplication, and supports flexible queries across oscillators, tests, and conditions.