Before this past Saturday's class, Manuel C. (Manny) brought a smile to my face with his email portion of Bonus Quiz 10. Too bad he had to miss class and the in-person portion of BQ10. However, my excitement for the second half of Lecture 4: Key Excel and Spreadsheet Analysis Concepts (Part 2 of 2) brought the smile back :-)
Mary kicked off the class session with her presentation on 3 Ethiopian Landscapes. This is not the first student of mine who traces his/her roots to Ethiopia. This is not the first time a student of mine showcased Ethiopia as his/her A5 Slideshow Presentation. This is not even the first time I have two students that hailed from the same country in the same class. But this is the first time that both students wanted to a presentation on their ancestral county. The motherly Mary focused on three unique landscapes, allowing her younger classmate to focus on their common motherland.
After walking through the polishing process of Mary's draft slideshow to final slideshow, I engage the class with four scenarios in my Weighted vs. Straight Average exercises. Anisley, Wayne, and Roberto actively participated while others observed and barely spoke up. I will post the starting point of the four scenarios as the central image in a later blog post for students to walk through again.
I concluded my final formal lecture presentation with a decision tree in choosing the appropriate type of chart to use for a given scenario. Barring specialized analysis or perspectives, most charting needs can be satisfied with either a (i) pie chart (when showing contribution to a whole or breakdown from a whole), (ii) line chart (when the order of data elements matter), and when neither (a) or (b) applies, then the scenario is likely a comparison for which either (iii) bar (horizontal beams) or (iv) column (vertical beams) would the be the most appropriate type of chart to use.
The remaining classroom time saw students working on their coursework. Majority of the students completed their Fun with Functions and More Workbook working toward the end of Chapter 5 Microsoft Excel. A few students have even began working on A6 Spreadsheet Analysis with Trailer.
Click on the image for a larger/clearer view
The three Ethiopian landscapes are so stunning, majestic, and grand, I must help Mary showcase them:
(1) Dallol, Afar Region: https://en.wikipedia.org/wiki/Dallol_(hydrothermal_system)
(2) Lake Tana: https://en.wikipedia.org/wiki/Lake_Tana
(3) Simien Mountain National Park: https://en.wikipedia.org/wiki/Simien_Mountains_National_Park
Click on the image for a larger/clearer view
Students,
The Digital Literacy program director created the Fun with Functions and More Workbook to supplement Chapter 5 Microsoft Excel, hone your thinking and execution skills, and help you prepare for the MO-210 Excel certification exam. The program director also made three YouTube videos:
Excel TEXTJOIN and CONCAT functions (5 min 19 sec)
Using the SUMIF function (5 min 10 sec)
UNIQUE function in Excel (2 min 5 sec)
In your comment to this post, please share your thoughts on:
(A) How was your experience in doing the Fun with Functions and More Workbook?
(B) Did you find his three YouTube videos helpful?
(C) With Fun with Functions and More Workbook and what you have done in Chapter 5 Microsoft Excel thus far, how do you feel about your mastery of Microsoft Excel?
The Fun with Functions and More Workbook was a bit challenging. Since there are multiple ways to get an answer, it caused me to have to really read and ask myself "What are they asking me for." Once I saw "Correct" pop up next to my formulas, it was like a breath of fresh air.
ReplyDeleteHaving someone speak as they are entering the different formulas helps me understand the different formulas a little better, so the three YouTube videos were very helpful. Having different teachers is always a plus when trying to grasp a new concept or skill.
I am pretty confident in my Excel skills, especially compared to what I knew at the start of the semester. Chapter 5 Microsoft Excel along with the Workbooks are great training to not only understand Excel, but how to use it in real-world scenarios. Hopefully, the formulas covered in the expert certification exam work the same way.
1. Fun with Functions and More Fun Workbook was alright. I did have trouble with some parts, but eventually got through.
ReplyDelete2. These videos are good. They are a quick review of how to use functions that some people might have a harder time than others.
3. I think I will be able to pass the exam with a somewhat decent score. I just need to study up before the actual exam.
1. Fun with Functions and more Fun was good. I was overthinking it but after I read the instructions again it was easier to complete than the previous worksheet.
ReplyDelete2. The YouTube videos were great. Such an easy way to summarize and explain the steps for the formulas. I'm a visual person so seeing it helped me engrave them in my brain.
3. I'm aiming to achieve the same score I achieved in my Word exam but I know I need to study some more If I want that to happen.
1) The Fun with Functions and More Workbook was a bit challenging for me but once I understood the concept thanks to the LabSim videos and Mr. Albert's help, I finally got it.
ReplyDelete2) Yes, they are very helpful.
3) To be honest I am kind of getting the hang of time and hope I pass. If not, I know at least I put in the good fight, that's how I see it.
1) The fun with the functions workbook was somewhat challenging. Considering that I am not the best when it comes to Excel, this assignment took a while for me to complete.
ReplyDelete2) The YouTube videos were helpful. They were a great overview of the Excel formulas. It's always helpful to have a visual recap of Microsoft Word, Excel, and PowerPoint.
3) Although Fun with Functions and More and Chapter 5 Excel were helpful I still don't feel I've mastered Excel. Excel has a lot of steps and rules to follow, it takes a lot of skill to master this program.