ID-251 General Sylabus for all Activities

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

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

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