Course Content
Theme 01: Operating Systems
0/2
Operating Systems – Part 1
00:00
Operating Systems – Part 2
00:00
Theme 02: Working in Microsoft Excel
0/3
Inserting, renaming and deleting a worksheet
00:00
Selecting and naming a cell range and applying a formula
00:00
Differentiating between various types of cell references
00:00
Theme 03: Functions and charts in Microsoft Excel
0/1
Functions and charts in Microsoft Excel
00:00
Theme 04: Algorithms and Flowcharts
0/1
Algorithms and Flowcharts
00:00
Theme 05: An introduction To Programming in Java
0/1
Programming need and importance
00:00
Theme 06: Introduction to apps.
0/1
Introduction to apps.
00:00
Theme 07: Developing an App
0/1
Developing an App
00:00
Theme 08: Networks
0/5
Components of a network
00:00
Types of networks
00:00
Network hardware and models
00:00
Structure of a network
00:00
Terms related to the Internet
00:00
Theme 09: More on computer networks.
0/2
Network protocols
00:00
Characteristics and advantages of cloud computing
00:00
Computer – 8
About Lesson

Course Summary for Theme 02: Working in Microsoft Excel

In the Class 8 Computer Course, Theme 02 focuses on working with Microsoft Excel, with a particular emphasis on the following key concepts:

1. Selecting and Naming a Cell Range: Students will learn how to effectively select a range of cells within an Excel spreadsheet. This involves understanding the various methods for selecting cells, including clicking and dragging, using keyboard shortcuts, and employing the Shift key. Furthermore, students will discover the importance of selecting specific cell ranges for data manipulation and analysis.

2. Applying Formulas: This theme also covers the fundamental skill of applying formulas in Excel. Students will become proficient in creating mathematical expressions and logical operations within cells to perform calculations. They will learn how to use operators such as addition (+), subtraction (-), multiplication (*), and division (/) to create basic formulas. Additionally, they will explore Excel’s built-in functions like SUM, AVERAGE, and IF to perform more complex calculations.

By the end of Theme 02, students will have a solid understanding of selecting cell ranges and using formulas in Microsoft Excel. These skills are essential for data management, analysis, and reporting, and will serve as a strong foundation for their computer proficiency.

Previous
Next