Project Lab

Real State Job Examples & Practice

Study 8 real California State job examples. Each includes writing samples, coding tasks, and feedback from State hiring managers showing exactly what they value.

Select a Job to Study

Staff Services Analyst I — Department of Water Resources

Category: Analysis & Reporting

Control Number: JC-123456

Analyze water quality data and prepare technical reports for regulatory compliance

Writing Sample

The Prompt

Write a brief analysis comparing two water quality monitoring reports and explain what the differences mean for public health.

Example Answer

The Q3 2024 monitoring report from the Sacramento watershed shows elevated pH levels (8.2) compared to Q2 2024 (7.9). The increase correlates with recent algal bloom activity documented by the regional office. Public health implications include potential bioaccumulation of toxins in drinking water sources. Recommended action: increase sampling frequency to weekly and notify downstream water treatment facilities of the alkalinity shift.

Why This Works

Strong example. You correctly identified the trend, explained the cause (algae), understood the public health angle, and proposed actionable next steps. State hiring managers want analysts who connect data to real consequences.

Technical Task

The Prompt

Write a Python script that reads water quality CSV data and flags values outside acceptable ranges

Example Code


import pandas as pd

def check_water_quality(csv_file, limits):
    df = pd.read_csv(csv_file)

    for col in ['pH', 'Turbidity', 'Temperature']:
        if col in df.columns:
            df['is_flagged'] = (df[col] < limits[col]['min']) | (df[col] > limits[col]['max'])
            flagged = df[df['is_flagged']]
            if len(flagged) > 0:
                print(f"\n{col} violations found: {len(flagged)} samples")
                print(flagged[['Date', col]].to_string())

    return df

limits = {'pH': {'min': 6.5, 'max': 8.5}, 'Turbidity': {'min': 0, 'max': 5}, 'Temperature': {'min': 0, 'max': 25}}
results = check_water_quality('water_data.csv', limits)

Why This Works

Good approach. The script reads data, iterates through key metrics, and flags outliers — exactly what a State analyst needs. You used clear variable names and handled multiple columns efficiently. In the real job, you'd also log these to a database and generate a summary report.

Ready to practice? Analyze a real job posting and get your personalized roadmap.

Analyze a Job Posting