Scenario: You
have an entrepreneurial spirit and decided to start your own business. You know
that there is much to do. You decide to use the Microsoft Software Applications
(Word, Excel & PowerPoint) you have recently learned about to create some
documents you need to start your business.
You decide to use MS
Word to create a flyer to announce your grand opening, MS PowerPoint to create a presentation you
can present to a bank or other investors requesting a loan MS Excel to create your start up
budget.
Part 1: MS Word - Create a one page Opening Day Flyer in for
your new business using MS Word. The flyer must include at a minimum the
specifications listed below.
a. Select a theme.
Microsoft Office comes with variety of themes that you can choose to make a
more professional looking document. Your
flyer should be in landscape orientation.
b. Include the
following information in your flyer:
Company Name, Date and Time of Opening, Location of Opening, Description
of business, Events to take place, Additional information you feel is required
c. Add Word Art. Some of the text must be
added using Word Art.
d. Add a graphic.
The graphic should be appropriate for your business. It could be a logo you
created or clip art.
e. Add a table.
Tables can be used to help organize your data on a page. You might use your
table to list the dates and time of the scheduled events.
f. Add Footer. The footer should include
your name, course and section number, and the date. This information should be
centered.
g. Ensure Flyer is
well written. Information presented should be easily understood.
h. Ensure all
choices add to the creation of a well-designed document. It is important that
your flyer reflects knowledge of Microsoft Word features as covered in the
course.
Part 2: MS Excel
- Create a Start up Budget and first 6 months operating expenses for your new
Business using MS Excel. The Excel spreadsheet must include at a minimum the
specifications listed below:
a. Create two
worksheets. The first worksheet should contain your expected expenses for
start-up cost. The second worksheet what you expect it to cost to run your new
business for the first 6 months.
b. Name the two
worksheets on the tab. The first worksheet should be named "Startup
Costs" and the second "6 Month Expenses."
c. Include the
following information on the first worksheet:
oStart
up costs you might incur to start your business, such as equipment, supplies,
deposits for electric,
water, phone, etc. You may make up items and values based on your business.
Must have at a minimum 5 items.
Example: You need 10 laptops and each cost $1,599. Your
total would be $15,990 for the computers. Fees to have water turned on might be
$250 for a deposit.
o
Formulas for totals of the Startup cost.
o
Appropriate labels to identify all categories, columns, row, totals and other
computed values.
o A
multi-row title section at the top of the first worksheet, merging cells as
needed. Title should include a title for the worksheet, your name, course and
section, and the date.
d. Include the
following format for the first worksheet:
o
Column heading cells should have a background color and the text should be in
Arial 12 point and bold.
o
Totals should be clearly labeled and the values formatted with dollar signs
($).
o Title
section at top of page should be in Font of choice 14 point, bold and a
background color of choice.
e. Include the following information on the
second worksheet:
o
Estimated monthly expenses for the first 6 months, such as salaries (don't
forget your own salary), electric,
water, phone, Internet connection, supplies and anything else you may need. Must have at a minimum 5 expenses.
Example: You have talked to other business owners in the
area and know they spend approximately $275 per month for electricity except in
the winter months when it increases to roughly $350 per month. You need to hire
5 employees and you will start them out with different monthly salaries and
they range from $2500 to $4600 per month (remember months with 31 days should
be a little higher than those with 30 days).
o
Formulas for totals for each month and categories and an overall total for the
6 months.
o
Appropriate labels to identify all categories, columns, rows, totals and other
computed values.
f. Include the following format for the second
worksheet
o
Column heading cells should have a background color and the text should be in
Arial 12 point and bold.
o
Totals should be clearly labeled and the values formatted with dollar signs
($). g. Ensure your workbook
has an appropriate layout that reflects the use of Excel concepts and
techniques covered in class.
h. Ensure all
choices made add to the creation of a professional, well-designed document and
that spelling and grammar are correct.
Part 3: PowerPoint
- Create a slide show that includes 8-10 slides, you could use to present your
business idea to a bank or other investors using MS PowerPoint. The flyer must
include at a minimum the specification listed below.
a. Select a Design Theme. A design theme used throughout the
slide show makes for a more professional looking presentation. There are many
to choose from.
b. Include a title slide. Title slide should include an
appropriate name for your presentation, your name and the date created.
c. Embed your MS Word
Flyer on a slide.. It should not be embedded as an Icon, rather it should be
embedded directly into your slide.
d. Add a slide that highlights your expenses This should
include start-up costs and first 6-months operating expenses.
e. Embed the Expense workbook on a slide. It should not be
embedded as an Icon, rather it should be embedded directly into your slide.
f. Add a final slide. The final slide should include contact
information, such as your phone number (made up), email address, fax number,
etc.
g. Add 4-6 additional slides. These slides should describe
your business, your vision, a mission statement, slogan, etc. Include a slide
explaining how you would promote your business via the internet (through use of
a blog, advertisements on Google web searches, or other method)
h. Add graphics to at least 3 slides The graphics could be
clip art, or pictures. Please make sure you only add .gif or .jpg/jpeg files.
i. Add Transitions between the slides.
j. Ensure your
project is a professional, well designed presentation. Spelling and grammar are
correct. Presentation shows that you have a clear understanding of the concepts
covered in PowerPoint during the course.
Part
4: File Management is an important aspect of using your computer
effectively and sharing files and folders with other. Directions for naming
your files are located under the deliverable section.
1. Ensure your files are properly named as stated under the
deliverables section of these directions, and submitted to the correct dropbox.
No comments:
Post a Comment