Text Transcript of the CBEDS Training
Text Transcript of the 2024–25 California Basic Educational Data System (CBEDS) training.2024–25 CBEDS Training
This is a text transcript of the California Basic Educational Data System (CBEDS) training. This document provides text translation to the CBEDS training, which is posted as a video file. The 2024–25 CBEDS Training [https://www.cde.ca.gov/ds/dc/cb/cbedstrngvideo.asp] video should be the version selected by most users.
2024‒25 CBEDS Training:
Presented by Lisa Young
California Department of Education, Sacramento, CA
August 2024
Table of Contents
- CBEDS Training
- County/District Information Form (CDIF)
- School Information Form (SIF)
- District of Choice Supplemental (DOCS)
- CBEDS-ORA Overview
Slide 1 – 2024–25 CBEDS Training
Welcome to the California Basic Educational Data System (CBEDS) training. This training is intended for local educational agencies (LEAs) and independently reporting charter (IRC) schools that are responsible for completing and submitting school and district level CBEDS data to the California Department of Education (CDE) through the CBEDS Online Reporting Application (ORA).
For the purposes of this presentation, an LEA is defined as a school district, county office of education, California Education Authority, State Special School, State Board of Education Charter, or Statewide Benefit Charter.
Slide 2 – Contact Information
Contact information for CBEDS related inquiries is displayed. General inquires and questions about CBEDS-ORA shall be directed to the CBEDS Office email at cbeds@cde.ca.gov. Please do not hesitate to contact us with questions or suggestions. Questions regarding a specific subject area shall be directed to the subject matter expert for that subject.
- For Classified Staff, Teacher Hires, and Educational Calendar contact Lisa Young by email at cbeds@cde.ca.gov.
- For Kindergarten Program Type email Benjamin Allen at ballen@cde.ca.gov.
- For Work Visa Applications email Erin Koepke at ekoepke@cde.ca.gov.
- For District of Choice email Kathryn Morrissey at districtofchoice@cde.ca.gov.
Slide 3 – Agenda
This training consists of an overview of CBEDS, which includes:
- A description of CBEDS and the forms and data that are collected
- A summary of the purpose and uses of CBEDS data
- A description of CBEDS coordinators responsibilities
- Information on available resources
- A description of the data collection, verification, submission, and certification process
- Significant dates
- This training also provides detailed instructions on how to accurately report data for the three CBEDS forms: The County/District Information Form (CDIF), the School Information Form (SIF), and the District of Choice Supplemental (DOCS).
- This training also provides an overview of CBEDS-ORA, which highlights various features of ORA, provides instructions for key entering, editing, importing, and exporting data, discusses the available reports within ORA, and provides instructions for submitting data.
Slide 4 – CBEDS Overview
We will begin this training by providing an overview of the CBEDS data collection process.
Slide 5 – What is CBEDS?
- CBEDS is an annual statewide data collection of aggregate-level school, student, and staff data.
- CBEDS data are reported through an online reporting application referred to as CBEDS-ORA.
- Data is collected on the following three forms, which will be covered in detail on the next slide.
Slide 6 – CBEDS Forms and Data Collected
The County/District Information Form (CDIF) is a county/district-level form that collects data on the full-time equivalent (FTE) of classified staff working at the county/district office, the estimated FTE of teachers the county office/district plans to hire, and information on work visa applications that the county office/district applied for on behalf of potential employees, and home-to-school transportation data. CDIF data is collected for each county office of education and district office.
The School Information Form (SIF) is a school-level form that collects data on the FTE of classified staff working at each school,the type of kindergarten program the school operates, the type of educational calendar the school operates on, information on work visa applications for charter schools, and the estimated FTE of teachers independently reporting charter schools (IRCs) plan to hire. SIF data is collected for every public kindergarten through grade twelve (K–12) school, including charter schools.
The District of Choice Supplemental (DOCS) is a district-level form that collects data on District of Choice transfer requests, transfer students receiving transportation services by race/ethnicity and gender, and transfer students receiving transportation services by program participation. DOCS data is only completed by districts participating in the District of Choice (DOC) program.
Slide 7 – Purpose of CBEDS Data
CBEDS data is administered to meet federal and state reporting mandates and to aid in program policy and decision making. Federal mandates require the state to provide data on classified staff and estimated teacher hires. State mandates require the CDE to provide information on H-1B work visa applications, information about students participating in the District of Choice program, and information on the types of kindergarten programs offered by schools, and home-to-school transportation.
Educational calendar is collected to assist with program and policy decision making.
Slide 8 – Uses of CBEDS Data
CBEDS data is used:
- To calculate teacher shortage based on the estimated teacher hire data
- To conduct program analysis on Kindergarten programs
- To assist with educational calendar program and policy decision making
- To aid with cohort calculations using school start and end dates.
- To assist school districts, transportation agencies, and school transportation operators in providing the safest and most efficient transportation services for their passengers.
- For research and general use by educational institutions and the general public
Once the CBEDS data collection is complete, data are made available to the general public through the following CDE web pages.
- DataQuest, which is a dynamic system that provides reports about California's schools and districts. DataQuest web link [https://dq.cde.ca.gov/dataquest/]
- Student and School Data Files page, which contains downloadable CBEDS data files. The Student and School Data Files web link [https://www.cde.ca.gov/ds/ad/filescbedsorab.asp/]
- Staff Data Files page, which contains downloadable data files for CBEDS classified staff data. The Staff Data Files web link [https://www.cde.ca.gov/ds/ad/filescbedsoraa.asp/]
Slide 9 – CBEDS Coordinator Responsibilities
Every LEA and IRC is asked to assign a CBEDS coordinator who will be responsible for ensuring that all CBEDS data for the LEA and IRC are collected and submitted to the CDE. In order to fulfill their CBEDS reporting responsibilities, CBEDS coordinators shall:
- Be aware of the CBEDS data reporting requirements, including changes to the data collection, and be prepared to report the required elements.
- Compile the data for your LEA or IRC.
- District and county office coordinators shall compile or obtain data from all the schools in their LEA, including charter schools not reporting independently of their LEA.
- They should also train and provide assistance to school staff regarding the collection and reporting of data for their schools.
- Verify the accuracy of the reported data prior to certification. LEAs shall review the data being reported for each school and should take advantage of the summary and comparison reports that are available within CBEDS-ORA. These reports may be shared with appropriate district and school staff to assist with the verification of the data.
- Run the errors and warnings report and resolve all errors, and research and fix warnings as necessary.
- Submit your LEA’s or IRC’s CBEDS data to the CDE. LEA’s shall ensure all data are included in their data submission, including data for charter schools not reporting independently of their LEA. Charter school’s electing to submit data to the CDE independent of their authorizing LEA shall be responsible for ensuring their data submission is complete and accurate.
- Charter schools wishing to report their data independently of their LEA may elect to do so by submitting a CALPADS and CBEDS-ORA Charter School Reporting Status Change Form to the CDE by the end of June, or upon establishment of the charter school. If a form is not submitted by the June 30 deadline, the reporting status from the previous year will carry over to the next year.
- Should changes need to be made to certified data, the CBEDS coordinator shall submit necessary changes to the CDE within the CBEDS amendment window.
Slide 10 – CBEDS Resources
The following resources are available to CBEDS coordinators to aid in the collection and submission of CBEDS data.
- The CBEDS web page, which contains the information you will need to complete the CBEDS data submission, including the Administrative Manual, frequently asked questions, file import specifications, the quick guide, forms, training, correspondence, policies and guidelines, and more.
- CBEDS-ORA, which is the online application used by CBEDS coordinators to submit CBEDS aggregate data to the CDE. Use of the CBEDS-ORA is required by all LEAs and IRCs, and a CDE-issued user name and password are needed to access the application and submit data. CBEDS-ORA also contains a list of the schools in your LEA for which you are required to submit CBEDS data, as well as the ability to view and update coordinator contact information. Both of these options are available from the Main Menu within CBEDS-ORA.
Slide 11 – Administrative Manual
We’d like to take a moment to highlight the key resources that CBEDS coordinators will need to utilize in order to successfully complete their CBEDS reporting requirements. These key resources include the CBEDS Administrative Manual and the List of Expected Schools. The CBEDS Administrative Manual is an instruction booklet that includes information on the following:
- Contacts and resources
- When data are collected
- What data are collected
- Who provides the data
- Purpose and uses of data
- Changes to the data collection
- The data collection and submission process
- Glossary and instructions
The Administrative Manual [https://www.cde.ca.gov/ds/dc/cb/documents/admin2024.docx] (DOCX) is available from the web page listed.
Slide 12 – List of Expected Schools
The other key resource CBEDS coordinators will need is the List of Expected Schools. The List of Expected Schools is a list of the schools in your LEA from which the CDE expects to receive data. It also identifies which charter schools are reporting independently of their authorizer.
The List of Expected Schools is available online through CBEDS-ORA.
It is very important that you review the accuracy of this list prior to submitting your CBEDS data to the CDE, as data submission may be prevented if you do not have data for all the schools on the list. You will also be prevented from submitting data for new schools not appearing on the list, so it is important to resolve any discrepancies with the list prior to reporting your data.
If you find discrepancies with the list, we ask that you work with your LEA’s County-District-School (CDS) coordinator to submit changes, or for assistance with the following:
- School closures
- School name changes
- Grade span changes
- School type changes
- Opening a new school
Slide 13 – List of Expected Schools (Continued)
If you have a school with no enrollment on Information Day, use the List of Expected Schools to notify the CDE of a temporarily non-operational school by following these steps:
- Contact your LEA's California Longitudinal Pupil Achievement Data System (CALPADS) Administrator to confirm that no student enrollments were reported on the CALPADS ODS Report 1.1 on Information Day.
- Indicate the "Non-Operational Effective Date"
- Provide a brief “Reason for Not Operating” on the List of Expected Schools. Examples of reasons that schools are temporarily non-operational include:
- No enrollment on Information Day
- Lack of funding
- School closed for construction
- Obtain the Superintendent’s signature
- Email the list to cbeds@cde.ca.gov.
It is very important to resolve all discrepancies with the List of Expected Schools prior to reporting or submitting data. Failure to resolve discrepancies with the List of Expected Schools may result in errors in your data submission, or prevent, or delay in your ability to submit your data.
Slide 14 – Collecting Data
- CBEDS requires LEAs to collect and report data for current year, as well as for the prior year and, future projections.
- Current year data are to be collected as of Information Day, October 2, 2024.
- If your LEA is not in session, or is off track on Information Day, at the discretion of the Superintendent, data may be collected on another date in October. It is recommended that you choose a day close to Information Day.
- If data are to reflect a year other than the current school year, reporting periods will be specified.
- In order to meet the reporting deadline at the end of October, data shall be collected from all schools on the List of Expected Schools in mid-October. This includes your charter schools, unless the charter schools are reporting independently of the LEA. IRCs are to submit data directly to the CDE.
Slide 15 – Verifying Data
- CBEDS coordinators are responsible for ensuring that their data submission is complete and that data has been included for each school on the List of Expected Schools, including charter schools not submitting independent of their authorizing LEA.
- If a school(s) has closed, or is temporarily non-operational, ensure data has not been reported for those schools.
- The CBEDS coordinator shall also verify the data for accuracy by taking the following steps prior to submission and certification:
- Review the data in CBEDS-ORA, especially if data were imported.
- Review the Errors and Warnings report to resolve any errors and/or warnings. All errors must be resolved prior to submission. Warnings should be checked and verified for accuracy.
- Print and review school and district summary and comparison reports for accuracy with appropriate LEA staff. Various reports are available in CBEDS-ORA to assist with your data review.
Slide 16 – Submitting Data
- CBEDS data is due to the CDE on or before October 31, 2024.
- Data is to be submitted electronically via CBEDS-ORA. Once all data has been entered and/or imported into CBEDS-ORA, LEA’s must go through the process of submitting and certifying their data. To submit data via CBEDS-ORA:
- Select the “Certify Data” option from the Main Menu.
- Then click on the “Certify Submission” button to begin the certification process. At this point, the system will go through a final check to validate the data. Once the check is complete, a report will be displayed indicating any errors and/or warnings. As mentioned before, warnings must be verified and all errors must be fixed prior to data submission and certification.
- If no errors are detected in your data, and the information on the page is accurate, click on the “Certify” button to submit your data.
- Once your data has been successfully submitted, you will receive a Certification Receipt with a date and time stamp which can be printed for your records. The certification receipt is also available from the Reports menu in CBEDS-ORA once you have submitted your data. Please do not submit data to the CDE via paper forms.
Slide 17 – CDE Data Processing and Certification
- Once data is submitted by LEAs, CDE staff begins processing the data to identify missing or incomplete data submissions. CDE staff will contact CBEDS coordinators to ensure data is submitted in a timely manner and to resolve any issues identified with their data submission.
- Once all data have been received statewide, CDE staff analyzes the data for trends and consistency and contacts select LEAs for verification prior to certifying the data statewide.
- Once all errors and anomalies are corrected and verified, the data are certified statewide and posted via the CDE Data and Statistics web page. This usually occurs in the spring.
- Changes cannot be made to CBEDS data after statewide certification, which usually occurs in December.
Slide 18 – Significant Dates
The following are significant dates for CBEDS:
- CBEDS coordinators receive data collection information in August.
- CBEDS training is made available online in September.
- Information Day is October 2.
- On October 15, District of Choice data are due to the CDE for districts participating in the District of Choice program.
- CBEDS Data are due to the CDE on or before October 31.
- On November 1, the CDE will notify LEA superintendents and independently reporting charter school administrators if CBEDS data is not received by the deadline.
- The CBEDS cycle ends, and data is certified statewide on December 15.
Slide 19 – Instructions for Completing the CBEDS Forms
This completes the CBEDS overview portion of this presentation. Next, we will cover the instructions for completing the CBEDS forms, starting with the County/District Information Form (CDIF).
Slide 20 – County/District Information Form (CDIF)
The CDIF shall be completed by county offices, district offices, the California Education Authority, State Board of Education agencies, Statewide Benefit Charter agencies, and State Special Schools. Independently reporting charter schools do not complete a CDIF.
Slide 21 – Classified Staff – CDIF (Section A)
- Classified staff are employees of the county or district not requiring certification qualifications. An exception to this is non-certificated administrators at the level of assistant, deputy, or associate superintendent or higher. These staff are not to be included in the count of classified staff.
- Report the full-time equivalent (FTE) of classified staff positions assigned to the district office or county office of education as of Information Day.
- Report classified staff data by gender, type of position (i.e., paraprofessional, office/clerical, or other classified), and by racial/ethnic designation.
- Note: Single school districts are to report all classified staff on the SIF, not on the CDIF.
Slide 22 – Classified Staff FTE – CDIF
- When reporting classified staff, report FTE counts to two decimal places. For example, full-time would be reported as 1.00 FTE, two-thirds time would be reported as .67 FTE, and half-time would be reported as .50 FTE.
- For classified staff working in more than one position, report the FTE of each position. For example, if a full-time employee works half-time as a “paraprofessional” and half-time as “other classified,” report each position as .50 FTE.
- For classified staff working at more than one location, report the FTE at each site. For example, if a half-time employee is assigned to both the district office and a school site, report .25 FTE at each location.
Slide 23 – Estimated Number of New Teacher Hires – CDIF (Section B)
- Report the projected or estimated full time equivalent (FTE) of teaching positions you plan to fill for the following school year.
- Report data to one decimal place.
- Only include full-time equivalent positions that are new or vacated. Do not include staff you plan to re-employ in the same position the following year.
- Only include classroom teaching and specialist positions.
- In “Other Specializations” do not include:
- Administrative, pupil services, or classified positions.
- Report data for all schools in your district, except any charter schools that report their data independent of your district. IRCs are to report their estimated new teacher hires on the School Information Form (Section E).
Slide 24 – Work Visa Applications – CDIF (Section C)
H-1B work visas are visas employers apply for when seeking to hire nonimmigrant aliens as workers in specialty occupations.
New legislation requires LEAs to report the number of H-1B work visas applied for on behalf of potential LEA and school employees, and the number of those applications that were granted.
LEAs are not to include visa application data from their charter schools on the CDIF. This includes districts with all charter schools, state board of education, and statewide benefit charter agencies.
Visa data for charter schools are to be reported on the charter school’s SIF.
Slide 25 – Home-to-School Transportation – CDIF (Section D)
- Report home-to-school transportation data for all students utilizing transportation.
- General transportation information includes number of days, miles, routes, and seat belt equipped buses.
- Types of fuel sources used, selecting all that apply.
- Report counts of ridership information which includes daily riders, and socioeconomically disadvantaged riders.
- Ridership demographics is a breakdown of race/ethnicity counts.
Slide 26 – School Information Form (SIF)
We have completed the instructions for the CDIF portion of this presentation. Next, we will provide instructions for completing the SIF, which shall be completed for each school.
Slide 27 – Classified Staff – SIF (Section A)
- Classified staff are employees of the school not requiring certification qualifications. An exception to this is noncertificated administrators at the level of assistant, deputy, or associate superintendent or higher. These staff are not to be included in the count of classified staff.
- Report the FTE of classified staff positions assigned to a specific school as of Information Day.
- Report classified staff by gender, type of position (i.e., paraprofessional, office/clerical, or other classified), and by racial/ethnic designation.
- Single school districts are to report all staff on the SIF, not the CDIF.
Slide 28 – Classified Staff FTE – SIF
- When reporting classified staff, report FTE counts to two decimal places. For example, full-time would be reported as 1.00 FTE, three-fifths time would be reported as .60 FTE, and a quarter-time would be reported as .25 FTE.
- For classified staff working in more than one position, report the FTE of each position. For example, if a full-time staff member works half-time as a “paraprofessional” and half-time as “other classified,” report each position as .50 FTE.
- For classified staff working at more than one location, report the FTE at each site. For example, if an “other classified” staff position is considered half-time and he/she is assigned to two schools, report .25 FTE at each school.
Slide 29 – Kindergarten Program Type (Section B)
This section collects data on the kindergarten and transitional kindergarten (TK) program type offered by each school. Data in this section are required to be reported for every school in the district, regardless of whether or not the school serves kindergarten students. When reporting data in this section, report the type of kindergarten program and transitional kindergarten program the school offers by selecting one of the available program types.
Program type options include full-day, part-day, both, or none. While the maximum school day in kindergarten is 4 hours, schools that have adopted an early primary program (extended-day kindergarten) are allowed to exceed 4 hours, and may offer a full-day program.
Slide 30 – Work Visa Applications – SIF (Section C)
Only charter schools are to report Work Visa Application data on the SIF in section C. The reporting requirements for this section is similar to those reported by the district on the County/District Information Form in Section C.
H-1B work visas are visas employers apply for when seeking to hire nonimmigrant aliens as workers in specialty occupations. New legislation requires LEAs to report the number of H-1B work visas applied for on behalf of potential charter school employees, and the number of those applications that were granted.
Slide 31 – Educational Calendar – SIF (Section D)
This section collects data on the type of calendar on which the school operates, as well as the school’s start and end date for the school year.
Report the type of calendar on which the school operates by selecting the appropriate calendar type, or types (i.e., traditional, single-track, or multitrack).
- If the school does not operate a year-round calendar, only select traditional.
- If the school offers both year-round and traditional calendars, select traditional.
- If the school operates on a year-round calendar, select either single-track or multitrack.
Report the school’s start and end date for the school year. The start date should represent the first day of instruction and the end date should represent the last day of school.
For schools operating on a multitrack calendar, the start date should represent the first day of school for the earliest track, and the end date should represent the last day of school for the latest track.
Slide 32 – Estimated Number of New Teacher Hires (Section E)
IRCs are to report Estimated Teacher Hires on the SIF in section E. The reporting requirements for this section is similar to those reported by the district on the County/District Information Form in Section B. Please refer to the CDIF slide 23 for details on reporting these data.
Slide 33 – District of Choice Supplemental (DOCS)
We have completed the instructions for the SIF portion of this presentation. Next, we will provide instructions for completing the DOCS, which shall only be completed by school districts whose governing body elected to operate as a DOC and accept transfer students from one or more districts of residence.
Slide 34 – Transfer Requests – DOCS (Section A)
This section collects information on District of Choice transfer requests that were received and processed for the current school year. All districts participating in the District of Choice program must complete this section.
Districts participating in the District of Choice program are required to report the number of transfer requests that were granted, withdrawn, or denied. If any transfer requests were denied, the reason(s) for the denial must also be reported by specifying all of the reasons for denial that apply.
Other types of transfer requests, such as school choice or open enrollment are not to be included in these transfer request counts.
Slide 35 – Transferred Students Receiving Transportation Services by Race/Ethnicity and Gender – DOCS (Section B)
Sections B and C of the DOCS only needs to be completed if the district participating in the District of Choice program provides transportation services to District of Choice transfer students. If this is the case, the district participating in the District of Choice Program will need to complete Sections B and C of the DOCS for each district of residence for which the district receives District Of Choice transfer students.
For each district of residence, report the number of transfer students who received transportation services by race/ethnicity and gender.
Slide 36 – Transferred Students Receiving Transportation Services by Subgroup – DOCS (Section C)
As we mentioned, Section C of the DOCS only needs to be completed if the district participating in the District of Choice Program provides transportation services to District of Choice transfer students.
For each district of residence, report the number of transfer students who received transportation services and participated in the following programs:
- Free or Reduced Priced Meals
- English Learners
- Students with Disabilities
- Socioeconomically Disadvantaged
Students are to be reported in each program they participate. Counts may be duplicated across programs. For example, a socioeconomically disadvantaged English Learner student with disabilities who is eligible for free or reduced priced meals would be reported in each of the programs.
Slide 37 – CBEDS-ORA Overview
This completes the instructional portion of our training for completing each of the CBEDS forms. Next, we will provide a brief overview on CBEDS-ORA, which is the web application used by LEAs to submit CBEDS data to the CDE.
Slide 38 – CBEDS-ORA Features
CBEDS-ORA includes the following features:
- A List of Expected Schools, which is a list of the schools in the LEA that are expected to report CBEDS data. This list is also used to notify the CDE of temporary school closures, or non-operational schools.
- The ability to view or update district and/or IRC CBEDS coordinator contact information. It is important to keep contact information up-to-date to ensure receipt of CBEDS correspondence.
- The ability to key enter or update CBEDS data.
- The ability to import and/or export data. Users with access to data files containing CBEDS data, either extracted from their student information, human resources, or other systems, may upload these files in order to bypass key entry. Once data are entered into CBEDS-ORA, users may also export the data to obtain a file of the data contained in CBEDS-ORA.
- The ability to view or print various reports compiled from reported data. Reports are available for data quality and verification purposes and include reports of completed forms, district level summaries, and year to year comparisons.
- Lastly, CBEDS-ORA provides the ability for LEAs to electronically certify and submit their CBEDS data to the CDE.
NOTE: Districts participating in the DOC program will have an additional menu option, which will provide access to DOCS reporting features. These features will be discussed later in this training.
Slide 39 – Entering/Editing Data
There are two options available for entering CDIF and SIF data into the CBEDS-ORA. The first option is manual key entry, which is used by most districts and IRCs. The second option is to import data, which bypasses key entry and loads a file containing CDIF/SIF data. The importing option will be discussed later in this training. Now we will provide instructions for key entering/editing CDIF/SIF data.
- Select the “Edit” option from the main menu.
- Select a school or the “District Office (CDIF)” from the list of schools in the drop-down menu and click on the “Select” button. Selecting a school will load the SIF for the school. Selecting the District Office (CDIF) will load the CDIF for the district/county office.
- Once the system loads the school or district office information, a screen showing the available sections for you to edit will be displayed. Select the section you wish to enter data for and click on the “Edit/Update Data Below” button.
- Click on the “Save” button to save and view your keyed entry, or you may click the “Cancel” button to exit without saving.
- Note: If an error is detected in the data that have been entered/keyed into the system, a note with an explanation of the error will be displayed at the top of the screen. You will not be allowed to save and exit if errors have been detected. You must fix the error(s) prior to saving and exiting, or you may select the “Cancel” button to exit without saving.
- To select another site to edit, click on the “Select a School or District Office” button at the top of the screen and repeat the appropriate steps above.
Note: If there is a school in the drop-down list that is not in operation this year, notify the CDE per instructions on the List of Expected Schools before entering data for the school.
Slide 40 – Sample Edit Screen
This slide shows a screen shot of the edit screen for reporting classified staff on the SIF through CBEDS-ORA. This screen will be the default screen for most LEAs when they choose to edit data for a school. From this screen you may choose to enter data for any of the sections by clicking on the appropriate section letter and selecting the “Edit/Update Data Below” button.
You may also choose to select another site to edit by clicking on the “Select a School or District Office” button, or you may choose one of the navigational links on the page to return to the Main Menu, or one of the other main pages within the application.
Slide 41 – Importing and Exporting Data
As previously mentioned, importing data files is one option available to LEAs for entering CDIF and SIF data into CBEDS-ORA.
- The import option is available to LEAs that have their data available electronically, for example from a student information system, who wish to bypass the key entry option and upload data files into the application.
- Data files must be formatted to meet the CBEDS-ORA Import File Specifications, which are available through CBEDS-ORA from the Export screen, or from the CBEDS web page [https://www.cde.ca.gov/ds/dc/cb/index.asp].
- The import option is located from the “Advanced Features” option from the Main Menu.
- Files are checked against format and validation checks prior to upload.
- You will need to review the Import File Submissions report to see if your file passed the format and validation checks. This report is displayed after attempting to import your file, and is available from the Reports Menu.
- If your file fails, it will not be uploaded. You will need to review the provided Format Checker Report, fix the identified errors, and reimport a file.
- If your file passes, it will be uploaded and data will be viewable through the edit screens and reports.
Note: If importing data, you must still go through the process of certifying your data. In order to obtain a file of the data in CBEDS-ORA, users have the option to export a data file. The export option is located from the “Advanced Features” option from the Main Menu and may be used to back up or save your data to a text file.
Slide 42 – Import and Export Screens
This slide shows screen shots of the import and export screens within CBEDS-ORA.
To import a file, navigate to the Import screen by selecting Advanced Features from the Main Menu and select the Import option. From the Import screen, select the Browse button. Select the file you wish to import, then select the Upload File button. Only text files that have been formatted to meet the CBEDS-ORA File Import Specifications will be uploaded. Please do not attempt to upload a Word, Excel, PDF, or other non “text” file type.
To export a file, navigate to the Export screen by selecting Advanced Features from the Main Menu and selecting the Export option. From the Export screen, select the Export Data button and save the file to your computer. If your LEA has IRCs, you will have the option of including or excluding these schools from your data file. For your convenience, the export screen contains a link to the CBEDS-ORA File Import Specifications.
Slide 43 – Available Reports
This slide contains the reports available from CBEDS-ORA. Depending on your LEA type (e.g., independently reporting charter schools or IRC’s), fewer reports may be available to you.
- Current year forms include links to blank CDIF/SIF forms.
- Completed CDIF/SIF forms display data that has been entered into CBEDS-ORA.
- Prior year reports display data that was reported last year.
- Summary reports consist of:
- A District Summary, which is a summary of all the data entered on each of the SIFs.
- A Summary of Current and Last Year report, which summarizes the data reported at the district level for each section and includes current and prior year totals.
- Section by school summary reports, which list each school and section totals.
- Other reports include:
- The Errors and Warnings report, which displays all of the errors and/or warnings that were triggered for your LEA.
- An Explanation of Errors and Warnings, which explain each error and warning and why they are triggered.
- An Import File Submissions report, which only pertains to LEAs importing CDIF/SIF data. This report provides the status of import files and whether or not they passed the format and validation checks.
- A Certification Receipt, which is only available after you have successfully certified your data. This report displays the date and time of your submission.
Slide 44 – DOCS Reporting Features
As previously mentioned, districts participating in the District of Choice program will have a separate menu item in CBEDS-ORA for accessing the District of Choice reporting features. These features include:
- The ability to key enter or update District of Choice transfer request and transportation data.
- The ability to view or print various reports compiled from reported data. Reports are available for data quality and verification purposes and include:
- A summary report, which displays the transfer request data, as well as summarizes all of the reported transportation data.
- A completed report, which displays the data reported for each section and each district of residence. The report also allows users to select which district(s) of residence to include on the report.
- An explanation of errors and warnings, which explains each error and warning and why they are triggered.
- An import file submission report, which provides the status of import files and whether or not they passed the format and validation checks.
- Lastly, CBEDS-ORA provides the ability for users to import and/or export data. Users with access to data files containing CBEDS data, either extracted from their student information, human resources, or other systems, may upload these files in order to bypass key entry. Once data is entered into CBEDS-ORA, users may also export the data to obtain a file of the data contained in CBEDS-ORA.
This concludes the CBEDS training. Hopefully these resources, as well as the contents of this training, were successful in providing you with the information you need to collect and submit accurate, timely CBEDS data. Should you need further assistance submitting your LEA’s CBEDS data, please do not hesitate to contact our office.