Year 7 Computer Science Comprehensive Revision Notes

Online Safety, Digital Footprints, and Personal Data

Online safety is a fundamental aspect of digital literacy, encompassing the management of one's digital presence and the protection of sensitive information. A digital footprint refers to the comprehensive trail of data left by an individual while using the internet. This includes a record of every website visited, along with the specific activities, games, and interactions performed online. Because these footprints are often permanent and searchable, understanding their impact is crucial for maintaining a positive online reputation.

Personal data consists of any information that can identify a specific individual. It is essential to protect this data to ensure privacy and security. Primary examples of personal data include an individual's full name, their birthday or date of birth, their physical home address, and their personal phone number. Sharing such details indiscriminately can lead to privacy breaches or identity theft, making it vital for users to understand what constitutes personal information and where it is being shared.

Electronic Mail Features and Communication Protocols

Email, which stands for Electronic Mail, is a digital communication method used to send messages over the internet. It functions similarly to traditional physical mail, such as writing a letter and posting it, but allows for the near-instantaneous transmission of messages via computers, tablets, or smartphones. Beyond simple message sending, email systems include specific protocols for managing recipients to ensure information is shared appropriately.

Carbon Copy, or CC, is a feature used to send a copy of an email to additional recipients to keep them informed about a topic. When using CC, every person who receives the email can see the names and addresses of everyone else who was CC’d. In contrast, Blind Carbon Copy, or BCC, is used to send copies secretly. When an address is placed in the BCC field, other recipients are unable to see that person's address or know they received the message. This feature is particularly useful when sending an email to a large group of people while wishing to maintain the privacy of individual email addresses.

Understanding Malware and Systems Security

Malware, a term derived from the phrase "malicious software," refers to any computer program specifically designed to cause harm, steal data, or create functional problems within a computer system. There are several distinct types of malware, each characterized by its method of infection and behavior. A computer virus is a type of bad software designed to spread from one computer to another, typically causing damage to files or systems in the process.

A computer worm is a specific variety of malware that distinguishes itself by its ability to self-replicate and spread across computers and networks without requiring any human interaction or help. A Trojan Horse, often simply called a "Trojan," is a deceptive program that masquerades as something safe or useful, such as a video game or a legitimate file, while hiding harmful components within its code. Finally, spyware is a type of malware used to monitor and record a user's computer activities without their knowledge. This software watches user actions and transmits that collected information to a third party.

Fundamentals of Spreadsheet Software and Data Organization

Spreadsheets are specialized computer programs, such as Microsoft Excel or Google Sheets, designed for the organization, calculation, and display of information. The layout of a spreadsheet resembles a large table consisting of vertical columns and horizontal rows. The point where a row and a column intersect is defined as a cell. Users can input various types of information into these cells, including numbers, words, or mathematical formulas.

A formula is a specific set of instructions provided to the spreadsheet to perform automatic calculations. These can range from simple arithmetic, such as addition, subtraction, multiplication, and division, to more complex mathematical operations. For example, a user can write a formula in a cell as $=10+5$, and the software will automatically display the result of $15$. Formulas are dynamic tools that allow for efficient data processing across large datasets.

Advanced Spreadsheet Functions and Cell Referencing

Functions are built-in automated tools within spreadsheet software that allow users to perform calculations without having to manually construct complex formulas. These functions provide a simplified way to analyze groups of data. The $MAX$ function is used to identify the largest numerical value within a specified range. For instance, if cells $A1$ through $A4$ contain the values $3$, $7$, $12$, and $5$, the function $=MAX(A1:A4)$ will return the result of $12$. Conversely, the $MIN$ function identifies the smallest number in a group; using the same dataset, $=MIN(A1:A4)$ would return $3$.

