Please click this link : https://docs.google.com/forms/d/1F8Nzaiq0qKotQnz_MTnicXls45V-nGvD1a2u-N4rlTw/viewform?c=0&w=1
Wednesday, September 24, 2014
Evaluation Form Link
Please click this link : https://docs.google.com/forms/d/1F8Nzaiq0qKotQnz_MTnicXls45V-nGvD1a2u-N4rlTw/viewform?c=0&w=1
Wednesday, September 3, 2014
Word Processing Activity 6
WORD PROCESSING
ACTIVITY
6
What you will
practice or learn:
Ø Moving blocks of text using drag and drop or cut and paste
Ø Review of Fairytales!
Ø Adding clip art (find the text doggie!)
Ø
Changing
margins
Ø
Line
Spacing
DIRECTIONS:
1. Open a Word Document. Go to
File - Page Set-up and change the margins to 1.5” on all sides.
2. Set the font size to 16 point.
3. Type your name. Hit Enter. Type Activity 6. Hit Enter twice.
4. Type the following mixed-up quotes from fairytales as shown below:
(If
you type the a. to begin the first
sentence, the computer will automatically letter each one as you go.) Don’t
forget to use quotation marks (Left of the Enter key)
a. Little Red Riding Hood said, “I am bruised all over from that bed.”
b. The giant said, “Grandmother, what big eyes you have!”
c. The princess said, “Not by the hair of my chinny chin chin.”
d. The fairy godmother said, “Fe Fi Fo Fum. I smell the blood of an
Englishman.”
e. The little pig said, “Someone’s been sleeping in my bed.”
f.
Papa Bear said, “You must be home by
midnight.”
5. Now take each quote and put the correct saying with the correct person
who said it. Use drag and drop or cut
and paste. (To drag, select words to move, left click on it and HOLD it down
while dragging the words to a new location.)
6. Select the whole block of quotes.
Go To Format – Paragraph. In the
middle of the window, find LINE SPACING.
Hit the down arrow, and click on Double. There is also a Line Spacing Icon on the row
of buttons. Can you find it?
7. Add a piece of clip art to illustrate each one of the fairytales. Insert the clipart next to the appropriate
fairytale text in either the right or left margin. The pictures will have to be sized
smaller. You must remember to “text
doggie” on “behind text” from the picture toolbar or you won’t be able to move
the picture after inserting it. Using “Behind Text” means the picture will not
disrupt the writing.
Monday, August 25, 2014
Word Processing Activity 5
Skills to review or learn:
· Using the TAB key
· Setting margins
· Changing font size, style
· Using bold, italic, and underline
· Adding clip art
DIRECTIONS:
1. Open a new Word document. Change the margins to .5” on both sides. (That’s ½”, NOT 5 inches!) Change the font size to 16 point.
2. Type your name. Hit ENTER once. Type Activity 5. Hit ENTER twice.
3. Type the word Character. Hit TAB three times. Type the word Movie. Hit TAB five times. Type the word Description. Hit ENTER twice.
4. Using the same format as in #3, type in the following information using the TAB key between sections. Hit ENTER only once between each line (single spacing).
You may have to adjust the number of times you hit TAB to line up each column.
Yoda Return of the Jedi Jedi Master
Luke Skywalker A New Hope Son of Darth Vader
Hans Solo Return of the Jedi Intergalactic Smuggler
Padme Amidala The Phantom Menace Queen of Naboo
5. Underline and Bold the words Character, Movie, and Description.
6. Italicize the Movie Titles in the center column.
7. Add a clip art picture of a space ship at the bottom of the page.
8. Save as Activity 5
http://rembold-dawg.weebly.com/microsoft-word-activities.html
· Using the TAB key
· Setting margins
· Changing font size, style
· Using bold, italic, and underline
· Adding clip art
DIRECTIONS:
1. Open a new Word document. Change the margins to .5” on both sides. (That’s ½”, NOT 5 inches!) Change the font size to 16 point.
2. Type your name. Hit ENTER once. Type Activity 5. Hit ENTER twice.
3. Type the word Character. Hit TAB three times. Type the word Movie. Hit TAB five times. Type the word Description. Hit ENTER twice.
4. Using the same format as in #3, type in the following information using the TAB key between sections. Hit ENTER only once between each line (single spacing).
You may have to adjust the number of times you hit TAB to line up each column.
Yoda Return of the Jedi Jedi Master
Luke Skywalker A New Hope Son of Darth Vader
Hans Solo Return of the Jedi Intergalactic Smuggler
Padme Amidala The Phantom Menace Queen of Naboo
5. Underline and Bold the words Character, Movie, and Description.
6. Italicize the Movie Titles in the center column.
7. Add a clip art picture of a space ship at the bottom of the page.
8. Save as Activity 5
http://rembold-dawg.weebly.com/microsoft-word-activities.html
Word Processing Activity 4
What you will practice or learn:
1) Font Effects
2) Alignment
3) Line Spacing
4) Numbering
DIRECTIONS:
Open a Word Document. Type your name. Hit ENTER
once. Type Activity 4. Hit ENTER twice.
Change to any BASIC font (no cursive), size 14 point.
Type the following title and paragraphs as written (use word wrap).
Amelia Island
While a remote tropical isle may be the ultimate winter escape, you need only head to the northeasternmost tip of Florida for an unspoiled, unpretentious refuge. Framed by 40-foot dunes, Amelia Island’s white sand beaches are remarkably uncrowded in mid-winter, in contrast to their more southerly counterparts.
You’ll also find plenty of fishing – on the island and offshore – bird watching, and horseback riding, and about 120 holes of that famous Sunshine State golf. At sunset, make your way to the downtown docks for the shrimp fleet’s return to Fernandina Harbor.
Hit ENTER twice. Type the following list of big words used in these paragraphs:
Remote
Unpretentious
Contrast
Counterparts
Southerly
5. Center the title Amelia Island and increase it to size 18 font. Hit ENTER again.
6. RIGHT Align the first paragraph. (You must highlight the paragraph first)
7. JUSTIFY the alignment in the second paragraph.
8. Highlight both paragraphs. Go to FORMAT – PARAGRAPH. Find LINE SPACING in the middle of the window and change from single space to 1.5 spacing.
9. Go to FORMAT – FONT. Change the font effects of each word in the list as follows: (Effects are found in the middle of the window. Effects are NOT the font style!)
Remote – Change to red font color
Unpretentious – Strikethrough
Contrast – Small Caps
Counterparts – Outline
Southerly – Underline with a dotted line
10. Highlight the whole list of words. Go to FORMAT – BULLETS & NUMBERING. Click on Numbering and select a style of numbering for your list.
11. SAVE as Activity 4 ex. (Activity4_John Brixton).
http://rembold-dawg.weebly.com/microsoft-word-activities.html
1) Font Effects
2) Alignment
3) Line Spacing
4) Numbering
DIRECTIONS:
Open a Word Document. Type your name. Hit ENTER
once. Type Activity 4. Hit ENTER twice.
Change to any BASIC font (no cursive), size 14 point.
Type the following title and paragraphs as written (use word wrap).
Amelia Island
While a remote tropical isle may be the ultimate winter escape, you need only head to the northeasternmost tip of Florida for an unspoiled, unpretentious refuge. Framed by 40-foot dunes, Amelia Island’s white sand beaches are remarkably uncrowded in mid-winter, in contrast to their more southerly counterparts.
You’ll also find plenty of fishing – on the island and offshore – bird watching, and horseback riding, and about 120 holes of that famous Sunshine State golf. At sunset, make your way to the downtown docks for the shrimp fleet’s return to Fernandina Harbor.
Hit ENTER twice. Type the following list of big words used in these paragraphs:
Remote
Unpretentious
Contrast
Counterparts
Southerly
5. Center the title Amelia Island and increase it to size 18 font. Hit ENTER again.
6. RIGHT Align the first paragraph. (You must highlight the paragraph first)
7. JUSTIFY the alignment in the second paragraph.
8. Highlight both paragraphs. Go to FORMAT – PARAGRAPH. Find LINE SPACING in the middle of the window and change from single space to 1.5 spacing.
9. Go to FORMAT – FONT. Change the font effects of each word in the list as follows: (Effects are found in the middle of the window. Effects are NOT the font style!)
Remote – Change to red font color
Unpretentious – Strikethrough
Contrast – Small Caps
Counterparts – Outline
Southerly – Underline with a dotted line
10. Highlight the whole list of words. Go to FORMAT – BULLETS & NUMBERING. Click on Numbering and select a style of numbering for your list.
11. SAVE as Activity 4 ex. (Activity4_John Brixton).
http://rembold-dawg.weebly.com/microsoft-word-activities.html
Word Processing Activity 3
What you will learn or practice:
· Setting Margins
· Changing font size
· Changing alignment
· Using bold print
· Typing a paragraph with word wrap
· Spell checking
· Copy and paste
DIRECTIONS:
1. Open a Word document. Click on FILE- PAGE SET-UP. Change the margins to the following: top and bottom = 2 inches, left and right = 2 inches. Click on OK.
2. Change the font to Lucida Console, size 14 point, and type your name.
3. Change your name to bold print.
4. Center your name horizontally between the margins. (CENTER ALIGN)
5. Press the ENTER key once. Take OFF bold print.
6. Type Activity 3. Press the ENTER key twice.
7. Change the font to Times New Roman, size 12 point.
8. Change to LEFT ALIGN.
9. Type the paragraph below, with errors included, using word wrap (Do not hit enter at end of line). The computer may automatically correct some of your errors. That’s ok. Hit ENTER when you are all done with the paragraph.
Did you spel this correctly? The spell checker may notice double
words. Proper names such as as George, Tom, and Leessa may
cause the spell checkr to display a message. You may be able to
use a suggest buton so that you do not have to type each corection.
10. Use the spell checker to check for errors. Every red underlined word shows a potential error. Place the cursor on the word and right click. The computer will give you suggestions for changes. Click on the correct change. Another way to spell check is to click on the ABC icon on the Menu Bar with the checkmark OR click on Tools-Spelling and Grammar from the Menu Bar. Put cursor at end of paragraph. Hit ENTER twice.
11. Change to size 14 point. Type your first, middle, and last name.
12. Select your name. Copy and paste your name four MORE times, so you end up with a LIST of five times. There are three ways to copy and paste:
· Edit – Copy – Paste.
· Control-C for Copy and Control-V for paste.
· Mouse Right click – copy, mouse right click –paste.
13. Change each version of your name in the list to a different font and a different size.
14. Save as Activity 3 and write your fullname ex. (Activity 3_John Brixton).
· Setting Margins
· Changing font size
· Changing alignment
· Using bold print
· Typing a paragraph with word wrap
· Spell checking
· Copy and paste
DIRECTIONS:
1. Open a Word document. Click on FILE- PAGE SET-UP. Change the margins to the following: top and bottom = 2 inches, left and right = 2 inches. Click on OK.
2. Change the font to Lucida Console, size 14 point, and type your name.
3. Change your name to bold print.
4. Center your name horizontally between the margins. (CENTER ALIGN)
5. Press the ENTER key once. Take OFF bold print.
6. Type Activity 3. Press the ENTER key twice.
7. Change the font to Times New Roman, size 12 point.
8. Change to LEFT ALIGN.
9. Type the paragraph below, with errors included, using word wrap (Do not hit enter at end of line). The computer may automatically correct some of your errors. That’s ok. Hit ENTER when you are all done with the paragraph.
Did you spel this correctly? The spell checker may notice double
words. Proper names such as as George, Tom, and Leessa may
cause the spell checkr to display a message. You may be able to
use a suggest buton so that you do not have to type each corection.
10. Use the spell checker to check for errors. Every red underlined word shows a potential error. Place the cursor on the word and right click. The computer will give you suggestions for changes. Click on the correct change. Another way to spell check is to click on the ABC icon on the Menu Bar with the checkmark OR click on Tools-Spelling and Grammar from the Menu Bar. Put cursor at end of paragraph. Hit ENTER twice.
11. Change to size 14 point. Type your first, middle, and last name.
12. Select your name. Copy and paste your name four MORE times, so you end up with a LIST of five times. There are three ways to copy and paste:
· Edit – Copy – Paste.
· Control-C for Copy and Control-V for paste.
· Mouse Right click – copy, mouse right click –paste.
13. Change each version of your name in the list to a different font and a different size.
14. Save as Activity 3 and write your fullname ex. (Activity 3_John Brixton).
Word Processing Activity 2
What you will practice:
· Creating a centered list
· Using the horizontal centering command
· Using bold, italic, and underline features
· Changing font and font size
DIRECTIONS:
1. Open a new Word document. Change to Arial, Size 12, and type your name. Hit ENTER one time.
2. Type Activity 2. Hit ENTER two times.
3. Change the alignment to CENTER. (Alignment icons at the top of the screen in the menu bars. ) READ THROUGH THE DIRECTIONS BEFORE CONTINUING!
4. In a list form, type the words on the left side where it says “What to Type”. Use Upper and Lower case letters as shown in the sample. Press the ENTER key at the end of each line (twice when a blank line is indicated.) DO NOT TYPE THE WORDS “BLANK LINE”!!!
5. Change the font sizes and special formats as shown in the right column. Check the sample on the back side frequently.
6. Save as Activity 2 and write your fullname ex. (Activity 2_John Brixton).
WHAT TO TYPE: HOW TO TYPE IT
EXERCISES Size 24 point, bold, all caps.
Blank line
Monday Size 20, underline
Blank line
Chest Size 16, italic and bold
Blank line
Bench Press Size 14
Push-ups Size 14
Flies Size 14
Blank line
Abdomen Size 16, italic and bold
Blank line
Negative sit-up Size 14
Crunch Size 14
Hip lift Size 14
Blank line
Wednesday Size 20, underline
Blank line
Back Size 16, italic and bold
Blank line
Lateral raise Size 14
Rowing Size 14
(http://rembold-dawg.weebly.com/microsoft-word-activities.html)
· Creating a centered list
· Using the horizontal centering command
· Using bold, italic, and underline features
· Changing font and font size
DIRECTIONS:
1. Open a new Word document. Change to Arial, Size 12, and type your name. Hit ENTER one time.
2. Type Activity 2. Hit ENTER two times.
3. Change the alignment to CENTER. (Alignment icons at the top of the screen in the menu bars. ) READ THROUGH THE DIRECTIONS BEFORE CONTINUING!
4. In a list form, type the words on the left side where it says “What to Type”. Use Upper and Lower case letters as shown in the sample. Press the ENTER key at the end of each line (twice when a blank line is indicated.) DO NOT TYPE THE WORDS “BLANK LINE”!!!
5. Change the font sizes and special formats as shown in the right column. Check the sample on the back side frequently.
6. Save as Activity 2 and write your fullname ex. (Activity 2_John Brixton).
WHAT TO TYPE: HOW TO TYPE IT
EXERCISES Size 24 point, bold, all caps.
Blank line
Monday Size 20, underline
Blank line
Chest Size 16, italic and bold
Blank line
Bench Press Size 14
Push-ups Size 14
Flies Size 14
Blank line
Abdomen Size 16, italic and bold
Blank line
Negative sit-up Size 14
Crunch Size 14
Hip lift Size 14
Blank line
Wednesday Size 20, underline
Blank line
Back Size 16, italic and bold
Blank line
Lateral raise Size 14
Rowing Size 14
(http://rembold-dawg.weebly.com/microsoft-word-activities.html)
Word Processing Activity 1
What you will learn:
Changing font and size
Changing alignment
Using bold and underlining
Typing using word wrap (soft return)
DIRECTIONS:
1. Open a blank Word document.
2. Change to Arial style font, size 14. (Font style and size are located in the upper tool bar.)
3. Type your name (first and last). Hit ENTER once.
4. Type Activity 1. Press ENTER key two times.
5. Type the name of your school in a different font and use size 18 point. Press ENTER key two times.
6. Change the font to Times New Roman size 16.
7. Type the following paragraph using word wrap. Word wrap means you DO NOT hit the enter key at the end of a line. Let the computer move to the next line when it is ready. Do not indent. At the end of each paragraph, press the ENTER key two times.
Master Yoda says that fear is the path to the dark side. Fear leads to anger. Anger leads to hate. Hate leads to suffering. Master Yoda is very smart.
Emperor Palpatine said that a Jedi gains power through understanding and a Sith gains understanding through power.
8. Type your name once again. Underline it. Italicize it. Bold it.
9. Change the first paragraph to right alignment. (Alignment icons are to the right of B I U series.) Hold your cursor on top of them to read which one is which.)
10. Change the second paragraph to justified alignment.
11. Center your name at the bottom using the centering alignment icon.
12. Make the school name Bold. (Use the B icon.).
13. Turn page over and proofread your assignment activity.
14. Save as Activity 1 and write your fullname ex. (Activity 1_John Brixton).
(http://rembold-dawg.weebly.com/microsoft-word-activities.html)
Tuesday, July 8, 2014
Excel Quiz 1
Instructions:
1. Type in all text and numbers shown in the spreadsheet.
2. Format numbers with no decimal places.
3. Create a formula that calculates the cost for each items.
4. Create a formula that calculates the total cost, average total cost and percentage cost.
Friday, July 4, 2014
Monday, March 17, 2014
GRADE ANNOUNCEMENT
To all my bcs 111 and 112 students. Sorry for not uploading your grades here in our blog, there seems to be a problem when uploading large images. On the other hand, you can now visit me in the Information and Publicity Office (IPO) to check for your grades. Grades for BCS 112 and BCS111 sat 8-11 and 1-4 pm are already done while for BCS111 8-9PM and TTH 7-8:30PM is will be reviewed. Please visit me before Friday march 21, 2014 is the submission of grades to the registrars office. Thank you and God Bless!
Friday, February 14, 2014
MS Word Activity 1 - 4
Exercise1 - Working with
Font size, colors and faces
1. Type your first and last name.
2. Select your whole name.
3. Change the font color to blue.
4. Change the font to “Lucinda Handwriting.”
5. Change the font size to 72.
6. Type your street address.
7. Select your address.
8. Change the color of your address to red and the font size to 18.
9. Change the font of your address to “Tahoma”.
Exercise 3 - Working with
Text & Images (Text Wrapping)
1. Look for any picture
Font size, colors and faces
1. Type your first and last name.
2. Select your whole name.
3. Change the font color to blue.
4. Change the font to “Lucinda Handwriting.”
5. Change the font size to 72.
6. Type your street address.
7. Select your address.
8. Change the color of your address to red and the font size to 18.
9. Change the font of your address to “Tahoma”.
Exercise 2 – Working with
Alignments
Alignments
For this activity you may be required to search in the internet.
1.Prepare a three paragraph story:
2. 1st paragraph should be align left.
3. 2nd paragraph should be align center.
4. 3rd paragraph should be align right.
1.Prepare a three paragraph story:
2. 1st paragraph should be align left.
3. 2nd paragraph should be align center.
4. 3rd paragraph should be align right.
Text & Images (Text Wrapping)
1. Look for any picture
2. Paste it into your document and format it as a background image of your contents.
Friday, February 7, 2014
Activity - 1 - Internet Search
1. Create your own email address(if you have not created your email account). Write your EMAIL ADDRESS only on a separate sheet of paper. Please follow the standard format for your email address.
2. Visit at least 5 Websites and get the following details:
a. What search engine you use for searching?
b. Get the URL or the Website address.(ex.http://www.google.com)
c. Brief information about the website (at least two sentences.)
2. Visit at least 5 Websites and get the following details:
a. What search engine you use for searching?
b. Get the URL or the Website address.(ex.http://www.google.com)
c. Brief information about the website (at least two sentences.)
Monday, December 16, 2013
MS Word Exercise - 4
ACTIVITY 3: WORKING
WITH TABLES
TABLE 1.
NAME
|
ADDRESS
|
NUMBER
|
TABLE 2.
Mike’s Lunch Bar
|
||||
ITEM NO.
|
LUNCH ITEMS
|
UNIT SOLD
|
UNIT PRICE
|
SALES
|
1
|
SANDWICHES
|
2,300
|
$ 2.50
|
|
2
|
MEAT PIES
|
1,100
|
$ 2.50
|
|
3
|
MACARONI
|
3,600
|
$ 5.50
|
|
TABLE 3.
CLASSIFICATION OF COMPUTERS
|
|
 |
A PC can be defined as a small, relatively inexpensive computer
designed for an individual user. PCs are based on the microprocessor
technology that enables manufacturers to put an entire CPU on one chip.
Businesses use personal computers for word processing, accounting, desktop
publishing, and for running spreadsheet and database management applications.
At home, the most popular use for personal computers is for playing games and
surfing the Internet.
|
 |
Workstation is a computer used for engineering applications
(CAD/CAM), desktop publishing, software development, and other such types of
applications, which require a moderate amount of computing power and
relatively high quality graphics capabilities.
|
TABLE 4.
CREATE AN
ADDRESS BOOK CONTAINING PICTURE, FAMILY NAME, FIRST NAME, ADDRESS, EMAIL, PHONE
NUMBER OF THE RECEPIENT.
TABLE 5.
CREATE A
CALENDAR OF YOUR ACTIVITIES FOR THE
MONTH OF DECEMBER.
Sunday, December 8, 2013
MS Word Exercise - 3
Creating a Flyer with Word
Purpose
In this tutorial sheet you will learn how to create a flyer with Word. More specifically, you will learn how to:
Use WordArt
Insert an image
Insert a text box
Draw a picture using drawing tools
Overview
WordArtInserting an image
Inserting a text box
Using drawing tools
Theme to incorporate "Christmas Celebration"
Examples:
http://www.musthavemenus.com/imageservice/images/13/1291409517185_110/img_large_watermarked.jpg
http://images.sharefaith.com/images/3/1255047011348_194/img_page-01.jpg
http://images.sharefaith.com/images/3/1255047308779_195/img_page-01.jpg
MS Word Exercises - 1
Objectives:
The
learner will be able to:
1. Find and use the Insert Clip Art command
at least 75% of the time
2.
Select and resize a picture using the picture handles
3.
Use the alignment buttons to center and left align text and pictures
4.
Insert a Date and Time Text field from the Insert Menu
Create a Business
Letter
A “Corporate
Stripe” is a set of documents that have the company logo, fonts, and styles.
This exercise allows you to practice formatting text and pictures while you
create a business letter.
Type
the company name and address
Open a blank Microsoft Word
document. Type the following
information:
Computers Are Us
555 Main Street
Brighton, MI 48116
(810) 555-1212
Select All of the text and use the Font
options to format the type:
Tahoma,
12 point, bold, centered, and dark red
Select the first line of type and make it
14 point.
Insert a Picture from ClipArt
Go to Clips Online, the Microsoft Design
Gallery
Search for a photo or cartoon of a computer
Select two or three images and Download them
Use one of the pictures for a company logo
Resize the picture
Center it above the Company name and
address
Insert the Date and Time
Remember, the default Date and Time
updates automatically. This option is not appropriate for medical or legal
documents that must be date/time stamped, but is fine for this exercise.
Type a sample business letter:
Dear Sir,
Thank you for your order, yesterday. We
will be shipping your parts by FedX ground.
Sincerely,
Your Name
Save your practice document and name it: Beginning Word Practice 1. Save it to your flash drive or in your e-mail.
Tuesday, September 24, 2013
Introduction to Powerpoint
Microsoft Powerpoint 2007
- A Power Point is designed to help you achieve a consistent look in your slide presentations.
- You want your audience to focus on the message and not be distracted by poor and inconsistent design from one slide to the next.
- You can achieve this consistency by using Templates, or pre-designed slide presentations, that coordinate background colors and designs, font styles and placement, and other graphic design elements.
- Through a Power Point presentation, you as a trainer have the power to control the subject and also ensure that the audience sees what you want them to see and agree with your perspectives and your points of view
For Complete Reference Please Visit This link:
Introduction to Excel
What is a Spreadsheet?
A spreadsheet is the computer equivalent of a paper ledger sheet.
It consists of a grid made from columns and rows.
It is an environment that can make number manipulation easy and somewhat effortless.
Types of Spreadsheets:
Manual – creating a worksheet on a ledger
or columnar paper using a pencil/pen,
calculator, and eraser.
Electronic – A computer-generated
spreadsheet that makes the basic tasks much easier.
Spreadsheets are made up of :
columns – identified with alphabetic headings
rows - identified with numeric headings
and their intersections are called cells
(Cell references: B4, A20)
In each cell there may be the following types of data:
text (labels)
number data (constants)
formulas (mathematical equations that do all the work)
Formulas ALWAYS begin with an = sign. This “tells” Excel that a calculation will need to be performed.
Reference cells, NOT the numbers in them!
There are two ways to enter information into a cell:
1. Type directly into the cell.
Click on a cell, and type in the data (numbers or text) and press Enter.
2. Type into the formula bar.
Click on a cell, and then click in the formula bar. Now type the data into the bar and press Enter.
Microsoft Excel 2007 Window
Microsoft Excel is an electronic spreadsheet.
- You can use it to organize your data into rows and columns.
- You can also use it to perform mathematical calculations quickly.
Microsoft Office Button
When you click the button, a menu appears.
You can use the menu to create a new file,
open an existing file, save a file, and perform many other tasks.
Quick Access Toolbar
provides you with access to commands you frequently use.
By default, Save, Undo, and Redo appear on the Quick Access toolbar.
You use Save to save your file, Undo to rollback an action you have taken,
and Redo to reapply an action you have rolled back.
Title Bar
The Title bar displays the name of the workbook on
which you are currently working. Microsoft Excel
displays the name of the workbook you are currently using.
At the top of the Excel window, you should see
"Microsoft Excel - Book1" or a similar name.
Ribbon
Microsoft Excel 2007, you use the Ribbon to issue commands.
At the top of the Ribbon are several tabs;
clicking a tab displays several related command groups.
Within each group are related command buttons.
You click buttons to issue commands or to access
menus and dialog boxes. You may also find a dialog box
launcher in the bottom-right corner of a group. When you
click the dialog box launcher, a dialog box makes additional
commands available.
Cells
The combination of a column coordinate and a
row coordinate make up a cell address.
For example, the cell located in the upper-left
corner of the worksheet is cell A1, meaning column A, row 1.
Formula Bar
If the Formula bar is turned on, the cell
address of the cell you are in displays
in the Name box which is located on the left side of
the Formula bar. Cell entries display on the right side
of the Formula bar. Note: The current cell address displays
on the left side of the Formula bar.
Status Bar
Display information such as the sum, average, minimum, and maximum value of selected numbers. You can change what displays on the Status bar by right-clicking on the Status bar and selecting the options you want from the Customize Status Bar menu. You click a menu item to select it. You click it again to deselect it. A check mark next to an item means the item is selected.
For Complete reference please visit this link:
http://www.baycongroup.com/el0.htm
A spreadsheet is the computer equivalent of a paper ledger sheet.
It consists of a grid made from columns and rows.
It is an environment that can make number manipulation easy and somewhat effortless.
Types of Spreadsheets:
Manual – creating a worksheet on a ledger
or columnar paper using a pencil/pen,
calculator, and eraser.
Electronic – A computer-generated
spreadsheet that makes the basic tasks much easier.
Spreadsheets are made up of :
columns – identified with alphabetic headings
rows - identified with numeric headings
and their intersections are called cells
(Cell references: B4, A20)
In each cell there may be the following types of data:
text (labels)
number data (constants)
formulas (mathematical equations that do all the work)
Formulas ALWAYS begin with an = sign. This “tells” Excel that a calculation will need to be performed.
Reference cells, NOT the numbers in them!
There are two ways to enter information into a cell:
1. Type directly into the cell.
Click on a cell, and type in the data (numbers or text) and press Enter.
2. Type into the formula bar.
Click on a cell, and then click in the formula bar. Now type the data into the bar and press Enter.
Microsoft Excel 2007 Window
Microsoft Excel is an electronic spreadsheet.
- You can use it to organize your data into rows and columns.
- You can also use it to perform mathematical calculations quickly.
Microsoft Office Button
When you click the button, a menu appears.
You can use the menu to create a new file,
open an existing file, save a file, and perform many other tasks.
Quick Access Toolbar
provides you with access to commands you frequently use.
By default, Save, Undo, and Redo appear on the Quick Access toolbar.
You use Save to save your file, Undo to rollback an action you have taken,
and Redo to reapply an action you have rolled back.
Title Bar
The Title bar displays the name of the workbook on
which you are currently working. Microsoft Excel
displays the name of the workbook you are currently using.
At the top of the Excel window, you should see
"Microsoft Excel - Book1" or a similar name.
Ribbon
Microsoft Excel 2007, you use the Ribbon to issue commands.
At the top of the Ribbon are several tabs;
clicking a tab displays several related command groups.
Within each group are related command buttons.
You click buttons to issue commands or to access
menus and dialog boxes. You may also find a dialog box
launcher in the bottom-right corner of a group. When you
click the dialog box launcher, a dialog box makes additional
commands available.
Cells
The combination of a column coordinate and a
row coordinate make up a cell address.
For example, the cell located in the upper-left
corner of the worksheet is cell A1, meaning column A, row 1.
Formula Bar
If the Formula bar is turned on, the cell
address of the cell you are in displays
in the Name box which is located on the left side of
the Formula bar. Cell entries display on the right side
of the Formula bar. Note: The current cell address displays
on the left side of the Formula bar.
Status Bar
Display information such as the sum, average, minimum, and maximum value of selected numbers. You can change what displays on the Status bar by right-clicking on the Status bar and selecting the options you want from the Customize Status Bar menu. You click a menu item to select it. You click it again to deselect it. A check mark next to an item means the item is selected.
For Complete reference please visit this link:
http://www.baycongroup.com/el0.htm
Computer Networks
What is a Network?
Network: A connected system of objects or people
Computer network: A collection of computers and other hardware devices connected together so that users can share hardware, software, and data, as well as electronically communicate with each other.
Internet: Largest computer network in the world
Types of networks:
Business networks,
Phone networks,
Home
Multimedia networks
Common Uses for Computer Networks
1. Sharing a printer or an Internet Connection among several users.
2. Sharing application software with a network license, which can be purchased less expensively and which needs to be installed and updated on only one computer.
3. Working collaboratively, such as sharing a company database or using a collaboration tools to create or review documents.
4. Exchanging files among network users and over the internet
5. Connecting the home computers and the entertainment devices, (such as TVs, gaming consoles, and stereo systems) located within a home.
Networking and Communications Applications:
1. Global positioning system (GPS): Uses satellites and a receiver to the exact geographic location of the receiver
a. Commonly found in cars today
b. Available as handheld units
c. Used by the military, hikers, travelers, and others who need to know their precise
2. Videoconferencing: Use of communications technology for real-time, face-to-face meetings between individuals located in different places
a. Technology continues to improve and mimic reallife environments
b. Telepresence videoconferenceing
c. Online conferencing ( via the Internet)
d. Video phone calls
Types of Network Topology: How the devices in the network (called nodes) are arranged
1. Star networks: All devices connect to a central device or hub)
- All computers/devices connect to a central device called hub or switch.
- Each device requires a single cable
- Point-to-point connection between the device and hub.
- Most widely implemented
- Hub is the single point of failure
2. Bus networks: All devices connect to a central cable
- Uses a trunk or backbone to which all of the computers on the network connect.
- Systems connect to this backbone using T connectors or taps.
- Coaxial cablings ( 10Base-2, 10Base5) were popular options years ago.
3. Ring networks: Devices connect to one another in a ring
a. Logical ring
-Meaning that data travels in circular fashion from one computer to another on the network.
- Ring networks are most commonly wired in a star configuration
- Token Ring has multi-station access unit (MSAU),equivalent to hub or switch. MSAU performs the token circulation internally.
4. Mesh networks: Multiple connections between devices
- Each computer connects to every other.
- High level of redundancy.
- Rarely used.
- Wiring is very complicated
- Cabling cost is high
- Troubleshooting a failed cable is tricky
- A variation hybrid mesh
- create point to point connection between specific network devices, often seen in WAN
implementation.
5. Some networks use a combination of topologies
Internet Terms to be Familiar with:
Browser - Contains the basic software you need in order to find, retrieve, view, and send information over the Internet.
Download - To copy data from a remote computer to a local computer.
Upload - To send data from a local computer to a remote computer.
E-mail - (electronic mail) is the exchange of computer-stored messages by telecommunication. E-mail can be distributed to lists of people as well as to individuals. However, you can also send non-text files, such as graphic images and sound files, as attachments sent in binary streams.
Home Page - The beginning "page" of any site.
HTML (HyperText Markup Language) - The coding language used to create documents for use on the World Wide Web. There are three-letter suffixes used in coding that help to identify the type location one is viewing
HTTP (HyperText Transport Protocol) - the set of rules for exchanging files (text, graphic images, sound, video, and other multimedia files) on the World Wide Web. Relative to the TCP/IP suite of protocols (which are the basis for information exchange on the Internet), HTTP is an application protocol.
¨Search Engine - A web server that collects data from other web servers and puts it into a database (much like an index), it provides links to pages that contain the object of your search.
TCP/IP - TCP/IP (Transmission Control Protocol/Internet Protocol) is the basic communication language or protocol of the Internet. It can also be used as a communications protocol in a private network (either an intranet or an extranet). When you are set up with direct access to the Internet, your computer is provided with a copy of the TCP/IP program just as every other computer that you may send messages to or get information from also has a copy of TCP/IP.
URL (Uniform Resource Locator) - The Internet address. The prefix of a URL indicates which area of the Internet will be accessed. URLs look differently depending on the Internet resource you are seeking.
WWW (World Wide Web) - A technical definition of the World Wide Web is: all the resources and users on the Internet that are using the Hypertext Transfer Protocol (HTTP).
Internet
- An information system
- Communication tool
- A large network of computer systems world wide can be explored by using a Web Browser
- Services available through the Internet:
- Email (Discussion groups,Chat Rooms, etc.)
- Information search (including research)
- Education (Online courses; virtual colleges)
- Entertainment, News, and more…...
Evolution of the Internet
ARPANET: The predecessor of the Internet, named after the Advanced Research Projects Agency (ARPA), which sponsored its development
- Initially connected four supercomputers
- Eventually grew into today’s Internet
The World Wide Web: The collection of Web pages available through the Internet
- Proposed by Tim Berners-Lee in 1989
- Originally only text-based content
- Release of the graphical Mosaic browser in 1993 led to graphical content
- Wide variety of content available via Web pages today
Internet: Researches advanced Internet applications and technologies
Web Browsers
- You use this software to view different locations on the Web, which are known as Web pages. A group of Web pages is a Web site. The first page of a Web site is often called the home page.
- Software programs used to access the World Wide Web (WWW)
- Most popular web browsers:
a. Google Chrome
b. Microsoft Internet Explorer
c. Mozilla Firefox
d. Apple Safari
Search Engines
- A program that connects you to a database or Web address
- used to perform a thorough search
- Some Popular Search Engines
- Google search, Alta Vista, Excite, Hotbot, Lycos, InforSeek, etc.
- Random Browsing (takes too much time)
- Mark Favorite Sites (bookmark the sites)
- Use several Search Engines for a thorough search
Some Well Known Search Engines
- Yahoo! Search
www.yahoo.com
- Google Search
www.google.com
- Bing ”Live Search, Windows Live Search, and MSN Search”
www.bing.com
Email
- E-mail stands for Electronic Mail.
- It is one of the most widely used features of the Internet.
- Mails are regularly used today where with the help of postage stamp we can transfer mails anywhere in the world.
- With electronic mail the service is similar but here data are transmitted through Internet and therefore within minutes the message reaches the destination anywhere in the world.
Email Components
- You may have an e-mail account through a business network or you may create an e-mail account with a service that provides Internet access.
- An e-mail address consists of:
a. A user name or login ID
b. The “at” symbol (@)
c. The name of the e-mail server
Understanding Email
- E-mail, or electronic mail, is an efficient way to exchange messages with others on a network.
- This network may be small and self-contained, such as within an office, or as large as the Internet.
- E-mail messages can go to only one recipient or to dozens of recipients at once.
- When you send a message, it travels through the network to an e-mail server.
- The e-mail server stores messages until the recipient(s) request them.
Web Address (URLs)
- Each computer on the Internet has an unique identification number, called an IP (Internet Protocol) address.
- Each part of the address is a number ranging from 0 to 255, and each part is separated from the previous
part by a period, for example: 106.29.242.17.
- Although each computer connected to the Internet has a unique IP address, most Web browsers use domain name addressing to locate Web sites and pages.
Network: A connected system of objects or people
Computer network: A collection of computers and other hardware devices connected together so that users can share hardware, software, and data, as well as electronically communicate with each other.
Internet: Largest computer network in the world
Types of networks:
Business networks,
Phone networks,
Home
Multimedia networks
Common Uses for Computer Networks
1. Sharing a printer or an Internet Connection among several users.
2. Sharing application software with a network license, which can be purchased less expensively and which needs to be installed and updated on only one computer.
3. Working collaboratively, such as sharing a company database or using a collaboration tools to create or review documents.
4. Exchanging files among network users and over the internet
5. Connecting the home computers and the entertainment devices, (such as TVs, gaming consoles, and stereo systems) located within a home.
Networking and Communications Applications:
1. Global positioning system (GPS): Uses satellites and a receiver to the exact geographic location of the receiver
a. Commonly found in cars today
b. Available as handheld units
c. Used by the military, hikers, travelers, and others who need to know their precise
2. Videoconferencing: Use of communications technology for real-time, face-to-face meetings between individuals located in different places
a. Technology continues to improve and mimic reallife environments
b. Telepresence videoconferenceing
c. Online conferencing ( via the Internet)
d. Video phone calls
Types of Network Topology: How the devices in the network (called nodes) are arranged
1. Star networks: All devices connect to a central device or hub)
- All computers/devices connect to a central device called hub or switch.
- Each device requires a single cable
- Point-to-point connection between the device and hub.
- Most widely implemented
- Hub is the single point of failure
2. Bus networks: All devices connect to a central cable
- Uses a trunk or backbone to which all of the computers on the network connect.
- Systems connect to this backbone using T connectors or taps.
- Coaxial cablings ( 10Base-2, 10Base5) were popular options years ago.
3. Ring networks: Devices connect to one another in a ring
a. Logical ring
-Meaning that data travels in circular fashion from one computer to another on the network.
- Ring networks are most commonly wired in a star configuration
- Token Ring has multi-station access unit (MSAU),equivalent to hub or switch. MSAU performs the token circulation internally.
4. Mesh networks: Multiple connections between devices
- Each computer connects to every other.
- High level of redundancy.
- Rarely used.
- Wiring is very complicated
- Cabling cost is high
- Troubleshooting a failed cable is tricky
- A variation hybrid mesh
- create point to point connection between specific network devices, often seen in WAN
implementation.
5. Some networks use a combination of topologies
Internet Terms to be Familiar with:
Browser - Contains the basic software you need in order to find, retrieve, view, and send information over the Internet.
Download - To copy data from a remote computer to a local computer.
Upload - To send data from a local computer to a remote computer.
E-mail - (electronic mail) is the exchange of computer-stored messages by telecommunication. E-mail can be distributed to lists of people as well as to individuals. However, you can also send non-text files, such as graphic images and sound files, as attachments sent in binary streams.
Home Page - The beginning "page" of any site.
HTML (HyperText Markup Language) - The coding language used to create documents for use on the World Wide Web. There are three-letter suffixes used in coding that help to identify the type location one is viewing
HTTP (HyperText Transport Protocol) - the set of rules for exchanging files (text, graphic images, sound, video, and other multimedia files) on the World Wide Web. Relative to the TCP/IP suite of protocols (which are the basis for information exchange on the Internet), HTTP is an application protocol.
¨Search Engine - A web server that collects data from other web servers and puts it into a database (much like an index), it provides links to pages that contain the object of your search.
TCP/IP - TCP/IP (Transmission Control Protocol/Internet Protocol) is the basic communication language or protocol of the Internet. It can also be used as a communications protocol in a private network (either an intranet or an extranet). When you are set up with direct access to the Internet, your computer is provided with a copy of the TCP/IP program just as every other computer that you may send messages to or get information from also has a copy of TCP/IP.
URL (Uniform Resource Locator) - The Internet address. The prefix of a URL indicates which area of the Internet will be accessed. URLs look differently depending on the Internet resource you are seeking.
WWW (World Wide Web) - A technical definition of the World Wide Web is: all the resources and users on the Internet that are using the Hypertext Transfer Protocol (HTTP).
Internet
- An information system
- Communication tool
- A large network of computer systems world wide can be explored by using a Web Browser
- Services available through the Internet:
- Email (Discussion groups,Chat Rooms, etc.)
- Information search (including research)
- Education (Online courses; virtual colleges)
- Entertainment, News, and more…...
Evolution of the Internet
ARPANET: The predecessor of the Internet, named after the Advanced Research Projects Agency (ARPA), which sponsored its development
- Initially connected four supercomputers
- Eventually grew into today’s Internet
The World Wide Web: The collection of Web pages available through the Internet
- Proposed by Tim Berners-Lee in 1989
- Originally only text-based content
- Release of the graphical Mosaic browser in 1993 led to graphical content
- Wide variety of content available via Web pages today
Internet: Researches advanced Internet applications and technologies
Web Browsers
- You use this software to view different locations on the Web, which are known as Web pages. A group of Web pages is a Web site. The first page of a Web site is often called the home page.
- Software programs used to access the World Wide Web (WWW)
- Most popular web browsers:
a. Google Chrome
b. Microsoft Internet Explorer
c. Mozilla Firefox
d. Apple Safari
Search Engines
- A program that connects you to a database or Web address
- used to perform a thorough search
- Some Popular Search Engines
- Google search, Alta Vista, Excite, Hotbot, Lycos, InforSeek, etc.
- Random Browsing (takes too much time)
- Mark Favorite Sites (bookmark the sites)
- Use several Search Engines for a thorough search
Some Well Known Search Engines
- Yahoo! Search
www.yahoo.com
- Google Search
www.google.com
- Bing ”Live Search, Windows Live Search, and MSN Search”
www.bing.com
- E-mail stands for Electronic Mail.
- It is one of the most widely used features of the Internet.
- Mails are regularly used today where with the help of postage stamp we can transfer mails anywhere in the world.
- With electronic mail the service is similar but here data are transmitted through Internet and therefore within minutes the message reaches the destination anywhere in the world.
Email Components
- You may have an e-mail account through a business network or you may create an e-mail account with a service that provides Internet access.
- An e-mail address consists of:
a. A user name or login ID
b. The “at” symbol (@)
c. The name of the e-mail server
Understanding Email
- E-mail, or electronic mail, is an efficient way to exchange messages with others on a network.
- This network may be small and self-contained, such as within an office, or as large as the Internet.
- E-mail messages can go to only one recipient or to dozens of recipients at once.
- When you send a message, it travels through the network to an e-mail server.
- The e-mail server stores messages until the recipient(s) request them.
Web Address (URLs)
- Each computer on the Internet has an unique identification number, called an IP (Internet Protocol) address.
- Each part of the address is a number ranging from 0 to 255, and each part is separated from the previous
part by a period, for example: 106.29.242.17.
- Although each computer connected to the Internet has a unique IP address, most Web browsers use domain name addressing to locate Web sites and pages.
Subscribe to:
Posts (Atom)
