Wednesday, April 28, 2010

Telehealth Success Story

In the Journals: IT Bundle Reduces Mortality; Commentary Examines Comparative Effectiveness Research abstract of an  article posted in the April 12, 2010 issue of Archive of Internal Medicine

at https://www.ecri.org/PatientSafety/HrcReports/Pages/AlertListing.aspx?alert=4587&ref=https://www.ecri.org/PatientSafety/HrcReports/Pages/HRC_Public_Alerts.aspx

The researchers found that a combination of healthcare information technology (HIT) and remote intensivists reduced mortality by 30%.  Ventilator use was reduced by 5%. The study included 1,913 patients. 
(Chapter 22 on telehealth)

Textbook Chapter Resources Update

Linda, will be updating the textbook website at http://dlthede.net/Informatics/Informatics.html
with the following:

Siegler, E. L., & Adelman, R. (2009). A Remediable Hazard of Electronic Health Records. American Journal of Medicine, 122(6), 495-496. An excellent discussion of the hazards of this practice, along with some thoughts about how to make this a safe, reliable, and contributory to patient care. (Chapter 21)

http://www.amjmed.com/article/S0002-9343%2809%2900157-0/fulltext

Reichard, L. (2010, April 10). Electronic Medical Records: A Nursing Perspective from the Front Lines. A good description of how a well designed EMR functions along with some suggestions for those contemplating an EMR. (Chapter 19)

http://www.billianshealthdata.com/Knowledge/Blog/2010/2010/April/EMRx_A_Nursing_Perspective.html

Monday, April 26, 2010

Linda has updated the textbook web site with the following:

April 24, 2010 Gugerty, Brian. He has developed surveys for Pre and Post Implementation that gauge the attitudes of staff. Would be helpful pre to gauage need for change management. (Chapter 19)


http://cisevaluation.com/CISIES_Administrations.html

Tuesday, April 20, 2010

PowerPoint Presentation Software Skills List

I invite your feedback on this listing of Presentation software skills (PowerPoint, etc.)
Basic Presentation Skills
* Design a simple presentation
* Apply a template
* Insert a new slide
* Apply the use of different slide layouts
* Use spell-check
* Save a presentation
* Add shapes to a slide
* View a slide show
* Print a presentation

Intermediate Presentation Skills
* Customize the presentation menu
* Create handouts
* Add clip art to slides
* Add SmartArt to slides
* Move and resize objects
* Incorporate multimedia (audio, graphics, animation, and video) into slide design
* Modify multimedia used for presentations
* Demonstrate competency using two presentation software applications
* Save a presentation in file formats for use with other software applications
* Share/collaborate with others on presentation design
* Apply pedagogical principles to presentation design (Purpose, visual clarity, consistency, readability)

Advanced Presentation Skills
* Design on-screen navigation
* Customize presentation toolbars
* Embed/edit a spreadsheet
* Create a macro
* Add slide transitions
* Add slide sections
* Design slide animations
* Demonstrate advance text and graphic editing techniques
* Build custom slide masters
* Build custom handout masters
* Build custom notes masters
* Create a presentation template
* Publish and distribute presentations
* Demonstrate competency using more than two presentation software applications

Gaining New Office Software Skills

I posted a couple of blogs outlining basic, intermediate, and advanced skills for Word and Excel. So perhaps you realize that you are ready to learn a few new ones.  What should you do? There are lots of FREE high-quality learning resources.

Mentioned this site in an earlier blog GCF Learn Free- http://www.gcflearnfree.org/computer/ - is free, but requires a login and password

Hewlett Packard Learning http://h30187.www3.hp.com/ is also free, but requires a login and password

Microsoft provides many free interactive tutorials at http://office.microsoft.com/en-us/training/default.aspx

Wednesday, April 14, 2010

Excel Skills

I am working on creating identifying Excel skills at the basic, intermediate, and advanced levels.  Please comment/edit the following:
Basic Spreadsheet Skills
·         Design a simple table
·         Name a worksheet tab
·         Apply a template
·         Insert a new worksheet
·         Create a simple formula (Add, subtract, multiply, divide)
·         Use basic functions (SUM, AVG, MIN, MAX, COUNT)
·         Resize columns and rows to display data
·         Sort cell data
·         Use search and replace
·         Freeze rows and columns
·         Use automatic data entry
·         Use spell-check
·         Use a chart
·         Save a workbook
·         Print a worksheet

Intermediate Spreadsheet Skills
·         Customize the spreadsheet menu
·         Design spreadsheets using data validation features
·         Customize a spreadsheet using conditional formatting features
·         Create/modify a chart
·         Import/export data in text format
·         Link spreadsheet data from other sources
·         Apply principles of effective spreadsheet design
·         Create complex formulas
·         Create/modify a pivot table
·         Create a form
·         Create a report
·         Link and embed tables into word processing documents
·         Use data protection
·         Password protect a workbook
·         Demonstrate competency using two spreadsheet applications
·         Share/collaborate with others on a spreadsheet design

Advanced Spreadsheet Skills
·         Create formulas that use logical and statistical operations
·         Use advanced data analysis tools
·         Create a dashboard
·         Create a new template
·         Create macros
·         Create new functions using Visual Basic expressions
·         Demonstrate competency using more than two spreadsheet applications

Tuesday, April 13, 2010

Institute for Safe Medicine's Guidelines for Standard Order Sets

Linda added another resource to the textbook website at http://dlthede.net/Informatics/Informatics.html

