How to create a new word list with spreadsheets?
I'm relatively new to the site, and am mostly using it to review my Mandarin. However, due to my own interest in improving my German vocabulary I have been attempting to create a few lists of German business vocabulary.
I already speak German fairly well (I lived there in high school), so my goal is to make more subject-specific lists rather than beginner type vocabulary lists. I'm making them for my own use, with the hope that other people can get some benefit from them in the long run. :)
I have read the FAQ but don't completely understand how to use a spreadsheet to add more dimension to my lists. I finished one list (Deutsche Wirstschaftssprache - Teil 1 - Wirtschaftsgeographie) using the browser input system. However, I noticed that when words were already listed somewhere, they had a plural form available. How do I do this on my own? I tried to put the plural in parentheses but it looked like the plural would then show up all the time, which wasn't my goal.
If I could get a blank spreadsheet of some kind to fill in my own word lists along with a little bit clearer explanation of how to use the columns, that would help greatly. I'm already double checking the articles and translations (as well as declination, where necessary) with additional dictionaries so I can find the information easily, it's simply a matter of getting it to show up on the site correctly.
Any help and/or suggestions would be greatly appreciated! :)
Additionally, is there some way to show these course lists as related? The name seems a little long right now, but putting all the sections together is going to be a ridiculous amount of vocabulary for one lesson. i.e. would there be a way to make a parent course of Wirtschaftsdeutsch, with subclasses of 1.) Wirtschaftsgeographie, 2.) Produktion, 3.) Handel etc...?
Posted by lovesasa 2/18/12 (1 year ago)Additionally, is there some way to show these course lists as related? The name seems a little long right now, but putting all the sections together is going to be a ridiculous amount of vocabulary for one lesson. i.e. would there be a way to make a parent course of Wirtschaftsdeutsch, with subclasses of 1.) Wirtschaftsgeographie, 2.) Produktion, 3.) Handel etc...?
Posted by lovesasa 2/18/12 (1 year ago)Great question - we are implementing a design for the course creation that will make this much more straightforward, but in the meantime, the easiest way to get a sample spreadsheet would be to go to another German course (maybe one of the featured ones would be best) and then click "download" (it is right at the bottom of the main course page). This will allow you to download a sample spreadsheet, with the right columns. You just need to delete the "url" column, and then you can add two more columns if you want to: "alternative english" and "alternative german". I'm afraid that at the moment there is no way to group separate courses together. But we wil be introducing searches soon and so people will be able to, eg search byt he course creator, which should help with that.Does that make things clear? Please let me know if you have any other questions.Thanks!Ben
Posted by benwhately 2/18/12 (1 year ago)Great question - we are implementing a design for the course creation that will make this much more straightforward, but in the meantime, the easiest way to get a sample spreadsheet would be to go to another German course (maybe one of the featured ones would be best) and then click "download" (it is right at the bottom of the main course page). This will allow you to download a sample spreadsheet, with the right columns. You just need to delete the "url" column, and then you can add two more columns if you want to: "alternative english" and "alternative german". I'm afraid that at the moment there is no way to group separate courses together. But we wil be introducing searches soon and so people will be able to, eg search byt he course creator, which should help with that.Does that make things clear? Please let me know if you have any other questions.Thanks!Ben
Posted by benwhately 2/18/12 (1 year ago)That sounds good, thanks! That was kind of my plan with working on the word list, but I was confused by the URL column and how the alternative words showed up. Thanks for clarifying. I'll mess around with it some more and will let you know if I come across any problems.Thanks for your help,Sasa
Posted by lovesasa 2/19/12 (1 year ago)That sounds good, thanks! That was kind of my plan with working on the word list, but I was confused by the URL column and how the alternative words showed up. Thanks for clarifying. I'll mess around with it some more and will let you know if I come across any problems.Thanks for your help,Sasa
Posted by lovesasa 2/19/12 (1 year ago)I want to do something similar, however I want to include sample sentences to give the vocab some context. Is there a field name I should add to the spreadsheet, such as "sample sentence" or something?
Posted by alphomega 2/27/12 (1 year ago)I want to do something similar, however I want to include sample sentences to give the vocab some context. Is there a field name I should add to the spreadsheet, such as "sample sentence" or something?
Posted by alphomega 2/27/12 (1 year ago)Yes, pretty much. You should actually put "samples" or "sample" as the column heading. For full instructions on the spreadsheet uploading, take a look here - http://www.memrise.com/faq/upl...
Posted by benwhately 2/27/12 (1 year ago)Yes, pretty much. You should actually put "samples" or "sample" as the column heading. For full instructions on the spreadsheet uploading, take a look here - http://www.memrise.com/faq/upl...
Posted by benwhately 2/27/12 (1 year ago)