Versions Compared

Version Old Version 16 New Version Current
Changes made by

Elizabeth Storrs

Elizabeth Storrs

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Key:

Nutrition/GSBS (TUH)
TUSMGP (TUP)
Vet (TUV)
Fletcher (TUF)

  • Bold are external deliverables

  • Items in Dark grey text have been delivered

  • [brackets] identify dependencies

“Sprint” Schedule by Data Grouping Deliverable

Sprint date

Application/Person v1 (Beth)

Engagement v1 (Helen)

Schools v1 (Beth)

Programs v1

General

Completed

  • Slate queries finalized and connected to Denodo forVet, GSBS, and Nutrition.

by Thanksgiving

  • Slate queries finalized and connected to Denodo for TUSMGP and Fletcher.

  • Query/data structure draft created [Nutrition as model].

  • Sample spreadsheet of data provided to UCM.

  • feed of NUTR 2025 cycle primary undergraduate school and major

  • develop prospectus for cleaning school data

  • Start technical conversation series with Matt

  • Finalize next data priorities

  • Build out interim marketing report for Nutrition

by Christmas

  • Applicants who straddle multiple terms (defers, early admits, dual programs): Develop start conversation @ data definitions and establish standard business practices [IR]

  • Draft queries created in Fletcher, Vet, GSBS, and TUSMGP.

  • Meeting with UCM on expectations.

  • Business process guide for Slate users providing engagement data through Denodo finalized.

  • determine path for schools data quality initiative

  • feed of NUTR 2025 cycle primary undergraduate school and major

  • Initial dataset built in TUSMGP with first-priority fields

  • complete Connecting and Combining Data with Denodo course

January 2-18, 2025

  • identify all of the types of applicants who straddle multiple terms; draft standard business practices for handling/counting them

  • Query finalized and connected to Denodo for Nutrition.

  • Meet with Vet and Fletcher to understand their

  • [funding]

  • Populate data in TUSMGP

  • Demonstrate dataset to stakeholders

  • Copy dataset model to Fletcher, Vet, GSBS, and Nutrition

  • Tableau training

January 21- February 7

  • Query finalized and connected to Denodo for TUSMGP and GSBS

  • Ask stakeholders to populate their datasets.

  • Build query to send data to Denodo for TUSMGP

February 10 - March 1

  • Copy query to Fletcher, Vet, GSBS, and Nutrition

March 4 - March 21

  • Query finalized and connected to Denodo for TUSMGP, Fletcher, Vet, GSBS, and Nutrition

Data Grouping Deliverables

Data Grouping

Version/Phase

Description

Priority (1 - critical, 5 - nice to have)

Person

v1

Basic bio/demo data, record created date, Tufts EMPLID, Hubspot flag

COMPLETE

Person

v2

Most recent program of interest, lead status flags/field?

1

Person

v3

Socioeconomic indicators

2

Person

v4

Application

v1

Basic application details, SIS program codes, basic status flags, basic funnel dates

COMPLETE

Application

v2

Advanced funnel dates, advanced status flags

Engagement

v1

RMI form submission, event registration, source import

1

Engagement

v2

Engagement

v3

Schools

v1

Primary US institution attended (bachelor’s degree awarded or expected) and major

1

Schools

v2

Program Details

v1

Cycle dates, basic program details, enrollment targets

1

Program Details

v2

Application review process details

Program Details

v3

...

  1. Person

    1. Simple bio/demo data

  2. Application

    1. Simple program/app data

    2. Funnel Dates

      1. Complete Date

      2. Interview Date

    3. Invite to Interview Flag

    5. Fee waived

    6. HRSA/Socioeconomic Indicators

    7. Application review indicators

      1. GPA

    8. Decline for institution

  3. Schools

  4. Engagements

    1. Lead Form submissions

    2. UCM/Hubspot

    3. First Source

    4. Flags

      1. Submitted a form

      2. Registered for an event

      3. Contacted the school

  5. Program Dataset (Meta data about programs)

    1. Cycle dates

      1. Application Open

      2. Application Deadline

      3. Decision dates

      4. Semester Start date (race release)

      5. Fiscal Year

      6. Academic Year

      7. Enrollment targets?

    2. Program length

    3. Program launch date/term

    4. Program close date

    5. Program Application Review stuff

      1. Do they require interviews?

      2. Rolling admission?

      3. Number of required recommendations

      4. Required test scores?

      5. Definition of complete application

      6. Requirements for complete post-submission? What is collected after you submit?

    6. Fee waiver process?

    7. Application fee amount?

    8. Location

    9. Format/Modality

    10. Degree or non-degree

    11. SIS codes

    12. PF codes

    13. Tuition

    14. Scholarship?

    15. Program Staff (use for content blocks?)(use the existing user table?)

      1. Admissions Director

      2. Manager, etc.

      3. Admissions Counselor/staff

    16. Program selectivity rating

...