Course Content
Chapter 1: Introduction to Computer
This chapter introduces the basic concept of computers and modern IT gadgets. Learners will understand the evolution, applications, and types of hardware and software. It builds a strong foundation for further computer learning and digital skills.
0/6
Lesson 1.1: Understanding Computers – The Basics
Lesson 1.2: Evolution of Computers and IT Gadgets
Lesson 1.3: Applications of Computers and Gadgets
Lesson 1.4: Computer Hardware
Lesson 1.5: Software Types
Practice Questions (Write in Notebook)
Chapter 2: Introduction to Operating System
This chapter explained the basic concepts of operating systems for both desktop and mobile devices. Learners understood how operating systems manage hardware and software, and how users interact with computers through the user interface. The chapter also covered system settings, file and folder management, printer setup, and common file extensions. These skills are important for operating a computer smoothly and performing daily tasks efficiently.
0/7
Lesson 2.1: Basics of Operating Systems (Desktop and Mobile)
Lesson 2.2: Desktop Interface (Taskbar, Icons, Applications)
Lesson 2.3: System Settings (Mouse, Date/Time, Display)
Lesson 2.4: Add/Remove Programs & Printers
Lesson 2.5: File and Folder Management
Lesson 2.6: File Extensions
Practice Questions (Write in Notebook)
Chapter 3: Word Processing
This chapter introduced learners to the basics of word processing using popular software like Microsoft Word and LibreOffice Writer. It covered how to create, save, edit, format, and print documents. Students learned essential text editing tools such as copy-paste, alignment, font styling, spell check, and find-replace. The chapter also explained how to insert and format tables, add headers and footers, and use features like AutoCorrect and Mail Merge. These skills help in preparing professional documents for personal, academic, or office use.
0/8
Lesson 3.1: Introduction to Word Processors
Lesson 3.2: Creating and Managing Documents
Lesson 3.3: Editing and Formatting Text
Lesson 3.4: Paragraph and Document Formatting
Lesson 3.5: Table Creation and Manipulation
Lesson 3.6: Mail Merge
Lesson 3.7: Shortcut Keys and PDF Export
Practice Questions (Write in Notebook)
Chapter 4: Spreadsheet
In this chapter, you learned the basic concepts and usage of spreadsheet software such as Microsoft Excel, LibreOffice Calc, and Google Sheets. You explored how spreadsheets are structured using rows, columns, and cells, and how to enter and manage data effectively. The chapter covered: Basic spreadsheet layout and cell operations Editing and formatting of cells for better presentation Tools like sorting, filtering, autofill, and freezing panes to manage large data sets Use of basic formulas and built-in functions for calculations Creating visual data representations using charts (bar, pie, line) These skills are essential for handling data in offices, academic tasks, business records, and personal budgeting.
0/6
Lesson 4.1: Spreadsheet Basics and Cell Operations
Lesson 4.2: Editing and Formatting Cells
Lesson 4.3: Sorting, Filtering, Autofill, Freezing Panes
Lesson 4.4: Basic Formulas and Functions
Lesson 4.5: Creating Charts (Bar, Pie, Line)
Practice Questions (Write in Notebook)
Chapter 5: Presentation
This chapter introduces learners to presentation software, which is used to create slideshows for displaying information visually. Presentations are useful for teaching, training, business meetings, and sharing ideas. You learned how to: Create, open, and save presentations Add and manage slides Insert text, images, shapes, and charts Apply slide layouts, background styles, and design themes Add transitions and animations to slides Use slideshow view to present your content Save or export presentations in different formats (like PDF or video) With presentation tools like Microsoft PowerPoint, LibreOffice Impress, and Google Slides, users can make their ideas more attractive and easier to understand.
0/6
Lesson 5.1: Creating a Presentation (Template & Blank)
Lesson 5.2: Inserting Slides and Text
Lesson 5.3: Slide Manipulation and Objects
Lesson 5.4: Master Slide and Slide Show Setup
Lesson 5.5: Aesthetics and Printing Handouts
Practice Questions (Write in Notebook)
Chapter 6: Introduction to Internet and WWW
This chapter introduces learners to the basics of computer networks and the Internet. You learned how computers are connected using networks like LAN and WAN, and how the World Wide Web (WWW) helps in sharing information globally. The chapter also covered: Internet-related terms like IP address, ISP, and connectivity methods Use of web browsers for accessing websites How to browse, search, download, and print web content Safe and efficient use of internet tools in daily life These skills are essential for communicating, learning, and working in today’s digital world.
0/6
Lesson 6.1: Basics of Networks (LAN, WAN, Topologies)
Lesson 6.2: Understanding Internet and Web Browsers
Lesson 6.3: IP Address, ISP, Connectivity Modes
Lesson 6.4: Web Browsing and Searching
Lesson 6.5: Downloading and Printing Web Pages
Practice Questions (Write in Notebook)
Chapter 7: Email, Social Media and eGovernance
In this chapter, you learned about essential digital communication tools and online citizen services. You explored: How to create, send, and receive emails, and use features like CC, BCC, attachments, and signature Common social media platforms such as Facebook, WhatsApp, and LinkedIn — their uses and safety tips Importance of e-Governance, and how government services are available online through portals like Aadhar, Income Tax, Digilocker, and Parivahan You also learned how digital tools help save time, increase transparency, and improve communication between citizens and the government. Digital communication and e-governance are essential skills for participating in today’s digital society.
0/6
Lesson 7.1: Introduction to Email and Its Importance
Lesson 7.2: Creating, Sending, and Receiving Emails
Lesson 7.3: Email Features – CC, BCC, Attachments, Signature
Lesson 7.4: Introduction to Social Media Platforms
Lesson 7.5: eGovernance Services and Online Citizen Portals
Practice Questions (Write in Notebook)
Chapter 8: Digital Financial Tools and Applications
In this chapter, you learned how to make cashless and secure financial transactions using digital tools. You explored: UPI, BHIM App, and mobile wallets for daily payments How to use QR codes to pay at shops or send money The difference between Internet Banking and Mobile Banking, and how to use them safely Importance of cyber security in digital payments — how to protect yourself from fraud, phishing, and fake websites These tools make money transactions easy, fast, and safe — from your home, office, or mobile.
0/6
Lesson 8.1: Introduction to Digital Payments and UPI
Lesson 8.2: Mobile Wallets and Payment Apps
Lesson 8.3: Using BHIM App and QR Code Payments
Lesson 8.4: Internet Banking and Mobile Banking
Lesson 8.5: Cyber Security in Digital Transactions
Practice Questions (Write in Notebook)
Chapter 9: Overview of Future Skills and Cyber Security
This chapter introduced you to the future of digital skills and the importance of being a safe and responsible digital citizen. You learned about: Emerging technologies like Artificial Intelligence (AI), Cloud Computing, and Data Analytics — which are shaping the future The need for Cyber Hygiene — good habits to keep your digital life safe Various online threats like phishing, malware, fake news, and identity theft How to protect your personal data and privacy The role of the Indian government, cyber laws, and platforms like CERT-In and cybercrime.gov.in that help protect citizens
0/6
Lesson 9.1: Introduction to Future Skills (AI, Cloud, Data Analytics)
Lesson 9.2: Importance of Cyber Hygiene
Lesson 9.3: Safe Internet Practices and Online Threats
Lesson 9.4: Protecting Personal Data and Privacy
Lesson 9.5: Role of Government and Legal Measures in Cyber Security
Practice Questions (Write in Notebook)
Chapter 10: e-Governance Services
This chapter explained how the Indian government uses digital technology to offer fast, transparent, and efficient services to citizens. This is known as e-Governance. You learned about: The definition and purpose of e-Governance Four major types of e-Governance: G2C – Government to Citizen G2G – Government to Government G2B – Government to Business G2E – Government to Employee The Digital India Programme, launched in 2015 to make services digitally accessible Popular citizen services like UMANG, DigiLocker, Aadhaar portal, e-District Benefits of e-Governance such as speed, transparency, and cost-saving Challenges like lack of internet, low digital literacy, cyber security, etc.
0/6
Lesson 10.1: What is e-Governance?
Lesson 10.2: Types of e-Governance (G2C, G2G, G2B, G2E)
Lesson 10.3: Digital India Programme
Lesson 10.4: Common e-Governance Services for Citizens
Lesson 10.5: Benefits and Challenges of e-Governance
Practice Questions (Write in Notebook)
Final Practice Test – Check Your Readiness
0/1
Final Test (100 Questions)
Complete Computer Concepts Course

