Test Data Prompt

 create a prompt to research 2020-2025 Pocahontas County, West Virginia school test data, analyze it, and develop 10 hypotheses. Include all five schools in the report. Byline should be "An AI Product of the Salt Shaker Press."

Pocahontas County School Data Analysis
Research Websites and Files
(1) Scan the attached file 'WV_Balanced_Scorecard_Data_2025 (1).xlsx - SY25 Balanced Scorecard Results.csv' to identify all schools listed for "Pocahontas" in the "District Name" column. Confirm these are the five schools for the report.
(2) From the '...SY25 Balanced Scorecard Results.csv' file, extract and analyze the 2025 data for the 'Totals' subgroup for all five Pocahontas County schools. Focus on key indicators: 'Assessment ELA Performance Value', 'Assessment Math Performance Value', 'Attendance Value', and 'Discipline Value'.
(3) In the 2025 data from the CSV, compare the performance of student subgroups (e.g., 'Economically Disadvantaged', 'Children With Disabilities') against the 'Totals' subgroup for each of the five schools to identify any significant performance gaps.
(4) Perform Google searches using keywords like "West Virginia Department of Education Balanced Scorecard," "WV Zoom data," or "Pocahontas County Schools test scores" to locate publicly available school test data for the years 2020, 2021, 2022, 2023, and 2024 for all five identified Pocahontas County schools.
(5) If 2020-2024 data is successfully retrieved, synthesize it with the 2025 data from the CSV file to analyze longitudinal trends in ELA and Math proficiency for each school. Note any sharp improvements or declines.
(6) Conduct Google searches for news articles or official reports related to Pocahontas County, WV, from 2020-2025. Look for information on any new educational initiatives, school board policies, or significant local events (e.g., socioeconomic changes, pandemic response) that could provide context for the data.
(7) Based on the complete analysis of the 2025 file data, any identified 2020-2024 trends, subgroup performance gaps, and contextual information, formulate 10 distinct hypotheses explaining the observed data patterns.
(8) Compile the final report, starting with an analysis of the 2020-2025 data for all five schools, followed by the 10 hypotheses. Ensure the report is clearly bylined with "An AI Product of the Salt Shaker Press."

 

 

Sample news prompt

 

News Copy 

Option 2: Advanced & Detailed Prompt

This prompt provides more specific constraints and role-playing, leading to a more structured and professional-sounding news article. It's better for complex or nuanced text.

Prompt:

Your Role: You are a professional journalist working on a deadline. Your task is to take the information from the provided text image and format it into a formal, objective news article suitable for publication.

Input: [Image attached]

Your Process:

1. Analyze & Extract: First, silently analyze the image and extract all key factual information. Identify the "Five Ws": * Who: Who is involved (people, organizations)? * What: What is the main event or announcement? * When: When did this happen, or when will it happen? * Where: Where is this taking place? * Why/How: What is the context, cause, or purpose mentioned?

2. Write the News Story: Using only the extracted information, write a news story that follows the "inverted pyramid" structure (most important information first).

Output Requirements:

• Headline: Write a concise, factual, and neutral headline.

• Dateline: Begin the story with a dateline. If the location is specified, use it (e.g., CITY, State --). If not, use a generic placeholder like [LOCATION] --.

• Lead Paragraph (Lede): The first paragraph must be a strong lede that clearly summarizes the most critical "Five Ws" (or as many as are available).

• Body Paragraphs: Subsequent paragraphs should expand on the lede, providing supporting details, context, or direct quotes found in the text.

• Tone: The writing style must be strictly objective, neutral, and formal. Do not use sensational language, personal opinions, or emotional speculation.

Crucial Constraint (Handling Missing Information): If the text image does not provide information for one of the "Five Ws" (like a specific date, location, or reason), you must not invent it. Either omit that detail or use qualifying phrases like "at an unspecified date," "the reasoning was not provided," or "the event took place at an undisclosed location."

---

Example of How to Use It

You: [Upload an image of a tweet that says: "BREAKING: The City Council just passed the 'Green Futures' bill, 5-2. This means solar panels are now mandatory on all new commercial buildings starting Jan 1. Big win for the environment! #cleanenergy #localgov"]

You: (Using the Advanced Prompt)

Your Role: You are a professional journalist... [etc.]

Expected AI Response:

Headline: City Council Passes 'Green Futures' Bill Mandating Solar Panels on New Commercial Buildings

[CITY, State] -- The City Council has passed the "GreenFutures" bill in a 5-2 vote, according to a recent announcement. The new legislation mandates the installation of solar panels on all new commercial construction.

The measure is set to take effect on January 1. Proponents of the bill described its passage as a "big win for the environment" and a step forward for clean energy initiatives within the city. The vote reflects a local government effort to advance environmental policy through building regulations.