Scenario

You are newly appointed to the communications team for a reputable, multi-faceted philanthropic organization, Momentum for Better. The current task for your team is to create a brand-new campaign that promotes Diversity, Equity, and Inclusion. To kick off this campaign, you have been asked to develop a mood board presentation and written summary that you will present to leadership at the upcoming annual meeting.

You are reminded that a mood board is a deliverable—a collage of images, colors, patterns/textures, and text—that visually describes the intended look & feel of the campaign.

You DON’T need to be an artist or designer to create a mood board, but you DO need to have a keen understanding of what various visuals communicate and how they make people feel. Keep in mind the various ways that you analyzed and evaluated visuals throughout this course.

Instructions

Mood Board Presentation

1. First, create a Microsoft PowerPoint presentation. Your presentation will need to have the slides listed below clearly labeled.
2. Visually compelling title slide
3. Colors and Patterns
4. Logos, Ethos, Pathos
5. Graphics
6. Delivery Methods
7. Memes
8. Second, think about the overall look & feel that you want the campaign to have. Then, search the web for examples of the kinds of images, graphics, colors, and patterns/textures that you have in mind.
9. Third, copy and paste those images, graphics, etc., into the appropriate slides of your Microsoft PowerPoint presentation. You must have at least four (4) images per slide, except for the Memes slide, which just needs two (2). The images should fill up as much of the slide as possible but DON’T stretch or squish the images. Here is more detail about the types of images you need to include in the slides.
10. Visually compelling title slide
11. Include one main image and a title for your presentation.
12. Include the organization’s name, Momentum for Better.
13. Colors and Patterns
14. Your color scheme must feature two colors.
15. Images of color swatches or things that are your chosen colors (e.g., fire engine red, canary yellow, etc.).
16. Patterns or textures that feature strong use of lines (e.g., stripes, swirls, borders, plaid, etc.).
17. Logos, Ethos, Pathos (choose one main rhetorical approach)
18. Photos of people that signify your chosen rhetorical approach.
19. Photos must include people of various genders, ethnicities, and ages.
20. Graphics
21. Logo and/or symbol graphics that convey diversity, equity, and inclusion.
22. Delivery Methods
23. Images of two (2) chosen delivery methods for spreading awareness about the campaign. For example, if you want social media to be one of the options, then include photos of a person using social media.
24. Memes
25. Create two (2) positive, inspiring memes that fit the overall message of Diversity, Equity, and Inclusion. Don’t make the memes funny, satirical, or divisive.
26. You can only use public domain or Creative Commons licensed images. You CAN’T use images from movies, shows, comics, books, video games, etc.
27. You may use PowerPoint, Canva, Adobe Express, Microsoft Paint, or any other app to create the memes. Save them as a JPG or PNG file, then insert them into your PowerPoint presentation.
28. Fourth, as you develop the visually compelling title slide and all the other slides, you need to demonstrate your understanding of visual presentation. In other words, your slides need to be aesthetically pleasing with good visual connectivity.

Written Summary

Once you’ve finished creating your mood board presentation, you need to write a detailed summary explaining why you chose the visuals that you did. Your summary should include the following:

1. In a Microsoft Word document, use APA formatting. The title on your title page must match the title slide of your mood board presentation.
2. Your introductory paragraph must explain your overall intended look & feel for the campaign and how it will communicate Diversity, Equity, and Inclusion. For example, will it be serene, energetic, serious, or something else?
3. Include section headings in your summary, and these must match the slide labels from your mood board presentation.

Each section must contain 2–3 full paragraphs explaining your chosen images in detail. Keep in mind how you’ve analyzed and evaluated visuals throughout this course. Connect them to the overarching message of Diversity, Equity, and Inclusion. You’ll be graded on your ability to defend your choices and clearly articulate your analysis.

Submit a PowerPoint presentation (PPTX) and Microsoft Word document (DOCX).

Freezing Panes & View Options – Challenge activity

