Run a Mock Medical Front Desk Shift

Build a mobile shift board to practice scheduling, routing, and handoffs.

Introduction

30 Second Summary

A busy clinic shift can leave the next person guessing about what happened. Unfinished requests are easy to miss when there is no clear handoff.

In this project, you will build a fictional clinic shift board in Google Sheets on your phone or tablet. You will use it to document front-desk decisions without entering real patient information.

What You'll Build

On your phone or tablet, a completed shift board will let you walk an interviewer through each fictional case from request to current status.

By the end of this project, you'll have:

A conflict-resolution walkthrough that exposes the duplicate 09:30 slot before showing PT-103 moved to 10:00 under the simulation rule.
A privacy-aware follow-up queue where intake and insurance items stay visible without names, birth dates, phone numbers, or real insurance details.
A filtered handoff view that keeps unfinished work visible. Its note shows that the clinical question was routed to the clinical team.
Secret Mission: Add a priority system and rewrite the handoff so the High clinical item appears first.

Are there any prerequisites?

No healthcare or virtual assistant experience is required. Step 1 covers the full mobile setup for Google Sheets and a Google Account.

Before We Start

This first checkpoint lets you commit to the fictional clinic shift board before any hands-on work. Naming the medical front-desk skills you want to demonstrate gives the simulation a clear purpose.

Set Up Google Sheets on Mobile

A fictional clinic shift board only works when every task stays in one reliable workspace. Switching between apps would make this practice shift harder to follow.

You'll use Google Sheets on your phone or tablet to keep the full simulation in one spreadsheet. A Google Account gives you access to create the file at no charge.

In this step, get ready to:

Install Google Sheets on your mobile device.
Sign in with a Google Account.
Prepare a named shift board with a training label plus six formatted headers.

Why use one spreadsheet?

One spreadsheet keeps the schedule plus every administrative request in the same mobile workspace. This lets you focus on accurate decisions throughout the simulation.

Install and sign in

The mobile app lets you edit the shift board directly from your phone or tablet. First, check whether it is already available on your device.

Check your Home screen or app library for Google Sheets.

✔️ Google Sheets is installed

Your device already has the app, so you can continue to sign-in.

Tap Google Sheets on your Home screen or in your app library.

ⓧ I need to install Google Sheets

Choose your device type below to install the app from its official store.

macOS

Use these instructions for an iPhone or iPad.

Open the App Store on your iPhone or iPad.
Open the Google Sheets listing in the App Store.
Tap GET INSTALL.

Google Sheets should now appear on your Home screen.

Windows

Use these instructions for an Android phone or tablet.

Open the Play Store on your Android device.
Open the Google Sheets listing in the Play Store.
Tap Install.

Google Sheets should now appear on your Home screen.

Google Sheets stores the shift board in your signed-in account. Choose the path that matches your current account setup.

✔️ I have a Google Account

Tap Google Sheets on your Home screen.
Follow the sign-in screen to choose your Google Account.
Complete the sign-in prompts.

You'll return to Google Sheets under your signed-in account.

ⓧ I need a Google Account

Open Google's Create a Google Account guide.
Choose Create account.
Select Personal use.
Follow the on-screen prompts to finish creating your account.
Return to Google Sheets.
Complete the sign-in prompts with your new account.

You'll return to Google Sheets under your new signed-in account.

Can't finish the setup?

Confirm your device has an internet connection before retrying the installation.
Complete any unfinished account prompts before returning to Google Sheets.

Ask for help with setting up Google Sheets on my mobile device.

Create and name the spreadsheet

A specific file name makes the practice board easy to find throughout the simulation. The creation steps differ slightly between Android devices plus iPhones or iPads.

macOS

Use this path in Google Sheets on an iPhone or iPad.

Tap Create in the bottom right.
Choose a new spreadsheet.
Enter Fictional Clinic Shift Board as the name.
Tap Create.

You'll see a blank spreadsheet with Fictional Clinic Shift Board as its name.

Windows

Use this path in Google Sheets on an Android phone or tablet.

Tap Create in the bottom right.
Choose a new spreadsheet.

You'll see a blank spreadsheet. Rename it if Google Sheets has given it another name.

Return to the Google Sheets file list.
Tap More beside the new spreadsheet.
Tap Rename.
Enter Fictional Clinic Shift Board.
Tap Ok.
Tap Fictional Clinic Shift Board in the file list.

Your practice shift now has a clear home. You should see Fictional Clinic Shift Board open in Google Sheets.

Add the training label and headers

A visible training label separates this simulation from real clinic work. The six headers give every task a consistent place on the board.

Double-tap cell A1.
Enter TRAINING ONLY: FICTIONAL DATA.

