Course Note

Course Note - Details Our Class

 πŸ“Œ What is MS-Windows?

Microsoft Windows (commonly called Windows) is a Graphical User Interface (GUI) based Operating System developed by Microsoft Corporation. It is one of the most widely used operating systems in the world.

It manages hardware and software resources, provides a user interface, and allows users to run applications.

🧠 Key Functions of Windows Operating System

  • File Management: Creates, stores, edits, deletes files and folders.
  • Memory Management: Allocates memory to programs and manages RAM.
  • Device Management: Controls hardware devices like printer, keyboard, and mouse.
  • Process Management: Manages processes and multitasking.
  • User Interface: Offers GUI with icons, buttons, and windows for easy interaction.
  • Security: Provides password protection, firewall, antivirus support.

πŸͺŸ Features of Windows OS

  • Graphical Interface (Icons, Start Menu, Taskbar)
  • Multitasking (Run multiple apps at once)
  • Plug and Play (Auto-detects new hardware)
  • Networking (LAN, Internet support)
  • Built-in Tools (Calculator, Paint, Notepad, File Explorer)
  • Search Functionality
  • Windows Defender (Basic security)
  • Control Panel / Settings App for system configuration

πŸ“… Popular Versions of MS-Windows

Version

Released

Key Features

Windows 95

1995

Start Menu introduced

Windows XP

2001

Stable, user-friendly

Windows 7

2009

Speed, Aero interface

Windows 8

2012

Metro UI, touchscreen support

Windows 10

2015

Cortana, virtual desktops

Windows 11

2021

New UI, better performance

πŸ“ Basic Elements of Windows Desktop

  • Desktop – Main screen area.
  • Icons – Shortcuts to apps or files.
  • Taskbar – Shows open programs and Start menu.
  • Start Menu – Access to programs, settings, shutdown.
  • Notification Area – Clock, volume, network, etc.
  • File Explorer – Used to browse and manage files and folders.

⚙️ Control Panel / Settings

Used to configure:

  • Display settings
  • User accounts
  • Date/time
  • Devices (keyboard, mouse, printer)
  • Programs and features

πŸ” User Account Types

  • Administrator – Full control.
  • Standard User – Limited access.
  • Guest – Temporary use.

πŸ’» Common MS-DOS / Windows Commands

These can be run in Command Prompt (cmd):

Command

Description

dir

Lists files and folders in current directory

cd

Changes the current directory

md or mkdir

Creates a new folder

rd or rmdir

Deletes a folder

del

Deletes a file

cls

Clears the screen

exit

Closes the command prompt

copy

Copies files

rename

Renames files

ipconfig

Shows network IP configuration

ping

Tests network connection

shutdown -s

Shuts down the computer

tasklist

Shows running tasks

format

Formats a disk (use with caution)

πŸ“ Tips for Students

  • Always log off or shut down properly.
  • Keep your desktop organized.
  • Learn to use keyboard shortcuts (e.g., Ctrl + C, Alt + Tab).
  • Use the Search bar to quickly find apps and settings.
  • Practice file management: creating folders, moving files, renaming, etc.

πŸ§‘‍🏫 Practice Activities for Students

  1. Create a folder named MyFiles on Desktop.
  2. Inside MyFiles, create 3 folders: Photos, Docs, Videos.
  3. Rename Photos folder to Images.
  4. Use cmd to list files using dir.
  5. Try basic commands like cd, cls, and exit.


Microsoft Word - Note

 

πŸ“Œ What is the File Menu in MS Word?

The File Menu in Microsoft Word is also called the Backstage View. It contains commands related to file handling, such as opening, saving, printing, sharing, and managing Word documents.

You can access it by clicking the "File" tab on the top-left corner of MS Word.

🧠 Functions of the File Menu

The File Menu helps users to:

  • Start a new document
  • Open an existing file
  • Save or Save As a document
  • Print the document
  • Export or Share files
  • Access recent documents
  • Set document properties and options

πŸ“‹ Detailed Options in the File Menu

Option

Function

New

Create a new blank document or use a template

Open

Open an existing Word document from your PC or cloud

Info

Shows file details: size, author, permissions, version history

Save

Saves changes to the current document

Save As

Saves a copy of the document with a new name or location

Print

Print the document; set page size, orientation, number of copies

Share

Share the document via email, OneDrive, or link

Export

Save as PDF or change file type

Close

Closes the current document (not the entire Word app)

Account

Manage Microsoft Office account, sign in/out, update

Options

Set Word preferences (language, display, proofing, etc.)

πŸ’Ύ Save vs. Save As

  • Save: Updates the current file without changing the name or location.
  • Save As: Allows you to save a copy with a different name, location, or format (e.g., .docx, .pdf, .txt).

