 
Syllabus
Course Projects
Suggested
projects:
Imagine you are the proud new owner of an "Internet café." All four
projects listed below are in support of that major theme. So as not to stifle
your creative nature and freedom, aside from the theme restriction I have
imposed upon you, you are free to decide all other aspects of your business
(name, location, products, size, etc.).
You will be
required to complete 10 minimum elements for each project that I will define
below. Each element is worth four points (40 total points). All other details
you may want to include to enhance your projects is up to you. However, I
will take into account only the 10 minimum elements when I grade your projects.
I am not grading your artistic or graphic abilities, but rather your
understanding of how to perform these basic functions.
The Halvorson and
Hunt text may assist you in working with MS Office Applications. You should
review the contents and work through the unit exercises in order to
understand the operations of Microsoft Office Applications. On some of the
exercises below, you will see Unit references from the Halvorson and Hunt
text for your projects in the project descriptions. These references will help
you complete the assigned tasking for each project.
Word Assignment
No. 1
Create a flyer for your
new business.
Element #
1.
Create your flyer on no more than one 8.5" x 11" page, with margins
at .75" on all edges.
2. Use WordArt to create the name of your business on the flyer.
3. Center the name and address of your business, using the center alignment
function.
4. Use a logo (insert clip art) somewhere in your flyer.
5. Use a table (using the auto format feature) to show at least five of your
products and their associated prices.
6. Use bullets or numbering somewhere in the text (see the help menu if you
are unclear on how to do this).
7. Use normal, bold, and italic text somewhere in the design.
8. Use at least two colors for your fonts, at least two font styles, and at
least two different font sizes.
9. Create a footer and include the: 1) name of the business, and 2) the date
(using the date function).
10. Spell check and grammar check your work and save the file with your name
(e.g. myname.doc).
Excel Assignment
No. 2
Create a
spreadsheet to display the sales for your five main products for the last
four weeks.
Element #
1. Place a title
for your worksheet (e.g. Last Month's Sales) at the top of the spreadsheet.
Center it over your table using the "Merge and Center" button on
the toolbar (near the alignment buttons). See help if necessary. Use a size
16 font for your labels and the default font size for your data. Use any
color except black for your labels.
2. Create a spreadsheet that lists products down the left column and Weeks 1
through 4 across the top row. Enter fictitious data for sales for each week
by product. Make the product names and the week names bold. Do not bold the
data.
3. Use the Sum function to add the totals for each week for all products (at
the bottom) and the Sum function to add the totals for each product for all
four weeks (right side).
4. In the row beneath the sum function for the product totals, use the
Average Function to calculate the average sales per week. You do not need to
calculate the average for each product on the right side.
5. Format the data to Currency with decimal points to two places (e.g.
$365.43) for all data, totals, and products of the functions. In other words,
everything.
6. Set each column width to 12. Set all row heights to 20.
7. In page setup, create a footer that has your name and the date the sheet
was created, choose landscape, and center horizontally and vertically.
8. Set the print area to include all the data in the table you have created.
9. Using the chart command, chart the data (be careful not to include the
totals or averages in your range) using a bar chart. Choose the option that
places the chart in your spreadsheet and not as a separate sheet. Your chart
should show all five products together grouped by weeks. This should happen
automatically.
10. Spell check and grammar check your work and save the file with your name
(e.g. myname.xls).
PowerPoint
Assignment No. 3
Create a
presentation for your new business to explain to lenders why they should loan
you money to expand your business.
Element #
1. Your
presentation should consist of five slides, including the title slide, two
bullet slides, one graph slide, and one bulleted summary slide.
2. Choose and use a design template for your presentation.
3. Insert clip art on at least four of the slides.
4. Place: 1) a logo, 2) page numbers and 3) a date in the master slide (see
PowerPoint help if necessary).
5. Create a graph (bar chart or line chart) on one slide to show increasing
sales over the last year. You can use the charting function inherent in
PowerPoint or embed the chart created for assignment 2 (Excel) (copy and
paste) from Microsoft Excel (Unit C).
6. Create speaker notes on each of the slides using the notes function in
PowerPoint.
7. Use at least two colors for your fonts, at least two font styles, and at
least two different font sizes.
8. Set the preset timings and create transitions for each slide for the
online presentation mode.
9. Omit the background from the graph chart only, and change its background
to a solid color (other than white) of your choice.
10. Spell check and grammar check your work and save the file with your name
(e.g. myname.ppt).
Access Assignment
No. 4
Create a customer
database to allow you to conduct mailings in the future. Customers will put
their business cards into a jar in hopes of winning promotional items. Their
business cards will give you their name, the company they work for, and all
the other information you need to set up your database. This project will
closely parallel the one in the text.
Element #
1. Create a table
with all the same fields and settings as the one in Unit A. Save this table
as "Customer Data." Exclude the "billing address" and
"active" fields.
2. Build a data entry form similar to the one in Unit A.
3. Design the format of the form any way you choose, but do format it.
4. Add some clip art to your form (anything you choose).
5. Enter data for at least 10 customers, using the data entry form. Use the
form instead of using the table so you can make sure it works.
6. Sort your database table by the customer's last name.
7. Create and save a query that pulls all the company names from the company
name field. Sort them alphabetically ascending.
8. Note: Do not set a password for your database.
9. Create a report that contains your customer's name, address, city, and zip
code (a report of mailing addresses) only. Format your report in some way
(title, clip art, font colors). Save your report as "customer mail
report."
10. Spell check and grammar check your work and save the file with your name
(e.g. myname.mdb).
|
