Posts

Transforming Google Form Data with ARRAYFORMULA in Google Sheets

In my job, I often need to assign tasks to reviewers. For example, I may assign faculty to review and score student work for assessment purposes, or reviewers to score assessment reports or award applications. Using Google Forms to collect reviewers' feedback and scores is my go-to low-cost method.  Below is a typical Google Form setup that I use: Question 1: Review Name [Drop Down Menu] Question 2: Report Reviewed [Drop Down Menu] The response data returns a vertical dataset like the mock dataset below. 🧪 Mock Dataset (Raw Form Responses) Sheet name: Form Responses Column A Timestamp Column B Reviewer Name Column C Report Reviewed 2025/03/20 09:01 Alice Report A 2025/03/20 09:03 Bob Report B 2025/03/20 09:05 Alice Report C 2025/03/20 09:08 Alice Report D 2025/03/20 09:10 Bob Report E 2025/03/20 09:12 Carol Report A 2025/03/20 09:14 Carol Report B In order for me to monitor whether a reviewer has completed their reviews, I need to transform this vertical dataset into a horizontal ...
Post a Comment
Read more

Exploring AI Tools for Literature Review

Image
 Exploring AI Tools for Literature Review For years, I meant to establish a strong theoretical foundation in facilitative leadership and conduct a comprehensive literature review. Today, I explored several AI tools and compared them with the results from Google Scholar. Below is my journey. 1. Google Scholar ( scholar.google.com ) I typed in "facilitative leadership" in Google Scholar. There were 83,600 results. Among the first 10 results, 6 seemed to be highly relevant for providing a theoretical foundation. Facilitative Leadership : The Imperative for Change.  (1992) Facilitative Leadership : How Principals Lead without Dominating.  (1994) Facilitative leadership : One approach to empowering staff and other stakeholders  (2004) [BOOK]   Planning in the face of conflict: The surprising possibilities of  facilitative leadership  (2017) Participatory approaches and the role of  facilitative leadership  (2014) [PDF]   Can instructiona...
Post a Comment
Read more

AI in Syllabus & Classroom -- Lecture Notes and Reflection

Generative AI technology permeates our lives. It generates excitement and fear among educators. What is it and what can educators do with it? Below are some notes from presentations by Paul McKimmy , Michael Menchaca , and others, with some independent research notes. Generative AI is predictive.  Generative AI produces new texts, images, sounds, and videos based on a trained model with a large language database. But it does not recite them. AI produces what it predicts as a reasonable response to a question, but not necessarily as a factual or accurate response. It is not a dictionary or an encyclopedia. This is the reason that you will receive different responses for the same question that you ask at different times. As Dr. McKimmy said, "If you are not the expert to evaluate the response, you have a problem." What can AI do? Brainstorm Draft Outline Writing Programming Everything that we ask students to do in a written assignment  Source  AI in Syllabus and Classroom, ...
Post a Comment
Read more

Maddening Tabs tamed

Have you ever had the experience where you have 15 tabs open in a browser and you can't find the tabs that you just opened so you have to go to your email or your Zoom Chat to copy and paste the link to create yet another tab to be lost in the forest of tabs!!! As my project lists grew longer, I spent longer and longer time finding the right tab. The difficulty of finding the right tabs has been the pet peeve that I brought up consistently in all my Zoom meetings in the past two weeks. A rewarding experience is the tips and strategies that my different Zoom collaborators shared, summarized below: Close them promptly. Leave the only tabs open for your current project. (Good suggestion. But as I have 10 projects going on at the same time, if I close a tab, I may miss a task that I need to complete.) Pin tabs. It's maddening that I always have to find where my email and my calendar tabs are. Right-click on them in Chrome. Select  pin . Now my email is always the first tab to...
Post a Comment
Read more

Choose WHO not HOW for effective time management

 Today, I accidentally bumped into this video  Achieve more In 1 DAY Than Others Do In 1 WEEK (Ask Who, Not How!) - YouTube  by Little Bit Better. Some ideas are refreshing. This video is a book summary of WHO NOT HOW by Dan Sullivan, who give 11 Lessons for entrepreneurs to better manage their time. The most important lesson is to ask the question of WHO. Who can solve this problem for me? Problems can be divided into two types: technical problems and adaptive problems. Find WHO for the technical problems and focus your time and energy on the adaptative problems that only you can answer.  For example, if you have a business, you need a website. This is a technical problem. Hire the WHO to solve it. On the other hand, how to grow the business is an adaptive problem. It needs your creative ideas. No one can replace you. So you will have to do it. When you go about the adaptive problems, ask yourself the seven questions as the "Impact Filter": 1. What is the project? W...
Post a Comment
Read more

Facelift your report and articles to increase the access and influence of your assessment work!

Image
I love Chris Lysy and his freshspectrum blogs and cartoons. This is an evaluator who knows how to communicate and catch his audience's attention. In a recent blog: Access is NOT a Vanity Metric . Chris proposed five strategies to increase access to one's work, traditionally presented in the form of a report (as PDF files posted on the website) or as journal articles behind the Login gates. His strategies are: take a PDF and adapt it into an HTML-based report. take a long wordy report and adapt it into a string of infographics. take a report written at a post-graduate reading level and adapt it into a report that doesn’t require more than a lower secondary education level. turn big tables or complicated charts into nice, easy-to-follow charts. turn qualitative interview transcripts into a story collection. (Blogging is also what Chris proposed to increase access to and influence of one's work, back in 2011 in fact. And I finally started doing it now in 2023, more than a de...
Post a Comment
Read more

Preparing kid for applying La Pietra

Image
Private school is expensive. And you have to be really good at academics to be admitted. For these two reasons, I have not thought about sending my kids to private schools. Yet one day in early June, I got a call from the Vice Principal for my 5th grade graduating daughter, recommending her to apply for La Pietra because her teacher considered her as a top 20% student. I was in quite some disbelief. I know my daughter is creative and talented in her way, but top 20% in academics?! But who am I to deny her the opportunity to go to La Pietra. So I went on this process to apply for a private school and below are lessons learned (in progress).  1. You can make the cost manageable by applying for both financial aid and merit-based scholarships from the school and other organizations. The Financial Aid application is done through a third-party vendor and charges a fee ($60 for School & Student Services ). Completing the financial aid is like the experience of filing taxes on your ow...
Post a Comment
Read more