Steven Lawrence
Coding Tutor from Thomas College - Python Lessons for Kids




Show all photos
Steven Lawrence
Bachelors degree
/ 55 min
About your coding tutor - Steven
I am an experienced programmer with a passion for problem-solving and software development. With years of coding experience across multiple languages, including Python, I specialize in breaking down complex problems into clear, logical steps. My ability to analyze challenges and develop efficient solutions has helped me create robust applications, automate tasks, and optimize workflows. One of my key strengths is visualizing code execution—understanding how each function interacts within a system before implementation. This skill is especially valuable in Python, where data structures, algorithms, and logic flow play a critical role in building scalable solutions. I teach my students how to think beyond individual lines of code, helping them develop a strategic mindset for efficient programming. My structured six-lesson series is designed to prepare students for professional coding roles. Whether you’re aiming to start a career in tech or refine your programming skills, my approach ensures you gain a deep understanding of problem-solving strategies, debugging techniques, and real-world applications—especially in Python, one of the most versatile and powerful languages in the industry. If you’re looking for a tutor who can simplify programming, strengthen problem-solving abilities, and help you visualize what happens when code is executed, I’d love to work with you!
Coding tutor specialities
Job readiness
Exam prep
Homework help
Upskilling
Code Optimization
Code Review
AI modules
Summary
Podcast
Quiz
Learnings
Flashcard
Spotlight
Zero Risk Guaranteed
15-days refund
Free tutor swap
No cancel fee
1-yr validity
24/7 support
Learner types for coding classes
Coding for kids
Coding for adults
Coding for beginners
Coding class highlights
Programming is more than just writing code—it’s about designing solutions that are efficient, scalable, and adaptable. While implementation is important, code design is the foundation of a well-structured program. A strong design ensures code remains maintainable and capable of handling real-world challenges. I structure my teaching approach around three key steps: WHAT, WHY, and HOW. WHAT – We define the problem and establish business rules that shape the project. Clear objectives ensure smart design choices. WHY – We analyze the purpose behind each function or system. Understanding why a solution is needed guides decision-making. HOW – With the what and why established, we write clean, optimized code with confidence, prioritizing architecture over rushed implementation. I foster a relaxed, interactive learning environment where students feel comfortable asking questions and developing creative solutions. My lessons are project-based, focusing on topics that genuinely inspire each student—whether it's automation, data analysis, or web applications using Python. By prioritizing code design first, students gain the ability to visualize how their code functions before writing it. This leads to cleaner, more efficient programs that stand the test of time. My goal is to help students master the thought process behind coding, ensuring long-term success in any tech career.
Hands-on learning
Students gain confidence applying coding skills to real projects.
Paired coding for effective learning
90% of students benefit from collaborative lessons.
Proven success with code projects
85% of students complete personal projects in a few months.
Steven - Coding tutor also teaches
Coding for kids
SQL

Coding concepts taught by Steven
Student and Tutor discussed strategies for organizing financial data in Google Sheets, including distinguishing between personal, work, and business expenses. They implemented an automated ID generation formula and refined the process for importing bank statement data from CSV files. Future sessions will focus on building automated data transformations using Power Query to streamline data entry from various bank sources.
Data Source Simplification & Single Source of Truth
Dynamic Unique ID Generation in Google Sheets
Optimizing Bank Statement Imports: CSV vs. PDF
Essential Data Transformations for Clean Imports
Introduction to Power Query for Automated Transformations
The Student and Tutor worked on enhancing an expense tracking system in Google Sheets. They implemented advanced `FILTER` and `CHOOSECOLS` functions to create a dynamic "Refund Status" sheet and extensively debugged a Google Apps Script to automate the updating and removal of paid refundable expenses. The Tutor shared an updated calendar link for planning future sessions.
Refining Dynamic Filters for Real-time Updates
Google Apps Script for Inter-Sheet Data Synchronization
Dynamic Data Extraction with Google Sheets Functions
Principles of Custom Financial Tracking
AI's Role and Limitations in Data Automation
Student and Tutor discussed foundational and advanced Excel functionalities. They practiced combining text from cells and thoroughly explored the differences and best practices for using "Merge & Center" versus "Center Across Selection." The Tutor also provided a demonstration of a complex, custom-built Excel application and explained the advantages of using Excel Tables for dynamic data management.
Center Across Selection: A Safer Alternative to Merging
Embracing Best Practices & Critical Feature Use
Excel as a Powerful Application Development Platform
Dynamic Excel Tables vs. Static Ranges
Merge & Center: Understanding Its Power and Pitfalls
Combining Text & Data Safely
The session commenced with the Tutor and Student performing audio checks. The Student then mentioned a specific problem they had discussed with their professor, indicating that the class was about to focus on reviewing or solving this particular academic challenge with the Tutor.
Remote Class Setup & Audio Verification
Proactive Problem Follow-up
Readiness for Interactive Presentation (Screen Sharing)
The Student and Tutor practiced advanced Excel functions for a sample exam. They worked on database queries using the `DAVERAGE` function, corrected formulas for calculating age and years of service, and developed logic for conditional birthday messages by comparing only the day and month of dates.
D-Functions for Database Queries with Criteria
Precise Age and Years of Service Calculations
Crafting Dynamic Birthday and Anniversary Alerts
The Student and Tutor worked on an Excel task involving data consolidation. They practiced filtering appointment data for June 2026 from two separate sheets, copying the filtered data, and pasting it into a combined tab. The session concluded with refreshing a pivot table to update it with the newly added data.
Efficient Data Selection and Copying
Appending Data to a Combined Sheet
Updating Excel Pivot Tables
Applying and Clearing Excel Filters
Approach & tools used by coding tutor
Visual Studio Code
Google Colab
Jupyter Notebook
Hands-on coding classes
Parent feedback
Weekend lessons
Open Q&A
Note taking
Pets are welcomed

Programming tutors on Wiingy are vetted for quality
Every tutor is interviewed and selected for subject expertise and teaching skill.
