Back to Top

College Board Landscape

Landscape™ provides consistent applicant high school and neighborhood data to help admissions officers fully consider every student, no matter where they live.

The standard resources necessary to provide record data to College Board (and to import the associated Landscape data into Slate) can all be located within Slate's Research Configuration Library. These resources include:

Research source
Stores Landscape data based on the high school, neighborhood, and score data that was provided to College Board.
Record export query
Exports selected record data that can be uploaded to College Board.
Source format
Imports the Landscape data to the Landscape research source.

 

  Note

College Board is currently piloting this process with a select number of schools and will announce when the process expands to general access.

 

Step 1: Research source and additional configurations

Add the College Board Landscape Research Source

All of the elements needed to exchange data between Slate and College Board exist in the Research Configuration Library.

To add the College Board Landscape research source:

  1. Select Database from the main navigation.
  2. Under Configurations, select Research Configurations.
  3. From the right navigation, select Library.
  4. From the right navigation, select the Admissions folder.
  5. Select College Board Landscape from the list of research sources.
  6. To the right of the research source name, click the plus sign. A confirmation popup appears.
  7. Click OK

 

Add Additional Landscape Configurations

In addition to the data keys needed for the Landscape research source and the prompts associated with those data keys, both of which were added to your database automatically when you added the research source, the College Board Landscape research source lets you easily add the following items to your database from one convenient location:

  • The data keys needed for the Landscape research source (included by default)
  • The prompts utilized by certain data keys (included by default)
  • query formatted to the College Board Landscape specifications that can be exported and uploaded for tagging by College Board
  • source format to import the tagged data back into Slate.

To add these additional elements:

  1. Click the plus sign next to the item. A summary popup appears.

    Note:
    If you do not see this icon next to the item, you may need to refresh your Slate Template Library resources. This can be accomplished using the refresh the Slate Template Library link on the Database > Slate Template Library page.
  2. Click Add.
  3. If the item has a confirmation popup, click OK.

Now that the Landscape resources have been added from the library, the next section will walk us through additional configurations required before use.

 

Step 2: Customize the Export Query

The College Board Landscape Export query contains export values arranged and formatted to comply with the specifications necessary for the file to be consumed by College Board's data tagging system. There are certain customizations that must take place to the query prior to using it.

Since many of the data points needed by College Board for tagging are stored as custom data points within Slate, there are certain placeholder export values that use Literal values to indicate that they need to be replaced.

Additionally, there are some decisions that your institution may choose to make about the specific type of data that should be exported, such us sending a permanent address or a mailing address.

To customize the query:

  1. Select Queries from Queries / Reports in the main navigation.
  2. Use the search bar to find and select College Board Landscape Query.
  3. Click Edit Query.
  4. Click Save Copy so that you can reference the original, standard query, or start over if necessary.
  5. Enter a name and (optionally) select a new folder for the copied query.
  6. Click Copy. You are directed to the new query's edit page.
  7. For each Literal export that features the text ** Custom (for example, Application_Type), add a new export to the query that targets the appropriate data point within Slate. Give this export the same name as the literal export with which it corresponds. Click X to delete the placeholder export.

    Reference the College Board Landscape Data Points table for more information about each of the necessary data points.
  8. Add filter criteria to limit the records sent to College Board.
  9. (Optional): If desired, adjust any standard exports to point to custom data points instead.

    Note
    :
    Make sure that the export name and the export data type remain the same.

Once the query has been finalized, the query can be run manually to generate a data file.

 

College Board Landscape Data Points

Files uploaded to College Board's system must adhere to the specified format.  Each column header must be included, regardless of whether your institution supplies data in that field.

FieldField Form or Allowed Values Description

Applicant_ID

Original format

Unique identifier for each record. The applicant_id should be anonymous, that is, not allowing personal identification of the student from publicly available information.  It should not be the student's Social Security Number. 

Street_Address_1

Text string

Line 1 – use permanent or mailing address

Street_Address_2

Text string

Line 2 – use permanent or mailing address

Street_Address_3

Text string

Line 3 – use permanent or mailing address

City

Text string

City name

State

