Introduction to Computer

(3hrs)

Introduction of Computer

Introduction to computer, History of computers: A brief timeline, Classification of different types of computers, Application of different types of computers, Basic Operations of Computer

Computer Software

What is software? Different types of software, what is firmware? Software vs. firmware   

Computer Hardware

Basic components of a computer, Introduction to different components of hardware

Operating System Using Windows & Linux

(6hrs)

Operating System

Introduction of operating system; Discussion of different operating systems (windows, Linux, Unix, etc); Installing Windows operating systems;

Operation of Computer

Turn on the PC, create windows user, Password creation and modify, Identifying and create File-Folder-Drive, Create, Save, Undo, Redo, Open new file, File permission, Cut, Copy; Search for an existing file, find location of a file, Change location of files; Daily Uses of digital appliances;

Hardware and Troubleshooting

(9hrs)

Hardware: Assembly & De-assembly: Discuss Computer Hardware Component; Desktop, Laptop, Printer, Scanner De-Assembly and Assembly, Hard Disk Partitioning & Formatting, Data Backup & Recovery, Installing Peripheral devices (Printer, Scanner, Webcam etc.), Preparing LAN & File Sharing, Software and Hardware Diagnostics and Troubleshooting

Microsoft Word

(18 hrs)

Microsoft Word

Microsoft Word and its working area; Opening Microsoft Word and understanding the home screen, Tour of the Word interface (ribbon, toolbar, menus, workspace)

Creating, Saving, and Managing Documents

Starting a new document, naming, and saving (as .docx and PDF), Opening, closing, and managing files, Practice: Create and save a simple document

Basic Text Entry and Editing

Typing text, selecting, cutting, copying, and pasting, Undo/redo functions, basic navigation, Practice: Write and edit a short paragraph, save progress

Text Formatting Fundamentals

Font style, size, and color adjustments, Bold, italic, underline, and text alignment, Using bulleted and numbered lists for organized content

Paragraph and Page Layout

Line spacing, paragraph spacing, indentation, and tab settings, setting up margins, orientation (portrait vs. landscape), and page size, Page and section breaks Using predefined styles (e.g., Heading 1, Heading 2) for a structured document

Inserting and Formatting Images

How to insert images from the computer or online, adjusting image size, positioning, and using text wrapping options

Working with Shapes, Text Boxes, and Basic Design Elements

Inserting shapes, clip Art, Smart Art, adding text boxes, and customizing simple designs, using accessibility tools (e.g., Read Aloud, Accessibility Checker)

Tables: Creation and Formatting

Inserting tables, adjusting rows/columns, and basic formatting, Table borders, shading, and alignment, Applying styles for tables, headings, and paragraphs

Proofing Tools: Spell Check, Grammar Check, and Find & Replace

Using spell check, grammar check, and thesaurus to improve document quality, Find and replace for quick edits and adjustments, Adding comments for collaborative feedback, Book Mark

Document Organization with Headers, Footers, and Page Numbers

Adding headers, footers, and page numbers for a professional look, Customizing headers/footers with different styles

Document Templates and Quick Parts

Exploring built-in templates (resumes, reports, letters), Using Quick Parts for reusable content (e.g., date, author information)

Introduction to Mail Merge

Overview of Mail Merge for letters, labels, and emails, setting up and customizing mail merge fields for personalization

Keyboard Shortcuts and Efficiency

Common shortcuts: Copy (Ctrl+C), Paste (Ctrl+V), Save (Ctrl+S), Navigation shortcuts and productivity tips for faster editing

Document Accessibility and Quality Checks

Using the Accessibility Checker for inclusive document design, improving readability and using structured layouts

Unicode Bangla

Introduction of Unicode & Familiar with Unicode Keyboard and font; Unicode Software and Font Installation technique; Writing procedure in Bangla etc. Bangla typing using voice command, Google Docs

Microsoft Excel

18. hrs)

Working Area of MS Excel and Induction of Excel Interfacing

Creating a New Workbook & Navigating in Excel, Moving the Cell Pointer, Using Excel Menus; Using Excel Toolbars: Hiding, Displaying, and Moving Toolbars, Entering Values in a Worksheet and Selecting a Cell Range; Previewing and Printing a Worksheet, Getting Help from the Office Assistant, saving a Workbook & Re-opening a saved workbook etc.

Formatting a Worksheet

Creating Headers, Footers, and Page Numbers, Adjusting Page Margins and Orientation, Adding Print Titles and Gridlines, rows to repeat at top of each page, Formatting Fonts & Values, Adjusting Row Height and Column Width, Changing Cell Alignment, Adding Borders, Applying Colors and Patterns, Using the Format Painter, Using AutoFormat, Merging Cells, Rotating Text, and using AutoFit, Using AutoFill

Managing & editing your workbooks

Switching Between Sheets in a Workbook, Inserting and Deleting Worksheets, Renaming and Moving Worksheets, Protecting a Workbook, Hiding Columns, Rows and Sheets, Creating a New Workbook, Navigating in Excel, Moving the Cell Pointer, Using Excel Menus, Using Excel Toolbars: Hiding, Displaying, and Moving Toolbars, Entering Values in a Worksheet and Selecting a Cell Range, Previewing and Printing a Worksheet, Getting Help from the Office Assistant, Saving a Workbook & Re-opening a saved workbook etc.

Working with the Forms Menu Chart and Data

