With Remote Learning now happening due to COVID-19, and a lot of educational institutions diving into utilizing Microsoft Teams, teachers are now asking "When x happens, can y also happen?". A lot of these needs/wants can be completed through Power Automate in Office 365.

This Power Automate Flow takes a newly assigned assignment in a Microsoft Class Team, and also creates a new task in the Planner app for each student. There are several reasons for doing this:

- Students can see a list of their assignments in either the Planner App or in the Microsoft To-Do app.
- Students can add their schedule of current tasks in Planner to their Outlook Calendar

For those new to Flow, this has some cool stuff going on. You're creating variables, assigning those variable values from Parsed JSON, creating a condition, and filtering data too. Very cool. Basically, the Flow grabs information data from a New Post in the General channel of a Team, format's the data and sets some of it to user-created variables, grabs all the members (students) in the class team, and then based on the condition of whether the Team post was created by the Assignment Bot, creates a Planner task for each students, and also updates each task with the link to the Teams Assignment. Cool stuff.

In this Flow you will need to Copy/Paste the following expression:

addDays(variables('varDateAssigned'), 7, 'yyyy-MM-dd')

The "7" determines the due date for the Planner Task. In this case, 7 days after the Assignment was created. You can change that number if you want :-)

If the below pics are hard to see, zoom in and you should be able to see everything.

Happy #RemoteLearning!

​Empowerment has been a popular EDU buzzword for quite sometime now. Usually when I see it in my twitter feed, the term is being used in conjunction with "students"; "Empower students to do X with Y". Empowerment isn't a word I use loosely because of it's #EDU buzzy-ness, but I couldn't help myself using "empowerment" days ago while presenting at the 2019 CETPA (now CITE!) conference.

​My session wasn't focused on empowering my students through, it was showing the empowering capabilities of PowerApps. I've been using PowerApps in my music classroom for over a year now, and like other EdTech tools I've adopted over the years into my pedagogy (Surface, Miracast, OneNote, Power Bi), I can't see myself teaching day to day without it.

I was fortunate to have the expertise of Brian Dang (@8bitclassroom) on hand for my presentation. Without his help a couple summers ago, I'd still be using  less efficient methods to track my inventory and student achievement.

​With PowerApps, I have applications for assigning, tracking, and turning in my classroom inventory with my 240 students. This includes 160+ shared band and orchestra instruments, 250+ method books, instrument accessories, and 300+ classroom iPads. This is nothing new for a music teacher, it's just a part of the job. My previous methods included pencil/paper or a spreadsheet, but that was tedious, cumbersome, and ate up a lot of my prep and class time. There is probably some 3rd party inventory tracking service I could pay for, but I don't have the ca$h for that. With PowerApps, I was able to create my own custom inventory applications, designed to my liking that captured the specific data points I needed. It's a WIWIWIG (What I Want Is What I Get) platform. Sure, you can argue that every dev platform is like that, but the PowerApps Low-Code learning curve is so much easier for my busy teacher/husband/father lifestyle. 

I teach my middle school students Music Theory. Short answer: Music Notation is brand new language and ya gotta hit all 4 domains of language acquisition. Just say'n. Resources for practicing and reinforcing the concepts and skills I teach my students are limited, and will cost me more money to get more. I have my lessons and worksheets for students to practice on, but having to recycle them with my students I see for 3 years just feels bad. My 8th graders will get a worksheet they completed in 6th and 7th grade and that's because that's all I have ¯\_(ツ)_/¯. Sorry not sorry, and I'm not going to TPT to buy a some worksheets that are lacking the rigor I'm looking for. ​

However, since last school year I've been transferring my students' skill/concept practice of music theory over to an application I created in PowerApps. So far I have identifying/creating notes, building scales, and creating intervals. I shared my app to my students via my school's Office 365 tenant, so they just login to the PowerApps app like anything else in 365 and have at it. PowerApps runs on all devices plus the browser, so iPad, phone, whatever, it works. There are so many benefits to what's happening now I have to show you a list:

💯 My students have unlimited practice now. In class or at home. Regarding home, I don't assign them to use my app, they just do it themselves at night and over breaks. That's a win for me 😁

​💯 No more paper and trips to the copy room!

💯 The practice activity questions are randomized, so my students are never answering the same stuff as the student next to them. "Hey, what did you get for the third one?" does not work in my class. Now my students are working together, helping each other, and teaching each other how to get the correct answers.

💯 All the data being collected (student answers) live in my school's Office 365 tenant, not some other 3rd party service.

💯 Speaking of data, since PowerApps is WIWIWIG, I design the app activities to capture the data points I'm looking for. Students struggling more with Bass Clef? Ledger Lines? Tri-Tones? Leading Tones? I can see all that because I designed the data output.

💯 Student.Work.Is.Automatically.Graded.

💯 All the data get pumped into Power Bi so I can see how successful my students are doing. I can see trends over time, hotspots in my seating arrangements, and common issues.

💯 All the data is anonymized and shared back with my students to my liking.

I like to use rubrics now since I jumped on the grading-for-mastery bandwagon. This takes more time rather than marking stuff correct/incorrect and coming up with a percentage. Speaking of time, grading my 240+ students takes about….forever. Usually I'm trying to get through grading their work so fast that I don't spend the time needed to keep track of the issues I'm seeing. There are other 3rd party rubric tools out there I could use, but nothing I've seen fits my rubric-ing style, so I made my own rubric scoring tool in PowerApps.

​My rubric app adapts to the domain I'm grading. If I'm looking at my students' written work, I choose  "Writing" in my dropdown, and now all my mastery standards change on the apps' screen. Each standard also has a list/combo box picker of common issues I can select from as I'm grading their work. So, I look at my student's work, I move the slider to give them points for that standard, I select the issues I'm seeing, then hit save. Easy-Peasy. If I'm scoring a performance activity, I just switch the domain to "Performance" and my app adjusts all the mastery standards and coinciding issues to reflect it. All the data gets saved to me, I pump it into Power Bi for analysis, and I can export/import scores into my LMS.

