Data & Such …
How to Get Your Data Rolling …
(This is a long post- click Here if you want to skip to a list of posts)
In the late 1990’s there was a data storm in the perfusion community. All of a sudden, terms like CQI, STS, QA, and CQM, were rolling off perfusion administrators tongues faster than a water park slide. This was definitely the tail wagging the salivating dog.
Number crunching was in, and on top of all the perfusion data we were already collecting, was added a nice new and shiny wrapper in what was to become the new and improved perfusion package.
If it had a number, it had better be in the database that perfusion groups were spending thousands of dollars on.
The database itself was a mythical beast. On top of countless records and checklists, the mountain that was yet to be climbed, AFTER the all night circ-arrest case, was the mentally crippling task of typing in data, to feed this monstrous pig.
And the authors of this soulless tyranny? It’s administrators? Well sad to say, but the persons that fomented this information gorge were invariably some of our own…
People climbing ladders and spending countless hours trying to figure out how to fit an abacus into an email, and teaching monkeys to count.
I was once one of them… So this is my Mea culpa …
So.. You want a Database- for Free…
Well it’s not as hard as it sounds… it’s actually pretty easy.
If you follow the steps listed below, you and your group can have a database that is:
- Can be accessed anywhere and anytime
- Automatically creates a spreadsheet with the data in it
- Has conditional navigation
- Has data entry checks to prevent missed data points
- Spits out nice bar graphs and pie charts on it’s own
- Can be downloaded and backed up at anytime
- Did I say free ?
If you don’t want to read up on the process but would like to see how it works- Launch the Form now by clicking below. Please enter data one time only- as it is a live form.
Start Your Database …
Step 1: Open a Gmail account (they provide the database engine)
Step 2: Log in to your new Gmail account.
Step 3: create a new document. There are several options- but for now, let’s just create a new form.
Step 4: Design your questionnaire/data collection tool.
Note: Pay attention to the “Type” of question you are designing. “Multiple choice” allows for one selection only, whereas “checkboxes” allow for more than one response.
Note: The 3 different “types” of question formats below
Step 5: Save your form before you close out of gmail.
Step 6: Add some fluff and a nice wrapper…
Step 7: Test your form (really test it and make sure the results graph out the way you want them to).
Step 8: Set security settings to allow access only to the people you want to have entering the data.
Step 9: Who gets to see the results?
Note: The form generates it’s own down loadable Excel sheet.
Step 10: Get instant updates on when data forms are submitted.
Step 11: Do you want the people submitting the forms to see the results?
Note: How to see the form responses…
Note: Shiny new bar graphs. Where’s that dog whistle ?
Note: A credit to instant gratification… Like going to the ice cream parlor.
OK- you’re done.
Let me know what you think and leave questions in the comments section. The form above is one that I created to use for this blog as a way to determine if a global perfusion data bank could ever be established.
So if you want to see the online database in action, try filling out the form below, and viewing the results. The form is live- so please enter only once.
Results can be seen by clicking the link at the bottom of the post.
Good Luck !
(and leave a comment if this actually helped you or your group create a database)
Frank Aprile, BBA, LP, CCP
Take the Poll …