Transcript PowerPoint Presentation - KPMD (IT Solutions) Ltd

KPMD (IT Solutions) Ltd
Blades Enterprise Centre, Bramall Lane, Sheffield S2 4SU, United Kingdom
telephone: +44 (0)114 292 2292 fax: +44 (0)870 705 2655
email: [email protected]
www.kpmd.co.uk
Software for external quality assessment and proficiency testing
organisers.
Title Page
programmemanagementsystem
System Overview
Office system: multi-user with
MS Access or SQL Server
database: modules for Lab
(Participant) Management, To
Do Items and Distribution
Management.
Some
participants still
rely on paperbased results
data entry and
reports.
Data synchronised between
office database and website
database using web services.
programmemanagementsystem
Website for participants using
Active Server Pages with MS
Access or SQL Server
Database. Javascript for clientside validation.
Internet access for participants
for data entry and reports
(Acrobat PDF files).
Samples sent to participants.
Login Screen
Individual user login for
administrator or ordinary user
level access. Other security
levels can be built in, along
with Audit Trails as required.
Easy searching
on name etc
programmemanagementsystem
Participant / Laboratory List
programmemanagementsystem
Filter displayed records
Search options
Double-click to view lab
records
Lab – Main Details
Main details:
main contact,
main address,
courier,
distributor,
currency etc
Membership
programmemanagementsystem
programmemanagementsystem
Lab - Contacts
Multiple contacts:
Finance contact,
manager,
Technical contact,
quality manager etc
Lab – Finance / Registration Details
Multiple registration
forms
Multiple invoices /
invoice request forms
(for Finance Dept)
programmemanagementsystem
Lab – Correspondence
Out-going
correspondence
generated using Word
with Word templates
and mail merge.
Documents stored
centrally for future
reference.
In-coming
correspondence
scanned and stored
centrally as image.
programmemanagementsystem
Lab – Queries
Multiple queries:
complaints, requests
for extra samples,
unsatisfactory
performance, follow-up,
appeals etc
Query details
programmemanagementsystem
Lab – Queries / Actions
Multiple actions for
each query: eg letter,
visit, phone call,
investigation etc
programmemanagementsystem
Lab – Cohorts
For grouping labs / participants into informal
groups for reporting purposes
programmemanagementsystem
Lab – Meetings
Recording attendance of labs /
participants at annual
conferences, seminars, training
courses, meetings etc
programmemanagementsystem
programmemanagementsystem
Administration – Lookup Maintenance
Maintain system data eg
system users, distributors,
currencies, programme prices
etc
programmemanagementsystem
Administration – Web Services
Update website database using
Web Services
programmemanagementsystem
Reports
Various reports generated
using Crystal Reports (enabling
export to Word, Excel and
Acrobat PDF format) or mail
merge using Word and Word
templates
Batch Processes
programmemanagementsystem
For batch registration forms
and batch invoices / invoice
requests
To Do List
Multiple actions generated
from queries
programmemanagementsystem
To Do List – Action Details
programmemanagementsystem
Distribution List
Filter on Programme,
dates etc
List of distributions
programmemanagementsystem
Distribution Details
Summary data
Distribution details
Sample details
Audit trail / key
milestones
programmemanagementsystem
Distribution – Main Functions
Main Distribution functions:
synchronising data with
website database using web
services,
emailing labs about new
distribution and reports
availability,
results entry,
producing statistics.
programmemanagementsystem
Distribution – Results Data Entry
Example data entry
form:
designed to match
current forms,
quantitative,
qualitative and
interpretive results,
drop-down comboboxes to select lookup data for methods,
machines, techniques
etc,
mark data input as
complete,
acceptable late return
marker,
exclude sample
marker,
Comments for
recording reasons for
late return, sample
exclusion etc,
additional data eg
reagent lot number,
sample received date,
test date etc.
programmemanagementsystem
Distribution – Reports
Reports:
cover sheets to
accompany samples,
data entry forms,
labels for samples and
paper reports (for nonweb users),
picking lists for
bagging samples,
distribution progress
report,
distribution results /
reports for labs /
participants.
programmemanagementsystem
Distribution Administration
Lookup Maintenance
Maintenance of sample
data (as required)
Also methods,
manufacturers,
machines, techniques,
units etc.
programmemanagementsystem
Distribution Administration
Method Example
programmemanagementsystem
Example of Method maintenance where methods can
be used across different schemes / programmes
Participant Report Example 1
Participant’s results
programmemanagementsystem
Participant Report Example 2
Graphical
representation
programmemanagementsystem
Participant Report Example 3
Various graph types
available
programmemanagementsystem
Website Login
Website designed to match client’s
corporate image with colours, logo,
fonts, images etc.
Three elements for
participants to log in
for added security and
to allow individuals
with laboratory to
have their own login
for audit purposes.
programmemanagementsystem
Website Programme Selection
Scheme selection using dropdown combo box to display list
of distributions. Click a row for
data entry form and report.
Status of each
distribution shown.
programmemanagementsystem
Website Result Data Entry
Screen designed to
match paper data
entry forms if
necessary.
Qualitative, quantitative and interpretive result
with validation where required.
programmemanagementsystem
Buttons to save data, mark it complete (after which it
cannot be changed), and download report (when
available).
Print a blank
results form
for data entry.
Drop-down combo boxes for methods, units,
machines, techniques etc, with validation of
acceptable combinations if required.