​I'm at the point now where I can build an app in a weekend to use during the next school week. It's really that easy, and the PowerApps team is working to make the learning curve easier all the time. Do a search on YouTube and you'll find all sorts of people in the PowerApps community making videos to teach and help you out. Follow the #PowerAddicts hashtag on twitter and you'll find a wonderful community of insightful people willing to lend their expertise. PowerApps has empowered me, allowing me to create the apps I need to work more efficiently, improve my pedagogy, and get more insight on my students' learning and progress. 

Recently I was at the TCEA Educational Technology conference in Texas. I was there with the assistance of the MIE Expert program to present my  session on using Power Bi for student data analysis. This is my 5th time presenting this session; I've also presented the same topic at 2017 Fall CUE, 2018 NCCE, 2018 Spring CUE, and 2018 CETPA. Every time my session changes a little bit because the data has changed and I have more examples of actionable pedagogy based on the data. However, this time at TCEA there was a much bigger difference, and it wasn't related to me. I was one of 3 Power Bi sessions at this conference! Three! I'm used to being the only Power Bi anything at conferences I attend, so this was a pleasant surprise to see. I've been raising as much Power Bi awareness as I can for the past few years, and it seems like now we're moving into the early-adopter phase of this educational innovation. 

I got to be honest though, as much as I love using Power Bi, PowerApps has recently been hogging my free-time attention. I've blogged about creating apps to help alleviate the complications of my classroom inventory management, but lately I've been developing for pedagogy. I teach a lot of music theory in my classes (by "a lot", I mean more than the typical middle school classroom). By the time my students head off to High School, my 8th graders can create Intervals, Triads, Scales, and can use all that knowledge to create polyphonic music using both relative Major and Minor scales. When it comes to teaching all this theory pedagogy, I have OneNote Class Notebook and StaffPad to create custom assessment exercises, or I can use other assessments I have from Finale or Alfred. This is good practice for my students, but it is A LOT of grading on my end.

Just the other day my students were working on an Interval worksheet (identification) with 24 different Intervals on the paper. I have 100 students completing this work, so that's 2,400 Intervals I have to grade for one assignment on one day. Sigh.... So, for a few hours at night I have to go through each worksheet, quickly scanning over them just to see if my students' identified each Interval correctly, the do the math and give them a grade. Alternatively, I could get a couple students to grade them for me (I don't do this 😉). Regardless, because in both instances I'm trying to quickly get through this tedious grading exercise, I probably don't spend enough time looking at my students' answers to do some analysis and find out WHY my students are getting wrong answers. Is it because they didn't count the lines and spaces of the music staff correctly, or did they miscount the half steps between the two notes? Are these careless mistakes, or is there a trend going on? Figuring that out takes even more time ☹. ​

But, now I have PowerApps 😁
 
Over winter break I started brainstorming in my head how I could create music theory activities in PowerApps, and not for stuff low on Bloom's totem pole like identification, I'm talking about creating. That's really what we want our students to do with the knowledge and skills we teach them. "I've taught you, now go prove you understand by creating something!" Working on previous PowerApps, I gained  some understanding of using variables which really helped out in the design process of the music theory activities. It also really helps  that music notation has a bunch of math going on based on note placement and value too. I could create an assessment activity where my students manipulate music notes, submit an answer, and I get to collect all the assessment data I want (because I'm the designer and I know what information I want from my students' answers 😉), and then dump all that data into Power Bi for automatic grading and analysis. Did you read that? Automatic grading and analysis. So I got to work, and within a few days I had my first assessment activity for my students.

​My first assessment related to what my 7th/8th grade students were currently learning back in January; creating Major and Minor scales given a tonic note and using the Half Step/Whole Step formula related to both modes. This activity reinforces their knowledge of Treble and Bass Clef notes, Half and Whole Steps, Enharmonics, basic Intervals, lays the groundwork for establishing a Key for a piece of music, and also helps to explain the whole reason for a Key Signature. Normally this is done through paper and pencil activities, and also takes forever to grade.

Creating the app was fairly straight forward. Create a music staff, clef sign, and a whole note for my students to manipulate. PowerApps doesn’t support drag n drop, so I created a control for the first whole note. Using the control a student could raise/lower the note and add a sharp/flat/natural. When that was complete and ready to duplicate 7 more times, I realized my setup would be too excessive. Instead of having a control for each note, I wanted one control that could manipulate each of the 8 notes, depending on which one was selected. I used context variables to make this happen. After my 8 notes and control were set, I had to figure out the instructional design process of:

1) Teacher assigns scale
2) Student sees assigned scale, creates scale, and submits scale
3) Student no longer see assigned scale because it has been turned in.

To figure this out I used some knowledge I recently gained on creating star-schema data models. Each assigned scale would have a primary key in one data table, and on a separate table my students' submissions would include a primary key (created on their submission). If a match existed, that scale was "turned in" and wouldn't show up on the screen anymore. Cool stuff.

​I took a couple days to beta test the app/activity with my students and get feedback. They used their classroom iPads, running the app through the PowerApps mobile app or in the web browser. We discussed what worked, what didn't, and how could it be better? Overall the feedback was positive and I made some changes to the submission process to avoid accidental submissions by the students. The good news is since all my data was going into Power Bi, I could filter out those beta testing days so they wouldn't count towards the students' assessment score. Speaking of Power Bi, that was the last step in this process. Now that my student answer data was coming in, I needed to create my algorithms to get the insight I wanted and organize the data in a meaningful way for my students and me.

