Transcript: DataVista: Data Exchange Portal Tour
Welcome to Data Vista. In this tutorial, we will walk through how to use the data exchange portal. The data exchange portal is a tool that enables K12 strong workforce program data partners to securely submit CalPAD's data files for annual reporting.
We'll start on the Data Vista homepage. Hover over the top navigation ribbon and click on data views. Once the menu expands, select upload data. This is the data exchange portal.
If you are a first time user, you will need to create an account before you can upload files. On the upload data page, select get started with an account. You'll fill in your name, last name, work email, job title, primary organization, and create a password. If you have any special requests for your account setup, you can include those in the special request field. When providing your email, use your school or district work address. Personal addresses like Gmail or Hotmail are not accepted. If your domain is approved, your account is created instantly. Check your inbox or spam filter for a confirmation email and select confirm my account. If your domain isn't recognized, a Data Vista administrator will review your registration and notify you by email once approved.
When logging in for the first time, users will enter the upload data page. There are seven files that are required for the K12 strong workforce program. The student enrollment, student information, student program, student language acquisition, course section completion, student course section completion, and the student career technical education files. The files should be uploaded as they were received from the CalPAD's ODS and must be carrot delimited to be ingested.
You can upload all seven files in one batch. There is no need to upload files one at a time. Files will immediately appear as uploaded or error as in the example shown. Uploaded files are validated nightly. The file status will update to done, partial, or failed within 24 hours.
From the upload screen, you can select the back to schools list to see the status of all of the schools you have permissions for. Today, I am using Antioch Unified School District as our example. To see the history of the files that you have personally uploaded, select the see history button to the right of the upload files button. This space shows only the files that you have uploaded to the data exchange. You have the option to filter the year of the files, the file type, or the status.
Returning to the schools list, we can see how many files have been submitted for each school for each year and whether there is any on file for that school. A dashed line indicates a school is not participating in that year of the K12 strong workforce program. If we would like to see which files have been submitted regardless of who submitted them, we can select an individual school to see the history by year. All the years the school participated in the K12 strong workforce program will be shown.
If you need to request an exception for the file submissions, you can click on request exception. In the new window, please select the academic year, the file or files you requesting an exception for, a brief explanation, and click on submit request. If your exception is approved, the number of required files will decrease to the appropriate amount.
If you have any questions, please reach out to us at datavistac@ccccco.edu.