THE German course spreadsheet
Here it is: https://drive.google.com/open?id=1nZDwp4zR_SvcGNJK8B126BQot0GkmHyA I was creating this document while doing the course, including any word or phrase I've seen along the way and put an English translation next to it. I did it mostly for myself, such spreadsheets help me to understand the grammar of languages better and remember the words better as well. But I thought others might find it useful as well so I decided to post it.
The first page of the document includes all vocabulary in the course (I hope I haven't missed much). All words are divided into 5 categories: nouns (the biggest one), adjectives, verbs, adverbs and all other stuff (pronouns, numerals, prepositions etc.) + there is an additional category for some quirky phrases that can't be easily broken down to translate it word by word without losing some meaning.
The second page is grammar. There are tables showing the way German declination and conjugation work plus there are exceptions listed. If you want to know how to decline or conjugate any word on the first page, you can find it out here.
The third page is a list of all vowel alternations that regularly occur in German. It's relatively simple in German since there are only 3 of them (I'm not counting the strong verb classes, those are listed on the grammar page).
That's it, I guess. If you have any questions or you find any mistakes I made while making this spreadsheet, please leave a comment here, I’ll read all of them.
[Update 07.25.2019]: Major rework. All grammar tables are now on another page. Noun gender and word classes are now in separate columns. Added a page that lists all vowel alternations. Reworked many notes. Other minor corrections.
[Update 07.27.2019]: Added the conjugations of modal verbs können, müssen, sollen and dürfen. No idea why they weren't included...
The Polish spreadsheet discussion: https://forum.duolingo.com/comment/28339394 The Czech spreadsheet discussion: https://forum.duolingo.com/comment/28367063 The Dutch spreadsheet discussion: https://forum.duolingo.com/comment/33287288
That's a lot of hard work there, and very generous of you to share it with the forum. Karma+++ to you
No, that's great! I love it. However, that makes me think if I should write declension/conjugation types in a different column, because without any context those numbers and letters in brackets look... strange.
:) Yes I see what you mean. I might remove them from the Quizlets if I have time.
OMFG! You're my hero. I do not give them away easily, but... lingots for you :-)
What an awesome thing to do!! Thank you so much for all your hard work, and for sharing it as well!
Wow! I can't believe you did all this and are sharing it with us! Thank you so much! I love learning German and this will help so much!
This must have taken you 2 YEARS. & thanks for sharing this info with everyone
Thanks big bro. This is of great help. I am keep a German course and planned to make a spreadsheet like this by me but just don't know how to start it. Thanks again for sharing it.
Grossartige Arbeit! Eine kleine Anmerkung zu: Hand drücken /shake hands: man sagt durchaus jemandem die Hand schütteln, oder jemandem die Hand geben. Jemandem die Hand "drücken" wir eher nicht bei der Begrüßung, sondern eher emotionaler gemeint, z.B. wenn ein Gegenüber getröstet werden soll, das ist nicht das Übliche auf-und-ab-bewegen der Hände bei der Begrüßung.
Danke für deinen Kommentar! Ich glaube dir dass du die Wahrheit sagt, aber ich habe diese Phrase in meiner Tabellenkalkulation eingeschlossen weil sie so in dem Kurs war. Ich bin (noch) nicht deutschsprachig, also weiß ich keine solche Phrasen und muss dem Kurs vertrauen... Wenn du denkst dass es nicht richtig ist, sollst du den Kursmoderatoren danach fragen.
P.S. Entschuldigung wenn ich viele Fehler gemacht habe!