In Full Fabric, such as in higher education, a transcript is the official school record of a student's academic activities and performance for a given class, possibly including items like courses taken, grades earned, credits received, degrees awarded, and others. With a symbiotic relationship with study plans, there are roughly three stages to managing these documents: building the templates, creating academic transcripts and then printing them. 🖨 Below we'll explain the whole process. 😃
How do I create transcript templates?
As with letters (if you're familiar with that module), all academic transcripts derive from standardized templates, which, in turn, start out as MS Word documents that you must upload onto Full Fabric. For the content of these .docx files to be correctly read, understood, and populated by the system, it must be structured in a specific way and employ merge fields.
Merge fields are placeholders for the unique student data stored in Full Fabric that you want to add to the transcripts, such as someone's final grade for a course, the names of their courses, etc. Upon generating a transcript, the merge fields are automatically substituted with the correlating data for that profile. Merge fields are inserted inside the MS Word document through Word's Mail Merge feature, after which they take their name.
Creating a transcript template via Microsoft Word
As mentioned before, transcript templates are Word documents, created either in Microsoft Word 2007 or a later version and saved with the .docx extension. Here's an example of one:
The snippets of text in guillemets (« ») are the substitution tags for the merge fields; for instance: =degree_class, =course.final_grade, =final_grade_percentage, etc. The guillemets are automatically added by Microsoft Word when you configure a substitution tag as a merge field: =degree_class then becomes «=degree_class», =course.final_grade becomes «=course.final_grade», =final_grade_percentage becomes «=final_grade_percentage», and so on.
For the sake of comparison, here's an academic transcript based on the above template:
It's up to you which substitution tags to include in the templates, making them highly customizable. Having said that, some considerations must be taken into account in terms of structure, namely when trying to retrieve lists of courses.
To zoom in on this topic, let's zoom in on the images and throw in some borders as well:
As you can see, what the borders reveal is that each list – which, in reality, are one and the same –, is actually a table. So that answers question one: how must lists of courses be formatted? You guessed it: tables! 😉 That way, the system can easily add new lines as new courses are taken throughout the program.
Question two is: how does the table at the top become the table at the bottom? By recalling Aristotle's lesson on stories: that they must have a beginning, a middle, and an end! In short, if you want a transcript to feature a list of courses, you must delimit the list so that the system can orient itself within the document and figure out not only where to place this particularly mutable block of information, but also how to contain it in place as it expands to avoid the content spilling over and breaking the formatting. Let's splash some color on the cells to clarify what this means:
Highlighted in light orange, you have the merges fields which delimit the list, not unlike property lines. Because they help you outline the boundaries of the "territory" (as a manner of speaking), they're not meant to be replaced by data and are not visible on transcripts. Essentially, they serve the same purpose as that of the quintessential white picket fence (except for fences always being, you know, visible, what with consisting of material matter and all 😅).
Finally, highlighted in light grey in the middle, you have the merge fields which produce the actual courses, whereby each column returns a different value, such as the course code, the course name, the course credits, the final grade, and more. One single row will automatically multiply itself into however many courses a student has taken, so there's no need for more.
Transcript substitution tags and how to add merge fields to Word
It's now time to take a closer look at the merge fields: what they are and how to insert them into a Word document.
Here's a list of the main substitution tags you'll need for a transcript template:
SUBSTITUTION TAGS | DESCRIPTION |
=programme.name | Shows the name of the programme. |
=course.name | Shows the Subject name. |
=course.code | Shows the Subject code. |
=course.custom_transcript_name | Shows the custom transcript name instead of the standard name (provided that, in the Course details area of the academic calendar, you picked Yes under Allow custom transcript course name – more information here). Especially useful for project-centered courses, because it allows you to display the name of each student's individual project, such as the name of a thesis. |
=curricular_grade | Shows the student's final grade for the program – in other words, the average of the marks obtained in each course, automatically calculated by the system (provided that the grade was set to be quantitative and include partials, as well as to be displayed in the transcript as an average). |
=final_grade_percentage | Same as =curricular_grade, but as a percentage (provided that the grade was set to be quantitative and include partials, as well as to be displayed in the transcript as a percentage). |
=course.final_grade | Shows the final grade for a course. |
=course.grades | Shows the final and partial grades for a course. |
=course.partial_grades | Shows all partial grades for a course, separated by a comma (,). For example: 15, 20, 12. |
=credits.total_awarded | Shows the total number of credits that the student has been awarded for the entire program. |
=credits.total_registered | Shows the total number of credits that the student registered for the entire program. |
=credits.total_required | Shows the total number of credits required for graduation for the entire program. |
courses:each(course) & =course:endEach | Combined, these two show the list of courses a student has taken, as explained and demonstrated in the previous topic. |
course.category.XYZ.courses:each(course) & course.category.XYZ.courses:endEach | A variation of the above codes incorporating the categories in the study plan to only grab courses from a given category, whereby the name of the category goes where the XYZ is. For instance, supposing you have a category named Final MBA Assessment, the resulting pair of codes would be: course.category.final_mba_assessment.courses:each(course) & course.category.final_mba_assessment.courses:endEach. |
=degree_class | Shows the Degree class that the final course grade corresponds to (for instance, Excellent, Satisfactory, Not Satisfactory, etc., as defined in the study plan). |
=degree_class_in_es-es | Same as =degree_class, but in Spanish. |
=degree_class_in_de-de | Same as =degree_class, but in German. |
=degree_class_in_fr-fr | Same as =degree_class, but in French. |
=degree_class_in_nl-nl | Same as =degree_class, but in Dutch. |
Because a transcript is fundamentally a document, letter substitution tags also apply, such as to display dates, entries from the profile Info tab, and more. Please read this article to find out more about these.
Last, but not least, to learn how to insert a merge field into a Word document, please come here.
Uploading a transcript template to Full Fabric
So you created your Word document, formatted it to look all nice and pretty, added some merge fields, and deemed it ready to go live. Fantastic! 👏 To upload a transcript template to Full Fabric, simply do as follows:
1) Click the gear at the top right-hand corner and choose General settings
2) Navigate to Documents and then to Transcript templates
3) Press the Create a new template button at the top-right corner
4) Title the template under DESCRIPTION
5) Tap Choose file to select the file to upload
6) Once all is said and done, click Create template
You'll be automatically redirected to the TEMPLATE DETAILS area, where you can determine the settings of your template. We'll discuss it below.
Accessing your school's list of transcript templates and editing an existing template
if you want to see the list of transcript templates of your school and edit one of them, it's quite easy!
1) Click the gear at the top right-hand corner and choose General settings
2) Navigate to Documents and then to Transcript templates
3) Press the gear at the end of whichever row belongs to the template you want to access
The settings of a template comprise two tabs: Details and Schema.
Let's start with Details:
About the control to Show references for courses which do not count towards final grades and credits?, it gives you the option to either hide the † and * symbols from transcripts or use them to signal final grades and credits, respectively.
The next field, Allow Students to download this transcript template?, lets you decide whether or not you want to make that particular template available for download to students. No is selected by default, but when switched to Yes, students will see a button to Download transcript on the top-right corner of their Transcripts page.
Finally, Only Include Units lets you specify which courses you want to display in the transcript by default: courses which have published grades, courses which have a final grade, courses which count towards the final grade, and/or courses which the student has passed. The same choice is also offered when printing a transcript individually.
To delete a transcript, click the X next to it in the transcript overview. This action is irreversible.
How can I print student transcripts?
When it comes to printing a student's transcript on the staff side, there's an option to do just that inside individual transcripts, namely the Download transcript button on the top-right corner:
When you click it, you're asked to choose a transcript template, which courses to include and the export format:
Nevertheless, you can also print transcripts in bulk inside the class overview of a given class. That's because, when a class progresses to the state IN PROGRESS, a new tab becomes available named Transcripts:
As the name suggests, the Transcripts tab presents a list of every profile in that class that has a transcript. The column picker (the icon with three vertical bars) lets you define which columns you wish to be visible in your list – and, by extension, your export of the list, which you may download by pressing the vertical ellipsis and then Export list to CSV or Export list to Excel. In it, you may include profile fields, journey fields, transcript fields and more; however, please note that the transcript fields don't display data for each course, but rather totals and averages.
Also accessible through the vertical ellipsis, Export all transcripts produces a ZIP file containing the actual transcripts, sent to you by email:
You're given the same customization options as when downloading an individual transcript:
How can students view and print their own transcripts?
Students have their own Transcripts area where all of their transcripts are aggregated. Browsing one's transcripts is always permitted, but transcripts can only be downloaded if the operation was antecedently authorized by staff.
If you're accessing Full Fabric via a student profile and said profile has a transcript, here's how you can view it and extract a copy:
1) Click on the profile name on the bottom left-hand corner to open the profile menu
2) Press Transcripts to find that profile's collection of transcripts, separated by tabs
3) Navigate to the appropriate tab (ergo, transcript)
4) Click Download transcript on the upper right-hand corner
5) Lastly, select a transcript template and tap Download
If no template is selected and you press Download anyway, the request will fail and return an error message: Missing default template. Please provide one or choose some template on the list.
As indicated earlier, the order that the courses are displayed replicates that of the study plan: alphabetical by subject name (from A to Z) or chronological by earliest course start date (from January to December). Sorting by subject name is the default.
The student view of a transcript doesn't necessarily have all of the same information that's on the staff view. More specifically, the transcript grade average, the transcript grade percentage and the degree class aren't displayed by default on the student view, only the final grade for each course, though they're always displayed on the staff view. It's on managerial staff to decide whether or not to share these with students. If you'd like to, drop us a line and we'll turn their visibility on.
*
You have reached the end of this article. Thanks for reading! 🤓 If you have any questions or comments on the topic at hand, or if you enjoy reads like this and have article requests, let us know. Also, please leave a rating below. Your feedback is highly appreciated! 💖
PUBLISHED: July 1, 2021
LAST UPDATED: December 15, 2021 at 6:01 p.m.