I have made my learning design on the topic of cell-counting features in Microsoft Excel.
This is a tutorial on some of the cell-count variations available in Excel:
Baldwin, C. (2021, September 18). How to Count Cells in Microsoft Excel (COUNT, COUNTA, COUNTIF, COUNTIFS Functions). YouTube. https://youtu.be/5RFLncJuMng
Now following your study and walkthrough on Excel’s cell-count functions, the following is a question set to test you on it.
Reflection
I really enjoyed using H5P to create the question set for this post. It was a first for me in terms of using such a comprehensive tool. Not only was it very user-friendly, it was also varied in its repository. I personally have used multiple different websites or tools on the internet such as SurveyMonkey, Google forms and Kahoot to create only some of the activities in H5P’s expansive repository. As such I fould it really engaging when H5P as a free tool could cover them all.
I personally really like the drag and drop activity and would definitly utilize it extensively if I were to use it in a teaching context. For example, as a computer science student (as a teacher in this case), similar to how I constructed a question for an Excel worksheet, I could leave blanks in sections of code and have learners drag and drop the correct code line out of multiple options for specific outputs.
Some of the H5P activities are definitely more resource-intensive to create than others, typically because of their multimedia and interactivity requirements. Personally I think interactive videos are expensive to make. These usually involve embedding questions, pop-up notes, and links within videos, which requires the need for sourcing or creating high-quality video content and also carefully planning the interactions for enhanced learning.
Interesting blog post Swoyam! I also really like the drag and drop activity! I didn’t use it in my own blog post but when I was playing around with it I found it extremely satisfying. I think you provide great insight for using it in your programming output example and it just goes to show how versatile and effective this method is. If I were to be teaching a course or subject of some kind, I would like to use a mixture of the drag and drop activity as well as multiple-choice, as I believe the instant assessment and feedback would have a positive effect on the learners educational experience. I also really like that you included a video in your blog as it provides some context for what the learners are learning. Furthermore, I also think that this point of adding a video goes well with your final point of how certain interactive activities can be too expensive and time consuming to make. I think educators need to find a healthy balance of utilizing whats already available such as complex videos, with interactive components to enhance the learners overall experience in the most efficient way possible.