Celia's Class Schedule

Winter 2000 class reports the weather

Class of Fall 2000 acts out!

Who is Celia, anyway?

Word for ESL Part 2
In this class, you will learn how to:
  • Customize toolbars
  • Format whole documents
  • Calculate and sort within a table
  • Create charts
  • Use Mail Merge


Assignment 1

English Topic: Present Perfect
Computer Skill: Whole Document Formatting 1

Do exercise 3 in your handouts.  DO NOT NUMBER EACH ITEM.  Just press enter after each number or each speaker.  Change the page setup as follows:

  • Top margin 2 inches
  • Left, right and bottom margins should be 1 inch
  • Landscape orientation
  • Center vertical alignment
  • Line numbers: restart after each section
  • Use a hanging indent of 0.25 inches


Assignment 2

English Topic: Present Perfect vs. Simple Past
Computer Skill: Customizing Toolbars

Do exercise 8 in your handouts.  Clear all toolbars from your window.  Type and save the assignment as Customizing Toolbars.  Apply the toolbars you need as you type.  At the end of the document, list which toolbars you used.  Print the document and give it to me.


Assignment 3

English Topic: Writing Narratives
Computer Skill: Whole Document Formatting 2

Requirements:

  • Use portrait orientation.
  • The title must run across the entire page, but the body of the newsletter must be in 3 columns.
  • At least 3 articles: an interview, a story with a list, and the last one can be anything you want that is related to a past event in school.
  • Each article must have a different font.  Titles must be larger than text.
  • All lists must be bulleted or numbered.
  • Insert at least one graphic for each article.  The art must match the theme of the article.

You may work individually or in groups of two or three.


Assignment 4

English Topic:  Review of Present, Past, Future and Present Perfect
Computer Skill:  Sorting and Calculating within a Table
Situation:  You and your spouse are trying to save money.  You tell your spouse that the reason you cannot keep within the budget is because you eat out too much.  But your spouse doesn't believe you.  You decide to prove you are right by creating evidence.  The tables are your evidence.

Copy the sample table handout.  Use landscape orientation.  Each letter represents a restaurant that you visited for the corresponding number of times per month.  You will need to copy and paste the table twice so that you have three identical tables on one page.

Table 1:  Use a formula to calculate sums of each row and column.  Title the table.

Table 2:  Use a formula to calculate the average number of times you went to each restaurant for the whole year and for each month.  Title the table.

Table 3:  Sort the table by the column headed "June" to see which restaurant you visited most in June.  Title the table.

Write a letter to your spouse explaining what the tables say.  Set the page layout so that you use protrait orientation for this section.  The tables should still be in landscape orientation.

  • If the tables are true about this year, about how many times have you eaten out already? 
  • How many times do think you will eat out this month and for the rest of the year? 
  • Make suggestions so that you can save some money. 

You should only submit 2 pages.  One page will have all three tables and the other will have the letter.  I will not accept any more than 2 pages.  You will have to format your tables to fit on the page.


Assignment 5

English Topics:  Comparison & Using Logical Organizers
Computer Skill:  Creating Charts

1. Create a chart based on the information in assignment 3.  You may choose any table or part of a table.  Change the settings and appearance as you wish.  When choosing colors, remember that our printer is black and white.  Try to have as much color contrast as possible so that it will be easy to read the chart.

2. Write a paragraph explaining your chart.  What are the advantages and disadvantages of using the chart as compared to using the tables?  Use logical organizers in your paragraph.


Assignment 6

English Skills: Writing a Narrative
Computer Skill: Mail Merge

1.  Make an invitation to a potluck party.  You may design it any way you want but it must have:

1. At least 2 columns;
2. Your name, address and telephone number;
3. The name and address of the recipient;
4. The reason for the potluck party;
5. A list of food that people could bring;
6. What you would like the recipient to bring;
7. An RSVP date; and
8. At least one graphic.

2.  Create a data source for numbers 3 & 6 above.
3.  Fill out data forms for at least 3 people.