You can create and manage categories in ExamSoft, but you might find it more convenient to create your complete category structure in an Excel file and then import it into ExamSoft.
Procedures
Create the Excel File
Use a template to ensure that your file has the right structure, and then enter your categories and sub-categories.
- To download the template, select this link: Category Import Template.xlsx
- Open the file in Excel.
- Replace the sample text with the names of your category types, categories, sub-categories, and so on.
Important: Complete only one cell in each row. Add and delete rows, if needed.
Notes:- Column A is for category type. In the example below, we entered our first category type, National Standards, in Row 1, Column A.
- Column B is for the categories within the above category type. In the example, we entered a category, Communication, in Row 2, Column B.
- Column C is for sub-categories within the above category. In the example, we entered two sub-categories. Proposal Writing is in Row 3, Column C, and Formal Presentations is in Row 4, Column C.
- Column D can be used for the sub-sub-categories within the above sub-category. In the example, we didn't enter any sub-sub-categories, so Column D is not shown.
- Next, we needed a second category type. Column A is for category types, so we entered Critical Thinking in Row 5, Column A.
- We also needed a category below that. Column Bis for categories, so we entered Cause-Effect Analysis in Row 6, Column B.
- When you're finished building your category tree, save the file as XLS or XLSX.
Example
Note: Do not enter a header row in your file. This table includes the column labels only to help you to interpret the example.
| Column A (category type) |
Column B (category) |
Column C (sub-category) |
|
| Row 1 | National Standards | ||
| Row 2 | Communication | ||
| Row 3 | Proposal Writing | ||
| Row 4 | Formal Presentations | ||
| Row 5 | Critical Thinking | ||
| Row 6 | Cause-Effect Analysis |
Import Your Category File
- Log in to your institution's ExamSoft portal.
- Select the Admin menu (near the top right corner of the page).
- Select Category Management.
- Select Import (near the top right corner of the page). You can drag and drop your file or select Browse to find the file on your computer.
Your file will be processed and imported. A confirmation message will appear near the top right corner of the screen.