What's Happened?

The general syllabus that follows covers things that were done in the class and lab during the combined years, 1998, 1999, 2000, 2001, 2002, and 2003. The course ended at the time of my retirement at the end of January 2003. If you would like to see just a bit of what happened before then, look at the way in which our wireless network and 16 Mac G3 Airport based portables worked out.


The course structure is based on a "point/counter-point" style of teaching. The diagram below illustrates this. One resource for the course is shown at each corner of the pyramid. Alone, they are conventional. But, here, they are selected so that, while they relate to the subject material, they do so in a contrasting manner. For example, the classes are designed to stimulate and provoke by lecture and demonstration. The labs are designed to gently and helpfully instruct on using the computers to do the projects that the classes develop. The books are selected to tell exciting stories about pivotal people and developments in the field. The films are designed to be dramatic wake-up calls about what can happen when humans manage machines that in turn manage other humans.

In the midst of all this are the talk shows, which are our reality checks where real professional people talk about what it really takes to make it through the day, and whether computers make it better or worse. These resources are not "a lot of work" on your part (although they are for me!). They instead allow a fuller understanding of the intricate balances in the health professions when computers are actively used to influence the relationship between a professional person and his or her clients. In the syllabus below, all of these resources are developed more fully by example and comment as hyperlinks.


Click on a box or title in the diagram below to open an expanded discussion of that item.

course structure

The ID-251 Books Talk-Show Guests The syllabus The Films The Labs

Here is our syllabus for 1999. The dates changed with repeated offerings, but the content was largely stable, influenced mainly by changes in the software and the computer technology. Scanning improved, programs like Photoshop evolved into Photoshop Elements, and Microsoft Office underwent its usual biannual facelifts.

Time

Monday
1/4/99

Tuesday
1/5/99

Wednesday
1/6/99

Thursday
1/7/99

Friday
1/8/99

8:00

Daily Readings
Cybermedicine -Chaps 1-2
The Cuckoo’s Egg
Accidental Empires
Excel p 1-26

Daily Readings
Cry /Cov p 7-56
The Hot Zone
Excel p 27-42
Speeding the Net - Part One

Daily Readings
Cybermedicine -Chaps 3-4
The Cuckoo’s Egg
Accidental Empires
Excel p 43-57

Daily Readings
Cry /Cov p 57-100
The Hot Zone
Excel p 58-73
Speeding the Net - Part Two

Daily Readings
Cybermedicine -Chap 5
The Cuckoo’s Egg
Accidental Empires
Excel p 77-109

9:00

RML 250 open for e-mail & web work.

RML 250 open for e-mail & web work.

RML 250 open for e-mail & web work.

RML 250 open for e-mail & web work.

RML 250 open for e-mail & web work.

10:10
10:30

Chapel

Chapel

Chapel

Chapel

Chapel

10:40










11:30
11:40
12:40

Lecture #1
Organizational meeting in RML 250
to present the course structure and objectives, assign roles, announce films and talk shows, and start the class and labs. How to make a calendar is explained.
---------------------------
Formal lecture to explain file sharing, servers, Pine, WWW, drop boxes, and other ways of electronically sharing text and pictorial data.

Film Lab #1
Brazil
Being a comi-graphic account of how seemingly insignificant blunders in computer based information management leads to human devasta-tion when the data are in the hands of dull-witted yet overly-powerful bureaucrats. Applies to the abuse of electronic records.

Lecture #2
Professional Information Management I:
The uses of word processors for boilerplating, record building, and mail merging material with pictures to biopsy clients.
---------------------------
Formal lecture on using "autotext" to enter boilerplating into a letter to do a mass mailing based on sensitive context lab results.

Film Lab#2
1984
Being a harshly surrealistic portrayal of intellectual domination and control of thought through computer controlled history in the hands of a centralized authority
by negation of the individual’s value as a child of God. The novel and film were responsible for popularization of the phrase "orwellian".

Lecture #3
Professional Information Management II
: The uses of word processors for entry of data into forms, and tables. How spreadsheets and charts can be added to letters.
---------------------------
Formal lecture on using a spreadsheet to make a table to import into Microsoft Word for doing a mass mailing based on past due billings.

12:40
1:30

Lunch
Daily Readings

Lunch
Daily Readings

Lunch
Daily Readings

Lunch
Daily Readings

Lunch
Daily Readings

1:30






3:00

