Site Map

Home | Course Info |  Syllabus | Calendar | Assignments | Resources | Review | WebCT | FAQ

Last Week's Lesson | Next Week's Lesson

What We Did Last Week

We learned  to start Word and create a document in Project 1 last week.  Before entering any text in the document, you learned how to change the font size.  You also learned how to save and print a document.  You used Word's check spelling as you type feature.  Once you saved the document, you learned how to format its paragraphs and characters.  Then, you inserted and resize a clip art image.  You learned how to insert, delete, and modify text.  Finally, you learned one way to use the Word Help system.

Project 2 introduced you to creating a research paper using the MLA documentation style. You  learned how to change margin settings, adjust line spacing, create headers with page numbers, and indent paragraphs. You learned how to use Word's AutoCorrect feature. Then, you added a footnote in the research paper. You alphabetized the works cited page by sorting its paragraphs and included a hyperlink to a Web page in one of the works. You learned how to count words, browse through a Word document, move text, and find and replace text. You looked up a synonym and checked spelling and grammar in the entire document. Finally, you navigated to a hyperlink and e-mailed a copy of a document.

In Project 3 you learned to creating a resume using a wizard and creating a cover letter with a letterhead, a bulleted list, and a table. You used the Resume Wizard to create a resume and then used several formatting techniques to personalize the resume.  You viewed and printed the resume in print preview. You created a letterhead and then the cover letter. While creating the letterhead, you learned how to add color to characters, set custom tab stops, collect and paste between documents, and add a border to a paragraph.  You created an AutoText entry, which you used when you personalized the cover letter. Finally, you addressed and printed an envelope.

Some of you sent your assignments to the wrong place. Assignments 1 - 10 on Concepts, Windows XP, Word, Access, Excel and PowerPoint should be sent to my PJC account at llemley@pjc.edu as attachments with "Section #, Assignment #, Your name" typed in the Subject box. Only your biography in Threaded Discussion (Bulletin Board) is done in WebCT.

There are some common mistakes in the assignments turned in last week:

• Do not press Enter key at the end of each line.  Instead, press the Enter key only when you finish typing the entire paragraph. This is the Word Wrap feature we have in word processing software. If you click on Show/Hide ¶ icon on the toolbar, you will see where you pressed the Enter key.  Simply move your insertion point to the end of each line and press Delete key or Backspace key to delete the ¶ paragraph mark.

• Do not press Tab or Space bar to force the heading to be centered or right-aligned in the document. Instead, you should click on Format/Paragraph/Alignment and select the proper alignment for your heading. Or you can simply click on the Center or Align Right icon on the formatting tool bar to align your text.

Some of you still have questions on SAM²⁰⁰³.  You have to have Shockwave installed on your computer in order to use SAM (Skill Assessment Manager). Also, you have to have an account with SAM²⁰⁰³ at http://sam2003.course.com to use SAM in this course. Here is how:

1. Install the SAM²⁰⁰³ CD you received at the orientation.
2. Click on the SAM²⁰⁰³ icon on the desktop to go to http://sam2003.course.com.
3. Enter your username (pjc followed by three digits) and password (your section number followed by two digits) to login. Do not login as a new user.  Please contact me if you don't have your username and password.
4. Select any Training from the assignment list to launch training.
5. You will see a list of 5 exams at the beginning of the listing. Do not select any exam. They are the actual exams you are going to take for this term. Click on Exam only when you are ready to take the tests on Windows XP, Word, PowerPoint, Excel, and Access at the test center.

SAM is performance-based learning. For each skill you want to master, a SAM activity provides four learning modes:

• Prepare - Provides important conceptual information about each skill, including definitions of key terms and graphics illustrating commonly used features of each application. Offers step-by-step instructions for the most common methods used to perform the skill.

• Observe - Watch a narrated animation that allows you to see and hear how a skill is completed in the application.

• Practice - Helps you master a skill by guiding you, step by step, through the process of performing a task. You will practice in a realistic simulation of the application.

• Apply - Allows you to test your knowledge by working on your own, in a realistic simulation of the application, without step-by-step guidance.

You can access Prepare, Observe, Practice, and Apply at any time, moving among them in any order to create the learning program that best suits you. You can also access any learning mode as many times as you like.  The real test is very much similar to the test you take using Apply mode in Training.

Test #2 is scheduled on Tuesday/Thursday at 6 p. m. in Room 2146. You can also take the test at any one of the PJC test centers during the week from Monday to Thursday during their testing hours. Make sure to call ahead and make an appointment. Tuesday/Thursday night test is set up for people who work during the day and can't go to the test center.

Top of the Page

What You Will Learn This Week

• Lesson 10: Excel 2002: Creating a Worksheet and Embedded Chart

• Lesson 11: Excel 2003: Formulas, Functions, Formatting, and Web Queries

• Lesson 12: Excel 2003: What-If Analysis, Charting, and Working with Large Worksheets

