Back to your course / CR2-S05
Computing and Robotics · 2.º ESO · Learn
Big Data and artificial intelligence
Data support explanations that can be questioned and revised, but they need context. You will clean a sample, represent a question and test a classifier with new examples while explaining errors and limitations.
Your mission
Produce a data report and model for a school need. Use anonymous, open or prepared data without personal information, with a dictionary, cleaning record and charts. Train a classifier for objects or non-identifying sounds, separate training and testing, record a class-based matrix and evaluate an improvement.

Read the explanation, study the diagram and try the activity in each section. You can choose another version at any time.
Your tools
Use Google Docs for written explanations and diagrams.net for diagrams. Save the editable file as well as the evidence requested in each task.
5.1. From a school dataset to Big Data
Learn · theory and practice
A datum represents an observation, category or value. Interpretation requires knowing what it describes and how it was obtained. Metadata provide context: origin, time, scale, method or transformations. Not all are needed in every project; choose them according to the question. A relative light reading and a measurement in lux cannot be compared as the same quantity. A file’s editing date is not necessarily the moment when the phenomenon was observed either.
Big Data involves datasets and problems whose management requires scalable resources and methods. Volume, variety and generation speed help explain the need: many records, different formats and continuous inputs can make timely storage and analysis difficult. No row count alone turns our table into a Big Data infrastructure. The school sample teaches a shared process: ask, describe provenance, prepare data, analyse and communicate limitations. Relate that process to a real service without confusing a small demonstration with a large platform’s capabilities.
- Question
- Data with provenance
- Relevant metadata
- Interpretation
Two tables both show 80. The first uses a relative light scale from 0 to 255; the second expresses a percentage of classified objects. The numbers match but describe different things. Before plotting them together, the team checks the dictionary and formulates a question for each variable. Context prevents a mathematically possible operation from producing a meaningless comparison.
- In Google Docs, formulate a specific question about a school need without collecting personal data.
- In Google Sheets, identify the origin and meaning of four fields in the prepared sample.
- In diagrams.net, connect volume, variety or speed with a data-service difficulty.
What must you know before comparing two columns named value?
5.2. A dictionary makes data understandable
Learn · theory and practice
A data dictionary defines each field: name, meaning, type, unit or scale and permitted values. A zone is categorical; a reading may be numerical; an instant expresses time. An identifier recognises a record but must not contain personal information. Equal readings are not necessarily duplicates: they may represent separate observations. Identify an exact duplicate using a rule covering identifier and fields, checking provenance before removing a copy.
Cleaning prepares a working copy without changing the original. Record action, reason and effect on rows or calculations. Missing information is not zero; an out-of-scale value requires checking the source rather than intuitive correction. For a mean, sum only valid values and divide by their count, reporting excluded missing values. Do not hide data contradicting expectations. Cleaning must make decisions reconstructable and distinguish corrected errors from remaining uncertainty. Another pair can then review whether the chart actually represents the described sample.
- Preserved original
- Review rule
- Documented change
- Analysable copy
Three valid records have values 4, 6 and 8, while another has no reading. The mean of known values is 6 using three observations. Replacing the missing value with zero would give 4.5 and assert a measurement never made. The team preserves the missing value and explains the denominator. These hypothetical data illustrate calculation rather than submission-dataset results.
- Open the classroom material’s datos_revision.csv and dictionary in Google Sheets and preserve an original copy.
- In a Google Sheets copy, review the exact duplicate, missing value and scales and record each decision.
- In Google Docs, explain a mean’s denominator and unresolved cases.
Why do a missing value and a zero reading have different meanings?
5.3. Choose charts that answer the question
Learn · theory and practice
A chart represents selected relationships from a table. Bars support category comparisons; lines can show evolution when order is meaningful, such as time. An increasing identifier does not guarantee equal time intervals. Before choosing a type, write the question and what each axis represents. When comparing zone means, also report the valid observation count for each zone. A chart cannot recover context missing from the data.
Scale changes visual impressions. For bars, starting at zero usually supports proportional interpretation; a visible truncation may serve another purpose but must be justified without hiding its effect. Compare two representations of the same dataset to distinguish appearance from conclusion. Association does not demonstrate causation: quantities may vary together because of another factor or sample selection. Limit conclusions to observed conditions and identify additional data needed. Keep table and chart linked so ranges, filters and labels remain reviewable instead of submitting only an image without provenance.
- Analysis question
- Variables and order
- Chart and scale
- Limited conclusion
Two zones have hypothetical means of 18 and 20. One chart begins at 17 and makes the difference look enormous; another begins at zero and preserves visual proportion. Numbers are unchanged, but impressions differ. The team states its question, scale and observation count. It does not conclude that one zone will always exceed the other from this sample.
- In Google Sheets, create a chart by zone and another by observation order.
- In Google Sheets, review ranges, axes, scale and valid-data count.
- In Google Docs, explain each chart’s question, a supported conclusion and another needing more tests.
How does a time trend differ from a line joining unordered categories?
5.4. Supervised learning and representative data
Learn · theory and practice
Supervised learning starts with examples accompanied by labels identifying their reference classes. During training, the model adjusts relationships between input features and those labels. For another example, it uses what it has learned to produce a prediction, without understanding the object as a person does. Those relationships depend on the available examples: if a class always appears against the same background, the model may use that as a cue rather than distinguish the intended feature. Quantity, diversity and label consistency influence this learning.
Testing examines what happens with examples that were not used for training. Reserving them beforehand and documenting how they were obtained separates the two purposes. Renaming a photograph or extracting a nearly identical image from the same capture does not guarantee independence. The workshop uses twenty training examples per class and ten new tests, five per class. These quantities organise the exercise and support comparable records, but do not guarantee general performance. Materials consist of objects or non-identifying sounds, with no recognisable people, using the approved tool.
Test errors can also guide improvements to training. Once used for that purpose, the series has influenced the design: it no longer provides an independent check of the chosen improvement. Its exploratory role is therefore retained, and another independent series is prepared after the change is selected. This separation distinguishes what was learned by reviewing errors from what was observed when evaluating the model again.
- Labelled examples
- Training
- Model
- Reserved examples
- Recorded predictions
A classifier learns notebooks on a light table and pencil cases on a dark one. Initial tests appear successful, but swapping backgrounds changes predictions. This investigates a cue unrelated to object class. The team proposes varying backgrounds in both classes and reserving new captures. Adding copies of the same photos would not verify removal of the dependency.
teachable machine
Watch in short sections. Connect one explanation with the diagram and try the example in this section. The written theory lets you complete the activity without playing the video.
The video keeps its original spoken language. Use the captions available in the player if they help.
- In Google Docs, define two classes and separate training and test examples beforehand with their provenance.
- In approved Teachable Machine, train with twenty examples per class without personal information.
- Run ten new tests, five per class, and record reference and prediction in Google Sheets.
Why does testing the same images used in training not check generalisation?
5.5. Class-level results can reveal a problem
Learn · theory and practice
A results matrix organises each test using two pieces of information: the actual class, known as the reference, and the class predicted by the model. In our representation, rows correspond to actual classes and columns to predictions; labelling them prevents reversed interpretations. Matches lie on the diagonal and the other cells count confusions. A row total shows how many actual examples of that class were tested. A column total counts how often the model answered with that class, rather than how many objects actually belonged to it.
Percentages answer different questions depending on their denominators. Overall accuracy divides all matches by the total number of tests. Class-level accuracy divides a row’s matches by the actual examples of that class. With different class sizes, a high overall result can hide failures concentrated in one class. Keeping the matrix, totals and denominators reveals that distribution and supports deciding which cases deserve review.
The score or confidence displayed for a prediction concerns that example, rather than the percentage of correct answers observed in the test. It does not guarantee truth: a high-scoring response still counts as an error if it contradicts the reference. The record retains those errors and their scores too. The direction of confusion also matters, because putting material in the wrong box and leaving it unsorted can have different consequences. The small sample guides improvements; it neither demonstrates performance under all future conditions nor justifies important decisions about people.
- Reference and prediction
- Matrix
- Accuracy with denominator
- Class errors
- Improvement hypothesis
A hypothetical test uses eight examples per class. The model gets six A and four B right: ten matches out of sixteen, or 62.5%. Class results are 75% for A and 50% for B. The difference guides case review. An incorrect prediction with a high score still counts as an error against the known reference.
- In Google Sheets, build the matrix with actual rows, predicted columns and totals.
- In Google Sheets, calculate overall and class-level accuracy with each denominator.
- In Google Docs, explain an error in each direction and distinguish prediction score from test accuracy.
What information does an overall percentage hide without class-level results?
5.6. Ethical decisions are part of design
Learn · theory and practice
A system may work technically yet be inappropriate for a purpose. Ask which decision it supports, who is affected by error and who can review results. Classroom-object classification studies patterns without classifying people or allocating opportunities. Choose only necessary information and check that open material contains no personal data before reusing it. Removing names or replacing them with codes does not by itself prove that other columns or images cannot identify someone.
The report connects question, provenance, cleaning, representation, training and evaluation. A responsible conclusion explains two limitations and a usage condition, linking them to evidence. Bias may arise from collected examples, chosen labels or missing situations. Adding repeated data does not automatically remove it. Formulate a concrete hypothesis and testable improvement, such as diversifying a missing orientation. Retain human review outside tested conditions. Recognising uncertainty does not make the work worthless: it determines which part of the demonstration is useful and which cannot extend to other contexts.
- Purpose
- People and consequences
- Evidence and limits
- Usage condition
- Human review
A model distinguishes two materials only with a uniform background and good lighting. The team can present a demonstration under those conditions, but not automatic classification of every waste item. They propose human review for deformed objects and new tests with varied orientations. The usage condition connects demonstrated performance to a practical decision rather than a generic final warning.
- In Google Docs, identify purpose, audience, an error consequence and who would review results.
- In Google Sheets, check whether the sample and labels leave a condition unrepresented.
- In Google Docs, write two limitations, a responsible-use condition and an improvement linked to observation.
Why is an accuracy figure insufficient to decide where to use the model?
5.7. Laboratory, project and two assignments
Learn · theory and practice
The laboratory connects table analysis and classification through a shared question and reviewable record. There is no need to pretend both files contain the same data types: explain each contribution to the school need. Preserve original, cleaned copy, dictionary, charts and model results. A test sheet identifies example, actual class, prediction and capture conditions; another summarises the matrix and denominators without replacing individual records.
To study reduced examples in one class, maintain comparable conditions and document each version’s training. Using one series to compare versions may support exploration, but that series influences selection of the improvement. Then run a fresh independent evaluation. Do not attribute every variation to quantity if background, labels or tool also changed. A01 combines the question, plan and first completed cleaning, charting, training and testing actions. A02 adds full analysis, class results, evaluated improvement and limitations. Each partner explains a decision and a data-supported conclusion within the same two assignments.
- Preserved process
- Exploratory comparison
- Chosen improvement
- New independent test
- Report
A version improves after adding images, but test lighting also changed. The record reveals two different factors. The team cannot be sure which caused the difference and repeats under described conditions. This is useful even without a definitive improvement: it identifies what must be controlled before claiming more examples solved the problem.
- In Google Sheets, organise originals, cleaning, charts, individual tests and matrix in identified spaces.
- In Teachable Machine, compare full training with a reduced-class version, recording conditions.
- Choose an improvement, run another independent series and write the comparison and individual explanation in Google Docs.
How does a series’ role change once its errors have guided design?
5.8. Explore further at your own pace
Learn · theory and practice
Documentation checks terms and procedures without turning an example figure into your own result. Google’s dataset reference explains that tests can wear out when repeatedly used to adjust decisions. Its classification reference shows why overall accuracy depends on class distribution. Google Sheets help guides chart types. Consult each resource with a specific question and connect its explanation to the operations and conditions actually used in class.
Teachable Machine trains and runs models using browser technology, but that does not justify claiming that every configuration, save or export always keeps all data in one place. The teacher checks the approved environment and permitted examples are used. Preserve the project or model through authorised options and record reopening instructions; do not publish it automatically just to obtain evidence. Videos are optional and may be supported by text. To transfer the model to another object or condition, review classes, diversity, error consequences and fresh evaluation. Explain what the test would teach without promising that more data guarantee improvement.
- Method question
- Primary source
- Documented application
- Own result
- Declared scope
A guide shows a large dataset and excellent results. The team does not transfer that percentage to its ten tests. It uses the reference to understand dataset separation and keeps its own modest results, then proposes investigating another orientation with new examples. The source supports the method; the pair’s observations support the report’s conclusion.
- Consult dataset, classification and chart-type references for a report question.
- In Google Docs, connect one methodological claim to its source and another conclusion to your observations.
- Save the Teachable Machine project through an authorised option and check reopening without public distribution.
Which report claims are supported by documentation and which need your own results?
Your project and submissions
A01 · Design the solution
- Create CR2-S05_datos_A01_Apellidos in Google Docs with question, need, audience and chosen source.
- In Google Sheets, define fields and dictionary, then complete initial cleaning and a chart while preserving the original.
- In diagrams.net, represent provenance, cleaning, analysis, training and testing with separate files.
- Define two classes, reserve independent tests and complete initial training and evaluation in approved Teachable Machine.
- Add an ethical risk, planned usage condition, results compared with predictions, sources and individual contributions.
What to submit
- Dossier with question, provenance, dictionary, cleaned table and first chart.
- Change record, classes and dataset separation with initial training and testing completed.
- Risk and ethical condition linked to design; individual explanation.
A02 · Data report and model for a school need
- Complete cleaning and two representations in Google Sheets, explaining scales, question and denominators.
- Train two classes in Teachable Machine with twenty examples per class and record ten new tests, five per class.
- Build the matrix in Google Sheets and calculate overall and class-level accuracy, including errors.
- Compare with reduced training in one class, choose an improvement and evaluate it with another independent series under documented conditions.
- Submit CR2-S05_datos with Google Docs report, editable table, dictionary, changes, charts, reopenable project or model, tests, two limitations, a responsible-use condition, sources and individual explanation.
What to submit
- Preserved original, reconstructable cleaning and two charts connected to explicit questions.
- Reopenable model or project, separate datasets and matrix with references, predictions and denominators.
- Improvement evaluated on new tests; two limitations and a usage condition supported by records and individual explanation.
Before you submit
- I explain each field’s meaning and provenance.
- I distinguish duplicates, real repetition and missing values without inventing measurements.
- I choose charts by question and explain scale.
- I separate training and evaluation and recognise when tests have guided adjustments.
- I interpret the matrix and class accuracy without confusing them with confidence.
- I propose an improvement, two limitations and a usage condition supported by results.
Templates and files
Open the blank A01 or A02 template and make your own copy in Google Docs. Keep the editable file from your project platform as well.
These reusable templates help you organise your work. Follow the specific instructions and evidence list for this unit; remove fields that do not apply. The blank master is read-only. Keep your answers private and share them only as your teacher instructs.
A01 · Design the solution
Make your own copy in Google Docs · View the blank template
- Dossier with question, provenance, dictionary, cleaned table and first chart.
- Change record, classes and dataset separation with initial training and testing completed.
- Risk and ethical condition linked to design; individual explanation.
A02 · Data report and model for a school need
Make your own copy in Google Docs · View the blank template
- Preserved original, reconstructable cleaning and two charts connected to explicit questions.
- Reopenable model or project, separate datasets and matrix with references, predictions and denominators.
- Improvement evaluated on new tests; two limitations and a usage condition supported by records and individual explanation.
Classroom rubrics
The classroom assessment reference is preserved below in its original Spanish. Use the checklist above to prepare your work and ask your teacher about any descriptor you need to clarify.
Consultar la rúbrica de A01
Diseño y microprueba
CYR.2.4.1 Datos, metadatos y lectura crítica
Conocer las aplicaciones actuales del Big Data, así como la naturaleza de los distintos tipos de datos y metadatos generados, siendo capaces de analizarlos, visualizarlos y compararlos, empleando a su vez un espíritu crítico y científico.
Evidencia. Pregunta, diccionario, tabla limpia y primer gráfico de taller.
| Banda | Desempeño observable |
|---|---|
| 1–2,9 | Confunde dato y metadato y no relaciona tabla o gráfico con la pregunta. |
| 3–4,9 | Reconoce variables, pero pierde procedencia o trata duplicados y ausencias como datos válidos sin explicación. |
| 5–6,9 | Distingue datos y metadatos, documenta procedencia, realiza una limpieza y un gráfico y relaciona el ejemplo con una aplicación de Big Data sin llamar masiva a la muestra escolar. |
| 7–8,9 | Compara representaciones o escalas y explica una limitación del origen o tamaño de muestra. |
| 9–10,0 | Contrasta otra fuente o política de limpieza y justifica cómo cambia la interpretación de la pregunta. |
CYR.2.4.2 Modelo entrenado, evaluación y ética
Comprender los principios básicos de funcionamiento de los agentes inteligentes y de las técnicas de aprendizaje automático, con objeto de aplicarlos para la resolución de situaciones mediante la Inteligencia Artificial de forma ética y responsable.
Evidencia. Clases, separación de conjuntos y primer entrenamiento y prueba independiente.
| Banda | Desempeño observable |
|---|---|
| 1–2,9 | Confunde la regla programada con un modelo aprendido o usa entrenamiento como demostración final. |
| 3–4,9 | Entrena, pero no separa pruebas o propone un uso sin considerar errores o personas afectadas. |
| 5–6,9 | Explica entrenamiento y predicción, realiza una prueba independiente y prevé un riesgo y una condición ética de uso. |
| 7–8,9 | Detecta desequilibrio o pista espuria y propone mejora que conserva una prueba nueva. |
| 9–10,0 | Diseña una comparación controlada de ejemplos o contexto y anticipa qué resultado apoyaría su hipótesis. |
Consultar la rúbrica de A02
Producto pruebas y mejora
CYR.2.4.1 Datos, metadatos y lectura crítica
Conocer las aplicaciones actuales del Big Data, así como la naturaleza de los distintos tipos de datos y metadatos generados, siendo capaces de analizarlos, visualizarlos y compararlos, empleando a su vez un espíritu crítico y científico.
Evidencia. Informe, diccionario, limpieza documentada y visualización con denominadores.
| Banda | Desempeño observable |
|---|---|
| 1–2,9 | Las conclusiones no corresponden a los datos o se pierde su procedencia. |
| 3–4,9 | Presenta gráfico y porcentajes, pero omite metadatos, limpieza o límites de muestra. |
| 5–6,9 | Analiza, visualiza y compara datos y metadatos, conserva origen y limpieza y explica una aplicación y un límite del Big Data. |
| 7–8,9 | Contrasta resultados por clase y escala y revisa una conclusión que exageraba la diferencia. |
| 9–10,0 | Compara un conjunto nuevo o una fuente alternativa y argumenta qué resultados permanecen y cuáles no son generalizables. |
CYR.2.4.2 Modelo entrenado, evaluación y ética
Comprender los principios básicos de funcionamiento de los agentes inteligentes y de las técnicas de aprendizaje automático, con objeto de aplicarlos para la resolución de situaciones mediante la Inteligencia Artificial de forma ética y responsable.
Evidencia. Modelo, resultados por clase, mejora contrastada y condiciones de uso.
| Banda | Desempeño observable |
|---|---|
| 1–2,9 | No interpreta las predicciones ni distingue acierto de ejemplo ya usado para aprender. |
| 3–4,9 | Informa acierto global, pero no analiza clases ni reconoce una consecuencia del error. |
| 5–6,9 | Entrena y prueba con separación, tabula resultados por clase y explica dos límites y una condición de uso responsable. |
| 7–8,9 | Mejora datos o etiquetas y contrasta con nuevos casos conservando denominadores y errores. |
| 9–10,0 | Analiza qué tipo de error importa al destinatario y justifica uso, revisión humana o no utilización con los resultados disponibles. |
Videos, resources and sources
Tutorial LibreOffice Calc – 30/34 Gráficos (II): Diferentes tipos de gráfico y su personalización.
This optional video uses LibreOffice Calc. The chart concepts also apply to Sheets, but the menus are different. Complete this unit’s tasks in Google Sheets.
Watch in short sections. Connect one explanation with the diagram and try the example in this section. The written theory lets you complete the activity without playing the video.
The video keeps its original spoken language. Use the captions available in the player if they help.
Teachable Machine: tutorial en español
Watch in short sections. Connect one explanation with the diagram and try the example in this section. The written theory lets you complete the activity without playing the video.
The video keeps its original spoken language. Use the captions available in the player if they help.
Keep learning
- NIST CSRC: Big Data
- Google Docs Editors Help: Types of charts and graphs in Google Sheets
- Google for Developers: Datasets, dividing the original dataset
- Google for Developers: Classification, accuracy, recall, precision and related metrics
- Google Creative Lab: Teachable Machine Community
- AEPD e INCIBE: Guía de privacidad y seguridad en Internet
Editorial revision: October 2026.
