Computer Science

facility that houses servers, storage systems and networking equipment to store, process and distribute data

energy that comes from natural sources that are constantly replenished and will not run out

The environmental impact of data systems

Database fundamentals

Database design

SQL fundamentals

SQL searches

Data management with SQL statements

Data protection, copyright and the law

Data and privacy

Big data

This unit introduces pupils to databases and SQL, they will explore the key terms used in a database and why relational databases are used to eliminate the redundancy that can occur in a flat file database. They will explore SQL commands to retrieve, update, and delete data in a relational database.

Databases and SQL

Data centres use electricity, often from fossil fuels.

Electricity use leads to greenhouse gas emissions.

Put these in order for understanding the environmental impact of cloud storage:

What are large facilities called that store, process, and manage vast amounts of digital information for organisations?

equipment to keep servers from overheating

release of gases that contribute to climate change

Put these steps in order for making a data centre more sustainable:

energy from sources that are constantly replenished

Which of the following is an environmental impact of data centres?

It is too large and arrives too quickly for older systems.

What is one reason big data is difficult to process using traditional computers?

the different types and formats of data collected

Which of these best describes the term “variety” in big data?

Cloud systems can scale up to handle very large and complex data sets.

Why do organisations often use cloud storage for big data?

Put these in order for handling big data:

Match the example to the big data characteristic:

This lesson was made for home learning during the pandemic.

The environmental impact of data systems

Lesson outcome

This lesson was made for home learning during the pandemic.