Adelaide University Internship Experience - Todd Guanhua Tao

Welcome Todd! 
Todd Guanhua Tao joined our SAcommunity Data Analytics Team and SAcommunity Website Rebuild Team for his University of Adelaide SET (Sciences, Engineering and Technology) Internship for his Masters of Computing and Innovation Semester 2, 2024: 13 August 2024 - 29 November 2024. 

He completed a 280 hour internship onsite with SAcommunity at the Connecting Up Office, Infoxchange for 3 days (22.5 hours) a week for ~14 weeks around his classes. Todd returned as a volunteer to Connecting Up on 3rd of December 2024 to continue to further investigate and build his skillset in Data Analytics.

Total Hours 305 This YearJoined 13 August 2024 Last Check-in 14 January 2025 
 
 
Section A: Personal Biography
Todd Guanhua Tao is in his final year of the Master of Computing and Innovation program at the University of Adelaide. He has an interdisciplinary background in Landscape Architecture, having graduated from a multifaceted design firm as a senior landscape architect and project manager. Many of his community-level projects have been praised by local residents once implemented. He has a proven track of records of awards both domestically and internationally. He chose to pursue a degree in Computing and Innovation after encountering smart city projects, where extensive data-driven charts and reports were utilized during the early design stages to support decision-making.

He joined the Connecting Up Data Analytics Team and the SAcommunity Website Redevelopment Team to follow his passionate goal of acquiring skills in Data Analytics and Full Stack Development. Todd aims to gain a deep understanding of Data Analytics tools such as Power BI and Google Analytics, while also refining transferable skills like project management and design from his previous experience. 

Todd plans to explore a career combining programming and landscape design, with the aim of leveraging data-driven insights, innovative software, and web projects to enhance the design process and improve societal well-being.
 

Outback Communities Authority Council Four Years Comparison Report
 
Section B: Community Services in Councils Project
Todd has selected the Outback Communities Authority for his Power BI council reports, a small database of approximately 53 community services operating in the area for the financial years 2021-2022 and 2022-2023, 2023-2024 and his completed reports will be found >>here.
 

Council Report Discussion Photo with Data Analytics Team 14 Aug 2024
 
Google Analytics 4 Data Cleaning Discussion Photo with Data Analytics Team 04 Sep 2024 .Left to Right: Aaron Xuefeng Li, Neil Anubhav DattaguptaEily Lee Selvam, Rajkarthick Raju, Mihir DesaiAlex Thi Ngoc-Bich NguyenTodd Guanhua TaoIvy Ling Luo

There are a number of steps involved in the creation of community service information data presentations. A summary of data trends prepared, using information from Google Analytics and SAcommunity with subsequent Power BI and Canva reports revealing data anomalies and corrections required, the database is updated and reports re-created with improved information. Final data reports are published to the website, and introduced by Todd to Outback Comminities Authority council stakeholders for information and/or feedback on 15 November 2024.

Todd participated in developing a Python script for cleaning raw data extracted from GA4. This project was a collaborative effort involving Todd, Neil, Mihir, and Jason. Todd's role was to compare the data cleaning results generated by the script with the manually checked results for the OCA dataset and conduct testing. The script significantly reduced the workload for interns and volunteers in cleaning raw council data.

Connecting Up Monthly Meeting with guest Kylie Love - Senior Human Resources Business Partner at Infoxchange, Tuesday 13 August 2024

Section C: Work experience - Internal and External Events, Connections and Networks
Volunteers and interns are encouraged to attend monthly SAcommunity Team meetings,  Connecting Up staff meetings, as well as quarterly all-staff Infoxchange Town Hall meetings to understand more about the organisation as a whole.
 
Organisation-wide news, events and projects are communicated through the staff channels, with weekly CEO Updates from David Spriggs. Informal 'Lunch and Learn' educational sessions and meetings create connections with staff and stakeholders. Whilst peer-to-peer training or capacity building and telephone techniques training allow for networking with other volunteers.
 
Interns are also given opportunities to attend Data Catalyst Network and ADIA stakeholder and partner events as they arise.

Relevant meetings Todd has attended include:


Connecting Up monthly All-staff meeting held 10 Sep 2024

Connecting Up monthly All-staff meeting held 08 Oct 2024
 
1.Connecting Up (CU) meetings
As a mandatory part of career development, Todd will attend the monthly Connecting Up staff meetings. From this event, volunteers and interns gain a deeper understanding of the working environment in the real world. They will grow rapidly in three key areas: gaining insight into the organization’s purpose and task assignments, learning how to extract key information from meetings, and learning how to quickly integrate into a team.

