In Tableau, when using Cohort Data via the Student Count measure can I obtain the actual number of students who submitted their SATs, ACTs and HS GPA from the fields provided. I can get their average SAT, ACT and HS GPA scores, but I also want/need to know how many student in the cohort submitted these scores. When I look at any of the SAT (ACT or HG GPA) measures and change the average default to count or sum the numbers are different from what I have in our IR data base. Thanks.

Right now, [Registration Status Current] shows the latest registration status, including for graduated students and students who have dropped.  How do I identify students who are registered or enrolled for only this current term?  How do I ignore graduated and dropped students?  If I try to filter using the Term Set - Term Code then I cannot see the history of the student.  How do I the history of the current students?

Can Application Term code and Applicant Type be added to SAH?  It is currently in the Provost model.

thanks, Natalie Noles

Can we add a commuter status flag (or y/n field) that indicates if they have an active contract with HDH for housing so that we know people who live on campus? I've provided a query from the Housing DB to Russia in the past and I believe Sabrina Wong is the data owner from HDH.

Class Is Scheduled As Cross Listed Flag = A Yes/No flag indicating if the class has been scheduled to be cross listed for the term.

Course Is Cross List Approved Flag = A Yes/No flag indicating if the class has been approved to be cross listed for the term

See IGC Workgroup at https://collab.ucsd.edu/display/SAH/Logic+for+Cross+Listed

IR Uses this information regularly in their reporting. 

Hi Sarah,

I ran across this term in reviewing UCUES data: New Generation (New Gen): Students who are first generation, Pell recipients, and/or from underrepresented groups (African American, American Indian, Hispanic/Latino(a)).

https://www.universityofcalifornia.edu/infocenter/ucues-data-tables-main

If it's not already there, proposing this for inclusion as a data point in SAH and as a term in the data dictionary. It seems to be integral to the UCUES Longitudinal Analysis, which would indicate that local campus analysts are likely to be asked for data related to this population. (See: https://www.universityofcalifornia.edu/infocenter/ucues-longitudinal, "Responses by New Gen and Year at UC."

Thank you,

Natalie

Natalie Noles

Instructional Analyst

T: (858) 534-2574 | E: nnoles@ucsd.edu

When does a course get added to this view?  When the course gets senate approved?  When a student enrolls?  When grades are entered?  

What are the possible values for Activity_Type_Code, similar to what's defined for Research?

Use case examples: user login/logout from applications, check in to recreation facilities, attend college events