HLT-PHYS81-01 · Lesson 6 · 18 clock hours · lab
Digital Tools for the Rehab Clinic: Scheduling, Data Entry & Professional Communication
Objective. Students will demonstrate basic competency with clinic-relevant digital tools by navigating a simulated electronic scheduling interface, entering patient exercise data into a spreadsheet accurately, and composing a professional email communication appropriate for the clinical setting.
⚠ Pending professional review
This lesson, its worked examples and its practice questions has not yet been verified by a licensed clinician in the field or by a certification or approval body. It is a study draft and may contain errors. Do not use it to make decisions about any patient or medication. Always follow your instructor, your supervising professional, and current official references and regulations.
VoTechWorks program approval and accreditation are still in progress. Credentials are issued only by the certifying bodies named in each program, after their own exams.
Why Digital Skills Matter in the Rehab Clinic
Modern physical therapy clinics depend on digital tools for almost every part of daily operations. As a rehab aide, you will use computers or tablets to look up appointments, record patient progress, and communicate with staff and patients. Mistakes in scheduling or data entry can delay patient care, create billing errors, or compromise patient safety. Professionalism in written communication — including email — reflects on the entire clinic and affects patient trust. Developing these skills now prepares you to contribute from your first day on the job.
Electronic Scheduling Systems
Clinics use scheduling software to manage appointments for multiple providers and treatment rooms. As an aide, you will typically work with a system that has already been set up by office staff or the supervising physical therapist (PT). Your role is to navigate that system accurately — not to configure it.
Key tasks you may perform under supervision include:
- Finding a patient's appointment — Use the patient name or ID to pull up their scheduled visit. Confirm the date, time, provider, and room.
- Recording an appointment change — When a patient calls to reschedule, document the change immediately. Never rely on memory. If your clinic uses a paper backup, update both systems.
- Flagging a room as unavailable — If a treatment room is being cleaned, has equipment down, or is reserved for a procedure, mark it unavailable so the scheduler does not accidentally book a patient there.
- Entering a new patient — New-patient entries typically require full legal name, date of birth, contact information, and insurance details. Enter exactly what is on the intake form — do not guess or abbreviate.
- Generating a printed daily schedule — Most systems allow you to print a schedule filtered by provider or room. Verify the date before printing. This schedule guides the entire clinical team through the day.
Safety note: Never change or delete an appointment without clear instruction from a licensed clinician or office supervisor. Unauthorized changes can cause a patient to miss medically necessary care.
Spreadsheet Data Entry
Spreadsheets — such as Microsoft Excel or Google Sheets — are used to track patient exercise completion, supply inventory, and other clinical data. Accurate data entry is critical because errors can affect decisions made by the supervising PT about a patient's home exercise program (HEP).
Best practices for data entry:
- Use exact values from the source document — do not round unless instructed.
- Enter numbers as numbers, not text (avoid adding extra spaces or letters).
- Label every column with a clear header: for example, Patient ID, Exercise Name, Sessions Assigned, Sessions Completed, Completion %.
- Double-check entries against the source before moving on.
- Use a simple formula to calculate completion percentage: divide sessions completed by sessions assigned, then multiply by 100. In most spreadsheet programs the formula looks like `=( B2 / A2 ) * 100` where B2 is completed and A2 is assigned.
Safety note: Spreadsheets containing patient information are protected health information (PHI) under HIPAA. Never share, email, or print these files without supervisor authorization. Lock your screen when you step away from the workstation.
Professional Email Communication
Email is a formal business tool. Clinic emails may be read by patients, insurers, or regulatory bodies. Every message you send reflects your professionalism and the clinic's reputation.
Four qualities of a professional clinical email:
1. Tone — Polite, respectful, and appropriate to the reader. Avoid slang, humor that could be misread, or emotional language. Use a formal greeting ("Dear Mr. Rojas,") and a courteous closing ("Sincerely," or "Best regards,").
2. Spelling — Use spell-check, but also proofread manually. Spell-check will not catch correctly spelled wrong words (for example, "patent" instead of "patient").
3. Clarity — State your purpose in the first sentence. Be specific. If you are confirming an appointment, include the date, time, and location. If you are reporting a supply shortage, name the item and the quantity remaining.
4. Completeness — Include all information the reader needs to act. For a patient confirmation email: appointment details, what to wear, what documents to bring, and a contact number if they have questions.
Safety note: Never include clinical findings, diagnosis details, or treatment notes in an email unless you have been specifically trained and authorized to do so by your supervising PT. Protect patient privacy in every message.
Scope of Practice Reminder
Digital tools support clinical care — they do not replace clinical judgment. As a rehab aide, you document and communicate what you observe and what you are directed to record. You do not interpret clinical data, modify treatment plans, or make decisions about patient care. If you are uncertain whether a task falls within your role, stop and ask your supervising PT before proceeding. This protects patients and protects you.
Putting It All Together
In today's lab you will practice all three skill sets: scheduling tasks, spreadsheet data entry, and professional email writing. Work carefully, verify your entries, and remember that the habits you build now — accuracy, professionalism, and privacy awareness — are the habits that will define your career as a rehab aide.
Key terms8
Electronic Health Record (EHR) / Scheduling SystemSoftware used by clinics to manage patient appointments, provider schedules, and treatment room availability; aides navigate these systems under supervision.
Home Exercise Program (HEP)A set of exercises prescribed by a physical therapist for a patient to perform independently at home; aides may track and record HEP completion data.
Completion PercentageThe proportion of assigned exercise sessions a patient actually completed, calculated by dividing sessions completed by sessions assigned and multiplying by 100.
Protected Health Information (PHI)Any individually identifiable health information protected by HIPAA; includes patient names, dates, contact information, and clinical data stored in digital files.
HIPAAThe Health Insurance Portability and Accountability Act; the federal law that sets standards for protecting patient privacy and health information.
Scope of PracticeThe tasks a rehab aide is trained and authorized to perform; aides document and support care but do not interpret clinical data or make treatment decisions.
Professional ToneLanguage in written communication that is respectful, clear, and appropriate for a clinical or business setting; avoids slang, emotional language, and informality.
Data IntegrityThe accuracy and consistency of data entered into a system; maintaining data integrity means entering information exactly as it appears on the source document.
Worked examples4
1. A patient was assigned 20 home exercise sessions over four weeks and completed 15 of them. Calculate their HEP completion percentage.
- Identify the values: Sessions Completed = 15, Sessions Assigned = 20.
- Divide sessions completed by sessions assigned: 15 ÷ 20 = 0.75.
- Multiply by 100 to convert to a percentage: 0.75 × 100 = 75.
Answer: The patient's HEP completion percentage is 75%.
2. A patient was assigned 8 sessions and completed 8 sessions. What is their completion percentage? Write the spreadsheet formula if completed sessions are in cell B2 and assigned sessions are in cell A2.
- Identify the values: Sessions Completed = 8 (cell B2), Sessions Assigned = 8 (cell A2).
- Write the formula: =(B2/A2)*100
- Calculate: 8 ÷ 8 = 1.0; 1.0 × 100 = 100.
Answer: The completion percentage is 100%. The spreadsheet formula is =(B2/A2)*100.
3. A patient was assigned 30 sessions and completed 21. Calculate the completion percentage and determine whether this rounds to the nearest whole number.
- Divide sessions completed by sessions assigned: 21 ÷ 30 = 0.70.
- Multiply by 100: 0.70 × 100 = 70.
- 70 is already a whole number, so no rounding is needed.
Answer: The patient's HEP completion percentage is 70%.
4. A patient completed 17 out of 25 assigned sessions. Calculate the completion percentage and round to one decimal place.
- Divide sessions completed by sessions assigned: 17 ÷ 25 = 0.68.
- Multiply by 100: 0.68 × 100 = 68.
- 68.0 is already expressed to one decimal place.
Answer: The patient's HEP completion percentage is 68.0%.
The math in this lesson1
Learners compute a home exercise completion percentage from sessions completed over assigned.
7.RP.3
In class: Log in to a simulated or actual electronic scheduling demo (instructor-configured spreadsheet or free scheduling software demo) and complete five tasks: find a patient appointment, record an appointment change, flag a room as unavailable, enter a new patient, and generate a printed daily schedule for one PT; compare output to an answer key. · Enter a set of ten patient home exercise program completion records into a provided spreadsheet template, apply a simple formula to calculate each patient's completion percentage, and format the spreadsheet with proper column headers; the instructor checks for data accuracy and formula correctness. · Compose three professional emails in a word processor: (1) a response to a patient asking to reschedule, (2) a message to the supervising PT reporting a supply shortage, and (3) a message to a new patient confirming their first appointment and what to bring; evaluate each against a professional communication rubric covering tone, spelling, clarity, and completeness.
Materials: Computers or tablets with internet access, scheduling software demo or instructor-prepared spreadsheet template, data entry worksheet, email rubric, word processor (Google Docs or Microsoft Word), printer
Check: Scheduling and data entry tasks scored against answer key at 90% accuracy. Email rubric scored by instructor: all three emails must meet Professional on all four rubric categories (tone, spelling, clarity, completeness) to pass.
Practice check8
Answer each question, then check it. Nothing is recorded; this is your own practice.
Record this lesson on my transcript. Sign in with your key and enrollment email to record lessons (enroll free if you have no key). This page stays open to read and practise.