31:T63a,# 🗄️ Data Collection The data is overly simplified, but what can you do? After looking for time-tracking apps, I ended up decided on good 'ol google sheets due to the flexibility and ability to make it an API endpoint should I ever want to make a language learning dashboard. On this page I go over the specifics of my language learning activities. I only tracked *active*¹ time in German and Japanese. I didn't include anytime spent in French, and consequently my French time became limited to conversation with my francophone buddies because it didn't 'count' toward anything. I realised later on this was a mistake, but I had already started and had data collection fatigue, so I didn't change it. *Active* means the activity fully has my attention, no easy task given that I have ADHD. I don't count when I listen to podcasts while cooking, cleaning, making coffee etc. I unfortunately hopped from one activity to another and wasted a lot of time looking for material. I attempted to 'plan' my material - some platforms make that relatively easy, such as curating playlists on youtube. If I don't know exactly what I want to watch, I go to my youtube playlist and pick something from my German documentary list, for example. I ended up accumulating a lot of books and starting and stopping most of them. This is just a problem I have in general - there's too much content out there and since I won't have time to read it all, I want to read what is best for me in the moment....and boils down to a lot of FOMO. 32:T1ac8,Reading and listening. **Listening**: Watching movies, shows, youtube videos, listening to podcasts.
**Reading**: Reading books and articles.

${await FileAttachment('listening.png').image({width: iconWidth+30})} ### ━ Listening ━ | ${await FileAttachment('podcast.png').image({width: iconWidth})}| ${await FileAttachment('videos.png').image({width: iconWidth})} | | ---------------- | ----------------| | **Podasts** | **Videos** | |**German:** [Easy German](https://www.easygerman.org/podcast)(Conversation), [Quarks Daily](https://www.quarks.de/podcast/dailyquarks/)(Science), [Explore - Der National Geographic Podcast](https://open.spotify.com/show/2DVz3Bok3JzRtF4tbHZF0n?si=2503eca8c85141bd)(Culture), [OHNE DEN HYPE](https://open.spotify.com/show/6eCLHnuTL70JJgzz0Wg6JX?si=9a5090f3d7ee423a)(Design Interviews), [Die Märchen Podcast. Dein Einschlafpodast](https://open.spotify.com/show/36a2VZc2afkrJHDWQJUdBM?si=8e3cbbed33f54e06)(Meditation/Fairy Tales)| **German**: [MrWissen2Go](https://www.youtube.com/user/mrwissen2go)(Explainer), [Alicia Jones](https://www.youtube.com/@AliciaJoe)(Society), [maiLab](https://www.youtube.com/@maiLab)(Science), [ATLAS](https://www.youtube.com/@atlas_funk)(Explainer), [Dinge Erklärt](https://www.youtube.com/@KurzgesagtDE)(Explainer) | | **Japanese:** [The Miku Real Japanese Podcast](https://www.mikurealjapanese.com/)(vblog), [The Real Japanese Podcast](https://www.haru-no-nihongo.com/podcast)(vblog), [Thinking in Japanese Podcast](https://open.spotify.com/show/0lBMf4PEpcG7W44lG6ORKR)(Japanese & Studying Building), [The Bite Sized Japanese Podcast](https://www.youtube.com/@the_bitesize_japanese_podcast)(Japanese & Studying Building), [Japanese with Noriko](https://www.japanesewithnoriko.com/)(vblog)| **Japanese:** [あかな日本語教室](https://www.youtube.com/@Akane-JapaneseClass)(vblog), [Comprehensible Japanese](https://www.youtube.com/@ComprehensibleJapanese)(Culture), [Nakaji Koji Fermentation](https://www.youtube.com/@nakajikojifermentation)(Fermentation), [Hakko Department](https://www.youtube.com/@hakko_d)(Fermentation), [一人前食堂](https://www.youtube.com/@mai_ichininmae)(Cooking), [hokuoh kurashi no douguten](https://www.youtube.com/@hokuoh_kurashi)(interviews) | ${await FileAttachment('meditation.png').image({width: iconWidth})}| ${await FileAttachment('yoga.png').image({width: iconWidth})} | | ---------------- | ----------------| | **Meditation** | **Yoga** | | [7 Mind App](https://www.7mind.de/krankenkasse?sadid=SAD-ID-Foolhardy-Tempting-Superficial-Viceroybutterfly&utm_source=google&utm_medium=cpc&utm_campaign=AW_NU_DE_CPA_7mindApp_de_Search_ABSM-DSA_AG064&utm_term&gclid=Cj0KCQiA_bieBhDSARIsADU4zLcoFIKT6X3PYCJLYGSvXd6FJkXoc2UjcIcBTBRYLjRLC6jLmvWI0uUaAqgMEALw_wcB) | [Mady Morrison](https://www.youtube.com/@madymorrison) |
${await FileAttachment('reading.png').image({width: iconWidth+30})} ### ━ Reading ━ #### Intensive vs. extensive I usually have two types of material: intensive (challenging) and extensive (at my level). **Extensive:** Minimal look-ups. Also called 'freeflow', the purpose is to read or watch something that is more or less at your level so that you can understand what is going on without looking up unknown words. Useful for: - Grasping the meaning of unknown words naturally through context. - Drilling in everything you learned from intensive activities and getting a dense amount of information and repetition of vocabulary in a short amount of time.
**Intensive:** Stopping when you don't understand something and looking up words that you can add to your flashcard deck. Useful for: - Working on harder passages - Learning new grammar points and vocabulary ___________ ## Output Speaking and writing. **Speaking**: Conversations, Monologues, Chorusing, Shadowing
**Writing**: Writing messages, free-flow "journaling", summarising articles/videos

