KV Hebbal Shala Darpan Videos (R K S)

                                                              शाला दर्पण

Ministry of Human Resource Development, Government of India: Click Here

KV Shaala Darpan August 2019 activities (Online Tutorial Links & Training Manuals) :Click Here  Step 8 - Result Entry-Scholastic,Co-Sch Grades,&Teacher Rem_1.0.pdf:  Click Here                        1. Training Video – Examination - Result Entry - Scholastic: (13 min) Click Here            2. Training Video – Examination - Result Entry - Co-Scholastic Grades Entry: (6 min)  Click Here            3. Training Video – Examination - Result Entry - Teacher's Remarks : (10 min)  Click Here Step 7 - Allocate Optional Subjects to Students_1.0.pdf : Click Here Step 6 - Exam Scheduling_1.0.pdf: Click Here Step 5 - Set Data Entry Rule for Result Entry_1.0 : Click Here Step 4 - Inherit Grade Rules_1.0.pdf : Click Here

*  HRMS-Class Teacher Association/Allocation:(07 min Year: August 2019) :Click Here

*  Admission- Student Roll Number updation for the new Academic Year( 09 Minutes August
     2019 (March 2016) ) :Click Her

*  Bulk Students Data Uploading Excel-file format (Down load: Year August 2019): Click Here

*  Students Promotion and Detention(20 Minutes Year:August 2019 (2017)): Click Here

*  Photo upload for students: (11 Minutes Year: August 2019 (March 2016) ): Click Here

*  ADM STUDENT PROMOTION 31032016 Click Here (11:09 Minutes)          

    

* Examination Rule(38 minutes): Click Here
        Examination template: 1. Trouble shooting :Click here  2. Module: Click Here 3. Letter

* EXM 03 Exam Rule(40 minutes): Click Here

* EXM 13 Exam Scheduling (16 minutes): click Here

*  EXM 14 Exam Result (21 minutes):  Click Here

*  EXM 17 Exam Result Posting
    Click Here (07:52 minutes)

* KVS Steps to Exam Result Entry – Scholastic, Co Scholastic, & Remarks Shaala Darpan: Click Here (4: 34 minutes)

9. Uniform System of Assessment, Examination and Report card Class I to XII academic year
2017-18 on wards: Click Here


*  Off line Result Entry in Shaala Darpan manual and link 2018(date 01-10-18): Click Here

* Employee and Student Data Import: Click Here  (13:13 Minutes Year: 2016)
        Students data porting template(procedure) :    1. pdf file     2. Excel sheet

11-C Prog-24. Write a algorithm and python function program to find mean value in a list without using function average():

def mean(n):
    l=[]
   
    for i in range(n):
        num=int(input("Enter the number"))
        l.append(num)
   
    #mean logic
    sum=0
    for j in range(len(l)):
        sum=sum+l[j]
    avg=sum//n
    print("The mean value of list is:",avg)

#main program
n=int(input("Enter the size of the list"))
print("The size of the list",n)
mean(n)

Example:

Enter the size of the list5
The size of the list 5
Enter the number6
Enter the number4
Enter the number5
Enter the number10
Enter the number20

The mean value of list is: 9

    

12th September test-2018 Blue Print

 Boolean Algebra-16 marks

1)  Boolean  Circuit to Expression -2 mark

2)  Boolean  Expression to Circuit : 2 marks

3)  Writing   SOP Expression Expression (3 variables):1 mark 

4)  Writing   POS Expression (3 variables): 1 mark 

5)  Boolean Laws(10+1) verification (truth table/Laws): 2 marks

6)  Boolean Laws(10+1) verification (truth table/Laws): 2 marks

7)  K-Map simplify SOP expresiion: 3 marks

8)  k-Map simplify POS  expression: 3 marks

 DBMS Concepts- (15 marks)
                  Two Table

1) Relational model- 1mark                         2) Tupple - 1mark               3) Attribute - 1 mark, 

4)Degree-1mark                                         5) Cardinality                        6)Selectioon(   ) 1mark

7) Projection (π)- 1 mark                            8) Candidate Key - 1mark    9) Primary Key  1mark

10) Alternate Key- 1mark                           11) Foriegn Key - 1 mark      

 Relational Algebra:       12) Union  - 1mark      13) Intersection - 1mark 

14)Cartesian product - 1 mark          15) Difference - 1 mark


SQL COMMANDS : (4 marks)