Tutorial Lab 1
How to make a letterhead. Learning about inserting pictures in Word. How to use form fields to make an appt. calendar

Project Lab 1
Design of your personalized letterhead
Prepare boilerplate letter to cover different biopsy results. Prepare a calendar.

Tutorial Lab 2
Learning about autotext in Word. Learning how to use mail merge fields in a Word document to prepare a dunning letter.

Project Lab 2
Prepare a set of dunning letters to report overdue billings using mail merge. Finish projects from Tuesday’s boilerplate lab>

Talk Show
On the front lines with people making appointments.
Dr, Kay Schwebke, Mrs. Bev. Lubbers, and Mrs. Cheryl Gjerdingen, all from Allina Clinic

3:30





5:00

Open
Workshop (RML250)
Learn A.D.A.M
Learn Desk Paint
Design Posters
Learn Excel
Final Exam Work

Open
Workshop (RML250)
Learn A.D.A.M
Learn Desk Paint
Design Posters
Learn Excel
Final Exam Work

Open
Workshop (RML250)
Learn A.D.A.M
Learn Desk Paint
Design Posters
Learn Excel
Final Exam Work

Open
Workshop (RML250)
Learn A.D.A.M
Learn Desk Paint
Design Posters
Learn Excel
Final Exam Work

Informal Discussion with Talk Show Guests

Time

Monday
1/11/99

Tuesday
1/12/99

Wednesday
1/13/99

Thursday
1/14/99

Friday
1/15/99

8:30

Daily Readings
Med Inf p 181-217
The Cuckoo’s Egg
The Road Ahead Excel p 109-120

Daily Readings
Cry /Cov p101-140
The Hot Zone
Excel p 121-138
Networking

Daily Readings
Med Inf p 219-272
The Cuckoo’s Egg
The Road Ahead Excel p 138-145

Daily Readings
Cry /Cov p 141-206
The Hot Zone
Excel p 145-164
Networking

Daily Readings
Med Inf p 273-322
The Cuckoo’s Egg
The Road Ahead Excel p 167-174

9:00

RML 250 open for e-mail & web work.

RML 250 open for e-mail & web work.

RML 250 open for e-mail & web work.

RML 250 open for e-mail & web work.

RML 250 open for e-mail & web work.

10:10
10:30

Chapel

Chapel

Chapel

Chapel

Chapel

10:40











11:30

Lecture #4
Introduction to using a spreadsheet to keep lab and clinical records.
Preparing and interpreting linear regressions and bar graphs for result interpretations. Graphing autoanalyzer results to show clients.
---------------------------
A formal lecture to explore the best ways to present the results of a blood test to a client, looking for clarity, not information overload.

Film Lab #3
2001
Being a gently surrealistic portrayal of the use of artificial intelligence for decision making in paradoxical situations - with an illustration of how God uses a divine computer to
prepare the second coming through a "star child" to provide humanity’s salvation. Relates to medical diagnosis by computer program.

Lecture #5
How to prepare and present data in a spreadsheet, formatted to be inserted into a Word document so that a tidy letter that can be automatically updated with current lab data results. How to calculate a penalty in Excel.
---------------------------
A formal lecture to explore the ways in which automata and laboratory robots can be used to gather clinical results for telemetry to patients.

Film Lab #4
2010
Being a portrayal recapturing human control of decision making from an artificially intelligent computer and the compromises that result from personal ambition for its use.
The film serves as a way of "interpreting" 2001 for the public, while also cautioning against computer based uses of power.

Lecture #6
How to use a spreadsheet as a front end to a database. Excel can serve as a way of entering data into a database by the use of forms. This is a little known feature that can be of great help in making small data bases.
---------------------------
A formal lecture to explore the desirability of using Microsoft Word with Excel for office automation to do a mass mailing

11:40
12:40

12:40
1:30

Lunch
Daily Readings

Lunch
Daily Readings

Lunch
Daily Readings

Lunch
Daily Readings

Lunch
Daily Readings

1:30







3:00

Tutorial Lab 3
Spreadsheets for clinical data illustrations.
Preparing and interpreting blood pressure data. Doing a t-test to determine if blood pressure meds are having the desired effect. How to make a quality professional graph.

Project Lab 3
Spreadsheets for dataprocessing in clinical chemistry..
Robot Day! We learn by observation how a lab robot can be used to do clinical analysis. The data are automatically collected and sent to RML250 for spreadsheet processing.

