Week 10: Nov 12-16 

Modeling and databases- MS Excel 2016

Learning objectives:

Explore the components of a database:

  • Introduce the concept of tables, rows, and columns.
  • Explain the importance of data types and field constraints.
  • Discuss primary keys and their role in uniquely identifying records.

Understand conditional formatting in Excel:

  • Define conditional formatting and its purpose.
  • Explain the benefits of using conditional formatting in data analysis.
  • Identify conditional formatting rules like color scales, data bars, and icon sets.

Working with tables

Conditional Formatting

Create a drop-down list

Classroom activity