Computar end year exam

Chambridge Lower Secondary Stage 9

Data,

Data can be row facts or information

Functions used in Spreadsheets,

SUM

COUNT

MIN

MAX

AVERAGE

SUM function,

Adds a range of numbers together

MIN function

,find the smallest value in range

MAX function,

Finds the largest value in a range.

COUNT function,

Counts many cells contain number

Types of IF statements,

Simple IF

Nested IF

Simple IF,

one question

Nested if,

multiple questions

Count functions,

COUNT
COUNTA

COUNTIF

COUNTIFS

COUNTBLANK

COUNT,

counts all cells with numeric data/values

COUNTA,

Counts all non-empty cells.

COUNTIF,

counts the only only in one condition

COUNTIFS,

counts multiple conditions

COUNTBLANK,

counts the number of blank cells

Algorithm,

series of steps that solve a prob

3 main types of errors,

syntax

logic

run-time

Flat file database,

stores all data in a single table

Relational Database,

stores data in multiple related tables

Databases,

Used to store the data
flat-file

relational

Primary Key,

unique identifier

Foreign Key,

used to link 2 tables and it can be a primary key of another table

Data Redundancy,

data is repeating unesseserely in multiple places

Big Data,

refer to very large and complex data which are difficult to update and store

Characteristics of Big Data,

Volume,

Velocity,

Variety,

Veracity,

Value

Volume,

amount of data

variety,

types of data

Velocity

,speed of data

Verocity,

accuracy of data

Value,

uses of data

Network topology,

layout of network and it shows the way and the devices are designed and arranged in the network

Network topologie,

Bus

Star

Ring

Hybrid

Mesh

Tree

Bridge,

A network device which joins 2 segments in LAN

Examples of Protocols,

TCP

IP

HTTP

HTTPS

2 types of parity,

odd parity

even parity

The 3 main factors that the user should consider,

User experience

Accessibility

Ergonomics

User experience,

Refers to how a person feels when they are using the system

Accessibility,

Refers to the designing of the device and how easy to use

Egonomics,

about designing the equipment and work space to be comfortable and safe to use.

Emerging tech,

New developing tech

Examples for emerging tech:

Artificial inteligens

internet of things

non technology

Prototypes,

the early version of the product of the program

Examples for Prototypes,

visual prototypes

working prototypes

An array,

a collection of objects of the same data type

4 types of test data,

normal data

extreme data

Abnormal data

Boundary

Data pattern,

a repeated trend or arrangement found in data

MAC adress,

a unique adress used to identify a devise on a network

Client-server arcitecture,

a network where clients request services from a server

Explain fetch-decode-execute cycle,

the CPU fetch an instruction, decodes it and execute it.

3 tasks done by the operating system,

memory management

file management

device management

2 utility software,

antivirus software

backup software

Compiler,

translate the whole program at ones

Interpreter,

translate and run the program line by line

sample rate when recording sound in digital,

the number of sound samples taken each second during recording.