Exploring Teachers’s Dashboard

To build a teacher’s dashboard for this week’s activity, I used the Sample 2 data which included the following information

  1. Student First and Last names.
  2. Attendance percentage.
  3. Interaction with the learning platform with data related to: VLE logs, forum views, forum posts, forum replies and pdf views per week for each student.
  4. Test scores for 4 tests for each student.

I decided to use the Microsoft Excel after I explored in Google Data Studio as I’m more familiar in functions and pivot tables and I have used it before at work for Data analysis.

After looking at the data, I decided to add three new fields: 

  1. Attendance indicator – which identified students with attendance more than 80% (used 80% out of my own college experience!)
  2. Active participation – which identified the students with a total number of forum posts and replies above the average of all students. 
  3. Average test score for each student

The following is the Dashboard I have developed based on the provided information and divided into 3 sections: 

Teacher Class Dashboard: which contains the data visualisation and analysis section giving the teacher at a visual snapshot and summaries with the following information details:

  1. Top 5 students with average test score of above 70 (a table)
  2. Access to the learning spaces summary (the donut) demonstrating the total number of all VLE access and forums views and posts per week. 
  3. A Chart of the students test results including the average for each. 
  4. A sparkline table that provides a visualization of the students’ test results in columns showing increasing or decreasing trends and highlighting the highest and lowest score. 
  5. Top Active participants of the classroom measured by the total number of forum posts and replies that are above average. 

The Pivot table and controls that allows the teacher to manipulate the data and perform what if analysis to focus on certain scenarios and data elements per the class or per a set of students.

The complete class captured data in a table format. 

The following table reflects on the exercise questions:

What kind of data might be useful for teaching?  Two types of data that can be useful here:
– factual data: test results, attendance, assignments’ submission time and dates,
– Actionable data: performance progression, learning environment activity, performance in relation to others, aggregated data from other classes or previous years
How data might be organised, combined, and visualised for particular kinds of teaching practice?Data should be organised per students as a complete profile to understand all aspects of the student data before relaying on comparison charts and assumptions of calculation and with clear understanding of the assumptions used to calculate the date. Example for above : high attendance was measured at 80%.
Flexibility for the teacher to change these benchmarks or reference data to be able to perform what if analysis
How might such ‘dashboards’ impact the day-to-day practices of teaching?High impact especially if the teacher takes the information as is without drilling into details and understanding what is behind the data presented. Looking at the data, the highly active students measured by participation on the forums (posting and replying) had relatively “high to average” grades. Students with the highest VLE log on are not necessary the highest participating on the forums. So teachers can’t make decisions only by looking at these dashboards but they might help teachers priorities where to look or support certain questions
what data should be included, what should be excluded, and for what purposesFrom this example of data, there are far less data than maybe need to perform an understanding of the students’s performance and level of understanding. The test scores indicates a number but the level of content and analysis of questions vs understanding of subject is not there. The test data can project overall performance as a class. Like in general test 2 had the highest values.

For example: The attendance data and VLE log has little impact on participation. The highest attendee percentage of 100 with highest VLE logs of 15 p/w result into two students with above average test results. One of these students are not active at all in terms of posting or replying on forums. If a teacher looked at this data alone (active participation), her/she would have thought that the second student (Mitchel) is not a “performing” student.
Some Analysis

In conclusion, it was a good exercise to try to imagine what the teacher could be interested in and to design a dashboard with the data available. I believe the best approach would be to design the dashboard and link it to the learning and teaching objectives and then define what, where and how to measure or capture the relevant data. Using Brown’s (2020) conclusion of the study:

To effectively use a tool (and to make a tool effective for its users) LADs need to be sufficiently configurable that they can be enfolded into existing instructional practices. Before selecting a tool and throughout its use, instructors should build time into their practice to evaluate the affordances and limitations of a technology

Brown 2020

References :

5-Day Meals Visual Log

Software based Personal Data Recording

For this assignment I used a mobile app called Ate (link below) which allows the user to take a picture of the food and the app automatically records the time and date. The data that can be added to the pictures are the following :

  • On path or off path (planned meal and quality/quantity)
  • Why you did you eat ?
  • How are you ?
  • Who did you eat with ?
  • How was it?
  • Where did you eat?
  • How was it made?
  • How did it make you feel ?

The information is captured on the pictures when one select the day cap option. The following is a visual log of my meals for 5 days with tags of the answers provided on each meal.

Meal Visual Log

The app also provides data visualisation option in various charts and more reporting could have been obtained if you I purchased the full app version. I went for the basic free one which gave a lot of information. It also measured the fasting time based on the my data logging.

Some reflection points on the app data and what I learnt about my eating habits :

  • 50% of my meals are out of hunger and rest varies. Being in home office and not being able to go out I believe that’s a good representation. I eat of many other reasons than pure hunger
  • most of my eating is while I’m standing. This is usually at the kitchen counter because I’m either eating between calls or during calls!
  • Food is most of the time making me satisfied. Although I describe myself a food adventurer and I enjoy a good meal or cooking something new. With the Covid-19 situation food is more than a routine than to make me happy or just stress eating with my guilty and stuffed ratings
  • I tend to be on path more during the week and then towards the weekend I loose course!
  • I’m impressed that I’m maintaining intermittent fasting without really focusing or counting the hours. I started more than a year ago monitoring my fasting … I guess it is now part of my routine
  • Number of meals a day really vary… and it seems when I’m in a lower mood I eat more frequently and more meals.

Using an application / software for data capturing this week was fun but it had certain limitation compared to the hand-based data recording for the data visualisation assignments. I can also summarise the advantages and disadvantages of having an app/software in the below

Time and date recorded automatically the type of data captured is based on the app design
Capturing pictures and using the phone as a devise made a lot easier No flexibility to capture additional data except in free text that is not part of the automated reports
the automatic reports and statistics The reports are not customisable or you can’t combine two / three types of data to do more analysis
Sharing content The options / feature are based the cost you are willing to invest
Data visiualtion presentations are neat and easy to readthere is no food content analysis / portions / healthy features etc

The question is: would I use this app on a regular basis beyond this assignment / task ? I doubt I would because of it is not linking it to my health or weight management and it doesn’t offer recommendations to improve quality or quantity.

Ate Food Diary: mindful eating by Piqniq Inc.