OECD Health Data Guide
Help | Quick Query | Quit | Start | Tables, Charts and Maps |
 |
Two search options are available:
| Quick Query one variable one country or all countries one, two or all years available calculate growth rates for the relevant period create maps (if all countries selected) |
Tables, Charts and Maps one or more variables one or more countries one or more years calculate growth rates for the relevant period create charts and maps from the tables created |
Help: HELP:
Click the ? for context-sensitive help at any time. Quick Query Click Quick Query.
The 10 top level chapters are displayed. Click the (+) button to see all the chapters.
Double click the chapter, variable and unit desired, or click the Search Index check box to search for a variable by keywords using the "Starts with" or "Includes" tab.
(To return to the Chapter listing, click the Searh Index box again.)
The information selected will be displayed on the upper right of the screen.
Select the desired country or countries.
To select one country scroll through the list and double click on the desired country. To select all countries, click the All Countries check box.
Select the desired years.
NOTE: If ALL countries are selected, ONLY data for one or two years can be displayed.
Click the Availability button on the lower right of the screen. In the Availability box, the larger dots indicate the years for which data is available for either the one country selected or for all countries selected.
Click on the desired years (blue dots will turn green) and then click OK button.
Click Results button to view the data.
To access the Quick Query window again, close or minimize the Results window.
To Change the View of the Results:
If one country and one or two years is selected (the results are not displayed as a table), multiple results can be viewed at one time. Minimize the Results window or place the mouse pointer on title bar and drag the Results window to the desired location on the screen. Repeat the Quick Query process.
NOTE: The Tables, Charts and Maps option is highly recommended in place of multiple Quick Queries.
If the results of a Quick Query are displayed as a table, the columns can be moved. Place the mouse pointer on column heading and drag it left or right. Adjust the width of the columns by placing the mouse pointer on the column heading at line separating the column (the pointer becomes a double arrow). Drag it to the desired width.
The data can be sorted in a number of ways, e.g.
Click on the A-Z button to sort the data alphabetically by country
Click on the 0-7 button to sort data in ascending order by year.
Click the appropriate icon to sort data in ascending or descending order by value of the selected variable.
To Save the File:
First click the Copy button to copy the query results to the Clipboard for use in other applications.
To save the file, minimize OECD Health Data Library.
Double click the Clipboard icon. Click File on the menu bar and select Save As.
NOTE: File name must include drive letter, e.g. a:filename
Click Tables, Charts and Mpas.
A number of useful tables have been created and are available in the OECD Health Data Library.
Click the button in the lower left corner of the Create Table window (to the right of the ?) to view a list of the tables in the OECD Health Data Library.
Highlight the desired table and click OK.
To return to the Create Table window, clik the quit button on the table toolbar.
B. To Construct a Table:
Click Tables, Charts and Mpas.
In the Create Table window, click the Add button to view the list of chapters.
Select the chapter,variable and unit as in Quick Query mode.
Repeat process to select additional items.
To modify a selected variable, highlight it and click the Modify button.
To remove a selected varaiable, highlight it and click the Cut button. (Use the Paste button to reinsert the last variable cut.)
Click the Countries tab. Select the countries from the list or click the Group icon to select a group of countries.
Click the Years tab. Select the years desired. Click the Availability button to ensure that data is available or one or all variables, and one or all countries.
To create the table, click the Construct tab.
Choose the type of item that is to be fixed, e.g. 1 country, 1 year or 1 variable.
Select the type of item for the rows and columns, e.g.
| fixed item rows columns |
year countries variables |
1997 G-7 Group of Countries Total expenditure on health, Total population, etc. |
NOTE: Do NOT click the Save button. It is only used to save the table to the OECD Library.
See Data Output Options below for saving a table.
To Change the View of the Table:
Double click a column heading to change the title of the column.
Double click the empty cell in the upper left of the table to change the table title.
To change the column width, click the column separator line at the column heading. (The pointer becomes a double arrow.) Drag the column to the desired width.
To Add Variables to a Displayed Table:
Click the table's close box (X) to return to the Create Table window. Click the Variables tab and then click the Add button to add variables to the table. Continue as outlined under Tables, Charts and Maps.
Data Output Options:
Click one of the options on the table toolbar, e.g.
Print
Export (save) NOTE: File name must include drive letter, e.g. a:filename
Other options on the table toolbar include:
| Show/hide toolbar Change the scale of the table displayed (zoom) Adjust the width of the columns according to content Adjust the width of the columns to the width of the active column Show/hide the gridlines Sort the elements of the selected column in ascending/descending order Add a column / Delete a column Calculate the arthimetic mean of the values in the active column Calculate the sum of the values in the active column Perform simple regressions Evaluate the similarities and differences between countries Copy the active portion to the clipboard Access the chart module Construct a map based on the active column when the rows are countries Quit/cancel |
To Quit: Click the Quit button in the lower right corner to return to the previous screen.
To exit OECD Health Data, at the main screen, click Quit Health Data.
please ask at the Information Desk.
|
|
|
|
Health Sciences Library Memorial University of Newfoundland St. John's, NL Canada A1B 3V6 Phone: Contact Us Fax: 709-777-6866 |
August 4, 2008
Shelagh Wotherspoon
