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
Apply Conditional Formatting
Create a drop-down list
Classroom activity