Instructions for exporting data lists from iPASS for Houghton Mifflin Math ‘ 05 Field test

You must choose the data fields that you need to export.  The following fields are recommended:

Grade Level, Home Room, SASID, Primary Language, Sped Status, Lunch Type, Ethnicity State Code

Follow these steps:

• Log onto iPASS

• Go to the Biographical folder

• Go to the Export Report tab

• Choose the following fields from the Export Report drop down lists located on the right (indicated by a triangle)

• Enter the following fields into the Export Report (by clicking on the triangle that will produce a drop down list)

• Field 1:  Grade Level

• Field 2:  Home Room

• Field 3:  SASID

• Field 4:  Primary Language

• Field 5:  Sped Status

• Field 6:  Lunch Type

• Field 7:  Ethnicity State Code
   

• In the Filter Criteria area only make the following changes

• School:  choose your school name from the list

• Grade Level:  Leave it at ALL

• Home Room:  Leave it at ALL

• Sort By:  Grade Level
   

• The file will then go to you're My Reports folder (you may have to wait until it is done processing)

• Go to the My Data Folder

• In the report list choose the TXT or CSV option to view your data

• Right click on the file of your choice

• Save Target as

• If you use CSV give the file a name with an extension of .CSV and save it to your desk top

• Then you will be able to open it in Microsoft Excel to view or manipulate and print the file

• You may also widen the columns and label the field names that you exported.

• Highlight Row 1

• Go to the top menu and INSERT row (that will give you an extra row of cells to name your exported columns)

• Go the the menu at the top and click Format, column, auto fit selection

• Click on the save icon again to save your changes

• You may have to adjust your margins in Print Preview get the best printing results.

If you have any questions give us a call at the Telecom Dept.