1) CREATE TABLE - 2 marks     2) ALTER TABLE,- 2 marks


create table name of the table

(

 colum1 datatype,

 colum2 datatype,

 colum3 datatype,

'

.

column datatype );

 integer,

 Item_name char(15),

 Type char(15),

 DOS date,

 Price decimal,

 Discount integer

);

create table FURNITURE

(

 No integer,

 Item_name char(15),

 Type char(15),

 DOS date,

 Price decimal,

 Discount integer

);

DROP TABLE, ALTER TABLE, UPDATE...SET...,INSERT, DELETE;
SLECT, DISTINCT, FROM WHERE, IN, BETWEEN, GROUP BY, HAVING, ORDER BY;

SQL FUNCTIONS: SUM, AVG, COUNT, MAX and MIN


a) Writing sql query  with the help description, refering Table1  and Table2  - 1 mark
b) Writing sql query  with the help description, refering Table1  and Table2  - 1 mark
c) Writing sql query  with the help description, refering Table1  and Table2  - 1 mark
d) Writing sql query  with the help description, refering Table1  and Table2  - 1 mark

e) Writing Output for the sql query, refering Table1 and Table2 -   ½ mark
f) Writing Output for the sql query, refering Table1 and Table2 -   ½ mark
g) Writing Output for the sql query, refering Table1 and Table2 -   ½ mark
h) Writing Output for the sql query, refering Table1 and Table2 -   ½ mark

 Two Table General Syntax and Example:

SELECT  T2C,  T1C,  FROM  TABLE2  T2,  TABLE1 T1 WHERE T2..PKEY=T1..FKEY  CONDITION

EXAMPLE:
SELECT NAME, DEPARTMENT FROM EMPLOYEE E, DEPT D WHERE E.DCODE=D.DCODE AMD ENO<1003;      (OD. 2015)