2 character string

Customary 2 character state abbreviation

Zip

5-digit numeric

5 digit zip code

Country

Text string

Full country name

GeoID

11-digit number

OPTIONAL – submit GeoID in lieu of address

HS_CEEB_code

6-digit number

CEEB code of the high school the applicant attended

Gender

1, 2 or 3

1 = Female
2 = Male
3 = Another (not listed)

SAT_Math

3-digit numeric

3 digit SAT score

SAT_EBRW

3-digit numeric

3 digit SAT score

ACT_Composite

2-digit numeric

2 digit ACT score

Old_SAT_Math

3-digit numeric

3 digit SAT score

Old_SAT_CR

3-digit numeric

3 digit SAT score

Old_SAT_Writing

3-digit numeric

3 digit SAT score

ACT_English

2-digit numeric

2 digit ACT score

ACT_Math

2-digit numeric

2 digit ACT score

ACT_Science

2-digit numeric

2 digit ACT score

ACT_Reading

2-digit numeric

2 digit ACT score

ACT_Writing

2-digit numeric

2 digit ACT score

Application_Type

1 or 2

1 = Early
2 = Regular

Admitted

0, 1

0 = not admitted
1 = admitted

Enrolled

0, 1

0 = not enrolled
1 = enrolled

Waitlist

0 or 1

0 = not waitlisted
1 = waitlisted at any time.

This variable only covers whether an applicant was waitlisted at any time during the admissions process; the applicant's final admission status should be indicated in the decision.

First_Year_GPA

3-digit numeric

First year GPA (0.00 – 4.0 scale)

Sophomore_Retention

0 or 1

0 = not retained to sophomore year
1 = retained to sophomore year

Race 

1 – 9

OPTIONAL

1 = White
2 = Black or African American
3 = Hispanic/Latino
4 = Asian
5 = American Indian or Alaska Native
6 = Native Hawaiian or Other Pacific Islander
7 = Two or More Races
8 = International
9 = Unknown

Entry_Term

4-digit numeric

Year of Fall Term for which the applicant applied

First_Generation

0 or 1

OPTIONAL

0 = not first generation
1 = first generation

HSGPA

3-digit numeric

High school GPA (0.00 – 5.00 scale)

Pell_eligible

0 or 1

OPTIONAL

0 = not Pell eligible
1 = Pell eligible

Number_of_AP_exams

1 or 2-digit numeric

Number of AP exams taken (0-38)

AP_Average

3-digit numeric

Average of all AP exam scores (Min=1.00; Max=5.00)

Number_of_IB_exams

Numeric

Number of IB exams taken

IB_Average

Numeric

Average of all IB exams taken

Custom_1

Original format

Custom data field for use by institution. This field can hold up to 100 alphanumeric characters. Use this field to keep track of information for further distinction of records or for your own research purposes (e.g. distinguish between fall and winter applicants for 2020, identify scholarship candidates or honors scholars, etc.).

Custom_2

Original format

Custom data field for use by institution. This field can hold up to 100 alphanumeric characters. Use this field to keep track of information for further distinction of records or for your own research purposes (e.g. distinguish between fall and winter applicants for 2020, identify scholarship candidates or honors scholars, etc.).

Custom_3

Original format

Custom data field for use by institution. This field can hold up to 100 alphanumeric characters. Use this field to keep track of information for further distinction of records or for your own research purposes (e.g. distinguish between fall and winter applicants for 2020, identify scholarship candidates or honors scholars, etc.).

 

Permanent or Mailing Address

In the query template from the library, the top-ranked address, regardless of the type, is included in the data. Your institution can customize the type of address to send to College Board for tagging. This choice largely depends on how your institution captures and stores address data.

For example, if you always capture the mailing address, but only ask for permanent address if it is different, send the mailing address to College Board. If your institution captures a mixture of permanent and mailing addresses, you may wish to use the top-ranked address, regardless of the type.

