This activity allows you to practice creating a line listing as part of a disease outbreak investigation.
Each page provides information about an outbreak scenario. Click “Next Page” to move on to the next page or “Previous Page” to go back. You can monitor your progress at the bottom of the page (e.g. Page 4 of 25).
Many pages contain links to additional information. Links will open in a new window; be sure to disable your pop-up blocker (or hold the shift key while clicking on the link) to allow these windows to open. Click "Close window" to return to the main activity page.
Throughout the activity, you will see the following icons:
The Note Pad, located in the upper right corner of every screen, contains a summary of all of the information you have learned so far. Information is automatically added to the Note Pad so you do not need to print information from every screen. To view a note, click on its title. To hide a note, click on its title again.
The voicemail icon indicates that you have a new message. You can listen to the voicemail if you have computer speakers or headphones (recommended), or view a transcript of your voicemail message. A summary of the message will be added to the Note Pad.
The email icon indicates that you have a new email message. Your message will open in a new window. You will have the option to print your email, and the message contents will be added to the Note Pad.
The lab icon indicates laboratory results that you have received. The results will open in a new window. You will have the option to print the laboratory results, and they will be added to the Note Pad.
The Excel icon represents a line listing document. A screenshot of a Microsoft Excel spreadsheet will open in a new window and be added to the Note Pad.
Time to complete
- This activity should take approximately 30 minutes to complete, and we recommend that you complete it in one sitting. However, if you need to stop the activity, be sure to bookmark the current Web page so you can return to it later.
- Create a table shell for a line listing.
- Explain how a line listing is useful for understanding an outbreak.
The number next to each competency corresponds to the full list of CSTE competencies.
- List relevant data and information sources within and outside the public health system (I.A.1.a)
- Use methods for finding cases or other subjects suitable to the investigation (I.C.6.d)
The following tutorials are recommended for Epi Team members without experience with working in Microsoft Excel or creating a line listing. They can be viewed before beginning the activity.
- Microsoft Excel Tutorial
You can create a line listing in many different ways (e.g., computer spreadsheet, handwritten). In this exercise, we recommend that you practice creating a line listing in Microsoft Excel, which allows you to easily change and sort the data as you gain new information. If you are unfamiliar with Excel, you can view an online tutorial from the Microsoft Web site.
- Line Listing Lesson
This PowerPoint presentation describes the steps you need to follow to create a line listing. If you have never created a line listing, or need a refresher on the basic steps, please view this presentation before proceeding.