Study.com - Split KW Files into 50 Lesson Sheets

Study.com - Split KW Files into 50 Lesson Sheets

Objective
Split Keyword Selection batch into Sheets.

Process
  1. Create New Tab
    1. Duplicate tab 
    2. Subtract appropriate Lessons
    3. Name Tab: STDY - Batch# - Row Range - Count
  2. Format Tab for QA
    1. Insert 2 rows at bottom of sheet
    2. Copy Correction list to 4 columns to the right
    3. Set Corrections counter formula 
      1. =COUNTIF(F2:F1409, "*")
    4. Lock Columns in formula and drag right to show specific corrections add dropdown cells
      1. =COUNTIF($F2:$F1409, G1409)
    5. Add score formula
      1. =(500-F1411)/500
      2. Format cell as %
  3. Save to New Spreadsheet
    1. Locate saved file and rename using Tab name

Create New Tab

Duplicate tab



Subtract rows 


Rename tab STDY - Batch# - Row Range - Count | Note First and lat URL ID for Row Range



Format Tab

Insert 2 rows at bottom of sheet & copy Correction list to 4 columns to the right



Add Correction Count formula  =COUNTIF(F2:F1409, "*")

Extend Counter formula: Lock Columns in formula and drag right to show specific corrections add dropdown cells =COUNTIF($F2:$F1409, G1409)




Add Score formula =(500-F1411)/500 & Format cell as %


Copy to New Sheet



    • Related Articles

    • Study.com - KW Selection Create File

      Objective Set up a file for Study.com individual for Keyword Selection. Process Grab fresh batches from Study.com Sharepoint server Login to Study.com from this link Request Account verification code Check email (often in Spam folder) Navigate to ...
    • Study.com Lesson Page

      The Study.com Lesson page is the page we are selecting the Keywords for so Study.com can rank better in the search results. The important features of the Lesson page are:  Lesson Title (which also usually the page title) The Lesson's main topic, ...
    • What is a Lesson?

      The Two Ways We Think About Lessons We think of Lessons in two ways for the Study.com project. Pages on the Study.com website Records to be worked on the Keyword project Lessons on the Study.com Website Study.com pages are organized into Lessons. A ...
    • Log-in to Study.com

      Navigate to Study.com Log-in using: Login: contractors@educationportal.com Password: p1zdon7Ch$nge7isPW19 This is a shared login DO NOT change any account information once logged in
    • Lesson Keyword Sheet Record

      The Lesson Keyword Sheet or Sheet contains ±50 Lessons for Keywords selection. The important parts of the Lesson are: Study.com Lesson URL where you go to check the lesson and grab the Lesson's main idea. The available Keywords for selection. The ...