In this article we providing information regarding latest Navodaya Class 7 Computer Subject August Month Notes 2026.
Navodaya Class 7 Computer Subject August Month Notes 2026
August – 2026 : NVS Class 7 Computer Science Syllabus
- Spreadsheets (MS Excel/Google Sheets/Libre Office Calc):
- a)Introduction workbook & Worksheet use in day-to-day life.
- b)Steps to start Spreadsheets
- c)Components of the Spreadsheets screen
- d)Various data types
- e)Cell reference
- f)Functions
- g)Sorting of Data
- h)Filtering Data
- i)Conditional Formatting
- Working with presentations( MS PowerPoint/Google Slides/Libre Office Impress)
- a)What are presentations?
- b)Insert a new slide.
- c)Insert an image.
- d)Word art.
- e)Audio and video.
- f)Transitions in the slide.
Part A: Spreadsheets
(MS Excel / Google Sheets / LibreOffice Calc)
1. Introduction to Workbook and Worksheet
A Spreadsheet is a software used to organize, calculate, and analyze data.
Workbook
A workbook is a file that contains one or more worksheets.
Worksheet
A worksheet is a single page inside a workbook made up of rows and columns.
Uses in Daily Life
✔ Preparing marksheets
✔ Attendance records
✔ Household budgets
✔ Shopping lists
✔ Salary calculations
Example: An Excel file named “Student Marks.xlsx” is a Workbook, while “Class 7 Marks” is a Worksheet.
2. Steps to Start a Spreadsheet
In MS Excel
- Click Start Menu.
- Open Microsoft Excel.
- Choose Blank Workbook.
In Google Sheets
- Open a web browser.
- Visit Google Sheets.
- Click Blank Spreadsheet.
In LibreOffice Calc
- Open LibreOffice.
- Click Calc.
3. Components of the Spreadsheet Screen
Important Parts
| Component | Function |
|---|---|
| Title Bar | Shows workbook name |
| Ribbon/Menu Bar | Contains commands |
| Rows | Horizontal lines (1,2,3…) |
| Columns | Vertical lines (A,B,C…) |
| Cell | Intersection of row and column |
| Formula Bar | Shows data or formulas |
| Worksheet Tabs | Switch between sheets |
Example
Cell A1 = Column A + Row 1
4. Various Data Types
Different kinds of data can be entered in a spreadsheet.
a) Text (Label)
Contains words.
Example: Rahul, School
b) Number (Value)
Contains numbers.
Example: 25, 100, 500
c) Date
Stores dates.
Example: 15/08/2026
d) Formula
Performs calculations.
Example: =A1+B1
5. Cell Reference
The address of a cell is called a Cell Reference.
Examples
- A1
- B5
- C10
Use
Cell references are used in formulas.
Example:
=A1+B1
Adds the values stored in cells A1 and B1.
6. Functions
Functions are predefined formulas used for calculations.
Common Functions
| Function | Purpose |
|---|---|
| SUM() | Adds numbers |
| AVERAGE() | Finds average |
| MAX() | Finds largest value |
| MIN() | Finds smallest value |
| COUNT() | Counts cells containing numbers |
Examples
SUM
=SUM(A1:A5)
AVERAGE
=AVERAGE(A1:A5)
7. Sorting of Data
Sorting arranges data in a specific order.
Types
Ascending Order
A to Z or Smallest to Largest
Descending Order
Z to A or Largest to Smallest
Example
Before Sorting:
- Ravi
- Amit
- Kiran
After Ascending Sorting:
- Amit
- Kiran
- Ravi
8. Filtering Data
Filtering shows only selected information and hides the rest.
Example
A class list contains students from different houses.
Using Filter, we can display only:
- Red House students
or - Blue House students
Benefit
Makes large data easy to view.
9. Conditional Formatting
Conditional Formatting changes the appearance of cells automatically based on conditions.
Examples
✔ Marks above 80 → Green color
✔ Marks below 35 → Red color
Uses
- Highlight toppers
- Identify low scores
- Analyze data quickly
Part B: Working with Presentations
(MS PowerPoint / Google Slides / LibreOffice Impress)
1. What are Presentations?
A Presentation is a collection of slides used to present information visually.
Uses
✔ Classroom teaching
✔ Projects
✔ Seminars
✔ Business meetings
Example
A presentation on “Environment Protection” may contain several slides with text and pictures.
2. Insert a New Slide
Steps
- Open PowerPoint/Slides.
- Click Home.
- Click New Slide.
Use
Adding new topics or information.
3. Insert an Image
Pictures make presentations attractive and easy to understand.
Steps
- Click Insert.
- Select Pictures/Image.
- Choose image.
- Click Insert.
Uses
✔ Educational presentations
✔ Science projects
✔ School activities
4. WordArt
WordArt is decorative text used to make titles attractive.
Steps
- Click Insert.
- Select WordArt.
- Choose a style.
- Type text.
Example
“Science Exhibition 2026”
can be displayed in colorful artistic text.
5. Audio and Video
Multimedia elements make presentations more interesting.
Audio
Used for music, narration, or voice recording.
Video
Used for demonstrations and explanations.
Steps
- Click Insert.
- Select Audio or Video.
- Choose file.
- Insert it into the slide.
6. Transitions in Slides
A Transition is a visual effect that appears when moving from one slide to another.
Examples
- Fade
- Push
- Wipe
- Split
Benefits
✔ Makes presentation attractive
✔ Improves audience interest
✔ Gives a professional look
Quick Revision
| Topic | Key Point |
|---|---|
| Workbook | Spreadsheet file |
| Worksheet | Page inside workbook |
| Cell | Intersection of row and column |
| Cell Reference | Address of a cell |
| Function | Predefined formula |
| Sorting | Arrange data in order |
| Filtering | Show selected data only |
| Conditional Formatting | Highlight data automatically |
| Presentation | Collection of slides |
| New Slide | Add another slide |
| Image | Makes slides attractive |
| WordArt | Decorative text |
| Audio/Video | Multimedia content |
| Transition | Effect between slides |
One-Line Summary
Spreadsheets help us organize and calculate data, while presentations help us share information effectively using slides, images, audio, video, and attractive effects.
Thanks to Beloved Readers.