In creating the Aquatics Wear Six-Month Financial Projection workbook, you will learn how to work with large worksheets that extend beyond the window and how to use the fill handle to create a series. You will learn to display hidden toolbars, dock a toolbar at the bottom of the screen, and hide an active toolbar. You will learn about the difference between absolute cell references and relative cell references and how to use the IF function. You also will learn how to rotate text in a cell, generate a series, freeze titles, change the magnification of the worksheet, display different parts of the worksheet through panes, create a 3-D pie chart, and improve the appearance of a 3-D Pie chart. Finally, project 3 will introduce you to using Excel to do what-if analysis by changing values in cells and goal seeking.

Top of the Page

Lesson Objectives

After completing this lesson, you will be able to:

• Start Excel
• Describe The Excel Worksheet
• Describe the Speech Recognition Capabilities of Excel
• Select a cell or range of cells
• Enter Text and Numbers
• Use the AutoSum button to sum a range of cells
• Copy a cell to a range of cells using the fill handle
• Bold font, change font, and change font color
• Center cell contents across a series of columns
• Apply the AutoFormat command to a format range
• Use the Name box to select a cell
• Create a column chart using the Chart Wizard.
• Saving a workbook
• Print a Worksheet
• Quit Excel
• Open a Workbook
• Use the AutoCalculate area to determine totals
• Correct Errors on a Worksheet
• Use the Excel Help system to answer your questions

• Use Formulas and Functions; Format Excel Worksheet; and Create Web Queries

  • Enter multiple lines of text in the same cell
  • Enter a formula using the keyboard
  • Enter formulas using the point method
  • Identify the arithmetic operators
  • Recognize Smart Tags
  • Applying the AVERAGE, MAX, and MIN functions
  • Verify a formula using Range Finder
  • Change the font of a cell
  • Color the characters and background of a cell
  • Add borders to a range
  • Format numbers using the Format Cell dialog box
  • Add conditional formatting to a range of cells
  • Align text in cells
  • Change the width of a column and height of a row
  • Check the Spelling of a worksheet
  • Preview how a printed copy of the worksheet will look
  • Distinguish between portrait and landscape orientation
  • Print a partial or complete worksheet
  • Display and print the formulas version of a worksheet
  • Print to Fit
  • Use a Web query to get real-time data from a Web site
  • Rename sheets
  • E-mail the active workbook from within Excel

• Perform what-if analysis, charting, and work with large worksheets

  • Rotate text in a cell
  • Create a series of month names
  • Use the Format Painter button of format cells
  • Copy and paste
  • Insert and delete cells
  • Format numbers using format symbols
  • Freeze Titles
  • Display and Format the System Date
  • Use absolute cell references in a formula
  • Use the IF function to perform a logical test
  • Copy absolute cell references
  • Display and dock toolbars
  • Add a drop shadow to a range of cells
  • Create 3-D Pie chart on a separate chart sheet
  • Color Worksheet tabs
  • Rearrange sheets in a workbook
  • Preview and print multiple sheets
  • Use the Zoom box to change the worksheet view
  • View different parts of the worksheet through window panes
  • Use Excel to answer what-if questions
  • Goal seek

Top of the Page

Activities for This Week

• Test #2 (Word 2003) - Tuesday/Thursday, 7/11 or 7/13, at 6:00 p.m. in Building 21, Room 2146, Academic Computing Center, Pensacola Campus

• Reading Assignment - Projects 1, 2 and 3 in your Excel 2003 textbook.

• Assignment #5 -  Using Excel to Creating a Worksheet and Embedded Chart; Formulas, Functions, Formatting, and Web Queries

  Email your completed assignment to your instructor at llemley@pjc.edu as an attachment. Remember to type "Your Section #, Assignment 5, Your Name" in the Subject.

• Assignment #6 -  What if Analysis, Charting, and Working with Large Worksheets

Email your completed assignment to your instructor at llemley@pjc.edu as attachments. Remember to type "Your Section #, Assignment 6, Your Name" in the Subject.

Top of the Page

Conclusion

  At the end of this lesson, you have learned:    

      Using Excel to Creating a Worksheet and Embedded Chart

      To use formulas and functions

     To format Excel worksheet

      To perform What-If analysis, charting, and work with large worksheets

  Assignments

• Test #2 (Word 2003) - Tuesday/Thursday, 7/11 or 7/13, at 6:00 p.m. in Building 21, Room 2146

• Reading Assignment - Read Projects 1, 2 and 3 in Microsoft Excel 2003 of your book.

• Assignments #5 and #6 and email them as attachments.

  What we will do next week: Microsoft Access 2003

• Test #3 (Excel 2003) - Tuesday/Thursday, 7/18 or 7/20, at 6:00 p.m. in Building 21, Room 2146

• Complete Assignments #7 and #8

 

 

Top of the page

Home | Course Info |  Syllabus | Calendar | Assignments | Resources | Review | WebCT | FAQ

Last Week's Lesson | Next Week's Lesson

 

For more information, please contact Ms. Linda Lemley by phone or email.

Last updated: 06/26/06