The $AVERAGE$ function calculates the arithmetic mean of a range of numbers by summing all the values and dividing that total by the count of the numbers. In the example range of $3$, $7$, $12$, and $5$, the function $=AVERAGE(A1:A4)$ yields a result of $6.75$. The $SUM$ function is used to add all numbers in a specific range together. For the values in cells $A1:A4$, the function $=SUM(A1:A4)$ results in a total of $27$. Additionally, spreadsheets utilize relative cell referencing, which is a method of referring to a cell that allows the reference to change automatically when a formula is copied or moved to a different location in the grid.

Block-Based Programming in Scratch

Scratch is a visual, block-based programming language designed to teach coding concepts in an accessible and engaging manner. Rather than requiring users to write out lines of text-based code, Scratch utilizes interlocking blocks that can be dragged and snapped together to build programs. This method simplifies the logic of coding for beginners while allowing for the creation of complex interactive projects and animations.

The programming environment is organized into several categories of blocks, each serving a unique function. Motion Blocks are used to control the movement of "sprites" (objects or characters) on the screen; for example, the block $\text{move } 10 \text{ steps}$ shifts the sprite forward by that amount. Looks Blocks manage the visual appearance of sprites, including changing their costumes or displaying speech bubbles. A block like $\text{say Hello for } 2 \text{ seconds}$ will cause the sprite to appear as if it is speaking. Sound Blocks control audio elements, allowing users to play specific sounds, such as $\text{play sound meow until done}$, or adjust the volume within the project.

Logical Control and Interactive Blocks in Scratch

Programs in Scratch are driven by Events Blocks, which determine the triggers for actions. A common example is the $\text{when green flag clicked}$ block, which initializes the program. Control Blocks dictate the logical flow of the code, allowing for repeating actions or decision-making processes. For instance, a $\text{repeat } 10$ block will execute any code nested within it exactly $10$ times. Sensing Blocks allow sprites to interact with their environment by checking for specific conditions, such as $\text{touching [mouse-pointer]?}$, which returns a response if the sprite is in contact with the cursor.

Mathematical and data operations are handled by Operators Blocks and Variables Blocks. Operators Blocks perform tasks such as addition, subtraction, or string manipulation, such as the $\text{join [Hello] [world]}$ block which creates the combined phrase $\text{"Hello world"}$. Variables Blocks are essential for storing and updating information that changes over time, such as in the block $\text{set [score] to } 0$, which initializes a game's scoring system. Finally, Pen Blocks allow sprites to function as drawing tools. With the $\text{pen down}$ block, a sprite will leave a trail on the screen as it moves, enabling the creation of geometric art and patterns.

Computer Systems: Input and Output Devices

Computer systems rely on hardware components categorized by their role in handling data. Input devices are hardware used to enter data or instructions into the system. Keyboards allow for the input of text, numbers, and commands, while a mouse is used to control an on-screen pointer for selecting items. Other input devices include microphones for audio data and voice recording, scanners for converting physical paper documents into digital formats, and webcams for capturing and transmitting images or video.

Output devices are hardware components that present processed data from the computer back to the user in a human-readable form. Monitors are the most common output device, displaying visuals like text, images, and video. Printers produce physical hard copies of digital documents. Audio output is handled by speakers or headphones, which allow for private listening and sound reproduction. For large-scale visual presentations, a projector can be used to display computer visuals onto a large external screen.

Computer Systems: Storage and Processing Hardware

Storage devices are critical hardware used to retain data and software programs for future access. Different types of storage offer various balances of speed and capacity. A Hard Disk Drive (HDD) provides a large storage capacity suitable for operating systems and large files. A Solid State Drive (SSD) is a faster alternative to an HDD because it contains no moving parts. Portable storage options include USB Flash Drives and Memory Cards (such as SD cards commonly used in phones and cameras). Additionally, Cloud Storage services like Google Drive allow users to store information on remote servers over the internet rather than on local physical hardware.

The processing device is the core component that executes instructions and processes data to create output. The primary processing hardware is the Central Processing Unit, or CPU. In computer science, the CPU is frequently referred to as the "brain of the computer" because it is responsible for controlling all operations and performing the actual processing of data within the system.