Link a column across classes

This is an advanced method


Besides showing your columns in different tabs in the same class , you can also link a column across classes
Open the target class, then:

- Add a new Calculation Column > Formula
- Give the header a name such as "Column from Biology" to identify it clearly.
- Tap on the Formula tag, select the class, source of the column, Biology

teachers ipad



Select the desired tab for example, 2nd Semesterand once in it, select the desired column.
Make sure that the Grade type is the same as in the source column, if you like to have the same values in both columns

In our example we will copy the column Test 1 from Biology Sample 101 > 1st Semester to 11gD3 > 1stQ

See below the detailed procedure.

teachers ipad



Here is the linked column from Biology 101 class

teachers ipad



Once the column is linked in the new Class , any grade value changed in a cell of the source column is also reflected in the cell of the linked column



Link non-numeric grades across classes

If the linked column has its source in a non-numeric grade, Project 1 in our example, some small differences apply.
The procedure is the same as shown before, but the formula has no Integer function applied , and the second difference is that the result is not exactly what we expected.

See below those differences:

teachers ipad



Two more steps are needed to have the non numerical grading column ready.
- Create a new Calculation > Addition - Total points grading column, select Simple Addition and click on the Project 1 Header, save the configuration.
- Tap and hold on the new columns header, select edit , change the Grade type Result to Text grades A to F , save and this is it.
The animation below shows these final steps :

teachers ipad



And here is the Text grade column linked to the Biology class

teachers ipad gradebook



Related articles

Show the same column in different tabs (linked column)