​Numbers don't lie, and that's what we saw. Some students had trouble with their clef signs, some were struggling with the basic ascending intervals of the notes, and others weren't counting their Half Steps between the notes correctly. When students saw this information in Power Bi on their end, they were able to filter out their answers to see how they were doing and what mistakes they were making. We had some good conversations in class reviewing the knowledge and skills they needed to successfully complete the scale creation activity, and as the data shows, they've gotten better over time. And yes, creating this whole setup took hours, hours that I could've spent grading paper and pencil worksheets, but now that I've got a super time-saving resource that challenges my students' learning, automatically grades, gives us the insight we need, eliminates photocopies, and I can reuse it now whenever I want.

​It hasn't ended too. This past week my students used my new music theory PowerApp to complete another activity, creating Intervals. Not basic ones, but Major, Minor, and Perfect Intervals. For this activity, I didn't want my students to be working on the same Interval at the same time because we sit close to each other and they have wandering eyes. Using a timer control and the Rand() function a few times, I created an algorithm that would create 10 random intervals for my students to complete. My students navigate to the correct screen, hit the button, and now have 10 Intervals to create that don't match anyone else in the classroom. The intervals differ in Clef Sign, Direction, Root Note, Accidental, and Interval. Students' answers get dumped into Power Bi, and now we can see more than just if they got it right/wrong, but what mistakes did they make to get it wrong. Once again, cool stuff.

​So far my students have submitted 723 scales and 1367 Intervals that I didn't have to hand grade. They're better at Scales than Intervals, and I know which students I need to revisit concepts with so they can successfully create these digital music theory artifacts. Future steps include a Creating Major/Minor Triads screen, and a Creating Treble/Bass Clef notes screen for my beginner students. I also need to create a method for my students to track their music theory mastery based on the numbers they're getting in Power Bi. This is related to Sonny Magana's T3 framework, and will probably involve my students using Excel 😁. In some good news I also just figured out (finally!) how to create a Report Tooltip in Power Bi, so my students can get the personalized (and anonymous) data about their progress faster.

​I think I have a new EdTech conference session I need to start submitting during the proposal process: PowerApps, Power Bi, and Pedagogy

“It's important that students engage in the process of designing digital platforms and tools as a means to generate robust solutions to problems that matter.”
 
That's from Sonny Magana's recent book Disruptive Classroom Technologies: A Framework for Innovation in Education. It relates to the 3rd tier of his T3 Framework: Transcendent Technology Use, where he discusses how technology can be used in the classroom for the meaningful application of inquiry design and social entrepreneurship.
 
It's been 5 years since the launch of Code.org and the Hour of Code movement, and we just finished celebrating Computer Science Education Week. Two of my beginning music classes did their Hour of Code activity, while two more are waiting until after their upcoming concert this Thursday. Every year I poll my 6th graders; "Who has already done Hour of Code before?" and every year more and more students are raising their hands. It's wonderful to see that after these five years more teachers are aware of HOC and are making time for their students to participate in the activity. By now a lot of us know how important computational thinking and computer science concepts are for students, and that getting their hands dirty on the keyboard doing coding activities is a great experience for their CS learning. But what happens after that? According to Magana, students should use the available coding platform resources and new skills to solve "Wicked Problems," and I agree. Don't just make something, make something that's useful to you.
 
What about teachers though? Here we are, stewards of Computer Science Education Week and Hour of Code, promoting its importance and creating clubs at our schools, but what do we do as we also acquire these same skills and understandings of computer science? I'm in my 15th year in the classroom, and I've seen many "Wicked Problems" inside and outside of the classroom that affect my pedagogy and work efficiency. As a teacher and CS advocate, I'm supposed to design and provide the right environment so "students engage in the process of designing digital platforms and tools as a means to generate robust solutions to problems that matter", but what about me? Can I “engage in the process of designing digital platforms and tools as a means to generate robust solutions to problems that matter” to me? As more and more educators learn CS concepts and skills and realize the potential of what they are capable of creating, where can they go to take an idea from their head and code it into a functional application curated for their professional needs?

Last summer I met Brian Dang at his UCI PowerApps Hackathon. He's a former teacher who now works at Microsoft in the PowerApps wing of Office 365 Power Platform Apps. I had been following the development of PowerApps for a couple years, spending free time during the summer reading up on its documentation and messing around in the platform. However, in all of my studying I was never able to figure out how to write data to a data source in the platform. I already had experience designing and creating applications from my master’s degree at CSULB, so I already knew how to design and create a user interface with all the available controls, but I just couldn't figure out that pesky Patch function on my own. Brian helped me, explaining and showing me how patching and context variables work, and the flood gates in my brain began to open. I've had application ideas stuck in my head for a while, ideas that would solve my pedagogically-wicked problems, and now PowerApps was going to let me code them into reality.
 
PowerApps, along with Power Bi and Flow are a part of the Office 365 license my school district provides to me. It’s a "Low Code" application development platform that runs in the browser and utilizes resources available in Office 365 like SharePoint lists, Excel file tables, Flow recipes, the Active Directory, but can also connect to other third-party resources (like your SIS 😉). In the past I've written about my experience using Power Bi for student data analysis. PowerApps is the other side of that big picture. I’m using it to create applications for classroom student data collection.

