# Course Profile

* [Interactive Mart Dependency Diagram](#taskforcemartcourseprofile-interactivemartdependencydiagram)
* [Schema](#taskforcemartcourseprofile-schema)
* [Field Structure and Subcategories](#taskforcemartcourseprofile-fieldstructureandsubcategories)
  * [Course - Static Metadata](#taskforcemartcourseprofile-course-staticmetadata)
  * [Course - Dynamic Metadata](#taskforcemartcourseprofile-course-dynamicmetadata)

The *mart\_taskforce.course\_profile* mart aggregates helpful metadata about course sections and offerings in academic terms.

## **BQ Prod Dataset Locations**

* mart\_taskforce

## Interactive Mart Dependency Diagram <a href="#taskforcemartcourseprofile-interactivemartdependencydiagram" id="taskforcemartcourseprofile-interactivemartdependencydiagram"></a>

The following visualization shows the construction of this data mart defined in the [UDP marts](https://gitlab.com/unizin-community/unizin-data-platform/marts) repository. More information on the repository and diagram can be found on [this marts page.](https://resources.unizin.org/products/data-and-analytics/unizin-data-platform/data-stores/data-marts)

{% hint style="info" %}
[Click here to open the interactive chart.](https://assets.public.unizin.org/udp-marts/mart/mart__taskforce__course_profile.svg)
{% endhint %}

<div data-full-width="true"><figure><img src="https://3709019308-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FKYwtHNGgdPXS3PWAlZUr%2Fuploads%2Fgit-blob-c237ee7ccf7a5a0262560a5208b3c2eac7178c3b%2Fcourse_profile.png?alt=media&#x26;token=6255f0c8-2064-4ed5-8f01-d0333bc81208" alt=""><figcaption><p>mart_taskforce.course_profile</p></figcaption></figure></div>

## Schema <a href="#taskforcemartcourseprofile-schema" id="taskforcemartcourseprofile-schema"></a>

### **mart/taskforce/course\_profile**

<table data-full-width="true"><thead><tr><th width="287.33333333333337">Field Name</th><th width="116">Type</th><th>Description</th></tr></thead><tbody><tr><td>course_section_id</td><td>INTEGER</td><td>The UDP ID of the course section.</td></tr><tr><td>course_offering_id</td><td>INTEGER</td><td>The UDP ID of the course offering.</td></tr><tr><td>academic_term_id</td><td>INTEGER</td><td>The UDP ID of the academic term.</td></tr><tr><td>course_title</td><td>STRING</td><td>The title of the course offering.</td></tr><tr><td>course_subject</td><td>STRING</td><td>The alphabetic abbreviation of the academic department or discipline offering the course. It is one part of the total course ID number. E.g., "BIO" in "BIO 101.”</td></tr><tr><td>course_number</td><td>STRING</td><td>The official reference number portion of a course ID. This number typically designates the level of the course as well as the level of the individual expected to enroll in the course. E.g. "101" in "BIO 101." This is sometimes called the catalog number.</td></tr><tr><td>course_code</td><td>STRING</td><td>The concatenation of course_subject and course_number.</td></tr><tr><td>course_start_date</td><td>DATE</td><td>The date when the course begins.</td></tr><tr><td>course_end_date</td><td>DATE</td><td>The date when the course ends.</td></tr><tr><td>available_credits</td><td>NUMERIC</td><td>Measured in Carnegie units, the amount of credit available to a student who successfully meets the objectives of the Course Offering.</td></tr><tr><td>delivery_mode</td><td>STRING</td><td>The delivery mode for the instruction given in this Course Section. (<a href="https://docs.udp.unizin.org/tables/ref_course_section_delivery_mode.html">option set</a>)</td></tr><tr><td>is_graded</td><td>INTEGER</td><td>Indicates whether the Course section is the graded Course section, if multiple Course sections are available to the student for this Course offering.</td></tr><tr><td>is_honors</td><td>INTEGER</td><td>Indicates whether the Course section is considered an honors Course section.</td></tr><tr><td>max_enrollment</td><td>INTEGER</td><td>Maximum number of students who can be enrolled in the Course Section.</td></tr><tr><td>course_type</td><td>STRING</td><td>The type of instruction delivered in this section. Institutions may refer to a section type as a "component" of a Course offering. (<a href="https://docs.udp.unizin.org/tables/ref_course_section_type.html">option set</a>)</td></tr><tr><td>term_name</td><td>STRING</td><td>The human-readable name for the academic term.</td></tr><tr><td>term_type</td><td>STRING</td><td>The type of Academic term. (<a href="https://docs.udp.unizin.org/tables/ref_term_type.html">option set</a>)</td></tr><tr><td>term_begin_date</td><td>DATE</td><td>The beginning date of the term.</td></tr><tr><td>term_end_date</td><td>DATE</td><td>The ending date of the term.</td></tr><tr><td>program_name</td><td>STRING</td><td>The human-readable name of the Academic organization, governed by a corresponding academic organization code (e.g., “CAS” for “College of Arts &#x26; Sciences”).</td></tr><tr><td>academic_career_name</td><td>STRING</td><td>The description of the Academic career at the Institution.</td></tr><tr><td>instructor_name_array</td><td>STRING</td><td>An array of all the instructors’ names for the Course offering, written as a comma-separated string.</td></tr><tr><td>num_instructors</td><td>INTEGER</td><td>The number of distinct names in instructor_name_array.</td></tr><tr><td>num_students</td><td>INTEGER</td><td>The number of students enrolled in the course.</td></tr><tr><td>num_published_assignments</td><td>INTEGER</td><td>Based on the course's view in the LMS, the total number of published learner activities (quizzes, assignments, surveys, etc.).</td></tr><tr><td>num_unpublished_assignments</td><td>INTEGER</td><td>Based on the course's view in the LMS, the total number of unpublished learner activities (quizzes, assignments, surveys, etc.).</td></tr><tr><td>avg_assignment_score</td><td>FLOAT</td><td>Based on the current grade book status, this is the average of all assignment scores for assignments marked as graded.</td></tr><tr><td>num_active_modules</td><td>INTEGER</td><td>The total number of active modules in the course's LMS.</td></tr><tr><td>num_unpublished_modules</td><td>INTEGER</td><td>The total number of unpublished modules in the course's LMS.</td></tr><tr><td>num_published_quizzes</td><td>INTEGER</td><td>Based on the course's view in the LMS, the total number of published learner quizzes.</td></tr><tr><td>num_unpublished_quizzes</td><td>INTEGER</td><td>Based on the course's view in the LMS, the total number of unpublished learner quizzes.</td></tr><tr><td>avg_quiz_score</td><td>FLOAT</td><td>Based on the current grade book status, this is the average of all quiz scores for quizzes marked as graded.</td></tr><tr><td>num_active_discussions</td><td>INTEGER</td><td>The total number of active discussion topics in the course.</td></tr><tr><td>num_unpublished_discussions</td><td>INTEGER</td><td>The total number of unpublished discussion topics in the course.</td></tr></tbody></table>

## Field Structure and Subcategories <a href="#taskforcemartcourseprofile-fieldstructureandsubcategories" id="taskforcemartcourseprofile-fieldstructureandsubcategories"></a>

This mart focuses both on courses, terms, and average scores/behaviors:

* Course
  * Static Metadata
    * course\_title
    * course\_subject
    * course\_number
    * course\_code
    * course\_start\_date
    * course\_end\_date
    * available\_credits
    * delivery\_mode
    * is\_graded
    * is\_honors
    * max\_enrollment
    * course\_type
    * program\_name
    * academic\_career\_name
    * instructor\_name\_array
    * num\_instructors
  * Dynamic Metadata
    * num\_students
    * num\_published\_assignments
    * num\_unpublished\_assignments
    * avg\_assignment\_score
    * num\_active\_modules
    * num\_unpublished\_modules
    * num\_published\_quizzes
    * num\_unpublished\_quizzes
    * avg\_quiz\_score
    * num\_active\_discussions
    * num\_unpublished\_discussions
* Terms
  * term\_name
  * term\_type
  * term\_begin\_date
  * term\_end\_date

### Course - Static Metadata <a href="#taskforcemartcourseprofile-course-staticmetadata" id="taskforcemartcourseprofile-course-staticmetadata"></a>

These fields describe course attributes that we don't expect to change. Once these values are set in the LMS or SIS, they should remain the same for the entirety of the term.

### Course - Dynamic Metadata <a href="#taskforcemartcourseprofile-course-dynamicmetadata" id="taskforcemartcourseprofile-course-dynamicmetadata"></a>

These fields are tied to the status of course assets and student submissions. For example, num\_students may update as students either enroll or drop courses. Also, avg\_assignment\_score and avg\_quiz\_score will update as students' submissions are graded and updated in the LMS grade book.

\\