Computer Course in Delhi

Section 1: Fundamentals of Hardware (Day 1)
⦿ Computer components such as CPUs, RAM, ROM, storage devices, etc.
⦿ Understanding Computer Architectures
⦿ Detailed understanding about Expansion cards, connectors, & ports

Section 2: PC Assembly (Day 2)
⦿ Step-by-step process of assembling a Personal Computer (PC)
⦿ Understanding the installation & configuration of peripheral devices
⦿ Basic Input Output System (BIOS) & Unified Extensible Firmware Interface (UEFI) settings & configuration

Section 3: Troubleshooting of Hardware Resources (Day- 3)
⦿ Understanding techniques used for Troubleshooting with good practices
⦿ Knowledge of general hardware problems & solutions
⦿ Diagnosing hardware issues using loopback plugs

Section 4: Networking concepts (Day- 4)
⦿ Understanding networking concepts like IP address, MAC address & protocols like SSH, DHCP, DNS, etc.
⦿ Understanding wired & wireless networks
⦿ Troubleshooting network related problems

Section 5: Mobile Devices like Phones & Laptops (Day- 5)
⦿ Understanding Laptop hardware components
⦿ Comparing Laptop with Computer
⦿ Common Laptop issues & repair techniques for troubleshooting
⦿ Phone's hardware & its troubleshooting

Section 6: Peripherals like Printers (Day- 6)
⦿ Printer, their types & components
⦿ Understanding process of Printer installation, configuration, & maintenance
⦿ Troubleshooting problems related to printers

Section 7: Security Best Practices (Day- 7)
⦿ Understanding concepts of cyber security
⦿ Importance of Computer security fundamentals
⦿ Implementing security measures for hardwares & softwares
⦿ Encryption for data protection

Section 8: Safety & Environmental problems (Day- 8)
⦿ Important precautions when working with computer hardware
⦿ Hardware disposal & recycling concepts for Environment
⦿ Electrostatic Discharge (ESD) prevention techniques

Section 9: Communication skills for Professionalism (Day- 9)
⦿ Good Communication with customers & colleagues for maintaining Professionalism
⦿ Best guidelines for IT support
⦿ Legal considerations in IT support

Section 1: Fundamentals of Networking (Day 1-2)
⦿ GUnderstanding networking concepts & communication models such as OSI & TCP/IP.
⦿ GTypes of Network
⦿ GIntroduction to Ethernet & wireless Networks
⦿ GUnderstanding networking devices like routers, switches, hubs, etc.
Labs
⦿ GLab 1.1: Installation process of Cisco Packet Tracer
⦿ GLab 1.2: Basic Network Topology

Section 2: Network Access (Day 3-4)
⦿ GConfiguration of Layer 2 Switches
⦿ GConcepts of VLAN & inter-VLAN routing
⦿ GWireless LAN configuration & security like Wi-Fi standards, SSIDs, Encryption, etc.
Labs
⦿ GLab 2.1: VLAN Configuration
⦿ GLab 2.2: Wireless LAN Setup

Section 3: IP Connectivity (Day 5-7)
⦿ GConcepts of IP Address & Subnet
⦿ GUnderstanding the types of IP Address- IPv4 & IPv6
⦿ GConcepts of Routing Protocols- RIP, OSPF & EIGRP
⦿ GConfiguration of Static & Dynamic routing
Labs
⦿ GLab 3.1: Subnetting & IP Addressing
⦿ GLab 3.2: Routing Configuration

Section 4: IP Services (Day 8-10)
⦿ GDHCP (Dynamic Host Configuration Protocol)
⦿ GNAT (Network Address Translation)
⦿ GVarious types of NAT
⦿ GConcepts of Access Control Lists (ACLs) for filtering traffic
⦿ GCategories of ACL
Labs
⦿ GLab 4.1: DHCP Configuration
⦿ GLab 4.2: Network Address Translation (NAT)

Section 5: Network Security Fundamentals (Day 11-13)
⦿ GIntroduction to network security principles
⦿ GSecuring network devices (routers, switches)
⦿ GAuthentication, authorization, & accounting (AAA) concepts
Labs
⦿ GLab 5.1: Access Control Lists (ACLs)
⦿ GLab 5.2: Device Security & AAA

