[Go to site: main page, start]
Scribd
Upload
2 views4 pages

Python Programming Language - Basic Course

This document provides a basic course on Python programming, covering fundamental concepts such as print output, variables, data types, user input, control statements, loops, lists, functions, and a simple calculator. It also includes a learning roadmap and beginner project ideas, along with links to free online courses. Additionally, it outlines basic Excel formulas and their uses, which are essential for students and office work.

Uploaded by

ps278941013
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
2 views4 pages

Python Programming Language - Basic Course

This document provides a basic course on Python programming, covering fundamental concepts such as print output, variables, data types, user input, control statements, loops, lists, functions, and a simple calculator. It also includes a learning roadmap and beginner project ideas, along with links to free online courses. Additionally, it outlines basic Excel formulas and their uses, which are essential for students and office work.

Uploaded by

ps278941013
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Python Programming Language – Basic Course

Python is a beginner-friendly programming language used in web development, AI, data


science, automation, and software development.

1. Print Output

print("Hello World")

Output:

Hello World

2. Variables

name = "Piyush"
age = 16

print(name)
print(age)

3. Data Types

name = "Python" # String


age = 16 # Integer
height = 5.8 # Float
is_student = True # Boolean

4. User Input

name = input("Enter your name: ")


print("Hello", name)

5. If-Else Statement

age = 18

if age >= 18:


print("Adult")
else:
print("Minor")

6. Loops
For Loop

for i in range(1, 6):


print(i)

While Loop

count = 1

while count <= 5:


print(count)
count += 1

7. Lists

fruits = ["Apple", "Banana", "Mango"]

for fruit in fruits:


print(fruit)

8. Functions

def greet(name):
print("Hello", name)

greet("Piyush")

9. Simple Calculator

a = int(input("Enter first number: "))


b = int(input("Enter second number: "))

print("Sum =", a + b)

Learning Roadmap

1. Variables and Data Types

2. Input and Output

3. Operators
4. If-Else Conditions

5. Loops

6. Lists, Tuples, Dictionaries

7. Functions

8. File Handling

9. Object-Oriented Programming (OOP)

10. Projects

Beginner Project Ideas

Calculator

Student Marksheet

Number Guessing Game

To-Do List

Quiz Game

For free learning, beginner Python courses are available on platforms such as [CodeChef Learn
Python]([Link] and [Great
Learning Python
Fundamentals]([Link]
mentals-for-beginners?utm_source=[Link]).
Here are some basic Excel formulas with their names and uses:

Formula Name​ Formula​ Use


SUM​ =SUM(A1:A10)​ Adds numbers
AVERAGE​ =AVERAGE(A1:A10)​ Finds average
MAX​ =MAX(A1:A10)​ Largest value
MIN​ =MIN(A1:A10)​Smallest value
COUNT​ =COUNT(A1:A10)​ Counts numbers
COUNTA​ =COUNTA(A1:A10)​ Counts non-empty cells
IF​ =IF(A1>50,"Pass","Fail")​ Conditional result
TODAY​ =TODAY()​ Current date
NOW​ =NOW()​ Current date and time
LEN​ =LEN(A1)​ Counts characters
CONCAT​ =CONCAT(A1,B1)​ Joins text
LEFT​ =LEFT(A1,3)​ Extracts left characters
RIGHT​=RIGHT(A1,3)​Extracts right characters
ROUND​ =ROUND(A1,2)​ Rounds a number
VLOOKUP​ =VLOOKUP(A1,B:C,2,FALSE)​ Looks up data

Example Student Result Sheet

Name​ Marks​ Result

Rahul​ 85​ =IF(B2>=33,"Pass","Fail")


Aman​ 25​ =IF(B3>=33,"Pass","Fail")

These formulas are the foundation of any basic Excel course and are useful for Class 10–12
students, office work, and data management.

You might also like