Understanding Data

2.1 Core concepts

• What is data? Data is a collection of characters, numbers, and other symbols that represent values of some situations or variables. "Data" is plural; the singular form is "datum". Data stored electronically can be processed faster and more easily than manual processing. (NCERT §7.1, p. 98)
• Importance of data: Humans rely on data for decision-making. Large amounts of data, when processed by a computer, reveal hidden patterns not otherwise visible. Examples include ATM transactions (bank debiting the withdrawn amount), meteorological offices monitoring satellite data for cyclones, businesses using dynamic pricing based on demand-supply data, and electronic voting machines accumulating votes for quick result declaration. (NCERT §7.1.1, p. 98–99)
• Types of data — Structured: Data organised in a well-defined format, stored in a tabular (rows and columns) structure where each column is an attribute/characteristic/variable and each row is one observation. Examples: inventory tables, fee records, ATM withdrawal records. (NCERT §7.1.2(A), p. 99–100)
• Types of data — Unstructured: Data that is not in a traditional row-and-column format. Examples include newspaper pages, emails, web pages with multimedia content, text documents, business reports, audio/video files, social media messages. Unstructured data is sometimes described using metadata. (NCERT §7.1.2(B), p. 100–101)
• Metadata: Data about data. For an email, metadata includes subject, recipient, main body, attachment details. For an image file, metadata includes image size (KB/MB), image type (JPEG, PNG), and image resolution. (NCERT §7.1.2(B), p. 101)
• Data collection: The process of identifying already available data or collecting it from appropriate sources. Data may exist as physical diary/register entries (requiring digitisation into a spreadsheet), already in digital format (e.g., CSV file), or not yet recorded (requiring software development using Python with MySQL or CSV storage). (NCERT §7.2, p. 101)
• Data storage: The process of storing data on storage devices so it can be retrieved later. Common digital storage devices include Hard Disk Drive (HDD), Solid State Drive (SSD), CD/DVD, Tape Drive, Pen Drive, and Memory Card. File processing has limitations that can be overcome through Database Management System (DBMS). (NCERT §7.3, p. 102)
• Data processing: Converting raw data (numbers/text/image) into information (tables/charts/text). The data process cycle has three stages: Input (data collection, data preparation, data entry) → Processing (store, retrieve, classify, update) → Output (reports, results, processing system). Figure 7.1 and Figure 7.2 illustrate these steps with real-world examples (competitive exam admit card, bank ATM withdrawals, train ticket issuance). (NCERT §7.4, p. 102–103)
• Statistical techniques — overview: Summarisation methods applied on tabular data for easy comprehension. The five techniques covered are Mean, Median, Mode (measures of central tendency) and Range, Standard Deviation (measures of variability/dispersion). (NCERT §7.5, p. 103–104)
• Mean: The average of numeric values of an attribute. Given n values x₁, x₂, …, xₙ, mean = (sum of all values) / n. Mean is not suitable when outliers are present; outliers should be removed before calculating mean. Example: heights [90,102,110,115,85,90,100,110,110] → mean = 912/9 = 101.33 cm. (NCERT §7.5.1(A), p. 104)
• Median: The middle value when all values are sorted in ascending or descending order. For odd number of values, median is the value at the middle position. For even number of values, median is the average of the two middle values. Median represents the central value at which data is equally divided into two halves. Example: sorted heights [85,90,90,100,102,110,110,110,115] → median = 102 cm (position 5). (NCERT §7.5.1(B), p. 104–105)
• Mode: The value that appears most frequently in the data. Computed on the basis of frequency of occurrence. A dataset has no mode if each value occurs only once; it may have multiple modes. Mode can be found for numeric as well as non-numeric data. Example: in height data, mode = 110 (frequency 3). (NCERT §7.5.1(C), p. 105)
• Range: The difference between the maximum and minimum values in the data (M − S). Range can be calculated only for numerical data and indicates coverage/spread of data values. However, any outlier in the data badly influences the result since range is based on only the two extreme values. Example: max height 115 cm, min height 85 cm → range = 30 cm. (NCERT §7.5.2(A), p. 105–106)
• Standard deviation: Refers to differences within a group/set of data. Unlike Range, it considers all data values. Calculated as the positive square root of the average of squared differences of each value from the mean: σ = √[Σ(xᵢ − x̄)² / n]. Smaller σ means data are less spread; larger σ means more spread. Example: for the nine student heights, σ = √(938/9) = √104.22 ≈ 10.2 cm. (NCERT §7.5.2(B), p. 106)
• Python for data analysis: Python has libraries specially built for data processing and analysis, making it a preferred programming tool for efficient analysis of large data volumes. These will be covered in following chapters. (NCERT §7.5, p. 107)
• Why summarisation matters (NCERT §7.5, p. 103-104). Raw tabular data — even small datasets — quickly becomes hard to interpret. A single number (mean, median, mode) or a measure of spread (range, σ) compresses many values into a comprehensible summary, enabling decisions without scanning every record.
• Sensitivity of mean to outliers (NCERT §7.5.1(A), p. 104). Median, by contrast, is order-based and ignores the magnitudes of extreme values — making it the robust choice for income, real-estate prices, exam scores with outliers, etc.
• Why σ uses squared differences (NCERT §7.5.2(B), p. 106). Squaring ensures that positive and negative deviations from the mean do not cancel out; taking the square root at the end restores the original measurement unit (e.g., cm, not cm²).
• CSV vs Excel (NCERT §7.2, p. 101). Both are tabular formats, but CSV is plain text (cross-platform, language-agnostic) while Excel files are proprietary binary formats. Pandas can read both with read_csv() and read_excel() respectively.

