Spring 2023 student videos, new lesson plans and presentation of lesson plan posters at the CUNY Illusion of Inclusion Diversity, Equity and Access Conference


My Spring 2023 and Fall 2022 Spreadsheet Applications in Business and Research Methods in Business students gave generously of their time, patience, creativity and collaborative struggle to test four new lessons I developed. These lessons are set in the context of Environmental Sustainability and Governance. Making sure that future generations have a better quality of life because the corporate and government sectors are working together to reduce climate change and social inequities could be very important to my students. Here are four sample lessons that I believe will motivate students to exceed their own expectations for learning Excel, Tableau and VBA (Visual Basic for Applications) using Environmental Sustainability Case Studies.
Climate Change Excel Dashboards
My Excel Dashboards climate change lesson tasks students with creating visualizations using data from the Bronx Botanical Gardens budding and leaf color change (phenology) repository for Red Maple trees. This data has been collected for decades by other Citizen Scientists. We will create Excel Dashboards using budding dates and daily temperatures recorded in Central Park to find out how warmer weather impacts phase changes for this species.
Collecting Genetic Data using Visual Basic for Applications Forms Created by Students
I believe that racial strife will diminish if the next generation of Americans understand that racial differences are insignificant. Strengthening our students’ resolve to strive for a more open, peaceful society is an ultimate goal of these lessons. Students will investigate their phenotypes, the physical manifestation of their own personal genetic traits, and make their own data. We then make a chart that includes everyone’s individual traits that may reveal how genetically similar classmates are. Then we will create Visual Basic for Applications data entry forms for capturing human traits.
Creating a taxonomy for tagging greenhouse gas emissions disclosures and learning Calcbench
Students create a simple taxonomy of greenhouse gas emissions, tag data and create human readable, machine readable documents using CDP.org repository data. They also learn how to use Calcbench, a program that facilitates benchmark comparisons of tagged SEC disclosure documents.
Balancing Triple Bottom Line Criteria using Solver Lesson Plan
The study of Environmental Sustainability gives the corporate sector strategies for improving the quality of life on earth. Students use Solver, an optimization program to pick a portfolio of stocks that have successfully balanced the Triple Bottom Line Goals of: making a profit, protecting the environment and enhancing the prospects of people who are often denied the prosperity they deserve. If we continue the misguided squandering of natural resources, and disregard for the economic disparity caused by racism, sexism and greed, efforts to heal the world may be delayed until it is too late.
Two Fall 2022 Spreadsheet students who tested these lesson plans were with me and the rest of the research team when we presented our lesson plans during the Illusion of Inclusion, Diversity, Equity and Access Conference at the CUNY Graduate Center. Michelle Liang, a research team member and one of my CIS 2200 students Bryan Lara appear in the picture with me. Sean Gonzalez, one of the research team members appears with me and Dr. Elys Vasquez-Iscan in the video below.

Baruch College Spreadsheet Applications in Business Class

Corey Bogen’s Midterm Video

Ming Chan’s Midterm Video

David Chen’s Midterm Video


Jihye Han’s Midterm Video

Shantal Lester’s Midterm Video

Thomas Luong’s Midterm Video

Chad Meirelles-Rodies’s Midterm Video

8 thoughts on “Spring 2023 student videos, new lesson plans and presentation of lesson plan posters at the CUNY Illusion of Inclusion Diversity, Equity and Access Conference

  1. The very heart of your writing whilst sounding reasonable at first, did not really sit perfectly with me personally after some time. Someplace throughout the paragraphs you actually managed to make me a believer but only for a while. I nevertheless have got a problem with your leaps in assumptions and one would do well to fill in those breaks. If you actually can accomplish that, I would certainly be fascinated.

  2. I must show thanks to this writer for bailing me out of this particular instance. Just after surfing throughout the world-wide-web and coming across views which were not pleasant, I thought my life was well over. Existing devoid of the approaches to the issues you’ve solved by way of your posting is a crucial case, as well as the kind which may have in a wrong way damaged my career if I had not encountered your web blog. Your own talents and kindness in dealing with all the details was excellent. I am not sure what I would’ve done if I hadn’t discovered such a thing like this. It’s possible to now look forward to my future. Thanks for your time very much for this professional and sensible help. I won’t be reluctant to suggest your blog post to anyone who requires direction on this issue.

  3. I have not checked in here for a while as I thought it was getting boring, but the last several posts are great quality so I guess I?¦ll add you back to my daily bloglist. You deserve it my friend 🙂

Leave a Reply

Your email address will not be published. Required fields are marked *