Microsft Excel Exercises

Exercise # 1 Working with Microsoft Excel

Open Microsoft Excel
Click File Menu
Click Page Setup
Click Page Tab
Orientation: Portrait
Paper Size: 8.5”x11”
Click Magins Tab
Top     : .5”
Bottom  : .5”
Left    : .5”
Right   : .5”
Click OK button

Type the following:

3
45
32
345
23
22
35
189

Click File, click Print Preview
Edit the data (Press F2 or Double click the cell)
Change 189 to 289
Click File, click Save, enter the filename

File name: exer1.xls

Note: if you want to save for worksheet in your diskette just
  include A:\ before the filename.

Click File, click Close
Click File, click Exit

_________________________________________________________________________

Exercise # 2 Microsoft Excel Resizing and moving window

Open Microsoft Excel
Click File Menu
Click Page Setup
Click Page Tab
Orientation: Landscape
Paper Size: 8.5”x14”
Click Magins Tab
Top      : 1”
Bottom   : 1”
Left     : 1”
Right    : 1”
Click OK button

Minimize the Application Window
Click the control menu, click minimize or click the minimize
 button located at the upper left portion of your worksheet.

Restore your document
To restore double click the ICON restore at the top left
portion of the window.

Resize the document window
Position your mouse pointer anywhere on the border of your
window.  When the mouse pointer changes to two-headed arrow
click and drag the mouse. Release the mouse.

Moving the document window
Position the mouse pointer on the Title Bar.  Click the
 left mouse button and drag it to the left.

Click File, click Close
Click File, click Exit

_________________________________________________________________________

Exercise # 3 Sorting Cells

Open Microsoft Excel
Click File Menu
Click Page Setup
Click Page Tab
Orientation: Portrait
Paper Size: 8.5”x11”
Click Magins Tab
Top   : .5”
Bottom: .5”
Left  : .5”
Right : .5”
Click OK button

Move down five rows
Click the down arrow key 5 times

Move up 2 rows2
Click the up arrow key 2 times

Move right 10 columns
Click the right arrow key 10 times

Move left 2 columns
Click the left arrow key 2 times

Type the following:

Red
Orange
Blue
Yellow
White
Pink
Violet
Gray

Highlight A1 to A8.
Click the Sort Ascending button
Highlight A1 to A8.  Change the font size to 16.  Look what
will happen
Click File, click Exit
Note: Don’t save your work
_________________________________________________________________________

Exercise # 4 Selecting Cells, Ranges and resizing column

Open Microsoft Excel
Click File Menu
Click Page Setup
Click Page Tab
Orientation: Portrait
Paper Size: 8.5”x11”
Click Magins Tab
Top   : .5”
Bottom: .5”
Left  : .5”
Right : .5”
Click OK button

Select cell B8
Position the mouse pointer on cell B8 and click the left mouse
 button.
Type Room
Select range A2:D20

Position the mouse pointer to cell A2
Click and drag the mouse pointer to cell D20
Release the mouse button.

Select range B2, D4, E25, F12 and C17

Hold down the CTRL key
Click the B2, D4, E25, F12, and C17
Select all columns on A
Click column heading A
Note: All of the rows on A will be highlighted
Select column B and C
Select rows G15 and column E
Resizing column

To resize the column click the column heading that
 you want to resize (A, B, C, D, E….)
Move the mouse pointer on the edge of the column,
 the mouse pointer will change to black
color and becomes a cross with 2 headed arrow.
 Drag the mouse.

_________________________________________________________________________

Exercise # 5 Inserting Border, using Decimal and comma style

Open Microsoft Excel
Click File Menu
Click Page Setup
Click Page Tab
Orientation: Portrait
Paper Size: 8.5”x11”
Click Magins Tab
Top   : .5”
Bottom: .5”
Left  : .5”
Right : .5”
Click OK button

Type the following:

SCHOOL  LOT AREA
BUST    323,452,345
GUP     234,234,341
MATENEO 123,231
TEU     2,121,212

Click File, click Print Preview or click

Note: The document has no border

To insert a border
Highlight the cell(s) or range A1 to B5
Click the Border Icon
Click the All borders icon

SCHOOL  LOT AREA
BUST    323,452,345
GUP     234,234,341
MATENEO 123,231
TEU     2,121,212

Click Print preview or click

Note:  To resize the column click the column heading that
you want to resize.  Move the mouse pointer on the edge of
the column, the mouse pointer will change to black color
and becomes a cross with 2 headed arrow.Drag the mouse.