Specifically, during the meetings, Head of Connecting Up, Pankaj Chhalotre, first summarizes the core tasks and their status from the previous stage. This allows interns to better understand the organization’s objectives and the team’s current main tasks, helping them clarify their own development goals. In the staff meetings, every full-time employee provides a detailed work summary, which is an efficient and direct way for interns to familiarize themselves with team members.

 
Interns Todd and Ivy with Cameron Brown (right) 17 Sep 2024 
2. Mentor Meeting Program on 17 Sep 2024
Connecting Up Volunteers and Interns are provided with the opportunity to select staff members from across the wider Infoxchange organisation for an informational mentor meeting. Here they have the opportunity to ask more about staff members job roles and employment journey, and learn about their career and professional development, to gain insights and guidance that can be applied towards their own success.

Volunteers and interns both prepare 5 questions for their mentors and then are encouraged to record 5 aspects they felt were helpful for them to share on their portfolio for both them and other volunteers, and Todd shared his experience in meeting Cameron Brown, experienced 7-year Web Developer, Infoxchange.

Mentor - Cameron Brown, Web Developer
Cameron Brown is an experienced and technically focused mentor. He has served in web development at Infoxchange for nearly seven years. His experience in web development and IT has enabled Infoxchange to enhance our online customer experience and deliver products and services in new, innovative ways.

Career Insights:

The first question Todd and Ivy asked was whether self-paced and self-motivated projects from Udemy or Coursera would be useful for job applications. Cameron responded that it might be beneficial to select projects based on personal interests and that it’s not necessary to follow every episode in sequence. Doing this before entering the real world could add value.
 
Cameron then addressed our concern about the constantly emerging new technologies. He explained that it’s nearly impossible to keep up with everything since things change so rapidly. Instead, he advised focusing on a specific area rather than trying to cover everything in a broad field. For example, you don’t need to learn every programming language—it’s more practical to specialize, which makes staying up-to-date easier.
 
Experience Sharing:
When we discussed the importance of soft skills and networking, Cameron mentioned that "social relationships and knowing the right people are valued more than actual skills or talent when securing jobs these days. However, skills are definitely still important. Personally, I believe that soft skills and the ability to solve problems and research necessary technical skills are more valuable than trying to memorize or focus on specific technical skills."

Then, when asked, "If you could go back to the start of your career in web development, what do you wish you had known? What tips would you give to someone just starting out?", Cameron responded that he wouldn’t be as nervous or scared about trying to excel and get everything right from day one. He would also not be afraid to make mistakes and ask lots of questions. 

Telephone Techniques 11 September 2024: Led by Volunteer David Webb

3. Telephone Technique Training
Telephone techniques follow on with email and communication techniques, to assist Data Analytics Team members with understanding more about the directory and data collection methods, in data cleaning and updating their individual dataset information, and, in finally introducing and presenting their data reports to council stakeholders. There are several telephone techniques meetings, and practice is important as with the student's elevator pitches.
 
Innovation at Infoxchange on 25 September 2024
 
4. IX Community & Cultural Event 
 
a. Health & Wellbeing Webinar - Foods to Boost your Mood Webinars on 20 August 2024
Todd attended the Food to Boost your Mood webinar, hosted by Elaine Fox, Head of Product and Innovation at Healthworks. The webinar offered valuable insights into the connection between diet and mood, highlighting how a holistic dietary approach can profoundly influence emotional well-being.
 
Key takeaways from Todd:

The webinar offered insightful information about the connection between diet and mood, along with practical tips for improving my eating habits. Elaine Fox passionately introduced a variety of healthy dietary options and emphasized the importance of choosing minimally processed foods.

Key takeaways included her advice to consume moderate amounts of high-quality proteins such as seafood, lean meats, and dairy while limiting highly processed foods. She also recommended aiming for five servings of vegetables and two servings of fruit daily, as well as incorporating Omega-3 fats from sources like fish and nuts to promote brain health. One particularly valuable point was her caution about calorie-dense yet nutritionally poor foods, which may temporarily enhance mood but often lead to overeating and long-term health issues.

Overall, the webinar was both engaging and informative. It deepened my understanding of how food choices affect overall well-being and inspired me to reassess my diet and adopt a healthier approach.