${await FileAttachment('speaking.png').image({width: iconWidth+30})} ### ━ Speaking ━ | ${await FileAttachment('chorusing.png').image({width: iconWidth})}| ${await FileAttachment('shadowing.png').image({width: iconWidth})} | | ---------------- | ----------------| | **Chorusing** | **Shadowing** | |Extracting an audio snippet of the TL (target language) and repeating segments over and over until you are happy with the result or bored in order to _refine your accent and grammar._ | Repeating every word possible from an audio snippet (such as a podcast) without pausing in order to increase _speaking fluidity, intonation, and the language's melody._ | | ${await FileAttachment('monologue.png').image({width: iconWidth})}| ${await FileAttachment('shadowing.png').image({width: iconWidth})} | | ---------------- | ----------------| | **Monologue** | **Conversation** | | Recording yourself for 5-10 minutes, and listening to your recording while correcting where you can and looking-up words you don't know in order to _develop more fluid spoken abilities._ | Talking to real-life native speakers! |
${await FileAttachment('writing.png').image({width: iconWidth+30})} ### ━ Writing ━ | ${await FileAttachment('journaling.png').image({width: iconWidth})}| ${await FileAttachment('shadowing.png').image({width: iconWidth})} | |-------------| -----| | **Journaling** | **Article Summary** | | Free-flow writing. | Reading an article/book chapter or watch a documentary and write a summary of it. | 33:T4ba,#### Data collection problems All data is biased and has uncertainties. This data collection is no different. The biggest discrepancy comes from what I call *language exposure density*: the amount of your TL (target language) that you are exposed to varies depending on the media you're using. For example, podcasts are _language-dense_, since there are few pauses in dialogues. Movies, however, can have minimal dialogue. 'Listening' to a two-hour movie is therefore much different than listening to two-hours worth of podcasts. I listen to a lot more podcasts than movies or shows, but I don't obsess over the time tracking and only count the amount of time a movie has dialogue. If I notice it had quite a lot of pauses, I might reduce the total listening time. When I am 'counting' a movie or show as immersion time, I make sure to watch something that is dense in speech. Another incongruity is from dual audio-reading. Earlier on the in the data collection phase, I was watching movies with subtitles in Japanese and counting that toward 'listening.' In retrospect, this should've been qualified as 'reading,' because my attention is mostly focused on the text rather than the oral qualities of my TL. 34:[{"id":"125f7a2f0b1ebcb0c59c7015798de01b5fbf52145190a3f4bb4441091e63f8410c4106e8980ceae89015d1910d7888c8baa3e158c26ad4e98f5c02416943b40e","href":"https://static.observableusercontent.com/files/125f7a2f0b1ebcb0c59c7015798de01b5fbf52145190a3f4bb4441091e63f8410c4106e8980ceae89015d1910d7888c8baa3e158c26ad4e98f5c02416943b40e","name":"reading.png","type":"image/png","lastModified":1674118622238.283,"size":129076},{"id":"e23d1bb54d3dc63faeda5dfcad7697760a5609dc663619399ab8bbdd466ffaeb360e8f7bbcda8d267468a3d53ab9ba58e571593704554f636354e5e89093837c","href":"https://static.observableusercontent.com/files/e23d1bb54d3dc63faeda5dfcad7697760a5609dc663619399ab8bbdd466ffaeb360e8f7bbcda8d267468a3d53ab9ba58e571593704554f636354e5e89093837c","name":"podcast.png","type":"image/png","lastModified":1674117433798.615,"size":115930},{"id":"5ae7790c085503554a65fc80dba19815baf703f4488e0076ef564bc7f1a1c35305e8eb3157f4eff7f84d20eee34b822acff9e9768a8d15ea3ab6b5604af9d0cc","href":"https://static.observableusercontent.com/files/5ae7790c085503554a65fc80dba19815baf703f4488e0076ef564bc7f1a1c35305e8eb3157f4eff7f84d20eee34b822acff9e9768a8d15ea3ab6b5604af9d0cc","name":"listening.png","type":"image/png","lastModified":1674117442046.861,"size":116358},{"id":"7e2097120840d1611075f0ad02a4f781927b4d7db1c984f36283ca1ae686d992cce4d173a8f8a772ddb5b6900f3f6df54c589457cd79a095d415ff81347f3287","href":"https://static.observableusercontent.com/files/7e2097120840d1611075f0ad02a4f781927b4d7db1c984f36283ca1ae686d992cce4d173a8f8a772ddb5b6900f3f6df54c589457cd79a095d415ff81347f3287","name":"monologue.png","type":"image/png","lastModified":1674117448674.638,"size":109417},{"id":"1fdb0075ecc4ae57377e1b0d7a479fb5fad913feb94aa96012d1ac95084f12e073fb2f40e1518bf8c5e91850309240729c0a47e7086a7efe551c38cbb73b7cdf","href":"https://static.observableusercontent.com/files/1fdb0075ecc4ae57377e1b0d7a479fb5fad913feb94aa96012d1ac95084f12e073fb2f40e1518bf8c5e91850309240729c0a47e7086a7efe551c38cbb73b7cdf","name":"meditation.png","type":"image/png","lastModified":1674117456867.388,"size":106869},{"id":"34844d2a5f676801d851842921634e230504d7484a3df0b2d14b159258f4b8fe86324f89fc8a7bd9f0626ce4a4f4630c39d97747ba943b45036d760fa6ca221d","href":"https://static.observableusercontent.com/files/34844d2a5f676801d851842921634e230504d7484a3df0b2d14b159258f4b8fe86324f89fc8a7bd9f0626ce4a4f4630c39d97747ba943b45036d760fa6ca221d","name":"speaking.png","type":"image/png","lastModified":1674117519043.719,"size":93190},{"id":"c186e6f80d58ced8ed2f673e7ffc6e79d5b0bb37fca5b4d88ff4b151e784aee8fd87871d7446bdfd2d365c0c7e9e0a0ec147818d14559dac06fc0005a0349073","href":"https://static.observableusercontent.com/files/c186e6f80d58ced8ed2f673e7ffc6e79d5b0bb37fca5b4d88ff4b151e784aee8fd87871d7446bdfd2d365c0c7e9e0a0ec147818d14559dac06fc0005a0349073","name":"journaling.png","type":"image/png","lastModified":1674117518799.268,"size":110741},{"id":"9ced373298f7dc8811c5bc36b7c80aa191924758489ef605c06c4f3b4ade0862c3f4b5aa91ec3ee07aef3b80d4a0bdab6adb8b26a93b1440a500d957e20daf48","href":"https://static.observableusercontent.com/files/9ced373298f7dc8811c5bc36b7c80aa191924758489ef605c06c4f3b4ade0862c3f4b5aa91ec3ee07aef3b80d4a0bdab6adb8b26a93b1440a500d957e20daf48","name":"yoga.png","type":"image/png","lastModified":1674117529880.357,"size":113537},{"id":"760ff847b22caa70a6137d955005ab9c40b094fe1814b0bb9f451be8e282a1a5c17f7b4777a885171fe4ad6a9be2a8f623bd13672d4aa016cd71c4c65ea5a9b6","href":"https://static.observableusercontent.com/files/760ff847b22caa70a6137d955005ab9c40b094fe1814b0bb9f451be8e282a1a5c17f7b4777a885171fe4ad6a9be2a8f623bd13672d4aa016cd71c4c65ea5a9b6","name":"shadowing.png","type":"image/png","lastModified":1674117519448.958,"size":118489},{"id":"87a44776a8d174a4f3cf29d87c62869ae782405e61c31706d2c95041e27fce66a13605aafecaa3f185fbff9d0380757a81b6320fc91df59b3e8f814d74f8f72b","href":"https://static.observableusercontent.com/files/87a44776a8d174a4f3cf29d87c62869ae782405e61c31706d2c95041e27fce66a13605aafecaa3f185fbff9d0380757a81b6320fc91df59b3e8f814d74f8f72b","name":"writing.png","type":"image/png","lastModified":1674117519393.768,"size":113693},{"id":"f36b9a90ce3de503a93a408ba57c726b08189066bdf24d5999f5c0b242f9a2a5845ec0fc670561e4ea15eb53c7175012fe0b2e2b9c8ad49ffd811436feff0acb","href":"https://static.observableusercontent.com/files/f36b9a90ce3de503a93a408ba57c726b08189066bdf24d5999f5c0b242f9a2a5845ec0fc670561e4ea15eb53c7175012fe0b2e2b9c8ad49ffd811436feff0acb","name":"videos.png","type":"image/png","lastModified":1674247578607.349,"size":102772},{"id":"4b52b3458167fbe35df8cb337bba5be7cc4150c3bc28748d076b62f24a8ee56dace7bfc299d9f56eef5bd3a8ce0d801bc07ede690d364540f8beaa2a15ad5f16","href":"https://static.observableusercontent.com/files/4b52b3458167fbe35df8cb337bba5be7cc4150c3bc28748d076b62f24a8ee56dace7bfc299d9f56eef5bd3a8ce0d801bc07ede690d364540f8beaa2a15ad5f16","name":"chorusing.png","type":"image/png","lastModified":1674468077084.93,"size":115309}] 2f:{"title":"🗄️ Data Collection","cells":[{"id":0,"value":"$31","pinned":false,"hidden":false,"mode":"md"},{"id":226,"value":"# Input and Output Activities","pinned":false,"hidden":false,"mode":"md"},{"id":124,"value":"\n${await FileAttachment('listening.png').image({width: iconWidth})} | ${await FileAttachment( \"reading.png\" ).image({width: iconWidth})} | ${await FileAttachment('speaking.png').image({width: iconWidth})} | ${await FileAttachment( \"writing.png\" ).image({width: iconWidth})}\n:-------------------------:|:-------------------------:|:-------------------------:|:-------------------------:\nListening | Reading | Speaking | Writing\n","pinned":false,"hidden":false,"mode":"md"},{"id":228,"value":"## Input","pinned":false,"hidden":false,"mode":"md"},{"id":171,"value":"$32","pinned":false,"hidden":false,"mode":"md"},{"id":257,"value":"$33","pinned":false,"hidden":false,"mode":"md"},{"id":246,"value":"\n1. By _active_ I mean that I am entirely engaged and my attention isn’t split. Watching a movie in my TL would be considered _active_, whereas cooking would be _passive_. ","pinned":false,"hidden":false,"mode":"md"},{"id":250,"value":"","pinned":false,"hidden":false,"mode":"html"},{"id":100,"value":"{ //File.url(file).then(url => {\n // var image = new Image;\n// image.src = url;\n // return image;\n//})\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":46,"value":"activities = {\n let arr = []\n activityNames.forEach(d => arr.push(`await FileAttachment('${d}.png').image({width: iconWidth}))`))\n\n return arr\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":55,"value":"activityNames = ['listening', 'podcast','yoga','meditation', 'reading', 'speaking', 'monologue', 'shadowing', 'chorusing', 'writing', 'journaling']","pinned":false,"hidden":false,"mode":"ojs"},{"id":14,"value":"iconWidth = 100","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W34","stdlib":"1","titling":"auto"}