Data Discs

beginning of content:

Transferring AP Data from CD to Your Computer

Follow these instructions to export the data into a readable file format, such as Microsoft Excel. Note: AP score reports on CD are not compatible with Mac computer systems.

Part 1

  1. Put the CD into your computer’s CD/DVD drive and then double-click on My Computer on your desktop.
  2. Double-click on your CD/DVD drive.
  3. Right-click on the file named APP.DAT.
  4. Select Open With and then choose Microsoft Excel.
  5. Save the data from the CD to your desktop or hard drive; you cannot save formatting changes directly from the CD.

Part 2

When the file has been opened in Excel, you will notice that all of the data is jumbled together into column A and not separated into individual columns as it should be. To remedy this, you will need to follow these steps:

  1. Highlight the entire column A. (Click on the letter A on the top left hand corner of the spreadsheet.)
  2. While column A is still highlighted, click on Data from the menus on the top of the screen. Then click on Text to Columns...
  3. A wizard should appear entitled Convert Text to Columns Wizard Step 1 of 3. Make sure Fixed Width is selected and click Next.
  4. On the following screen you will see a data preview of the file. In this step you will have to insert the column breaks to separate the fields. To determine where to insert the column breaks, please use your Dataset Record Layout (.pdf/203KB) (the sheet enclosed with the CD). The column entitled Location on the layout has the information that you will need to add the column breaks on the wizard to separate the fields. For example, the first field (Registration Number) is located in lines 1-8. To separate the fields, insert a column break by clicking on the eighth line using the ruler above the data. By inserting the column break, you will create a separate column for field 1. For the next field, insert a column break on line 23. Continue inserting column breaks according to the field location listed on the sheet. Please note: There will be lines Excel has inserted as defaults. Double-click the lines to remove them.
  5. After inserting all of the column breaks, click Next. If you like, you can format each column according to the information listed in the column (i.e., for field 12, format the information in the column as a Date.) See the Column Data Format area in the upper right corner. Otherwise, click Finish to display the formatted spreadsheet.
  6. All of the information should be in different columns according to where you inserted the column breaks. If you did not do so already, you can now format each individual column manually.