|
Home | Course
Info | Syllabus
| Calendar | Assignments
| Resources | Review |
WebCT
| FAQ Last Week's Lesson |
Next
Week's Lesson
| Week
9: At a Glance
|
|
What We Did Last Week
PowerPoint Project 2 introduced you to the Outline tab,
clip art, and animation effects. You created a slide presentation on
the Outline tab where you entered all the text in the form of an outline.
You arranged the text using the Promote and Demote buttons. Once the
outline was complete, you changed slide layouts and added clip art.
After adding clip art to slides without using a content
placeholder, you moved and sized the clips. You added preset
animation effects and applied animation effects to a clip. You learned how
to run an animated slide show demonstrating slide transition and animation
effects. Then, you printed the presentation outline and slides using
the Print command on the File menu and e-mail the presentation.
Finally, you learned to save the presentation as a Web page
using the Save As Web Page command. Then you published your
presentation, and PowerPoint started your default browser and opened your
HTML file so you could view the presentation. At the end, you edited
the presentation, saved it again, and viewed it again in your default
browser.
We are having our PowerPoint test this week and you are strongly
encouraged to take the practice test if you have not done so. You can make
an appointment with any one of the testing centers and take the test any
day between Monday and Friday.
You should have submitted all your assignments up to
assignment 5. 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
In creating the Dynamite Music Fourth Quarter Sales worksheet
and chart in Project 1 of your Excel book, you will gain a broad knowledge of
Excel. First, you will be introduced to starting Excel. You will learn
about the Excel window and how to enter text and numbers to create a worksheet.
You will learn 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 will learn how to
copy a cell to adjacent cells.
Once the worksheet is built, you will learn 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 will format the body of the worksheet using the
AutoFormat command, and you will use the Chart wizard to add a 3-D Column chart.
After completing the worksheet, you will save the workbook on disk, print the
worksheet and chart, and then quit Excel. You will learn how to start
Excel by opening an Excel document, use the AutoCalculate area, and edit data in
cells. Finally, you will learn how to use the Excel Help system to answer
your questions.
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
Top of
the Page
Activities
for This Week
-
Test #3 (PowerPoint 2003) -
Monday, 10/17/05, 6:00 p.m.
Room 2146, Academic Computing Center, Pensacola Campus
-
Reading Assignment - Project 1 in your Excel 2003
textbook.
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.
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:
 Using
Excel to Creating a Worksheet and Embedded Chart
Assignments:
-
Reading Assignment
- Project 1 in your Excel 2003 textbook.
-
Complete Project 1
in your Excel 2003 textbook.
-
Email your
Assignment #6 to your instructor after you complete the entire assignment.
-
MSLQ survey in
WebCT
What we will do next
week: Microsoft Excel 2003
Home | Course
Info | Syllabus
| Calendar | Assignments
| Resources | Review |
WebCT
| FAQ Last Week's Lesson |
Next
Week's Lesson
Last updated:
09/23/05
|
