Link to Live SOP
Civics Reporting - Standard Operating Procedure (SOP) for ESC Users

Standard Operating Procedure (SOP) for ESC Users

Weekly Verification Instructions (Mondays by noon)

Step 1: Export Data

1. Go to the "Learner Assessment Export" dashboard.
2. Select your date range
   1. Date Range filer on left of report (Small arrow if hidden)
   2. Example, select Range Type: Last > Last Week
   3. Click Apply
   4. Click Apply Filter
3. Click the vertical three dots ... on the chart and select Download > Export to .CSV
4. Open the CSV. 

You will see the verified column is either blank (for new users) or says "Yes" (for users verified in previous weeks).

Step 2: Add Verifications

1. For any new users you want to verify, simply type Yes in the verified column.
2. Save the file as CSV. (Comma delimited if prompted)

Step 3: Upload to System

1. In Superset, click the + icon at the top of the screen and select Data > Upload CSV to database.
2. Select your saved CSV file.
3. For the database, select ‘Analytics’
4. For the Schema, select ‘public’ 
5. CRITICAL: In the Table Name field, you MUST start the name with verifications_.
   We recommend naming it uniquely for your ESC and the date, for example: verifications_esc11_april29
6. All other settings should be left as default. (Delimiter, File Settings, Columns, Rows, etc )
7. Click Upload.
8. If successful you will see a message that says “Data Imported”

The system will automatically update the dashboard nightly.

If you need to upload a corrected version. Under file settings, select “Replace” in the “If Table Exists” dropdown. (Make sure the table name is the exact same as the existing upload)

If there is no TEA ID, it will be ignored by the system. (Fix in LMS)

Step by Step Guide