πŸ–¨️ Printing a Document

Steps:

  1. Click File > Print
  2. Choose printer and settings:
    • Page range (All, Page 1-3, etc.)
    • Number of copies
    • Page orientation (Portrait/Landscape)
  3. Click Print button

Shortcut: Press Ctrl + P

πŸ”§ File Menu Keyboard Shortcuts

Shortcut

Action

Ctrl + N

New document

Ctrl + O

Open existing document

Ctrl + S

Save document

F12 or Alt + F + A

Save As

Ctrl + P

Print document

Alt + F

Open File Menu

Alt + F + E

Export

Alt + F + C

Close document

πŸ§‘‍🏫 Practice Activities for Students

  1. Open MS Word and create a new document.
  2. Type a short paragraph and save it as "MyFirstDoc".
  3. Use Save As to save another copy as PDF.
  4. Open the Print menu and check page settings.
  5. Go to Options and change the default font to "Calibri".
  6. Practice using keyboard shortcuts like Ctrl + S, Ctrl + P.

✅ Tips for Students

  • Save your work regularly to avoid losing progress.
  • Use descriptive file names for easy identification.
  • Choose PDF format for sharing or submitting documents.
  • Explore the Info section to view file details and permissions.
  • Use Export to save documents in different formats for different needs.


MS-Excel : Note

Some Projects :

1.      Salary Sheet which is given:

name

address

basic

house rent

medical allowance

total

Nasrin

Dhaka

7000

 

 

 

Nasrin

Dhaka

14000

 

 

 

Nasrin

Dhaka

11000

 

 

 

Nasrin

Dhaka

15000

 

 

 

House Rent               = c2*40%

Medical Allowance    = c2*15%

Total                          = c2 + d2+e2


2.     Salary Sheet:

name

address

Desig

basic

house rent

medical allowance

Profidend Fund

total

Nasrin

Dhaka

Pm

7000

 

 

 

 

 

H rent          =IF(D2>=10000,D2*50%,IF(D2>=8000,D2*40%,IF(D2<8000,D2*30%)))

M Allow       =IF(D2>=10000,D2*10%,IF(D2>=8000,D2*8%,IF(D2<8000,D2*5%)))

P Fund        =IF(D2>=10000,D2*15%,IF(D2>=8000,D2*10%,IF(D2<8000,D2*7%)))

 

3.     Banking Interest :

Amount

year

year

year

year

year

 

1

2

3

4

5

100000

 

 

 

 

 

150000

 

 

 

 

 

200000

 

 

 

 

 

250000

 

 

 

 

 

 

Simple Interest

=G1*H1*10%

Interest + Amount

=G1*H1*10%+g1

Compound Interest

=G1*(1+10%)^H1

 

         Click at Data

         Click at Table

         Row Input cell and column input cell

         Click at OK

 

4.     Electric Bill :

Previous Reading

Present Reading

Billing Unit

Total Bill

250

666

=b2-a2

=IF(C2>=500,C2*6,IF(C2>=300,C2*4,

IF(C2<300,C2*2)))

 

 

5.     Over Time :

Worker's Name

Working Hour

Over time

total Pay

mina

9

=IF(B2>8,B2-8,0)

=IF(B2>8,8*10+C2*20,B2*10)

moina

12

 

 

manik

7

 

 

asad

10

 

 

 

 

 

6.     Sales Commission :

Name

Basic

Sales

Commission

Net Pay

Azad

5000

45000

=if(c2>=100000,c2*2%,0)

=B2+D2

 

 

7.     Goal Seek :

Interest Rate

Installment

Price

Loan

Payment

Profit

10%

15

 

=c2*60%

=pmt(a2/12,b2,-d2)

=b2*e2-d2

 

 

 







 

8.     Result Sheet :

name

Ba1

En1

Ma1

Ch1

Bi1

Total

Average

Result

asad

44

33

88

55

33

 

 

 

Total       =sum(b2.f2)

Average =average(b2.f2)

