Training Overview #

Edit

To access your account settings, look for the 3 horizontal bars located in the top right corner of screen. This is sometimes referred to as the “hamburger menu”.

The OnDataSuite reporting layout screens are laid out into three separate sections. These sections will function the same regardless of the OnPoint section that you are researching or creating reports for.

1.  The Report Center
The report center allows users to query the tables of data that have been uploaded into the file center. While the layout of the screens all looks very similar it is important to remember the section that you are in will determine the level of data that you will be able to run reports on.

The example below shows the view from under the STAAR Grades 3-8 Assessment tab. This means all the values that are within this section will only pertain to the STAAR 3-8 files uploaded into the file center.

From this point in the system, users can query and create reports from all the years of STAAR 3-8 data that they have uploaded. To initiate this process click on the test subject table you wish to research in depth.  Once you have made the first selection a corresponding filter option will appear to the right of each selection.

Once you have completed your selection and filter process you can click the ‘Create Report’ button and the system will generate an aggregate report based on your selections.

2.  The Focus List Section
This section allows users to create a filtered overlay of selected students or staff from within the Report Center when a focus list is selected from the drop-down menu selector. The default value is set at the ‘All Student’ level. When a focus list is selected the found items from the related report center selections will only retrieve data for the students, or staff that were selected from the focus list.

Example: If you create a focus list of 100 At-Risk students from the drop-down menu selector and then select Math from the report center and add the criteria of students that did not meet the state standard, your report can only generate 100 or fewer students on the returned list.

3.  Custom Reports
In an effort to save users time, frequently used reported items from within each area can be found in the custom reports sections of each section of OnDataSuite. Reports are automatically generated when the user clicks the link.  Some areas may have expanded sections located within the custom reports area depending on the OnPoint area you are working inside.

Example of generated custom reports

Use focus lists to isolate a group of staff or students in order to look at the data pertaining to them more specifically.

Creating:

• Option 1: From a generated “list” of student or staff names, locate the “Focus List” tab just below the title of the report.

• Create New Focus List
  • The title may be edited
  • Select Submit
• OR
• Append List to Existing Focus List– This feature will add the students/staff to an already existing focus list
  • Browse to a current focus list
  • Select Submit to add
• Option 2: From a student’s profile dashboard page, locate the “Focus List” section at the bottom right corner

• Option 3: From the ‘Focus List’ tab (top black menu bar), use ‘Upload Focus List’ to upload a list of TX Unique IDs, Local IDs or SSNs.

• Step 1: Use the drop down to select ‘Focus List Type’:
  • Student
  • Staff
• Step 2: Use drop down to select ‘ID Type’:
  • TX Unique ID
  • Local ID’s (Student Only)
  • Social Security No.
• Step 3: Title focus list in ‘Focus List Name’
• Step 4: Use ‘Browse’ to find file and ‘Upload’ to load IDs to the data entry box
  • NOTE: The file to be uploaded should be a CSV file
• Step 5: Data Entry Box
  • Update IDs loaded from CSV file if desired
    • and/or
  • Type IDs into the blank box with commas separating each number
    • Tip: Use for small focus lists
• Step 6: Create Focus List

Utilization:

An ad hoc report may now be created using a Focus List in the Report Center for Student, Assessment, or Staff. The report will ONLY pull data for the staff/students on the Focus List.

• Select a Focus List from the Focus List drop down box.

• Then, create report as usual. (Select Category/Criteria)

Some custom reports also have the option to choose a Focus List as the data source.

Staff/Student Overview tab on Profile/Dashboard – access to profile student or staff details required.

• A Staff or Student can be added to or removed from an already existing focus list from the Staff/Student profile Overview tab.
• The Profile Overview will also show any focus lists for which this person is a member.

Locate:

To find a complete listing of the focus groups created, select “Focus List” from the black menu bar.

From here, options include:

• Edit 
  • Select members of the Focus list to remove
  • Share Focus list with other ODS users including User Groups
  • Edit the Title of the Focus List
  • Delete the Focus List
  • Duplicate the Focus List
  • Share the Focus List
• Upload Focus list:
  • Add new members to a Focus List
  • Upload a Focus List manually – (see above)

NOTE: Click on the title to display members of the Focus List

Report Center

Edit

Assessment Report Center

• Select the Type of Assessment data to review.
• 

Examples:

• STAAR EOC Report Center

• Algebra I
  • Criteria 1 = Did Not Meet (Filter = Yes)
  • Criteria 2 = Grade
  • Create Report
• English I
  • Criteria 1=ESL Program Type Code
  • Criteria 2 =Approaches
  • Create Report

Column Options allows editing and adding information to a detailed student or staff list report from different data sources and/or different years, and various submissions. (Located above column titles.)

• Use “Add New Column” to add a column(s) of data to the list. Format follows Report Center categories/columns.
  • Select a “Data Type”
  • Select a “Record”
  • Select a “Column” -may select multiple
    • Note: Click outside of dropdown list to return to the Add Columns box in the background
  • Select a “Year”

Click the  “Add ” button to place the new data at the bottom of the display.

Click “Submit Changes”, top right-hand side, to generate the report.

Save Column Set

Use the Save Column Set tab when you want to “store” 1 or more of the rows of data to be used for future reports.

1. First, select the row(s) of data to be saved by checking the box in the “Save” column.  NOTE: option to “Select All”.
2. Next click the “Save Column Set” tab.
3. Provide a name, or use the default for this set of data.

Save Years – to retain the year for which that data is being pulled. It is listed on the row selected to be saved.

Save Code Display type – to retain the type of display selected for the row being saved. (Code, Description, or Code and Description)

Load Column Set  – to add the “Saved Column Set” to the report.

1. Select Load Data Set
2. Select the title of the set of columns, previously saved, to be added to the report.
3. Click “Load”. 
4. All of the rows of data saved in this set will be added to the bottom of the display.
5. Click “Submit Changes” to view report with added columns.

Manage Saved Column Sets

View or Delete current saved rows of data.

To EDIT columns/rows on the report

• Relabel the Title of a row instead of using the default Title. It is a free form field.
• Use the drop down to select a different Year for the data.
• Data Set– Lists which file the data is pulling from
• Record – Describes which record/area the data is pulling from
• Submission – Identifies which PEIMS submission the data is pulling from
  • Example: Economically Disadvantage is reported in both Fall and Summer PEIMS. User can expect to see identification as to which submission is being pulled to display the data.
• Change the Display Type to “Description” or the PEIMS “Code” or both
• Select a row of data to be Hidden when the report displays
• Grouping allows the user to group/ungroup data to be displayed
• Apply Filter allows the user to deselect the original filter applied to columns that have been added to the report.  EXAMPLE:
  • Report originally created to look for fall eco dis students coded 01-Free for 18-19
  • After adding fall eco dis code for 17-18 using Add New Column described earlier, if check mark left on (filter applied), report will apply the 18-19 fall eco dis filter of 01 to the 17-18 fall eco dis code and will only return students who are fall eco dis 01 in BOTH 18-19 and 17-18
  • Remove check (filter not applied) on the 17-18 eco dis column and the report will return all students coded fall eco dis 01 in 18-19 along with the fall eco dis reported in 17-18 regardless of what the code was that year
  • Note: The students and the year in the original detailed student list cannot be changed
• Save – see section above
• To Remove a column of data, click the trash can icon.
• Reorder the rows by using the blue up/down arrows.

Add more columns from other sources, records, or years by repeating above steps

Support/Training #

Edit