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”
The Senior Survey has been sent out to seniors in undergraduate degree programs who have applied or been approved for graduation in the Spring semester. The survey is emailed directly to each senior’s @ksu.edu email address. Please encourage your students to take the survey before it closes at the end of the semester.
The survey is designed to give students the opportunity to reflect upon their experiences and time at K-State. Results are used to improve the K-State experience for future students by identifying areas of strength and areas that need further development.
Prizes are available for students who complete the survey, including Alumni Association photography books and $15 K-State Campus Store gift cards.
Survey results of 1,718 seniors from 2015-2016 showed very positive results, including:
- 96% of respondents reported that they had a very positive (56.7%) or positive (39.3%) experience at K-State.
- 95.6% of respondents indicated that they definitely (68.9%) or probably (26.7%) would recommend K-State to others.
- 71.6% of respondents have a job lined up (48.6%) or will attend graduate school (22.9%) upon graduation.
- At least 94.9% of respondents felt that they made some or a lot of progress in:
- ability to interact positively with people who are different from themselves
- gaining a broad general education about different fields of knowledge
- ability to think critically (analytically and logically)
- understanding the ethical standards of their discipline or profession
- understanding themselves – their abilities, interests, and personality
- understanding of other people and their abilities, interests, and perspectives
- ability to participate as a team member
The entire 2015-2016 survey can be found here.
Find more information about the Senior Survey here.
The Athletic Training Program was recently selected by the Office of Assessment for the 2017 Excellence in Assessment Citation, which highlights exemplary assessment processes and practices at K-State.
Phillip Vardiman, director of K-State’s athletic training program and associate professor in the College of Human Ecology, said the collaborative environment in the program has led to its success. “It’s definitely a team effort,” said Vardiman. “There’s not one of us that can take full credit for this type of accolade. It’s something that we’re all really proud of.”
In addition to meeting the program requirements at K-State, the athletic training program is also accredited by the Commission on Accreditation of Athletic Training Education (CAATE). According to Vardiman, this has assisted the athletic training program in honing its assessment methods. “The big piece for us that is helpful is that we’re an accredited program,” said Vardiman. “We’re utilizing best practices… and selecting some of the items we feel best represent the areas we need to quantify for the assessment program.”
The Excellence in Assessment Citation was awarded to the athletic training program for the efforts and achievements in the following areas:
- Specificity and rigor in critical thinking assessments.
- Multiple rounds of assessment that provide feedback for students and document increased levels of achievement.
- Assessment tasks that reflect authentic, real-world learning expectations.
- Clear benchmark levels of achievement that expose specific needs.
- The use of results to guide instructional enhancement.
- Well-designed assessment of academic and professional integrity.
Vardiman said these areas are met through sequential learning. Students are taught hands on athletic training skills that are then used in their clinical sites, where they are evaluated by a preceptor. This method, said Vardiman, “is a unique undergraduate experience compared to other programs on campus, providing a real world scenario where there would be actual treatment and patient care.”
The students are taught to develop a deductive reasoning thought process. Athletic training students need to be able to assess a patient’s injury and from there, determine treatment methods. “That’s a sequential learning process that we go through and we’re able to assess each component as they go through it,” said Vardiman. Students in their final year of the program are assessed globally on their ability to evaluate and treat a patient from start to finish.
Vardiman has found Canvas to be helpful for course instruction and hopes to have the entire faculty using it to link the assessment methods to grading mechanisms by the end of next year. Currently, Vardiman is working on continuing to build the athletic training program, by supporting the undergraduate degree while expanding to a graduate program.
Vardiman has received multiple awards for his work in higher education. He was recently named the 2016 Kansas Athletic Trainer of the Year by the Kansas Athletic Trainers Society (KATS), and is a previous recipient of the National Athletic Trainers Association Athletic Training Service Award. Additionally, Vardiman served as the athletic trainer with the medical team supporting U.S. track and field athletes in Rio de Janeiro during the 2016 Olympics.
The award will be presented to the athletic training program at the Institute for Student Learning Assessment in October. For more information on the athletic training program, please visit: http://www.he.k-state.edu/fndh/ugrad/athletictraining/
Great ideas can often come from the strangest of situations. For Dr. Greg Eiselein, Donnelly Professor of English and Director of K-State First, the idea for a first-year experience program came about while working on the first task force for the K-State 8. One of the conclusions this task force made was that creation of a first-year experience program would be beneficial for new students. Several faculty members and administrators liked the concept and began meeting unofficially to discuss ideas and implementation.
Provost April Mason encouraged their work, which started with a pilot study to demonstrate the positive impact that a program like this could have. “From the very beginning of the first-year experience program, K-State First was committed to assessment,” said Eiselein. “We decided from the get go that assessment would be the foundation of everything we did.”
What resulted was K-State First, the University’s first-year experience program, which was launched six years ago and has had already some impressive results. Eiselein said that the four main areas of measurable success have been: higher retention rates from freshman to sophomore year, graduation rates and improved time to degree, higher overall GPA, and a greater level of student engagement.
Most importantly, said Eiselein, students are excited about the courses they are taking and excited about college itself. This has led to high engagement rates, with 84 percent of students reporting having an “excellent teacher” and 68 percent having an “excellent course” in the fall of 2016.
The student learning outcomes used to assess the success of the program are critical thinking, communication, community building, and application of learning. According to the K-State First website, these courses “have been developed and organized for students to achieve maximum success during their first-year.”
Departmental collaboration has been a key to the program’s success. Working with other departments to continue to engage first-year students in exciting courses is something many professors have been eager to assist with, said Eiselein.
Just six years after its implementation, this great idea continues to grow, as K-State First engages first-year students and prepares them for a great college experience.
For more information on the assessment methods used for K-State First, please click here.
The K-State Teaching & Learning Center has recently named 2017 as the Year of Critical Thinking. In keeping with these efforts, the Office of Assessment will host the second critical thinking event of March, “Designing Rubrics to Teach Critical Thinking.” This workshop will be led by the Office of Assessment’s Director, Fred Burrack and will take place on March 15th and 16th (repeat session) from 3-4 p.m. in Room 209 at the Union.
Critical Thinking in the context of an assignment or within a discipline is an expectation in most courses and programs. This session will explore how to assess student demonstrations of traits associated with critical thinking and provide examples of rubrics that can be adapted for a variety of assessment tasks. Participants will consider how students demonstrate critical thinking within their courses and programs and connect them to rubric design choices that enable authentic assessment of critical thinking.
More information can be found at the Office of Assessment events page and Twitter. To become a part of the critical thinking work at K-State, please plan to attend this event and engage on social media with the hashtag #MarchTowardCriticalThinking.
The event is free and no registration is required.