The Images in U7L3L8 are no longer working, which is the “How well do you know the 100 most influential African-Americans?” Very sad, this is a great app!
I brought this issue up as well a few weeks ago and I was essentially brushed aside.
Since I agree, it is a great qyuz app, I compiled a 95%+ working images. See the attached file you can download and then import and share with your students.
WorkingRoot100.csv (17.2 KB)
Here’s my best guess of why this is happening to not only this app but to others when it comes to images not showing up.
Someone at Code.org was assigned to create a new database and when you ask AI to do this, they are decent at text and numbers but AI just grabs the first image it finds on the Internet and there are many sites which prevent people from using these images. In addition, if they are too big that caused issues when applab times out when it doesn’t arrive. This person at code.org is not understanding that just because it generates a gives you a link, that doesn’t mean it is working. In my experience, they haven’t attempted to fix any of these issues. I have vented earlier today about other issues and it is starting to feel like no one is working at code.org to address and resolve issues.
For over a year, I keep checking if AI is getting better at building databases and it has improved but not with images. It usually like smaller batches of requests, under 10 images to find. In addition, I have compiled and trained Gemini to use my “Perfect Image Protocol” to help my students build custom databases.
Here’s what you should feed Gemini and then request small batches of 10. It usually find 8 or more working photos of the 10 you will request.
Protocol is below:
Prompting Your AI for a Simple Starter *.CSV File.
Copy/Paste The Perfect Image” Protocol below.
Reading and understanding the protocol is important.
Tweak the prompt at the bottom with your theme.
You can always add 10 more records at a time.
*****************************************************
The “Perfect Image” Protocol (Wikimedia V4.0)
System Role & Data Structure
-
Role: Act as a data scientist and spreadsheet expert.
-
Naming Convention: All column names must use lowerCamelCase (e.g., athleteName, imageAddress).
-
Output Format: Provide data in a clean CSV format and or a way to open in Google Sheets.
The Wikimedia Redirect Protocol To ensure images load reliably in Google Sheets, apply these strict rules to the imageAddress:
-
Source: Use Wikimedia Commons exclusively.
-
Rule 1 - The “No Ghost” Rule: Never guess a filename. You must perform a search to find a real, existing file. If a simple name like Name_2020.jpg does not exist, do not invent it. Use the actual, slightly longer filename found (e.g., Name_at_event_date.jpg).
-
Rule 2 - Case Sensitivity: Wikimedia URLs are strictly case-sensitive. You must match the file extension exactly.
-
Critical: Check if the file is .jpg, .JPG, .jpeg, or .png.
-
Example: File:Image.JPG will break if you write File:Image.jpg.
-
-
Rule 3 - Space Handling: Replace all spaces in the filename with underscores (_).
-
Rule 4 - Construct the URL: Use the stable redirect pattern:
-
Constraint: Return the image at 400px width.
-
Remember this “Perfect Image” Protocol for every time I ask for you to find image addresses.
-
If you cannot find an image address, then please use a similar proxy. The intent is to not use a proxy unless we have no other options. Still use as many of the rules within the protocol as possible.
The Prompt Template
"Please create a spreadsheet with 10 records for the theme: [INSERT THEME HERE]. Include 6 relevant data columns.
For the imageAddress column, apply the ‘Wikimedia Redirect Protocol V4.0’:
-
Search & Verify: Find a specific, existing file on Wikimedia Commons. Do not guess ‘clean’ names.
-
Case Check: Ensure the filename and extension (.jpg vs .JPG) match the source exactly.
-
Construct URL: Use …Special:Redirect/file/[Exact_Filename]&width=400.
-
Ensure the link is stable and low-resolution."