Week 3 - Spreadsheet Essentials - Excel

So here we go. On to chapter 2 of 'Images You Can Use', based on the idea that we would all benefit from the use of an IPad or Iphone sized medical detector, a device that would scan an area of our body and show an x-ray type image, give a diagnosis and make treatment recommendations and website references for further research, and recommend specialists in the area for treatment.

The Excel spreadsheet essentials lesson during week 3 lecture 2, gave me some ideas on how medical professionals all over the world could track and document the use of the medical detector, its efficiency and effectiveness, and where changes need to be made to make it more beneficial to the general public.

Excel is a perfect program to track the use of the medical detector. The device could be programmed so every time a person uses it, they would have to input information such as their gender, age, geographical location, type of medical emergency, recommendations made by the medical device and whether or not that information was accurate, relevant and helpful. All kinds of additional information could be required each time the medical detector is used and that information would be stored in a central system available to medical professionals all over the world so they could see how the device was being used.

The simple use of formula’s and functions would show results on the accuracy of diagnosis, what sources were recommended and what actions were taken. This information could then be color coded and graphed for easy review using the charts and illustrations. Using the sort and filter function, the date could be sorted by city, county or state, or even regionally by states or countries. The filter could also show what type of emergencies were being reported, in what parts of the country or world, and which of those had a higher success rate of treatment and why.

Information gathered could be ranked according to seriousness of injury, color coded to highlight correct and incorrect predictions, number of similar conditions, number of incidents per city/state and overall outcomes as a result of having the device.

By using the ‘get external data’ function, information for other medical reporting sources could be calculated against information received from the medical detector to compare results and highlight valuable resources.

Using Excel as a data reporting resource could significantly increase the medical professions knowledge of medical history around the world if every home owner had a medical detector and used it to input information about their use of the device.