Workshop on Visual Storytelling & Text Analysis


The 10-hour workshop was conducted for five days, from 28th January 2025 to 30th January 2025, 13th February 2025 and 27th March 2025. The workshop focused on introducing students to digital tools that could help in visual storytelling and text analysis.
Dr Jibrael Jos introduced the students to several features and functions of the familiar Excel software that can be useful in several ways, including analysing texts and creating visual presentations of data regarding stories. In the first session, Dr Jos introduced the students to functions like arithmetic progression, generating random numbers, finding minimum, maximum and averages between the numbers of selected cells, and so on. He showed the students ways to fill selected cells with relevant colours, and add icons into cells, with the use of conditional formatting. Then he introduced them to functions that could filter out the required number of characters from the text in a particular cell. In the second session, Dr Jos went on to explain how graph sheets can be created to visually present graphs for sentiment analysis over the course of a story, taking well-known fairy tales like Snow White, Cinderella, Beauty and the Beast, and Little Red Riding Hood as examples.
He taught the students different ways to organize the data so that it could be more accessible and effective in presenting the information. He also introduced students to the SmartArt feature, that the students can use to visually present diagrams and flowcharts in different ways. Then, he gave students an activity in which they have to gather data about a story, and then organize the data and visually present them with the tools and functions that have been introduced to them. The students came up with sentiment analysis graphs, action intensity graphs, flowcharts to depict the flow of events, and so on. In the third session, Dr Jos taught the students about different functions and applications of macro coding in Excel sheets. He taught the students how to enable the macro function, and create and edit macro modules.
He taught students to formulate strings of code that could automatically fill cells with textual or numerical data according to the commands in an instant, which would otherwise take more time when done manually. Lastly, he gave students some tasks to complete with the macro functions using the strings of code he taught them. In the fourth session, he showed the students different ways in which data can be presented visually so that they could be used to tell stories. Some of the examples of visual presentations mentioned in the workshop included timeline designing, story-mapping, and size comparisons.
In the fifth and last session, Dr Jos explained to the students about some important functions and libraries of Python that can be useful for conducting textual analyses. The workshop proved to be insightful for the students, who could apply what they have learnt in visually presenting data and conducting textual analyses using the features and functions of Excel software, Python programming, and other digital tools.

Comments

Popular posts from this blog

LAVASA, IN DEFENSE OF AN EDUCATION AMIDST NATURE

WEBINAR ON ROLE OF DIGITAL MARKETING IN THE PHARMACEUTICAL SECTOR

Attitude of Gratitude