Hierarchy Mapper allows you to automatically align courses to levels in your hierarchy, or the departments and colleges where those courses belong. Within hierarchy mapper, you can set up pairing logic that pairs courses with their specific department or college based off the identifying letters, numbers or coding of your course codes, titles, unique identifiers and, if necessary, instructor information.
Mapping Your Course Evaluations & Surveys Hierarchy
- Once you have built your hierarchy within Hierarchy Builder, navigate to Account Site Settings (section) Hierarchy Mapper.
- To map a level in your hierarchy, click on the level within the hierarchy on the left hand side of the screen.
- On the right-hand side of the screen, you will see the hierarchy level that you have selected.
- From the first dropdown menu, select the Condition you will use to map courses. Options include: Course Code, Course Title, Course Unique ID or (less typically) Instructor information.
- From the second dropdown menu, select the Operand that will be used in the mapping logic.
NOTEMost commonly used are Contains or Begins With. Use caution when using Equals as the entire course code/unique id must equal the inputted value. For example, one would map Course Code Contains/Begins with ECON or ECON5 rather than Course Code Equals ECON502_05.
- Input Value for this hierarchy level. In example below, Course Code Begins With ACC for Accounting level in hierarchy.
- Click Save.
- Mapping logic will display below for that hierarchy level. Option to click on Edit or Delete.
- Logging on the right displays a date/time stamp to show when logic was created and/or updated, by a particular user.
- Click on the next hierarchy level to create mapping logic for other levels in hierarchy.
- If needed, you can click on Export Hierarchy Mapper to download all levels of hierarchy mapping logic to an Excel spreadsheet.
Using the AND / OR in Hierarchy MapperAdditional values and conditions may be required within your hierarchy level. For instance, you may have more than one value associated with a level in your hierarchy, or you may need to narrow down the values for a particular field. You can use OR to add additional values to a level in your hierarchy, or AND to further define values for a specific level in the hierarchy.
- To add additional values for a hierarchy level using OR, click on the + Sub Condition link under the Save button when creating mapping logic.
- Input the additional value(s). To add multiple sub conditions, click on + Sub Condition again to add more values.
- Click Save.
- To add sub conditions to existing mapping logic, click Edit and then + Sub Condition.
- To further define values for a specific hierarchy level using AND, simply create a separate mapping logic for that level.
- Click Save.
- Use AND only when you need to further detail the mapping logic for a particular field with more information, such as Course Code Begins With ACC AND Course Code Does Not Contain _500. Or Course Code Contains ART AND Course Unique ID Ends with _OL.