Tutorial Lab 4
How to use Excel for making a variety of charts and graphs. Focus will be on pie charts, bar graphs, and custom charts. How to make a pivot table. How to use a pivot table. How to use digital photography for electronic patient records.

Project Lab 4
Using the data from the lab robot, a linear regression is made using Excel for a graphical display of results. Also graphical decision making in a dental clinic is mimicked. Bar and exploded pie graphs are used for decision making.

Talk Show
Dentists and computers - Drs. Mike Remes, Dr. David Brust, and John Ehresmann discuss how they manage their practice with UNIX based computers.

3:30





5:0

Open
Workshop (RML250)
Learn A.D.A.M
Learn Desk Paint
Design Posters
Learn Excel
Final Exam Work

Open
Workshop (RML250)
Learn A.D.A.M
Learn Desk Paint
Design Posters
Learn Excel
Final Exam Work

Open
Workshop (RML250)
Learn A.D.A.M
Learn Desk Paint
Design Posters
Learn Excel
Final Exam Work

Open
Workshop (RML250)
Learn A.D.A.M
Learn Desk Paint
Design Posters
Learn Excel
Final Exam Work

Informal Discussion with Talk Show Guests

Time

Monday
1/18/99

Tuesday
1/19/99

Wednesday
1/20/99

Thursday
1/21/99

Friday
1/22/99

8:00

Daily Readings
Med Inf p 324-364
The Cuckoo’s Egg
The Road Ahead
Excel p 175-192

Daily Readings
Cry /Cov p 207-242
The Hot Zone
Excel p 195-216
Networking

Daily Readings
Med Inf p 364-433
The Cuckoo’s Egg
The Road Ahead
Excel p 217-231

Daily Readings
Cry /Cov p 243-312
The Hot Zone
Excel p 231-236
Networking

Daily Readings
Med Inf p 535-581
The Cuckoo’s Egg
The Road Ahead
Excel p 259-269

9:00

RML 250 open for e-mail & web work.

RML 250 open for e-mail & web work.

RML 250 open for e-mail & web work.

RML 250 open for e-mail & web work.

RML 250 open for e-mail & web work.

10:10
10:30

Chapel

Chapel

Chapel

Chapel

Chapel

10:40









11:30

Lecture #7
The Electronic Patient Record; Digitizing, processing, storing, and sending diagnostic digital images. What "bit count" and digital color scales mean in terms of quality.
---------------------------
A lecture on how to capture information from a photograph and put it into an office presentation "slide show" to offset client anxiety

Film Lab #5
COMA
Being a vintage effort at blending digital illustrations with real time video to portray by animation the human-computer
(unavoidable) clash between good and evil. It relates more today to biology and the implanted computer chip than it did when it was first made.

Lecture #8
How to build a digital network. Using the network to transfer images between rooms in a mock hospital setting. How the size of an image and the speed of a network matters
---------------------------
A lecture on incorporating digital images into office documents, and the desirability of storing and transferring this much information about a person.

Film Lab #6
West World
Being a classic portrayal of cyborgs for personal gratification, run amuck due to "technical difficulties", leading to personal death..
Yul Brenner offers an astonishingly convincing performance of why technology must never be allowed to advance to the degree of total automation.

Lecture #9
How to incorporate digital imagery into documents could become part of a larger electronic patient record. How to build a database with images using Filemaker Pro.
---------------------------
A lecture on what the "electronic patient record" could mean, and how to make use of the WWW to exchange medical information. Security and risk.

11:40
12:40

12:40
1:30

Lunch
Daily Readings

Lunch
Daily Readings

Lunch
Daily Readings

Lunch
Daily Readings

Lunch
Daily Readings

1:30






3:00

Tutorial Lab 5
How to use Pagespinner to make a web page using pictures and forms as a way of lessening administrative detail and also informing a patient of possible surgical procedures.

Project Lab 5
We make a web page using forms to mimic a hospital intranet and inform patients of surgical procedures. Ilustrations from A.D.A.M. will be used for the page

Tutorial Lab 6
How to use Pagespinner to make a web page using forms as a way of informing a physician of patient responses to surgical procedures. Are web-based forms a secure example of the electronic patient record?

Project Lab 6
We make a web page using forms to mimic a hospital pharmacy for ordering prescriptions to have patients decide how they feel about internet ordering.