1. Follow the instruction given here 
   • Freeze First Column and use the horizontal scroll bar to look at sales from 2015.
   • the first column.
   • Select cell G17 and select Split to split the worksheet into multiple panes. Hint: This should split the worksheet between rows 16 and 17 and columns F and G.
   • Use the horizontal scroll bar in the bottom right of the window to move the worksheet so that Column N, which contains data for January 2015, is next to Column F.
   • Open a new window for your workbook, and select the 2012-2013 Sales
   • Move your windows so they are side by side. Now you’re able to compare data for similar months from several different years.
2. Use the file provided on the site. Create a screen shot of your edited document and paste it in Word before saving. Save as YourName_FreezingAndView.docx

30

Sorting Data – Challenge activity

1. Follow the instruction given here
   • Selecct Challenge in the bottom-left of the workbook.
   • For the main table, create a custom sort that sorts by Grade from Smallest to Largest and then by Camper Name from A to Z.
   • Create a sort for the Additional Information section. Sort by Counselor (Column H) from A to Z.
2. Use the file provided on the site. Create a screen shot of your edited document and paste it in Word before saving. Save as Sorting.docx

15

Filtering Data – Challenge activity

1. Follow the instructions given here
   • Select Challenge in the bottom-left of the workbook.
   • Apply a filter to show only Electronics and Instruments.
   • Use the Search feature to filter item descriptions that contain the word Sansei. After you do this, you should have six entries showing.
   • Clear the Item Description filter.
   • Using a number filter, show loan amounts greater than or equal to $100.
   • Filter to show only items that have deadlines in 2016.
2. Put your name on the file and screen shot the document showing your name. Paste the screenshot into Word before saving as YourName_Filtering.pdf. (Be sure to save it as a PDF file.)

Data flows freely throughout the internet, corporate, and commercial networks. Privacy has become paramount to businesses big and small. Understanding privacy concerns and where they come from is important you as a student, individual, employee, etc.

Pick a topic below and post your reply by Wednesday at midnight. Your response should be at least 400 words and appropriately cites your resources. 

Topics:

• What is freedom of surveillance? How does it apply to you at your place of employment? Are there exceptions?
• What is an inadvertent leak of information? How has it affected the adoption of technology?
• How do businesses benefit from search engines?
• Should we allow facial recognition at sporting events? What about shopping malls?
• How much should a user post on social media? Why?

Independent Project 6-5

Windows   Mac

Classic Gardens and Landscapes counts responses to specialty promotions to determine effectiveness. You use SUMIFS and an IFS formula to complete the summary. You also calculate insurance statistics and display full names in one cell.

[Student Learning Outcomes 6.1, 6.2, 6.3, 6.6, 6.7]

File Needed: ClassicGardens-06.xlsx (Available from the Start File link.)

Completed Project File Name: [your name]-ClassicGardens-06.xlsx

Skills Covered in This Project

• Nest MATCH and INDEX functions.
• Create DSUM formulas.
• Build an IFS function.
• Build SUMIFS formulas.
• Use TEXTJOIN to join labels.

1. Open the ClassicGardens-06 start file. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it.
2. Create a nested INDEX and MATCH function to display the number of responses from a city.
   1. Click the Mailings sheet tab and select and name cells A3:D28 as Responses.
   2. Click the Mailing Stats sheet tab.
   3. Click cell B21 and type Carthage.
   4. Click cell C21, start an INDEX function, and select the first argument list option.
   5. Choose or type the Responses range name for the Array argument.
   6. Click the Row_num box and nest a MATCH function. Select cell B21 for the Lookup_value and cells A3:A28 on the Mailings sheet for the Lookup_array. Click the Match_type argument box and type 0.
   7. Click INDEX in the Formula bar. Click the Column_num box and nest a second MATCH function to look up cell D3 on the Mailings sheet in the lookup array A3:D3.
   8. Click the Match_type box and type 0 (Figure 6-106) and click OK. The result displays as 343.00.Figure 6-106 Nested MATCH and INDEX functions
   9. Format the results to show zero decimal places.
   10. Type Smyrna in cell B21.
