PraxIS June 2008

08-06 Contents: Dutch ban e-voting, Medical IT risk, SoftTest events, Eusprig 2008

ISSN 1649-2374 This issue online at http://www.sysmod.com/praxis/prax0806.htm   [Previous] [Index] [Next]

Systems Modelling Ltd.: Managing reality in Information Systems - strategies for success  

IN THIS ISSUE

1) Risk & Security
     E-Voting Banned by Dutch Government
     Medical IT risks
 
2) Quality
     June SoftTest Ireland events
 
3) Spreadsheets
     Eusprig 2008 programme announced
     Another Excel problem solved
     ICAI Spreadsheet Risk briefing
 
4) Off Topic
     Quotes
 
8 Web links in this newsletter
 
About this newsletter and Archives
Disclaimer
Subscribe and Unsubscribe information

_______________________________________________________

Welcome to PraxIS

This month, I'll let you into one of the more weird behaviours of Excel that frustrated one of my colleagues.

Patrick O'Beirne

_______________________________________________________ _______________________________________________________

1)  IT Risk

E-Voting Banned by Dutch Government

http://www.intergovworld.com/article/0806e0920a01040801a6601c677052a2/pg1.htm

The Netherlands has banned the use of electronic voting machines in future elections due to concerns that the technology was too vulnerable to eavesdropping. "Developing new equipment furthermore requires a large investment, both financially and in terms of organization," according to the Ministry of Internal Affairs. "The administration judges that this offers insufficient added value over voting by paper and pencil."

So, that leaves the hapless Minister for Local Government in Ireland with some 7000 evoting machines that are still mothballed. The government has spent €52 million on electronic voting machines and spends €800,000 per annum to store the machines.

http://evoting.cs.may.ie/ E-voting discussion list archives includes link to official reports.

Medical IT risks

http://www.santacruzsentinel.com/ci_9356389

Software incompatibility was part of a chain of events leading to the wrong patient getting an appendectomy. The Dominican Hospital was fined $25,000. When the first patient's information was deleted from the computer in the scan room, it was not deleted from the computer system used by the radiologist. "This was due to an incompatibility of the software between the two systems," the state report said.

____________________________________________________________
____________________________________________________________   

2) Quality

June SoftTest Ireland events

http://www.SoftTest.ie

Monday 16 June, 2-5.30pm, IBEC, Confederation House, 84/86 Lower Baggot St, Dublin
Tuesday 17 June, 9am-12.30pm, Radisson SAS Hotel, The Gasworks, Belfast
Wednesday 18 June, 9am-12.30pm, Kingsley Hotel, Cork

There is no charge to attend these events.

Testing in an Agile Environment - James Lyndsay

It is hard to find a practical approach that allows a professional tester to achieve their full potential in an agile environment. Typical agile practices have characteristic effects on the work of a tester - and the expectations of experienced testers can be at odds with those of other experienced members in an agile team. How can a tester fit into an agile team and offer the best of his or her skills and insight? How does one make - or become - an 'agile tester'?

Using real-life examples, this talk attempts to give a flavour of what it is like to bring a test perspective into an agile project - and what it is like to be on an agile project that has a sudden need for testing skills. The talk will help testers recognise where they are bringing friction to an agile environment, help agile team members recognise where they may be incurring a 'testing debt' and identifies ways that testers can facilitate learning and bring value to an agile project.

Competency Based Tester Qualifications: The Next Step for the Testing Profession? - Susan Windsor

This session suggests that there is increasing demand for training and certification schemes that are based more on competence, rather than memory. What would such schemes look like? We’ve got some ideas, but we seek your input.

We’ll provide a suggested framework that may help structure the measurement of competencies for different roles within testing and some ideas on how this measurement could take place. But wouldn’t it be great to move this forward to a scheme that really benefits individuals and our industry?

____________________________________________________________
______________________________________________________________

3) Spreadsheets

 Eusprig 2008 conference programme announced

http://www.eusprig.org/

For the first time the organisers have to introduce parallel tracks as there are so many papers!

I'm really looking forward to hearing the AIB case study - at last Eusprig audiences are hearing reports from the field on how large companies are implementing controls.

At least three talks will be on skills certification. I've been working with the Spreadsheet Safe certification test creators, and I've learned a lot about how they construct questions that discriminate well between those who know their stuff and those who don't. Good tests have strong direct language and no trick questions. Some are performance-based simulation tests, some are multiple choice with one indisputably correct answer and several incorrect options ('distractors'). It's amazing the amount of work that goes into making these questions unambiguous. Some of the difficulty is preventing the geek answer where a method that nobody would normally use could be argued as a possible implementation by an expert.

http://office.microsoft.com/en-gb/excel/CH011975851033.aspx Quizzes for Excel and other Office products

My own paper is on "Information and Data Quality in Spreadsheets". The quality of the data in spreadsheets is less discussed than the structural integrity of the formulas. Yet it is an area of great interest to the owners and users of the spreadsheet. This paper provides an overview of Information Quality (IQ) and Data Quality (DQ) with specific reference to how data is sourced, structured, and presented in spreadsheets.

Spreadsheet Safe

Just to remind you, I am now offering courses leading to a test for this certification.

http://www.sysmod.com/spreadsheetsafe

Another Excel problem solved

I recently received a call for help about a spreadsheet. It was giving  a circular reference error. The formula was: ='1592628'-'17747'. The Trace Precedents command did not work on it. On investigation I found the entries 1592628 and 17747 as text in cells but right justified to look like numbers. And the option "Accept Labels in Formulas" was enabled for the workbook. So Excel was treating those labels as headings for columns. Turning off that option changed the formula in C7 to =C$3:C$65536-C$6:C$65536, which explained the circular reference. Another reason not to like that option!

ICAI Spreadsheet Risk briefing

I shall be presenting on Spreadsheet Risk at a breakfast briefing of the Institute of Chartered Accountants in Ireland planned for June 26. For more information see http://www.icai.ie

 

Spreadsheet Check and Control: 47 best practices to detect and prevent errors

http://www.sysmod.com/az.php?a=190540400X&b=Spreadsheet+Check+Controlrol Available worldwide from Amazon.

http://sysmod.buy.ie/catalog/product_info.php?products_id=188  Our offer - free shipping to EU .

 

_______________________________________________________
_______________________________________________________

FEEDBACK

Simply send your comments to FEEDBACK (at) SYSMOD (dot) COM

Thank you! Patrick O'Beirne, Editor

_______________________________________________________ _______________________________________________________

4) Off Topic


"In theory, reality and theory are the same. In reality, they're different." - Yogi Berra

“Well, I can see that it works in practice, but does it work in theory?” - Garret Fitzgerald

_______________________________________________________
_______________________________________________________

Copyright (c) Systems Modelling Limited, http://www.sysmod.com . 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, Editortor
_______________________________________________________
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. ______________________________________________________ __
ARCHIVES
To read previous issues of this newsletter please visit our web site at http://www.sysmod.com/praxis.htm

DISCLAIMER
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.
_______________________________________________________
PRIVACY POLICY:
We guarantee not to sell, trade or give your e-mail address to anyone. 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/IS/
_______________________________________________________