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

In creating the Dynamite Music Fourth Quarter Sales worksheet and chart in Project 1 of your Excel book, you gained a broad knowledge of Excel.  First, you were introduced to starting Excel. You learned about the Excel window and how to enter text and numbers to create a worksheet.  You learned how to select a range and how to use the AutoSum button to sum numbers in a column or row.  Using the fill handle, you learned how to copy a cell to adjacent cells.

Once the worksheet is built, you learned how to change the font size of the title, bold the title, and center the title across a range using buttons on the Formatting toolbar. Using the steps and techniques presented in the project, you formatted the body of the worksheet using the AutoFormat command, and you used the Chart wizard to add a 3-D Column chart.  After completing the worksheet, you saved the workbook on disk, printed the worksheet and chart, and then quit Excel.  You learned how to start Excel by opening an Excel document, used the AutoCalculate area, and edited data in cells.  Finally, you learned how to use the Excel Help system to answer your questions.

We talked about different types of camera last week. With a digital camera you can store your images electronically instead of on film. Half of you thought digital cameras would eventually replace traditional cameras and the other half did not think so.  All of you agreed that it was easy to store pictures in digital form which could be sent to family and friends through email easily.  However, there are some other issues involved that will keep traditional camera around for a while. The price tag for the digital camera is still pretty high. There are other costs involve also, such as a computer and a printer, which are required to view or print the pictures. The quality of the pictures is another factor that traditional cameras are not going to be replaced by digital cameras soon.

By now, you should have submitted all of your assignments up to assignment 6. Please contact me if you don't see your grade posted a week after you submitted your assignment.

Top of the Page

What You Will Learn This Week

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

• 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

Top of the Page

Activities for This Week

• Reading Assignment - Project 2 in your Excel 2003 textbook.

• Assignment #7 -  Using Excel to Creating a Worksheet and Embedded Chart

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

• MSLQ survey - You are selected to be in a research study to determine how motivation and use of learning strategies influence performance. You will be asked to complete a survey consisting of demographical information and questions correlating to motivation orientation and cognitive/metacognitive learning strategies. Here is more information concerning the survey. Please go to WebCT to answer the MSLQ survey. Remember to answer all questions and save each one of them before submitting your survey. Thank you in advance for your participation.

Troubleshooting -

Pop-up blocking software
The survey appears in a new browser window. If you have pop-up blocking software installed on your computer, the survey may not appear. To take the survey, you may have to disable the pop-up blocking software.

Top of the Page

Conclusion

  At the end of this lesson, you have learned:

      To use formulas and functions; 

     To format Excel worksheet; and 

     To create Web queries

  Assignments:

• Reading Assignment - Project 2 in your Excel 2003 textbook

• Complete Project 2 in your Excel 2003 textbook

• Email your Assignment #7 to your instructor after you complete the entire assignment.

• MSLQ survey in WebCT

  What we will do next week:  Microsoft Excel 2003

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

• Lesson 13: Web Feature Creating Static and Dynamic Web

• Complete Assignment #8

Top of the page

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

Last Week's Lesson | Next Week's Lesson