Add the following to column C
SCHOOL  LOT AREA     AMOUNT
BUST    323,452,345  2150214545
GUP     534,234,341  7125489872
MATENEO 123,231      3254894
TEU     2,121,212    325418784

To insert decimal places and comma
Highlight cell C2 to C5
Click increase decimal icon twice.
Click comma style icon.

SCHOOL  LOT AREA     AMOUNT
BUST    323,452,345  2,150,214,545.00
GUP     534,234,341  7,125,489,872.00
MATENEO 123,231      3,254,894.00
TEU     2,121,212    325,418,784.00

Add border to column C1 to C5
Click Print Preview or click

Click File, click Save
Enter the Filename
Click File, click Exit


_________________________________________________________________________

Exercise # 6 Centering data using Merge and Center command

Open Microsoft Excel
Click File Menu
Click Page Setup
Click Page Tab
Orientation: Portrait
Paper Size: 8.5”x11”
Click Magins Tab
Top   : .5”
Bottom: .5”
Left  : .5”
Right : .5”
Click OK button

Type the following:

BINAUGANAN
CUT-CUT I
POBLACION
SAN VICENTE
MATATALAIB
SAN SEBASTIAN
LIGTASAN
SAN NICOLAS
SAN ROQUE
STO. CRISTO
SAN JUAN DE BAUTISTA
MABINI
STA. CRUZ
TARIJI
BALIBAGO I
SALAPUNGAN
SEPUNG CALZADA
DALAYAP
ALVINDIA
BUHILIT
BANABA
CENTRAL/HOMESITE
MAPALACSIAO
LOURDES
ASTURIAS
BUENAVISTA

Sort the data in ascending order

Add the following headings:
Note:  To add a row.  Position the mouse on the
       desired row (A1). 
       Click Insert menu, click Rows.
To merge two cells highlight cell A1 to B1, click
       the merge and Center icon.
       Add a border

Tarlac City

Place               Population

ALVINDIA            344
ASTURIAS            6556
BALIBAGO I          2334
BANABA              2342
BINAUGANAN          1313
BUENAVISTA          5677
BUHILIT             4344
CENTRAL/HOMESITE    2343
CUT-CUT I           1323
DALAYAP             3443
LIGTASAN            2453
LOURDES             2344
MABINI              2342
MAPALACSIAO         2344
MATATALAIB          1234
POBLACION           3134
SALAPUNGAN          23424
SAN JUAN DE BAUTISTA4344
SAN NICOLAS         345553
SAN ROQUE           2434
SAN SEBASTIAN       6785
SAN VICENTE         7453
SEPUNG CALZADA      34434
STA. CRUZ           5767
STO. CRISTO         24244
TARIJI              5657

Save your work in your diskette with a filename “Tarlac”
Close Microsoft Excel


_________________________________________________________________________

Exercise # 7 Saving a workbook with different filename or location

Open Microsoft Excel
Click File Menu
Click Open
Open Tarlac file
Click OK button
Add the following:

Republic of the Philippines
Tarlac City
Place                Lot         Area Population
ALVINDIA             524         344
ASTURIAS             54,879      6556
BALIBAGO I           579         2334
BANABA               4,784       2342
BINAUGANAN           6,587       1313
BUENAVISTA           9,725       5677
BUHILIT              24,874      4344
CENTRAL/HOMESITE     49,947      2343
CUT-CUT I            5,498       1323
DALAYAP              487,514     3443
LIGTASAN             548         2453
LOURDES              547         2344
MABINI               4,876       2342
MAPALACSIAO          457         2344
MATATALAIB           3,658       1234
POBLACION            6,548       3134
SALAPUNGAN           548         23424
SAN JUAN             698         4344
SAN NICOLAS          478         345553
SAN ROQUE            698         2434
SAN SEBASTIAN        3,254       6785
SAN VICENTE          7,485       7453
SEPUNG CALZADA       3,654       34434
STA. CRUZ            3,254       5767
STO. CRISTO          12,545      24244
TARIJI               4,875       5657

Save your work with a different filename
Click File, click Save As
Filename: Places.xls
Click SAVE button

Close Microsoft Excel



_________________________________________________________________________

Exercise # 8 Renaming a Sheet

Open Microsoft Excel
Click File Menu
Click Open
Open Tarlac file
Click OK button

Right click sheet1 tab
Click Rename.  Type Places

