Learning path topics
-
Week 2: Python is a Database
Today we introduce basic types (integers, floats, booleans, lists, and dictionaries) that allow you to store data.
Time estimation: 1 hour 30 minutes
Learning objectives:
- Explain key differences between integers and floating point numbers.
- Explain key differences between numbers...
-
Week 3: Python is a Computer
Once you’ve covered basic datatypes, let’s do interesting things with Python like Loops! And Flow Control! Python lets you automate calculations and tasks and we’ll learn about that building block this week.
Time estimation: 1 hour 20 minutes
Learning objectives:
- Write conditional...
-
Week 3: SQL in other languages
Based on which language you’re teaching alongside SQL, you can choose one of the following lessons which have the same content for different programming languages.
Time estimation: 1 hour 30 minutes
Learning Objectives
- Write short programs that execute SQL queries.
- Trace the...
-
Week 4: Python is a Programming Language
Now that we’ve covered 90% of what you will write when you write a programming language, let’s look at the last 10%, reading and writing files and handling exceptional circumstances.
Time estimation: 1 hour 50 minutes
Learning objectives:
- catch an exception
- raise your own...
-
Week 4: Schema Design
In the Avans course an external tool was used when discussing Schema design.
-
Week 5: Recap
You’re now a Python Programmer! This week we’ll go over everything you learned and work on some exercises that require putting together all of your new skills.
Time estimation: 1 hour 30 minutes
Learning objectives:
- Recap all previous modules.
- Use exercises to ensure that all...
-
Week 6: Python is a Command Line Interface
Here we’ll move into some more advanced topics that will make you a better python programmer!
Time estimation: 45 minutes
Learning objectives:
- Use glob to collect a list of files
- Learn about the potential pitfalls of glob
- Learn how sys.argv works
- Write a simple command line...
-
Week 7: Python is a Workflow Engine
Cont.
Learning objectives:
- Run a command in a subprocess.
- Learn about check_call and check_output and when to use each of these.
- Read it's output.
- Set up a Python virtual environment for our software project using venv and pip.
- Run our software from the command...
-
Week 8: Review Period
This course is an extremely fast 8 weeks, so this last week is spent on helping students debug problems in-person