In this first project exam, you’ll use what you learned about the software development process to plan a PowerPoint presentation—and then organize those steps into a Word document.
In this first project exam, you’ll use what you learned about the software development process to plan a PowerPoint presentation—and then organize those steps into a Word document. To do this, read the following “Scenario” section. Then, follow the instructions as directed. This portion of your exam is worth 50 points. Earn full credit by following the instructions.
Scenario
Your boss’s executive assistant, Julia, unexpectedly resigned. You’ve been promoted under fire. Your first task is to create a PowerPoint presentation for your boss’s (Rita Martin) upcoming meeting with department heads.
Here’s what you know:
1. Rita needs to make a ten-minute speech with slides focused on how much overtime certain departments incurred last year (2021).
2. Rita wants to rank each department’s overtime from highest to lowest. So, the PowerPoint should include at least one chart showing that.
3. You must coordinate with department supervisors, so that they send you correspondent overtime data by next Monday. Today (insert date here). Here are the supervisors’ names and their areas. Assume you know their emails or phone extensions.
a. Warehouse—Robert Metzger
b. Marketing—Trish Philon
c. Accounts Payable—Barbara Halal
d. Shipping—Mark Evans
e. Production—Keith Daniels
4. You must update Rita daily by 4:00 p.m., regarding who has sent data and who hasn’t. She also wants to know what your plan will be to follow up with the slow providers.
5. You must provide a completion date for the finished first draft of the PowerPoint slideshow. The date should give ample time (before Rita’s meeting) for her to review the PP and request changes or add information if necessary.
6. Rita’s meeting will take place in 21 days.
Based on the information included within the “Scenario”, create a Word document that details several steps in your PowerPoint’s planning process. Follow the instructions carefully, including which part of the development process to use.
1.
1. Project title—Title your project “Overtime Presentation Process” (without quote marks).
Center the title
Style the title as a Title from the Styles tab
Reformat the title’s stylized font from the default font to Times New Roman.
Add Bold. Don’t change the title’s font size
2. Footer—Add a footer that includes the following:
Your name (left footer)
Your instructor’s name (center footer)
Current date (right footer)
3. Purpose—Create a new section titled, “Purpose.” (Without quote marks)
Style the section title as Heading 1
Reformat the stylized font to Times New Roman.
Add Bold
Don’t change the font size
4. Intro—Insert the following paragraph beneath the section heading you created. Use 12-point Times New Roman font. Be sure to make the proper changes as indicated: The purpose of this document is to keep track of the relevant steps needed to create (insert boss’s name here) PowerPoint presentations. It is due on (21 days from current date). This development plan includes the five following steps:
5. New section title—Create a new section title called, “Steps.”
Left justify the section title
Stylize it to Headings 2
Add Bold
Reformat the stylized font to Times New Roman
Don’t change the font size
6. List and define—Using the information from the “Scenario” section, create a separate section for the following process development steps. Stylize each step as its own section, using Style type Heading 3. Add Bold to each section heading. Change each Heading 3 section title’s Font to Times New Roman. Do not change the font size.
Step 1 title: Problem
Step 2 title: Goal(s) (Note: Include a main goal and up to 2 added goals.)
Step 3 title: Tasks and Benchmarks (Note: Include relevant dates, benchmarks and names where necessary.)
Step 4 title: Requirements (Note: Assume you have full access to Word, PowerPoint and email.)
Step 5 title: Documentation (Note: Show how you communicated requirements. Include dates and methods. Include how you documented your boss’s requirements, too.)
Step 6 title: Action Plan (Note: Include how many PowerPoint slides your boss’s presentation will have (8). Will it include graphs, charts, images? Which sections might it include?)
Here’s an example of how you should set up each section, including the format. Note, use 12-point Times New Roman font for all text, excluding title sections. Also take note of the extra spacing between sections.
7. Observations—Create a final Headings 2 section titled, “Observations.” Do not change the font size or the font type. Then, beneath the heading’s title, insert three rows of lines for potential notes. To make lines, use the Shapes group within the Insert tab. Select the first line icon from the drop menu and create the line. Then, copy and paste that line twice. Here is an example of how the lines should appear:
8. Edit—When you finish your Word document, run a Spelling and Grammar check. Fix any errors. Then, Save your document as a Word Document and a PDF document. Title each, “Exam 5.”
Following is a sample Word Document, excluding the footer information.
Worth 50.000 points.
In this second project exam, you’ll use what you learned about Excel. Follow the instructions carefully.
2.
1. Create a new Excel Worksheet—Open new worksheet and save it as, “Excel Form Filling” (without quote marks).
2. Beginning in column B2, create the following column headings:
Name
Salary
Commission
Travel Expense
Total Pay Due
Expense Percentage
3. Center and Bold all the column headings. Also, adjust the column widths to neatly fit each heading.
4. Format columns C through F as U.S. Dollar currency with two decimal places.
5. Format column G as a percentage with two decimal places.
6. Render columns B, C, D and E as a Table.
7. Create a form to fill in data for columns B through E.
8. Populate each table row with the following data:
Name: Erick G., Lisa A., Phillip G., Mikaela S.
Salary: 2000 (all)
Commission: 1000, 1237, 1776, 2108
Travel Expense: 250, 280, 320, 350
9. Once you complete all four form-fills, close the form dialog box.
10. In cell F4, create a formula to add the amounts from C4 through E4.
11. Copy and paste the formula to automatically populate cells F5 through F7.
12. In cell G4, create a formula to calculate how the percentage that each employee’s travel expense represents as part of the total Pay Due them.
13. Copy and paste the formula to populate cells G5 through G7.
14. Create a formula in cell C8 to add all the salaries. Add Bold formatting.
15. Copy and paste the formula from C8 into cells D8 through F8.
16. Add All outline format to all cells.
17. Add All outline to cells F2 through F8 and G2 through G8.
18. In cells F2 and G2, change the font color to white and format the background of each cell to black.
19. Create a formula in cell G8 to calculate the average expense percentages.
20. Format cell G8 with bold. Then, format cells C8 through G8 with white font color and black background.
21. Set your orientation layout to Landscape and then Save your worksheet as “Exam 5-2.”
22. Print your work and upload.
Worth 50.000 points.
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.