Intermediate Report - (Darshan J Ronad-027)
Intermediate Report - (Darshan J Ronad-027)
BACHELOR OF ENGINEERING
In
DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING
Submitted By
Darshan J Ronad
4GM21CS027
2024-2025
CONTENTS
Attendance Report
Under the leadership of CEO Lokanatha Reddy, Palle Technologies has expanded its team to
over 300 professionals, including experienced trainers and developers working on cutting-edge
technologies . The company's development wing actively engages in software projects,
providing additional practical exposure to students.
1
Intermediate Report
Palle Technologies has garnered positive reviews from its alumni, many of whom have
transitioned into successful careers in the IT industry. Testimonials highlight the institute's
effective training methodologies, supportive faculty, and robust placement support. Notably,
students from non-IT backgrounds have also found success through the programs offered,
securing positions in reputable companies like Tech Mahindra and Cognizant.
o Website: www.techpalle.com
o Address: No. 15/6, 3rd Floor, Manish Complex, Mangammanapalya Main Road,
Bommanahalli, Bengaluru, Karnataka 560068
o Phone: +91 80 4164 5630
Programming is the process of writing instructions that a computer can understand and execute
to perform specific tasks.
Logic & Problem Solving – Breaking down a problem into steps that a computer can
follow.
2
Intermediate Report
Syntax & Semantics – Using the correct structure (syntax) and meaningful logic
(semantics) in a programming language.
Python is a high-level, interpreted programming language known for its simplicity, readability,
and versatility.
Day 3: Operators
Operators in Python are special symbols used to perform operations on variables and values.
+ (Addition) - (Subtraction)
* (Multiplication) / (Division)
3
Intermediate Report
>= (Greater than or equal to) <= (Less than or equal to)
& (AND)
| (OR)
^ (XOR)
~ (NOT)
= (Assign)
4
Intermediate Report
Day 5 : About print and input function and some of the basic programmers.
Example code :
In the Second week, we learned about data types and slicing in Python. Data types help us
understand what kind of information a variable holds. For example, numbers like 10 or 3.5 are
stored as integers and floats, while words and sentences are stored as strings. Lists and
dictionaries help organize multiple values efficiently.We also explored slicing, which allows us
to pick specific parts of a word or list. If we have the word "Python," slicing it from position 1
to 4 gives "yth." We can even reverse a word using slicing. These concepts make handling data
easier and more flexible in Python programming.
Slicing used for the accessing the characters or elements from the sequence data.
5
Intermediate Report
Technique 1 : Variable[index]
This Technique is used for accessing the character from left side to right side.
This technique is used for the accessing group of elements from right to left or left to
right(alternate order.
In this class we learn about numerical data structures int ,float ,complex,Boolean.
Integer (int) – Stores whole numbers (positive, negative, or zero) without decimal
points.
Floating Point (float) – Stores numbers with decimal points or in scientific notation.
Complex (complex) – Stores numbers with real and imaginary parts, represented as a
+ bj.
It stores the key value pairs.Having unique key but the values can be duplicate.It
follows insertion order
It allows homogeneous and heterogeneous data elements and there will be no index
based operations.By the help of key values we can access the values from the dictionary.
Syntax :
Variable_name={“key1”:”value1”,”key2”:”value2”……}
6
Intermediate Report
In the third week we learned about the sequence data types like list, tuple ,
sets,range,Strings.We also learned about the functions and basic conditional statements.
The day1 of week3 we learned about the list and tuple data types and how are they useful in
the python programming and what is the Syntax and how to add the values to it and how to
access the values from the
Syntax (List) :
Variable_name=[“ar”,”kv”,1,2,3]
Syntax(tuple) :
Variable_name=(1,2,3,2,5)
In the day2 we learned further datatypes like Sets , Strings and Range data types. We also
understand about how the syntax of this data types and how they are used in the python
programming this topics were learned.
Syntax(Sets) :
Variable_name={ }
Syntax(range) :
Variable_name=range(x,y,z(stepindex))
Day 3 : Functions
On day 3 the class was mainly focused on the functions and the syntax of the functions.the
function will be return starting by the keyword def .A function is consist of function
name,Function Body,Function calling.
Synatx :
Def function_name():
Function Body
Function Call ()
7
Intermediate Report
In the day 4 of week 3 we learned about the conditional statements like if , if else , if elif
else,nested ifelse.
WEEK 4(MAR7-MAR14):
From March 7 to March 14, we covered Python If-Else statements, loops (while loop), and
problem-solving along with MS Excel basics, data entry, extraction, and key functions. Learned
sorting, filtering, formulas like SUM, AVERAGE, IF, and text functions in Excel. Python
exercises focused on conditional statements and loops for automating repetitive tasks. Holidays
were observed on March 8-9 and March 13-14 (Holi).
num = 1
print(num)
num += 1
8
Intermediate Report
March 10: Data Entry in Excel and Data Extraction & Load
Entering different types of data: Text (Names, Addresses), Numbers (Sales Data,
Scores), Dates & Time (Timestamps)
To filter only Laptop sales, apply a Filter on the "Product" column and select "Laptop."
March 11: Python Loops (While Loop) & MS Excel App Structure and Basic Commands
Covered Python loops, focusing on the while loop and its applications.
9
Intermediate Report
Learned about MS Excel’s structure, including the ribbon, menu options, and essential
shortcuts.
Explored basic Excel commands like SUM, AVERAGE, and COUNT for data
manipulation.
Solved more while loop problems to strengthen the concept of loop execution and
breaking conditions.
sum = 0
num = 1
sum += num
num += 1
print("Sum:", sum)
Output:
Sum:55
10
Intermediate Report
o Learn how to create your own custom calculations using operators (+, -, *, /, ^, &)
o Lock cells with absolute references ($A$1) to prevent changes when copied
11
Intermediate Report
o Use Goal Seek to find the input needed for a specific result
12
Intermediate Report
13
Intermediate Report
o FILTER()
o SORT()
o UNIQUE()
o SEQUENCE()
o LET()
o LAMBDA()
Power Query (Get & Transform) for cleaning and shaping data
Dashboard Design
o Slicers
14
Intermediate Report
Dashboard Design
o Slicers
o Recording macros
o Worksheet/workbook protection
o Locking/unlocking cells
o Password encryption
o Hiding formulas
15
Intermediate Report
o Microsoft Power BI
16
Intermediate Report
17