Competency Map Download

It is possible to easily enough download the Competency Mapping for any specified Program Year within your school. To do this, simply click as shown below. This is available from the Programs tab.

Expand Program Year Objectives

It is necessary to expand the Objectives as shown below in order to download the Competency Map.

Download Competency Map

After clicking as shown above, at the lower left hand corner of your browser window, you will see a file such as the following appear.

When opening it in Excel on a Mac, it initially appears as shown below (Before ...). There are many techniques that can be used to make it more presentable. You can also save it as an .xlsx or other Excel file format once the adjustments have been made.

You can view this in Finder (Apple) or Windows Explorer (WIndows) and save it to a more appropriate location of your chosing. Later, right click on it and choose to open it however you would normally open a .csv file. Excel or other text or spreadsheet applications should work.

What I recommend ...

  • Bold and customize the field names (top row)

  • Make the "mapped_course_objective" field much wider

  • Once widened, use Align text / "word wrap" on the "mapped_course_objective" field

  • Fix the top row so the file can ben scrolled.

Before ...

Before formatting the output ...

After ...

After formatting the output ...

You can sort the output however you would it sorted as well as move columns around and any other changes you may wish to perform once the file has been downloaded.

IMPORTANT NOTE: These Program Years are based on Matriculation Year so if the year selected is 17-18 for example, the mappings are probably not complete yet for the later years of these students' educational experience. This is because the mappings may have not been completed yet in Ilios for Courses, Sessions, and Offerings which are scheduled to take place in the future.