What you'll learn
1. MS Office
Course Description:
MS Office is a computer application course designed to develop practical skills in office productivity software. Students learn to create professional documents, prepare spreadsheets, analyze data, create presentations, and manage day-to-day office work using MS Word, MS Excel, and MS PowerPoint.
Subjects Covered:
- MS Word: Document creation, formatting, tables, images, page setup, mail merge, CV/resume preparation and printing.
- MS Excel: Data entry, formatting, formulas, functions, sorting, filtering, charts, conditional formatting and basic data analysis.
- MS PowerPoint: Slide creation, themes, layouts, images, SmartArt, charts, animations, transitions and professional presentations.
- Basic computer and file management
- Internet and email fundamentals
- Practical office projects
Job Roles:
- Office Assistant
- Computer Operator
- Data Entry Operator
- Office Executive
- Administrative Assistant
- Documentation Executive
2. Python Programming
Course Description:
Python is a beginner-friendly, high-level programming language widely used for software development, automation, data analysis, web development and artificial intelligence. This course provides students with fundamental programming knowledge and practical coding experience.
Subjects Covered:
- Introduction to Python
- Python installation and development environment
- Variables and data types
- Operators and expressions
- Input and output
- Conditional statements
if, elif and elsefor and while loops- Lists, tuples, sets and dictionaries
- Strings and string operations
- Functions and parameters
- Modules and packages
- Exception handling
- File handling
- Object-Oriented Programming basics
- Introduction to libraries
- Basic database connectivity
- Practical Python programs
- Mini project
Practical Projects:
- Calculator application
- Student marks management
- Employee salary calculator
- Simple billing system
- Contact management system
- Number guessing game
- Basic inventory management system
Job Roles:
- Junior Python Developer
- Python Programmer
- Software Developer Trainee
- Automation Testing Trainee
- Junior Web Developer
- Data Analyst Trainee
Show More
Course Syllabus
Module 1: MS Office Fundamentals
- Introduction to Computer and Office Applications
- MS Office interface and common features
- File and folder management
- Creating, saving and printing documents
- Keyboard shortcuts and productivity tools
Module 2: MS Word
- Creating and editing documents
- Text and paragraph formatting
- Page setup and document layout
- Tables and tabulation
- Images, shapes and SmartArt
- Headers, footers and page numbering
- Styles and templates
- Mail Merge
- Find and Replace
- Printing and PDF conversion
- Practical: Resume, official letter and business document
Module 3: MS Excel
- Workbook and worksheet management
- Data entry and formatting
- Rows, columns and cells
- Basic formulas and functions
- SUM, AVERAGE, COUNT, MAX and MIN
- IF and other logical functions
- Sorting and filtering
- Conditional formatting
- Charts and graphs
- Data validation
- Pivot Tables
- Basic data analysis
- Practical: Marksheet, salary sheet and monthly expense report
Module 4: MS PowerPoint
- Creating presentations
- Slide layouts and themes
- Text and image formatting
- Tables, charts and SmartArt
- Audio and video insertion
- Transitions and animations
- Slide Master
- Presentation and slideshow settings
- Professional presentation design
- Practical: Business/educational PowerPoint presentation
Python Programming
Module 5: Introduction to Python
- Introduction to programming
- Features and applications of Python
- Python installation and setup
- Python IDLE and VS Code
- Writing and executing Python programs
- Python syntax and indentation
- Comments and documentation
- Practical: Basic Python programs
Module 6: Variables & Data Types
- Variables and constants
- Numbers
- Strings
- Boolean data type
- Lists
- Tuples
- Sets
- Dictionaries
- Type conversion
- Input and output
- Operators
Module 7: Conditional Statements & Loops
- if statement
- if-else statement
- elif statement
- Nested conditions
- for loop
- while loop
- break and continue
- range() function
- Practical: Number checking, calculator and pattern programs
Module 8: Functions & Modules
- Introduction to functions
- Defining and calling functions
- Parameters and arguments
- Return values
- Default arguments
- Lambda functions
- Scope of variables
- Importing modules
- Creating user-defined modules
Module 9: Strings, Lists & Dictionaries
- String operations
- String methods
- List creation and manipulation
- List methods
- Tuples and sets
- Dictionary operations
- Iterating through collections
- List comprehension
- Practical: Student data and contact management programs
Module 10: File Handling, Errors & Project
- Reading and writing text files
- Working with CSV files
- Exception handling
- try, except, else and finally
- Debugging basic Python programs
- Introduction to object-oriented programming
- Classes and objects
- Basic Python libraries
- Final Project: Student Management / Billing / Simple Data Management Application
Course Outcome
After completing the course, learners will be able to create professional documents, spreadsheets and presentations using MS Office and develop basic Python programs using variables, conditions, loops, functions, data structures and file handling.
Bestseller
