1 / 14

Lab Review

Lab Review. Material that will be on the exam. Where to find Material. Course Website Calendar Lecture Slides (PowerPoint) Assigned Reading Blackboard Cases Lab Slides (PowerPoint). Intro Lab. This lab was just a system test Not important. GIS Lab. G eographic I nformation S ystems

vince
Download Presentation

Lab Review

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Lab Review Material that will be on the exam

  2. Where to find Material • Course Website Calendar • Lecture Slides (PowerPoint) • Assigned Reading • Blackboard • Cases • Lab Slides (PowerPoint)

  3. Intro Lab • This lab was just a system test • Not important

  4. GIS Lab • Geographic Information Systems • MapInfo • World Trade Center Case • GIS would have helped responders • Now, GIS systems are used by Fire, Police, Rescue, Disaster Management Teams • GIS systems are decision support systems • Used in marketing, store placement, geographic planning

  5. GIS Lab • Attributes of Information • For WTC Case, these attributes were important: • Timely, Accessible, Relevant, Reliable, Accurate, Flexible, Simple, Complete • These were NOT important • Economical, Secure, Verifiable

  6. HIPPA / HIPAA Lab • Health Insurance Portability & Privacy Act • OR Portability and Accountability Act • GE Centricity System • MIS System used by Indiana Heart Hospital • HIPPA requires Hospitals and Insurance Providers to take care of information • GE Centricity helps and creates numerous advantages.

  7. HIPPA / HIPAA Lab • We also analyze Centricity using CMC tools. • CMC: Computer Mediated Collaboration • Attributes of Information come up again. • HIPPA demands that information be both • Secure and Accessible / Flexible • This contradiction creates challenges for hospitals and insurance providers

  8. Goals? Stakeholders? Inputs?| Outputs? Reduce Cost (paperwork), reduce errors, increase efficiency, better patient care. GE, Insurance Providers, Hospital itself, Nurses, Doctors, Patients Data provided by patients (History, allergies, etc.); Data provided by insurance carriers (Coverage, limits, co-pay, etc.); Data from equipment Information: Bill of services rendered, formatted patient chart (electronic) GE Centricity System

  9. Processing? Feedback? Type of System? Functional Area? Plotting patients vital signs on a chart; Summarizing a patients visit history; Sorting patients by priority level. Average patient wait time, recovery time, etc. Number of errors, injuries, patients seen, etc. MIS (maybe ECS) Operations (in manufacturing its called production) GE Centricity System

  10. People Data Hardware Software Communication Network Same as stakeholders Medical records, equipment data, insurance info. Medical equipment, tablet PCs, touch screens GE Centricity Wifi Network Centricity: Big Picture

  11. People Data Hardware Software Communication Network Victims, Responders Spatial Data, Arial Images, Hazardous materials data Radios, GPS devices, Portable computers MapInfo Radio, WiFi, Satellite GIS & WTC: Big Picture

  12. Excel Lab • Return on Investment from GE Centricity System • Spreadsheet makes things easier to calculate • Megan Davis Convention Center • RAW DATA: • Reservations for the entire year • INFORMATION: • Average room charge • Average length of stay • Total Revenue from each Room

  13. Excel Lab • VLOOKUPS and IF statements • Big Picture: • How to transform raw data to information • Excel allows for some serious information processing • Imagine if there were 100 rooms and 20,000 reservations.

  14. DB versus SS Lab • Spreadsheets • Data Redundancy (duplication) • Lack of Integrity • Volitale sorting • Zip Code: 01234  1234 • Databases are not good for • Calculations, Math Functions • Charts, Graphics, etc. • Databases are generally not as intuitive as spreadsheets • But, you can program an intuitive user interface

More Related