PYTHON

TOPIC SUBTOPIC
Single-line/multi-line comments
Variable declaration, variable initialization, variable type-casting, global variables
Basics
Built-in datatypes, type() function to get the data types, setting the datatype,
constructor functions to set the datatypes
Arithmetic operators
Assignment operators
Comparison operators
Logical operators
Operators
Identity operators
Membership operators
Bitwise operators
Operator precedence
Boolean values and their signifcance in Python
Boolean
Evaluation of variables and values
if-else conditions
Nested if-else conditions
if-elif-else conditions
Conditional Shorthand if and if-else evaluation
Statements Use of comparison operators in if-else conditions for evaluation of expressions
Python match statements (alternative to switch in C/C++)
Combination of pipe operator in case evaluation in match
Using if conditions as guard in case evaluation in match
For loops
Looping through Python iterator objects using for loop
Use of pass, break and continue statements in for loops
Use of range() function in for loops
Iterative Use of else condition in for loops
Statements
Nested for loops
While loops
Use of pass, break and continue statements in while loops
Use of else condition in while loops
String declaration using single and double quotes
String quotations inside quotes
Loopting through strings as arrays using for loop
Check substring in a string using Python membership operators
Slicing of strings
Strings
Negative indexing in strings
Modification of strings by converting to uppercase, lowercase, replacing whitespace,
concatenation and splitting strings
String formatting using F-strings
Different string methods in Python
Accessing and changing list items
Adding and removing list items
 Sorting, joining or copying lists
Lists Looping through items in a list
List comprehension
Different list methods in Python
Nested lists
Accessing set items
Adding and removing set items
Looping through sets
Sets
Joining sets
Different sets methods in Python
Nested sets
Accessing and unpacking tuples
Joining tuples
Looping through tuples
Tuples
Updating or changing tuple items by converting them to lists
Different tuples methods in Python
Nested tuples
Accessing and changing dictionary items
Adding and removing items in a dictionary
Dictionary Looping through dictionary items (keys, values and key-value pairs)
Different dictionary methods in Python
Nested dictionaries
Function definitions and function calls
Function positional and keyword arguments
Arbitrary (*args) and arbitrary keyword (**kwargs) arguments in Python
Functions
Position-only, keyword-only, combination of position-only and keyword-only
arguments
Returning values from functions
File operations in text and binary files
File Handling Use of struct and pickle library methods for file operations
File end-of-file (EOF) check, seek(), tell() methods
Implicit vs. Explicit techniques of plotting using matplotlib pyplot methods
Setting figures, subfigures, subplots, mosaic subplots
Setting Artists such as colorbar, legends, axis labels, figure titles, super titles, sharing
x or y axis, adding text or annotations in plots

Matplotlib Definition and arrangement of mupltiple axes in a figure

Autoscaling axes, setting manual axes scales (log, linear, combination of the two) for
x and y axis
Axis major and minor ticks and formatter properties
Different types of color specifications in matplotlib
Text annotations, different types of box style annotations in matplotlib
 EXCEL
TOPIC SUBTOPIC
Introduction to ribbons, sheets and workbooks
Text formatting in Excel (font style, font size, font color, underline, italics, bold)
Text alignments
Cell type, cell styles, insertion and deletion of cells
Insertion and deletion of rows and columns in the sheet
Basics Sorting and filtering without using functions in the sheet
Find, select and replace of cell content in the sheet
Page layout settings of the sheets
Printing and exporting sheets in other formats
Sharing sheets via link or email with other collaborators
Commenting, spell checking in the sheet
Trigonometric functions, degrees to radians and radians to degrees conversion functions
RANDARRAY, RANDBETWEEN fuunctions,
GCD, LCM, FACT functions
ROUND, ROUNDDOWN, ROUNDUP, EVEN and ODD functions to round the digits of expression
SUMX2MY2, SUMX2PY2, SUMXMY2 functions to perform arithmetic operations in corresponding
ranges of arrays
SUM, SUMIF and SUMIFS functions to perform conditional summation of cell ranges
SEQUENCE, SERIESSUM functions to perform arithmetic operations in a series
BASE function to convert the text representation of a decimal number into a number with given radix or
base
AVERAGE, AVERAGEA, AVERAGEIF, AVERAGEIFS functions to compute the average (arithmetic
Functions related to mean) of the argument values
mathematics COUNT, COUNTIF, COUNTIFS, COUNTBLANK functions to count the occurrence of specific cells
MAX, MAXA, MAXIF, MAXIFS functions to find the maximum value within a range which satisfies a
condition
MIN, MINA, MINIF, MINIFS functions to find the minimum value within a range which satisfies a
condition
DEC2BIN, DEC2HEX, DEC2OCT to convert decimal values into corresponding binary or hexadecimal
or octal values
BIN2DEC, BIN2HEX, BIN2OCT to convert binary values into corresponding decimal or hexadecimal or
octal values
OCT2DEC, OCT2BIN, OCT2HEX to convert octal values into corresponding decimal or binary or
hexadecimal values
CONVERT function to convert a value from one number system into another
IF, IFS, IFNA, SWITCH functions for conditional expression evaluation
AND, OR, NOT and XOR functions
BYROW and BYCOL functions for corresponding row-wise or corresponding column-wise operations
Functions related to
logical operations
LAMBDA for defining custom lambda functions to be used as arguments in other functions
MAKEARRAY function to construct an array of ranges by performing arithmetic operations
REDUCE function to reduce an array of ranges by aggregating the values of the range
LOOKUP, VLOOKUP, HLOOKUP and XLOOKUP functions to search for an item in a given range of
cells and return the corresponding item from another range of cells
FILTER function to filter the array of ranges based on a given condition
GROUPBY function to group the range of cells by a column or row and aggregate the values of any
Lookup and
corresponding cells by performing the operation defined as built-in function
reference functions
TOROW, TOCOL and TRANSPOSE for the transformation of array of ranges.
SORT, SORTBY functions to sort an array of ranges
INDEX and MATCH functions to return the relative value and reference/position of a matching cell from
an array of ranges
DATE function to set the date
Date and Time DAYS function to return the number of days between two dates
functions YEAR function to return the year of a specified date
TODAY function to return the current date