| Section 1: Basics
(Computer is one of the main subjects of Bank PO. It counts for a very small section but values a lot by providing you an opportunity to score full. The question asked in the exam can be from the depth of the topic. SP Sharma Sir who has sound knowledge of the subject helps you by discussing the topics in a very innovative way.The question discussed by him appears 90% in the exams.)
|
|
|
Lecture 1
|
Introduction
(This is an introductory video of SP Sharma in which he has discussed the syllabus of the computer and the topics that are really important. You will discussion on the definition of computer, difference in computer and other electronic devices, Its functions, Its features, Computer system with examples, Computer language and scripting that includes the definition of both hardware and software, types of software, Different terms of computer languages and Steps to learn any language. This video gives you clear idea on what computer is and the types of question asked in the exam, the topic from which most of the questions are covered and the beginning of Computers.)
|
|
|
|
Lecture 2
|
Parts of Computer
(Here in this video you will continue with software mainly Application software , different types of application software then you will learn its uses. You will also discuss few things on MS Office, its components and the uses of many other Application software like MS Excel, Power point, etc. Similarly you will learn about the parts of the computer i.e, Hardware and Software. You will learn their definitions and types. Each term is very well explained and tried to make you learn just watching the video. At the end of the lecture you will have a complete grasp of the things taught to you. SP Sharma Sir has very well explained all the topics and has even discussed the types of questions asked in the exams. He has tried to relate the topics with your daily life. To make the class interesting you will be answering some MCQs. Different images has been shown to you to make it further easier for you. Besides you will learn practically to find the speed of the processor, Ram and the type operating system used by you. As you move towards the end you will learn some full forms as well.)
|
|
|
|
Lecture 3
|
Input, Output & Storage Devices
(You will begin with a small test in which you have to write the full form of some terms discussed in the last class and a quick revision of the topic discussed earlier and Then in this lecture you will continue with the remaining of parts of the computer i.e.,peripheral devices, optical devices and other output devices. You will find different types of output devices, soft copy/hard copy and so on. You will also discuss here different types of monitor and then you will also learn about various Printers and Plotter. You will get full explanation of everything.)
|
|
|
|
Lecture 4
|
History of Computers
(Now you will learn a bit about the history of computer. This lecture actually provides you details of the beginning of the computer. Purpose of designing computer. Who started logarithm and algorithm. Such questions are actually asked in the exam. So everything provided to you is meaningful and is provided to you in the form of notes as well. Moreover you will some images which will add up to your learning. Its five generation has been discussed here which is very very important topics. It contains many small points which we usually ignore and got muddled when asked in the exam. You will get revision classes, Short test series and more. You can ask your doubts on mail@studykhazana.com. Do not hesitate to ask any doubt, Sir is always there to help you.)
|
|
|
|
Lecture 5
|
Microsoft Excel
(You will begin with the definition of the MS.Excel. Basically MS. Excel is an application software and is a component of MS Office package. It is not only useful for banking but also for professional career. MS Excel has a huge demand in the market. It is now the requirement for many vacancies. So this topic need your utter attention. Further you will learn it practically. You will begin with instructions on how to open it and then move to different bars or buttons of Excel and their uses. You will further learn it Application name, default file name, Default number of menu and their respective names ans many more thimgs. You will learn the complete basics of Excel which is very helpful for a good career growth.)
|
|
|
|
Lecture 6
|
Microsoft Excel: Random Functions
(In this video Sir has discussed the Practical of Excel wherein you will learn functions and formulas. Here in this video you will learn how OTP are basically generated, difference between Rand() and Rand between(), their syntax , generating random character and more. This is going to be a practical experience for you. You will learn much faster when actually try these functions practically. SP Sharma Sir has very well explained everything and has even discussed the types of questions asked in the exams. He has made the class very interactive .His friendly way of teaching will help you the most.He is also giving you practice questions and has even shared his email-id for your doubts.)
|
|
|
|
Lecture 7
|
Microsoft Excel: Random Dates
(It is not just a lecture but a complete guidance. With this lecture you will master Excel. You need practice a lot and for your practice we will provide you practice sheets, Quiz with all the important questions and doubt sessions. You can ask your queries and you will 100% get your answer within 36 hours of your queries. Do not ever hesitate to raise any doubt. Particularly in this lecture you will learn about random date. You will learn to calculate days between two given dates. You learn how to work on dates. This is a step by step learning session. You're requested to watch the videos in the given sequence only to have a proper grasp of everything. This lecture will let you learn the different format of writing date, date value, commands to find the date value and age of a person if DOB is given with some funny tips to learn. As you finish dates you will different shortcut keys ans how to add text in cells and how to change the format and everything will be taught to you practically. You will get familiar with the techniques and important formulas of Excel like conditional formatting which includes sorting, filter, Pivot table, Vlookup, countif, count, sum, sumif and Address as per the requirement of syllabus.)
|
|
|
|
Lecture 8
|
Microsoft Excel: Text
(This lecture is all about the text in MS.Excel. You will again learn some new formulas and these formulas are more than enough to finish the entire topic. MS. Excel is a very interesting topic with many formulas. Mugging up formulas is just a wastage of time as at the end you will forget and it becomes trash. The best way to learn these formulas is by making use of them as much as you can. Make a list of everything you do in your daily life, calculate your daily expense and there are lot many ways to utilize it. This lecture is the last topic of Excel but not the least to learn.)
|
|
|
|
Lecture 9
|
Microsoft Word
(MS Word is an application in which you will create different documents in different formats for different purposes. It is a versatile application with bulk of features in it. It is extremely easy to use application and can be used by any one. You will really get amused once you start using it.
As you have finished MS Excel with practice sheets, Now we will begin with a new topic MS Word whereupon you learn the name of the application name, its default name, its extension and about all its buttons, their functions and more. You will learn formatting of the text and different terms and many more things.
MS Word is used professionally for Collaboration, For office documents, marketing material, Professional Presentations and to integrate with other Microsoft office products.)
|
|
|
|
Lecture 10
|
Microsoft Word and Power Point
()
|
|
|
|
Lecture 11
|
Microsoft Power Point
()
|
|
|
|
Lecture 12
|
MS. Access Part-1
(Microsoft Access is a Relational Database Management System (RDBMS), designed primarily for home or small business use. In this video you will be learning about Data, Database, DBMS or Data Base Management System, Types of DBMS, Hierarchical, Network Database, Relational Database, Object oriented database, Relational Database Management System, NoSQL, Access file extension, access file objects, Data types in MS. Access, DBMS Languages, Data Manipulation Language and Data Control Language,)
|
|
|
|
Lecture 13
|
MS. Access Part-2
(Microsoft Access is a Relational Database Management System (RDBMS), designed primarily for home or small business use. In this video you will be learning about Data, Database, DBMS or Data Base Management System, Types of DBMS, Hierarchical, Network Database, Relational Database, Object oriented database, Relational Database Management System, NoSQL, Access file extension, access file objects, Data types in MS. Access, DBMS Languages, Data Manipulation Language and Data Control Language,)
|
|
|
|
Lecture 14
|
M.S DOS
(This is the main operating system in the syllabus. You will begin with the full form of M.S DOS i.e., Microsoft Disk Operating System and a brief history of operating system wherein you will learn about different generations of DOS. Then you will work practically. You will learn to run M.S DOS as it is a command based system so you can command it in terms if text only. Then you will learn about Internal Command and External Command, different between them, main extensions, terms like prompt and some internal/External Command.)
|
|
|
|
Lecture 15
|
M.S DOS Part-2
(Herein you will learn to create file. You will shown the steps live on the screen. You can see can and practice the same at your home or from any place. You will learning different commands to open a file creating it or to move/copy it from one folder to another or to hide and many more. This is going to be fun to command. You are requested to follow the steps, note it down, practice the commands as many times as you can Moreover you will get a practice sheets with 35-40 questions which will add up to your knowledge and make it further strong. For queries or doubts you can mail us at mail@studykhazana.com.)
|
|
|
|
Lecture 16
|
Operating System( Windows)
()
|
|
|
|
Lecture 17
|
Number System -1
()
|
|
|
|
Lecture 18
|
Number System -2
()
|
|
|
|
Lecture 19
|
LOGIC GATES
()
|
|