Part IV finishes the report by formatting charts and adding final touches.
Part III begins the process of creating the report, including the creation of measures and charts.
Part II demonstrates how to create dimensions, including steps to enter data manually, get data from Excel files, and connect to a data warehouse.
An earlier post presented a conceptual overview of using Canvas Outcomes scores in PowerBI. Today, we are presenting a four-part, step-by-step walkthrough detailing how to create a direct assessment dashboard/report in PowerBI. These videos present a variety of options for each step and are meant to be adapted to fit each user’s needs.
The first video in the series covers the creation of the Fact Table using outcomes data exported from Canvas.
New tools available to programs can facilitate collection, management, and analysis of direct assessment data. With these new tools, it is now possible for faculty to assess direct student demonstrations of learning as part of the regular grading process. Data collected in this way can then be automatically analyzed and delivered to those in the program responsible for assessment. When fully implemented, this process has the potential to reduce the amount of time spent on process, and afford programs additional opportunities to use assessment data to guide improvements.
The Office of Assessment can help programs implement these new tools and design custom reports that meet the program’s needs. This article describes using Canvas to collect data, but other options are available. The key is that assessment data is gathered at the student level, which enables connection to other student indicators and metrics. Continue reading “Automating and Deepening Assessment Processes using Canvas and Power BI”