A-G Alignment Tool

Drag to your bookmarks bar

Drag the button below into your browser's bookmarks/favorites bar. You only need to do this once.

Navigate to any school's A-G page

Go to hs-articulation.ucop.edu/agcourselist (opens in new tab), search for a school, and open its course list page.

Click the bookmarklet

Click Download A-G Courses in your bookmarks bar. The tool will automatically fetch all course details and download a formatted .xlsx file — no copying or pasting needed.

Select Your Student Information System (SIS)

Choose your SIS below to see the correct export instructions for Step 5.

Aeries SIS Query

Run this query in Aeries, then use Print → Export to Excel:

Columns returned: Course Name (CN), Course ID (CO), CSU Req (E1), UC Req (U1), Status Tag (TG)

Infinite Campus Ad Hoc Export

Build and run this query in IC, then export to Excel:

1. Select Your Fields

1. Go to Ad Hoc Reporting › Filter Designer
2. Click New and select Query Wizard
3. Choose Course as the Data Object
4. Expand the Course folder and add these fields in order:
   Course.number Course.name Course.ucApproved Course.active

2. Set Up Filters

1. For ucApproved — leave Operator and Value blank (returns all courses)
2. For Course.active — set Operator to =, Value to 1
3. For Course.gradeLevel — set Operator to >, Value to 08

3. Export the Data

1. Click Save and name it (e.g. "Active Course Catalog - All")
2. Go to Ad Hoc Reporting › Data Export
3. Select your saved query, choose Excel (.xlsx), and click Export

School Pathways Report Builder

Build and run this report in School Pathways, then export to Excel or CSV:

1. Open Report Builder

1. Log in and navigate to the Reports tab at the top
2. Select Create A Report (sometimes labeled "Custom Report Builder")

2. Select the Course Table

1. Under "Start With" or "Table Selection", choose Course Table
2. Select Create a Report
3. Note: Do not select the Student table — it only shows courses with enrolled students

3. Choose Your Columns

1. Add these fields in order:
   Course Code Course Name UC A-G Code Active

4. Apply Filters

1. For Active — set restriction to True
2. For UC A-G Code — do not adjust (returns all courses regardless of A-G status)
3. For School Year — set to current academic year (e.g. 2025–2026)
4. Hit Next

5. Select Options

1. Under the Field Arrangements section, move Active to the bottom of the field list

6. Export the Data

1. Click Continue or Okay, then click Display Results
2. When the list appears, click the Excel or CSV icon (top right of the data grid)