You'll see the training label in the first cell.

Tap Done.
Tap outside cell A1 to save the entry.

Online changes save automatically after you leave the edited cell.

Enter Time in cell A2.
Enter Case ID in cell B2.

The first two headers identify when each request occurs plus which fictional case it belongs to.

Enter Request in cell C2.
Enter Check in cell D2.

The next two headers show what the case needs plus what must be checked.

Enter Action/Route in cell E2.
Enter Status in cell F2.

Your six-column structure is now visible across row 2.

Select cells A2:F2 with the selection handles.
Tap Format.

The formatting panel displays separate Text plus Cell tabs.

Tap the Text tab.
Tap Bold.

The six header labels should now appear in bold text.

Tap the Cell tab.
Choose a fill color for the selected header cells.

The header row should now stand apart from the blank rows below it.

Tap the sheet outside the formatting panel to save.

Before you inspect the finished board, do you think every required cell is complete?

Read cell A1 from the top of the sheet.
Scan cells A2:F2 from left to right.

You should see TRAINING ONLY: FICTIONAL DATA in cell A1. You should see Time, Case ID, Request, Check, Action/Route, plus Status across row 2.

Each header should have bold text plus a fill color. Your mobile workspace is ready for the simulated shift.

Your fictional clinic shift board has a clear structure plus a visible training label. Next, you'll add the first appointments to reveal the scheduling conflict.

Build the First Schedule View

Your Google Sheets workspace now has the Fictional Clinic Shift Board open. Its training label and formatted headers are ready for the shift data.

A raw schedule makes each appointment visible. Reading the rows as a queue exposes a time conflict that the current board cannot resolve.

In this step, get ready to:

Add three fictional appointments to the shift board.
Inspect the morning schedule for a conflict.
Preserve the issue you discover for the next step.

Enter the fictional appointments

Each appointment uses one row beneath the headers. Keeping each detail in its matching column creates an appointment tracking view you can scan from left to right.

Enter 09:00 in cell A3.
Enter PT-101 in cell B3.
Enter New patient appointment in cell C3.
Enter Ready in cell D3.
Enter Confirm in cell E3.
Enter Open in cell F3.

Your first fictional appointment is now visible across row 3.

Enter 09:30 in cell A4.
Enter PT-102 in cell B4.
Enter Follow-up appointment in cell C4.
Enter Ready in cell D4.
Enter Confirm in cell E4.
Enter Open in cell F4.

Your second fictional appointment now occupies row 4 at 09:30.

Enter 09:30 in cell A5.
Enter PT-103 in cell B5.
Enter New patient appointment in cell C5.
Enter Ready in cell D5.
Enter Needs review in cell E5.
Enter Open in cell F5.

Your third fictional appointment now appears across row 5.

Review the board as the shift begins

A schedule review checks whether the listed appointments can proceed as written. The time column is the fastest place to spot a conflict.

Before you inspect the times, do you think every appointment has its own slot?

Scan the Time column from A3 through A5.
Read row 4 from left to right.
Read row 5 from left to right.

You'll see that PT-102 and PT-103 both show 09:30. This duplicate time slot is the intended scheduling conflict.

The board currently records both appointments without resolving which one can use that time.

Preserve the scheduling conflict

Keeping the unresolved conflict visible creates a clear starting point for the scheduling decision. The duplicate remains part of the board at the end of this step.

Tap outside the final edited cell to save the entries.
Keep 09:30 in cell A4.
Keep 09:30 in cell A5.

Before your final check, do you expect the Time column to contain three unique times?

Read down the Time column from row 3 through row 5.
Read across row 4 to confirm that PT-102 shows 09:30.
Read across row 5 to confirm that PT-103 shows 09:30.

You'll see 09:00, 09:30, and another 09:30 in the Time column. Both PT-102 and PT-103 remain open at the duplicated time.

Good catch. Your schedule now exposes the exact conflict that needs a documented decision.

The first schedule view is complete. Next, you'll apply the simulation rule to resolve the duplicated time and record the outcome.

Resolve the Double-Booking

Your Google Sheets shift board now shows three fictional appointments. The matching 09:30 times for PT-102 and PT-103 expose a double-booking.

The duplicated 09:30 slot makes the schedule unreliable. This step uses a simulation-only scheduling rule to resolve that conflict.

In this step, get ready to:

Apply the simulation-only scheduling rule to the shared 09:30 slot.
Reschedule PT-103 to 10:00 with a completed status.
Confirm PT-102 at 09:30 with a completed status.

Apply the simulation scheduling rule

In this simulation, the follow-up appointment keeps the shared time. The new-patient appointment moves to the next open time.

Why This Rule Is Simulation-Only

