Reference no: EM132475499
Assessment 1:
Create the Presentation Outline
1. Start Word and create a new blank document.
2. Display the document in Outline view and type the outline shown in the figure, being sure to place topics at the indicated level.
3. Save the document, naming it Project Outline.
4. Close the document.
Create a Spreadsheet and a Chart
1. Start Excel and create a new blank workbook.
2. Enter data as shown in the figure.
3. Convert the data into a pie chart. Be sure that you select a chart style that includes the percentage figures somewhere on the chart.
4. Save the workbook, naming it Homelessness Statistics.
Create a Word Table
1. Start Word and create a new blank document.
2. Create a 2 × 4 table with the information shown in the figure. Choose a table style similar to that shown, merge the first row of cells, and center and format the title appropriately.
3. Save the document, naming it Impoverished Hungry.
4. Close the document.
Create the Presentation
1. Start PowerPoint and create a new blank presentation.
2. Use the appropriate command to add slides from the Project Outline document.
3. Delete the first slide, which isn't part of the presentation, and then reset the remaining slides to match the PowerPoint presentation formatting.
4. Change the layout of the first slide to Title Slide layout.
5. Change the theme of the presentation to Frame. Slide 1 should look similar to the figure.
6. Display slide 3, delete the text box with the bullet item placeholder, and then copy and paste the Homelessness Statistics chart.
7. The chart data labels need to be read from a distance. Format text in each label to 20 point. Size and position the chart so that your slide looks similar to the figure.
8. Display slide 4, delete the text box with the bullet item placeholder, and then embed the Impoverished Hungry table.
9. The table text is too small to be seen from a distance. Edit the table from within PowerPoint to display 16 point text. Size and position the table so that your slide looks similar to the figure.
10. Save the presentation, naming it Sociology Project.
11. Add the following lecture notes to slide 3, Homelessness:
The issues related to homelessness are complex.
Working homeless individuals hold a job but may not be making enough to afford housing.
Homelessness can occur when a child in foster care turns 18 and doesn't have the needed support to transition to independent living.
Veterans can suffer from mental illness, poor health, disabilities, or a combination of any of these.
Other problems that increase risk of homelessness are related to mental illness, domestic violence, disability, poor physical health, and substance abuse.
12. Add the following lecture notes to slide 6, How can our college community help?:
Our college campus community can help reduce hunger for those in need. The Backpack program may be especially popular on a college campus because this effort fills school backpacks with nonperishable nutritious snacks and school supplies for elementary students.
13. Apply the Uncover transition to all the slides.
14. Set the presentation to advance the slide show after 5.00 seconds and apply this option to all slides. In Slide Sorter view, your presentation should look like the figure.
15. Save the modified presentation and then play the slide show from the beginning to check your presentation.
16. You'll submit your presentation as a video. Export your presentation as an .mp4 video file.
17. Save the presentation again.
Assessment 2
Instructions
Create the Clients Database
1. Start Access and create a new Blank database named "Clients."
2. Name the new table "Clients," and then display it in Design view.
3. Edit the ID field to be Client ID. Verify that it's data type AutoNumber and that it has been selected as the primary key.
4. In Design view, add the remaining fields and corresponding data types:
|
Field Name
|
Data Type
|
|
Company Name
|
Short Text
|
|
First Name
|
Short Text
|
|
Last Name
|
Short Text
|
|
Job Title
|
Short Text
|
|
Address
|
Short Text
|
|
City
|
Short Text
|
|
State
|
Short Text
|
|
Zip
|
Short Text
|
5. Save and then close the Clients table.
6. Create a Clients form that looks similar to the figure below.
7. Use the Clients form to populate the Clients table with the records listed below.
8. Close the Clients database.
Create a Letterhead
1. Start Word and create a new Blank document.
2. Type "ABC Engineering Company" and then press Enter.
3. Type "1552 Carbondale Road" and then insert a bullet character.
4. Type "Any Town, FL 33334" and then press Enter.
5. Format the first line of the letterhead as Verdana 16-point bold and center the paragraph.
6. Format the second line of the letterhead as Verdana 12-point italic and center the paragraph.
7. Format the last, blank paragraph as Times New Roman 12-point with No Spacing paragraph style. Your letterhead should look similar to the figure.
8. Save the document, naming it "Letterhead."
Create the Estimates Letter
1. With the insertion point in the blank paragraph below the letterhead, type the text shown in the figure below, inserting merge fields where indicated.
2. On the File tab, click Save As and then save the document with the name "Estimates."
Embed an Excel Worksheet Object
1. With the insertion point in the second blank paragraph after ". . . costs for three scenarios:", insert an Excel worksheet object to embed a new spreadsheet.
2. Enter data as shown in the figure below. Center and bold column labels and format Site data to display commas with 0 decimal places.
3. Format cells C3 through F4 as Currency with 0 decimal places.
4. Enter formulas in column C to calculate Equipment costs as 15 times the site size.
5. Enter formulas in column D to calculate the Labor costs as 10 times the site size.
6. Enter formulas in column E to calculate the Overhead and Profit (O & P) as 0.25 times the sum of equipment and labor costs.
7. Use a function in a formula to calculate the total costs in column F for each scenario.
8. Size the worksheet object so just the cells with data are displayed, as shown in the figure.
Merge Field Data
1. Use the appropriate command to merge the field data and create a document containing the individual letters.
2. Save the merged document, naming it "Merged Estimates." Your first letter should look similar to the figure below.
Attachment:- exam Instructions.zip