b. Lunch & Learn - Innovation at Infoxchange on 25 September 2024
Jo Davies, Chief Operating Officer at Infoxchange, was the speaker of this webinar, where she discussed the importance of innovation. The webinar focused on defining innovation within the IX organization and its role in employee engagement feedback. Jo particularly emphasized that innovation is not only a core company value but also a principle that runs through all aspects of the company's work. The discussion aimed to help participants understand the true meaning of innovation and explore how to foster innovation within the organization.

Jo Davies shared her definition of innovation, stressing that it is not merely an expression of creativity but a process of turning ideas into concrete actions. She outlined several types of innovation, including incremental and disruptive innovation, providing examples such as Airbnb and Netflix to illustrate these concepts. Additionally, she explored how collaboration and process innovation can boost efficiency, ultimately helping to achieve organizational objectives.

Key takeaways from Todd:
Through this webinar, firstly, I gained a deep understanding that innovation is not just about coming up with new ideas, but more importantly, about putting those ideas into practice to create tangible value. Secondly, Jo Davies emphasized that innovation is an ongoing process that requires us to continually adapt to the evolving needs of the market. Thirdly, the most important takeaway is that I now understand that IX's innovation is divided into three phases.

The Three Horizon Model shows that in the current phase, we focus on product and service innovation, such as client management and managed IT services. In the near term, we plan to focus on innovations like the data warehouse and AI applications. In the future, IX will prioritize innovations related to the Digital Future Fund. This gives me a clearer understanding of Infoxchange's developmental goals at different stages. This webinar made me reflect on areas in my daily work where I can apply innovation to optimize processes and eliminate "human duct tape fixes." 

Data Catalyst Network Webinar with The Smith Family on 01 October 2024

c. Data Catalyst Network (DCN) September Webinar | Working with Government data - Lessons from the Learning for Life program

Anne Hampshire, Head of Research and Advocacy of The Smith Famiily conducted a discussion on working with government data. The purpose of this introduction is to share insights about working with sensitive data. The Smith Family Learning for Life program - which is designed to support children experiencing disadvantage by providing them with the necessary resources to engage with school and improve their educational outcomes.

A key aspect of the program is the use of data to provide timely and targeted support. The Smith Family has partnered with the South Australian Department for Education to gain access to key educational data in real-time for students on their program. This data includes attendance, achievement, and behaviour management incidents, which are updated daily. This allows Learning for Life team members to support students and families as issues emerge, helping to identify and address problems early on.

Key takeaways from Todd:

a. Building Strong Relationships is Essential: The discussion emphasized that successful data-sharing arrangements with government entities rely heavily on pre-existing relationships. Trust and mutual understanding between organizations and government bodies are crucial for navigating legal, logistical, and operational complexities when dealing with sensitive data.

b. Clear Value Proposition and Data Security: When working with sensitive data, especially in government partnerships, it's important to clearly define the value proposition for all parties involved. Additionally, ensuring robust data management practices, such as verifying who has access to the data and maintaining security standards, is essential for building trust and ensuring successful collaboration.

c. Consent and Trust from Stakeholders: A significant part of the discussion highlighted the importance of obtaining consent from families and stakeholders, especially when dealing with sensitive data. The high level of trust from families, as demonstrated by a 95% consent rate, shows that when stakeholders believe data will be used to benefit them directly (such as improving educational outcomes for their children), they are more likely to participate in data-sharing initiatives.

Infoxchange RU OK Cake & Connect Day 10 September 2024

d. Cake and Connect - R U OK? DAY on 10 September 2024

Attending R U OK? Day provided a meaningful reminder of the importance of staying connected and checking in with those around us. The event emphasized the crucial role of having regular, heartfelt conversations to support anyone going through a challenging time. It reinforced the idea that asking “Are you OK?” should become a natural part of our everyday interactions, ensuring that people feel valued and supported, whether their struggles are big or small.

The Cake and Connect session was both delightful and insightful. Sharing cakes and engaging in casual conversations created a friendly and relaxed atmosphere. On top of that, we picked up some useful tips for boosting our physical and mental health, like getting some morning sunlight and taking a cold shower to invigorate ourselves. These little changes can make a big difference in how we feel day-to-day.

The opportunity to genuinely check in with one another was invaluable. The session was a reminder that reaching out should extend beyond the event itself. It’s essential to check in not only with colleagues but also with our families and friends. The day underscored that genuine care and connection can happen at any time, and that is something we should carry with us every day. 

Infoxchange Mental Health Week Event & Connect Day 10 September 2024

e. World Mental Health Day Networking Activity

