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
I greatly appreciate this list and all the work you put into it. Thank you for sharing it. I double checked your nouns against the list I was keeping and (I think) the following are missing if you want to update.
Branche Chef Daten Delfin Dokument Erwachsene Innere Kritik Mittag Mittel Pappe Partei Planung Politiker Rechte Umgang Urgroßvater Weise Zeit Zeug
OK, I've been checking your list of words right now and can say the following things:
Daten - I have the word Datum in my list, Daten is the plural of that.
Delfin - I have a word for that in my list but it's written as Delphin. As far as I can tell, the form Delphin is more common but I added Delfin as well.
Innere - I have the word Inneres in my list, Innere is an inflected form.
Mittag - good catch, missed that one. In my course it was used only in the context of essen zu Mittag, maybe that's why I forgot to include it.
Rechte - I have the word Recht in my list, Rechte is the plural of that. Rechte can be used as a nominalized adjective meaning "the right side" but it wasn't used in this context in my course.
Zeit - another good catch, don't know how I missed this word. It's added now.
Zeug - another rightful addition to my list.
Apparently, I never encountered all other words you mentioned. I checked the Words section on Duolingo and these words just weren't there. Perhaps they were present in your course, if so, you can add them to your file yourself. :) But since I didn't meet them, I'll not include them.
The spreadsheet which I created on MsExcel has 4 columns (masc./ fem./ neuter/ plural). The listing of the German words are kept in alphabetical order. Say, for instance, the word "Kind" (child). The listing of "Kind" would come under Column A. In parenthesis, the meaning appears. This way, every day, I take a column to review. Because I am reviewing, Column A, automatically my mind can recall all the masculine words in that column. This reinforces the appropriate articles for nouns, etc.
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!
I'm a bit lost - is this for the Duolingo German course? Your vocab list looks like you started with all the stuff I ideally would have liked to study with. Unfortunately for me, my beginning trees' nouns are all along the lines of Apfel, Brot, Wasser, Katzen, Hause, Kleid, Mutter.... Dates isn't taught until the 4th tree, and Business 1 is the 8th bubble of the 6th tree :(. I started Duolingo last year too. Did Duolingo really change things up or does anyone know why our trees are placed so differently? Is there some setting to set your Duolingo learning geared towards different goals?
Hello Lion...Yes, it was an answer to a question for the German course. I think, it´s possible to jump forward. Perhaps only , if you pass the next checkpoint well. Checkpoints are the towers with flags. Sorry for my bad english- hope its ok for you. To the best of my knowledge it isn´t possible to set learning to self-chosen goals.
I don't really know what you mean, tbh. This list includes all words that I've seen in my English-German course. Also why is it unfortunate that you start with nouns Apfel, Brot, Wasser etc??? These are some of the most important words to know while learning a different language. Maybe my tree had some differences but I'm sure it was mostly the same.