Course Content
Chapter 1: Computer Basics and Typing Skills
This chapter introduces the fundamental concepts of computers and typing. Students will learn what a computer is, its types, essential hardware and software components, and how to manage files and folders using the Windows operating system. It also focuses on the importance of typing in both English and Hindi and provides a basic introduction to typing tools and practices. These are essential skills for any computer operator working in offices, data entry roles, or administrative jobs.
0/8
Lesson 1.1: What is a Computer? Types and Uses
Lesson 1.2: Basic Components of a Computer (Input, Output, Processing)
Lesson 1.3: Difference Between Hardware and Software
Lesson 1.4: Introduction to Operating Systems (Windows)
Lesson 1.5: File and Folder Management
Lesson 1.6: Common Keyboard Shortcuts and Their Uses
Lesson 1.7: Introduction to Typing (English and Hindi)
Lesson 1.8: Typing Tools and Daily Practice Plan
Chapter 2: Office Productivity Tools – MS Word, Excel, PowerPoint
This chapter focuses on the most widely used office software tools – Microsoft Word, Excel, and PowerPoint. These tools are essential for preparing letters, reports, tables, calculations, charts, and presentations in any office environment. By mastering these tools, students will become job-ready for roles like data entry operator, back-office assistant, and admin executive.
0/7
Lesson 2.1: Introduction to MS Word and Its Interface
Lesson 2.2: Typing and Formatting Text in MS Word
Lesson 2.3: Tables, Lists, and Page Setup in Word
Lesson 2.4: Introduction to MS Excel and Its Interface
Lesson 2.5: Entering Data and Formatting Cells in Excel
Lesson 2.6: Performing Basic Calculations and Formulas in Excel
Lesson 2.7: Creating and Formatting Charts in Excel
Chapter 3: Word Processing (Microsoft Word)
This chapter will introduce students to Microsoft Word, a word processing software used for creating, formatting, and editing documents. By the end of this chapter, learners will be able to create professional documents such as resumes, letters, certificates, and reports with proper formatting, layout, and styling. They will also learn useful tools like spell check, bullet points, headers & footers, tables, and how to save or print documents.
0/5
Lesson 3.1: Introduction to Microsoft Word and Its Interface
Lesson 3.2: Typing and Formatting Text in MS Word
Lesson 3.3: Paragraph Formatting and Page Setup
Lesson 3.4: Working with Tables, Images, and Shapes
Lesson 3.5: Saving, Printing, and Sharing Word Documents
Chapter 4: Spreadsheet (Excel) Essentials
This chapter introduces the basics of spreadsheet software like Microsoft Excel or Google Sheets. You will learn how to enter and manage data, perform calculations using formulas, and visually represent data using charts. These skills are essential for tasks like data entry, analysis, reports, and basic accounting.
0/5
Lesson 4.1: Spreadsheet Basics and Cell Operations
Lesson 4.2: Editing and Formatting Cells
Lesson 4.3: Sorting, Filtering, Autofill, and Freezing Panes
Lesson 4.4: Basic Formulas and Functions
Lesson 4.5: Creating Charts (Bar, Pie, Line)
Chapter 5: Creating Presentations (PowerPoint Basics)
This chapter teaches how to create professional-looking presentations using Microsoft PowerPoint or Google Slides. Students will learn to create slides, insert text and multimedia, apply design themes, and set up slide shows. These skills are useful for office meetings, teaching, marketing, and personal projects.
0/5
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
Chapter 6: Internet and Networking Basics
This chapter introduces the foundational concepts of computer networks and the internet. Students will learn what networks are, how devices connect, and how the internet works. It also covers web browsing, search engines, IP addresses, and safe downloading practices—skills essential for any modern office or online work environment.
0/5
Lesson 6.1: Basics of Networks (LAN, WAN, Topologies)
Lesson 6.2: Understanding Internet and Web Browsers
Lesson 6.3: IP Address, ISP, and Connectivity Modes
Lesson 6.4: Web Browsing and Searching
Lesson 6.5: Downloading and Printing Web Pages
Chapter 7: Digital Communication and Office Tools
This chapter explores essential tools for digital communication and day-to-day office work. Students will learn how to send professional emails, manage attachments, use digital calendars, and participate in online meetings. It also covers the use of basic office equipment like printers, scanners, and photocopiers.
0/5
Lesson 7.1: Email Basics – Creating, Sending, and Managing Email
Lesson 7.2: Email Etiquette and Safety Guidelines
Lesson 7.3: Using Calendar, Online Meetings, and Reminders
Lesson 7.4: Using Printers, Scanners, and Photocopiers
Lesson 7.5: Office Record Management (Files, Notes, Digital Tools)
Chapter 8: Workplace Readiness and Soft Skills
This chapter focuses on essential skills and practices that make a person job-ready for any office environment. Alongside computer knowledge, employers also expect communication skills, professional behavior, teamwork, time management, and interview preparation from a computer operator or office assistant. This chapter builds those soft skills to ensure overall employability.
0/10
Lesson 8.1: Office Etiquette and Professional Behaviour
Lesson 8.2: Communication Skills (Verbal and Written)
Lesson 8.3: Time Management and Teamwork
Lesson 8.4: Office Dress Code and Etiquette
Lesson 8.5: Interview Skills and Job Readiness
Lesson 8.6: Freelancing and Online Job Platforms
Lesson 8.7: Creating an Impressive Resume and Cover Letter
Lesson 8.8: Interview Preparation and Workplace Etiquette
Lesson 8.9: Freelancing and Work from Home Opportunities
Career Advice
Final Test – Computer Operator & Office Assistant
This is the final quiz of the course, designed to test everything you’ve learned.
0/1
Final Assessment & Certificate Submission
Computer Operator and Office Assistant – Complete Course (Job Ready Program)

Lesson 4.4: Basic Formulas and Functions

This lesson introduces you to the most commonly used formulas and functions in spreadsheet software like Excel and Google Sheets. These tools help you perform calculations and analyze data efficiently.

➕ What is a Formula?

A formula is an equation that performs a calculation.

Formulas always start with an equals sign (=).

🧾 Example:

sql
=5+3 → Result: 8
=A1+A2 → Adds values of cell A1 and A2
=B1*B2 → Multiplies values of cell B1 and B2

🔢 What is a Function?

A function is a predefined formula that performs a specific task.

🔹 Common Functions:

Function Purpose Example
SUM() Adds numbers =SUM(A1:A5)
AVERAGE() Finds average =AVERAGE(B1:B5)
MAX() Finds the highest number =MAX(C1:C10)
MIN() Finds the lowest number =MIN(D1:D10)
COUNT() Counts number of entries =COUNT(E1:E10)

🔄 Order of Operations in Formulas:

Like in math, Excel/Sheets follow the BODMAS rule:

  • Brackets

  • Orders (exponents)

  • Division and Multiplication

  • Addition and Subtraction

🧾 Example:

sql
=10+5*2 → Result: 20 (not 30, because multiplication happens first)

✅ Real-World Examples:

  • Calculate total marks: =SUM(B2:F2)

  • Find average score: =AVERAGE(B2:F2)

  • Find top scorer: Use =MAX(G2:G10)

📝 Practice Task:

  1. Enter marks of 5 subjects for 5 students.

  2. Use SUM() to calculate total marks for each student.

  3. Use AVERAGE() to find average marks.

  4. Find the highest and lowest total marks using MAX() and MIN().

Previous
Next
Scroll to Top