User:Amberannelarsen/sandbox/315

Purpose
In preparing to create the new Online Learning pages, we need to gather and sort the current existing videos into some spreadsheets.

Project Leader
Amber Larsen

Task List
Spreadsheet

Instructions
1. Sign your name in the task list above for the country you'd like to work on, and then open up that country's tab in the Spreadsheet.

2. The Spreadsheet is where you will be compiling all of the video links/information that you find for each country.

FSL Facebook Videos
3. Open the FS Library Facebook Videos spreadsheet.

4. Look through the list of videos (sort the table if you need to), and copy over any relevant information for that country into the spreadsheet.
 * There may not be any relevant videos for your country. If that is the case, move on to step 6.
 * Some videos may cover a region (e.g. British Church Records - this would pertain to England, as well as possibly Wales and Scotland, etc. if they are covered in the video). In those cases, add that video to all pertinent country tabs of the Spreadsheet.

5. Add all pertinent videos for your country to the spreadsheet, filling out as much information as you can for each column.
 * Column A will be filled in as either: "RootsTech", "FSL Facebook", or "FS Learning Center".
 * Column B will be the title of the class also as a hyperlink to that class video.
 * Column C will be the name(s) of the presenter(s).
 * Column D will be the language the class is presented in.
 * Column E will be the topic of the class (usually country/region and/or record type).
 * Column F will be a link to the class handout (if there is one). If there is no handout, write "No Handout".
 * Column G will be the year the class was presented.

6. The FS Library Facebook Videos spreadsheet doesn't specify the Language, Presenter, or Handout. If there is a relevant video for your country, you may have to open the link to the video and deduce that information for yourself.
 * The Presenter usually is listed either in the video caption or is mentioned at the beginning of the video. If there is no presenter, then just put "FS Library" as the Presenter in the spreadsheet.
 * The Handout (if there is one) is often linked to in the comments of the video.

RootsTech On-Demand Library
7. Open the RootsTech On-Demand Library.

8. Search for the country in question, and analyze the pertinence of the search results.
 * Be aware that the RootsTech search is not very good, so you may need to search multiple different ways to see all the possible videos for your country (e.g. don't just search for "China", also search for "Chinese" or "Asia", etc. to catch pertinent videos)
 * There may not be any relevant videos for your country. If that is the case, move on to step 9.
 * Some videos may cover a region (e.g. British Church Records - this would pertain to England, as well as possibly Wales and Scotland, etc. if they are covered in the video). In those cases, add that video to all pertinent country tabs of the Spreadsheet.
 * Example: If there are no search results for Afghanistan in the RootsTech library, try searching "Middle East" and see if there are videos that can pertain to your place.
 * Note:Not every video in the search results will actually be relevant. Use your best judgment on each video to decide whether it would actually be useful to users researching in that country. 

FamilySearch Learning Center
9. Open the list of Learning Center classes page. 

10. Sort the table by the "Country/Topic" heading, and locate the relevant topic(s) for your country.
 * Note: there may be paleography classes you could add, or classes about a geographical region that contains your country. Catch as many of them as you can that may pertain.

11. After you have gathered all pertinent videos for your country, mark the date in the task list and continue to the next country.
 * Note: You may not end up adding any videos to the spreadsheet for your particular country, especially for smaller countries or places we don't know much about research-wise. That's ok.

Example

 * See American Samoa on the spreadsheet.