Lesson 4.4: Basic Formulas and Functions

Spreadsheets are powerful tools for calculations and data analysis. You can use formulas and functions to perform mathematical operations quickly and accurately.

➕ 1. What is a Formula?

A formula is an equation that performs calculations using cell values.

  • Every formula starts with an equal sign (=)

  • You can use operators like +, -, *, /

📌 Examples:

  • =A1 + B1 → Adds values in A1 and B1

  • =A2 * 10 → Multiplies A2 value by 10

📊 2. What is a Function?

A function is a predefined formula — easy to use and time-saving.

📌 Common Functions:

Function Purpose Example
SUM() Adds numbers =SUM(A1:A5)
AVERAGE() Calculates average =AVERAGE(B1:B4)
MAX() Finds largest value =MAX(C1:C10)
MIN() Finds smallest value =MIN(D1:D5)
COUNT() Counts numeric entries =COUNT(E1:E10)

🧮 3. Using Cell References

Instead of typing numbers directly, you can refer to cell addresses:

  • =A1 + B1 is better than =10 + 20 because it updates automatically

📌 4. AutoSum Tool

Quick way to add numbers:

  • Select empty cell below numbers

  • Click AutoSum (Σ) on toolbar

  • Press Enter

Formulas and functions help you calculate data easily and reduce human errors. Mastering them makes your work faster and smarter.

Previous
Next
Scroll to Top