I will rewrite it according to the same principle. There are two additional nuances to consider, so I will address them after the text.
Digitization and structuring of official open educational materials into a Google spreadsheet
I am looking for a performer for technical work: transferring officially published open educational materials into a structured Google spreadsheet and organizing accompanying images.
Data source
Only the official source — DNT "Center for Quality of Education of the Ministry of Health" (testcentr.org.ua) and its educational module (testcentr.net): officially open and demonstration brochures and tasks. Third-party collections are not used.
Important: we only take officially published open brochures and demo tasks (the complete closed database is not used). The Center's materials are allowed for non-commercial use with the preservation of author information — the legality of further use is agreed separately before publication.
Volume (only officially available)
- Levels: Step 1, Step 2, Step 3, Step M (and Step B, if available).
- Specialties: medicine (general medical training), dentistry, pharmacy, nursing, etc.
- Years: all officially available.
What needs to be done
- Transfer the content into a Google spreadsheet with the structure:
- Level (Step 1 / Step 2 / Step 3 / Step M)
- Specialty
- Year
- Question number
- Text of the question (clinical situation / task)
- Answer options (A, B, C, D, E)
- Correct answer
- Has image (yes / no)
- Image file name (if any)
- Save images separately on Google Drive:
- the file name clearly corresponds to the question, format:
krok<level>_<specialty>_<year>_<question number> (e.g. krok1_med_2024_q045.png); - folder structure: level → specialty → year;
- the name in the table matches the name of the file on the drive.
Result
Link to the Google spreadsheet + link to the Google Drive folder with images (with access for the team).
Quality requirements
- The data in the table accurately corresponds to the original official brochures of the Center.
- Images of normal quality, without watermarks, correspond to the original.
- Each image is linked specifically to its question.