​The first two I created were not directly related to student achievement. I had a bigger Wicked Problem on my mind; my inventory. I currently have 85 wind instruments that are shared between two band classes (around 50 students each) and 78 string instruments shared between 3 classes (around 50 students each). In my situation, for example, one Violin is used between 3 different students throughout the day. That's not really a problem in the classroom, but when my instruments start going home so students can practice after school, I need to know who has what and at what time. I also provide my students a method book at the beginning of the school year. The wind players need their own mouthpiece and may also need a ligature or neck strap according to what they play. I have a lot of inventory that I distribute and need to keep track of so at the end of the year I can collect it all back and hold my students accountable. In the past I used paper/pencil and eventually moved to OneNote and Excel spreadsheets to keep track of everything, but I was never satisfied with those solutions. Creating my records was very time consuming, eating into my class instruction time, and revisiting my records throughout the year for new and exiting students was a cumbersome process trying to figure out what was available and what was needed....during class. These were my own wicked problems, and this year I solved them with PowerApps.

​I created a PowerApp that turns my smartphone into a barcode scanner for collecting instrument checkout records, and it has made this after-school routine a streamlined stress-less process for my students and me. I've previously blogged about using a Bluetooth barcode scanner paired with my phone, entering in the scanned text strings into an Office form. This process worked and got the job done, but it wasn't the best solution. The Bluetooth scanner wouldn't work outside in the sunlight while I was on gate duty, sometimes it had connection issues or just wouldn't read my barcodes, and the process wasn't quick. However, this year the routine is a breeze using the new PowerApp I coded. My smartphone's camera captures the barcodes and the data is automatically written to a SharePoint list. Within the app I can also look up previous records to see which student was the last to check out a particular instrument. No more opening up and searching through a spreadsheet. Now I can just type “Violin 19" into my app and "hey, looks like it was Suzy Q who checked it out two days ago and hasn't brought it back from home yet." I'm saving time now, and my students can check out and get out my door faster to their waiting parents. That's important now since I now have about 20-30 students on average swinging by my room after school to grab their instrument and take it home.

This year I've been collecting my school's old 4th Gen iPads we've had for 5 or 6 years. My school is now a Chromebook school, but I prefer tablets over laptops in my desk-less classroom (plus inking and OneNote of course). Four of my five classes are now 1:1, so that's another inventory item I must keep track of. To help streamline the assigning of instruments, accessories, method books, and iPads, I created a PowerApp to help me filter through my inventory lists and assign/select materials for my students. The app is connected to and pulls in my inventory item lists that are stored on SharePoint in my district’s Office 365. My student roster list is saved to an Excel spreadsheet saved in my OneDrive, and also gets pulled into my app when I open it up. In the app, my dropdown controls act as filters for these lists, allowing me to quickly get to the items I need to see. I coded the app so items on the lists that have already been assigned for that given class period are pink, so I know not to select them. All I have to do now is select the period I'm in, select a student, select the items they're getting, and then hit the Assign button. The selected items are combined into a record that is saved to another SharePoint list (which is then incorporated into my Power Bi algorithms afterwards 😉). Within the same app I created a separate screen to lookup my students and see what materials they've been assigned (iPad #245, Clarinet #10, Clarinet Method Book 1 #17). This really helps when a student's book is missing (they left it in my class) and he/she can't remember what book number they have. I just open up my app and lookup their record. Using my inventory Power App (that I coded myself 😁) this year, assigning materials has been super easy and a much faster process than previous years. ​

I've coded two other apps so far; one for my school's PE department, and another that can be used school-wide by my school's faculty to better track student tardy data…but this blog post is already too long to talk about those. I have other ideas forming in my head too, apps I can create and incorporate into my music classroom to expand my pedagogy, track mastery, and collect data related to classroom management. PowerApps provides the development platform to design and code my ideas, and Office 365 provides the data storage resources I need. All these resources are sitting right there in my district Office 365 license.
 
So, I've hit a point in my career where I'm able to apply the CS skills I've picked up over the past few years to create solutions to problems relating to my job and pedagogy. This idea is what we want students to do; use their learned CS skills to solve "Wicked Problems", but at the same time, let’s not forget about teachers. Teachers are also learning and acquiring CS skills, and they have their own wicked problems they would like to solve too. With the continued push for CS in education along with the continued development of user-friendly app development platforms, will teachers in the future become their own problem solvers by creating applications that fit their exact pedagogical needs, rather than rely on third party software vendors that may or may not? PowerApps gives me the tools I need create solutions to my specific pedagogical problems, and if you have a district Office 365 license, you should check it out.

This is part 4 of a series of posts I'm writing on my past school year using various edtech tools for data-driven interventions.

I first learned about the Iron Chef activity from Jon Corippo. You put kids together in a group, give them a topic to research, and then give them twenty minutes to throw together a slide deck before they get up and present. It's a fun activity, but my students and I weren't ready to do this whole process in one or two class periods. This whole time I was slow cook'n the process, getting them ready for their collaborate group project.​

At this point I had placed my students into groups based on their neediest/lowest performance category (Pitch, Rhythm, Articulations, and Tone). Their next assignment was to collaboratively work together to put together a PowerPoint slide deck that generally focused on:

• Their instrument(s)
• Their performance technique category, such as:
  • How do you achieve this technique on your particular instrument?
  • Common mistakes
  • Good habits​

​Assignment details were located and distributed through OneNote, however this time I created a specific collaboration section for each group in the Collaboration Space of the Class Notebook and distributed each specific group page there. That way the groups had access and could collaborate together on their assignment page, but couldn't mess around with any other groups.

​Regarding the slide deck file, normally in an Iron Chef activity one kid in the group creates the file and then shares it to their colleagues and the teacher, but I didn't want to do this. My students didn't have enough practice with that particular skill and I wanted to avoid any hiccups related to it. In a perfect world/classroom I would have been able to create this assignment in Microsoft Teams, attach the PowerPoint template file I had created for each category group, and assign it to the group members thereby taking care of all the cloud/file permission stuff. Alas, my district still hasn't turned on Teams for the students yet ☹, so I took the matter into my own hands. In my OneDrive I created a folder for the project slide decks and created a template PowerPoint file. Basically I just put some directions on the first slide. I then just copypasta'd the file until I had enough for each group, and changed the title of each file to reflect Group 1, Group 2, etc. I then created a sharing link with editing rights for each file and copypasta'd that onto the corresponding OneNote group assignment page. This way my students could click on the link to get to the PowerPoint file in the browser, then click on the "Open in PowerPoint" button to open up the file in the iPad PowerPoint app.

