10-04 Contents: Data Protection, Medical software errors, Eusprig 2010, Excel compatibility
ISSN 1649-2374 This issue online at http://www.sysmod.com/praxis/prax1004.htm [Previous] [Index] [Next]
|Systems Modelling Ltd.: Managing reality in Information Systems - strategies for success|
IN THIS ISSUE
Data Protection Commissioner 2009 report
and further resources on the topic
New book: A pocket guide to risk mathematics
Medical errors and their prevention
How to write a successful EuSpRIG paper
Resources for the change from Excel 2003 to 2007
|About this newsletter and Archives
Subscribe and Unsubscribe information
Spring has arrived in Ireland! A month late. The magnolia is in flower, the roadside primroses are coming out and the sun is beginning to shine. That *was* a long winter.
The Twenty-First Annual Report of the Data Protection Commissioner 2009 is available at
http://www.dataprotection.ie/documents/annualreports/AR2010.pdfBilly Hawkes, the Data Protection Commissioner for Ireland, writes "2009 was a year of change - both actual and promised - in the legal framework governing data protection. The Lisbon Treaty embedded data protection as a fundamental right of European Union citizens. It provided the basis for an extension of data protection rights into all areas of EU activity. It gave new authority to the European Parliament as co-legislator in this area. "
In 2009 a total of 914 complaints were formally opened for investigation. In the last two years, unsolicited direct marketing complaints have halved. 29% of complaints concerned rights of access to personal data. During 2009, 119 data security breach notifications were received compared to 81 in the preceding 12 months. This is attributed to more organisations contacting the Office for advice when faced with a data security breach.
Reports on significant investigations are given, for example the Health Service Executive. The report ends with 16 case studies.
Guidance on audits aimed at assisting organisations selected for audit by the Office of the Data Protection Commissioner - http://www.dataprotection.ie/documents/enforcement/AuditResource.pdf
The following training
aids and guidance material are
available free of charge to assist organisations in raising staff
awareness of their responsibilities when processing personal
Breach Notification Guidance:
Direct Marketing - A General Guide for Data Controllers:
Documents adopted by the Data Protection Working Party 2009
The Case for Mandatory Data Breach Disclosure Laws, slideshow by Brian Honan.
Matthew Leitch's new book is “A pocket guide to risk
mathematics: key concepts every auditor should know”
"The idea is to change things radically by offering a relatively quick and easy way to learn enough about risk mathematics to include it in audits. It covers the subject conceptually, so that readers can absorb the ideas without having to do the algebra and calculus. This way it covers a lot of territory, with some deep insights, and has space to explain common problems auditors can look for, with suggestions on how to find them and what to suggest. Auditors do not have the main responsibility for avoiding future economic meltdowns, but it would be great if they had the knowledge to do more."
Here are some items I recently posted to the Eusprig yahoogroup and the Excel-L lists, copied here for a wider audience :
Journal of Oncology Pharmacy Practice DOI: 10.1177/1078155208094453 Aug 27, 2008;
Matthew DC Small, B. Pharm, Ann Barrett and Gill M Price
The impact of computerized prescribing on error rate in a department of Oncology/Hematology
A prospective audit of 1941 prescriptions for chemotherapy was made from January to September 2005.
Results. An application specifically designed for prescribing reduced errors by 42% (RR 0.58; 95% CI 0.47–0.72). Errors occurred in 20% of spreadsheet prescriptions compared with 12% of the computerized prescriptions.
Overdoses on spreadsheet prescriptions ranged from double doses of cisplatin to tenfold doses of mitoxantrone and hundred fold doses of vincristine. These carry the risk of a fatal outcome, although it is unlikely that they would not have been corrected during pharmacy preparation.
Reducing number entry errors: solving a widespread, serious problem
"The erroneous sum in the right-hand column is caused by 3.1. having a final decimal point/full stop, and hence being treated as text, and thus processed as zero by SUM." That article makes me realise that only now are some people realising that input validation in life-critical applications is a Good Thing. Read the description of the operation of the Alaris Infusion Pump and the Grasbey drug delivery system and shiver.
I uploaded a collection of tips for prospective authors new to
writing conference papers: "How to write a successful EuSpRIG paper"
Object Model Changes Since Microsoft Office 2003 Excel Developer Reference
A summary of the changes in the Microsoft Office Excel 2007 object model as compared to Microsoft Office 2003.
Changes in ChartingUpdated: 2009-01-15
This article lists the changes (and reasons for the change) in Charting from Microsoft Office 2003 to 2007 Microsoft Office system and suggests migration paths
This topic is included in the following downloadable book for easier reading and printing:
Technical reference for the 2007 Office release
See the full list of available books at Downloadable content for the 2007 Office Resource Kit .
XLTest helps you to check the integrity of your spreadsheets far more quickly than with tedious cell-by-cell inspection.
XLTest for Excel 2003 also works in the Add-In tab of Excel 2007
If you own the book "Spreadsheet Check and Control" you save the cost of the book - 30 euro! Simply enter into the discount code box the first word on the top left of page 131.
If you buy the spreadsheet inventory/assessment workbook ScanXLS you can get it free! Simply say you want XLTest free when placing your ScanXLS order.
To learn more, download the 19-page set of screenshots (1MB PDF) showing you what it does.
Simply send your comments to FEEDBACK (at) SYSMOD (dot) COM
Thank you! Patrick O'Beirne, Editor
Looking back to the beginning of this month, there are some April Fool stories in the Risks Digest. I smiled at the one about Silver Iodide being used to seed cloud computing.
Copyright (c) Systems Modelling Limited,
. Reproduction allowed provided this copyright notice is included.
We appreciate any feedback or suggestions for improvement. If you have received this newsletter from anybody else, we urge you to sign up for your personal copy by sending a blank email to EuroIS-subscribe (at) yahoogroups (dot) com
For those who would like to do more than receive the monthly newsletter, the EuroIS list makes it easy for you to discuss issues raised, to share experiences with the rest of the group, and to contribute files to a common user community pool independent of the sysmod.com web site. I moderate posts to the EuroIS list, to screen out inappropriate material.
Patrick O'Beirne, Editor
ABOUT THIS NEWSLETTER
"Praxis" means model or example, from the Greek verb "to do". The name is chosen to reflect our focus on practical solutions to IS problems, avoiding hype. If you like acronyms, think of it as "Patrick's reports and analysis across Information Systems".
Please tell a friend about this newsletter.
We especially appreciate a link to www.sysmod.com from your web site!
To read previous issues of this newsletter please visit our web site at http://www.sysmod.com/praxis.htm
This newsletter is prepared in good faith and the information has been taken from observation and other sources believed to be reliable. Systems Modelling Ltd. (SML) does not represent expressly or by implication the accuracy, truthfulness or reliability of any information provided. It is a condition of use that users accept that SML has no liability for any errors, inaccuracies or omissions. The information is not intended to constitute legal or professional advice. You should consult a professional at Systems Modelling Ltd. directly for advice that is specifically tailored to your particular circumstances.
We guarantee not to sell, trade or give your e-mail address to anyone.
To subscribe to this Newsletter send an email to
EuroIS-subscribe (at) yahoogroups (dot) com
To unsubscribe from this Newsletter send an email to
EuroIS-unsubscribe (at) yahoogroups (dot) com
EuroIS is the distribution list server of the PraxIS newsletter. It also offers a moderated discussion list for readers and a free shared storage area for user-contributed files. The archives of this group are on YahooGroups website http://finance.groups.yahoo.com/group/EuroIS/