Computer Science/Informatics Practices for NCET

• 1

  Database Concepts

  Section A (compulsory) and Section B1. Covers Database and file systems; Relational data model; Keys; Relational algebra.

  • Database and file systems 5 questions
  • Relational data model 5 questions
  • Keys 5 questions
  • Relational algebra 5 questions
• 2

  Structured Query Language

  Section A (compulsory), B1 and B2. Covers SQL and MySQL basics; DDL commands; DML and queries; Math and text functions; Date functions; Aggregate functions and grouping; Operations on relations.

  • SQL and MySQL basics 5 questions
  • DDL commands 5 questions
  • DML and queries 5 questions
  • Math and text functions 5 questions
  • Date functions 5 questions
  • Aggregate functions and grouping 5 questions
  • Operations on relations 5 questions
• 3

  Computer Networks

  Section A (compulsory), B1 and B2. Covers Introduction to networks; Network devices; Network topologies; Addressing and the web; Internet applications and websites; Web browsers.

  • Introduction to networks 5 questions
  • Network devices 5 questions
  • Network topologies 5 questions
  • Addressing and the web 5 questions
  • Internet applications and websites 5 questions
  • Web browsers 5 questions
• 4

  Exception and File Handling in Python

  Section B1, Computer Science. Covers Exceptions; try, except, else and finally; Text files; Binary files.

  • Exceptions 5 questions
  • try, except, else and finally 5 questions
  • Text files 5 questions
  • Binary files 5 questions
• 5

  Data Structures: Stack and Queue

  Section B1, Computer Science. Covers Stack; Expression notation; Queue; Deque.

  • Stack 5 questions
  • Expression notation 5 questions
  • Queue 5 questions
  • Deque 5 questions
• 6

  Searching and Sorting

  Section B1, Computer Science. Covers Linear and binary search; Hashing; Sorting algorithms.

  • Linear and binary search 5 questions
  • Hashing 5 questions
  • Sorting algorithms 5 questions
• 7

  Understanding Data

  Section B1, Computer Science. Covers Collecting and organising data; Statistical measures; Interpreting data.

  • Collecting and organising data 5 questions
  • Statistical measures 5 questions
  • Interpreting data 5 questions
• 8

  Data Communication and Security

  Section B1, Computer Science. Covers Communication concepts; Transmission media; Mobile telecommunication; Network protocols; Threats and prevention; Network security.

  • Communication concepts 5 questions
  • Transmission media 5 questions
  • Mobile telecommunication 5 questions
  • Network protocols 5 questions
  • Threats and prevention 5 questions
  • Network security 5 questions
• 9

  Data Handling Using Pandas

  Section B2, Informatics Practices. Covers Python libraries for data; Series; DataFrames; Indexing, merging and CSV; Descriptive statistics; Aggregation, grouping and pivoting; Missing values and MySQL.

  • Python libraries for data 5 questions
  • Series 5 questions
  • DataFrames 5 questions
  • Indexing, merging and CSV 5 questions
  • Descriptive statistics 5 questions
  • Aggregation, grouping and pivoting 5 questions
  • Missing values and MySQL 5 questions
• 10

  Plotting Data Using Matplotlib

  Section B2, Informatics Practices. Covers Chart types; Customising plots.

  • Chart types 5 questions
  • Customising plots 5 questions
• 11

  Societal Impacts

  Section B2, Informatics Practices. Covers Digital footprint and netiquette; Intellectual property; Cybercrime and cyber law; E-waste and health; Project-based learning.

  • Digital footprint and netiquette 5 questions
  • Intellectual property 5 questions
  • Cybercrime and cyber law 5 questions
  • E-waste and health 5 questions
  • Project-based learning 5 questions

Practice questions and mock tests