Classroom Content

ICT

Quiz Test conducted based upon ICT

---

Test

ICT Skills Test

---

Test

Adding of 10 Numbers

Dear Students Type Any Ten Numbers And With The Help Of Formula Add Them and Share The Screenshot. Go through My Tutorials, that Will Help You.

---

Assignment

Formatting Assignment in Open Office Calc

Dear Students please Make the same table and find the total by using formula. Use the same formatting and for that you can take help of shared videos in study material folder.

---

Assignment

Making table of 17 And 23

Dear Students Make A table Of 23 and 17 by using Formulas and Send Your Screenshots. Check All the Tutorials Either On My Youtube Channel Or On Study Material of Teachmint https://youtu.be/PVWw8gGrpoI

---

Assignment

Using Formulas on Text

Dear Students I have Already Shared You the tutorial Based Upon Using Text Formulas In Your Study Material, Please Go through That Formula and Share The Screenshot . Although That Tutorial Is Made In Ms Excel But Working Is Same For Open Office Calc Also. Hey Please check out my Study Material: Using Formula on text for classroom.

---

Assignment

Calculating Percentage of the Students

Dear Students please use the same Values as shown in attached screenshot. Also use the same formatting

---

Assignment

Calculating Grades & Percentage

Create the Percentage, Grades, Maximum , Minimum, Average. Please See the Values Itself From Tutorial By Pausing It.

---

Assignment

Using Filters In open office Calc

Dear Students I have Already Shared Tutorial Based Upon Filtering Of All Three Types . Please Share The Screenshots Showing All Types Of Filter. You can Use The Values WHAT I have Used In My Tutorial.

---

Assignment

Multiple Choice Questions

Dear Students In Exams You many not get the Options as shown here.

---

Test

Calculating Salary

Dear Students I have Already Shared You the Tutorial for finding The salary. Please Upload The Screenshots Showing the Calculations. Use the same Values which I have used

---

Assignment

Types of Cell Reference

Dear Students Please Go through The Tutorial Based Upon Types of Cell Reference. Share the Screenshots Showing All' three Kinds Of Reference.

---

Assignment

Consolidate Data

Consolidate Data In Open Office Calc With Sum, Count And Average (Based Upon the Marks of the Students. )

---

Assignment

Consolidate Data Ass 2

Consolidate Data Of R&R company

---

Assignment

Finding Subtotals of Company

Subtotals In Open Office Calc. Use 1.Sum Function Based Upon Company. 2. Group By Product - Calculate Sum. 3. Find Max Sales Product Wise.

---

Assignment

Finding Subtotals Based upon Staff

1.Finding Subtotals In Open Office Calc ( Ass- 2)Based Upon Designation(Use Sum). 2. Use 2 groups to Find Max Salary

---

Assignment

Subtotals Based upon Class

1. Finding Subtotals Based Upon Students of Different Classes Living at Different Places. Use Sum And Count. (Send Screenshots Of All Kinds Of Grouping)

---

Assignment

What if scenarios 2nd Assignment

Using What If Scenarios based Upon Marks (First term, Half Yearly etc)

---

Assignment

What if Scenarios Assign 1

Using What If Scenarios Assign 1 Based Upon Finding Interest

---

Assignment

Using GOAL Seek Assign 1

Using Goal Seek Assignment Based Upon Calculating Interest

---

Assignment

Using Goal Seek Assign 2

Using Goal Seek Assign 2 Based Upon Finding Percentage

---

Assignment

Using Goal Seek ( Assign 3)

Using Goal Seek Assignment Based Upon Salary

---

Assignment

Link Data and worksheet Part 1

Dear Students Share The screenshots Showing Inserting Of Any Worksheet from Any Other Spreadsheet

---

Assignment

Creating References With Mouse & Keyboard

