Free Online Storage

  • Subscribe to our RSS feed.
  • Twitter
  • StumbleUpon
  • Reddit
  • Facebook
  • Digg

Monday, 11 January 2010

Using Google Docs to facilitate patient flow in a community health center

Posted on 09:00 by Unknown
Guest post: David Margolius is a medical student at Brown University. He is spending the year in San Francisco as a research fellow and recently began working with Southeast Health Center to improve access, patient care, and clinic flow. He changed patient management at the clinic by using a shared Google Doc to make it easy for staff and providers to communicate in real time, without walkie-talkies, pagers, and interruptions.

Southeast Health Center is a community-oriented primary care clinic in San Francisco. Through Healthy San Francisco, a program created by the City of San Francisco, Southeast and other clinics make health care services accessible and affordable for uninsured residents. The program offers a new way for San Francisco residents who do not have health insurance, to have basic and ongoing medical care.

At Southeast, all of this work can make it difficult to keep track of which patients are in which rooms, how many patients are in the waiting room, and how far the doctors are falling behind with their patients for the day. Up until about a month ago, when patients checked in, the front desk would page the medical assistant who would then escort the patient to a room when one was free. The assistant would then let the doctor know that the patient was available. If patients were late, canceled their appointments, or the waiting room was overflowing, the doctor would be the last to know. All in all, communication was linear, uncoordinated, and difficult.

The medical director asked me try to figure out something better…anything better. After observing clinic flow for a few days, my first thought was to build some sort of intra-office communication device with switches and LED lights. I found an intra-office light communication system online and with the director's permission was ready to spend some big time money on it, but a friend of mine ruined all of my crazy ideas by saying: “Why can’t you just do that in Google Docs?”

A few days later, Southeast Health Center fully incorporated the “Check-in Tracker”, a shared spreadsheet on Google Docs, into their clinic flow which you can see a sample of below:



When a patient checks in at the front desk, the clerk types “a” into the slot where that patient was scheduled. Using the “change color with rules” function, that slot turns orange to let everybody in the clinic know that Dr. Mark’s 8:15 AM patient has arrived. If the 8:55 AM patient arrives at 9:15 AM, the front desk types in “L 9:15” into that slot and the slot turns pink. Dr. Mark can look at the Google spreadsheet and type an “x” if he is unable to see the late patient or “ok” if he has time to see the patient. Patients in rooms turn green and indicate which room number. Discharged patients turn blue.

Everybody communicates in real time, because we are all using the same shared spreadsheet. Medical assistants, doctors, providers, clerks, and nurses are communicating with each other more efficiently. It is pretty incredible to see.

Google Docs has made this all possible, no mechanical engineers or big time money required. Check out this template in the Google Docs template gallery to try it out yourself.

Posted by: David Margolius, Clinic Coach, Southeast Health Center, Margolius@gmail.com
Email ThisBlogThis!Share to XShare to Facebook
Posted in Google Apps Blog | No comments
Newer Post Older Post Home

0 comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Popular Posts

  • More Google Experiments That Hide Results URLs
    There are at least two other versions of the Google experiment that removes search results URLs . The first alternate version places site na...
  • Merge cells vertically in Google spreadsheets
    There are many times when you want to format your spreadsheets in a certain way to make your data easier to read and understand. Starting to...
  • Add a Keyboard Shortcut for Chrome's App Launcher
    I'm not sure why Chrome's app launcher doesn't have a keyboard shortcut, but it's pretty easy to add one. For Windows XP, r...
  • What's The Right Answer?
    Sometimes the same question can have multiple answers, even when you're looking for a simple fact. I've searched for [ny population]...
  • Google Quick View
    Google Search for mobile has a new feature called " Quick View ". Right now, it only shows up for Wikipedia results and it allows ...
  • A completely new look for Drive on iOS
    One of the features you’ve told us you want on Drive for iOS is the ability to effortlessly browse and preview files, just like you can on A...
  • Give us your feedback with Product Ideas for Google Docs
    With Google Docs, we've learned that some of our most valuable insights come from our users, and we are always excited by what you have ...
  • Google Tests New Desktop Sign-in Page
    Back in August, Google changed the sign-in page for mobile devices. A few readers report that they see the updated sign-in page in the desk...
  • Featured video: Setting up spreadsheets notifications
    Posted by: Meredith Whittaker, Program Manager Recently , we added a notifications feature for spreadsheets, which gives you the the ability...
  • Add, edit, sort, and filter: Improved mobile access to spreadsheets
    Over a year ago, we enabled  view-only access to docs from mobile devices. This has come in handy for me because I use Google Docs spreadshe...

