ICT Package

Clear Problem: -

Company: Doctors Surgery

Relocating: Kingston

Needs: To keep all the patients details on a computer data base with

appropriate back up system.

Real User: Dr Steer

Accessibility: This is strictly confident to Dr Steer only

Solution: -

This is a small but established surgery but has decided to go

paperless. We have grown over the years and can no longer rely on our

manual papers because they are simply getting too big. The move to new

premises means we can set up the ideal ICT package tailor made for our

needs.

1. To keep a details of the patients.

2. To enable accurate details on the patient.

3. Easy to access it as well.

Objectives: -

1. Create a patient detail list with any long term diseases or medical

formalities.

2. I will use access to produce an easy program for the doctor to use.

4. To enable a quick analysis of the total number of hours worked in a

week to see for eligibility of a pay rise.

5. The system is legible, we producible and at the end of the tax year

can be used to make the company report and tax declaration.

Analyse: -

Hardware:

I recommend any modern and up to date computer technology, such as

Dell. They provide reliable machines with easy ability to upgrade and

excellent support service.

It will need to have a CD-RW and a ZIP drive to enable the data to be

backed up.

Software:

I need a clear easy to use spreadsheet package. I feel the best is

Excel. This choice is based on recommendations and research of other

software. The advantages are it is simple, easy and reliable. I will

use the most up to date version and Microsoft is constantly updating

it.

Input:

The data clerk will produce and update the date every week. The data

is entered via a keyboard and an accounting manager will audit the

accounts monthly and do reconciliation.

Output:

The data entered will be shown on a TFT screen and stored to a CD

or/and ZIP.

This will be printed off using a laser printer and filled in an

accounting folder.

Back up-

Strategy:

The accounts will be needed to be backed up every Friday evening. This

is to protect the data from being lost due to a power surge. It will

be backed up on disk and be stored in a fireproof safe.

Design: -

Initial Design:

I am going to have a sample table to put my data on. I will draw it in

rough first (see enclosed) to see if my initial ideas would work.

The columns are headed:

Employee number

First Name