To update the included address:

  1. Select Queries from Queries / Reports in the main navigation.
  2. Use the search bar to find and select College Board Landscape Query.
  3. Click Edit Query.
  4. In the Joins section, select the Address subquery join.
  5. Click Filter.
  6. Add filters to limit which addresses are eligible for inclusion in the data. In this example, the Address Type filter limits the address types that are exported.
  7. Click Save once all of the desired filters and adjustments to the join are complete.

Edit_Address_Join_to_Filter_for_Address_Type.png

  Note

While the default, library version of this join has no filters, it includes a sort to order the addresses on the record by their overall rank. Since this is a subquery join, only one row is returned for each record. This effectively limits the address data to the rank 1 overall address on the record.

If you add an address type filter, then only addresses in the selected type are eligible for inclusion, and those addresses are then sorted by the overall rank to return just a single address for the record.

Also note: International addresses cannot be tagged.

 

Test Score Options

Verified or Self-Reported Scores

In the query template from the library, test scores are used regardless of the verification status (self-reported or verified). If your institution elects to send only verified test scores, follow the steps below. 

 

SAT Scores

  Note

The SAT scores included in the joins described below are the highest combined scores from a single test date.  If your institution would like to send the highest SAT scores achieved, regardless of the test date (superscores), follow the instructions in the section Single Test Date or Superscore: SAT instead.

To filter the query for verified SAT scores only:

  1. Select Queries from Queries / Reports in the main navigation.
  2. Use the search bar to find and select College Board Landscape Query.
  3. Click Edit Query.
  4. In the Joins section, select the Tests - SAT R subquery join.
  5. Add the Status filter.
  6. Select Verified.
  7. Click Save to finish adding the filter.
  8. Click Save to save the join.
  9. Repeat steps 1 - 5 for the join Tests - SAT I.

Edit_SAT_-_R_Join_to_Filter_for_Verification_Status.png

  

 

ACT Scores

  Note

The ACT scores included in the joins described below are superscored.  If your institution would like to send the scores associated with the highest composite score from a single test administration, follow the instructions in the section Single Test Date or Superscore: ACT instead.

To modify the query to send only verified ACT Composite scores:

  1. Select Queries from Queries / Reports in the main navigation.
  2. Use the search bar to find and select College Board Landscape Query.
  3. Click Edit Query.
  4. Select the export ACT_Composite.

ACT_Composite_Subquery_Exports.png

  1. For each subquery export in the ACT_Composite export (English, Math, Reading, Science, and Writing):
    1. Edit the subquery export.
    2. Add the Status filter under the Tests section.
    3. Selected Verified.
    4. Click Save to save the filter.
    5. Click Save to save the subquery export.
    6. Repeat these sub-steps for each remaining subquery export.
  2. Click Save.

Add_Status_Filter_for_Verified_ACT_Scores.png

  

 

To modify the query to send only verified ACT component scores, for each of the component score export columns (ACT_English, ACT_Math, ACT_Reading, ACT_Science, and ACT_Writing):

  1. Select Queries from Queries / Reports in the main navigation.
  2. Use the search bar to find and select College Board Landscape Query.
  3. Click Edit Query.
  4. Select the export to modify (for example, ACT_English).
  5. Add the Status filter under the Tests section.
  6. Select Verified.
  7. Click Save to save the filter.
  8. Click Save to save the changes to the export.
  9. Repeat these steps for the remaining ACT component score query export columns.

Add_Status_Filter_for_Verified_ACT_Component_Score.png

 

AP and IB Scores

To send only information about verified test scores for AP and IB exams, for each of the exports Number_of_AP_examsAP_AverageNumber_of_IB_examsIB_Average: 

  1. Select Queries from Queries / Reports in the main navigation.
  2. Use the search bar to find and select College Board Landscape Query.
  3. Click Edit Query.
  4. Select the export to modify (for example, Number_of_AP_exams).
  5. Add the Status filter under the Tests section.
  6. Select Verified.
  7. Click Save to save the filter.
  8. Click Save to save the changes to the export.
  9. Repeat these steps for the remaining AP and IB query export columns.

Add_Status_Filter_for_Verified_AP_or_IB_Exams.png

 

Single Test Date or Superscore: SAT