This rule supports a consistent training decision. A real clinic's scheduling policy determines what you do at work.

Correct PT-103

The rule points to PT-103 because its request is New patient appointment. Its next open time in this exercise is 10:00.

Replace the value in cell A5 with 10:00.
Replace the value in cell E5 with Rescheduled to 10:00.
Replace the value in cell F5 with Done.
Tap outside the final edited cell to save the row.
Read row 5 from left to right.

Good work. PT-103 now has its own time with a documented outcome.

PT-103 Still Showing 09:30?

Check that row 5 contains PT-103.
Replace the value in A5 with 10:00.
Tap outside the edited cell to save the change.

Help me correct the PT-103 row in my fictional clinic shift board.

Finish the confirmed follow-up

PT-102 is the follow-up appointment, so the training rule keeps its 09:30 time. Its remaining fields record that the follow-up is complete.

Replace the value in cell E4 with Confirmed.
Replace the value in cell F4 with Done.
Tap outside the final edited cell to save the row.

Before you check the whole schedule, how many distinct appointment times do you expect to see?

Scan the Time column from rows 3 through 5.
Read the Case ID column from rows 3 through 5.
Read the PT-102 row from left to right.
Read the PT-103 row from left to right.

You'll see 09:00, 09:30, and 10:00 once each in the Time column. The Case ID column still reads PT-101, PT-102, and PT-103.

PT-102 shows Confirmed with Done. PT-103 shows Rescheduled to 10:00 with Done.

That's the conflict resolved. Your board now gives every appointment a unique time with the scheduling decision recorded.

Schedule Still Showing a Conflict?

Check that A4 remains 09:30.
Check that A5 shows 10:00.
Confirm that E4 says Confirmed.
Confirm that F4 says Done.

Help me compare my corrected schedule with the expected rows.

Your schedule now has one trustworthy time for each appointment. Next, you'll track missing intake and insurance information without adding real patient details.

Track Missing Information

Your Google Sheets board now gives every appointment a unique time. The recorded actions preserve each scheduling decision.

A resolved schedule can still contain cases that need administrative follow-up. Missing information can prevent the next action from moving forward.

This step turns each gap into a visible follow-up task. A minimum-necessary information check keeps real patient details out of the training board.

In this step, get ready to:

Update PT-101 to show the missing intake item.
Add PT-104 as an insurance follow-up task.
Check every row for minimum-necessary information.

Turn PT-101 into an intake follow-up

An intake follow-up needs a clear missing-item note. Its status must show that the case is waiting for information.

Editing several cells on a phone can feel cramped. Short checks keep each change easy to verify.

Find PT-101 in row 3.
Replace Ready in cell D3 with Contact detail missing.
Replace Confirm in cell E3 with Request update.

You should see Contact detail missing in D3. You should see Request update in E3.

Replace Open in cell F3 with Waiting.
Tap outside the edited cell to save the change.

That follow-up is now clear. PT-101 shows the missing detail plus the requested next action.

Add a fictional insurance task

Insurance verification can pause when a required identifier is missing. The board records the missing item without storing the identifier itself.

Enter 10:15 in cell A6.
Enter PT-104 in cell B6.

The new row now has a time. It also has a fictional case ID.

Enter Insurance verification in cell C6.
Enter Member ID missing in cell D6.

The row now identifies the administrative task. It also states which item is missing.

Enter Request missing ID in cell E6.
Enter Waiting in cell F6.

The new task now shows the requested next action. Its Waiting status keeps the unfinished work visible.

Tap outside the edited cell to save the row.

You have added the fourth fictional case. PT-104 now records the insurance follow-up without containing an actual member ID.

Check the sheet for minimum-necessary information

A practice board needs enough information to explain the work. Fictional identifiers keep the exercise separate from any real person.

What stays out of the board?

This exercise uses fictional case IDs. Keep these real-world details out:

Names.
Dates of birth.
Phone numbers or other contact details.
Diagnoses.
Medical record numbers.
Actual insurance numbers.

Review cells A3:F6 for any real-world detail from the list above.
Remove any real-world detail that you find.

Your review should leave only fictional case IDs plus operational notes. No row should identify a real person.

Before you check the statuses, which two cases do you expect to show Waiting?

Read the full PT-101 row.
Read the full PT-104 row.

You should see Waiting in both rows.

PT-101 should show Contact detail missing under Check. It should show Request update under Action/Route.

PT-104 should show Member ID missing under Check. It should show Request missing ID under Action/Route.

Your shift board now separates completed appointments from cases waiting on missing information. Next, you'll route a clinical question to the appropriate team.

Route a Clinical Message and Prepare Handoff

Your Google Sheets shift board now separates finished appointments from administrative follow-up that is still waiting. That clear status trail prepares the next front-desk assistant to continue the shift.

