Y12 EC Data Science Wk5-6 Lesson

Open Ended

List the success criteria for using a spreadsheet as mentioned in the image.

Multiple Choice

What are the key functions of spreadsheets and databases in data management?

• Collate data

• Organise data

• Process data

• Present data

Multiple Choice

What is the purpose of collating information using spreadsheet analysis features?

• To create charts

• To analyze data

• To perform statistical analysis

• To model scenarios

Multiple Choice

How can you apply conditional formatting to a range of cells?

• Use the `=IF` function

• Use the `=SUM` function

• Use the `Conditional Formatting` option in the toolbar

• Use the `Data Validation` option

Multiple Choice

What steps should you take to filter, group, and sort data in a spreadsheet?

• Open the spreadsheet

• Select the data

• Use the filter option

• Save the file

Multiple Select

What are the success criteria for this lesson?

• Using graphs effectively

• Using pivot tables and slicers

• Creating a data dashboard

• Applying spreadsheet features

Multiple Choice

What are the steps to apply spreadsheet analysis features to develop a data dashboard?

• Identify data sources

• Create visualizations

• Analyze trends

• All of the above

Multiple Choice

Which data manipulation command is used to combines the records from one or more tables?

• A.SELECT

• B.PROJECT

• C.JOIN

• D.PRODUCT

Multiple Choice

What are the primary keys and foreign keys in the relational database schema shown in the image?

• ID (P)

• Publisher_ID (P)

• Developer_ID (P)

• Release_date

Multiple Choice

What is the result of the following SQL query: `SELECT * FROM Employees WHERE Salary > 50000;`?

• It selects all employees with a salary less than £50,000

• It selects all employees with a salary greater than £50,000

• It selects all employees with a salary equal to £50,000

• It selects all employees regardless of salary

Multiple Choice

Which of the following can be used to summarise data in a report?

• Grouping

• Sorting

• Filtering

• All of the above

Poll

How confident do you feel about this topic now?

• Very confident
• Somewhat confident
• Not confident