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
Exam prep
Homework help
Code Review
Job readiness
Upskilling
Project help
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 adults
Coding for beginners
Coding for kids
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
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
The Student and Tutor reviewed intermediate Excel functions, including table creation, dynamic updates, and cross-sheet data referencing. They then transitioned to a comprehensive lesson on effective file management and organization, covering local folder structures and the benefits of cloud storage. The Student expressed a desire for future lessons to adopt a problem-based learning approach, applying Excel skills to real-world scenarios like financial statement analysis.
Excel Tables vs. Ranges for Data Management
Inter-Sheet Data Referencing in Excel
Structured File & Folder Organization
Document Version Control & Cloud Backup
Secure Password Management
The Student and Tutor reviewed the Student's independent work using the `SUMIFS` function in Excel. They then focused on modifying the `SUMIFS` formula to calculate "units sold" and applying `SUMIFS` with multiple criteria. The Student also learned how to use data filters to verify calculation results, and was assigned to complete the remaining "units sold" calculations as homework. The next session was scheduled.
Extending SUMIFS for Different Metrics
Dynamic Data Setup with 'Remove Duplicates'
Multi-Criteria SUMIFS for Granular Analysis
Essential Formula Debugging in Excel
Verifying Data Accuracy with Filters
Standard Number Formatting for Clarity
Student and Tutor continued working on an Excel project to identify and manage account discrepancies within a business context. They focused on refining complex spreadsheet formulas and data organization to streamline the identification of accounts needing performance adjustments, specifically utilizing XLOOKUP and IF statements for dynamic owner assignment and advanced data filtering. They also discussed setting up saved filter views for efficient data analysis, with the Student planning to apply these techniques.
Identifying Hidden Revenue Discrepancies
Dynamic Partner Assignment for Performance Adjustments
Configuring Auxiliary Lookup Tables for Flexibility
Handling Blank Rows and Errors with `IF` and `IFERROR`
Advanced Filtering with `FILTER` and Multiple Conditions (`OR`/`AND`)
Leveraging Filter Views for Personalized Reports
Approach & tools used by coding tutor
Visual Studio Code
Google Colab
Jupyter Notebook
Hands-on coding classes
Parent feedback
Note taking
Weekend lessons
Record lessons
Pets are welcomed

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