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



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
Assignment help
Project help
Homework help
Upskilling
Job readiness
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 School students
Coding for College students
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 student and tutor worked on advanced XLOOKUP functions in Excel to retrieve and analyze data based on multiple conditions, specifically calculating sales variances. They practiced formula construction, troubleshooting, and discussed creating a template for automated reporting for future analysis.
XLOOKUP with Multiple Conditions
Handling Data Types and Formatting
Best Practices for Formula Creation
Calculating Variance with Lookups
The tutor and student explored methods to automate personal finance tracking in Excel, focusing on integrating dynamic budgeting with historical data and automating bank statement imports. They discussed the development of a more advanced financial analysis tool, with plans for the student to utilize a developed version in the near future.
Customizable Reporting and Data Visualization
VBA as an Advanced Excel Tool
Automated Bank Statement Import with VBA
Dynamic Budgeting in Excel
The student and tutor focused on advanced spreadsheet techniques, specifically addressing data extraction and handling duplicate or missing entries. They practiced using `FILTER`, `CHOOSE columns`, `UNIQUE`, and `VSTACK` functions to consolidate and analyze data from multiple sources, and implemented conditional logic and error handling for more robust reporting. The next session will involve building a comparison analysis sheet.
UNIQUE and VSTACK for Comprehensive Lists
FILTER and CHOOSECOLS Functions
VLOOKUP Limitations
Handling Blanks and Errors with IF and IFERROR
The Tutor and Student explored advanced Excel techniques for data analysis, focusing on pivot tables and formula-based approaches to recreate dynamic summaries. They practiced creating mapping tables and using checkboxes for flexible data filtering and analysis, with plans to apply these skills to a specific data set in the next session.
SUMIFS Function for Conditional Summation
Mapping Tables for Rule-Based Analysis
Checkboxes for Dynamic Data Control
Pivot Tables for Data Summarization
The session covered the distinctions between Excel ranges and tables, emphasizing the advantages of tables for dynamic data management and formula referencing. The tutor demonstrated practical applications and discussed future learning directions, including financial statement analysis and budgeting.
Range vs. Table in Excel
Dynamic Formulas with Tables
Boolean Values and Checkboxes
Dynamic Data Analysis with FILTER Function
The student and tutor worked through advanced Excel techniques, focusing on the IF statement for conditional logic in inventory reordering and VIP pricing calculations. They also practiced using absolute cell referencing with the F4 key to ensure formulas correctly update across multiple data entries. Homework assignments related to these concepts were planned.
Percentage Calculations in Excel
Excel Nested IF Statements and Flowcharts
Absolute vs. Relative Cell References
Excel IF Statement Logic
Approach & tools used by coding tutor
Google Colab
Visual Studio Code
Jupyter Notebook
Hands-on coding classes
Pets are welcomed
Note taking
Weekend lessons
Parent feedback
Chat for quick help

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