3. Use DSUM to summarize mailing data.
   1. Select the Mailings sheet and note that number mailed is located in the third column and response data is in the fourth column.
   2. Click the Criteria sheet tab. Select cell B2 and type lan* to select data for the Landscape Design department.
   3. Type law* in cell B5 for the Lawn & Maintenance department.
   4. Type pat* in cell B8 for the Patio & Furniture department.
   5. Click the Mailing Stats sheet tab and select cell B7.
   6. Use DSUM with the range name Responses as the Database argument. Type 3 for the Field argument (# Mailed column), and enter an absolute reference to cells B1:B2 on the Criteria sheet as the Criteria argument.
   7. Copy the formula to cell C7 and edit the Field argument to use the fourth column (# Responses).
   8. Use DSUM in cells B8:C9 to calculate results for the two remaining departments.
4. Use SUM in cells B10:C10.
5. Format all values as Comma Style with no decimal places.
6. Create an IFS function to display a response rating. Note: If your version of Excel does not include the IFS function, build the following nested IF function =IF(C7/B7>=20%,$C$15,IF(C7/B7>=15%,$C$16,IF(C7/B7>=11%,$C$17,$C$18))) to display the rating.
   1. Click cell D7. The response rate and ratings are shown in rows 14:18.
   2. Start an IFS function and select C7 for the Logical_test1 argument. Type / for division and select cell B7. Type >=20% to complete the test.
   3. Click the Value_if_true1 box, select C15, and press F4 (FN+F4) (Figure 6-107).Figure 6-107 First Logical_test and Value_if_true arguments
   4. Click the Logical_test2 box, select C7, type /, select cell B7, and type >=15%.
   5. Click the Value_if_true2 box, click cell C16, and press F4 (FN+F4).
   6. Complete the third and fourth logical tests and Value_if_true arguments (Figure 6-108).Figure 6-108 Completed IFS function arguments
   7. Copy the formula in cell D7 to cells D8:D10.
7. Use SUMIFS to total insurance claims and dependents by city and department.
   1. Click the Employee Insurance sheet tab and select cell E25.
   2. Use SUMIFS with an absolute reference to cells F4:F23 as the Sum_range argument.
   3. The Criteria_range1 argument is an absolute reference to cells E4:E23. The Criteria1 argument is bre* to select the city of Brentwood.
   4. The Criteria_range2 argument is an absolute reference to cells D4:D23, the department column, with criteria of lan* to select the Landscape Design department.
   5. Click OK. The result for cell E25 is 10.
   6. Build SUMIFS formulas for cells E26:E28 based on the criteria displayed in cells C26:C28.
   7. Format borders to remove inconsistencies, if any, and adjust column widths to display data.
8. Use TEXTJOIN to display names. Note: If your version of Excel does not include the TEXTJOIN function, use CONCAT or CONCATENATE to build the function.
   1. Click the Full Names sheet tab and select cell E4.
   2. Start a TEXTJOIN function and press Spacebar for the Delimiter argument.
   3. Click the Text1 box and select cell C4.
   4. Complete the Text2 and Text3 arguments to show middle and last names and click OK (Figure 6-109).Figure 6-109 Delimiter is a space
   5. Copy the formula to display full names in column E.
9. Save and close the ClassicGardens-06 Excel workbook (Figure 6-110).

Create your own acceptable use policy (AUP) for the computers and network access for your school or organization. Make sure to cover computer use, Internet surfing, email, web, and password security. Compare your policy with those of other students in the class. Finally, locate the acceptable use policy for your school or organization. How does it compare with yours? Which policy is stricter? Why? What changes would you recommend in the school’s or organization’s policy?

Include, security awareness and training available at your school or place of business? How frequently is it performed? Is it available online or in person? Is it required? Are the topics up-to-date? On a scale of 1–10, how would you rate the training?

Write a one-page paper on your findings.