LESSON 1:     

TOPIC: DEFINITION OF SPREADSHEET SOFTWARE AND SAMPLE APPLICATIONS TO USE

For this lesson, students are expected to:

1. Define spreadsheet software, identifying key features such as cells, rows, columns, formulas, and functions.

2. Evaluate the effectiveness of different spreadsheet applications in managing data, considering factors such as ease of use, functionality, and compatibility with other software.  

3. Appreciate the value of spreadsheet software in solving real-world problems, such as financial planning, data analysis, and project management. 

LESSON 2:     

TOPIC: INTRODUCTION TO MICROSOFT EXCEL 365

1.  Define Microsoft Excel, identifying its primary functions, including data entry, calculations, and data visualization.

2.  Explain the basic layout of Microsoft Excel, including the purpose of the ribbon, workbooks, worksheets, cells, and ranges.

3.  Show interest in learning about Microsoft Excel, recognizing its importance in both personal and professional settings for data management and analysis.

LESSON 3:     

TOPIC:   NAVIGATING MICROSOFT EXCEL

For this lesson, Students are expected to:

1. Identify and select the appropriate Excel tools and commands to perform tasks such as data entry, formatting, and calculation. 

2. Set up their Excel workspace by organizing sheets, defining cell ranges, and customizing the ribbon to suit their workflow needs 

3. Appreciate the value of Excel as a versatile tool for handling various types of data, from simple lists to complex financial models 

LESSON 4:     

TOPIC: DATABASE MANAGEMENT SYSTEM: DEFINITION, SAMPLES AND BENEFITS

For this lesson, students are expected to:

1.  Define key terms related to database management systems.

2. Explain the basic concepts and components of a database management system, including how data is stored, retrieved, and manipulated within a DBMS

3.   Appreciate the role of databases in various industries.

LESSON 5:     

TOPIC:  INTREGRATING SPREADSHEET AND DATABASE

1. Name the key concepts of spreadsheet and database integration, including the roles of Excel and a Database Management System 

2. Explain the benefits and challenges of integrating spreadsheets with databases, such as improved data accuracy, scalability, and the need for data consistency. 

3. Appreciate the importance of maintaining data consistency and integrity when integrating spreadsheets with databases

LESSON 6:     

TOPIC:  INTRODUCTION TO MICROSOFT ACCESS

1. Identify the key components of Microsoft Access, including tables, queries, forms, reports, and macros.

2. Differentiate Microsoft Access Desktop Database with Access Web App.

3. Appreciate the importance of proper database design and the capabilities of Microsoft Access in managing    

          data for various applications, such as business and research.