Understanding Data

Revision Summary: Understanding Data (NCERT Class 12 CS)

1. Chapter at a Glance

• Data are a collection of characters, numbers and other symbols that represent values of situations or variables; they must be gathered, processed and analysed before decisions can be taken.
• Structured data are organised in a well-defined tabular format (rows = observations, columns = attributes/variables); unstructured data lack any fixed row-column structure.
• Data collection involves identifying already available data or gathering it from appropriate sources and converting it into digital form (e.g., CSV, spreadsheet or DBMS).
• Data storage is the process of keeping data on devices (HDD, SSD, pen drive, etc.) so that it can be retrieved later; file processing has limitations that DBMS can overcome.
• Data processing transforms raw data into meaningful information through the cycle: collection → preparation/entry → storage/retrieval → classification/update → output/reports.
• Measures of central tendency (mean, median, mode) give a single representative value for an attribute; choice depends on data characteristics and presence of outliers.
• Measures of variability (range, standard deviation) describe the spread or dispersion of values around the mean.
• Outliers (exceptionally large or small values) affect mean, range and standard deviation; they should be identified and handled before summarisation.

2. Key Terms and Definitions

• Data: Collection of characters, numbers and other symbols representing values of some situations or variables (singular = datum).
• Structured data: Data organised and recorded in a well-defined tabular format where each column is an attribute/variable and each row is an observation.
• Unstructured data: Data that are not in the traditional row-and-column structure (e.g., web pages, emails, videos, social-media posts).
• Metadata: Data about data (e.g., image size, type, resolution for an image file; subject, recipient for an email).
• Data collection: Identifying already available data or gathering it from appropriate sources and converting it into digital form.
• Data storage: Process of storing data on storage devices so that data can be retrieved later.
• Data processing: Transforming raw data into meaningful information through input, processing and output steps.
• Measure of central tendency: A single value that summarises the data (mean, median or mode).
• Mean (average): Sum of all values of an attribute divided by the number of values.
• Median: Middle value when data are sorted in ascending or descending order (average of two middle values if even count).
• Mode: Value that appears the highest number of times in the data of an attribute.
• Measure of variability (dispersion): Degree to which values are spread around the mean (range and standard deviation).
• Range: Difference between the maximum and minimum values of the data.
• Standard deviation (σ): Positive square root of the average of the squared differences of each value from the mean.
• Outlier: An exceptionally large or small value compared with other values in the data.

3. Syntax and Constructs

No programming syntax, functions, methods or commands are introduced in this chapter. All content is conceptual.

4. Algorithms and Worked Logic

• Mean calculation
  1. Sum all numeric values of the attribute.
  2. Divide the sum by n (number of values).
  Formula: \(\bar{x} = \frac{\Sigma x_i}{n}\)

• Median calculation
  1. Sort the values in ascending or descending order.
  2. If n is odd → median = value at position (n+1)/2.
  3. If n is even → median = average of values at positions n/2 and n/2 + 1.

• Mode calculation
  1. Count frequency of each distinct value.
  2. Select the value(s) with the highest frequency (data may have no mode or multiple modes).

• Range calculation
  Range = Maximum value – Minimum value.

• Standard deviation calculation
  1. Compute the mean \(\bar{x}\).
  2. For each value compute \((x_i - \bar{x})^2\).
  3. Sum the squared differences and divide by n.
  4. Take the positive square root.
  Formula: \(\sigma = \sqrt{\frac{\Sigma(x_i - \bar{x})^2}{n}}\)

• Data-processing cycle (basic steps)
  Raw data → Input/Collection → Preparation/Entry → Storage/Retrieval → Classify/Update → Processing → Output (reports/results/information).

5. Common Errors and Exam Pitfalls

• Confusing structured data (tabular, fixed attributes) with unstructured data (no fixed format) or forgetting metadata examples.
• Calculating mean without removing outliers or stating that mean is sensitive to outliers while median is not.
• Forgetting to sort data before finding median or using the wrong middle-position formula for even/odd counts.
• Reporting range or standard deviation for non-numeric data.
• Stating that mode exists when every value occurs only once.
• Writing the standard-deviation formula with (n–1) instead of n (chapter uses population formula with n).
• Omitting units or context when giving statistical results (e.g., “30 cm” for range).
• Mixing up “data” and “information” or claiming decisions can be made by looking at raw data alone.