How to put a College Reading Workflow into Tana

A practical way to manage college reading and coursework in Tana hinges on modeling everything as connected records—concentrations → classes → assignments, plus a separate book list—then using saved queries to keep each view automatically updated. Instead of manually tracking deadlines and reading lists, the workflow builds tables that filter themselves based on relationships between items, so “Psychology 101” can instantly show only its relevant classes, assignments, and readings.

The setup starts from a clean workspace and defines a “Concentrations” table. Each concentration gets an “advisor” field implemented as an instance of a “Professor” tag, allowing multiple professors to be linked to different concentrations. With concentrations stored as tagged items, a query can render a table of concentrations and advisors. This table becomes a navigational anchor in the sidebar, so the user always lands on the same structured overview.

Next comes “Classes,” organized under each concentration. Each class record includes fields like professor, required/recommended reading relationships, semester (using fixed options such as 2020 Spring, 2021 Fall, etc.), hours, and grade (as a number). The key modeling move is linking each class back to its concentration via an instance reference. That relationship enables filtered queries: the “Classes” table can be configured to show only classes belonging to a selected concentration (for example, only the writing-related courses under a specific concentration), rather than a complete list of every class ever created.

Assignments sit one level deeper. Each assignment is linked to a class through an instance-of-class field, and includes a due date plus a “complete” checkbox. Once assignments are connected to classes, a query can generate a “Course assignments” table that dynamically updates as new assignments are added. The workflow also supports quick filtering—such as showing only incomplete assignments (complete is not checked) or only completed ones—so the workload view stays focused.

Finally, the reading workflow uses a “Books” table built around tags and structured metadata. Each book includes a reading status (fixed options like “to read,” “finished,” and whether it’s required or recommended), author (as an author instance), genres, book format, and publication date. Books are then pulled into a “Book list” view via a query that selects all book items. Because the reading status and metadata are standardized fields, the list can be narrowed further with additional search filters.

Throughout, the workflow’s power comes from light modeling: once relationships are set correctly (concentration → class → assignment, and books as tagged records), Tana’s saved tables act like live dashboards. The result is a college system where selecting a concentration automatically surfaces the right classes, deadlines, and reading materials—without re-entering the same information in multiple places.