Classic View: MD State Reporting > Course Catalog Extract
Search Terms: Course Catalog Extract
This report is a course classification and data collection system that contains all the courses offered in Maryland public schools. The MCC is based on the national model and the School Codes for the Exchange of Data (SCED) developed by the National Center for Education Statistics (NCES). The MCC includes grades pre-kindergarten through grade 12.
Course Catalog Extract Editor
Report Logic
- Reports a record for each active course number in the selected Course Catalog(s).
- Courses only report once per Course Number even if the course exists more than once in a Course Catalog or in multiple catalogs.
- Courses marked as inactive or exclude on the Course Master do not report.
- When the Full Catalog checkbox is marked on the extract editor, the report returns all courses including courses with no scheduled students.
Do NOT mark this checkbox when creating the file for state submission.
When the Full Catalog checkbox is NOT marked, the report only returns courses with at least one student scheduled in the Academic Year selected on the extract editor.
Report Editor Fields
| Field | Description |
|---|---|
| Course Catalog(s) | All Catalog selection and each course catalog selection if there is more than one course catalog. You may select single, multiple and all catalogs. |
| Academic Year | The academic year from which data is reported. The active school year is the default selection. |
| File Identifier | This identifier displays after the date in the file name. 001 is the default file identifier. |
| Format | Determines the format for the report. Use the CSV (State Format) when submitting the final data. Use HTML or TXT for data review and testing. |
| Full Catalog | This checkbox further determines which courses report. See the Report Logic section for more information. Do NOT mark this checkbox when creating the file for state submission. |
| Generate Report Submit to Batch | Users have the option of submitting the report request to the batch queue by clicking Submit to Batch instead of Generate Extract. This process allows larger reports to generate in the background without disrupting the use of Campus. For more information about submitting a report to the batch queue, see the Batch Queue article. |
Report Layout
| Element | Description | Location | ||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| AcademicYear | The current school year, reported using the end year associated with the Academic Year selected on the extract editor. Date field, 4 characters YYYY | System Administration > Calendar > School Years > Active Year > End Year | ||||||||||||||||||||||||||||||||||||||
| LEA | The two-digit State designation of the LEA. Alphanumeric, 2 characters | System Administration > District Info > State District Number | ||||||||||||||||||||||||||||||||||||||
| SCEDSubjectArea | The intended major subject category of the education course. Alphanumeric, 2 characters | Scheduling > Courses > Course Master Info > SCED Subject Area | ||||||||||||||||||||||||||||||||||||||
| SCEDCourseNumber | The three-digit number for an SCED Subject Area. Numeric, 3 digits | Scheduling > Courses > Course Master Info > SCED Course Identifier | ||||||||||||||||||||||||||||||||||||||
| CourseLevel | An indication of the general nature and difficulty of instruction provided throughout a course. SCED Course Level Codes
Numeric, 4 digits | Grading and Standards > Course Masters > Course Master Info > NCES Data > SCED Course Level OR Scheduling > Courses > Course > NCES Data > SCED Course Level | ||||||||||||||||||||||||||||||||||||||
| CarnegieUnits | Measured in Carnegie Units, the amount of credit available to a student who successfully meets the course objectives. Numeric, 4 digits #.## | Scheduling > Courses > Course Master Info > SCED > Carnegie Units | ||||||||||||||||||||||||||||||||||||||
| SCEDGradeSpan | The grade span for which the course is appropriate. The span is represented by a four- character code with no decimals. Numeric, 4 digits | Course > State Grade Level Low AND State Grade Level High | ||||||||||||||||||||||||||||||||||||||
| SCEDSequenceOfCourse | The first part in the sequence or order of a series of courses if there are multiple parts. The first number of the SCED Sequence reports. Numeric, 2 digits | Scheduling > Courses > Course Master Info > SCED Sequence | ||||||||||||||||||||||||||||||||||||||
| SCEDSequenceTotal | The second part in the sequence or order of a series of courses if there are multiple parts. The second number of the SCED Sequence reports. Numeric, 2 digits | Scheduling > Courses > Course Master Info > SCED Sequence | ||||||||||||||||||||||||||||||||||||||
| MSDESubjectCode | The 4 digit code that identifies the MSDE identified subject area. Numeric, 4 digits | Scheduling > Courses > Course Master Info > State Code | ||||||||||||||||||||||||||||||||||||||
| LEACourseCode | The unique LEA assigned course code that identifies the course as noted in the LEA course catalog. Alphanumeric, 10 characters | Scheduling > Courses > Course Master Info > Number | ||||||||||||||||||||||||||||||||||||||
| LEACourseTitle | The descriptive name given to a course of study offered in a school or other institution or organization. Alphanumeric, 55 characters | Scheduling > Courses > Course Master Info > Name | ||||||||||||||||||||||||||||||||||||||
| LEACourseDescription | A description of the course content and/or goals. A value is required for grades 9-12 and is options for grades PK-8. If the Description field is null, this element reports blank. Alphanumeric, 500 characters | Scheduling > Courses > Course Master Info > NCES data > Description | ||||||||||||||||||||||||||||||||||||||
| Transition Course or Module | The transition course or module is a course or equivalent method completed by a 12th grade student that does not pass an approved CCR assessment for English 11 and Algebra 2 by end of grade 11. If the SCED Course Level field is null or anything other than TRN or MOD, None reports. Numeric, 4 digits | Scheduling > Courses > Course > NCES Data > SCED Course Level | ||||||||||||||||||||||||||||||||||||||
| LEACourseCredits | The number of credits assigned to the course as defined in the LEA Course Catalog. Non-credit bearing courses like elementary classes report as 0.00. Numeric, 5 digits ##.## | Scheduling > Courses > Course Master > GPA Weight | ||||||||||||||||||||||||||||||||||||||
| CourseGradePoint AverageApplicability | An indicator of whether or not this course being described is included in the computation of the student’s Grade Point Average.
Alphanumeric, 1 character Y or N | Scheduling > Courses > Course > GPA Weight | ||||||||||||||||||||||||||||||||||||||
| CourseContentStandards | Indicates the content standards used to align course curriculum and assess whether or not students meet grade level expectations. If the Course Content Standards field is null, this element reports blank. Alphanumeric, 2 characters | Scheduling > Courses > Course Master Info > Course Content Standards | ||||||||||||||||||||||||||||||||||||||
| AssessedContentArea | Indicates that the course is associated with a state mandated assessment content area at the elementary, middle, or high school levels. Alphanumeric, 5 | Scheduling > Courses > Course Master Info > Assessed Content Area | ||||||||||||||||||||||||||||||||||||||
| HighSchoolCourse Requirement | An indication that this course credit is required for a high school diploma. Alphanumeric, 1 character Y or N | Scheduling > Courses > Course Master Info > Required | ||||||||||||||||||||||||||||||||||||||
| K12EndOfCourse Requirement | An indication that this course has an end of course examination required by the SEA or LEA. Alphanumeric, 1 character Y or N | Scheduling > Courses > Course Master Info > End of Course Requirement | ||||||||||||||||||||||||||||||||||||||
| CTEAssociatedCourse | Indicates whether the course is part of an approved program of study in Career Technology Education (CTE) and is associated with courses which have a designated CIP code. Alphanumeric, 1 character Y or N | Scheduling > Courses > Course Master Info > CIP Code | ||||||||||||||||||||||||||||||||||||||
| CourseCertification Description | A description of the certification or recognition associated with this course. If the CTEAssociatedCourse field reports Y, the first 100 characters of the Certification description reports. If the Certification field is null, None reports. Otherwise, this field reports blank. Alphanumeric, 100 character | Scheduling > Courses > Course Master Info > Certification (description only) | ||||||||||||||||||||||||||||||||||||||
| FamilyAndConsumer SciencesCourseIndicator | Identifies whether the course is associated with the Family and Consumer Sciences plan of study. If the Program Type is Family and Consumer Sciences, this field reports Y. Otherwise, N reports. Alphanumeric, 1 character Y or N | Scheduling > Courses > Course Master Info > Program Type | ||||||||||||||||||||||||||||||||||||||
| TechnologyEducation Indicator | Identifies whether the course is a General Technology Education, Advanced Technology Education, or None. The value selected in the Technology dropdown list on the Course Master reports. If no value is selected, None reports.
| Scheduling > Courses > Course Master Info >Technology | ||||||||||||||||||||||||||||||||||||||
| DeliveryType | The primary setting or medium of delivery for the course. Alphanumeric, 2 characters | Scheduling > Courses > Course Master Info > Delivery Type | ||||||||||||||||||||||||||||||||||||||
| InstructionalLanguage | The language of instruction used to teach the program or course. Alphanumeric, 3 characters | Scheduling > Courses > Course Master Info > Instructional Language | ||||||||||||||||||||||||||||||||||||||
| NationalCollegiateAthletic AssociationEligibility | An indication that the course is approved for determining NCAA eligibility. Alphanumeric, 1 character Y or N | Scheduling > Courses > Course Master Info > NCAA Eligible | ||||||||||||||||||||||||||||||||||||||
| IPEDSSchoolCodeFor InstituteOfHigherEducation | The IPEDS school code for associated institution of higher education where the college-level or dual-credit course takes place. If the IPEDS School Code is null, None reports. Numeric, 6 digits | Scheduling > Courses > Course Master Info > IPEDS School Code |
