CBSE 12th Board Exam 2022

See CBSE Grade 12 Computer Science Practices 2022 Curriculum in Term 2. It is important for the preparation of the upcoming IP board exam 2022 of the CBSE class 12 in term 2 (term 2).

See Term 2 CBSE Class 12 Informatics Practices Syllabus 2022. Students preparing for Term 2 CBSE Class 12 Informatics Practices Board Exam 2022 should study this CBSE Class 12 IP Syllabus 2022 thoroughly and plan their studies accordingly. At the bottom of this article, there is a link to download the PDF for the 2022 Computer Science Practices Curriculum for Term 2 CBSE Class 12.

CBSE curriculum: 9th, 10th, 11th, 12th – revised & reduced (term 2 & 1 – combined): science, trade, art!

Term 2 CBSE Class 12 Informatics Practices Syllabus 2022:

Unit no.

Unit name

Brands

2

Database query with SQL

25th

3

Introduction to computer networks

10

total

35 marks

Unit 2:

Database query with SQL

  • Math functions: POWER (), ROUND (), MOD ().
  • Text functions: UCASE () / UPPER (), LCASE () / LOWER (), MID () / SUBSTRING () / SUBSTR

(), LENGTH (), LEFT (), RIGHT (), INSTR (), LTRIM (), RTRIM (), TRIM ().

  • Date functions: NOW (), DATE (), MONTH (), MONTH NAME (), YEAR (), DAY (),

DAY NAME (). Aggregate functions: MAX (), MIN (), AVG (), SUM (), COUNT (); With

COUNTING

  • .

Query and edit data using group by, credit, sort by.

Unit 3:

  • Introduction to computer networks
  • Introduction to networks, network types: LAN, MAN, WAN.
  • Network devices: modem, hub, switch, repeater, router, gateway.
  • Network topologies: star, bus, tree, network.
  • Introduction to the Internet, URL, WWW and its applications – web, email, chat, VoIP.
  • Website: Introduction, difference between a website and a website, static vs. dynamic website, web server and hosting of a website.

Web browser: introduction, frequently used browsers, browser settings, add-ons and plug-ins, cookies.

Distribution of practical grades

theme

Brands

SQL queries (pen and paper)

7th

Handy file – 12 SQL queries

2

Final project submission

3

Viva

3

total

fifteen

Recommended practical list

Data management

– Create a student table with the student number, name and tags as attributes, with the student number being the primary key.

– Enter the details of a new student in the table above.

– Delete a student’s details in the table above.

– Use the Select Command to view the details of students with grades over 80.

– Find the min., Max., Total and average of the grades in a student grade table.

– Find the total number of customers from each country in the table (customer number, customer name, country) by grouping by.

– Write a SQL query to sort the table (student ID, grades) in descending order of grades.

For more details, download the PDF of Computer Science Practices 2022 CBSE Grade 12 Curriculum in Term 2 from the link below

Download Term 2 CBSE Class 12 Informatics Practices Syllabus 2022 (PDF)

नीचे दिए गए लिंक को क्लिक करे और Government Recruitments – Study Guide and Study Tips की ताज़ा खबरों से जुड़े रहें |

भारत माता की जय |

Leave a Reply

Your email address will not be published. Required fields are marked *

বাংলা English ગુજરાતી हिन्दी ಕನ್ನಡ മലയാളം मराठी ਪੰਜਾਬੀ தமிழ் తెలుగు
error: Content is protected !!