DAY WISE SYLLABUS
18 JUNE 2020
Year 1:
Name of the Topic: sorting, filtering and validating data in Excel
Link to the video: https://bit.ly/37O4i60
17 JUNE 2020
Year 1:
Name of the Topic: Introduction to various functions in all categories of Excel
Link to the video: https://bit.ly/3fP0Fjh
16 JUNE 2020
Year 1:
Name of the Topic: Cell Referencing in Excel, How to link sheets in MS Excel
Link to the video: https://bit.ly/37MEs2u
15 JUNE 2020
Year 1:
Name of the Topic: Introduction to MS Excel and its features, How to work in MS Excel
Link to the video: https://bit.ly/2CmqGb0
11 JUNE 2020
Year 1:
Name of the Topic: MS Word Shortcut Keys, MS Word complete summary
Link to the video: https://bit.ly/311IMti
10 JUNE 2020
Year 1:
Name of the Topic: mail merge in ms word, Page Layout in Word and how to write in hindi in word
Link to the video: https://bit.ly/2V5XFHn
09 JUNE 2020
Year 1:
Name of the Topic: Inserting Objects like shapes, pictures, table etc in MS Word, What is Macro in word-Record and run Macro
Link to the video: https://bit.ly/3hS8beK
08 JUNE 2020
Year 1:
Name of the Topic: Introduction to the various applications in MS office, Introduction to Word features, Office button, toolbars
Link to the video: https://bit.ly/2V8hAFk
04 JUNE 2020
Year 1:
Name of the Topic: Install Linux operating system, Use the Linux graphical user interface for file and folder management, exploring the system
Link to the video: https://bit.ly/2Brln9R
03 JUNE 2020
Year 1:
Name of the Topic: Introduction to Linux Operating System features, structure, files and processes
Basic Linux commands
Link to the video: https://bit.ly/2V80ojl
02 JUNE 2020
Year 1:
Name of the Topic: Introduction to basic DOS Internal and External Commands, Introduction to Open Source Software
Link to the video: https://bit.ly/2Cuyojz
01 JUNE 2020
Year 1:
Name of the Topic: Basic Hardware and software issues and their solutions, Usage of Application software and Antivirus
Link to the video: https://bit.ly/3dnN4hh
28 May 2020
Year 1:
Name of the Topic: Introduction to the booting, Introduction to various types of memories and their features
Link to the video: https://bit.ly/2CoRbMZ
27 May 2020
Year 1:
Name of the Topic: Install and setup operating system and related software in a computer.
various shortcut commands in windows
Practice on Windows interface and navigating windows
Link to the video: https://bit.ly/3caXjF6
26 May 2020
Year 1:
Name of the Topic: Install and setup operating system and related software in a computer.
Introduction to operating System
Main features of Windows OS
Link to the video: https://bit.ly/3gmuadm
21 May 2020
Year 1:
Name of the Topic: Introduction to Computer components.
Various Input/ Output devices in use and their features
Assemble components of desktop computer
Link to the video: https://bit.ly/2TDqD0z
20 May 2020
Year 1:
Name of the Topic: Apply safe working practices,
Practice safe methods of fire fighting in case of electrical fire.
Concepts of Hardware and Software Function of motherboard components and various processors
Link to the video: https://bit.ly/3g3xlGB
19 May 2020
Year 1:
Name of the Topic: Create individual user accounts for each member in windows 7, Allow/Block User to Run Applications Software in Windows 7
Link to the video: https://bit.ly/2LGybLv
18 May 2020
Year 1:
Name of the Topic: Data backup, How to Enable WPA/WPA2/WPA2(MIX) Encryption on WiFi Router
Link to the video: https://bit.ly/3655O2M
14 May 2020
Year 1:
Name of the Topic: Provide firewall security for Internet connection and Network System, viruses, spyware and other malicious code, Introduction to IT Act and penalties for cyber crimes
Link to the video: https://bit.ly/2AX3C2k
13 May 2020
Year 1:
Name of the Topic: Overview of Information Security, SSL, HTTPS, Security threats, Introduction to Directory Services
Link to the video: https://bit.ly/3eqZmXw
12 May 2020
Year 1:
Name of the Topic: E-commerce websites viz Amazon and OLX, Payment and Order Processing, Authorization on E-Commerce website
Link to the video: https://bit.ly/315ubNC
11 May 2020
Year 1:
Name of the Topic: Introduction to E-Commerce and advantages, E-Commerce and building business on the net
Link to the video: https://bit.ly/2AWOdix
07 May 2020
Year 1:
Name of the Topic: Tax processing in tally, Tax processing in tally
Link to the video: https://bit.ly/2Nlmpa1
06 May 2020
Year 1:
Name of the Topic: Costing, cost elements, classification of cost in tally, Analysis and managing inventory in tally
Link to the video: https://bit.ly/2NlnvCG
05 May 2020
Year 1:
Name of the Topic: creating reversing, memorandum and optional vouchers, invoice in tally, scenario management and ratio analysis in tally
Link to the video: https://bit.ly/3dkKKaM
04 May 2020
Year 1:
Name of the Topic: Create and Managing Budget in tally.
Cash Flow and Fund flow in Tally.
Link to the video: https://bit.ly/2YVwAHP
30 APRIL 2020
Year 1:
Name of the Topic: How to create stock group in tally.
Chart of Accounts and PAYMENT ,RECEIPT JOURNAL.
Link to the video: https://bit.ly/314VLKA
29 APRIL 2020
Year 1:
Name of the Topic: Voucher Entry and Ledger Posting in tally.
Voucher entry in Tally.
Link to the video: https://bit.ly/3dnxiTl
28 APRIL 2020
Year 1:
Name of the Topic: Generate reports for Invoice, Bill, Profit & Loss account.
Perform Cost Center & Cost Category management.
Link to the video: https://bit.ly/3hMEkV7
27 APRIL 2020
Year 1:
Name of the Topic: Tally introduction and Terminology Of Accounting in Tally.
Create Company, Account and Voucher entry in Tally.
Link to the video: https://bit.ly/315thAI
23 APRIL 2020
Year 1:
Name of the Topic: Create and edit macros.
Methods and events in VBA Programming.
Link to the video: https://bit.ly/3hOHoA2
22 APRIL 2020
Year 1:
Name of the Topic: Write code to work with Excel in VBA forms
make a simple user form in VBA
Link to the video: https://bit.ly/3en2yU3
21 APRIL 2020
Year 1:
Name of the Topic: Functions and built in functions in VBA
Procedures in VBA
Link to the video: https://bit.ly/37ROO0N
20 APRIL 2020
Year 1:
Name of the Topic: string variables in VBA.
Mathematical, Conversion, Date and String Functions in VBA
Link to the video: https://bit.ly/2YWdd1l
16 APRIL 2020
Year 1:
Name of the Topic: Loop, Loop Control and Case statements in VBA
Create and Manipulate Arrays in VBA
Link to the video: https://bit.ly/2AP2Wfz
15 APRIL 2020
Year 1:
Name of the Topic: Create Message boxes and Input boxes in VBA.
Conditional statements like if, Else- if, and Select in VBA.
Link to the video: https://bit.ly/3fKqX63
14 APRIL 2020
Year 1:
Name of the Topic: Modify object properties in VBA program.
Write simple programs Involving VBA Data types, Variables, Operators and Constants.
Link to the video: https://bit.ly/3fMshW5
13 APRIL 2020
Year 1:
Name of the Topic: form controls like buttons, Check boxes, Labels, Combo Box, Group Box, List Box, Option Button, Scroll Bar and Spin button in VBA.
Link to the video: https://bit.ly/2YWcOfl