After that my differentiated collaborative group project was ready to go. For this project I gave them a couple weeks to get it done, and I gave them more class time to sit in their groups and work together. A few students were already behind on their previous assignments, and quickly realized how much they immediately needed to catch up. I also experienced seeing some previously-unknown leadership skills being used by students that usually are content sitting in the back of their instrument section and playing just enough to get by. That was cool.

​

Feedback
 
Fast forward a couple weeks. Instead of having each group get up and present in front of the class. I assigned the students to peer assess three of the other groups' slide decks. In order to get this done I needed to give the students viewing access to all the other groups' slide decks, and keep everything organized so there wouldn't be any tech hiccups. I first created a copy of each group's PowerPoint file and saved them in another folder in my OneDrive. I didn't want any last-minute-way-past-the-deadline-and-we-didn't-finish editing being done during the peer assessment process. I then navigated to the <iframe> embed code for each file and copypasta'd it into a separate Sway. I used Sway so I could also embed the Peer Assessment Form and the directions and keep everything centralized. Then I took all the viewing links to each Sway and put them in OneNote. I created a table so each student could find their group and then click on the corresponding link to get to the other group's  Sway project page. When the OneNote page, the Sways, and all the links were ready the students came in one day and started peer assessing their classmates' collaborative work. Their peer assessment scores were inputted into a Form, which of course I then uploaded into Power Bi so I could create a feedback chart to give back to the students afterwards.

​This whole slow cook'n process took over a month. It was during #EdTech conference season, so my traveling to various conferences definitely slowed down the flow. Plus I was doing this for the first time, so I was creating all these new OneNote pages, Sways, Forms, PowerPoint files, and Power Bi charts as we went along. We also weren't working on this everyday. We were rehearsing, practicing, doing our theory, and other various classroom activities throughout the weeks. In the end my students had completed some data analysis, reflected on it, did research on how to become better at their particular performance technique deficiency that corresponded to their instrument, then collaboratively worked together to synthesize that info and create a slide deck that presented the relevant information. I enjoyed brainstorming and designing the process, and I enjoyed seeing their work. Most importantly my students were practicing the 21st Century skills they will need when they get into high school.

We still weren't done yet though. My students had reflected and researched on what they needed to improve upon, next they would have to put it into practice...

This is part 2.5 of a series of posts I'm writing on my past school year using various edtech tools for data-driven interventions

,After my students completed their first round of Flipgrid recordings and peer assessments, I had rows of data in my Form/Excel files stored in my OneDrive. Now it was time to set up my Power Bi report that I would share back to my students. For this project I was using the Power Bi Desktop application, and for several reasons:

• I could import multiple data tables from various Excel spreadsheets into one Power Bi file.
• Creating relationships between data tables in Power Bi is super easy.
• The desktop app includes a Query Editor. This means I could make the changes to the data I needed to make without changing the original data stored in the Excel files.
• I gave me the ability to hide table columns that have identifiable information like my student's name, SID, and email address. People wouldn't be able to  see that information if they selected "See Records" in a chart.
• I could create new columns in a data set and write formulas for them.
• It included some visual formatting tools I wanted access to, like "Send Backward"

There are a couple methods of getting and installing Power Bi on your PC, but if you have a Windows 10 machine, I recommend getting it from the Microsoft Store. That way you'll automatically receive updates and won't have to do any monthly manual updating yourself.
 
My Power Bi file lived locally on my Surface Book in my work OneDrive in the same folder as my Form/Excel assessment files. I did this to help me keep my stuff organized, but it turns out keeping a Power Bi file in my work OneDrive space allowed some automatic data updating to happen in the background. More on that in a bit.
 
Once I was in my Power Bi file, I queried my assessment data using the Get Data button and selecting my Form/Excel files. After bringing the data tables into the application I had to do a few things to get my visuals to look the way I wanted them to look.

I had rubric scores for performance categories, but I also needed the scores added up (maximum 25 possible) in a separate column to get a Total, and then multiple that number by 4 to get a Score in another column. In the past I would have done this in Excel, but now I can leave the original data tables alone in their Excel file and do all my edits in Power Bi. I clicked the New Column button, wrote my formula for that column, and voilà! Done.

Since I was using alias codenames on my shared report. I had to connect my Peer Assessment data table (that have my students' names) to my Alias table (also has students' names) by creating a relationship between them. From the Relationships view in Power Bi, I found which columns have the same values, and it's as easy as clicking on one column and dragging the now visible line to the other column. SOOOOO much easier than Excel.

My students did a big Fall chair test assessment. Every student performs in the class and receives a peer assessment from every present student in the room (around 50). I created a new peer assessment form for this, because I was asking some new questions, but now a I had two separate sets of peer assessment data. My Flipgrid assessments and my chair test assessments. I needed these data sets together, so I could keep all that data in the same visual and keep it linear. Thankfully, Power Bi is awesome and can do that. I opened the Query Editor and used the Append button to combine the two tables into one. I had to do some editing of the original column names, so the program would see the match, and silly me also forgot to give the chair test assignment title a number at the beginning. No problem, I just did a find/replace, changing "Honor Band Audition" to "3 - Honor Band Audition". Now my data visual wouldn't lose the progressing linear awesomeness I had created.

