Skip to main content

From “There’s an App for That” to “You Can Build an App for That”: Converting a Physical Review Process to a Digital Student Experience with PowerApps

Empire State College

Description:

The problem/opportunity: the need to quickly convert a paper-based review process to a digital experience.

As a founding program of SUNY Empire State College, a distance learning institution, the Harry Van Arsdale Jr. School of Labor Studies stands out for its longstanding on-site, classroom-based cohort model of education. In 2003, the School of Labor Studies instituted a mandatory, student-facing midterm portfolio review into their curriculum as an academic support and retention imitative. Portfolios were collected in class, stored in a floor-to-ceiling bookcase, and reviewed by writing coaches on printed, triplicate rubric sheets: one copy for the student, one for the instructor and one for the director of academic support, Sophia Mavrogiannis. However, with a student population of approximately 1100, formally aggregating and using that data each term was insurmountably challenging.

In Spring 2020 when COVID-19 shuttered institutions and classrooms across New York state, students and instructors scrambled to survive the sudden move to remote learning and Ms. Mavrogiannis cancelled the midterm portfolio review. Faced with lingering uncertainty about returning on-site and the limitations of a paper-dominated process, the director reached out to the Department of Educational and Emerging Technologies and presented her problem: converting a required, core curricular, a high-touch, paper-dominated, student-facing retention and academic support process involving approximately 1100 students, 60-70 courses, and multiple reviewers to a user-friendly, web-based process that also allows for data collection and analysis.

The solution: two mobile apps: one for student submissions and one for reviewers.

Through trial and investigation of free solutions, we discovered that by utilizing the Microsoft Power Platform, currently included in all O365 educational licenses, we could design and develop two Power Apps that required low code, basic knowledge of Excel-like expression language, and familiarity with user design (UX). None of us were coders or developed a mobile app before. In the end, these two apps, in concert with their Sharepoint home base, provided:

1) a simple interface for the students to attach, comment on, and submit their documents,
2) a robust experience for the reviewers to filter submissions, easily access students’ files, and complete the review using a built-in rubric form,
3) automated emails that were triggered by two actions: after a student submission and after the reviewer submitted a portfolio review.

These apps are highly effective and efficient solutions because:
- They’re accessible on a desktop or any mobile device.
- They’re flexible and can be used together in person or remotely.
- The repetitive nature of the reviewers’ actions allows the app to be simple but powerful.
- O365 automatically identifies the students and reviewers by their log in. Thus, it removes the need to manually input redundant data such as names and email addresses.
- It allows for a more responsive and thorough delivery of feedback to students and faculty.
- Automated emails can be easily set up with triggers and actions to keep students and instructors communicated.
- It is completely paper-free.

To complete this project, we took the following major steps:

We actively listened to and engaged with stakeholders to empathize and understand their needs. A simple example was how the students and reviewers identify their classes. In this case, we noticed they rely heavily on weekdays more than instructor name, class name, or course number. Consequently, that was the first field the students and reviewers got when inputting or extracting the information.

We studied the options, challenges, and constraints before building and promising anything. Initially, our stakeholders had already envisioned a solution (in their minds) on MS Teams and were pushing pretty hard for it. We almost fell into the trap of “give them what they want” until we made a good case for going with PowerApps instead. Cost was also an important constraint we had to abide by. All the information gathered thus far was documented in our project charter after every meeting.

We created a workflow to understand all the tools, offices, and necessary collaborators. After deciding to go with PowerApps, the next step was to bring together offices and expertise from Cloud Computing, Intranet Manager, Service Desk and the Office of Marketing and Communication to ensure we had the right network of support for ourselves and users on all ends of the app.

We sketched a rough draft of what the ideal solution would “feel” like in order to have a point of reference for the apps.

We prototyped directly on PowerApps with the guidance of a Microsoft Customer Engineer to quickly learn about the platform as time was not on our side!

We created a new Sharepoint site to house the student and reviewer data, and started with a new Canvas app from blank adding galleries, objects, etc based on the initial rough sketch and workflow.

We tested, tested, tested.

We finished the project by creating an Active Directory group for the labor students so only they could access the app, and a shared inbox for the reviewers so we could setup automated emails with Power Automate.

At the end, with some room for improvement and iteration, we achieved a high-end product and experience for our students with no additional cost to the college. We modernized and digitized the midterm portfolio review process, created a rich database with student portfolios and review results, removed the need for paper or physical presence, and gave students more mobility and flexibility to submit their portfolios.

App-based solutions like these are no longer exclusive and costly options. It is evident that student services must be as agile as other departments and able to digitize, record, and retain information in a rapid manner. Coupled with the mobilization of our students and the increased reliance on mobile devices, app solutions should be considered as part of the student services repertoire.

Reference Links, Research, or Associated URLs

https://docs.microsoft.com/en-us/learn/paths/create-powerapps/

https://powerapps.microsoft.com/en-us/blog/assistant-principal-builds-power-platform-solution-to-improve-reading-assessments/

Additional Metrics:

"As an educator who has had to use all kinds of digital platforms recently at several different institutions, I wish everything were as user-friendly as this! The app is a really efficient tool, allowing me to quickly and easily reach all the students with whom I work -- assessing their work, and even adding personalized comments." -- Elizabeth Weaver, academic reviewer

"It was beautiful! The students reported that ease and I found it to be so as a reviewer. I could easily toggle between screens; open and read the student essays; toggle back to the main review screen where we choose our assessment responses and make selections based on the readings. I could also make notes in the comment portion of the review screen as I was reading and then fill out those thoughts once I had finished all my reviews. I could go back and edit a comment or assessment if necessary (and it was necessary a few times). I can even go back now, months later, and see what was written. It’s a beautifully designed app."-- Lynda Crawford, academic reviewer

"As both a reviewer and an instructor, I observed from multiple perspectives the functionality and effectiveness of these apps, which have now innovated and improved the process for semesters to come. I heard firsthand from students on the ease of accessibility of the student-facing app and as a reviewer who has been involved with this process for over five years, I experienced this much welcome digitization of a process formerly dependent on paper. It must also be stated that these apps have not only made the midterm portfolio review process more efficient from all vantage points, but this is also a “green” initiative that has inaugurated a reduction in the use of paper and ink—from the triplicate carbon copy forms the reviewers used, to the physical folders in which students put their work, to the paper and ink used to print student papers and photocopy class rosters." - Jessica Donofrio, academic reviewer

“The only issue I had was with the restricted number of files that could be attached.” -- student

“I felt that the midterm portfolio submission was the easiest part of my college semester technology-wise. I am not very good with technology.” -- student

From the director of academic support: “The midterm portfolio review process is a critical part of the Harry Van Arsdale Jr. School for Labor Studies curriculum and support programming. I’ve spent years imagining a digital process, but I faced collegial resistance to that dream up until COVID forced our on-site programming to go remote. Suddenly, I had options. The result is a product that’s clean and user friendly for students, reviewers and me as an administrator. Carolina and Michael executed our big asks, and really managed our expectations well. The data abilities of this app are the most exciting parts of this revamped process because I can now collect, review, filter and meaningfully interpret a lot of information. We’re also capturing qualitative data from students—brief self-reflection on their writing-- in the submission portal, an important part of the process that was lost over the years.”