Monday, October 10, 2011

Lesson 8 continuation

Using the Find All Command

1.Select the range of cells you want to search in.
2.Click on EDIT-> REPLACE
3.Type the text or numbers that you want to search for in the find box or choose a recently searched for item from the find what drop down.
4.Click on the FORMAT button to specify a format for your search and make selections on the FIND format dialog box.
5.Select OPTIONS to further refine your search.
6.Type the replacement text, characters members in the replace with box and choose specific format if necessary.

7.Click on the Find Next or Find All button.
8.Click on the Replace button or Replace All button to replace the highlighted occurrence or all occurrences of the found characters.
 

Search and Replace Utility


Using the Replace All Command:
1.Select the range of cells you want to search in.
2.Click on EDIT-> FIND and REPLACE
3.Type the text or numbers that you want to search for box or choose a recently searched for item from the search for drop down.
4.Click on the MORE OPTIONS button to further refine your search.
5.Type the replacement texts, characters or numbers in the replace with box and choose specific formats if necessary.
6.Click on the FIND button.
7.Click in the REPLACE button or REPLACE ALL button to replace the highlighted occurrence or all occurrence of the found character.

Sunday, October 2, 2011

Activity on Lesson 8 - Search and Replace Utility

Do the following instructions.
1.       1. Open the worksheet with the file name of Act_1_<your surname>.
2.      2.   Remove the back color of cell B7 to C11.
3.       3.  Insert cells after the following cells:
Cell Number
      A1
     A9
     A11
     A13
4.       4. Change all small letter a to capital letter A.
5.      5.  Change all small letters I to capital letter I.
6.       6.  Save  the workbook with the file name Act_2_<your surname>.
7.       7.  E-mail your work as an attachment to leugim001@yahoo.com with the subject:  <your section>_Act_2.
8.       This Activity is due on Wednesday, October 5, 2011.

Thursday, July 21, 2011

RUBRICS FOR THE PRELIM

Please use the Rubrics as your guide as you answer the Prelim.

Trait Writing Model : Short answers RUBRICS

http://rubistar.4teachers.org/index.php?screen=ShowRubric&rubric_id=1921644&

Trait Writing Model : Short answers


CATEGORY 4 3 2 1
Conclusion (Organization)
4.The asnwer is strong and leaves the reader with a feeling that they understand what the writer is "getting at."
3.The answer is recognizable connects most relevant items.
2. The answer is recognizable, but does connect all relevant items.
1. The answer is not clear.

Capitalization & Punctuation (Conventions)
4.Writer makes no errors in capitalization or punctuation, so the paper is exceptionally easy to read.
3. Writer makes 1 or 2 errors in capitalization or punctuation, but the paper is still easy to read.
2. Writer makes a few errors in capitalization and/or punctuation that catch the reader's attention and interrupt the flow.
1. Writer makes several errors in capitalization and/or punctuation that catch the reader's attention and greatly interrupt the flow.

Sentence Structure (Sentence Fluency)
4. All sentences are well-constructed with varied structure.
3. Most sentences are well-constructed with varied structure.
2. Most sentences are well-constructed but have a similar structure.
1. Sentences lack structure and appear incomplete or rambling.

Word Choice
4. Writer uses vivid words and phrases that linger or draw pictures in the reader's mind, and the choice and placement of the words seems accurate, natural and not forced.
3. Writer uses vivid words and phrases that linger or draw pictures in the reader's mind, but occasionally the words are used inaccurately or seem overdone.
2. Writer uses words that communicate clearly, but the writing lacks variety, punch or flair. 1. Writer uses a limited vocabulary that does not communicate strongly or capture the reader's interest. Jargon or cliches may be present and detract from the meaning.

Accuracy of Facts (Content)
4. All supportive facts are reported accurately.
3. Almost all supportive facts are reported accurately.
2. Most supportive facts are reported accurately.
1. NO facts are reported OR most are inaccurately reported.

Support for Topic (Content)
4.Relevant, telling, quality details give the reader important information that goes beyond the obvious or predictable.
3. Supporting details and information are relevant, but one key issue or portion of the storyline is unsupported.
2. Supporting details and information are relevant, but several key issues or portions of the storyline are unsupported.
1. Supporting details and information are typically unclear or not related to the topic.

Focus on Topic (Content)
4. There is one clear, well-focused topic. Main idea stands out and is supported by detailed information.
3. Main idea is clear but the supporting information is general.
2. Main idea is somewhat clear but there is a need for more supporting information.
1. The main idea is not clear. There is a seemingly random collection of information.

http://rubistar.4teachers.org/index.php?screen=ShowRubric&rubric_id=1921644&

FIRST PRELIM EXAM 2011

On one whole sheet of pad paper, answer the following questions in not less than 5 sentences.


1. Environmental scanning is a thorough observation of a target area. What are the advantages of environmental scanning over plain observation?

2. Why is earning a profit while answering the needs of the people an important part of entrepreneurship?

3. Business employs different tactics or gimmicks to attract customers. Is this practice really necessary to succeed in business? Prove your answer by citing an example.

4. How can technology help an entrepreneur become competitive on the market?

5. SWOT stands for Strengths, Weaknesses, Opportunities and Threats. If you were to add another area that an entrepreneur must look at, what would it be and why?

All answer sheets will be collected on Monday, July 25, 2011 on your ICT time.