This was a new peer assessment question for the Fall chair test. Students would choose two, and then I wanted to show the frequency of the chosen options in a word cloud. It worked, but I had to take some steps to clean up the data. The original answer data would format both student-selected options as "option;option;". For my word cloud to work, I needed to get rid of the semi-colons and keep a space between the words. I made this work in the Query Editor. I duplicated the column, and then used the Extract button to get rid of the semi-colons and add my space. Now my word cloud was set ?

At this point everything worked perfectly as I created my visuals. I really like the visual editor in Power Bi, and every update (about once a month) it gets more intuitive and also gets new features. It's really just dragging and dropping table columns onto a canvas, choosing the right visual, and then making it look visually appealing and intuitive for students. My assessment report page included both the Peer Assessments and Teacher Assessments, comments, focus areas, instrument checkouts (from another data source/point I was collecting), and slicers so my students could filter their data out and compare it to their grade level(s) and section(s).

When I was happy with what I created, I clicked the publish button in the desktop app. This process would take my report file and send it to my Power Bi space in my Office 365 account. After visiting the published report in the browser, I "published it to the web" which created a public link that I could share with my students. All my data had been anonymized and hidden, and you better believe I constantly checked on this throughout the year. Pasting the link on a page in our OneNote Class Notebook automatically embedded the webpage/report on the OneNote page, which made it visually super easy for my students to find and load up.

Because I chose the "Publish" button on the desktop app to send my finished report up into the cloud, I still had to manually update the report as assessment data was coming in. I had a couple options for this:

• I could open up the Power Bi report file, click refresh, let it pull in all the new data from the Form/Excel files, then hit Publish and send the updated report back into the cloud.
• I could install and use the Power Bi Personal Gateway application onto my computer. This program would let me create scheduled times where the Gateway app would do all the updating/syncing process in the background on my Surface and also let me start the process manually in the web.

 
I chose the latter but did run into some network firewall issues on my district Wi-Fi where the Gateway app couldn't connect to the internet. So when I wanted to update the report, I would hop over to my personal hotspot, run the update, then hop back over to my district Wi-Fi.

Something I didn't realize I could do at the time was start the publishing process from Power Bi in the web. Here it is:

• Use Power Bi desktop to create my report. Save my file to my OneDrive.
• Go to Power Bi in the web, hit the "Get Data" button, and find the Power Bi report file. Upload it to Power Bi.
• The report is published to my workspace, just like the other method.

The benefit of this method is that it allows for automatic hourly updates without needing the Gateway app, but I'm not exactly sure it can connect to my data sources to pull in new data. I have to test this out. If it works, it'll be my new process.

Throughout the school year I added more and more assessment data to the report file. I designed a cool string intonation activity with my string kids, we did music theory assessments, instrument checkouts, and ELA stuff too. I also had another Power Bi report file running at the same time that was only for me to see. In this separate report I could see student names, create quick charts, and mess around with my data to see if I could get more information out of it, like how do my student's peer assessment scores for Johnny's Flipgrid recording compare to my assessment scores for the same recording? After I find those differences, is there a student whose scores are constantly irregular? If so, what does it mean, and what do I do? Interesting stuff. My personal report file was also my testing ground for writing my column formulas that I would use in the public student report.

My public student report can be seen below. This is what was shared with my students. Performance assessment data is on pages 4 and 6.

Putting this together was a learning experience. I would run into roadblocks as I added more and more data to the report, and I would get stumped from time to time writing the algorithms I needed. I found help by reading/lurking the Power Bi community forums for answers, and the more I practiced, the better I got. When this upcoming school year begins, I'll already have a working system with working algorithms in place.
 
This was only a step in the whole data intervention process though. Now that the data was mapped out, what would the students and I do with it? That part will be up next ?

This past school year I took a classroom routine and translated it (I'm currently reading Sonny Magana's T3 book 😉) by integrating Flipgrid and OneNote into the process. This allowed for an increased frequency of student performance submissions, along with the resulting assessment scores from class peers and myself. I was pulling in lots of data. Rubric scores from students and myself, and plenty of feedback comments. The goal was to effectively use this data to help drive instruction and interventions with my students. Based on my previous experience messing around with and sharing student data, I had ideas for what I wanted going into this project:

While I was brainstorming how I would get all the pieces in place to make this work, I had ideas regarding my data organization and management setup:

For this project I used my go-to data tools I've been messing around with for a few years, Excel and Power Bi. Both are a part of the Office 365 suite, and can connect and talk to each other through OneDrive making the this whole process a lot easier. Excel files are where all my data sets would live, saved into a folder in my OneDrive. Power Bi was used for two different reasons. Data organization and presentation. It brings all the different sets of data together, organizes them, connects them to each other, and allows  me to write my own algorithms to get the numbers I'm looking for. At the same time, it provides the canvas and tools for me to design a data visual report that can be shared back to my students. Creating the workflow I wanted required some technology knowledge (TK!) on the different ways the software programs could communicate with each other. I worked my way backward, starting with Power Bi.

I created one Office Form for each set of assessment data set per class (Band or Orchestra). One for me to use, and one for my students to use. I did this so I could later do some comparisons between the two data sets in Power Bi. I screen clipped pics of the peer assessment rubric I had previously created, and dumped them into my Office Form. Each rubric category (Pitch, Rhythm, Articulations/Bowings, Tone, Posture) was a multiple choice question in my Form. The choices were 1, 1.5, 2, 2.5, etc. all the way to 5. I also had a comments question too, but because of the way the data would be shared with my students, the comments couldn't include any identifiable information. I had a talk with my students about not inputting any identifiable information such as name, gender, grade, and even a mention of the performer's  instrument. It worked, and if a student did accidently type in some identifiable information, they let me know and I was able to delete the string of text from the data set (in the Excel workbook).