2.2 Definitions to memorise

2.3 Diagrams / processes to remember

• Figure 7.1 — Steps in data processing (p. 103): Two-tier diagram showing (i) RAW DATA → Data Processing → INFORMATION and (ii) the Data Process Cycle: Input (Data Collection, Data Preparation, Data Entry) → Processing (Store, Retrieve, Classify, Update) → Output (Reports, Results, Processing System). Students must be able to place activities in the correct stage.
• Figure 7.2 — Data-based problem statements (p. 103): Three real-world cases — competitive exam admit card generation, bank ATM cash withdrawal, and train ticket issuance — each broken into Problem Statement / Inputs / Processing / Output columns. This figure is a prime source for case-based MCQs; remember the four-quadrant layout.
• Table 7.1 — Structured data about kitchen items in a shop (p. 100): Example of a structured dataset with columns ModelNo, ProductName, Unit Price, Discount(%), Items_in_Inventory. Used to illustrate how spreadsheet operations (summing a column, multiplying columns) work on structured data.
• Table 7.3 — Standard deviation calculation table (p. 106): Step-by-step working showing Height (x), x − x̄, and (x − x̄)² columns, with n = 9, x̄ = 101.33, Σ(x−x̄)² = 938.00, σ = 10.2 cm. Understand the tabular method for computing σ.

2.4 Common confusions / NTA trap points

• Mean vs Median for outlier-affected data: Mean is sensitive to outliers; Median is not. NTA often presents a dataset with one extreme value and asks which measure of central tendency is most appropriate — the answer is Median (or Mode, if the question is about the most frequent value). Mean should be used only after removing outliers.
• Range uses only two values; Standard Deviation uses all values: A common distractor states that range considers all data values. It does not — range = max − min. Standard deviation considers every data point.
• Mode can be non-numeric; Mean and Range cannot: Mode is the only measure that works for non-numeric (categorical) data. NTA trap: asking which technique to use for "most popular car colour" — answer is Mode, not Mean.
• Structured vs Unstructured mix-ups: Emails and newspaper layouts are unstructured (no fixed format). A fee receipt or ATM record is structured. The defining criterion is whether the data fits a fixed row-column schema.
• Data vs Metadata distinction (NCERT §7.1.2(B), p. 101). Metadata describes data — image resolution is metadata of an image file, not the image data itself.
• CSV is a structured-data format (NCERT §7.1.2(A), p. 101). Each row is an observation; columns are attributes — qualifies as structured.
• Median can be the average of two values (NCERT §7.5.1(B), p. 105). For an even-length sorted list, median is the average of the two middle values.
• Mode can be multimodal (NCERT §7.5.1(C), p. 105). A dataset may have more than one mode.
• Range is influenced by outliers (NCERT §7.5.2(A), p. 106). Since it uses only max and min, a single extreme value distorts it.
• σ vs Variance (NCERT §7.5.2(B), p. 106). σ is the square root of variance; both measure spread.
• DBMS over file processing (NCERT §7.3, p. 102). Overcomes redundancy, inconsistency, isolation issues.