Section 6: Automation & Programmability (Day 14-16)
⦿ GBasics of network programmability & automation
⦿ GIntroduction to Python scripting for network tasks
⦿ GConfiguration management tools (Ansible, Puppet)
Labs
⦿ GLab 6.1: Introduction to Python Scripting
⦿ GLab 6.2: Configuration Management with Ansible

Section 7: Wide Area Networks (WANs) (Day 17-18)
⦿ GWAN technologies & protocols (PPP, HDLC, Frame Relay)
⦿ GVirtual Private Networks (VPNs) & tunneling protocols (GRE, IPsec) Labs
⦿ GLab 7.1: Configuring Point-to-Point Protocol (PPP)
⦿ GLab 7.2: VPN Configuration

Section 8: Network Management (Day 19-20)
⦿ GSNMP (Simple Network Management Protocol) for monitoring
⦿ GNetwork troubleshooting methodologies & tools
⦿ GNetwork performance optimization techniques
Labs
⦿ GLab 8.1: SNMP Monitoring
⦿ GLab 8.2: Network Troubleshooting

Section 1: Overview of Linux Fundamentals (Days 1-2)
⦿ Understanding Linux concepts & Command-line Interface (CLI)
⦿ Linux File system hierarchy & file/directory permissions
⦿ Managing Users & Groups on Linux
⦿ Process management
Labs:
⦿ Lab 1.1: Installation of Linux
⦿ Lab 1.2: Introduction to Linux Environment
⦿ Lab 1.3: File System Management

Section 2: System Administration (Days 3-4)
⦿ Managing software packages with RPM & YUM
⦿ Disk management & partitioning
⦿ Configuring IP addressing & network services like DNS, DHCP, etc.
⦿ System boot process & GRUB configuration
Labs:
⦿ Lab 2.1: Package Management with YUM & others
⦿ Lab 2.2: Disk Management & File-system
⦿ Lab 2.3: Networking Configuration

Section 3: User Administration (Days 5-6)
⦿ User & group management with useradd, usermod, userdel, groupmod, etc. commands
⦿ Linux Password policies & authentication mechanisms
⦿ Managing privileges using sudo
⦿ Implementing security measures such as SELinux, firewall, access control etc.
Labs:
⦿ Lab 3.1: User & Group Management
⦿ Lab 3.2: Configuring Security Measures

Section 4: Managing Services & performing Bash Scripting (Days 7-8)
⦿ Managing system services using systemd
⦿ Basic Bash scripting for task scheduling & automation
⦿ Monitoring system performance & troubleshooting
Labs:
⦿ Lab 4.1: Managing Linux System Services
⦿ Lab 4.2: Writing script using Bash Scripting

Section 5: Networking & Remote Access (Days 9-10)
⦿ Network configuration using nmcli & nmtui commands
⦿ Configuring SSH for remote access & scp for secure file transfer
⦿ Troubleshooting networking issues
Labs:
⦿ Lab 5.1: Network Configuration with nmcli
⦿ Lab 5.2: Configuring SSH & scp for Remote Access & file transfer

Section 6: System Backup & Restore (Days 11-12)
⦿ Understanding backup strategies & tools such as tar, rsync, etc.
⦿ Implementing scheduled backups using cronjobs
⦿ Concepts of disaster recovery
Labs:
⦿ Lab 6.1: Backup Configuration with rsync
⦿ Lab 6.2: System Restore Practice

Section 7: System Performance Optimization (Days 13-14)
⦿ Monitoring system resources such as CPU, memory, disk I/O, etc.
⦿ Optimizing system performance by tuning kernel parameters
⦿ Identifying & resolving system performance bottlenecks
Labs:
⦿ Lab 7.1: Monitoring System Performance
⦿ Lab 7.2: Kernel Tuning & Optimization

Section 8: Virtualization & Containers (Days 15-16)
⦿ Introduction to virtualization with Kernel-based Virtual Machine (KVM)
⦿ Understanding Docker for managing containers & containerized applications
⦿ Understanding the Deploying & management of virtual machines & containers
Labs:
⦿ Lab 8.1: Setting up Virtual Machines with KVM
⦿ Lab 8.2: Containerization with Docker

