Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Introduction to Visual Basic using Karel the Robot in Excel
Rating: 4.0 out of 5(66 ratings)
7,628 students

Introduction to Visual Basic using Karel the Robot in Excel

Programming a Virtual Robot
Created byScott Knecht
Last updated 7/2018
English
English [Auto],

What you'll learn

  • Students who apply themselves will find a breakthrough in their approach to designing macros.

Course content

1 section8 lectures34m total length
  • Loops: While, For4:02

    Demonstrates using while and for loops in Visual Basic with Karel the robot in Excel, including declaring a loop variable, simple wall navigation, and turning after a loop.

  • If Statement and Functions (Subs)4:06

    Learn how to implement if statements and functions (subs) in Visual Basic, using Karel the robot in Excel to perform conditional turns and run sub procedures.

  • Debugger using [Shift+F8] and [F8] keys3:19

    Learn to debug in Visual Basic with Karel the Robot in Excel by setting stops, resetting, and stepping through code with Shift+F8 and F8 to step into or over.

  • Methodology4:59

    Embrace a methodology for problem solving with Karl the robot, organize your logic before language-specific syntax, and explore Stanford resources and quick reference cards.

  • Decomposition - Your First Challenge6:50

    Practice decomposition by building a Karel the Robot program, create methods for each step, and test with run macro to move to beeper, pick it up, return to starting point.

  • Karel the Robot Challenges / Puzzles2:41

    Explore Karel the robot challenges in excel by using solutions and training files, and run macros to see how the code is implemented; then practice with and without variables.

  • Visual Basic Resources and Code6:48

    Explore Visual Basic resources and code for Excel, including macros, viewing macro code, input handling, variables, if statements, loops, and recording macros across workbooks.

  • Wrapping It Up1:52

    Wrap up the course by reviewing loops, while and for loops, if statements, and debugging; break tasks into smaller components, explore challenges and resources, and plan future in-depth videos.

Requirements

  • Microsoft Excel

Description

Karel the Robot, used by Stanford University and implemented here in Excel VBA, is a fun way to engage new students in creating programs.  

Stripping away any cumbersome details, we will use Karel the Robot to focus on the essence of programming.  We will practice how to organize your thoughts into the proper structure which will sharpen your skills for more difficult problems.

Who this course is for:

  • Someone wanting to take their macro and programming approach to the next level of efficiency.