Versatile Teaching
High Standards
Bright Future
Absolutely Free
Both the Excel and Python courses are conducted through an open admission system. This means no formal enrolment is required. You can complete either of these courses at your own pace, in your own time. All you need to do is complete the Excel or Python (or both) video courses via the website. All assignments, tasks, projects, and quizzes will be available on the website by June 30, 2024. Please watch all the videos and ensure you are confident with the concepts taught.
Please prepare assignments, tasks, complete projects, and reflections, but keep them in a folder on your computer. Once you are confident that you have learned all the concepts and completed all the assignments, reflections, and tasks, please contact us via email at admin@fordandlord.com to indicate that you are ready for the exam. We will then send you a link to a Google Classroom page with the code. You will need to join the classroom and submit all the assignments, projects, and course reflections at once.
We will check and mark all the coursework. If you have achieved satisfactory results, we will invite you for an interview via an online meeting. During the interview, we will test your knowledge, and if you are successful, we will issue a certificate of completion.
How this course works. How to make the most of it.
Introduction to Python programming.
Understanding programming concepts and Python basics. Installing Python and setting up the development environment.
Please read the article provided in the week 1 assignment carefully and try to understand the concepts. Also, assignments and quizzes are available in the week 1 card.
Data Types: Strings, Integers, Floats, Lists, Sets, and Booleans.
Assignments and quizzes are available in the week 2 card.
Variables in Python.
Assignments and quizzes are available in the week 3 card.
Arithmetic Operators in Python, Basic Operators and Expressions.
Assignments and quizzes are available in the week 4 card.
String Formatting.
Please read the article provided in the week 5 assignment carefully and try to understand the concepts. Also, assignments and quizzes are available in the week 5 card.
In-place Arithmetic Operators.
Please read the article provided in the week 6 assignment carefully and try to understand the concepts. Also, assignments and quizzes are available in the week 6 card.
List Comprehension.
Please read the article provided in the week 7 assignment carefully and try to understand the concepts. Also, assignments and quizzes are available in the week 7 card.
Loops - for and while loops.
Please read the article provided in the week 8 assignment carefully and try to understand the concepts. Also, assignments and quizzes are available in the week 8 card.
Control Flow: if statements and conditions.
Please read the article provided in the week 9 assignment carefully and try to understand the concepts. Also, assignments and quizzes are available in the week 9 card.
Enumerate function.
List and Dictionary – Data Types.
Assignments and quizzes are available in the week 10 card.
Code execution project using dictionaries.
Only assignments are available in the week 11 card.
Slice Operator.
Please read the article provided in the week 12 assignment carefully and try to understand the concepts. Also, assignments and quizzes are available in the week 12 card.
Functions.
Assignments and quizzes are available in the week 13 card.
Project Title: Even Numbers Sorter.
The following video will help you complete this project. Also, assignments and quizzes are available in the week 14 card.
Task: Create a new script to achieve the same functionality as in week 14, but this time use a function and
the built-in sorted()
function.
Assignments and quizzes are available in the week 15 card.
How To Create A Function That Identifies Prime Or Composite Numbers.
Only assignments are available in the week 16 card.
How To Create A Function That Identifies Prime Or Composite Numbers.
Assignments and quizzes are available in the week 17 card.
The Return Keyword in Python.
Please read the article provided in the week 18 assignment carefully and try to understand the concepts. Also, assignments and quizzes are available in the week 18 card.
Submission Guidelines: Students should create a single Python script (.py file) containing the code for all tasks. The code should be well-commented. Optionally (not mandatory), you can follow the PEP 8 style guidelines. Submissions should be uploaded to the Google Classroom assignment when requested. Please search online to find out what the PEP 8 style guidelines are.
Click On Below Button For Learning New Topic.
Click On Below Button For Learning New Topic.
These questions are designed to encourage critical thinking, reinforce understanding of programming concepts, and promote active engagement with the Turtle module and geometric shapes in Python.
Your reflection should be approximately 500 words in length. Be sure to provide specific examples from the video and your own experiences to support your points. Aim to be clear and concise in your writing.
Note : Please read the following article carefully and try to understand the concepts. Read Article
Objective : This assignment aims to familiarize students with basic Python syntax and variables. The concept of variables will be discussed in detail in Week 3. It is recommended that you watch the Week 3 video before completing the following assignments.
Submission Guidelines : Students should create a single Python script (.py file) containing the code for all tasks. The code should be well-commented. Optionally (not mandatory), you can follow the PEP 8 style guidelines. Submissions should be uploaded to the Google Classroom assignment when requested. Please search online to find out what the PEP 8 style guidelines are.
Click On Below Button For Learning New Topic.
Objective : This assignment aims to familiarize students with basic concepts of variables and their appropriate use.
Requirements : This assignment aims to familiarize students with basic concepts of variables and their appropriate use.
Challenge : Implement validation to ensure that the input scores are within a
valid range (e.g., 0-100 for grades).
These assignments will require students to utilize variables effectively, handle user
input, perform calculations, and apply conditional logic as needed. They provide
practical exercises that can enhance students' understanding of variables and
programming concepts in Python.
Submission Guidelines : Students should create a single Python script (.py file)
containing the
code for all tasks. The code should be well-commented. Optionally (not mandatory), you can
follow the PEP 8 style guidelines. Submissions should be uploaded to the Google Classroom
assignment when requested. Please search online to find out what the PEP 8 style guidelines
are.
Click On Below Button For Learning New Topic.
Write a Python script that takes input from users and prints a times table. Please refer to the video above if you need help. Submit a single .py file for this assignment via Google Classroom when instructed.
Reflection: Write a 2-page document reflecting on the video tutorial, describing what arithmetic operators are in Python. Why did we use the int() function in the video? How many different arithmetic operators were used in the video?
An Alt code was used in the video. What is the code, and what does it do? Provide some other examples of Alt codes of your choice that can be used for mathematical operations.
Type the following in your IDE : to see what you get as a result and explain your findings in a single-page document. Please submit the document to Google Classroom when requested.
Submission Guidelines : Students should create a single Python script (.py file) containing the code for all tasks. The code should be well-commented. Optionally (not mandatory), you can follow the PEP 8 style guidelines. Submissions should be uploaded to the Google Classroom assignment when requested. Please search online to find out what the PEP 8 style guidelines are.
Reflection: Write a single-page document describing which string formatting method has been used in the video.
Describe the purpose of {vnum:.5f}
and what it does. Explain your answer in a
single-page
document. Please submit the document to Google Classroom when requested.
Note : Read the following article to understand what string formatting is. Questions will be asked from this document during the final exam. Read Article
Submission Guidelines : Students should create a single Python script (.py file) containing the code for all tasks. The code should be well-commented. Optionally (not mandatory), you can follow the PEP 8 style guidelines. Submissions should be uploaded to the Google Classroom assignment when requested. Please search online to find out what the PEP 8 style guidelines are.
Click On Below Button For Learning New Topic.
Reflection : Write a single-page document describing inplace arithmetic operators and their purpose.
Identify another important concept used in the video.
Write a Python script to create a times table as shown in the video using a while loop. Submit a single .py file to Google Classroom when requested.
Note : Read the document below and make sure you understand it thoroughly. Read Article
Submission Guidelines : Students should create a single Python script (.py file) containing the code for all tasks. The code should be well-commented. Optionally (not mandatory), you can follow the PEP 8 style guidelines. Submissions should be uploaded to the Google Classroom assignment when requested. Please search online to find out what the PEP 8 style guidelines are.
Reflection : Write a single-page document defining and describing list comprehension and discussing the benefits of using list comprehension.
Create a simple program that uses list comprehension. You can use examples from the video or come up with your own program.
Note : Read the following article to understand what a list comprehension is. Questions will be asked from this document during the final exam. Read Article
Submission Guidelines : Students should create a single Python script (.py file) containing the code for all tasks. The code should be well-commented. Optionally (not mandatory), you can follow the PEP 8 style guidelines. Submissions should be uploaded to the Google Classroom assignment when requested. Please search online to find out what the PEP 8 style guidelines are.
Click On Below Button For Learning New Topic.
Reflection : Write a single-page document defining and describing loops in Python and explaining why they are super useful in programming.
Recreate the two projects described in the following video : Watch Video
Note : Read the following document to understand loops in Python, including for and while loops. Questions will be asked from this document during the final exam. Read Article
Submission Guidelines : Students should create a single Python script (.py file) containing the code for all tasks. The code should be well-commented. Optionally (not mandatory), you can follow the PEP 8 style guidelines. Submissions should be uploaded to the Google Classroom assignment when requested. Please search online to find out what the PEP 8 style guidelines are.
Click On Below Button For Learning New Topic.
Reflection : Write a single-page document describing your understanding of control flow and how it is used in programming for decision-making.
Create two projects of your choice that use control flow by using if, elif, and else statements.
Note : Read the following article to understand what control flow and if statements mean. Questions will be asked from this document during the final exam. It is important to know the definition of Control Flow in Python by heart. Read Article
Submission Guidelines : Students should create a single Python script (.py file) containing the code for all tasks. The code should be well-commented. Optionally (not mandatory), you can follow the PEP 8 style guidelines. Submissions should be uploaded to the Google Classroom assignment when requested. Please search online to find out what the PEP 8 style guidelines are.
Click On Below Button For Learning New Topic.
Create a Python list that has numbers from 1 to 10 in random order. In the program, write three print statements showing index positions of three different numbers from the list that you created. Submit a single .py file to Google Classroom when requested.
Recreate the solution to a challenge from leetcode.com using different variable names. Submit the .py file to Google Classroom when requested.
Write a 1-2 page document discussing leetcode.com and how it can be used to improve skills in Python and prepare for job opportunities in international markets, enabling earning in foreign currencies. Submit the document to Google Classroom when requested.
Create two projects of your choice from leetcode.com and submit the .py files to Google Classroom when requested.
Submission Guidelines : Students should create a single Python script (.py file) containing the code for all tasks. The code should be well-commented. Optionally (not mandatory), you can follow the PEP 8 style guidelines. Submissions should be uploaded to the Google Classroom assignment when requested. Please search online to find out what the PEP 8 style guidelines are.
Click On Below Button For Learning New Topic.
Reflection : Write a 1–2 page document describing why it is important to understand how code executes in any program. Provide a detailed reflection on what you learned in the following video.
Submission Guidelines : Submissions should be uploaded to the Google Classroom assignment when requested.
The Text Analyzer project is designed to help students analyse text input provided by the user. It involves processing the text to extract useful information such as word count, character count, and generating word frequency statistics using the slice operator.
split()
method.word_freq = {}
).Note : Read the following article to understand what a slice operator is. Questions will be asked from this document during the final exam. Read Article
Students should create a single Python script (.py file) containing the code for all tasks. The code should be well-commented. Optionally (not mandatory), you can follow the PEP 8 style guidelines. Submissions should be uploaded to the Google Classroom assignment when requested. Please search online to find out what the PEP 8 style guidelines are.
For more information, visit the Google Docs link.
The objective of this assignment is to deepen your understanding of functions in Python, including function definitions, parameters, return values, and function calls.
Define a function named greet_user
that takes a parameter
username
and prints a greeting message like "Hello, [username]! Welcome to Python
Functions."
Define a function named calculate_area
that takes two parameters
length
and width
and returns the perimeter of a rectangle
(Perimeter=2×(length
+ width)).
Define a function named calculate_volume
that takes three parameters
length
, width
, and height
, where height
is
optional
with a default value of 1. This function should return the volume of a rectangular prism (volume =
length * width * height).
Define a function named is_even
that takes a parameter
number
and returns True
if the number is even, otherwise False
.
Call each of the functions defined above with appropriate arguments and print the results.
Define a function named calculate_total_cost
that takes parameters
price
and quantity
and calculates the total cost (total_cost = price *
quantity). Then, define another function named apply_discount
that takes parameters
total_cost
and discount_rate
(default value 0.1 for 10% discount) and
returns
the discounted cost. Finally, call these functions in sequence to calculate and print the discounted
cost.
Create your own custom functions with different functionalities and use them in meaningful ways to solve problems or perform calculations.
This assignment structure covers a range of concepts related to functions in
Python,
from basic function definitions to more advanced topics like default parameters and
function composition.
Students will have the opportunity to practice writing functions,
working with
parameters, and understanding return values, which are fundamental skills in Python programming.
Feel
free to modify or expand upon these tasks based on your students' proficiency level and learning
objectives.
Students should create a single Python script (.py file) containing the code for all
tasks.
The code should be well-commented.
Optionally (not mandatory), you can follow the PEP 8 style
guidelines.
Submissions should be uploaded to the Google Classroom assignment when requested.
Please
search online to find out what the PEP 8 style guidelines are.
Click On Below Button For Learning New Topic.
In this project, you will write a Python program to find all the even numbers from a given list of integers and then sort them in descending order.
The project "Even Numbers Sorter" is designed to help you practice filtering and sorting even numbers from a list of integers in Python. It includes a set of tasks and requirements to ensure your program is robust and user-friendly. Good luck with your project!
Task : Create a new script to achieve the same functionality as in week-14, but this time use a function and the built-in `sorted()` function.
Click On Below Button For Learning New Topic.
Watch the following video to understand how to create a function that identifies prime or composite numbers. Watch Video
Click On Below Button For Learning New Topic.
There are no assignments this week, but it is likely that you may be required to recreate this project in the final exam.
Click On Below Button For Learning New Topic.
Please read the following article carefully and try to understand the concepts : Read Article
Watch the following video to understand how to create a function that
identifies prime or composite numbers.
Watch Video
These tasks and resources are provided to help you deepen your understanding of Python
programming concepts. Good luck with your learning!