Section 1: Intro to Microsoft Word (Day 1-2)
⦿ Microsoft Word interface & its features
⦿ Overview of Ribbon, Quick Access Toolbar, & Backstage view
⦿ Understanding how to Create, open, & save documents
⦿ Basic text formatting such as font styles, sizes, colors
Labs:
⦿ Lab 1.1: Navigating Microsoft Word
⦿ Lab 1.2: Text Formatting

Section 2: Editing & Formatting Word Documents (Day 3-4)
⦿ Working with paragraphs & bullets
⦿ Applying themes & styles to documents
⦿ Concept of headers, footers, & page numbers
⦿ Utilizing Find & Replace feature
Labs:
⦿ Lab 2.1: Paragraph Formatting
⦿ Lab 2.2: Styles & Themes

Section 3: Working with Tables & Graphics (Day 5-6)
⦿ Creating & formatting tables
⦿ Inserting images, shapes, etc.
⦿ Adding captions & creating basic diagrams
Labs:
⦿ Lab 3.1: Table Creation & Formatting
⦿ Lab 3.2: Inserting & Editing Graphics

Section 4: Advanced Document Features (Day 7-8)
⦿ Document automation using templates & mail merge feature
⦿ Using comments & track changes for Collaborating on documents
⦿ Applying advanced formatting techniques such as sections, columns, drop caps, etc.
Labs:
⦿ Lab 4.1: Exploring various methods for Document Automation
⦿ Lab 4.2: Practical on Collaboration & Review Tools

Section 5: Document Efficiency & Customization (Day 9-10)
⦿ Utilizing shortcuts & productivity tools such as Quick Parts & AutoText
⦿ Customizing Word settings & options for personal preferences
⦿ Enhancing document accessibility & security
Labs:
⦿ Lab 5.1: Using Productivity Tools
⦿ Lab 5.2: Customizing Word Settings

Section 1: Introduction to Microsoft PowerPoint (Day 1-2)
⦿ Understanding PowerPoint interface & its features
⦿ Overview of slide layouts, placeholders, & slide master
⦿ Creating & saving presentations
⦿ Adding, rearranging, & deleting slides
Labs:
⦿ Lab 1.1: Navigating PowerPoint
⦿ Lab 1.2: Working with Slides

Section 2: Slide Design & Formatting (Day 3-4)
⦿ Applying themes, colors, & fonts to presentations
⦿ Formatting text & paragraphs
⦿ Using shapes, SmartArt, & images effectively
⦿ Applying transitions & animations to slides
Labs:
⦿ Lab 2.1: Applying Themes & Styles
⦿ Lab 2.2: Using Graphics & Multimedia

Section 3: Enhancing Presentation Content (Day 5-6)
⦿ Adding charts, tables, & diagrams to slides
⦿ Incorporating multimedia elements (audio, video) into presentations
⦿ Creating interactive & dynamic presentations
Labs:
⦿ Lab 3.1: Working with Charts & Tables
⦿ Lab 3.2: Multimedia Integration

Section 4: Slide Show Delivery & Interaction (Day 7-8)
⦿ Setting up slide show settings (timings, narrations)
⦿ Using presenter view & slide show controls
⦿ Adding navigation controls (hyperlinks, action buttons)
⦿ Incorporating interactive elements (forms, quizzes)
Labs:
⦿ Lab 4.1: Slide Show Customization
⦿ Lab 4.2: Interactive Presentation Features

Section 5: Collaboration & Sharing (Day 9-10)
⦿ Collaborating on presentations using comments & annotations
⦿ Using OneDrive & SharePoint for cloud-based sharing & collaboration
⦿ Exporting presentations to different formats like PDF, video, etc.
Labs:
⦿ Lab 5.1: Collaboration Tools
⦿ Lab 5.2: Exporting & Sharing Presentations