Link Data And Worksheet Part 2 ( Share The Screenshots Showing The Reference with Help of Mouse And Keyboard. Show The Screenshot With Formula

---

Assignment

Working With Hyperlinks Assignment 1

Working With Hyperlinks In Open Office Calc. Dear Students pls Go Through The Tutorial And Share the Screenshots showing the process of creating the hyperlink which takes you to google directly after clicking on hypertext.

---

Assignment

Working with hyperlinks Part 2

Working With Hyperlinks In Open Office Calc. Dear Students pls Go Through The Tutorial And Share the Screenshots showing the process of creating the hyperlink which takes you to another File directly after clicking on hypertext.

---

Assignment

Showing Relative hyperlink

Showing Relative Hyperlink. Pls Share The Screenshots

---

Assignment

Absolute Hyperlink

Show Absolute Hyperlink With Attached Screenshots

---

Assignment

Linking to External Data Showing website

Linking To External Data in Open Office Calc. Dear Students Link Cbse Website As Shown In Tutorial And Share the Screenshot .

---

Assignment

Linking to external data From Another Spreadsheet

Linking To External Data From Another Spreadsheet

---

Assignment

Linking to Registered Data Source

Linking to Registered Data Source

---

Assignment

Sharing Spreadsheet in Open Office Calc

Sharing Spreadsheet in Open Office Calc. Share your screenshots to support that you have Understood the topic. Practice This Topic So whole concept should Be clear to you

---

Assignment

Opening Spreadsheet in Open Office Calc

How to Open Spreadsheet in Open Office Calc

---

Assignment

How to Record Changes In Spreadsheet Calc

How to Record Changes In Spreadsheet Calc. Share the Pdf Files

---

Assignment

Merging Worksheets In Open Office Calc.

Merging Worksheets In Open Office Calc. Share The Screenshots.

---

Assignment

Comparing Documents in Open Office Calc

Comparing Documents in Open Office Calc

---

Assignment

Using Macro For Adding The Numbers

Using Macro For Adding The Numbers. Dear Students Pls Go through the tutorial And Add The Numbers Using Macro

---

Assignment

Macro for formatting

Using Macro For Formatting.Dear Students Pls Go through the tutorial and Share The Screenshots

---

Assignment

Print Your NAME USING Macro as function.

Macro as Function. ( Dear students Share The screenshots Showing The use Of Macro As Function where Your Name Should Be printed

---

Assignment

Adding two Numbers using macro

Macro as Function. ( Dear students Share The screenshots Showing The use Of Macro As Function where Two Number's Should Be Added.

---

Assignment

---

Study Material

---

Study Material

---

Study Material

Spreadsheet Basics

Open Office Calc Basics

---

Study Material

Spreadsheet Formatting

How to Do Basic Formatting In Open Office Calc

---

Study Material

Calc Basic Calculations

Spreadsheet Basic Calculations (I T skill Course 402)

---

Study Material

Basic & Compound Formula

Although This Tutorial I Have Explained In Excel But Working Is Same In Both Excel & Open Off Cal

---

Study Material

Using Formula on text

How to Use Text Formulas & use of Concatenation. Tutorial Made For Excel But Will Work For OpenOff

---

Study Material

Calculating Percentage

Tutorial Made In Excel But Concept Is Same for Open Office Calc

---

Study Material

How to put Grades With if

How to Use Grades While Calculating % Of Students using If Statement.Use Max, Min and Average also

---

Study Material

Using Sorting & Format

Using Sorting & Conditional Formatting

---

Study Material

Filters in Spreadshteets

How To Use Three Different Types Of Filters In Open Office Calc

---

Study Material

Making Salary Statement

Formulas Used For Calculating Salary of Employees

---

Study Material

Different Cell Reference

How To Use Different Cell Reference In Spreadsheet (IT Skill Course 402)

---

Study Material

ICT Skills Class 10

Solved Answers And MCQ

---

Study Material

I.T Class X Documentation

Solved Answers And MCQ Based Upon Digital Documentation

---

Study Material

Consolidating On Data

Consolidating Data On OpenOffice Calc I.T Skill Course 402 Class Xth

---

Study Material

Using Subtotals

Finding Subtotals in Open Office Calc

---

Study Material

What If Scenarios

Using What If Scenarios in Open Office Calc

---

Study Material

Goal Seek In Calc

How To Use Goal Seek in Open Office Calc

---

Study Material

Link Data & Worksheet (1)

How to Link Data And Worksheet (Part 1)

---

Study Material

Referencing Other Sheets

How to Create Reference With Other Sheet In Open Office Calc

---

Study Material

Working with hyperlinks

---

Study Material

Types of hyperlinks

---

Study Material

Linking To External Data

---

Study Material