GCN Home > 09/09/02 issue
GAO analysts ditch those sticky notes
By Dipka Bhambhani, GCN Staff
Information management app puts data at hand

Ever wonder how the General Accounting Office compiles a report full of seemingly endless details about projects at multiple agencies in quick fashion?

For years, GAO analysts mostly did this work by hand, shuffling and reshuffling paper and electronic files gathered by auditors. One senior analyst, Kevin Dooley, figured there had to be a better way than
Image:
You could run queries that search for documents, sort the documents according to your criteria, and output all or just pieces of the documents.
GAOs Kevin Dooley
paging through documents replete with hundreds of sticky notes.

In his search for applications to automate the process, Dooley discovered a few years back that the GAO library used an information management app that could import free-floating and database files, then organize them.

He decided to try the tool, askSam from askSam Systems Inc. of Perry, Fla. Dooley started out 16 years ago using the MS-DOS version and now uses Version 5, which runs under all versions of Microsoft Windows on a PC with at least 30M of storage. The original version let him chain queries, searching for something in one database and using that to search another database.

You could run queries that search for documents, sort the documents according to your criteria, and output all or just pieces of the documents, he said.

The askSam report window now does that automatically via dialog boxes.

Dooley said populating the search boxes with key words was much easier than remembering arcane syntax. But, he said, You set one query, one sort and get one report. You cant run a bunch of reports at the same time.

Survey toolsbang

Dooley discovered he could query the number of times a certain phrase appeared in any text file. For example, he uses askSam to generate GAO reports from Web surveys that pose, say, a dozen questions to virtual panels of 30 or 40 subject-matter experts at various agencies. He processes their essays into reports.

If you have survey tools like this, the statistics are a lot more convincing than doing a couple of case studies, Dooley said. Thats where the big bang is.

AskSam can organize the replies in Microsoft Outlook or Eudora e-mail and can import Rich Text Format, HTML, Microsoft Word and Excel, and Corel WordPerfect files.

More news on related topics: Knowledge Management, IT in Action