Categories

  • Acquisitions
  • Ads
  • Android
  • Annoyances
  • April Fools Day
  • attachments
  • back to school
  • Blogger
  • charts
  • chat
  • Chrome
  • Chrome extensions
  • chrome web apps
  • Cloud Connect
  • collaboration
  • comments
  • community
  • discussions
  • DMCA
  • docs
  • document list
  • documents
  • documents list
  • drawings
  • drivebacktoschool
  • Easter Egg
  • education
  • Faces of Docs
  • forms
  • gmail
  • gone google
  • Google Alerts
  • Google Analytics
  • Google Apps Blog
  • Google Apps Script
  • Google Calendar
  • Google Cast
  • Google Checkout
  • Google Chrome
  • Google Chrome OS
  • Google Cloud Connect
  • Google Contacts
  • Google Dictionary
  • Google Docs
  • Google Docs Viewer
  • google documents
  • google drive
  • Google Earth
  • Google Goggles
  • Google Hangouts
  • Google Instant
  • Google Keep
  • Google Latitude
  • Google Local
  • Google Maps
  • Google Music
  • Google News
  • Google Notebook
  • Google Now
  • Google Pack
  • Google Photos
  • Google Play
  • Google Plus
  • Google Reader
  • Google Sites
  • Google Suggest
  • Google Takeout
  • Google Talk
  • Google Toolbar
  • Google Translate
  • Google Trends
  • Google Voice
  • Google Wallet
  • Google+
  • googlenew
  • Greasemonkey
  • Guest Post
  • holiday
  • iGoogle
  • Image Search
  • images
  • InOut
  • iOS
  • Keep
  • Knowledge
  • mobile
  • OCR
  • offline
  • OneBox
  • paperless
  • pdfs
  • photo
  • photos
  • Picasa Web Albums
  • presentations
  • product ideas
  • profiles
  • quickoffice
  • Reddit
  • research
  • save to drive
  • scripts
  • Security
  • sharing
  • sheets
  • shortcut
  • slides
  • spell check
  • spreadsheets
  • stock photos
  • storage
  • students
  • tables
  • teachers
  • templates
  • Tips
  • User interface
  • videos
  • Viewer
  • Visualization
  • Voice Search
  • Web Search
  • Yahoo
  • YouTube

Blog Archive

  • ►  2013 (519)
    • ►  December (33)
    • ►  November (44)
    • ►  October (64)
    • ►  September (50)
    • ►  August (63)
    • ►  July (60)
    • ►  June (57)
    • ►  May (62)
    • ►  April (49)
    • ►  March (33)
    • ►  February (1)
    • ►  January (3)
  • ►  2012 (34)
    • ►  December (4)
    • ►  November (4)
    • ►  October (5)
    • ►  September (4)
    • ►  August (2)
    • ►  July (1)
    • ►  June (3)
    • ►  May (2)
    • ►  April (2)
    • ►  March (2)
    • ►  February (5)
  • ►  2011 (80)
    • ►  December (4)
    • ►  November (1)
    • ►  October (7)
    • ►  September (10)
    • ►  August (11)
    • ►  July (8)
    • ►  June (9)
    • ►  May (1)
    • ►  April (8)
    • ►  March (8)
    • ►  February (8)
    • ►  January (5)
  • ▼  2010 (118)
    • ►  December (11)
    • ►  November (16)
    • ►  October (6)
    • ►  September (13)
    • ►  August (13)
    • ►  July (7)
    • ►  June (15)
    • ►  May (11)
    • ►  April (7)
    • ►  March (7)
    • ►  February (6)
    • ▼  January (6)
      • Web browser support for Docs and Sites
      • A thumbnail is worth about one hundred words
      • The Google Docs for students page
      • Upload and store your files in the cloud with Goog...
      • Using Google Docs to facilitate patient flow in a ...
      • Google Docs and Sites: 2009 in Review
  • ►  2009 (82)
    • ►  December (14)
    • ►  November (4)
    • ►  October (10)
    • ►  September (10)
    • ►  August (4)
    • ►  July (6)
    • ►  June (6)
    • ►  May (5)
    • ►  April (4)
    • ►  March (8)
    • ►  February (7)
    • ►  January (4)
  • ►  2008 (97)
    • ►  December (6)
    • ►  November (4)
    • ►  October (6)
    • ►  September (8)
    • ►  August (5)
    • ►  July (7)
    • ►  June (11)
    • ►  May (20)
    • ►  April (13)
    • ►  March (6)
    • ►  February (6)
    • ►  January (5)
  • ►  2007 (25)
    • ►  December (1)
    • ►  November (1)
    • ►  October (2)
    • ►  September (3)
    • ►  August (3)
    • ►  July (4)
    • ►  June (3)
    • ►  May (2)
    • ►  April (2)
    • ►  March (1)
    • ►  February (2)
    • ►  January (1)
  • ►  2006 (10)
    • ►  December (2)
    • ►  November (4)
    • ►  October (4)
Powered by Blogger.

About Me

Unknown
View my complete profile