File Set-up Naming & Process

File Set-up Naming & Process

Objective

Create files for the Study.com teams that are easy to manage and consider the QA process after the files are worked.

Process

Receive file from Study.com
Example:



Format Sheet:


Duplicate a Working file
Create New Sheet in Working Folder 


Name the files according the following scheme:
  1. STDY - Project - Data 1/2/3 - 100-150
  2. Data Numbering = Batch drop from Study.com (Lumikha 1, Lumikha 2, etc.)
  3. The Numbers identify the Lesson Sequence in the last column of the file called “Row Order” 





Copy ±50 Lesson Records to the new file


  1. Prepare File for Work
    1. Freeze the first row
    2. Freeze the first two columns
    3. Highlight first row of each Lesson Record in yellow


    • Related Articles

    • Calibration Process & Concept

      Calibration Approach To help us learn how to perform keyword selection, we’ll use a learing calibration cycle, in additon to basic classes on calls with slides. Here’s how it works: Class for process explanation. Batch 1a with 10 records for each of ...
    • 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 ...
    • Quality Assessment Process, Scoring, & Objectives

      The Keyword Selection Project for Study.com involves continuous improvement of Sheets submitted. To improve our work, we perform a Quality Assessment of all Sheets. The quality process works in the following way: Study.com Keyword Selectors claim ...
    • Workflow for Processing Lessons

      This article covers how we will work together to process Lesson Keyword record files.  To process files, navigate to the Googe Drive folder labeled "Working" in the Study.com Project Data folder.  Select the file you plan to work on and add your ...
    • Study.com - Split KW Files into 50 Lesson Sheets

      Objective Split Keyword Selection batch into Sheets. Process Create New Tab Duplicate tab  Subtract appropriate Lessons Name Tab: STDY - Batch# - Row Range - Count Format Tab for QA Insert 2 rows at bottom of sheet Copy Correction list to 4 columns ...