Week 5:
- Required Reading: Microsoft Office97:
Introductory Concepts and
Techniques: E 1.1 - E 3.74, EI 1.1-EI 1.9
- Required Reading: Understanding and Using the
Internet: Unit 6;
- Assignments: Microsoft Office 97: Introductory Concepts and
Techniques: E 3.71 (In The
Lab) Using the #3 Solar Works, Inc Project Parts 1, 2, 3;
as a guide set up a
projected 3rd Quarter financial report for a Sporting Goods
Retail Store.. Use
the NOW function to enter the date and an assumption table to
calculate expenses. Be sure
to include Revenue, Expenses, and Net Income. Italicize and
rotate the text to
create the July month titleand then use the format painter to format
the remaining months
in the series. Use the SUM function to determine all the
totals. Net income should
be equal to the total revenue for each month minus the total revenue
for each month.
Select an attractive format theme to display your data.
Draw a 3D pie
chart that shows the monthly contribution to the quarterly net
income. Add a chart
title and format the chart in an attractive meaninful manner.
Make up the data but
be sure to include all the requirements for the #3 Solar Works
Project.
- Send this project to your instructor in one excel file as an
attachment to an
email message.
- Send your instructor a summary of what you learned in class this
week. This report
will be used to record your attendance in class this week.
- Post the address of a favorite website could use to find a new job
tell why you like it.
- Post the address of a favorite website that has a tutorial or gives
you tips on using
Excel.
- Post the address of a website talking about how to use news groups
or news servers on
the internet.
- Share something in the conference classroom you learned from this
week's lesson on Excel
or using and accessing news groups and news servers on the internet.
Post a question or a
response in another student's thread in the classroom conference.
- Complete additional exercises from the text as needed to become
proficient with the
software and online environment, but do not submit them to the
instructor.