This builds on my earlier post (link here).
After my session at the OAME Conference (link to Presentation), a few folks asked me how I had put this together, so I’m going to give a brief run-down here. You’re always welcome to ask me for more information, of course, if I’ve been too brief.
I used Microsoft PowerApps — it’s a quick-and-dirty way to make an app that uses your existing data and then you can muck around with the data, add more and then store it somewhere else.
What’s nice is that the Apps are universal — they work on the laptop, iPad, iPhone & Android phones. There’s a web app version so they will work on a Chromebook too!
Then I needed someplace to put the data once I collected it. There are a lot of options here … you could leave it as an Excel spreadsheet. I’m just using an Office365 Site List — which I can download as an Excel spreadsheet to work with. This means I never touch the real data; I always work with a copy. I also create a Picture Library to store the pictures in, and put a link to each picture in my Site List. I don’t imagine I’ll use the pictures a lot — they’re just there for backup to reinforce my comments/assessment.
Now off I go to PowerApps … it’s an option when you visit http://www.office.com and log in with your Office365 account … or you can go there direct at the http://powerapps.microsoft.com site. I started from scratch because this started as an experiment in learning PowerApps and got accelerated when a teacher said he wanted the app done yesterday. Remember, there’s always an easier way than what I do 🙂
The PowerApps programs are based on “screens” so I have two screens:
1) a “choose a teacher/course” screen which asks which teacher is using the app and then, from the Excel spreadsheet, the app pulls up the courses for the teacher and they select the one they’re in at that moment.
The main sequence is RED — Choose the student (1) and the General Expecation (2), assign a value to the observation/conversation (3) since the Ministry Inspector wants us to be able to say if/how it affects their reported grade (0 indicates you’re not giving them a value obviously and then we use a 1-5 rubric at my school) then write a comment (4) in the Rich Text field since we sometime like to add emphasis and click SAVE (5). This pushes all this data into the List on Office365. If you want to do a Learning Skill instead of an Expectation, tap the SWAP button (1) and you’ll see the Learning Skills list.