Monday, November 13, 2023

Other Chart Types, Spreadsheet Analysis with Trailer, Grade Breakdown

This past Saturday, November 11 was Veterans Day -- thank you for your service :-)

Wayne saved Bonus Quiz 3 from being neglected this semester as the former Navy Man took on BQ3 before class began. I officially kicked off the class session with my usual greeting but this time, I also outlined the different components that contribute to a student's IS101-3003 grade.

Roberto then paved out The Road to Competitive Pokémon as his A5 Slideshow Presentation. During my walk through the transformation process from his draft slideshow version to the final slideshow version, I pointed out the radar charts Roberto utilized to illustrate various characteristics (e.g. health point, attack, speed, defense) of a Pokémon character.

In last Saturday's Lecture 4: Key Excel and Spreadsheet Analysis Concepts (Part 2 of 2), I mentioned that for uncommon analysis or perspective, one may see chart types other than a pie, line, bar, or column. Roberto's use of radar chart type in his A5 is quite timely.

Another chart type is a heat map. The best example of a heat map I have seen was from four years ago:


As it not only illustrates its intended message well, but corrects an intentional misrepresentation!

Philemon stepped up do his A5 next Saturday and I gave the remaining class session for students to work on their IS101 coursework. Wayne sent in his A6 Spreadsheet Analysis with Trailer, joining two classmates.




Click on the image for a larger/clearer view

A6 Spreadsheet Analysis with Trailer is one of the two capstone assignments. The spreadsheet analysis accounts for 80% of the assignment and is mostly quantitative in nature. The remaining 20%, the trailer, consists of three topics: (A) exponential (non-linear) growth, (B) brief ccTLD look up, (C) perspective interpretation and qualitative communication. (C) is one of the oldest rare gem I came across during my teaching in higher education. It may be a decade and a half old, Chancellor Rogers' brilliance is timeless ^_^


Click on the image for a larger/clearer view

Students,

In your comment to this post, please share your thoughts on:

(i) Have you seen any other types of chart besides pie, line, bar, column, radar, heat map used? If so, please share that/those example(s), if not, did you use the correct chart types on A6?

(ii) What did you think of the spreadsheet analysis portion of A6?

(iii) What did you think of the trailer portion of A6?

5 comments:

  1. When I was learning about the stock market, I had to familiarize myself with Candlestick charts. It's a way the people in that industry show how much the price of an asset has changed in a certain amount of time. It was pretty confusing at first, but as with anything, practice makes perfect.

    The spreadsheet analysis portion of A6 was pretty fun. For some reason, I understand the different types of charts pretty well, so it didn't come off as challenging at all.

    The trailer portion of A6 was a bit of a challenge, because it challenged me to read and re-read the requirements to make sure I fully understood what was being asked. These assignments remind me how important it is to pay attention to the tiny details in the questions being asked.

    ReplyDelete
  2. 1. I might have seen a different type of chart, but not often enough for me to remember what it is. So I used a pie chart and a bar graph for A6.
    2. The spreadsheet part was okay. It took me a bit to get through just because I just happen to be really foggy whenever I decided to work on it. I like it though.
    3. I haven't gotten through this part yet. Hopefully it won't be too bad because I really need to finish this assignment. It is haunting me. I'm tired of it now.

    ReplyDelete
  3. 1. Yes, I have seen and used Venn Diagrams in the past. I was able to use the correct charts in the A6 assignment.
    2. The Spreadsheet A6 was easier to complete and I had a lot of fun working it through.
    3. The trailer part of the assignment made me slow down and read carefully. I work and function at a very high/fast pace, sometimes I forget how important is to take a second to analyze and successfully complete a task.

    ReplyDelete
  4. 1. To be honest, I never seen different types of chart besides what I seen this course, but maybe I have but just can't remember it.
    2. The spreadsheet analysis portion of A6 was pretty okay compare to the Fun with Functions book.
    3. I need to go back and redo the trailer portion again.

    ReplyDelete
  5. 1. I personally have not used any charts besides bar graphs, pie charts, and bar charts. Although these are common, they are the easiest to read and create since they are more familiar. One day I hope to use some more complex charts as a result of my practice from IS101.
    2. The spreadsheet part of A6 was slightly challenging for me. It took some research to figure out but it was a fun task!
    3. I would say that the trailer portion of A6 was challenging for me as well. The instructions for both the spreadsheet and the trailer were a bit of a struggle to understand. Re-reading the content over and over again made it easier to complete this portion.

    ReplyDelete