Introduction to Online Collaboration, Spreadsheets, Networks, and Programming

These flashcards cover vocabulary related to online collaboration, cloud computing safety, spreadsheet basics, network operations, and foundational programming concepts.

Shared Work

A form of online collaboration where 2 or more people contribute to the same document, presentation, spreadsheet or project.

Communication (Online Collaboration)

How people exchange ideas through email, comments, messages and shared planning spaces.

Responsibility (Online Collaboration)

A key aspect of good collaboration that depends on clear language, sensible behaviour and respect for other people's work.

Store (Cloud Computing)

The ability for files to be saved online instead of only on one device.

Access (Cloud Computing)

The ability for work to be opened from different devices when there is a connection.

Share (Cloud Computing)

A feature allowing several users to view, comment on or edit the same live document.

Version history

A tool that is especially useful because it helps recover mistakes and shows how work has changed over time.

Cell

A single box in a spreadsheet where data or a formulas is entered.

Row

A horizontal line of cells in a spreadsheet, labelled with numbers.

Column

A vertical line of cells in a spreadsheet, labelled with letters.

Cell reference

The position of a cell, such as $\text{B4}$ or $\text{D7}$.

Formula

An equation typed into a spreadsheet to calculate a value, usually starting with an equals sign.

Function

A built-in formula that carries out a common job such as adding or averaging.

$$=\text{SUM}(\text{B2:B6})$$

A common spreadsheet function that adds values.

$$=\text{AVERAGE}(\text{B2:B6})$$

A common spreadsheet function that finds the mean.

$$=\text{MAX}(\text{B2:B6})$$

A common spreadsheet function that finds the highest value.

Client

A device on a network that requests files or services.

Server

A computer on a network that provides files or services.

Router

A device that directs data to the corrects destination.

Packet

A small chunk of data sent across a network.

Internet

The global system of connected networks and devices.

World Wibe Web

A service that uses the internet to access websites and web pages.

Algorithm

A step-by-step set of instructions for solving a problem.

Program

An algorithm written in a form that a computer can read.

Sequence

A programming term where instructions happen in order.

Selection

A programming term where a choice is made, often using if statements.

Iteration

A programming term where instructions repeat in a loop.

Variable

A named value that can change, such as score or lives.

Count controlled loop

A type of loop used when the number of repeats is known, such as saying "Welcome" $3$ times.

Condition controlled loop

A type of loop used when the program should continue until something becomes true, such as repeating until the correct answer is given.