Y7 W13 Unit 7.4 The power of Data : Using data modelling

Unit 7.4 The Power of Data: Using data modeling

Multiple Choice

what is the meaning of plaintext?

• Original, unencrypted data
• Random data
• Decrypted data
• Encrypted data

Learning Objective

• Able to explain what is data model

• Identify range of real life scenarios where data models and simulations are used.

• Describe how spreadsheet and database applications can be used to model real - life scenarios

Multiple Choice

what's the function of encryption?

• To convert information into a code for easy access.
• To share information without any security measures.
• To decrypt information for unauthorized access.
• To convert information into a code to prevent unauthorized access.

Data models, simulations

• Computer models are representations of real - life situations

• Data is used to represent real life situation

• Rules that link data are coded using formulae

Multiple Choice

what's the difference between caeser cipher and simple substitution cipher?

• Caesar cipher involves reversing letters, while simple substitution cipher involves shuffling letters.
• Caesar cipher involves rotating letters, while simple substitution cipher involves mirroring letters.
• Caesar cipher involves doubling letters, while simple substitution cipher involves removing letters.
• Caesar cipher involves shifting letters, while simple substitution cipher involves replacing letters.

Examples of using models

• We can decide cost to organize a birthday party

Play Video Data model

Multiple Choice

Example of encryption algorithm is

• MD5
• SHA-1
• Blowfish
• Caesar cipher

Multiple Choice

Following are reasons why errors can occur during sending messages except

• Power surges

• Broken or damaged cables

• electrical interference

• loud noises

Data models

• In database model, a table is used to model important data about situation.

• The data relating to the model is organized under field headings.

Multiple Choice

what is databases?

• Databases are physical containers for storing data
• Databases are organized collections of data, typically stored and accessed electronically from a computer system.
• Databases are only used for storing text files
• Databases are never accessed electronically

Examples of using models

• Image on the left shows part of a database used to represent a group of students who are entering a computer gaming competition.

Multiple Choice

what is image recognition?

• Image recognition is the process of identifying and detecting an object in an audio file.
• Image recognition is the process of identifying and detecting an object or feature in a digital image or video.
• Image recognition is the process of identifying and detecting an object in a physical image.
• Image recognition is the process of identifying and detecting an object in a written document.

Simulations

• Simulations are more complex model than those created using databases and spreadsheets.

• Simulations will often use complex graphics to help represent the real life situation they are modelling.

• Simulations allow the user to see a visual representation of a scenario for example a gaming simulation that the user can interact with.

Multiple Choice

what is data model?

• A data model is a conceptual representation of data objects, the associations between different data objects, and the rules that govern data integrity.
• A data model is a type of computer hardware.
• A data model is a software used to analyze data.
• A data model is a physical representation of data objects.

Usage of models and simulations

• Used in medicine and healthcare to collect a wide range of data about patients (patience's age, symptoms, current medications)

• Used in training of pilots with simulators that look and feel like a real aeroplane.

• Used in scientific experiments to help them make predictions such as how changing temperature might effect a nuclear reaction.

• Used in weather and climate to assess the impact of climate change in weather patterns

• Used in business to identify patterns in sales of items at different times of the year

Multiple Choice

use case of data model?

• To create visual representations of data
• To analyze data trends
• To optimize data storage
• To define the structure and relationships of data within a system.

Pros and Cons of Simulations

Multiple Choice

what is simulation?

• Simulation is the elimination of real-world processes or systems.
• Simulation is the duplication of a real-world process or system instantly.
• Simulation is the imitation of the operation of a real-world process or system over time.
• Simulation is the exaggeration of a real-world process or system.

Multiple Choice

what's the cell reference?

• D3

• C3

• S1

• A1

Lets practice data model using spreadsheet

• Please create this spreadsheet.

• Please make sure to include SUM and AVERAGE

• Test 1, Test 2 and Test 3 have number format and set to 0 decimal

• Make sure to bold each labels and use your favourite fonts

Multiple Choice

what is pros of using simulations?

• Simulations provide safe experimentation, aid in understanding complex systems, offer a controlled training environment, and can predict outcomes.
• Simulations do not offer a realistic training environment
• Simulations are costly and time-consuming
• Simulations hinder progress by providing inaccurate results

Keywords in Excel/ Spreadsheet

• Formulae

• Cells

• Cell reference

• Cell range

• Built - in functions

• Factors

• Label

• Fill handle

• Relative cell reference

• Absolute cell reference

Multiple Choice

What's the name of this?

• feel handle

• fill handle

• cell referencing

• call referencing

Multiple Choice

Whats the name of this?

• formula 1

• cell range

• equation

• selection

Multiple Choice

What is this called?

• label

• formulae

• summary

• cell reference

Lets practice data model using spreadsheet

• Please create this spreadsheet.

• Please make sure to include SUM and AVERAGE

• Test 1, Test 2 and Test 3 have number format and set to 0 decimal

• Make sure to bold each labels and use your favourite fonts

Using formulae (Average/SUM)

• Enter '=' on the cell F2

• Type 'Average(' or 'SUM('

• Click on cell C2 and then hold shift while pressing right button to include test 2 and 3.

• once all three cells are selected, press ')' to close the formulae

• Press enter to execute the formulae

Multiple Choice

What's the cell reference?

• D9

• E8

• D8

• D7