During Mental Health Awareness Week, volunteers and interns were encouraged to have coffee chats with ConnectingUp full-time staff. The event focused on boosting mental, social, physical, and financial health through various activities. Staff were invited to enjoy a free coffee break as part of the initiative to enhance social well-being. This provided a relaxed environment for meaningful conversations and connections among colleagues Ivy, Aaron, and David. The activity created an opportunity to step away from work, recharge, and foster stronger workplace relationships. During the discussion, we talked about culture, food, and the challenges we encountered at work. This event was a great way to connect, communicate, and reduce mental stress.

Section D: Digital Training and Development 
Volunteers and interns have access to the Connecting Up Digital Learning Platform providing live webinars and recorded webinars, workshops and webcons presented by subject-matter experts to understand more about a range of technology topics for the not-for-profit sector.

Relevant training sessions were selected, attended, summarised and assessed by Todd to look at how these sessions can enhance his internship experience have included:

1.Getting Started with Analytics: Tools, Infrastructure & Data Webinar

This webinar was presented by Vivek Katial as part of the Data Catalyst basic webinars series. Vivek Katial is the Co-Founder and Executive Director at Good Data Institute, which works with not-for-profit organisations to help them elevate their data capabilities. 

Todd Guanhua Tao Certificate of Completion

Key Takeaways from Todd:

a. The Data Project Lifecycle: Analytics projects follow a structured lifecycle starting with defining objectives, gathering and cleaning data, analyzing insights, and implementing actions. Clear goals and clean, actionable data are essential for meaningful outcomes.

b. Handling Messy Data: Poor data quality leads to inaccurate insights and wasted resources. Standardizing data entry, regular cleaning, and automating processes can help mitigate common issues like typos, inconsistent formats, and missing information.

c. Ethical Considerations in Data: Ethical data collection requires awareness of inherent biases, which can skew insights and recommendations. This is especially critical when analyzing datasets that disproportionately represent economically developed regions.

2. PowerApps – capture NFP data & digitise workflows without coding

This webinar was presented by Cathy Xu and Alexander George, both are skilled Power Platform Architect and Trainer at Microsoft, This course is designed to teach participants: Functionality and capabilities of Microsoft Power Apps, Developing Power Apps for various purposes, and Creating workflows and automating processes using Power Apps.

Todd Guanhua Tao Certificate of Completion

Key Takeaways from Todd:

a. Through the webinar, I learned that Microsoft Power Platform combines low-code tools like Power Apps, Power Automate, and Power Pages to help organizations build apps, automate workflows, and create modern websites with minimal technical expertise.

b. The presenters demonstrated a typical workflow using Power Apps, but I need to come up with my own business idea to apply the tools effectively. The idea is the most crucial part.

3. Getting started with data: Strategy and collection for your NFP 

Karma Effect, and KiwiBots. The aim of this webinar is to help juniors learn how to empower their NGOs with the tools needed to kick-start their data journey.

Todd Guanhua Tao Certificate of Completion

Key Takeaways from Todd:

a. My reflection is that a well-defined data strategy begins with clear objectives and an assessment of an organization's data maturity. This includes identifying the goals, fostering a data culture, and ensuring that the project scope aligns with available resources to create a sustainable impact.

b. Embedding ethical considerations into data collection is critical for unbiased and meaningful insights. Organizations must address potential biases during data analysis, especially when comparing datasets from varying socio-economic contexts, as these biases can significantly influence decision-making and outcomes.

c. Digitizing workflows and leveraging automated data collection processes, such as using Google Forms, can streamline operations while reducing manual errors. This approach not only saves time but also supports creating a unified 'single source of truth,' enabling accurate and actionable data-driven decisions. 

4.Gain a clear understanding of your organisation's data and impact using Power BI 

Marcus Harvey, the head of Infoxchange's IT consulting and services teams in Australia and New Zealand, held this webinar to provide valuable insights into the relationship between data analysis and non-profit organizations (NFPs). Marcus presented a potential pathway for NFPs to extract more insights from their data, gain a deeper understanding of their clients, and identify current service gaps, enabling them to work smarter, not harder, and achieve measurable outcomes with the clients and communities they serve. 

Todd Guanhua Tao Certificate of Completion

Key Takeaways from Todd: 

a. Firstly, from the webinar, I learned that most NFPs don’t have easy access to critical information. According to the survey conducted by Marcus, 50% of organizations reported that their systems aren’t capable of capturing information about client outcomes. Therefore, data analytics is undoubtedly an effective way to help NFPs uncover hidden insights and make more informed decisions about service provision. 