The default query template uses the top-ranked test scores for each SAT type (SAT R and SAT I) on a single test date. If your institution would like to send the highest combined scores, regardless of the test date, follow these steps to modify the query.

To superscore SAT test scores for a given type:

  1. Select Queries from Queries / Reports in the main navigation.
  2. Use the search bar to find and select College Board Landscape Query.
  3. Click Edit Query.
  4. Delete the exports in the query that correspond with the test score type (for example, SAT_EBRW and SAT_Math).
  5. Delete the join that supported the deleted export columns (for example, Tests - SAT R).

    Note:
    Any query references to the join must be removed before the can be deleted.

Delete_Exports_and_Joins_-_SAT_R_Example.png

SAT R examples
  1. Click Subquery Export. This replaces the first of the two exports you deleted.
  2. Configure the following settings:
    • Enter a name that corresponds with the column you are configuring, for example: SAT_EBRW:
    • Type: Dependent subquery
    • Output: Aggregate
    • Aggregate: Maximum

Configure_SAT_EBRW_Subquery_Export_Settings_-_SAT_R_Example.png

  1. Click Join. Select the test type corresponding with the export being configured (for example, Tests - SAT R).
  2. Click Continue.
  3. Click Save.

Join_to_Test_Type_-_SAT_R_Example.png

  1. Click Export. Add the export from the added join's section (for example, Tests - SAT R) that corresponds with the column you are configuring, for example, Evidence-Based Reading and Writing.
  2. Click Continue.
  3. Click Save.

Add_Export_-_Evidence-Based_Reading_and_Writing_-_SAT_R_Example.png

  1. Click Subquery Filter. The filter requires the test score is ranked to prevent the inclusion of cancelled, discrepancy status, and test optional scores in the data. Configure the following settings:
    • Name: Customizable and used solely for the configuration (for example, "Rank Exists").
    • Type: Dependent subquery
    • Aggregate: Exists
  2. Within the subquery filter, click Export.
  3. Add the Rank export from the added join's section.
  4. Click Save.

Subquery_Export_-_Rank_Export_-_SAT_R_Example.png

Optional: If your institution would like to send only Verified test scores to College Board, add the Status filter from within the added join's section (for example, Tests - SAT R).

Within the subquery export:

  1. Click Filter. 
  2. Under the join's section (in this example, Tests - SAT R), select Status.
  3. Click Continue.
  4. Select the Verified status.
  5. Click Save.

  1. Lastly, click Save to save the new subquery export.

Add_Verified_Filter_to_Subquery_Export_-_SAT_R_Example.png

Completed_SAT_Superscore_Subquery_Export.png

Completed SAT EBRW superscore subquery export (SAT R example).

For each remaining export column associated with the current test type that must be replaced:

  1. Use the Copy button on the export created in the steps above to open a replica of the export created.

Copy_SAT_Composite_Subquery_Export_-_SAT_R_Example.png

  
  1. Update the Name to the name of the column you are configuring (e.g., SAT_Math).
  2. Delete the query export (e.g., Tests - SAT R Evidence-Based Reading and Writing Section)

Rename_Copied_Subquery_Export__Delete_Export_-_SAT_R_Example.png

  
  1. Click Export.
  2. Select an export from the join section (for example, Tests - SAT R) that corresponds with the column being replaced (for example, Math Section).
  3. Click Continue.
  4. Click Save Copy.
  5. If both SAT score types should be superscored, Repeat Steps 1-7 for the other test type.

Add_Export_-_Math_Section_-_SAT_R_Example.png

Completed_SAT_Math_Superscore_Subquery_Export.png

Completed SAT Math section superscore subquery export (SAT R example).

 

Single Test Date or Superscore: ACT

In the default query template, the ACT test type is superscored. If your institution would like to send the scores associated with the highest composite score from a single test administration, follow the steps below to modify the query.

To send ACT scores associated with the highest composite score from a single test administration:

  1. Select Queries from Queries / Reports in the main navigation.
  2. Use the search bar to find and select College Board Landscape Query.
  3. Click Edit Query.
  4. Delete the exports that correspond with the ACT test score components: 
    • ACT_Composite
    • ACT_English
    • ACT_Math
    • ACT_Science
    • ACT_Reading
    • ACT_Writing