I needed a way to get Power Bi to see relationships between my two assessment data sets, so I had to make sure the resulting data tables had columns with the same values. One of the questions I included was "Who are you assessing". This was a multiple choice question with 50 answers, one for every student. When I created this list of student-name answers, I had to make sure each string of text matched the same string of text in the Office 365 directory (when a student fills out the assessment form, the Form captures their name through login credentials and inputs it into the Forms spreadsheet). Apparently at my school hyphenated last names are a growing trend (please stop!), and that can interfere with text string relationships if they don't match. So, if my student's name is "Johnny Bravo-Charlie" in the Office 365 directory, then in my "Who are you assessing" question the Johnny option has to match that same text string. I found this out the hard way 🙃

Another question on my Forms was "which video performance are you assessing?" Another multiple choice question, its choices were the exercises the students were performing and recording into Flipgrid. Every time a new performance assessment was assigned to my students, I would just go back to the Form editor and edited the question to include the new assessment option. I wanted the data from these different performance assessments to appear linearly in a data visual, so in front of the title of the assessment exercise I put a number. "1" for the first assessment, "2" for the next one, and so on. This way Power Bi would easily recognize the order I want the assessments to be in. Every once in a while a student would choose the wrong exercise title in their peer assessment submission, but I was able to find the entry in the Excel file and edit the response to include the correct value.

Using this setup I had two sets of data per class that would automatically sync into Excel files saved in my OneDrive. I connected/queried these data tables into my Power Bi desktop file, and started creating my visuals as the data began to flow in. When I was happy with it, I published the report to my Office 365 workspace to make it official. To share it with students, I needed to go to Power Bi in web, find my report and open it up, then select the File-->Publish to Web option to get my sharing link. Sharing it with the students was simple. I could paste the link anywhere in our OneNote Class Notebook and the report would automatically pop up on the page, creating easy access (visually) for my students. Now my students could get the feedback from their peers and me on their performance assessments.

It was a bit of work to get this whole system set up, but the best part was after it was done in the beginning of September, my students and I were ready to use for the entire school year. I was able to add more data sets into the report over time (which I did), but my performance/peer assessment workflow was set in place and ready to use. 

Part 2 will continue in my next post, where I'll discuss how I used Power Bi to manage all this data. 

Capturing students' performance skills on their instrument is an important measurement for music teachers. When I observe a student perform, I can hear and see what they're doing well, and what they are struggling with. Their challenges can either be related to reading and interpreting music notation, or the kinesthetic aspect of playing their instrument. Playing with correct articulations, posture, bowings, and the minute details of their finger technique are all important to successfully performing on a musical instrument. As important as this is in music education, it is a time-consuming process to hear every student in an ensemble. This past school year my average class size hovered around 50 students. Unlike a written test, where students take an assessment at the same time, I have to listen to each student individually. Listening to each student perform an assessment during class takes at least 3 to 4 days, and can easily eat up a week of class instruction. It is important though, as it starts teaching my middle school students some practical life skills like responsibility, communication with their parents to schedule practice times in my classroom, how to deal with the anxiety of performing in front of peers, trying your best, and the idea of Practice makes Perfect.

Flipgrid took care of a lot of little issues I had with other technologies. It records video, providing me with both the audio and visual I want. It hosts and organizes the videos seamlessly, which at the time was such a huge feature for me. Teaching students how to record, save, and send a big video file (which is always dependent on their device and the communication service) is no longer a cumbersome task for the students and me, and I don't have to worry about saving and syncing a large amount of video files to the cloud and my computer. With Flipgrid, it's a breeze for my students to submit videos of themselves performing, and it's a breeze for me to access them. That was such a game changer. Flipgrid also makes the process fun for the students, giving them the ability to add graphics, digital ink, and all the buttons my students can click on to like each other’s videos. I'm not fun like that, just ask my students. Most importantly though, the listening-to-students-perform assessment process was moving out of my classroom instructional time. Student could now perform and submit their assessments videos before or after school in my room, or at home. 

As I've written in previous blog posts, I incorporate peer assessment into my student performance assessment activities. I assess my students when they perform, and the students do too. We use a rubric and a form. It started out as a paper/pencil routine, but I've since moved the process to using an Office Form. It's more practical, and I get so much relevant data now from my students! This year had to be a little different though, because I was adopting Flipgrid into the workflow. Now I'm able to assign more assessments, but I can't have students still assessing the rest of the whole class (50 students!) using my assessment form. They would go nuts and hate me. I narrowed it down to three. Every time my students had a new performance assessment to submit though Flipgrid, they would only have to do three peer assessments.

I would drop hints to my students as to what their next assessment exercise would be (usually from our method book) during class, but when the hammer officially dropped, I gave them a full week to submit their Flipgrid recording. Flipgrid can automatically close topic submissions, and I started using that method. I opened submissions again for the students that missed the deadline. Not a problem, they'll just lose a couple points. Speaking of points and grading, these were 10-point assignments. You either submitted your video on time (10 points), late (8 points), didn't submit at all (0 Points). That was it. I was using a point-based rubric to assess and score their performance, but that number never made it into the gradebook because I never intended it to. Those numbers was for something later 😉 Same deal for their peer assessment submissions. Ten points for 3 peer assessments, and then losing some points for each assessment not submitted. This took a lot of the anxiety my students have off of the performance aspect of the assignment. My students just had to submit their video and do 3 peer assessments to get full credit. Easy peasy.

It worked, and it worked really well. I was able to listen, watch, and assess my students more frequently throughout the year, and was able to space the assessments in-between concerts, concert rehearsals, semester projects, and honor ensemble activities. My students were checking out their instruments more to practice, and the couple days before a video recording was due my room was so packed with students practicing/submitting, they overflowed outside the classroom. As a music teacher, it was a incredible sight to see and experience 🙂 The students were engaged with their peers, helping each other with their music, showing lots of encouragement, holding each other accountable for their submissions, and pressing all those like buttons in Flipgrid. I even had a former cello student (now in high school) sneak his way onto the Orchestra grid and submit his own videos. That is just plain awesome. Who wouldn't love that happening.