Result  =if(or(b2<33,c2<33,d2<33,e2<33,f2<33),"Fail",if(h2>=80,

"A+",if(h2>=70,"A",if(h2>=60,"A-",if(h2>=50,"B",

if(h2>=40,"C", if(h2>=33,"D",if(h2<33,"Fail")))))))

 

10.   Data Consolidate :

          Sheet 1

Item Name

Quantity

Unit Price

Total Price

Television

 

 

 

Freeze

 

 

 

Air Conditioner

 

 

 

Woven

 

 

 

 

          Sheet 2

Item Name

Quantity

Unit Price

Total Price

Television

 

 

 

Freeze

 

 

 

Air Conditioner

 

 

 

Woven

 

 

 

 

          Sheet 3

Item Name

Quantity

Unit Price

Total Price

Television

 

 

 

Freeze

 

 

 

Air Conditioner

 

 

 

Woven

 

 

 

 

*  HLookup :

Serial

Name

Address

Basic

H rent

M Allo

P fund

Total

1

Asad

Pallabi

10000

3000

1500

1000

15500

2

Azad

Pallabi

12000

3600

1800

1200

18600

3

Mina

Pallabi

15000

4500

2250

1500

23250

4

Moina

Pallabi

9000

2700

1350

900

13950

5

Manik

Pallabi

6000

1800

900

600

9300








Serial

Name

Address

Basic

H rent

M Allo

P fund

Total
















data = A2.H6





question=A9













B19=HLOOKUP(B2,data,question,0)




Copy this formula to C9, D9, E9, F9, G9, H9

 

 

 

* PV (Loan) :

* FV (Deposit)

 

Interest Rate

7%

 

 

Year

5

 

 

Payment per year

12

Present Value (Loan Capacity)

=pv(b1/12,b2*b3,-b4)

Payment amount per month

2000

Loss for loan (jm ev ΓΏwZ)

=b2*b3*b4-d3

PV= Present Value OR Loan

 

Future Value (You will get)

=fv(b1/12, b2*b3,-b4)

FV=Future Value OR Cash

 

Profit for deposit (jvf)

= d5-b2*b3*b4

 

** Sumproduct() Function:

A

B

 

 

 

 

Date

Quantity



1/21/2018

10



9/25/2017

1



8/3/2018

7



8/30/2017

20



4/6/2017

3




17




=SUMPRODUCT((YEAR(a2:a6)=2018)*b2:b6)

 

 




Sum quantity of specific year.


 

Product

Quantity

Price

Amount

star

50 states

9

Computer

2

1000

2000

moon

Utah

4

Keyboard

4

250

1000

stars

Alaska

6

Mouse

4

100

400

9

Texas

5

Printer

2

50

100

 star








star

24


Total

3500

3500

star12

=SUMPRODUCT(LEN(H1:H4))


=SUMPRODUCT(B2:B5,C2:C5)

Find total length of character





2








=COUNTIF(F1:F7,"star")












Sum of Quantity * Price

Count only contain 'star' only

 

Sumiff() Function :

Item

Quantity









circle6

10









triangle

1









circle

7









circle8

20









triangle5

3





















7

=SUMIF(A2:A6,"circle",B2:B6)






40

=SUMIF(A2:A6,"<>triangle",B2:B6)






30

=SUMIF(A2:A6,"circle?",B2:B6)






8

=SUMIF(A2:A6,"*le",B2:B6)






28

=SUMIF(A2:A6,"triangle",B2:B6)+SUMIF(A2:A6,"circle8",B2:B6)+SUMIF(A2:A6,"circle",B2:B6)

 

 

 

 

 

iseven() Function :

22

TRUE

Even

29

FALSE

hello world!

6

30

TRUE

Even

=COUNTIF(C1:C11,"Even")

31

FALSE

hello world!

32

TRUE

Even

33

FALSE

hello world!

34

TRUE

Even

35

FALSE

hello world!

36

TRUE

Even

37

FALSE

hello world!

38

TRUE

Even

11

=ISEVEN(A12)

=IF(ISEVEN(A12),"Even","hello world!")

Some Functions:

Sum()- Returns the sum of some numbers.

Average()- Returns the average of some numbers.

Power()- Returns the results of a number raised to power.

Max()- Returns the maximum number from numbers.

Min()-Returns the minimum number from numbers.

Char()- Returns the symbol from ASCII Character set of number (0-255).

Len()- Returns the number of character of a cell.

Left()- Returns the character set specified from left.

Right()-Returns the character set specified from right.

Upper()- Returns the upper case of character from a cell.

Lower()-Returns the lower case of character from a cell.

Date()- Returns the current date international format.

Time()-Returns the current time international format.

Hour()- Returns the hour number of a time.

Minute()-Returns the minute number of a time.

Second()-Returns the second number of a time.

Year()-Returns the year number of a date.

Day()-Returns the day number of a date.

Month()-Returns the month number of a date.

Count()- Returns the number of numbers of specified cells.

Countblank()-Returns the number of cell that are blank.

 

Feroza Computer

(11-A, Road-4, House-7, Pallabi, Mirpur, Dhaka-1216)

 

 

 

 

 

 

 

Notes

On

MICROSOFT WORD

 

 

 

 

 

 

 

Student's Profile

 

Student's Name     : .............................................................................................

Address                 : .............................................................................................

Cell Number                    : .............................................................................................

 

 

 

 

 

 

 

1st Class:

Office button:

 

New ,Open, Save, Save As, Print, Send, Close.

 

New:-  (Ctrl+N)

bZzb ‡cR/dvBj †bIqvi Rb¨

Click for new blank document.

Office button/File- New /blank Document- create

 

 

Standard Keyboard = 101 button/key

6 lines.            1st key = Esc            Last key = Enter

1st line : Function button / key: 12 key as F1, F2, ..... F12/ Print Screen/ Scroll Lock/ Pause or break

2nd line : tild key (`  ~)  number key : 1, 2 .... 0/ -/ +=/ backspace

(Alternate Key : 17 button /  Number key and arrow key / - / +/ */ ins/ Del/ Enter)

Num lock on : Number key active

Num Lock off : Arrow key active.

 

3rd line :

4th Line :

5th Line : Contains Alphabet Key : a ...z / tab/ caps lock/ shift/ enter/ {} []/ :;/"'/|\/

6th Line : ctrl/ window logo/ alt/ space bar/ alt/ ctrl

Special Key :          inset/ home/ page up      delete/ end/ page doun

Arrow Key :     Up / right/ down/ left.

 

Keyboard Practice :

1st Practice :

a  s  d  f  g        h j  k  l  ;        Practice it 100 times.

2nd Practice :

q  w  e  r  t        y  u  i  o  p        Practice it 100 times.

3rd Practice :

z  x  c  v  b        b  n m  ,  .        Practice it 100 times.


2nd Class:

4th Practice :

a quick brown fox jumps over the lazy dog.    Practice it 50 times.

  

5th Practice :

A Quick Brown Fox Jumps Over The Lazy Dog.    Practice it 30 times.

  

6th Practice :

In this busy world it is very difficult to find a friend.  But learn Computer, Earn money, make yourself happy. It is best for you.

Practice it 20 times.

 

3rd Class:

Office Button Command

 

*        Save / dvBj †mf Kivi Rb¨

          File / Office Buttol- Click

          Save- click

          Type a file name and click at Save.

          OR

          Save:- (ctrl+s)

         

 

*        Open/‡mf Kiv dvBj †ei Kivi Rb¨

          File / Office Buttol- Click

          Open- click

          Select your file name

          Click on Open button

          OR

          Open:- (ctrl+ O)

         

 

*        Save As/ bZzb bv‡g dvBj †mf Kivi Rb¨

          File / Office Buttol- Click

          Save as- click

          Type a new file name and click at Save.

          OR

         

 

*        Print / wcΓ–›U Kivi Rb¨

          (Ctrl+P)

          Click File/ Office Button for file print.

          wcΒͺ›U †`Iqvi c~‡e© wb‡Pi Ackb ¸‡jv †`‡L wbb

          Print preview-Margin, Orientation, Size.

          Example: Margin:

          Click File/ Office Button for paper preview.

 

*        Close/ dvBj Kivi Rb¨

          File / Office Buttol- Click

          Close- click

 

*        Exit/ IqvW© †_‡K †ei nIqvi Rb¨

          File / Office Buttol- Click

          Exit- click

 

 

Home

*        Copy & Paste/ GKB †jLv/Qwe evi evi Kwc Kivi Rb¨

          Select your desire text or object or picture

          Click at Copy tool (Ctrl+c)

          Move your cousor to a desire position

          Click at Paste tool. (Ctrl+v)

 

*        Cut and undo cut/ ‡jLv ev` †`Iqv Ges wdwi‡q Avbvi Rb¨

          Select your desire text or object or picture

          Click at Cut tool (Ctrl+x)

          To undo the cut text or object or picture

          Click at undo tool. (Ctrl+z)

 

 

*        Bold Text/ ‡jLv Mvp Kivi Rb¨

          Select your desire text

          Click at Bold tool. (Ctrl+b)

 

*        Italic Text/ ‡jLv evuKv ÷vBj Kivi Rb¨

          Select your desire text

          Click at Italic tool. (Ctrl+i)

 

*        Underline Text/ ‡jLvi wb‡P `vM Uvbvi Rb¨

          Select your desire text

          Click at Underline tool. (Ctrl+u)

 

*        Strike Through Text/ ‡jLvi gvSLvb w`‡q `vM Uvbvi Rb¨

          Select your desire text

          Click at Strike Through tool.

 

*        Super Script Text/ ‡jLv‡K Dc‡i †bIqvi Rb¨

          Select your desire text

          Click at Super Script tool. (Ctrl+ Shift + +)

 

*        Sub Script Text/ ‡jLv‡K wb‡P †bIqvi Rb¨

          Select your desire text

          Click at Sub Script tool. (Ctrl+ +)

 

*        Change Font / ‡jLvi aib ev ÷vBj cwieZ©b Kivi Rb¨

          Select your desire text

          Click at Font tool.

          Select desire font from font list.

 

*        Change Font Size/ ‡jLv †QvU ev eo Kivi Rb¨

          Select your desire text

          Click at Font Size tool.

          Select desire font Size from font Size list.

 

          Grow font: A (ctrl+>)

          Font size replace(big)

 

          Shrink font: A (ctrl+<)

          Font size replace ( Small)

 

4th Class:

          Change case: ‡jLv †QvU/eo/ev‡K¨i cΓ–_g AΓΏi eo/ k‡Γ£i cΓ–_g AΓΏi eo BZ¨vw` cwieZ©b Kiv|

          Change all the selected case like lowercase, UPPERCASE, Capitalize etc.

 

          Tex highlight color:  abI  ‡jLvi wb‡Pi Ask‡K is w`‡q nvBjvBU&m Kiv|

 

          Font color: A   ‡jLvi A¶i ¸‡jv‡K iwOb Kiv|

          Example: asdfg ,lkjh

 

          Paragraph box

          Bullets: cΓ–ZxK w`‡q bv¤^vwis Kivi Rb¨|

          Example: », ∆, →

 

          Number: msL¨v w`‡q bv¤^vi Kivi Rb¨|

          Example: 1.2.3/ A,B,C/ I, ii,i v, v

 

          Align text left: (Ctrl+l)- ‡cR Gi evg cvk †_‡K †jLv Γ―i~ Kivi Rb¨|

          Example: Allah is one

          Align text center (Ctrl+e)- ‡cR G gvRLvb †_‡K †jLv Γ―i~ Kivi Rb¨|

          Example:

Take time to live.

          Align text Right:(Ctrl-R)- ‡cR G Wvb †_‡K †jLv Γ―i~ Kivi Rb¨|

          Example:

Take time to live.

          line Spacing: GK jvBb †K_‡K Ab¨ jvBb Gi `~iΖ’Z¡ wbY©‡qi Rb¨|

 

          Shading ‡h †Kvb parageaph ‡K iwOb Kivi Rb¨|

 

          Borders: ‡h †Kvb paragraph Gi Dc‡i, wb‡P, Wv‡b, ev‡g eW©vi Uvbvi Rb¨ |

 

Style box

‡h †Kvb †jLvi ÷vBj cwieZ©b Kivi Rb¨ Style box Gi heading My‡jv cwieZ©b Kiv †h‡Z cv‡i|

 

Style Sheet:  ‡h †Kvb †jLvi ÷vBj cwieZ©b Kivi Rb¨ Style Sheet Gi heading  M‡y‡jv cwieZ©b Ki‡Z cv‡ib|

 

Color:  ‡h †Kvb †jLvi iO cwieZ©b Kivi Rb¨ Style box Gi Color M‡y‡jv cwieZ©b Ki‡Z cv‡ib|

 

Font:  ‡ h †Kvb †jLvi d«›U cwieZ©b Kivi Rb¨ Style box Gi font M‡y‡jv cwieZ©b Ki‡Z cv‡ib|

 

Set as Default: c~‡e©i Ae¯’vq wd‡i Avmvi Rb¨  Set as Default wK¬K K‡ib|

 

Editing Box

Find: (ctrl+ f)  ‡h †Kvb IqvW© L&&&&&&&&&&&&&&&&&&&&&&y‡R †ei Kivi Rb¨|

Go to: (ctrl+G) ‡cR bv¤^vi Ly‡R †ei Kivi Rb¨|

Replace: (ctrl+R) IqvW© cwieZ©b Kivi Rb¨|

Select All: (ctrl+A) GK mv‡_ c~‡iv ‡jLv‡K  wm‡j± Kivi Rb¨|

Select text with Similar: GKB †cR G hw` Avjv`v Avjv` fvlv _v‡K †m¸‡jv †K Avjv`v K‡i  wm‡j± K‡i †`Lvi Rb¨|

 

5th Class:

Insert

 

Pages, Tables, Illustration, Links, Head- Footer, Text, Symbol Box

 

Pages box:

Cover page:  ‡h †Kvb ai‡bi wi‡cvU©, cΓ–wZ‡e`b BZ¨vw` iwOb ‡cR G ‰Zix Ki‡Z PvB‡j Kfvi †cR evPvB Ki‡Z cv‡ib|

Blank Page : bZzzb Lvwj †cR ‡bIqv hv‡e|

 

Table:  gvB‡ΓŽΓ¦vmdU IqvW© G ¸iΓ¦Z¡c~Y© f~wgKv cvjb K‡i †Uwej|

‡Uwej wZb fv‡e AvKvu hv‡e- Shadow, Insert, Draw.

hLb †cR G †Uwej AvuK‡eb ZLb ‡cR Gi Dc‡i g~j Ackb ¸‡jvi mv‡_ bZzb 2wU Ackb hy³ n‡e-

 

Design & layut  GB 2wUi wfZi †Uwe‡ji mKj Ackb jyKvwqZ _vK‡e|

 

Illustration box

Picture, Clip Art, Shapes, Smart Art, Chart:  ‡c‡R wewfbΕ“ ai‡bi Qwe, wK¬c AvU©, PvU© BZ¨vw` wWRvBb Ki‡Z PvB‡j GB Ackb My‡jv wK¬K Ki‡Z cv‡ib|

 

Position:  Qwe ‡K ‡c‡Ri †h‡Kvb cΓ–v‡Ε‘Í †mU Kivi Rb¨|

Bring to font: GK Qwe‡K Ab¨ Qwei Dci †mU Kiv hv‡e| Send to back: GK Qwe‡K Ab¨ Qwei wb‡P †mU Kiv hv‡e|

Text Wrapping: ‡jLvi NbZ¡, `~iZ¡, GKB e‡· ivLvi Rb¨ Ackb M~‡jv evPvB K‡I wb‡Z cv‡ib|

Group: ‡h‡Kvb e¨wmK ‡mc, Qwe BZ¨vw` †K MΓ–Γ¦c K‡i ivLv hv‡e|

(we: `Βͺ:-    References, Mailings Awdm †cΓ–vMΓ–vg Gi Rb¨ GB 2wU Ackb bv n‡jI Pj‡e )

 

 box

Hyperlink: GK dvBj Gi wfZi Av‡iKwU dvBj mshy³ Ki‡Z PvB‡j Hyperlink G wK¬K Ki‡Z cv‡ib|

 

Head & Footer box

‡cR Gi Dc‡i Ges wb‡P †h †Kvb ai‡bi wk‡ivbvg emv‡bvi Rb¨ Head & Footer e¨envi Ki‡Z cv‡ib|

 

Page Number : ‡cR Gi Dc‡i wb‡P bv¤^vwis Kivi Rb¨ Page Number wKΓΈK Ki‡Z cv‡ib|

G ‡ΓΏ‡ΓŽ 2wU Ackb _vK‡e  top (Dc‡i) Bottom( wb‡P).

 

6th Class:

Text Box :

 

 : ‡cR G mswÿß †bvU Kivi Rb¨  wK¬K Ki‡Z cv‡ib| 

Word Art:  IqvW©  †K wewfbΕ“ wWRvBb G mvRvB‡Z PvB‡j  K‡ib|

 

Drop cap:

ev‡K¨i  cΓ–_g AΓΏiwU Kgc‡ΓΏ wZb jvBb Ry‡o DVv‡bvi Rb¨ wK¬K K‡ib| Avgiv cwÎKvq jΓΏ Ki‡j gv‡S gv‡S †`L‡Z cvB|

Create a large at the beginning of a paragraph.

 

Signature line:

‡c‡Ri wb‡Pi As‡k mvBb DVv‡bv hv‡e

Insert a signature line that speacifies the indivutal who must sign.

Example--:

 

Date & time:   ‡cR G ‡WU UvBg DVv‡bvi Rb¨|

 

Equation:

‡cR G mvaviY MvwYwZK myÎ DVv‡bvi Rb¨|

Insert common Math mathematical  Equation .

 

Example :

 

Symbol:

‡cR G †h †Kvb ai‡bi  cΓ–ZxK e¨env‡ii  Rb¨| †hgb – KwcivBU, †UΒͺWgvK© BZ¨vw`|

Insert Symbol Such as copyright tradmark Unicode etc.

Example: ©, ®, @, $,%, &,# etc.

 

7th Class:

Page Layout

 

Themes, Page Setup, Page Background, Paragraph, Arrange.

 

Margin:

‡cR Gi Pvicv‡k gvwR©b  †mU Kiv hv‡e|

Select margin for entire document.

 

Orientation: ‡ccvi †gvW©

Switch the pages between portrait & landscape.

1.     Portrait- j¤^vjw¤^  2. Landscape-AvovAvwo

 

Size:  ‡ccvi mvBR wbY©q|

Choose a paper size of the current section.

Example: letter, A4 etc.

 

Columns:

GK Kjvg wewkΓ³ †jLv‡K GKvwaK Kjv‡g wef³ Kivi Rb¨ |

Split text into more colums.

 

Breaks : ev‡K¨i gv‡S KviQvU †i‡L ‡cR ,Kjvg †eΒͺK BZ¨vw` Kiv hv‡e|

Add page section or columns…..

 

Line Numbers: cΒͺwZwU jvB‡bi mvg‡b bv¤^vi w`‡Z cvi‡eb|

Add line number in the margin.

 

Watermark:  ‡cR Gi gvRLv‡b R¡jQvc †`Iqv hv‡e| †hgb- †h‡Kvb bvg, Qwe BZ¨vw` w`‡q|

 

Page color: ‡cR †K iwOb Kivi Rb¨|

 

Page borders: ‡cR Gi Pvi cv‡k eW©vi w`‡Z cvi‡eb|

Indent: gvwR©b cwieZ©b Kiv hv‡e| †hgb-

Left: evg cvk †_‡K Wv‡b  Right: Wvb †_‡K ev‡g Before: Dci †_‡K wb‡P  After: wbP †_‡K wbP/Dc‡i|

 

8th Class:

References

* Insert Footnote- ‡jLvi †k‡l †Kvb †jLvi Dci we‡kl †bvU †jLv|

 

* Insert Endnote -  dvBj Gi †k‡l †Kvb †jLvi Dci we‡kl †bvU †jLv|

 

 

Mailings

* Envelopes -  wPwVi Lv‡gi Dci wVKvbv ev G RvZxq †Kvb †jLv|

* Labels - gvK© ev wVKvbv wnmv‡e †Kvb †jLv Λ†Zix Kiv|

 

Review

 

Proofing, Comments, Tracking, Change, Compare, Lock

 

Spelling & Grammar:  MΓ–vgvi †PK Kivi Rb¨ (hw` Avcwb Bs‡iRx IqvW© wjL‡Z wM‡q †Kvb ai‡bi f’j K‡ib Zvn‡j Gi gva¨‡g mgvavb Ki‡Z cvi‡eb|

Thesaurus:  ‡h †Kvb k‡Γ£i mg_©K kΓ£ †ei Kiv hv‡e|

Word count: ‡cR msL¨v,jvBb, IqvW© BZ¨vw`I †gvU †ei Kivi Rb¨ |

New Coments: IqvW©, AΓΏi jvBb m¤ΓΊ‡K© gőÍe¨ Kiv hv‡e|

Delete: gőÍe¨ gyQ‡Z PvB‡j vwK¬K K‡ib|

Previews: GKvwaK gőÍe¨ Kivi ci GK GK K‡i ‡`Lv hv‡e|

Next: cieZx„ gbÍe¨ †`Lvi Rb¨|

Protect Document: dvBj jK K‡v ivLv hv‡e|

 

9th Class:

View

 

Document Views, Show/Hide, Zoom, Windows

 

Print Layut: GwU †cR 1g Gi GKwU Ae¯’v|

Full Screen: GwU †cR 2q Gi GKwU Ae¯’v|

Web layut: out line: GwU †cR 2q Gi GKwU Ae¯’v|

Drafts:   jvBb Gi mvg‡b gvK© K‡i jvBb †K Dc‡i wb‡P IVv bvgv Kiv hv‡e

 

Ruler: ‡cR Gi Dc‡i I ev‡g iΓ¦jvi †`qv hv‡e

iæjvi 2 cÖKvi- Vertical & Horizantal

Gridlines: MΓ–vd †ccvi †mU Kiv hve

Document map: cy‡iv †cR Gi g¨vc Kwc n‡q w¯¿b Gi evg cv‡k †`Lv hv‡e|

Thumbnails: cy‡iv †cR Gi g¨vc Kwc n‡q w¯¿b Gi evg cv‡k †`Lv hv‡e|

 

Zoom box:

Zoom:  IqvW© M~‡jv eo K‡i †`Lv hv‡e|

One page: GK †cR †`Lvi Rb¨|

Two page: w¯¿‡b GK mv‡_ 2 †cR †`Lv hv‡e|

Page width: ‡cR cvkv-cvwk Ae¯’vq †`Lv hv‡e|

Windows box:

New window: GK mv‡_ GKB wmÍΒͺ‡b GKvwaK DBb‡Wv ‡bqvi Rb¨|

Arange all: me ¸‡jv DBb‡Wv †K wgj Kivi Rb¨|

Split: GKwU DBb‡Wv †K 2 Kiv hv‡e|

View Slide by Slide: GK GK K‡i ¯ΓΈvBW wnmv‡e †`Lv hv‡e|

Switch windows: DBb‡Wvi myBP wbY©‡qi Rb¨|

Macros: ‡h †Kvb Kv‡Ri cΓ–_g ‡_‡K †kl chőÍ© ‡iKW© Kivi Rb¨|

 

 

Important Shortcut Keys for Computer-

CTRL+A. . . . . . . . . . . . . . . . . Select All
CTRL+C. . . . . . . . . . . . . . . . . Copy
CTRL+X. . . . . . . . . . . . . . . . . Cut
CTRL+V. . . . . . . . . . . . . . . . . Paste
CTRL+Z. . . . . . . . . . . . . . . . . Undo
CTRL+B. . . . . . . . . . . . . . . . . Bold
CTRL+U. . . . . . . . . . . . . . . . . Underline
CTRL+I . . . . . . . . . . . . . . . . . Italic
F2 . . . . . . . . . . . . . . . . . . . . . Rename selected object
F3 . . . . . . . . . . . . . . . . . . . . . Find all files
F4 . . . . . . . . . . . . . . . . . . . . . Opens file list drop-down in dialogs
F5 . . . . . . . . . . . . . . . . . . . . . Refresh current window
F6 . . . . . . . . . . . . . . . . . . . . . Shifts focus in Windows Explorer
F10 . . . . . . . . . . . . . . . . . . . . Activates menu bar options
ALT+F4 . . . . . . . . . . . . . . . . . Quit program, close current window
ESC . . . . . . . . . . . . . . . . . . . Cancel last function
SHIFT . . . . . . . . . . . . . . . . . . Press/hold SHIFT, insert CD-ROM to bypass auto-play

Document Cursor Controls
HOME . . . . . . . . . . . . . . to beginning of line or far left of field or screen
END . . . . . . . . . . . . . . . . to end of line, or far right of field or screen
CTRL+HOME . . . . . . . . to the top
CTRL+END . . . . . . . . . . to the bottom
PAGE UP . . . . . . . . . . . . moves document or dialog box up one page
PAGE DOWN . . . . . . . . moves document or dialog down one page
ARROW KEYS . . . . . . . move focus in documents, dialogs, etc.
CTRL+ > . . . . . . . . . . . . next word
CTRL+SHIFT+ > . . . . . . selects word
Ctrl + A Select all text
Ctrl + X Cut selected item
Shift + Del Cut selected item
Ctrl + C Copy selected item
Ctrl + Ins Copy selected item
Ctrl + V Paste
Shift + Ins Paste
Home Go to beginning of current line
Ctrl + Home Go to beginning of document
End Go to end of current line
Ctrl + End Go to end of document
Alt + S Send the email
Ctrl + C Copy selected text
Ctrl + X Cut selected text
Ctrl + P Open print dialog box
Ctrl + K Complete name/email typed in address bar
Ctrl + B Bold highlighted selection
Ctrl + I Italicize highlighted selection
Ctrl + U Underline highlighted selection

 

Feroza Computer

(11-A, Road-4, House-7, Pallabi, Mirpur, Dhaka-1216)

 

 

 

 

 

 

 

Notes

On

MICROSOFT Access

 

 

 

 

 

 

 

Student's Profile

 

Student's Name    : .............................................................................................

Address                 : .............................................................................................

Cell Number         : .............................................................................................

 

 

 

 

 

 

 

MS-Access Note

 

1. To Open MS-Access:

 

            Click at Windows Logo/Start Logo

            Select All Programs/ Program

            Select MS-Office

            Select MA-Access

 

2. To Create Data-base File :

            Click Blank Database Logo

            Write Database name

            Click Create button

            OR

            Click Office Button

            Click NEW

            Click Blank Data base Button

            Write Database name

            Click Create button

            Click Create

3. To Create Table File :

            Click Table Design

            Now create a field list like below :

 

            Click Field name   

            Click close button

            Now write file name and save it.

*          Now double click on your file name :

            And entry record as follows :


 

4.        To Create Query File :

            Click Create

            Select Query Design

            Now select your desire table file such as :

Now picked up the field for query file and type query data in your desire field such as :

            Now click close button

            click Yes for save file

            Type file name and click OK.

 

*          To display query file :

            Double click on your query file for see.

 

*          To Modify query file :

            Click on your query file.

            Click mouse Right button to display query chart

            Now change your field and data that you want to see.

            Save this file as above.

            See the file by double click.

6.        To Create Report File :

            To Create Report File :

            Click Create

            Select Report Wizard

            Now select your desire table file :

            Now select your desire Field

            Now select your desire grouping field

            Now select your desire grouping order on a field

            Now select your desire report layout

            Now select your desire report style

            Now type a report file title.

            Now select finish.

*          To set column width, page no. header, footer, title image, grid lines, etc. on a report file.

            Select a report file

            select view :

7.        To Create Label File :

            To Create Label File :

            Click Create

            Select Label

            Now select number of across

            Now select font, font size, font color, underline, etc.

            Now select your desire grouping field

            Now select your desire fields from field list.

            Now select your desire sorting order.

            Now type a label file title.

            Now select finish.

 

 

8.        To Create Macro File :

            Click Create

            Select Macro

            Now select Action name, object type and object name.

            Then for save  type a label file title.

            and close.

 

            * To run macro file

            Double click on a Macro file.

No comments:

Post a Comment

Subscribe to: Posts (Atom)