April 12, 2010 Institute for Safe Medicine's Guidelines for Standard Order Sets (Chapter 20)
http://e.ccialerts.com/a/hBLnlpxAIyhSgAa0kNPARfUnnf-/mh22

Formula Corrections for Chapter 9

I remembered Linda telling me that there were some errors in the formulas noted in Chapter 9 on spreadsheets.  I was confused because I knew that I had verified that the formulas worked and had used copy/paste to copy them into the chapter manuscript.  I obviously missed the errors when reviewing the chapter proofs (won't happen again!)  What happened is that the parentheses for creating formulas were changed to brackets in nested formulas.  That rule works for typed text, but not formulas!!

So.... if you are attempting to replicate the formulas on pages 158, be sure to use only parentheses, and not brackets.  For example for Application & Competencies #2, the spreadsheet output (after you drag the formula to rows 3 though 5, should look like this (I shortened the field names):

Prenatal DtDue DateGest Age at Visit
1/1/20099/1/095.29
9/2/20092/20/1015.57
4/1/20109/1/1018.14
1/20/20112/20/1135.57
 Be sure to change the brackets in exercise 3 to parentheses, too!

Friday, April 9, 2010

Textbook Chapter Resources Update

Linda has been busy updating the textbook web site at http://dlthede.net/Informatics/Informatics.html

The following resources were recently added:
Basic Computer Comptencies from the TIGER group. This group was charged with defining the minimum set of informatics competencies that all nurses need to succeed in practice or education in today's digital era. (Added April 8, 2010)
http://tigersummit.com/uploads/3.Tiger.Report_Competencies_final.pdf
 
The TIGER report is a "must read" for every nurse, not just the nurse educator. 

Tuesday, April 6, 2010

Jing Update

I learned some new features with Jing today.  You can use the free version of Jing to create buttons that will automatically upload Jing files to Twitter, Facebook, and Flickr.  I created the buttons (use the history menu), but have not attempted the uploads.  Not sure how it might work with Twitter. 

Friday, April 2, 2010

Word Processing Skills - Need Your Input

It appears that the blogger site had significant problems most of today.  If you had an RSS feed to this blog, you probably received an odd error.  I have been unable to post or edit all day.
Today I worked on identifying basic, intermediate, and advanced word processing skills.  Will note them below.  I am very interested in comments and suggestions to improve the list.

Basic Word Processing Skills

  • Create a new document
  • Use the menu and quick access toolbar
  • Customize the quick access toolbar
  • Use the ruler
  • Obtain the word count information for a document
  • Add basic text Format - font size, color, style
  • Alignment – center, left, right, justify
  • Format lines, words, and spaces - Spacing – choosing and Change line spacing, bullets
  • Use themes & styles
  • Move text - cut/paste, copy/paste, drag/drop
  • Create bookmarks
  • Insert hyperlinks (URL, email addresses & other places in the document)
  • Insert clip art
  • Make changes – undo/redo
  • Use search & replace
  • Use tab key to indent
  • Identify/correct spelling and grammatical errors
  • Create headers & footers
  • Insert page numbers
  • Use Help
  • Check spelling and grammar
  • Name documents
  • Save a document to Word and other file formats (.doc, .rtf, txt, PDF)
  • Print documents using print preview,
  • Change printer settings

Intermediate Word Processing Skills

  • Create an outline
  • Create new documents from a template
  • Design your own custom template
  • Modify text font style, color, size, and case
  • Modify text alignment
  • Make changes – Add, delete, & move text
  • Create and format text (styles, shadow effects, shape, and arrangement of)
  • Modify themes & styles
  • Change paragraph settings – hanging indent, first line indent
  • Create/modify the table using a table auto-header
  • Change margins & bullets
  • Use search & replace
  • Use mail merge
  • Create letters, envelopes, & labels with a wizard
  • Insert line breaks
  • Modify the menus and toolbars
  • Autocorrect & Styles
  • Check readability statistics
  • Collaborative skills
    • Use the review tool
    • Use Skydrive for file collaboration
  • Modify graphics – clip art, use drawing to modify graphics, position graphics
  • Use the bibliographic manager to create citations, insert citations into a paper, and to create an associated reference list
  • Create a paper in APA citation style, abstract, & a reference page

Advanced Word Processing Skills

  • Use desktop publishing tools to create newspapers & brochures
  • Create forms
  • Link and embed file – presentations and spreadsheets
  • Create custom themes
  • Create long documents – connect several documents into one
  • Create lists of figures, captions, table of contents, index, cross-index
  • Add a digital signature
  • Use formulas
  • Create macros
  • Add line numbers
  • Add a watermark

Thursday, April 1, 2010

Acrobat.com - Cloud computing office suite, wiki, and webinar all in one

Acrobat.com is a combination of a cloud computing office suite, a wiki, and webinar software all in one.   Acrobat.com is an Adobe shared workspace like a wiki; however, it has a few unique features.  By default, the shared workplace is free, private, and does not have advertisements. You can access the feature if you have an Adobe login and password.  Acrobat.com uses Flash, a platform for animation and interactivity.  It includes a self-contained cloud computing office suite with a word processor (Buzzword), presentation software (Presentation), and spreadsheet software (Project Mgmt).  The other unique feature is that it includes webinar software.  The free version allows up to three connections.  The webinar includes all of the standard webinar features, such as ability to invite others, video conferencing, audio, screen-sharing, remote control, and chat.  The initial file size limitation is 100 MB. According to a CNET article, the file size is expected to be increased later.

 I am pleasantly surprised to note that the file manager will accept file types other than Adobe. The resource is certainly worth exploring.