Transforming this assessment routine with Flipgrid was just one part of the bigger picture. By doing these activities I was now receiving lots of assessment data from my students and myself. Data that could be used to track growth and progress, but also to find more interesting insights by comparing assessment scores between teacher/student, instrument sections, grade levels, before/after interventions, and more. How I was able to organize, manage, analyze, and share that data will in the next part of this series.

For a few years now I've been messing around with Power Bi, using it more and more with my students and myself as I learned how to use the program.  This year I integrated it even more into my pedagogy with my two advanced classes, made up of 7th and 8th grade students, to track their performance skills and more as it turned out. This past school year I've travelled to several Educational Technology conferences presenting on this recent work, and I get a lot of questions like "how I created and made everything work" and "how I came up with the idea." It's a long story, and is based on the edtech I use and more importantly music education pedagogy. It can't be explained in a single blog post, so my plan is to write a series of blog posts that covers what I've done.

Now, if you're looking at the graphic you're probably thinking this is nothing new, I do this workflow all the time in my classroom. Probably using some form of Formative Assessment. Good! You should be! My story will cover how I integrated the above set of technology tools to create activities that incorporate the 4Cs, student centered learning, a little bit of metacognition, data, and probably some more Edu buzz words.

The activities I'll be writing about spanned the course of this past school year. In fact, in my opinion I didn't even really finish the whole process. However, I feel it was a pretty good first run that can be expanded upon next school year. The cool thing is some of this data will carry over to next year, since I'll be seeing my 7th graders return as 8th grade members of my ensembles.

Stick around for Part 1

It's been a week since CUE 2018. The conference was a nice break from the classroom. It's not that I don't enjoy teaching my students ( I do), but getting away allows me to reflect on the current state of #edtech and brainstorm on how to use up & coming useful technologies. Usually this time is reserved for late at night, but lately I find myself choosing sleep more often than not. Anyways, the point is I get some distraction-free thinking time. Here are some thoughts:

#OneNoteEdu - Tammy Dunbar and I gave a 3 hour Office 365 workshop, and I put together the section on OneNote. I've come to the conclusion that there is never enough time to discuss OneNote. There is just too much to talk about. Attendees need to understand the organizational structure of a OneNote notebook and the power of the page. Immersive Reader, embeds, math, tables, ink, researcher, printing and sharing, and then there are all the basics too. And if that wasn't enough, Classroom Notebooks take it all to a new level of pedagogical thinking, planning, and designing. I showed off a lot of examples of how I'm using Class Notebooks to share content, organize everything digital in my classroom, and implement learning activities with my students. It's pretty crazy how one software program can be used in so many various ways, be it for independent or collaborative student learning. At the same time, since OneNote is my classroom hub for practically everything, I don't have to teach new routines for other apps or online services. When my students come into the classroom and see that they're using iPads, they don't ask "what do we do?", they just automatically open OneNote, log in, and open our Class Notebook. I like this. It saves me time.

I digress though. Explaining all the ins and outs of a Class Notebook is also a big challenge. There is distributing and reviewing work, LMS integration, creating collaborative sections, creating groups for differentiated page distribution, the process of setting up a Class Notebook, and the permission levels associated with the three main sections. It's a lot to digest in such a short amount of time, and it's a lot to try to explain in such a short time too.

Power Bi - I gave my Power Bi session again. This was my third time, and I still haven't figured out a cool catchy name for my session title yet. I had a bigger audience this time. My session resource link (available at the session) was pinged 91 times that day (yay!). Maybe this whole what-are-we-going-to-do-with-all-this-student-data-and-how-are-we-going-to-manage-it idea is starting to catch on. It also helped to have a good location for the session as well 😉 Lots of people were interested, and there was a collective "wow" when I demonstrated manipulating a chart on students' success rate with multiple ELA anchor standards to show me the data based by grade level, class section, and both. I received some complements for my session at the end, before everyone was rudely kicked out by the convention staff.

FONBME - This is a take on FOMO (Fear of Missing Out). I call this Fear of Not Branding Myself Enough. There is just so much of it going on, and I don't know how to react to it. Should I do it too? I imagine it's time consuming, having to create a fancy acronym, write blog posts for every little thought, and having to attach myself to Twitter more than ever. I'd rather spend time this time with my family and on my students' learning. I like to create, innovate, and problem solve. This takes time. Time away from branding I guess. Oh well.

AR & VR - CUE has a nice little virtual reality playground for attendees to play around the latest devices (except for Microsoft's mixed reality headsets 😕). I'm still trying to put my finger on this for the music classroom. Yes, there are use cases for the historical part of music education, but I'm still trying to figure out how AR/VR could be used to help students understand and grasp the basic music concepts I teach in middle school. I already accomplish this without AR/VR, but does it have something to offer that makes it pedagogically worthwhile? I still don't know. Honestly I don't have a device to play around with and test, but that's not the real issue. I know what works in my classroom. I know how to design my resources and activities so that my students learn in my classroom. I want to (try to) do the same with VR. I want to be able to create a VR experience tailored exactly the way I want it for my students (TPK and TCK), except I don't know how to design for VR yet. During a discussion I had with one of the VR experts, I did learn about WebVR though, which I'm told is where everything is headed. Imagine if teachers had easy tools to create worthwhile VR/AR experiences for their students that could incorporate permission levels from the cloud, like a VR/AR classroom that adapts for every student. That would be cool. Make it happen Microsoft.