DFI - Dealing with Data

Reflection:

From last week, I have used Google Slides and Google Draw everyday in my class. I gave my learners the option to choose their way of presenting their work. There was a huge range in presentations from Google Draws to interactive slides. It was amazing to see how versatile Google was to use for their task.

I have found that the only thing I have been struggling with is forgetting what I have learnt as there's so much to take in. I have blogged all of my DFI notes but remembering off the top of my head has definitely been difficult.

Manaiakalani Pedagogy:

Today we focused on share. Sharing is a huge part of human nature. Sharing stories, food, success, failure, tears, etc. is in everyday life. Sharing on apps is a great way to interact with the rest fo the world. This all started in 2005. These apps include YouTube, Facebook, Instagram, Twitter, Bebo, etc. Manaiakalani used this concept of sharing to encourage and engage students to "be the star in their own movie". One of Manaiakalani's goals was "to work with learners to establish an authentic audience for their learning outcomes".

When it comes to sharing we need to be very specific on the purpose. The power comes from an authentic audience. An authentic audience are those who choose to engage with your work.

From 2006-2021 Manaiakalani used Blogger to share their work. This has since progressed into Edublog.

Below are the reasons why blogging was chosen as the form of sharing.

Google Forms:

Google forms is a great way to collect data. There is a range of question types you can use, such as multiple choice, date/time, short/long answer, checkboxes, drop down, etc. You can add pictures, use questions from previous forms, audio and more. Forms can be used to create quizzes which allows them to see their results at the end or even mark the test later. 

By enabling "auto save" this allows people to go back to the form and continue filling it out. This is a great tool fo certain tasks. You can send Forms in three ways, embedding, email or linking. At the end once data has been collected, it is possible to see the data displayed in a range of ways (graphs, percentages)

My Maps:

Maps is a great way to add the locations of areas. You are able to add lines to see the distance between areas and for shapes (such as school field). This is also an option when using the ruler tool. However the measurements will go away in comparison to the line tool.

Importing data is easy. A simple click of the "import" tab will allow you to use data from other files (sheets) to put markers on the map. By clicking on the markers, you are able to change and edit the colour and icon to make it easier to find markers.

This is the map I made.

Google Sheets:

It is possible to freeze the cells. By clicking "view" and selecting "freeze". From here you can choose which row/column you want to freeze. This means they are always at the top.

By choosing the "function" button it allows a range of formulas to be used such as sum, averages, count, maximum and minimum. This makes it so easy to do data analysis for the entire class as dragging the box down, uses the formula you have chosen for all the columns below.

Filtering:

By clicking the filter symbol, it is easy to filter through the data by selecting the data you would like to see.

Sparkline:

Sparkline creates a mini graph. Type =sparkline into a column. Click enter and select the columns you'd like to use.

Macro:

Macro is found under extensions. This allows you to do repetitive tasks that are done on the sheet. By recording a macro, it saves to you sheets and allows you to use it for other sheets. This can be used to sort data better as it is just a task that can be set for the computer to complete.

Notification tools:

These are used to send email reminders when someone edits a sheet or submits a form into the sheet. These can be found under "tools".

Data Validation:

Selecting the cells is the first step to adding drop down boxes. Two finger click and go to "view more cell options". Click on data validation and create a list of options. Once this is saved, the cells are locked to restrict the answers for these.

Protecting Columns:

By selecting the colums you want to lock, two finger click and choose "view more column actions". Then click on 

Viewing edit history:

Two finger click on the cell you want to look at. Find "view edit history". This will show you who and when it was edited and what it was changed to.

Randomise names:

By selecting the column and clicking "data", then finding randomise. This muddles up the names and allows there to be a list of who goes first with presentations and the likes.

Setting rules:

Select the columns first and go to the "fill" button. Click on "conditional formatting" and "add a rule". This means you can set rules for cells that contain certain words, have above/below results, etc. These can also be filter using the filter button and selecting "filter by colour". 

Create task:

For the Create task this week. We had to choose a child's blog to analyse the amount of blog posts and the reasons why they were low/high in those months. Below are the graphs I have made.

Analysis:

In total, the learner wrote and published a total of 183 blog posts in 2020. May and June had the highest number of blog posts which equated to 29.5% of all blog posts in 2020. This could be due to having no school holidays or interruptions within these two months. This is interesting as New Zealand went into a nation wide lockdown from March 25 - 13 May. From the time period of March - June there was an increase in blogs due to online learning and this is the time period when we first got back to school. 2020 was an uncertain time for everyone and it is interesting to see her blog post numbers didn't drop during our first lockdown. 

There was a drop in blog posts in August, this was due to Auckland being put in Level 3 which meant we schools had to shut. After this the overall blog post numbers drop drastically. This could be due to erratic attendance due to covid as many families were in fear of catching it at school.