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
Homework help
Project help
Debugging
Job readiness
Upskilling
Assignment 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 College students
Coding for Kids
Coding for Adults
Coding for School students
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
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
The Student and Tutor continued their Excel lesson, focusing on troubleshooting `SUMIFS` function errors and understanding the behavior of Excel tables. They corrected a formula error related to inconsistent range sizing, explored how tables autofill formulas, and dissected various Excel error messages including `#SPILL!`, `#VALUE!`, and `#REF!`. The next session will cover `VLOOKUP` and `XLOOKUP` functions, with the Student planning to use real-world data for practice.
Efficiency in Excel: Formatting & UI Shortcuts
Common Excel Error Messages: Diagnosis and Resolution
Excel Table Dynamic Behavior
SUMIFS Function Debugging & Range Consistency
Student and Tutor worked on updating an Excel dashboard by adding new monthly data. They practiced filtering data, copying specific columns, pasting values into a combined data tab, and refreshing a pivot table to reflect the changes. The session also covered troubleshooting common issues related to data visibility and filter application.
Clearing & Filtering Data in Excel
Accurate Data Copying & Pasting (Values Only)
Refreshing & Verifying Pivot Table Updates
The Tutor and Student worked with spreadsheet data, focusing on text manipulation techniques. They practiced using functions like SPLIT, TRIM, PROPER, TEXTJOIN, UPPER, and LOWER to clean, reformat, and split data. The next session is scheduled for Tuesday, June 2nd at 10 a.m.
Handling and Modifying Original Data
Text Join Function
Spreadsheet Data Splitting and Cleaning
Approach & tools used by coding tutor
Google Colab
Visual Studio Code
Jupyter Notebook
Hands-on coding classes
Chat for quick help
Pets are welcomed
Open Q&A
Record lessons
Weekend lessons

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