Right click sheet2 tab
Click Rename. Type Voters
Type the following:

BARANGAYS PRECINT # # OF REG. VOTERS
1998

AGUSO      1A       200
           1A1      167
           2A       200
           2A1      58
           3A       200
           3A1      30
           4A       200
           4A1      195
           5A       200
           5A1      116
           6A       159
           7A       81
           8A       153
           9A       198
                    2157

ALVINDIA   10A      200
           10A1     12
           11A      200
           11A1     144
                    556

AMUCAO     12A      200
           12A1     70
           13A      200
           13A1     185
           14A      200
           14A1     21
           15A      70
           16A      80
                    1026

_________________________________________________________________________

Exercise # 9 Using Formula Function

Open Microsoft Excel
Click File Menu
Click Page Setup
Click Page Tab
Orientation: Landscape
Paper Size: 8.5”x11”
Click Magins Tab
Top   : .5”
Bottom: .5”
Left  : .5”
Right : .5”
Click OK button
Type the Following:

Student no. Student Name       Prelim  Midterm Final Average
99-091      Bond, Mighty G.    78      78      78
99-827      Bondage, James T.  85      86      77
99-231      Pie, Erik H.       97      87      76
99-123      Sy, Jonathan S.    78      87      79
99-122      Agota, Michelle F. 84      89      84
99-132      Peralta, Havok T.  76      83      75
99-001      Labork, Chucky U.  87      86      76
99-623      Wong, Edwin T.     82      78      74
99-016      Dela Cruz, Say Y.  84      94      82
99-991      Talon, Talon T.    79      78      87

To use the Formula Function
Select cell F2
Type = average(C2:E5) and press ENTER key

To use formula to all cells at once
Position the mouse pointer to the lower right
 (fill handle) of cell F2, the pointer becomes
 a cross, drag the mouse down to cell F11.

Student no. Student Name      Prelim  Midterm Final Average
99-091      Bond, Mighty G.   78      78      78    78
99-827      Bondage, James T. 85      86      77    82.66666
99-231      Pie, Erik H.      97      87      76    86.66666
99-123      Sy, Jonathan S.   78      87      79    81.33333
99-122      Agota, Michelle F.84      89      84    85.66666
99-132      Peralta, Havok T. 76      83      75    78
99-001      Labork, Chucky U. 87      86      76    83
99-623      Wong, Edwin T.    82      78      74    78
99-016      Dela Cruz, Say Y. 84      94      82    86.66666
99-991      Talon, Talon T.   79      78      87    81.33333

Use only two decimal places:
Highlight cell F2-F11.  Click Decrease decimal icon 5 times
Sort the data according to last name.
Save your work in your diskette with a filename Grade.xls
_________________________________________________________________________

Exercise # 10 Copying and Moving Data

Open Microsoft Excel
Click File Menu
Click Page Setup
Click Page Tab
Orientation: Portrait
Paper Size: 8.5”x11”
Click Magins Tab
Top   : .5”
Bottom: .5”
Left  : .5”
Right : .5”
Click OK button

Open the file Grade.xls
Note: You have two workbooks open. Book1 and Grade

Copy Student No. and Student Name to Book1

Student no. Student Name
99-091      Bond, Mighty G.
99-827      Bondage, James T.
99-231      Pie, Erik H.
99-123      Sy, Jonathan S.
99-122      Agota, Michelle F.
99-132      Peralta, Havok T.
99-001      Labork, Chucky U.
99-623      Wong, Edwin T.
99-016      Dela Cruz, Say Y.
99-991      Talon, Talon T.


Type the following:
See sample output


SAMPLE OUTPUT

INTERWORLD COLLEGES
Ninoy Aquino Ave., Tibag, Tarlac City

Attendance Sheet

Subject:_____________________    Room:___________________
Day and Time:________________ Teacher:___________________


Student no. 
Student Name 
1st
2nd
3rd
4th
5th
6th
7th
8th
9th
10th

99-091 
Bond, Mighty G. 

99-827 
Bondage, James T. 

99-231 
Pie, Erik H. 

99-123 
Sy, Jonathan S. 

99-122 
Agota, Michelle F.

99-132 
Peralta, Havok T. 

99-001 
Labork, Chucky U. 

99-623 
Wong, Edwin T. 

99-016 
Dela Cruz, Say Y. 

99-991 
Talon, Talon T. 


Format Cell
Position the mouse pointer to column heading C, then drag
 the mouse up to column heading T.