Section 1: Introduction to Microsoft Excel (Day 1-2)
⦿ Overview of Excel interface & features
⦿ Understanding workbooks, worksheets, & cells
⦿ Entering & formatting data
⦿ Basic formulas & functions such as SUM, AVERAGE, COUNT
Labs:
⦿ Lab 1.1: Navigating Excel
⦿ Lab 1.2: Data Entry & Formatting

Section 2: Formulas & Functions (Day 3-4)
⦿ Working with basic & arithmetic formulas
⦿ Understanding cell references such as relative, absolute
⦿ Using common functions for calculations such as SUM, AVERAGE, MAX, MIN
Labs:
⦿ Lab 2.1: Basic Formula Writing
⦿ Lab 2.2: Working with Functions

Section 3: Data Analysis & Visualization (Day 5-6)
⦿ Sorting & filtering data
⦿ Creating & formatting tables
⦿ Using conditional formatting for data visualization
⦿ Inserting & customizing charts & graphs
Labs:
⦿ Lab 3.1: Data Analysis Techniques
⦿ Lab 3.2: Chart Creation & Customization

Section 4: Advanced Excel Functions (Day 7-8)
⦿ Using logical & lookup functions such as IF, VLOOKUP, INDEX-MATCH
⦿ Working with date & time functions
⦿ Understanding text functions such as CONCATENATE, LEFT, RIGHT
Labs:
⦿ Lab 4.1: Using Logical Functions
⦿ Lab 4.2: Date, Time, & Text Functions

Section 5: Data Management & Analysis (Day 9-10)
⦿ PivotTables & PivotCharts for data summarization
⦿ Data validation & error checking
⦿ Advanced data analysis techniques such as What-If analysis, Goal Seek
Labs:
⦿ Lab 5.1: PivotTable Creation & Analysis
⦿ Lab 5.2: What-If Analysis & Goal Seek

Section 1: Advanced Data Analysis Techniques (Day 1-2)
⦿ Using array formulas for advanced calculations
⦿ Applying advanced lookup functions like INDEX-MATCH, HLOOKUP, VLOOKUP with multiple criteria
⦿ Performing statistical analysis like SUMIF, COUNTIF, AVERAGEIF
⦿ Utilizing data validation & error handling techniques
Labs:
⦿ Lab 1.1: Array Formulas & Functions
⦿ Lab 1.2: Statistical Analysis & Data Validation

Section 2: Mastering PivotTables & PivotCharts (Day 3-4)
⦿ Creating dynamic & interactive PivotTables
⦿ Using advanced PivotTable features like slicers, timelines, calculated fields/items, etc.
⦿ Designing PivotCharts for insightful data visualization
⦿ Linking multiple data sources to PivotTables
Labs:
⦿ Lab 2.1: Advanced PivotTable Techniques
⦿ Lab 2.2: PivotChart Design & Customization

Section 3: Automating Tasks with Macros (Day 5-6)
⦿ Recording & editing macros for repetitive tasks
⦿ Understanding Visual Basic for Applications (VBA) basics
⦿ Creating user-defined functions (UDFs) for custom calculations
⦿ Implementing event-driven programming in Excel
Labs:
⦿ Lab 3.1: Recording & Editing Macros
⦿ Lab 3.2: Introduction to VBA & User-Defined Functions

Section 4: Advanced Charting & Graphical Representations (Day 7-8)
⦿ Creating dynamic dashboards with interactive charts
⦿ Using advanced chart types such as scatter plots, bubble charts, waterfall charts, etc.
⦿ Customizing chart elements using VBA macros
⦿ Incorporating Sparklines & data bars for quick visual analysis
Labs:
⦿ Lab 4.1: Dashboard Creation
⦿ Lab 4.2: Advanced Chart Customization

Section 5: Data Analysis Tools & Add-Ins (Day 9-10)
⦿ Using Excel's built-in data analysis tools such as Solver, Data Tables
⦿ Using scenario analysis & goal seeking techniques
⦿ Exploring Excel add-ins for specialized data analysis such as (Power Query, Power Pivot, etc.
⦿ Applying advanced filtering & sorting techniques
Labs:
⦿ Lab 5.1: Scenario Analysis with Goal Seek
⦿ Lab 5.2: Excel Add-Ins for Advanced Analysis