Get assignment solution or answer for "Department of Engineering and Technology ManagementETM-110-301: Fundamental Computer TechFall 2021150 Points Microsoft Office Suite ProjectThe current chapter, Chapter 3, focuses on different..."
Question Preview
Department of Engineering and Technology Management
ETM-110-301: Fundamental Computer Tech
Fall 2021
150 Points
Microsoft Office Suite Project
The current chapter, Chapter 3, focuses on different types of application software. One of the most commonly used suites of application software is the Microsoft Office Suite. The purpose of this project is to increase your understanding and skill level when it comes to using this suite of software
Prompt
You have started a new business and are creating all of the publications, materials, and databases yourself. You have decided that you need to create four different publications: a flyer, a presentation, a form and an expenses and billing registry.
Note: You can created your own business, be as creative as you want. Some examples include a made to order cake company, a flower shop,
Required Components
Flyer (30 Points): Use Microsoft Word to create a flyer advertising your business. It should include prices, times, contact information, basic overview of your business, and any other information you deem necessary. Your flyer must be visually appealing and eye catching, so be sure to use colors, graphics, etc.
Presentation (35 Points): Create a PowerPoint presentation containing at least 10 slides. The presentation should be an advertisement for your business and should elaborate on the information pertained in the flyer. Again, make sure it is visually appealing and interesting. Take advantage of the different features in PowerPoint. Your presentation should be on a timer to automatically transition slides after 15 seconds and utilize transitions.
Form (35 Points): Create an order form using Microsoft Access that will automatically create a database infrastructure to go with it. (Databases are covered more thoroughly in Chapter 11, but there are many different online references that can be helpful.)
Registry (50 Points): Use Excel to create a workbook that meets the following criteria. All of the calculations
must be done using Excel formulas and expressions.
- Table 1: Daily expenses:
- Include at least 3 expenses: o Examples: Food/Gas/etc
- Calculate the total costs for each day
- Calculate the total week’s cost for each expense
- Calculate the total cost for the week
- Calculate the average cost for each day
- Calculate the average cost for the week
- Make the table look good o Change the formatting/font/colors
- Table 2: Monthly expenses:
- Include a Salary or Allowance
- Include at least 5 expenses: o Example: Rent/Internet/Electricity/Sewage/Insurance/etc
- Using the weekly expenses from Table 1
- Calculate the total cost per month
- Calculate the profit made each month
- Make the table look good o Change the formatting/font/colors
Answer Preview
Experts are working on this assignment's solution or answer. If you order this assignment at tutordollar, We will update you as soon as possible to your registered email address.
Need any help? Feel free to connect with us.