Thursday, November 15, 2007

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 1st2nd3rd4th5th6th7th8th9th10th
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




Tuesday, November 13, 2007

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

Monday, November 12, 2007

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.