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.3: Sorting, Filtering, Autofill, and Freezing Panes

This lesson will help you manage large sets of data efficiently using sorting, filtering, autofill, and freezing panes features in Excel or Google Sheets.

🔀 Sorting Data:

Used to arrange data in ascending or descending order.

➤ How to Sort:

  1. Select the column you want to sort.

  2. Go to Data → Sort sheet A-Z (ascending) or Z-A (descending).

🧾 Example:
Sort a list of names alphabetically or sort marks from highest to lowest.

🔎 Filtering Data:

Used to hide data that doesn’t match specific conditions.

➤ How to Apply Filter:

  1. Select your data range.

  2. Click on Data → Create a filter.

  3. Filter icons will appear in column headers.

  4. Click the icon to select/deselect values to display.

🧾 Example:
Filter only students who scored above 60.

🔁 Autofill:

Used to quickly fill a series or pattern in cells.

➤ How to Use:

  1. Enter a value (e.g., 1 or Monday).

  2. Drag the fill handle (small square at bottom-right corner) down or across.

  3. It will continue the series: 1, 2, 3… or Monday, Tuesday…

🧾 Tip: You can also autofill formulas like =SUM(A1:A3)

❄️ Freezing Panes:

Freezing keeps headers visible while scrolling.

➤ How to Freeze:

  • In Excel: View → Freeze Panes → Choose rows/columns.

  • In Google Sheets: View → Freeze → Up to row 1 (or as needed)

🧾 Example: Freeze the first row so that column titles remain visible as you scroll down.

📝 Practice Task:

  1. Create a list of 10 students with marks.

  2. Sort the marks from highest to lowest.

  3. Apply a filter to show only marks greater than 70.

  4. Use Autofill to complete the days of the week.

  5. Freeze the top row with student names.

Previous
Next
Scroll to Top