Classic View:Ad Hoc Reporting > Data Analysis > Assessment Report
Search Term:Assessment Report
The BIE Assessment Report provides BIE district-level and NASIS state-level administrators the ability to analyze and interpret student assessment data previously collected by the BIE Assessment Data Mart tool. This tool relies on data collected by the Assessment Data Mart and does not retrieve data from any other sources or locations in Campus. Once generated, data represented in the report can be filtered, manipulated and viewed in a variety of formats that a user can externally export and share. Before using this report, review the following:
The Assessment Report uses pivot table functionality. A pivot table is a data summation tool often found in spreadsheets and other business intelligence software. Pivot table tools can sort, count and total the data stored in a table or spreadsheet, and then display the data in a new table or chart. See the Pivot Designer article for more information on pivot tables.
This report ONLY uses data stored on the BIE Assessment Data Mart table. Data not collected by the Assessment Data Mart is not included.
This tool is available in both BIE District Edition and NASIS State Edition sites.
Assessment Report (BIE)
Report Logic
BIE Assessment Data Mart
This report ONLY uses student data records from the BIE Assessment Data Mart's data table. If no records exist, or the data mart has not been created, this report will not work.
Student data records contained in a data mart are year specific. To include a year in the Assessment Report, there must be a BIE Assessment Data Mart created for that year.
Students:
Students marked as No Show are not included.
Students marked as State Exclude are included.
Tool Rights
Tool rights are required to use the Assessment Report. Review the following areas tool rights must be given to successfully use this report.
Recipients of a shared URL link must (minimally) have Read rights to Data Analysis, Assessment Report and Pivot Designer to follow and view a link that was shared to them.
Data Analysis Tool Rights
Current Look of Campus: Ad Hoc Reporting > Data Analysis New Look of Campus:Reporting > Ad Hoc Reporting > Data Analysis
Read
Write
Add
Delete
With Read rights users can view and select Data Analysis from the Index. Required to view shared links.
Write rights are not necessary.
Add rights are not necessary.
Delete rights are not necessary.
Assessment Report Tool Rights
Current Look of Campus: Ad Hoc Reporting > Data Analysis > Assessment Report New Look of Campus:Reporting > Ad Hoc Reporting > Data Analysis > Assessment Report
Read
Write
Add
Delete
With Read rights users can view and select the Assessment Report from the Index.
Required to view Shared links.
With Write rights users can save and share the Assessment Report.
With Add rights users can view ALL shared links.
With Delete rights users can delete shared links.
Pivot Designer Tool Rights
Current Look of Campus: Ad Hoc Reporting > Data Analysis > Pivot Designer New Look of Campus:Reporting > Ad Hoc Reporting > Data Analysis > Pivot Designer
The Assessment Report opens in Pivot Designer where a variety of features are available to assist users in sorting, analyzing and interpreting assessment data. To interact with the Assessment Report, users must have Read and Write rights to the Pivot Designer tool.
Read
Write
Add
Delete
Read rights allow a user to view the Assessment Report after the report has generated. Required to view shared links.
Write rights allow a user to interact with the same tools and features as the Pivot Designer when working with the Assessment Report.
Add rights are not necessary to use this report.
Delete rights are not necessary to use this report.
Assessment Report Editor
Before generating the Assessment Report, review and select all data elements and filters the report should include from the report editor. Selections made here determine which of the BIE Assessment Data Mart's data tables the report will use and provide additional filtering options to cross reference and analyze the student data. If the report has already been generated, and important data or filtering selections were missed, close the window the report generated in and generate a new report after all desired selections are made.
Assessment Report editor
Assessment Report Editor Field Descriptions
Field
Description
Data Source Required
Identifies the data table the report will use to generate results. Only one Data Source can be selected. BIEDMAssessmentVerification
Data generates from the Validation table of the BIE Assessment Data Mart.
BIEDMAssessmentCertification
Data generates from the Authentication table of the BIE Assessment Data Mart.
The authentication data table is a snapshot of the records in the validation data table. Reporting outputs may be different if the validation table was updated with a more recent snapshot and the authentication table was not.
**Only student data stored in the BIE Assessment Data Mart is included in this report.
Years to include in report Required
Identifies all the school years the report should include. When the report generates, years will display as an expandable dimension and can be filtered to a specific year(s).
Each year requires it's own BIE Assessment Data Mart. If a data mart does not exist for a year a report can not be generated.
Schools
Identifies which schools the report should include. When the report generates, each selected school will display as an expandable dimension. Filtering is available to include/exclude specific schools when viewing the report.
Test Subjects
Identifies which assessment test subjects to include in the report. When the report generates, each Test Subject selected will display as an expandable dimension. Filtering is available to include/exclude specific test subjects when viewing the report.
Add filters to include in report
Select any additional filters you would like to use when viewing the report. Filters selected here are become an available filter option in the report but are not automatically applied.
Generate Report
When generated, the Assessment Report opens in Pivot Designer in a new window.
View Share Links
Populates a list of all shared links in CSV format.
Delete Share Links
Deletes all shared links. Selecting Delete Share Links will override the URL's expiration date. Expiration dates are entered at the time the URL was generated and automatically delete on the specified date and time.
Generate the Report
Select one Data Source.
Select a year from the Years to Include list. Use the CTRL or SHIFT keys to make multiple selections.
Select a school from the Schools list. Use the CTRL or SHIFT keys to make multiple selections.
Select a Test Subject. Use the CTRL or SHIFT keys to make multiple selections.
Select a filter or multiple filters to add to the report (optional).
Select Generate Report. Report opens in a new window on a pivot table.
Grid View of Generated Assessment Report
Understand the Assessment Report
The Assessment Analysis Report opens in Pivot Designer where pivot table functionality can be used to sort, group, summarize, and count student assessment records pulled from the BIE Assessment Data Mart's data tables. By default, the report generates in grid view using default formats. Reporting dimensions (School Year, District, School, Test Subject) display in the first column along the left side of the grid. Each dimension can be expanded and filtered on to narrow down, manipulate and focus on specific data points.Additional dimensions, or labels, display in a row along the top of the report and include any previously selected filters from the report editor.
Assessment Report in Pivot Designer
Filtering
Filtering options are available and provide a way for a user to cross-reference and analyze specific data points. Users may find filtering necessary to compare yearly totals, understand the impacts demographics play in overall counts, and simply reduce the amount of data being displayed.
When a filter is applied, excluded data is hidden until the filter is either removed, or the report is closed. Filters are not automatically applied when the report generates and are not saved when the report is closed.
More information on filtering can be found in the Pivot Designer article under the section Understand Pivots.
Add a Filter
Filtering a Dimension
Select the gear icon to the right of the dimension header.
Remove the check mark from the fields the filter should not include.
Select Apply. All report counts will filter to only include student's who meet the criteria of the filter.
Remove a Filter
Select the gear icon associated to the dimension you wish to remove the filter from.
Select the "Select All" check box to mass select all boxes. The filter is removed when all boxes are selected.
Select Apply.
Assessment Report editor Filter Options
Before generating the report, additional filters are available for selection from the Assessment Report editor. Filters selected here are optional and are not required for the report to generate.
When the report is generated, any filters selected here will display along the top of the report as a 'Label'. A user must select the gear icon to the right of the label's name to apply a filter.
Assessment Report editor filters
Add a Report Editor Filter
The following steps only apply to the additional filter options available for selection in the report editor. Selections must be made prior to generating the report. Additional filter options can not be added once the report has generated. If a filter is missed, close the window the report generated in and start over.
From the Assessment Report editor screen, select all additional filters you wish to include. Once all data and filter selections have been made, select Generate Report.
After the report has generated, select the gear icon for the label you wish to apply a filter to. A pop-up window displays with available filtering options.
'All' displays below the name of a label when a filter is not applied. By default, filters are not applied when the report is generated.
Remove the check mark from the fields you do not want the filter to include.
In this example, by removing the selection from the 'N' (No) checkbox, the report will filter to only include EL student counts.
Select Apply. Report counts filter to only include student's who meet the criteria of the filter.
Note - If applying a filter to one of the report's default labels, ignore step one. Default labels can not be selected/unselected from the report editor and automatically display when the report generates.
Select the label you wish to remove the filter from.
Select the "Select All" check box to select every box. All boxes must be selected to remove filtering.
Select Apply.
Remove a Filter
Note - This process can also be followed to remove filters applied to any of the report's default labels. Default labels include: TestName, NASISID, Grade, Gender, RaceEthnicity, ParticipationStatus.
Charts and Graphs
Charts and graphs provide a way for users to analyze and interpret the data by viewing it in different formats. To view the information in a chart, click on the Charts icon and select from the options listed. Additional information on charts and graphs can be found in the Create Charts from Pivot Data section of the Pivot Designer article.
Charts and graphs respect any filtering that has been applied to the report.
Select Grid to return to the report's default format.
Example of Pie Chart
Format and Layout Options
Formatting and layout options are available to customize how the data in the report displays. Default selections are applied when the report is first generated. Additional information about Format, Options and Fields can be found in the Format and Layout Options section of the Pivot Designer article.
Format and Layout Options
Fields
Fields allow you to manipulate the order of how data displays in the report. Using the drag and drop method, users have control over the placement of all reported fields.
Fields
Values
To get a count of a data set, drag and drop the selected field(s) into Values and select Apply. A new column for the field will display in the report with student subtotals. To remove a field, drag and drop the field back to the All Fields list.
Editing Field Values
Rows and Columns
Using drag and drop, users can add and reorder fields to display the data in different ways when viewing the report. To remove a field, drag and drop the field back to the All Fields list.
Editing Rows and Columns
Report Filters
Using drag and drop, users can add fields to Report Filters as additional filtering options to use in the report. Fields added to Report Filters display as a label at the top of the report. To remove a field, drag and drop the field back to the All Fields list.
Refer to the Filtering section of this article on how to apply a filter.
Editing Report Filters
Options
Options allows a user to adjust the layout of the report including the display of subtotals and grand totals. More information about Options can be found in the Format and Layout Options section of the Pivot Designer article.
Layout Options
Format
Format options allow you to modify how cells represent data within the pivot table.
To access format options, click the Format button and select one of the following options:
Format cells - This editor allows you to control how text within the cell is aligned, what value is reported in the cells, how decimals are used, the current symbol used, any default null value you want the table to display, and whether or not you want data displayed as a percentage.
Conditional formatting - This editor allows you to set cell value thresholds as to whether or not the data is reported for each cell (less than or greater than a certain value) as well as modify the cell text size and font.
Right-click on any of the column headers to select from a list of additional formatting options.
To change the reported values from displaying as a Count to display as a Percent, right-click on any of the column headers and select "As Percent".
Formatting Options - Right-click on Column Header
Export and Share
Users may choose to Export the report to a number of external formats, or Share the report's URL with another Campus user. More information about Export and Share can be found in the Export and Share Pivots section of the Pivot Designer article.
Export
When a report is exported to another format such as PDF, CSV or HTML, the reported data elements are no longer linked to Campus' data tables. At this point, exported data is static and only represents the state of the data at the time the report was generated. Using the Export option, reported findings can be added to non-Campus tools for purposes of outside reporting or sharing with stakeholders who may not otherwise have access to it. Export can be used with any of the Charts formats.
Export Assessment Report
Share
Use the Share option to share a link of the current view of the Assessment Report with another user. The recipient of the URL must (minimally) have Read rights to the Assessment Report and Pivot Designer tool to view what was shared. Access to the report using a shared link will expire based on the date and time entered in the Share Link Expiration Date fields.
Share Assessment Report
View Share Links
From the Assessment Report editor, users who have been assigned (W)rite tool rights to the report can view a CSV list of only the links they have created by selecting the View Share Links button. If a user is also assigned (A)dd and (D)elete tool rights they will be able to see all shared links created by any user in a CSV list.
Delete Share Links
Users who have (D)elete tool rights or who hold the Student Information System Product Security role can delete all shared links by selecting the Delete Share Links button (all links will be deleted if Delete Share Links is selected).
Assessment Report (BIE)
Assessment Report editor
Grid View of Generated Assessment Report
Assessment Report in Pivot Designer
Example of Pie Chart
Format and Layout Options