SELECT  PNAME, SNAME FROM PRODUCTS P , SUPPLIERS S WHERE P.SUPCODE=S.SUPCODE AND QTY>100;  (OD 2013

11-C prog-27 Write a algorithm and python program accesses the elements one by one from the list if it is prime number display it

#program
def prime(n):
    lis=[]
    for i in range(n):
        num=int(input("Enter the element"))
        lis.append(num)
 
    for k in range(len(lis)):
        label=0
        for j in range(2,lis[k],1):
            if lis[k]%j==0:
                label=1
                break
        if label==0:
            print(lis[k])

#main program
n=int(input("Enter size of the list"))
print("The size of the list",n)
prime(n)

Example:

Enter size of the list4
The size of the list 4
Enter the element4
Enter the element7
Enter the element9
Enter the element17
7
17

12th D CS Question Wise Pattern-2018

   

     October-18  Q. No. 7 Computer Networking (10): Click Here

     September- 18 Q.No. 5 & 6 DBMS, SQL & Boolean Algebra(8+8) : Click Here 

     August-18 Q.No.-3 Data Structure in C++ (14): ClickHere

     July-2018. Q.No.- 4 Data File Handling in C++ (6) : Click Here  

    April-June-July-18 Q.No.-2 Object Oriented Programming in C++(12): Click Here

    April-18  Q.No.-1 C++ Revision Tour-11th Syllabus (12): Click Here 

    12th Computer Science(083) Blue-Print and Level Wise :Click Here

   * 12th-CS split up syllabus 2018-19: Click Here

Python Programming Concept Videos

 01. For beginners in Hindi: Introduction to python:  02:42 seconds
        https://www.youtube.com/watch?v=9NSG06bHekE

02. print() and comments in python (1:23 seconds)

    https://www.youtube.com/watch?v=MotfbvS5nC0

03. Variables in python (4:09 seconds)

        https://www.youtube.com/watch?v=MqNMZVX-xZ8

    04. Data types in python (2:14 seconds)                 https://www.youtube.com/watch?v=2Qtnorn8HMA 

05. Numbers data type in python (4:23 seconds)

    https://www.youtube.com/watch?v=mk20Q7P85fY

06. Strings data type in python:(6:23 seconds)

    https://www.youtube.com/watch?v=hOSbvs5gY1I

07.  python lists(Arrays)-8 -( 8:14 seconds) 

     https://www.youtube.com/watch?v=WSgLugvHMFg

08.Dictionary in python-(7:03 seconds)

         Click Here

09Tuple in python-(7:17 seconds)

       Click Here

10. if else in python-(09:03 seconds)

       Click Here

 

       

11-C Prog-26 Write a algorithm and python program accessing elements in a list(array) one by one if element even no. multiply by 10 and odd numbers divide by 5

def e_o(n):    #called function
    l=[]     # empty list
    for i in range(n):
        num=int(input("enter the number:"))
        l.append(num)

    for j in range(n):
        if l[j]%2==0:
            l[j]=l[j]*10
        else:
            l[j]=l[j]//5

    print("updated list elements=",l)

#main program
n=int(input("enter n value:"))
print("the n value is=",n)
e_o(n)   #calling function

Example:
enter n value:4
the n value is= 4
enter the number:12 enter the number:15 enter the number:20 enter the number:25
updated list elements= [120, 3, 200, 5]

introduce the notion of accessing elements in a collection of numbers in python

How to create an array in Python

arr = [10, 20, 30, 40, 50]

Accessing elements of array using indexing

arr = [10, 20, 30, 40, 50]
print(arr[0])
print(arr[1])
print(arr[2])

Ans:

10
20
30

Accessing elements of array using negative indexing

arr = [10, 20, 30, 40, 50]
print(arr[-1])
print(arr[-2])
Ans.
50
40

Find length of an array using len()

brands = ["Coke", "Apple", "Google", "Microsoft", "Toyota"]
num_brands = len(brands)
print(num_brands)    Ans: 5

SQL-3 TWO TABLE PROBLEMS

  Consider the following Dept and Employee tables.  Write SQL queries for (1) to (4) and find outputs for SQL queries (5) to (8).

Table: Dept

DCODE	DEPARTMENT	LOCATION
D01	INFRASTRUCTURE	DELHI
DO2	MARKETTING	DELHI
D03	MEDIA	MUMBAI
D05	FINANCE	KOLKATA
D04	HUMAN RESOURCE	MUMBAI

Table: Employee

ENO	NAME	DOJ	DOB	GENDER	DCODE
1001	GEORORGE K	01/09/2013	01/09/1991	MALE	D01
1002	RYMA SEN	11/12/2012	15/12/1990	FEMALE	D03
1003	MOHITESH	03/02/2013	04/09/987	MALE	D05
1007	ANILA JHA	17/01/2014	19/10/984	MALE	D04
1004	MANILA SAHAI	09/12/2012	14/11/1986	FEMALE	D01
1005	R SAHAY	18/11/2013	31/03/1987	MALE	D02
1006	JAYA PRIYA	09/06/2014	23/06/985	FEMALE	D05

CREATE TABLE DEPT1
( 

DCODE CHAR(3),
DEPARTMENT CHAR(15),
LOCATION CHAR(8)

);

INSERT INTO DEPT1 VALUES('D01','INFRASTRUCTURE','DELHI');
INSERT INTO DEPT1 VALUES('D02','MARKETING','DELHI');
INSERT INTO DEPT1 VALUES('D03','MEDIA','MUMBAI');
INSERT INTO DEPT1 VALUES('D05','FINANACE','KOLKATA');
INSERT INTO DEPT1 VALUES('D04','HUMAN RESOURCE','MUMBAI');

CREATE TABLE EMPLOYEE1
(

ENO CHAR(4),
ENAME CHAR(15),
DOJ DATE,
DOB DATE,
GENDER CHAR(6),
DCODE CHAR(3)

);

INSERT INTO EMPLOYEE1 VALUES('1001','GEORORGE','01/09/13','01/09/91','MALE','D01');

INSERT INTO EMPLOYEE1 VALUES('1002','RYMA SEN','11/12/12','15/12/90','FEMALE','D03');

INSERT INTO EMPLOYEE1 VALUES('1003','MOHITESH','03/02/13','04/09/87','MALE','D05');

INSERT INTO EMPLOYEE1 VALUES('1007','ANILA JHA','17/01/14','19/10/84','MALE','D04');

INSERT INTO EMPLOYEE1 VALUES('1004','MANILA SAHAI' ,'09/12/12', '14/11/86', 'FEMALE', 'D01');

INSERT INTO EMPLOYEE1 VALUES('1005','R SAHAY','18/11/13','13/03/87','MALE','D02');

INSERT INTO EMPLOYEE1 VALUES('1006','JAYA PRIYA','09/06/14','23/06/85', 'FEMALE','D05');

Q01 - To display Eno, Name, Gender from the table EMPLOYEE in ascending of Eno.
Ans: SELECT ENO,ENAME,GENDER FROM EMPLOYEE1 ORDER BY ENO;

Q02 - To display the Name of all the MALE emloyees from the table EMPLOYEE.
Ans: SELECT NAME FROM EMPLOYEE WHERE GENDER='MALE';

Q03 - To display the Eno and Name of those employees from the table EMPLOYEE   who are born between  '01-JAN-87' and '01-DEC-91'.
Ans: SELECT ENO,ENAME FROM EMPLOYEE1 WHERE DOB BETWEEN '01/01/87' AND '01/12/91';

Q04 - To  count and display FEMALE employees who have joined after '01-JAN-86'.
Ans: SELECT COUNT(*) FROM EMPLOYEE1 WHERE GENDER='FEMALE' AND DOJ>'01-JAN-86';


Q05 - SELECT COUNT(*), DCODE FROM EMPLOYEE GROUP BY DCODE HAVING COUNT(*)>1;
Ans: COUNT      DCODE
           2                  D01
           2                  D05

Q06 - SELECT DISTINCT DEPARTMENT FROM DEPT;
Ans: Department
         INFRASTRUCTURE
         MARKETTING
         MEDIA
         FINANCE
        HUMAN RESOURCE

Q07 - SELECT NAME, DEPARTMENT FROM EMPLOYEE E  , DEPT D WHERE E.DCODE=D AND ENO<1003;
Ans:  NAME             DEPARTMENT
          George K         INFRASTRUCTURE
          Ryma  Sen        MEDIA

Q08 - SELECT MAX(DOJ), MIN(DOB) FROM EMPLOYEE;
Ans: MAX(DOJ)              MIN(DOB)
        09/01/14                19/10/84

Outside Delhi (2015) 

12th D SQL- 2 TWO TABLE PRACTICAL

(2014) OUTSIDE DELHI

Table: SHOPEE

Id	SName	Area
S001	ABC Computronics	CP
S002	All Infotech Media	GK II
S003	Tech Shoppe	CP
S004	Greeks Tecno Soft	Nehru Place
S005	Hitech Tech Store	Nehru Place

create table shoppe
(Id character(10),
 Sname character(30),
 Area character(20)
);


insert into shoppe values('S001','ABC Computeronics','CP');

insert into shoppe values('S002','All Infotech Media','GK II');

insert into shoppe values('S003','Tech Shoppe','CP');

insert into shoppe values('S004','Geeks Techno Soft','Nehru Place');

insert into shoppe values('S005','Hitech Tech Store','Nehru Place');

Table: Accessories:

No	Name	Price	Id
A01	Mother Board	12000	S001
A02	Hard Disk	5000	S001
A03	Keyboard	500	S002
A04	Mouse	300	S001
A05	Mother Board	13000	S002
A06	Keyboard	400	S003
A07	LCD	6000	S004
T08	LCD	5500	S005
T09	Mouse	350	S005
T10	Hard Disk	4500	S003

create table accessories
(No character(5),
 Name character(30),
 Price decimal,
 Id character(5)
);

insert into accessories values('A01','Mother Board',12000.00,'S001');
insert into accessories values('A02','Hard Disk',5000.00,'S001');
insert into accessories values('A03','Key Board',500.00,'S002');
insert into accessories values('A04','Mouse',300.00,'S001');
insert into accessories values('A05','Mother Board',13000.00,'S002');
insert into accessories values('A06','Keyboard',400.00,'S003');
insert into accessories values('A07','LCD',6000.00,'S004');
insert into accessories values('T08','LCD',5500.00,'S005');
insert into accessories values('T09','Mouse',350.00,'S005');
insert into accessories values('T10','Hard Disk',4500.00,'S003');

Q.1  To display Name and Price FROM Accessories in ascending order of their Price.
Ans. SELECT NAME,PRICE FROM ACCESSORIES ORDER BY PRICE;

Q.2  To display Id, SName of  all shopee located in Nehru Place
Ans: SELECT ID,SNAME FROM SHOPPE WHERE AREA='Nehru Place';

Q.3. To display Minimum and Maximum Price of each Name of Accessories.
Ans:  SELECT NAME,MIN(PRICE),MAX(PRICE) FROM ACCESSORIES GROUP BY NAME;

Q.4 To display Name, Price of all Accessories and their respective SName where they are available.
Ans:  SELECT NAME,PRICE,SNAME FROM ACCESSORIES A , SHOPPE S WHERE A.ID=S.ID;