Creating & Working with Chart; and Data Filtering; Using Fill Effects, Mapping Data, Modifying a Map. Data Analysis & Pivot Tables, creating a PivotTable, Specifying the Dala a PivotTable Analyzes, changing a Pivot Tables’s Calculation, selecting what Appears in a PivotTable. Grouping Dates in a PivotTable, updating a PivotTable, Formatting and charting a PivotTable

Excel Functions

Function, Description

=AND, Returns TRUE or FALSE based on two or more conditions

=AVERAGE, Calculates the average (arithmetic mean)

=AVERAGEIF, Calculates the average of a range based on a TRUE or FALSE condition

=AVERAGEIFS, Calculates the average of a range based on one or more TRUE/FALSE conditions

=CONCAT, Links together the content of multiple cells

=COUNT, Counts cells with numbers in a range

=COUNTA, Counts all cells in a range that has values, both numbers and letters

=COUNTBLANK, Counts blank cells in a range

=COUNTIF, Counts cells as specified

=COUNTIFS, Counts cells in a range based on one or more TRUE or FALSE condition

=IF, Returns values based on a TRUE or FALSE condition

=IFS, Returns values based on one or more TRUE or FALSE conditions

=LEFT, Returns values from the left side of a cell

=LOWER, Reformats content to lowercase

=MAX, Returns the highest value in a range

=MEDIAN, Returns the middle value in the data

=MIN, Returns the lowest value in a range

=MODE, Finds the number seen most times. The function always returns a single number

=NPV, The NPV function is used to calculate the Net Present Value (NPV)

=OR, Returns TRUE or FALSE based on two or more conditions

=RAND, Generates a random number

=RIGHT, Returns values from the right side of a cell

=STDEV.P, Calculates the Standard Deviation (Std) for the entire population

=STDEV.S, Calculates the Standard Deviation (Std) for a sample

=SUM, Adds together numbers in a range

=SUMIF, Calculates the sum of values in a range based on a TRUE or FALSE condition

=SUMIFS, Calculates the sum of a range based on one or more TRUE or FALSE condition

=TRIM, Removes irregular spacing, leaving one space between each value

=VLOOKUP, Allows vertical searches for values in a table

=XOR, Returns TRUE or FALSE based on two or more conditions

Microsoft PowerPoint

(09 hrs)

Working area and Introduction of MS PowerPoint Interfacing

Introduction to Microsoft PowerPoint and its interface;, Creating a new presentation and understanding slide layouts; Inserting and managing slides (adding, deleting, rearranging); Working with text: ding, formatting, and aligning text on slides, Using bulleted and numbered lists, Saving and organizing presentations,  Inserting and formatting images on slides, Using shapes and icons to enhance design, Adding and editing SmartArt for visual storytelling, Introduction to charts: Creating and formatting charts,  Applying slide backgrounds and design themes, Working with slide master for consistent design.

Animations and Transitions

Introduction to slide transitions and applying different effects, understanding animations: Entrance, emphasis, exit, and motion path effects, customizing animation sequences and timings, Using the Animation Pane for complex animations, adding audio and video elements to slides

• Google Slides

Microsoft Access

(06 hrs)

Introduction and Database Basics

Introduction to Microsoft Access and its interface, understanding databases: Tables, queries, forms, and reports, creating a new database, setting up tables and defining fields, Data types and field properties, Primary keys and unique identifiers, Entering and editing data in tables Hands-on practice with table creation and data entry

Working with Tables and Relationships

Modifying table structure: Adding and deleting fields, Field properties: Input masks, validation rules, and default values, Sorting and filtering data in tables, creating relationships between tables, understanding one-to-many and many-to-many relationships, Enforcing referential integrity

Using lookup fields to display related data

Queries and Data Retrieval

Introduction to queries: Select, action, and parameter queries, creating basic select queries for data retrieval, using criteria to filter query results, Sorting and grouping data in queries, Creating calculated fields in queries, Action queries: Append, update, delete, and make-table queries, Using parameter queries for dynamic data input

Forms, Reports, and Database Management

Introduction to forms and their purpose, Creating and customizing basic forms, adding controls (e.g., text boxes, combo boxes) to forms, using forms to enter and navigate data, Introduction to reports: Creating and formatting reports, Grouping, sorting, and summarizing data in reports, Basic database management: Backup, compact, and repair

Smart Office Management

(21 hrs)

Internet

Introducing the Internet, Concepts pf Internet and Intranet, Introduction to web browser, Getting Help, Exploring the Web, Working with Web pages, Searching the Internet, Performing advanced searches, Using ChatGPT and AI-based search assistants. Customizing the search features, Working with Web pages, Working with Favorites, using links, Using the History list, Printing Web content, and Internet transactions. E-commerce, Web security.

Introduction to Email

Creating an email account, Understanding the inbox, sent folder, and trash folder, Composing, replying, and forwarding emails, Using CC and BCC, Formatting email text (bold, italics, fonts, hyperlinks, etc.), Adding attachments

Email Organization and Management

Setting up folders, labels, and archiving, Basic filters and rules for organization, Marking emails for follow-up (flags, stars)

Email Security and Privacy

Recognizing phishing and scam emails, Password best practices and two-factor authentication (2FA), Avoiding personal info sharing and handling sensitive information.

Social Media

Facebook, Twitter, YouTube, WhatsApp

Google Tools

Google Drive, Google Meet, Google Translate, Google Forms.