A medication question falls outside this administrative simulation.

The safe path records the request without medical advice. It routes the question to the clinical team for the shift handoff.

In this step, get ready to:

Add a fictional medication question without providing medical advice.
Inspect unfinished work by status.
Write a concise end-of-shift handoff.

Add the simulated message

Message routing sends a request to the role qualified to handle it. Your board records the administrative path without attempting a clinical answer.

Enter 10:30 in cell A7.
Enter PT-105 in cell B7.
Enter Medication question in cell C7.
Enter Clinical question in cell D7.
Enter Route to clinical team in cell E7.
Enter Routed in cell F7.
Tap outside the final edited cell to save row 7.
Read row 7 from left to right.

You should see a complete administrative record for PT-105. The row contains a route to the clinical team without an answer to the medication question.

Why Route a Medication Question?

This simulation keeps the front-desk role administrative. Routing records where the question went while leaving the clinical response to the clinical team.

Filter the unfinished queue

A filter temporarily narrows the rows shown on your screen. This lets you focus on unfinished work without changing the saved schedule.

Before you filter the queue, which case IDs do you expect to remain visible?

Tap More in the top right of the Sheets app.
Tap Create a filter.
Tap Filter at the top of the Status column.
Keep every value selected except Done.
Read the visible case IDs from top to bottom.

You'll see PT-101, PT-104, and PT-105. Rows PT-102 and PT-103 are hidden.

That's a useful shift check: your unfinished cases are visible without changing the saved schedule.

Seeing the Wrong Rows?

Tap Filter at the top of the Status column.
Select every value except Done.

Help me fix my unfinished-work filter.

Write the handoff

A handoff gives the next assistant a concise record of unfinished work. It also confirms that the clinical message reached the correct team.

Tap More in the top right of the Sheets app.
Tap Remove filter.

You should see PT-102 and PT-103 return to the board. All five fictional cases are visible again.

Double-tap cell A8.
Enter Handoff: PT-101 and PT-104 are waiting for missing information. PT-105 was routed to the clinical team..
Tap outside cell A8 to save the handoff.

Before you check the finished handoff, which unresolved case should be the only one marked Routed?

Read row 7 from the Time column through the Status column.
Read cell A8 from start to finish.

Row 7 should show 10:30, PT-105, Medication question, Clinical question, Route to clinical team, and Routed.

Cell A8 should read Handoff: PT-101 and PT-104 are waiting for missing information. PT-105 was routed to the clinical team..

Handoff Missing?

Return to cell A8.
Check that the complete handoff note is inside the cell.
Tap outside cell A8 again to save it.

Help me fix my handoff note.

Well handled. Your board now shows the clinical question routed safely.

The saved handoff gives the next assistant a concise view of unfinished work.

Secret mission

Create a Priority Handoff

Label every fictional case with a training priority. Prove the routed clinical question is the only High item. Put that item first in the handoff.

Clean Up Your Resources

Choose whether to keep the shift board, pause by closing the app, or remove the file entirely. The project uses one file in Google Sheets with no ongoing paid resources.

Resources you used:

One Google Sheet named Fictional Clinic Shift Board in the signed-in Google Account.

Keep everything running

No action is needed. Choose this if you want to keep practising with your completed mobile shift board.

Keep Fictional Clinic Shift Board in your signed-in Google Account.
Continue using fictional case IDs if you make more practice changes.

Pause - I'll come back to this later

Close the app to pause your practice while keeping the completed sheet available for later.

Tap outside the current cell to save the final handoff.
Close Google Sheets on your phone or tablet.

Google saves online changes automatically as you type. Offline changes save to the device before syncing to Google Drive after reconnection.

Delete - I don't want to use this again

Removing the sheet takes your practice artifact out of the active file list. Your Google Account stays in place.

Return to the file list in the Google Sheets app.
Find Fictional Clinic Shift Board.
Tap More beside the file.
Tap Remove.
Complete the confirmation prompt if one appears.
Confirm that Fictional Clinic Shift Board no longer appears in the file list.

Nice Work!

Shift complete! Your fictional clinic board now demonstrates a safe front-desk workflow on mobile using Google Sheets.

You've learned how to:

Build a mobile clinic shift board in Google Sheets. Use it to expose and resolve a deliberate double-booking.
Track missing intake and insurance information with fictional case IDs. Apply minimum-necessary information habits by keeping real patient information out of the board.
Route a simulated clinical question to the clinical team. Turn a filtered queue of unfinished work into an end-of-shift handoff.
Complete the optional Secret Mission by adding a priority system to every fictional case. Put the High routed item first in the revised handoff.

Ready to quiz yourself?