Study tracker chart from a Notion database
A study log with one row per session: the course, the date, the hours, and a score when the session was a quiz or an exam. Three charts answer what a student actually asks: am I putting the hours in, where do they go, and is it paying off.
Free for 5 charts · no card · no expiry
Hours per week
Free planHours by course
Free planAverage score by course
Free planThe data behind it
The first 10 of 48 rows of Sample · Study tracker. Every chart above is built from these columns and nothing else.
| session | course | date | hours | score | type |
|---|---|---|---|---|---|
| Session 1 | Statistics | 2026-02-02 | 1 | Study | |
| Session 2 | Biology | 2026-02-03 | 3 | Study | |
| Session 3 | History | 2026-02-04 | 1.5 | Study | |
| Session 4 | Spanish | 2026-02-05 | 2.5 | Study | |
| Session 5 | Statistics | 2026-02-06 | 2.5 | 93 | Quiz |
| Session 6 | Biology | 2026-02-07 | 2 | Study | |
| Session 7 | History | 2026-02-09 | 3 | Study | |
| Session 8 | Spanish | 2026-02-10 | 1.5 | Study | |
| Session 9 | Statistics | 2026-02-11 | 1.5 | Study | |
| Session 10 | Biology | 2026-02-12 | 1 | 79 | Exam |
How to build this in Notion
- Log one row per session. Each row is one sitting. Add a select property for the course, a date property for the day, a number property for the hours, a number property for the score, and a select property for the type with the options Study, Quiz and Exam. Leave the score empty on a study session.
- Connect the log. Create an account, open Data sources and connect Notion, then share the study database on Notion's screen. ChartOmodo reads the rows and never writes to them.
- Chart hours per week. Pick Bar, set X-axis (category) to the date, Y-axis (value) to hours with Sum, and Date grouping to Week. One bar per week of the term.
- Split the hours by course. Make a second chart with Pie, the course on the X-axis and the same Sum of hours. The slice sizes are the share of your time each course gets.
- Average the scores, then embed. For the third chart pick Bar, put the course on the X-axis, the score on the Y-axis with Average, and add a filter: type is not Study. Copy each embed link and paste it into your study page with /embed.
Hours and scores sit in the same rows, so all three charts read one database: log a session once and every chart that uses it counts it.