Prompt

Data Extraction and Manipulation from an ImageV2

September 16, 2025 Todd Benrud Teacher Prompts

This is an AI workflow for extracting student data from images and converting it to email lists and CSV files. School administrators, registrars, or teachers use AI to process class rosters, enrollment sheets, or student lists by uploading an image. The AI identifies each student's name and ID number from the image, generates school email addresses using a specific format ([StudentID]@guhsd.net), and outputs both a plain-text email list and a downloadable CSV file with organized student data. This streamlines data entry tasks and eliminates manual typing errors when creating digital student records or contact lists.

Content

Act as a data extraction specialist. Examine the attached image and identify all students listed. For each student, extract:

- First Name

- Last Name

- Student ID number


Generate an email for each student using the format: [StudentID]@guhsd.net


Produce and return:

1. A plain-text list of all email addresses, one per line.

2. A downloadable CSV file named students.csv containing the following columns (in order): First Name, Last Name, Email.


Reason through the process by:

- Carefully identifying and verifying each student's name and ID from the image data.

- Constructing the correct email addresses using the specified pattern.

- Assembling the required CSV with accurate column placement and formatting.


Example:

_Input information (from image):_

First Name: Jane  

Last Name: Smith  

ID: 654321


Output email:  

654321@guhsd.net


CSV row:  

Jane,Smith,654321@guhsd.net


**Output format:**

- A plain-text email address for each student. Organize into a bulleted list of email addresses.

- Immediately after, provide the content for students.csv as plain CSV text (no code blocks), using a header row and one row per student.  

- Last, a link to a downloadable .csv file. 

- Clearly label each section with a bold heading (e.g., "Email List:" and "students.csv:") for clarity.

- Do not explain your process in the output; only output the list of email addresses, CSV data, and downloadable .csv file as requested.


**Important Reminders:**

- Double-check spelling and ID accuracy from the image.

- Ensure the email format strictly follows the pattern [ID]@guhsd.net.

- The output should be ready to directly copy-paste or download as appropriate.



Related Content
Prompt
Stock Market Simulation Game for Classroom Use V1
Outlines a three-step AI prompting process for creating an interactive stock market game in Claude Artifacts. You'll guide students through simulating 30 trading days in a 30-minute period using a $25,000 portfolio with 10 real companies. The React-b...
Teacher Prompts
Prompt
Resume Refinement AI Prompts for Educational Leaders V1
These are three sequential prompts you can use with AI to refine your resume for educational technology positions. First, you'll customize your resume to match a specific job description and highlight your edtech vision. Second, you'll receive candid...
Teacher Prompts
Prompt
Pretrained Project: Two-Tier Sentence Frames V1
This AI prompt creates two-tier sentence frames to help your students start writing assignments. Tier 1 provides minimal support with blank lines, giving students autonomy. Tier 2 offers enhanced support with contextual hints in brackets when student...
Student Prompts
Prompt
Flash Card Generator Prompt: OpenSciEd C.1 Thermodynamics Unit V1
Prompt to create flashcards in NotebookLM for an exam review. This is a first attempt, untested prompt. This is a prompt for AI to generate 60 flash cards for 11th-12th grade students studying OpenSciEd's thermodynamics unit on polar ice. You'll use ...
Project Prompts
Prompt
Teacher Prompt Enhancer V1
This is a custom GPT prompt that transforms basic teacher prompts into polished, classroom-ready AI prompts. You'll use it to improve your own prompts before using AI tools to create educational content. It analyzes your initial prompt for missing de...
Teacher Prompts
Prompt
PDF Data Extractor and Link Creator V1
This tool automates prefilled Google Form URLs from PDF grade reports, eliminating manual data entry for teachers submitting multiple student grades. You upload PDF grade reports and provide your teacher name, and the system extracts each student's i...
Teacher Prompts