Overview
To accurately review, clean, and standardize medication tracking data from handwritten logs and electronic prescriptions into a structured spreadsheet while ensuring all records are complete, consistent, and error-free.
Scope of Work
Extract required information from handwritten logs and electronic prescription documents
Identify and remove duplicate or inconsistent medication entries
Correct formatting inconsistencies for medication names, dosages, patient names, and refill dates
Standardize entries for uniform structure across the spreadsheet
Verify completeness and flag missing or unclear information
Ensure prescribing doctor names and notes are accurate and consistently formatted
Maintain confidentiality and integrity of all patient and prescription data
Required Data Fields
Medication Name
Dosage
Patient Name
Prescribing Doctor
Refill Date
Notes
Prescription ID
Patient ID
Date Prescribed
Data Entry Date
Deliverables
Delivery One: A Word document report summarizing the data cleaning process, issues identified, corrections made, and number of prescriptions processed
Delivery Two: The final cleaned, standardized, and verified spreadsheet containing all medication tracking records
Client Materials
All handwritten logs and electronic prescription documents will be provided upon hire.
Deadline
All deliverables must be submitted on or before 17th February 2026 at 10:00 PM.