Do you use a tracking spreadsheet to follow the number of hours your work on different language learning related activity?
if you do, I'd appreciate if you would share a sample or image of it here. I'm just starting a new one and I'm curious about how others go about it, I don't want to overdo mine and render it too complicated.
Thanks in advance.
Tracking spreadsheets?
- zenmonkey
- Black Belt - 2nd Dan
- Posts: 2528
- Joined: Sun Jul 26, 2015 7:21 pm
- Location: California, Germany and France
- Languages: Spanish, English, French trilingual - German (B2/C1) on/off study: Persian, Hebrew, Tibetan, Setswana.
Some knowledge of Italian, Portuguese, Ladino, Yiddish ...
Want to tackle Tzotzil, Nahuatl - Language Log: viewtopic.php?f=15&t=859
- x 7032
- Contact:
- jeff_lindqvist
- Black Belt - 3rd Dan
- Posts: 3167
- Joined: Sun Aug 16, 2015 9:52 pm
- Languages: sv, en
de, es
ga, eo
---
fi, yue, ro, tp, cy, kw, pt, sk - Language Log: viewtopic.php?f=15&t=2773
- x 10596
Re: Tracking spreadsheets?
I've stuck to the one which Professor Arguelles uploaded many years ago:
Sample study chart (xls)
Every row is a language with columns for the activities:
Use one tab/sheet per year if you want to compare stats. The spreadsheet calculates average minutes per day etc. according to activity and language family.
Sample study chart (xls)
Every row is a language with columns for the activities:
- scriptorium
- narrative (which I split into listening and reading separately)
- analysis (any kind of work which doesn't fit the other categories, but typically grammar exercises, regular "lessons" etc.)
- shadowing
Use one tab/sheet per year if you want to compare stats. The spreadsheet calculates average minutes per day etc. according to activity and language family.
8 x
Leabhair/Greannáin léite as Gaeilge:
Ar an seastán oíche:Oileán an Órchiste
Duolingo - finished trees: sp/ga/de/fr/pt/it
Finnish with extra pain :
Llorg Blog - Wiki - Discord
Ar an seastán oíche:
Duolingo - finished trees: sp/ga/de/fr/pt/it
Finnish with extra pain :
Llorg Blog - Wiki - Discord
-
- Green Belt
- Posts: 379
- Joined: Sun Dec 20, 2015 9:59 pm
- Location: Sweden
- Languages: -
- x 920
- Contact:
Re: Tracking spreadsheets?
I've tried to use Toggl in the past but found it difficult to measure time because I jump between tasks. Now I only keep track of minutes watched and LWT automatically keeps track of new words translated when reading.
date/title/minutes/language/subtitles
date/title/minutes/language/subtitles
1 x
- SophiaMerlin_II
- Orange Belt
- Posts: 248
- Joined: Wed May 25, 2016 6:35 pm
- Location: USA
- Languages: English (N), Portuguese (0)
- x 433
Re: Tracking spreadsheets?
I do my spreadsheets by hand
One is for a long TV series I'm watching (366 episodes)
Date - Comments - Start ep # - End ep # - Today's hours - Total Hours
The other is just a simple reading log -- it's doesn't actually track time spent, but rather extensive style reading.
Date - Title - Start page - End page - Pages read
One is for a long TV series I'm watching (366 episodes)
Date - Comments - Start ep # - End ep # - Today's hours - Total Hours
The other is just a simple reading log -- it's doesn't actually track time spent, but rather extensive style reading.
Date - Title - Start page - End page - Pages read
4 x
Please ignore my English, elsewise be kind!
- Xenops
- Brown Belt
- Posts: 1451
- Joined: Mon Nov 30, 2015 10:33 pm
- Location: Boston
- Languages: English (N), Danish (A2), Japanese (rusty), Nansha (constructing)
On break: Japanese (approx. N4), Norwegian (A2) - Language Log: https://forum.language-learners.org/vie ... 15&t=16797
- x 3583
- Contact:
Re: Tracking spreadsheets?
The entire purpose of keeping them was for bragging purposes. I've dropped the use of them because then I would give myself unnecessary stress: "Oh no! I've only done 30 minutes today! Oh no, I didn't look at the clock when I started/finished the activity! Oh noes!"
9 x
Check out my comic at: https://atannan.com/
- zenmonkey
- Black Belt - 2nd Dan
- Posts: 2528
- Joined: Sun Jul 26, 2015 7:21 pm
- Location: California, Germany and France
- Languages: Spanish, English, French trilingual - German (B2/C1) on/off study: Persian, Hebrew, Tibetan, Setswana.
Some knowledge of Italian, Portuguese, Ladino, Yiddish ...
Want to tackle Tzotzil, Nahuatl - Language Log: viewtopic.php?f=15&t=859
- x 7032
- Contact:
Re: Tracking spreadsheets?
Xenops wrote:
The entire purpose of keeping them was for bragging purposes. I've dropped the use of them because then I would give myself unnecessary stress: "Oh no! I've only done 30 minutes today! Oh no, I didn't look at the clock when I started/finished the activity! Oh noes!"
Definitely one of my concerns - or doing it just for time but not quality.
But I think I want to identify a little what tools I'm using and why and I'm going to give it a run. If I find myself stressing from it, I'll drop it again.
4 x
I am a leaf on the wind, watch how I soar
- Ani
- Brown Belt
- Posts: 1433
- Joined: Mon Mar 14, 2016 8:58 am
- Location: Alaska
- Languages: English (N), speaks French, Russian & Icelandic (beginner)
- x 3842
- Contact:
Re: Tracking spreadsheets?
I really like the xp navi from Japanese A Level Up. You can use it for any language. It might be different from what you are looking for because it is a fully programed sheet that calculates your language level as you go along. I haven't used it in a while but it is super fun. I can't post pictures from my phone, but I can later if there is interest and I am pretty sure there are good pictures on the JALUP site.
1 x
But there's no sense crying over every mistake. You just keep on trying till you run out of cake.
- mjfleck2000
- White Belt
- Posts: 41
- Joined: Thu Jul 23, 2015 8:07 pm
- Location: Vancouver, WA, USA
- Languages: EN (N), ES (C1), Irish(beginner)
- x 105
Re: Tracking spreadsheets?
Last year I read a comment by Cavesa here in the Language Forum... she stated somthing about how many hours it took her to reach C2 level in French and how you almost couldn't help but reach C2 after one to two Super Challenges... or words to that effect. I decided to start a spreadsheet to track my hours of study.
I have a "Total" tab that is a summary of each individual tab that records specific tasks.
I have a "Total" tab that is a summary of each individual tab that records specific tasks.
You do not have the required permissions to view the files attached to this post.
6 x
Mike in Vancouver
- Carmody
- Black Belt - 1st Dan
- Posts: 1749
- Joined: Fri Jan 01, 2016 4:00 am
- Location: NYC, NY
- Languages: English (N)
French (B1) - Language Log: http://tinyurl.com/zot7wrs
- x 3408
Re: Tracking spreadsheets?
Yes! I "use a tracking spreadsheet to follow the number of hours." I think Spreadsheets are fantastic! They help me to quantify what time I have spent and not spent in studying my French.
So, in addition to quantifying hours spent and how they were spent, I also have in my Excel file separate spread sheet tabs for:
Advbs, Preps, Conjuncs
Books: Title, Date Read, No. of Pages
Farvorite Words
Faux Amis
Phrases
Methodology: (Tracking how I change my learning methods over time. It slowly evolves over time.)
Milestones!: (Obviously Very Important)
Salutations:
Synonyms
Timing
Weather
Vocab: (General Catch all.)
For me it is all about being able to call up what I need when I need it. It is also very important for me to track what it is I have actually done vs. what I think I might have done. Of course, honesty is absolutely necessary for the build'g blocks for the hours spent. But each hour helps. Like waiting for my wife in the MD office today, I was able to log One Hour reading my French book; so that will go on the spreadsheet in the Timing Tab that will show how much time and how it was spent.
I find for me that it is tremendously gratifying to be able to look back and see what I have accomplished over time.
Each person has their own methodology for language learning and for me this really works!
So, in addition to quantifying hours spent and how they were spent, I also have in my Excel file separate spread sheet tabs for:
Advbs, Preps, Conjuncs
Books: Title, Date Read, No. of Pages
Farvorite Words
Faux Amis
Phrases
Methodology: (Tracking how I change my learning methods over time. It slowly evolves over time.)
Milestones!: (Obviously Very Important)
Salutations:
Synonyms
Timing
Weather
Vocab: (General Catch all.)
For me it is all about being able to call up what I need when I need it. It is also very important for me to track what it is I have actually done vs. what I think I might have done. Of course, honesty is absolutely necessary for the build'g blocks for the hours spent. But each hour helps. Like waiting for my wife in the MD office today, I was able to log One Hour reading my French book; so that will go on the spreadsheet in the Timing Tab that will show how much time and how it was spent.
I find for me that it is tremendously gratifying to be able to look back and see what I have accomplished over time.
Each person has their own methodology for language learning and for me this really works!
5 x
- coldrainwater
- Blue Belt
- Posts: 689
- Joined: Sun Jan 01, 2017 4:53 am
- Location: Magnolia, TX
- Languages: EN(N), ES(rusty), DE(), FR(studies)
- Language Log: https://forum.language-learners.org/vie ... =15&t=7636
- x 2398
When I track, I keep it simple. Two columns. One for the activity and another for the minutes spent.
I'll have the date auto-populate in a third column (that I might not even make visible). If using a spreadsheet application, when I wish to visual the data, I might make something like mjfleck2000 posted. Static metrics might just as well stay in a separate tab recorded once. It is trivial to shore up the data into major categories (Noticias Oír, Libros, Amigo, etc), and slap a pivot on it anytime visualization is needed. That also gives high flexibility should visualization needs change and high portability in case you want to move the data to and fro.
The critical part for me is that I typically only need to track a few weeks or a month at a time. Once I note the patterns developing, I often stop if further data recording isn't yielding new insight.
I'll have the date auto-populate in a third column (that I might not even make visible). If using a spreadsheet application, when I wish to visual the data, I might make something like mjfleck2000 posted. Static metrics might just as well stay in a separate tab recorded once. It is trivial to shore up the data into major categories (Noticias Oír, Libros, Amigo, etc), and slap a pivot on it anytime visualization is needed. That also gives high flexibility should visualization needs change and high portability in case you want to move the data to and fro.
The critical part for me is that I typically only need to track a few weeks or a month at a time. Once I note the patterns developing, I often stop if further data recording isn't yielding new insight.
3 x
Return to “Practical Questions and Advice”
Who is online
Users browsing this forum: No registered users and 2 guests