b. Secondly, if an NFP wants to begin with data analytics and visualization, clean data and the right tool selection are crucial steps. Data cleaning ensures that the dataset is accurate and reliable, which in turn guarantees the validity of any inferences and conclusions drawn. Additionally, while there are many tools available for data visualization and analysis, Power BI stands out as a more user-friendly option that is sufficient to meet the initial data analysis and visualization needs of NFPs. 

c. Thirdly, I realized that the choice of data and tools largely depends on the type of services provided by the NFP and its organizational goals. These are just tools, after all. The true value of data analytics and the discovery of potential insights still rely on correct human decision-making. 

5. AI opportunities, risks and benefits for NFP's

This session will include a journey into what AI, Machine Learning and Computer Vision is through to Generative AI including key examples for not-for-profits. The presenter, Rita Arrigo is the Strategic Engagement Manager at CSIRO National AI Centre, focused on leading ecosystem strategy to foster engagement and collaboration across AI to lift Australia’s global AI leadership on commercialization and adoption.

Todd Guanhua Tao Certificate of Completion

Key Takeaways from Todd: 

 a. Generative AI's Transformative Potential for Nonprofits: AI tools, including generative AI, offer substantial benefits for not-for-profits by automating tasks like content creation, grant writing, and stakeholder engagement. These tools enhance productivity, reduce operational costs, and improve accessibility and inclusivity, making AI a critical co-pilot in modern nonprofit operations.

 b. Responsible AI Adoption and Ethics: Australia is emphasizing the responsible use of AI with frameworks like AI Ethics Principles and initiatives such as mandatory guardrails and voluntary safety standards. These measures aim to balance AI innovation with privacy, fairness, and transparency to safeguard societal and environmental well-being.

 c. AI for Community and Environmental Good: Case studies like Healthy Country AI and AI-powered conservation tools demonstrate how AI can address pressing challenges such as ecosystem health and cultural engagement. These applications showcase AI's potential to drive meaningful change beyond traditional organizational objectives. 

Final reflections and Career goal

I would like to demonstrate this section in the following aspects: 1. Technical and personal achievements. 2.Reflection about the weaknesses. 3. Impact on my career goal.

1. Technical and personal achievements.

During my internship, I was tasked with a wide range of activities, including developing my personal biography and portfolio, participating in career development activities, contributing to the Community Services in Councils Project, attending internal and external events, building connections and networks, and undergoing digital training and development. Each activity was tailored to support the development of both interns and volunteers. I approached these opportunities with a proactive mindset and successfully completed most of them on time.

The most significant achievement of this internship was publishing the Outback Communities Authority (OCA) organization web service report on the SAcommunity Website and delivering the report to the OCA representative. This accomplishment stood out as a pivotal contribution to the organization and highlighted the practical impact of my efforts.

2.Reflection about the weaknesses.

During this internship, I identified several personal weaknesses that affected my ability to work effectively in an Australian company. The most significant challenges were the language barrier and my coding proficiency. As English is my second language, I realized I need to invest more effort than my peers to communicate effectively. Moreover, my limited understanding of technical terminology and abstract expressions further compounded this challenge.

In terms of coding, my lack of prior experience placed me at a disadvantage compared to peers with more technical backgrounds. This weakness became particularly evident during my role at ConnectingUp, where technical proficiency was essential. Addressing these areas will be a top priority as I move forward in my career.

3.Impact on my career goal.

My career goals have evolved significantly over time. With a background in landscape architecture and data analysis, I initially aspired to create innovative designs, achieve recognition, and earn awards for my team. However, I eventually realized that the most rewarding aspect of my work was the interaction between designed spaces and the people who engaged with them. This realization led me to explore ways to quantitatively analyze and enhance these interactions, shifting my career focus.

 This internship played a crucial role in refining my career direction. Many of my tasks were closely tied to community-level matters, granting me valuable access to community data. I found the work both challenging and enjoyable, and I delivered tangible results. Through this experience, I discovered that community-level data analytics resonates more with my interests and skills than analyses at urban or national levels. My current career goal is to leverage data-driven insights to enhance the interaction between communities and designed spaces. This internship provided clarity and a strong foundation for this pursuit.

SAcommunity Website Rebuild Team: 

 

 

The SAcommunity website is licensed under a
Creative Commons Attribution 3.0 Australia Licence. © Copyright