Talk Show
Dr. Greg Beilman, Dr. Gretchen Ehresmann, Dr. Donald Asmussen, and Dr. Ken Sansome talk about electronic patient records and the web.

3:30





5:00

Open
Workshop (RML250)
Learn A.D.A.M
Learn Desk Paint
Design Posters
Learn Excel
Final Exam Work

Open
Workshop (RML250)
Learn A.D.A.M
Learn Desk Paint
Design Posters
Learn Excel
Final Exam Work

Open
Workshop (RML250)
Learn A.D.A.M
Learn Desk Paint
Design Posters
Learn Excel
Final Exam Work

Open
Workshop (RML250)
Learn A.D.A.M
Learn Desk Paint
Design Posters
Learn Excel
Final Exam Work

Informal Discussion with Talk Show Guests

Time

Monday
1/25/99

Tuesday
1/26/99

Wednesday
1/27/99

Thursday
1/28/99

Friday
1/29/99
=

8:00=

Daily Readings
Med Inf p 585-644
The Cuckoo’s Egg
The Road Ahead
Excel p 269-279=

Daily Readings
Cry /Cov p 312-360
The Hot Zone
Excel p 279-292
Networking=

Daily Readings
The Cuckoo’s Egg
The Road Ahead finish
Excel p 295-302=

Daily Readings
Cry /Cov finish
The Hot Zone finish
Excel p 319-334
Networking finish=

Daily Readings
Excel Appendices=

9:00=

RML 250 open for e-mail & web work.

RML 250 open for e-mail & web work.

RML 250 open for e-mail & web work.

RML 250 open for e-mail & web work.

RML 250 open for e-mail & web work.

10:10
10:30

Chapel

Chapel

Chapel

Chapel

Chapel

10:40







11:30

Lecture #10
How to use Filemaker Pro as a flat file data base for holding data that could make up a pictorial and graphical electronic patient record.
---------------------------
A lecture on e How to use Filemaker Pro as a data base holding the kinds of data that could make up an electronic patient record

Film Lab#7
Brainstorm
Being a visually stunning and imaginative portrayal of the ultimate use of virtual reality to record a near death
experience, with side excursions into militaristic abuse of VR combined with lots of artificial intelligence and robotics. Natalie Wood’s last film.

Lecture #11
How to exchange data between a spreadsheet and a data base. What happens to pictures? How to use the data base for patient recall.
---------------------------
A lecture on what can and cannot be easily done with data bases that makes the electronic patient record less a threat than a nuisance.

Film Lab #8
Time Bandits
Being a delightfully surrealistic presentation of how technology in the clever hands of mischievous or naive people
leads to the fall from Grace, capture by Satan, and final rescue from eternal damnation by God in person. This film ties together all the ID251 films.

Lecture #12
How to use Excel as a data base with conditional recall, pictorial inserts, linked sheets, macros, and other advanced inf. mgt. features.
---------------------------
A lecture assessing the possibility that the spreadsheet will survive and evolve as the ultimate medical and dental information management tool.

11:40
12:40

12:40
1:30

Lunch
Daily Readings

Lunch
Daily Readings

Lunch
Daily Readings

Lunch
Daily Readings

Lunch
Daily Readings

1:30





3:00

Tutorial Lab 7
Digitizing, in black and white, text and figures, painting, tinting, and taking digital pictures to form telemedicine information. How to make patient education a web reality.

Project Lab 7
We try to make a larger data base from individual records to mimic putting an electronic patient record on the WWW.

Tutorial Lab 8
Doing the "rolling ambulance" remote trauma role-play, with the trauma in SC321 and the ER in RML250, or a demonstration of commercial telemedicine apparatus.

Project Lab 8, Before and After
Using Photoshop, digital image scanning, and PageSpinner, a final set of images (like this) are prepared for the StoryBoards.

Hand in Final Examination
Poster presentation of blood pressure study outside my office (SC328) is encouraged! Turn in final exam.

3:30





5:00

A.D.A.M.
Workshop
Design A.D.A.M
Color Poster.

Poster Show
Print A.D.A.M
Color Posters.
Prepare layout of personal pathologies for display outside RML 250!!

A.D.A.M.
Workshop
Design A.D.A.M
Color Poster.

Poster Show
Print A.D.A.M
Color Posters.
Prepare layout of personal pathologies for display outside RML 250!!

THE END

 

Disclaimer