Click Format
Click Column
Click Width…
Type 3, then click OK buton

Center the Heading
Click Print Preview then close print Preview (this is done
 to display the paper size,  broken line indicates paper
 margin.
Highlight the text that you want to center. 
Example: Highlight cell A1 to cell T1
Click Merge and Center icon

Sort the Data
Highlight student no. 99-091 to 99-991, Student Name Bond,
 Mighty G. up to Talon, Talon T.
Click the Sort Ascending icon

Note:   Use the Border icon   to insert borders
Use the Merge and Center icon to Center the Heading

Save you work in your diskette with a filename Attend.xls
Close Microsoft Excel

_________________________________________________________________________
EXERCISE # 11 – Using Word Art

Change the paper setup to

Margin  Top - .5”
Left        - .5”
Right       - .5”
Bottom      - .5”

Orientation  Landscape

Click the Insert WordArt Icon
Select the WordArt style by double clicking the box
Type your text in the text box (you can edit the text
 by changing the Font style, size, bold, italics etc.)
Click OK

TO EDIT WORDART/TO RESIZE AND REPOSITION WORDART

Click the WordArt
A outside border will be displayed
To reposition the Wordart drag the text
To resize WordArt point the mouse pointer to any
 of the borders then drag the mouse.

note: You can use the Word art toolbars to edit
      your text

INSERT WORDART - It is use to add WordArt
EDIT TEXT - it is use to change or edit the text
WORDART GALLERY – It is use to edit the Word Art
 style
FORMAT WORDART – It is use to change the color and
 lines, size,etc.
WORDART SHAPE – it is use to change the shape of
 the WordArt to stop sign, plain, circle etc.
FREE ROTATE – it is use to rotate the Word Art.

Note : to rotate, click the free rotate icon
       then point to any  yellow circle of the
       edge of the text. Then drag the text.
WORDART SAME LETTER HEIGHTS -  It is use to change
 the size of all letters to a specific height. 
 Note: It will make the text all CAPS.
WORDART VERTICAL TEXT – It is use to align the text
 vertically
WORDART ALIGNMENT – It is use to align the text
WORDART CHARACTER SPACING – It is use to change the
 spacing of  the text. ( Normal, tight, loose, etc..)

_________________________________________________________________________

EXERCISE # 12 – Inserting a picture ( POSTER)

Change the paper setup to

Margin  Top - .5”
Left        - .5”
Right       - .5”
Bottom      - .5”

Orientation  Landscape

Insert a WordArt
Insert a picture

1. Click the Insert clip Art Icon
2. Click the category (example: click the
   animal icon)
3. Click magic then click the insert clip art
4. Close the Clip Art Window by clicking the
   x icon

note: change the size and position of the clip
      Art by dragging the image

OUTPUT:  


_________________________________________________________________________

EXERCISE # 13 – Inserting a picture and using the picture toolbar ( RECEIPT)

Change the paper setup to

Margin  Top - .5”
Left  - .5”
Right - .5”
Bottom - .5”

Orientation  Landscape

I. Type the following
II. Insert a picture

1. Click the Insert clip Art Icon
2. Click the category (example: click the animal icon)
3. Click magic then click the insert clip art
4. Close the Clip Art Window by clicking the x icon

note: change the size and position of the clip Art
      by dragging the image

note: to change the image click the image then click
      the image contol click the gray scale and
      click the watermark.

To display the picture toolbar click the view in the
     menu bar then click the toolbars then click
     picture toolbar.

INSERT PICTURE FROM FILE – it is use to insert picture
 from file.
IMAGE CONTROL – It is use to change the image to
 automatic, gray scale, black and white and watermark.
MORE CONTRAST AND LESS CONTRAST – it is use to change
 the image contrast
MORE AND LESS BRIGHTNESS- It is use to change the
 image brightness
CROP – It is use to crop the image
LINE STYLE - It is use to change the line style
FORMAT PICTURE - It is use to change the color
 and lines, size,etc.
SET TRANSPARENT COLOR – It is use to set the image
 to transparent.
RESET THE IMAGE PICTURE – It is use to reset the
 picture to its original size, color etc.

OUTPUT:  


_________________________________________________________________________

EXERCISE # 14 – using color (font, fill and line color) and using rectangle

Change the paper setup to

Margin  Top - .5”
Left        - .5”
Right       - .5”
Bottom      - .5”

Orientation  Portrait

I. Type the following

II. Insert a rectangle

1. Click the Rectangle Icon   then drag the pointer
   to make a box
2. Drag the box in the text
3. To change the color to transparent click fill
   color drop down list box the icon, then a color
   window will appear, click the no fill.
4. To change the line select or click the
   rectangle then click the line icon then select
   the line style.

III. Change the font color to BLUE

1. To change the font color highlight all the
   fonts then click the drop down list box of the
   font color the click BLUE

SAMPLE OUTPUT


STUDENT EVALUATION FORM


Name of Student ___________________________________________
Course ________________________ Major _____________________


Directions: Check the number that best describes the
student’s performance

Rating: 5 – Excellent 4 – Very Good 3 – Good 2 – Fair 1 – Poor

FIRST SEMESTER/FIRST YEAR        
Subject Code SUBJECTS                  UNITS  GRADE  
Eng113  Communication Arts              3    
Math2   College Algebra                 3    
Fil1    Kasanayan sa Pakikipagtalastasan3    
EDP1    Intro. to Comp. Scie.           6    
CA1     Comp. Architechture             3    
Typing  Basic Typing                    3    
PE1     Self Test Activities            2    
MS11    ROTC                            1.5    

SECOND SEMESTER/FIRST YEAR    
Eng.112 Communication Arts              3    
Fil.2   Panitikang Filipino             3    
Nat.Sci1Physics                         3    
Os101   Operating System                3    
CS101   Data Structure                  6    
PE2     Fundamentals of Rhythmic Act.   2    
MS12    ROTC                            1.5    

FIRST SEMETER/SECOND YEAR    
Eng.213 Technical Writing               3    
Nat.Sci Physics2                        3    
EDP2    Foxbase1                        6    
CA2     Computer Architecture           6    
PE3     Group Sports                    2    
MS 21   ROTC                            1.5    

SECOND SEMESTER/SECOND YEAR   
Eng.223 Business Correspondence         3    
Math3   Plane Trigonometry              3    
EDP3    Foxbase2                        6    
Soc.Sci5Rizal Life,Works,and Writing    3    
HUM     Phil.History                    3    
PE 4    PE 4                            2    
MS 22   ROTC                            1.5 

Syllabus

I. Course Description

Course : Computer Concepts with Fundamentals with Business

Application Software

Course Code :COS 1

No. of Hours : 54

Credit : 3

Prerequisite : 2 units lecture 1 unit laboratory

II. References

III. Instructional Methodologies

1. Lectures

2. Exercises

3. Quizzes

4. Case Study

5. Research

6. Group Project

7. Baby Thesis

8. Term Exam

IV. Grading System

Attendance 10%

Seatwork/Assignments 20%

Quizzes 30%

Term Exams 40%

Grade=((Total x 2)+Term Exam) /3
Final Grade=Prelim Grade+Midterm Grade + Final Grade

V. Course Outline

------------------------PRELIM------------------------

I. Historical Perspective

a. Overview of Computers

b. Classification of Computers

c. Computer Capabilities

d. Computer Limitation

e. Why computer sometimes fails

II. Components of Computer System

a. Overview of computer Bases System

b. Hardware Elements

c. Software Elements

III. Introduction to Windows 98/Windows XP

a. Exploring windows 98/XP Desktop

b. Using Pointing Device

c. Starting and closing a Program

d. Running Multiple Program

e. Switching Between Program

f. Shutting down windows 98/XP

IV. Introduction to Microsoft Word

a. Definition and features

b. The environment of MS word

c. Toolbars/Menus and Icons

d. Working with word document

e. Paragraph Formatting

f. Page Formatting

g. Tables and Columns

h. Special Tools

i. Printing in Word

j. Word Desktop Publishing Techniques

k. Mail Merge and Labels

------------------------MIDTERM------------------------

V. Introduction to Microsoft Excel

a. Definition and Features

b. Getting Started with Excel

c. Toolbars/Menus and Icons

d. Building a worksheet

e. Edition the Worksheet

f. Working with formula

g. Formatting Worksheet

h. Printer

i. Charts

------------------------FINALS------------------------

VI. Introduction to Microsoft Powerpoint

a. Definition and Features

b. Getting started with Powerpoint

c. Toolbars/Menus and Icons

d. The PowerPoint Views

VII. Developing a Presentation

a. Creating a consistent slide

b. Manipulating Objects

c. Entering Text

d. Editing Text

e. Formatting Text

f. Creating a Text Box

g. Indenting Text

h. Setting Tabs

i. Rearranging Slides

j. Understanding Color Scheme

k. Changing the color scheme

l. Applying color to an object

m. Choosing a fill effect

VIII. Animations and Multimedia Objects

a. Setting up a slide show

b. Creating slide transition

c. Adding animation

d. Using specialized animation

e. Coordinating multiple animations

f. Adding Action buttons

g. Adding links to objects

h. Timing a presentation

i. Inserting Multimedia Objects

Assignment #1 (11-13-07)

Deadline Saturday Nov. 17, 2007
A. Give the Meaning
1. ALU
2. BIOS
3. Data
4. Information
5. Analog Computer
6. Digital Computer
7. Hybrid Computer
8. Application Software
9. Operating System
10. General Purpose Computer
11. Special Purpose Computer
13. Main Memory
14. CPU
15. Input Device

B. Essay
1. Discuss the use of computer in Education, Medicine, Industry and Society
2. What are the classifications of computer based on capacity?
3. What are the computer capabilities?

Keyboard Shortcuts

CTRL+C (Copy)
CTRL+X (Cut)
CTRL+V (Paste)
CTRL+Z (Undo)
DELETE (Delete)
SHIFT+DELETE (Delete the selected item permanently without placing the item in the Recycle Bin)
CTRL while dragging an item (Copy the selected item)
CTRL+SHIFT while dragging an item (Create a shortcut to the selected item)
F2 key (Rename the selected item)
CTRL+RIGHT ARROW (Move the insertion point to the beginning of the next word) CTRL+LEFT ARROW (Move the insertion point to the beginning of the previous word) CTRL+DOWN ARROW (Move the insertion point to the beginning of the next paragraph) CTRL+UP ARROW (Move the insertion point to the beginning of the previous paragraph) CTRL+SHIFT with any of the arrow keys (Highlight a block of text)
SHIFT with any of the arrow keys (Select more than one item in a window or on the desktop, or select text in a document)
CTRL+A (Select all)
F3 key (Search for a file or a folder)
ALT+ENTER (View the properties for the selected item)
ALT+F4 (Close the active item, or quit the active program)
ALT+ENTER (Display the properties of the selected object)
ALT+SPACEBAR (Open the shortcut menu for the active window)
CTRL+F4 (Close the active document in programs that enable you to have multiple documents open simultaneously) ALT+TAB (Switch between the open items)
ALT+ESC (Cycle through items in the order that they had been opened)
F6 key (Cycle through the screen elements in a window or on the desktop)
F4 key (Display the Address bar list in My Computer or Windows Explorer)
SHIFT+F10 (Display the shortcut menu for the selected item)
ALT+SPACEBAR (Display the System menu for the active window)
CTRL+ESC (Display the Start menu)
ALT+Underlined letter in a menu name (Display the corresponding menu) Underlined letter in a command name on an open menu (Perform the corresponding command)
F10 key (Activate the menu bar in the active program)
RIGHT ARROW (Open the next menu to the right, or open a submenu)
LEFT ARROW (Open the next menu to the left, or close a submenu)
F5 key (Update the active window)
BACKSPACE (View the folder one level up in My Computer or Windows Explorer)
ESC (Cancel the current task) SHIFT when you insert a CD-ROM into the CD-ROM drive (Prevent the CD-ROM from automatically playing)

DIALOG BOX KEYBOARD SHORTCUTS

CTRL+TAB (Move forward through the tabs)
CTRL+SHIFT+TAB (Move backward through the tabs)
TAB (Move forward through the options)
SHIFT+TAB (Move backward through the options)
ALT+Underlined letter (Perform the corresponding command or select the corresponding option)
ENTER (Perform the command for the active option or button)
SPACEBAR (Select or clear the check box if the active option is a check box) Arrow keys (Select a button if the active option is a group of option buttons)
F1 key (Display Help) F4 key (Display the items in the active list)
BACKSPACE (Open a folder one level up if a folder is selected in the Save As or Open dialog box)
M*CRO$OFT NATURAL KEYBOARD SHORTCUTS

Windows Logo (Display or hide the Start menu)
Windows Logo+BREAK (Display the System Properties dialog box)
Windows Logo+D (Display the desktop)
Windows Logo+M (Minimize all of the windows)
Windows Logo+SHIFT+M (Restore the minimized windows)
Windows Logo+E (Open My Computer)
Windows Logo+F (Search for a file or a folder)
CTRL+Windows Logo+F (Search for computers)
Windows Logo+F1 (Display Windows Help)
Windows Logo+ L (Lock the keyboard)
Windows Logo+R (Open the Run dialog box)
Windows Logo+U (Open Utility Manager)

ACCESSIBILITY KEYBOARD SHORTCUTS

Right SHIFT for eight seconds (Switch FilterKeys either on or off)
Left ALT+left SHIFT+PRINT SCREEN (Switch High Contrast either on or off)
Left ALT+left SHIFT+NUM LOCK (Switch the MouseKeys either on or off)
SHIFT five times (Switch the StickyKeys either on or off)
NUM LOCK for five seconds (Switch the ToggleKeys either on or off)
Windows Logo +U (Open Utility Manager)

WINDOWS EXPLORER KEYBOARD SHORTCUTS

END (Display the bottom of the active window)
HOME (Display the top of the active window)
NUM LOCK+Asterisk sign (*) (Display all of the subfolders that are under the selected folder) NUM LOCK+Plus sign (+) (Display the contents of the selected folder)
NUM LOCK+Minus sign (-) (Collapse the selected folder)
LEFT ARROW (Collapse the current selection if it is expanded, or select the parent folder) RIGHT ARROW (Display the current selection if it is collapsed, or select the first subfolder)

SHORTCUT KEYS FOR CHARACTER MAP

After you double-click a character on the grid of characters, you can move through the grid by using the keyboard shortcuts:

RIGHT ARROW (Move to the right or to the beginning of the next line)
LEFT ARROW (Move to the left or to the end of the previous line)
UP ARROW (Move up one row)
DOWN ARROW (Move down one row)
PAGE UP (Move up one screen at a time)
PAGE DOWN (Move down one screen at a time)
HOME (Move to the beginning of the line)
END (Move to the end of the line)
CTRL+HOME (Move to the first character)
CTRL+END (Move to the last character)
SPACEBAR (Switch between Enlarged and Normal mode when a character is selected)

M*CRO$OFT MANAGEMENT CONSOLE (MMC) MAIN WINDOW KEYBOARD SHORTCUTS

CTRL+O (Open a saved console)
CTRL+N (Open a new console)
CTRL+S (Save the open console)
CTRL+M (Add or remove a console item)
CTRL+W (Open a new window)
F5 key (Update the content of all console windows)
ALT+SPACEBAR (Display the MMC window menu)
ALT+F4 (Close the console)
ALT+A (Display the Action menu)
ALT+V (Display the View menu) ALT+F (Display the File menu)
ALT+O (Display the Favorites menu)

MMC CONSOLE WINDOW KEYBOARD SHORTCUTS
CTRL+P (Print the current page or active pane)
ALT+Minus sign (-) (Display the window menu for the active console window)
SHIFT+F10 (Display the Action shortcut menu for the selected item)
F1 key (Open the Help topic, if any, for the selected item)
F5 key (Update the content of all console windows)
CTRL+F10 (Maximize the active console window)
CTRL+F5 (Restore the active console window)
ALT+ENTER (Display the Properties dialog box, if any, for the selected item)
F2 key (Rename the selected item)
CTRL+F4 (Close the active console window. When a console has only one console window, this shortcut closes the console)

REMOTE DESKTOP CONNECTION NAVIGATION

CTRL+ALT+END (Open the m*cro$oft Windows NT Security dialog box)
ALT+PAGE UP (Switch between programs from left to right)
ALT+PAGE DOWN (Switch between programs from right to left)
ALT+INSERT (Cycle through the programs in most recently used order)
ALT+HOME (Display the Start menu)
CTRL+ALT+BREAK (Switch the client computer between a window and a full screen) ALT+DELETE (Display the Windows menu)
CTRL+ALT+Minus sign (-) (Place a snapshot of the active window in the client on the Terminal server clipboard and provide the same functionality as pressing PRINT SCREEN on a local computer.)
CTRL+ALT+Plus sign (+) (Place a snapshot of the entire client window area on the Terminal server clipboard and provide the same functionality as pressing ALT+PRINT SCREEN on a local computer.)

M*CRO$OFT INTERNET EXPLORER NAVIGATION

CTRL+B (Open the Organize Favorites dialog box)
CTRL+E (Open the Search bar)
CTRL+F (Start the Find utility)
CTRL+H (Open the History bar)
CTRL+I (Open the Favorites bar)
CTRL+L (Open the Open dialog box)
CTRL+N (Start another instance of the browser with the same Web address)
CTRL+O (Open the Open dialog box, the same as CTRL+L)
CTRL+P (Open the Print dialog box)
CTRL+R (Update the current Web page)
CTRL+W (Close the current window)
Alt + All Underlined text menu bar (Open and select the content you want to execute)

Chapter 1

GENERATION OF COMPUTER

1. PRE-COMPUTER ERA - (circa: 1887 –1945)

Marked by the used of electronic-mechanical devices and components. They were designed mainly to perform single tasks and simple arithmetic operations.

2. 1st GENERATION – (circa: 1946 – 1959)

Utilize Vacuum tubes. They require large air-conditioning system because they heat up easily. They are also expensive, relatively slow, unreliable and bulky. These monoliths usually occupy entire rooms and require that the flooring be specially reinforced (heavy), otherwise, they will collapse with their sheer mass and weight.

3. 2nd GENERATION – (circa: 1960 – 1969)

Emergence and use of transistors. They are smaller in physical dimension, require less power to operate, generate less heat, are reliable, and cost less to maintain.

4. 3rd GENERATION – (circa: 1970-1979)

Use of Microelectronic (miniaturized circuits) and/or Integrated Circuits (IC). The LSI (Large-scale Integrated Circuit) and the VLSI (Very Large-scale Integrated Circuit) were also introduced in this era. They are more compact, more efficient, fatsre and more reliable.

5. 4th GENERATION – (circa: 1980 – present)

In this era, the VVLSI (Very, Very Large-scale Integrated Circuit) and the bumble memory were among the very first to be developed and introduced. This era is characterized by the use of dual processors, dual CPUs, fault-tolerant and non-stop system, and vertical recording. Also, in this era, although they have already been long in existence, the radical surge of improvement and development of Telecommunications Interfacing by computers and of Artificial Intelligence (AI) can be observed. Software and system developments also experienced a fantastic boom in every direction.

WHAT IS COMPUTER?

A computer is an electronic device capable of doing arithmetic computation, reading, writing, storing data and even make logical decision. It is composed of hardware and software.

TYPICAL PARTS OF A COMPUTER

1. MONITOR or Cathode ray tube (CRT) – serves as the viewpoint of the computer, because it is here where we see the output of our commands.

2. C.P.U. – The “Brain” of the computer, it is the one that processes all the commands coming from the operator or programmer.

3. KEYBOARD – used to input command or data into the computer.

Computers can be classified into categories based on size and capacity

A. Supercomputers are very fast computers with large memories used in
research laboratories, nuclear weapon development, weather forecasting and aircraft design. It can calculate billions or even trillions of instructions or data per-second.

B. Mainframe computers are large computers with ultimate sophistication,
flexibility and speed and typically used in government agencies, large corporations and computer service organizations. A single mainframe computer can be used simultaneously by many different people working at terminals. It has a large storage capacity and can operate 8-16 million instructions or data per-second.

C. Minicomputers are smaller than mainframe computers but can still support
multiple users. It is widely used in commercial operation, schools, laboratories, airline reservation, banking transactions and inventory control. They can do almost everything that a large computer can do and much lower at cost.

D. Microcomputers, first built in the mid-1970s. This are computer build with
silicon chips where the entire CPU is contained on a single integrated circuit (called a microprocessor). Microcomputers are small enough and inexpensive enough for individuals to be able to afford them. The development of more powerful microprocessor chips has made it possible to steadily increase the speed and memory capacity of microcomputers.

COMPUTER CAPABILITIES

1. Ability to perform certain logic operations
2. Ability to provide new time dimensions
3. Ability to store and retrieve information
4. Ability to control error
5. Ability to check itself

LIMITATION OF COMPUTER (DISADVANTAGES)

1. Inability to generate information
2. A computer cannot correct wrong instructions
3. A computer cannot come out with an original “Decision”
4. Inability to derive meaning from objects

FOUR SUPPORTIVE ELEMENTS OF COMPUTER

1. PROBLEM – a set of instructions or data that is used to find a solution.
2. HARDWARE – refers to the tangible or physical components of a computer, such as monitor, CPU, video card, printer, plotter, speakers, mouse etc.
3. SOFTWARE – this are programs designed to manipulate the computer or set of instructions or commands for the computer to follow.
4. Programmer/Operator – This refers to the person responsible in the operation or maintenance of a personal computer and he/she is the one that creates the programs or software.