Please turn on the javascript option.

NSW Department of Education and Training

Curriculum support for NSW Public Schools

Using databases in PDHPE

The following activity investigates the types of health services available in the local community. Students then import, mailmerge and reformat data and fields to produce individually addressed letters to each of the health services identified.

Task:

Students create a database of the contact details of local health services and develop a letter to request support for a Healthy Lifestyles Forum to be held at the school. The students need to complete the following steps for this task:

  1. Identify the health services that are available in their local community.
  2. Locate the addresses and contact person for each of the services identified in Step 1.
  3. Using Microsoft Word create a database of the names and addresses of all of the health services within the local community that have been identified by the class group.

Teacher tip: Access the help menu under “using data merge to create form letters” for step-by-step instructions of the process.

  1. As a class group, draft a form letter using the create button in the data merge manager, that could be sent to the health services requesting their support for a Healthy Lifestyles Forum to be held at the school.
  2. Using the preview menu in the data merge manager, check the letter and addresses to ensure that the fields are correctly placed.
  3. Use the merge function to complete the mail merge.
  4. Print out the letters. Address labels can also be created for ease of forwarding them to the respective services.
NEAL's logo

Conditions of use | Help | Contact us
Report incorrect, out-of-date or missing information