Delete_ACT_score_component_exports.png

  1. Click Join.
  2. In the Person, select Tests - ACT.
  3. Click Continue.

Add_Join_to_Tests_-_ACT.png

  1. Click Subquery Filter.
  2. To require that the test score is ranked to prevent the inclusion of cancelled, discrepancy status, and test optional scores in the data, configure the following settings:
    • Name: Customizable and used solely for the configuration.
    • Type: Dependent subquery
    • Aggregate: Exists

Configure_ACT_Subquery_Filter_Settings.png

  1. Within the subquery filter, click Export.
  2. Select Rank from the Tests- ACT join's section.
  3. Click Continue. 
  4. Click Save.

Subquery_Filter_Export_-_Rank_Export_-_ACT.png

Optional: If your institution would like to send only Verified test scores to College Board, add the Status filter from within the Tests - ACT join's section.

Within the subquery filter:

  1. Click Filter. 
  2. Under the Test - ACT join's section, select Status.
  3. Click Continue.
  4. Select Verified.
  5. Click Save.

Add_Status_Filter_for_Verified_ACT_Scores_-_Single_Test_Date_or_Superscore.png

  1. Click Sort.
  2. Select Rank. This orders the matching ACT scores by rank (highest composite score first). Since this is a join, only the first score to meet the filter criteria will be included, so ordering by rank ensures that the data included in the query is from the highest highest composite ACT score achieved.
  3. Click Save to save the join.

Sort_Matching_ACT_Scores_by_Rank.png

  1. Click Export.
  2. Select exports for each of the ACT score components from the Tests - ACT join configured previously:
    • Composite
    • English
    • Match
    • Reading
    • Science Reasoning
    • Writing

Select_ACT_Exports.png

 
  1. Rename each of the exports to match the column headers required by The College Board:
    • ACT_English
    • ACT_Math
    • ACT_Composite
    • ACT_Science
    • ACT_Writing
    • ACT_Reading

Rename_ACT_Exports.png

  

 

Step 3: Configure the Remap Settings for the Source Format

Once a file has been received from College Board, the Remap settings must be configured and then activated. Many of the source fields are pre-mapped to the College Board Landscape research source destination.

Important!

Remap settings are customizable, with the following exception: Mapped applicant_id

The applicant_id field is the Slate GUID that was sent in the data export. This value is used for matching purposes back to Slate, and it is mapped to the Slate GUID Matching Only destination. Changing this mapping destination will prevent records from importing appropriately.

applicant_id_Source_Field.png

 

To configure the source format's remap settings:

  1. Select Database from the top navigation.
  2. Under Import, select Source Formats.
  3. From the list, select College Board Landscape.
  4. Select Remap. View the standard, pre-mapped Slate destinations, and update the settings according to your institution's needs. Refer to the Source Formats section of the Knowledge Base for additional details on the configuration of source formats.
  5. Navigate back to the source format's landing page.
  6. Select Edit from the upper right.
  7. Update Remap Active to Active.

  Note

The data in the files from College Board contains data that was exported from Slate in addition to the Landscape data. The Slate GUID (included as the applicant_id column) is therefore able to be used for matching purposes. Bio/demo and score data exported from Slate should not be mapped back to those destinations within Slate.

 

Exporting Data from Slate

  1. Navigate to the landing page for the College Board Landscape: Record Export query configured in the previous section. 
  2. Use the Run to Browser button to download the data from the query as a CSV file.

Follow the steps outlined on the Landscape Help page to upload this file to College Board's Landscape system and retrieve a tagged data file from College Board.

 

Importing Landscape Data

  1. Navigate to the landing page for the College Board Landscape source format added earlier.
  2. Click Upload File(s).
  3. Upload the files retrieved from College Board's Landscape system.

If you have already configured the source format and activated the Remap settings, Slate will automatically process the import during the next import job cycle (typically within 15 minutes).

If you have not yet configured the source format, return to the section Configure the Remap Settings for the Source Format.  Once the source format's Remap Active setting is Active, the data will import during the next import job cycle.

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.