|
|
||
|
|
Instructions
for using the Free Download of OKDATA Computer Spreadsheet
Right click here and select 'Save Target As' to download the free file - OKDATA
System requirementsYou will require a PC running Windows, and with Microsoft Excel installed. Instructions 1. Open the Microsoft Excel spreadsheet
program on your PC. 2. Open the file on the disk named
‘OKData’ The ready prepared OK Health Check
spreadsheet file should open onto your screen. Across the top of the screen are headings in
shaded boxes Down the left hand side is a shaded column
headed ‘Names’. This is where you enter the name of the client. The next column, ‘Reference’ is provided if you wish to
use a reference number or case number to identify your client. Having entered a client’s name, you move
across the spreadsheet from left to right entering data as required. The number in brackets in the header box is the number of the corresponding item on the ‘OK’ Health Check Client Assessment Sheet. It is assumed you will be using the assessment sheet to provide you with the information to enter on the spreadsheet program. The first few entries require you to enter text information copied from the Client Assessment Form as follows: ‘DATE’ is today’s date, or the date of the assessment. Use the dd/mm/yy formula. NEW! The next column, 'Needs Updating?' is an automatic reminder that the file needs updating. It has been set to 6 months. This will only operate if your PC has the 'Analysis Toolpacks' installed from your Windows Office or Excel disk. Note also that the date format must use the format shown above. Where there is no file entered the word 'Update' automatically appears. Should you wish to change the duration of update from 6 months to some other time duration, just enter the cell and edit the formula, deleting the '6' and putting in its place the number of months you want. ‘AGE’ is the client’s current age in numbers. ‘SEX’ requires you to enter an ‘m’ or an ‘f’. ‘Clinical Syndrome’ requires you to enter the name of the syndrome or disease that applies to the client, if it is known. If it is not known, leave this cell (box) blank. ‘Weight’ should be entered using kilograms, with two decimal points, for example 54.23, or 63.75. If you cannot weigh the client, leave it blank. ‘Height’ should be entered
using centimetres, for example, 178, 154 or 146. If you cannot measure the
client, leave it blank. ‘BP’ is the
clients Blood Pressure at rest, and should be recorded as two numbers separated
by a ‘/’, for example 130/80, or 140/95. If it is not available, leave the
cell blank. ‘Pulse’ is
the client’s pulse rate at rest and is recorded as a simple number.
If it is not available, leave the cell blank. ‘Resp.’
refers to the clients rate of breathing, respiration and is a simple number. If
it is not available, leave the cell blank. All of the remaining boxes require you to
enter a single letter to duplicate the responses from the numbered questions on
the Client Assessment Form, which will have a ‘tick’ in either the
‘YES’, ‘NO’ or ‘Don’t know’ box.
Simply enter a ‘y’, ‘n’ or ‘d’ accordingly on the data sheet. ‘y’ = ‘yes ‘n’ = ‘no’ ‘d’ = ‘don’t
know’ Saving the data sheet
You will need to save the work you enter
onto the blank data sheet. It is
suggested that you create a name for your completed datasheet and save it as
soon as you have opened it. You do
this as follows. 1. Open the ‘OKData’ file onto your
screen. 2. Click on ‘File’ – ‘Save
As’ 3. Select the place on your hard drive where
you wish to save the file in the ‘Save In’ box. 4. Enter a name for your records and type it into the ‘File Name:’ box. (You might choose something like ‘OK2004’ which tells you it is the data for 2004). 5. Click ‘OK’ Enter the data into the spreadsheet on
screen, and after every few entries simply click you mouse on the ‘SAVE’
icon at the top of the screen, and the file (eg OK2004) will automatically be
updated. Remember to make a final
save of the data immediately before you close the PC at the end of a session. Next time you want to enter more data,
simply click on the ‘OPEN
FILE’ icon, then click on the file which you named, (eg OK2004). Statistical Information
The information stored in the program should
be of enormous value to a service manager, by informing the service about the
numbers of clients in specific categories. By scrolling to the bottom of the screen, in
column ‘A’ you will find the word ‘TOTALS’. Alongside this are four rows of information
about each of the items above. This information is
the calculations of the data entered, and tells you how many items are
selected in each category. Column ‘E’ for example tells you how many males and females are entered into the spreadsheet, Column ‘Q’ tells you how many clients have known heart problems, and how many do not. Column ‘V’ tells you how many clients have epilepsy and so on. For many columns there is an option for ‘don’t know’ to be selected. This is important as it sometimes highlights the need for further investigation or for staff training. Printing You can print out the entire sheet, or just
a section from it. To print out the whole sheet is a clumsy and
untidy business, which necessitates a sorting operation to put it all in order
as the print out is spread over many sheets.
To print the whole file just click on the printer icon. To print a section of the sheet highlight
the section you require by clicking and dragging the mouse from top left to
bottom right. When the piece is
highlighted, click on: ‘FILE’ – ‘PRINT’ a small dialogue box will open. Look for the ‘Print what:’ item and click next to ‘Selection’. Then click OK.
|
|
