MS Office Integration Project

,

Shelly Cashman Office 365/2021 | Modules 1-3: SAM Integration Project 1a

Shelly Cashman Office 365/2021 | Modules 1-3: SAM Integration Project 1a

2

Wellpoint Medical Clinic

INTEGRATE EXCEL, ACCESS, WORD, AND POWERPOINT DATA

GETTING STARTED

Save the file SC_EX365_2021_1-3a_ FirstLastName_1.xlsx as SC_EX365_2021_1-3a_ FirstLastName_2.xlsx

Edit the file name by changing “1” to “2”.

If you do not see the .xlsx file extension, do not type it. The file extension will be added for you automatically.

Save the file SC_PPT365_2021_1-3a_ FirstLastName_1.pptx as SC_PPT365_2021_1-3a_ FirstLastName_2.pptx

Edit the file name by changing “1” to “2”.

If you do not see the .pptx file extension, do not type it. The file extension will be added for you automatically.

To complete this Project, you will also need the following files:

Support_AC365_2021_1-3a_Studies.accdb

Support_PPT365_2021_1-3a_Heart.png

Support_WD365_2021_1-3a_Hypertension.docx

With the file SC_EX365_2021_1-3a_ FirstLastName_2.xlsx open, ensure that your first and last name is displayed in cell B6 of the Documentation worksheet.

If cell B6 does not display your name, delete the file and download a new copy.

With the file SC_PPT365_2021_1-3a_ FirstLastName_2.pptx open, ensure that your first and last name is displayed in the presenter notes on Slide 1.

If the presenter notes do not display your name, delete the file and download a new copy.

When downloading Access support files, your browser may display a warning message similar to "This type of file can harm your computer." Project files are always considered safe, so you can disregard this message.

PROJECT STEPS

Margarita Romero is the clinic manager for the Wellpoint Medical Clinic in Columbia, Maryland. The clinic has recently completed its first year of operation, and Margarita is using an Excel workbook to prepare for the annual report, which will include data about revenue and the clinic's health studies. She asks for your help to calculate totals, incorporate data from Access, and insert charts to complete the workbook. Open your Excel Project file workbook, go to the Department worksheet, and then modify it as follows:

Rename the worksheet to use the more descriptive Department Analysis as the worksheet name.

Unfreeze the top rows since Margarita does not need to display them while scrolling.

Format and insert data in the first two rows as follows to provide a date and a more striking worksheet title:

In cell B1, apply the Title cell style.

Add a Bottom Border to cell B1 using the thick line style (2nd column, 5th entry in the Style list) and the Lime, Accent 2 color.

Enter the date 7/29/24 in cell C2.

Using the Number Format list, apply the Short Date number format to cell C2 to display the date with a four-digit year.

Margarita wants to format cell A4 to match cells A12, A19, and A27. Format the cell as follows:

Merge and center the range A4:A9.

Rotate the text up so it reads from bottom to top.

Change the fill color of the cell to Lime, Accent 2, Lighter 60%.

Middle-align the text.

Autofit column A to reduce the width of the worksheet contents.

Format the Quarterly Revenue and Projected Revenue data as follows to make it easier to read:

In the ranges C5:F5 and C9:F9, apply the Accounting number format.

Copy the formatting from the range B5:H9 to the range B20:H24 so that the format of the Projected Revenue data matches the format of the Quarterly Revenue data.

In the range H5:I9, Margarita wants to calculate the annual revenue per department and show the percentage each department contributed to total revenue. Insert formulas to provide these calculations as follows:

In cell H5, enter a formula using the SUM function to calculate the total revenue for the General Medicine Department (range C5:F5).

Copy the formula without formatting from cell H5 to the range H6:H9.

In cell I5, enter a formula without using a function that divides the General Medicine total in cell H5 by the annual total in cell H9 to display the department's percentage of total revenue. Use an absolute reference for cell H9, and then copy the formula without formatting from cell I5 to the range I6:I9.

To display more precise percentages, increase the number of decimal places in the range I5 to I9 to show one decimal place.

Margarita also wants to show the average, maximum, and minimum revenue amounts per department and for all departments. Calculate these statistics in the range J5:L9 by entering formulas as follows:

In cell J5, enter a formula using the AVERAGE function to average the quarterly revenue from the General Medicine Department (range C5:F5). Copy the formula without formatting from cell J5 to the range J6:J9.

In cell K5, enter a formula using the MAX function to find the maximum quarterly revenue from the General Medicine Department (range C5:F5). Copy the formula without formatting from cell K5 to the range K6:K9.

In cell L5, enter a formula using the MIN function to find the minimum quarterly revenue from the General Medicine Department (range C5:F5). Copy the formula without formatting from cell L5 to the range L6:L9.

Providers and staff collectively are eligible for a 20 percent bonus if the total quarterly revenue this year is more than $230,000. Otherwise, the bonus is 15 percent of the quarterly revenue. Next year, the departments will have to earn more than $250,000 per quarter to be eligible for the 20 percent bonus. Apply conditional formatting as follows to highlight the revenue totals eligible for the higher bonus:

In the range C9:F9, apply a conditional formatting Highlight Cells Rule that formats cells greater than 230,000 with Green Fill with Dark Green Text.

In the range C24:F24, apply the same conditional formatting to cells with totals greater than 250,000.

Next, Margarita asks you to complete the Bonuses Earned data in the range C12:H15. The amount eligible for a bonus depends on the quarterly revenue. The providers and staff reimburse the clinic $1250 per quarter for nonmedical services. The final bonus is 35 percent of the remaining amount.

Using the text in cell C12, fill the range D12:F12 with the names of the other three quarters.

In cell C13, enter a formula using an IF function that tests whether cell C9 is greater than 230,000. If it is, multiply cell C9 by 0.20 to calculate the 20 percent eligible amount. If cell C9 is not greater than 230,000, multiply cell C9 by 0.15 to calculate the 15 percent eligible amount.

Copy the formula in cell C13 to the range D13:F13 to calculate the other quarterly bonus amounts.

In cell C15, enter a formula without using a function that subtracts the Share amount (cell C14) from the Amount Eligible (cell C13) and then multiplies the result by the Bonus Percentage (cell C16). Use an absolute reference to cell C16.

Copy the formula in cell C15 to the range D15:F15 to calculate the bonuses for the other quarters.

Margarita has already added Column sparklines in the range G20:G24, but she thinks Line sparklines would show the trends more clearly, as they do in the range G13:G15. She also needs to add sparklines for the Quarterly Revenue data. Add and modify sparklines as follows:

In the range G5:G9, insert Line sparklines for the data range C5:F9.

Apply the Dark Green, Sparkline Style Accent 3, Darker 50% (3rd column, 1st row of the Sparkline Styles gallery) to match the other sparklines in the worksheet.

Change the sparklines in the range G20:G24 to Line sparklines.

The total projected revenue for next year in cell H24 is less than $1,000,000, which is the clinic's goal for the coming year. Margarita wants to know how much more revenue the General Medicine Department would have to earn to result in total revenue of $1,000,000. Use Goal Seek to set cell H24 to 1,000,000 by changing the projected increase percentage for General Medicine (cell C28).

For the annual report, Margarita needs to create a chart comparing the actual quarterly revenue by department. Create the chart as follows:

Create a Clustered Column chart for the quarterly revenue data in the range B4:F8.

Move the chart to a new chart sheet and use Revenue Chart as the worksheet name.

Move the Revenue Chart worksheet after the Department Analysis worksheet so the chart appears after the data.

Use Revenue by Department as the chart title.

Change the number format of the vertical axis to display 0 decimal places and a $ symbol.

Add a primary vertical axis title and use REVENUE as the axis title text.

Change the text direction of the vertical axis title to Stacked.

Save and close your Excel Project workbook, and then open the Access database file Support_AC365_2021_1-3a_Studies.accdb. Margarita wants to include a list of clinic departments in the database. Create a table in Design View as follows:

Add a new field named DepartmentID with the Short Text data type.

Assign the DepartmentID field as the primary key.

Change the field size of the DepartmentID field to 4.

Add a new field called DepartmentName with the Short Text data type.

Save the table using Departments as the name. [ Hint: This step will be credited as correct upon the successful completion of step #18.]

Display the Departments table in Datasheet View, and then resize the columns to their best fit to display the full field names. Add the records shown in Table 1. Save and close the Departments table. [ Hint: This step will be credited as correct upon the successful completion of step #18.]

Table 1: Records for the Departments Table

DepartmentID	DepartmentName
D500	General Medicine
D501	Laboratory
D502	Radiology
D503	Wellness

Open the Providers table in Datasheet View and use the DepartmentID lookup list to add values to the Providers table as shown in bold in Table 2. Close the Providers table. [ Hint: This step will be credited as correct upon the successful completion of step #18.]

Table 2: DepartmentID Values for the Providers Table

ProviderID	First Name	Last Name	Degree	DepartmentID
P107	Dale	Klug	MD	D500
P114	Robert	Hatzinger	MD	D502
P119	Tanesha	Shahidi	NP	D500
P124	Ashley	Togstad	MD	D501
P131	Gerard	Mero	MD	D500
P138	Gloria	Hernandez	RN	D503
P140	Antero	Garcia	RN	D500
P145	Faye	Vancleave	PA	D503

Margarita wants to create two queries to use in the Excel Project workbook. The new Departments table needs to be related to another table in a one-to-many relationship before creating the queries. Open the Relationships window and then create a relationship as follows:

Add the Departments table to the Relationships window to the right of the Providers table.

Create a one-to-many relationship between the primary DepartmentID field in the Departments table and the related DepartmentID field in the Providers table.

Enforce referential integrity on the relationship.

Save and close the Relationships window. Margarita wants to create two queries to use in the Excel Project workbook. First, she wants to list the department for each provider at the Wellpoint Medical Clinic. Use the Simple Query Wizard to create a query as follows:

Include first the ProviderLast field and then the Degree field from the Providers table.

Include the DepartmentName field from the Departments table.

Use ProviderDepts as the query name.

Display the query in Query Datasheet View to view the results and then close the query. [ Hint: This step will be credited as correct upon the successful completion of step #18.]

Margarita also wants to show the number of patients participating in recent health studies at the clinic, including the Hypertension study. Create a query in Query Design View as follows:

Add the Patients, Participants, and Studies tables to the query.

First add the StudyName field from the Studies table to the design grid, and then add the PatientID field from the Patients table.

Add criteria to select only those records where the StudyName field is Arthritis or Cholesterol or Diabetes or Hypertension.

Add a Total row to the query.

Group the query by the values in the StudyName field and count the values in the PatientID field.

Save the query using RecentStudies as the query name.

Display the query in Query Datasheet View to view the results and then close the query. [ Hint: This step will be credited as correct upon the successful completion of step #18.]

Export the queries to Excel as follows:

Export the ProviderDepts query as an Excel file (.xlsx) with the same name to the folder that stores the database. Export the data with formatting and layout. Do not save the export steps.

Export the RecentStudies query as an Excel file (.xlsx) with the same name to the folder that stores the database. Export the data with formatting and layout. Do not save the export steps.

Compact and repair the Support_AC365_2021_1-3a_Studies.accdb database, and then close it. [ Hint: This step will be credited as correct upon the successful completion of step #18.]

Margarita wants to include the exported queries in the Excel Project workbook and then use them to create charts for the annual report. Include the query data as follows:

Open your Excel Project workbook and go to the Studies worksheet.

Open the Excel workbook ProviderDepts.xlsx.

Copy the data in the range A1:C10. Switch to the Studies worksheet in your Excel Project workbook, and then paste the data using no paste options starting in cell A2. Close the ProviderDepts.xlsx workbook.

Open the Excel workbook RecentStudies.xlsx.

Copy the data in the range A1:B5. Switch to the Studies worksheet in your Excel Project workbook, and then paste the data using no paste options starting in cell A14. Close the RecentStudies.xlsx workbook.

Use Patients in Studies as the column heading in cell B14.

In the Studies worksheet, Margarita wants to include a chart showing the number of patients participating in recent studies. Create the chart as follows:

Create a 2-D Pie chart based on the data in the range A14:B18.

Move and resize the pie chart so the upper-left corner is in cell D13 and the lower-right corner is in cell K26.

Change the style of the chart to Style 4 to coordinate with other content in the workbook.

Add Data Labels to the chart at the Outside End of each pie wedge.

Save and close the Excel Project workbook and then open the Word document Support_WD365_2021_1-3a_Hypertension.docx, which is a fact sheet for patients interested in preventing or managing hypertension. Margarita wants to prepare some of the content to use in a PowerPoint presentation. At the bottom of page 2, change the text and formatting of the "Quick Facts" heading as follows so it will better fit the PowerPoint presentation:

In the heading "Quick Facts", use the Thesaurus to replace the word "Quick" with a synonym that begins with the letter F.

Apply the Fill: Green, Accent color 1; Shadow text effect to the heading. [ Hint: This step will be credited as correct upon the successful completion of step #30.]

Format and correct the next paragraph, which begins "According to the…", to use in the presentation:

Left-align the paragraph, which does not need to be centered.

Remove the hyperlink to the American Heart Association because the webpage information is summarized in the following list.

Remove the space before the "According to the…" paragraph to tighten the spacing. [ Hint: This step will be credited as correct upon the successful completion of step #30.]

Revise the list of statistics as follows to make it easier to read:

Clear the formatting from the sentence "81.5% are aware they have it."

Add bullets to the four paragraphs citing statistics, beginning "81.5% are aware they have it." and ending "47.5% are not controlling it."

In the bulleted list only, find and replace the % (percent sign) with a space followed by the word percent to use the correct style for these types of sentences. [ Hint: This step will be credited as correct upon the successful completion of step #30.]

On page 3, Margarita needs to include a table comparing the prevalence of hypertension in the U.S. with the prevalence in Wellpoint patients. Add the table as follows:

Delete the "[Insert table]" placeholder text and replace it with a blank table containing three columns and four rows.

Enter the data shown in Table 3.

Apply the List Table 4 – Accent 2 table style. [ Hint: This step will be credited as correct upon the successful completion of step #29.]

Table 3: Data for Hypertension Table

Age (Years)	U.S. (%)	Wellpoint (%)
18-39	7.3	7.0
40-59	32.2	30.5
60 and older	64.9	61

On page 4, Margarita wants to modify two of the pictures before copying all of them to the PowerPoint presentation. Adjust the pictures as follows:

Add the following alt text to the first picture, the one in the "Physical activity" row: Man enjoying exercise

Flip the picture of the woman walking (in the "Healthy weight" row) horizontally so she is facing the text in the table. [ Hint: This step will be credited as correct upon the successful completion of step #34.]

Save the Word document and keep it open, and then open your PowerPoint Project presentation. Margarita is helping the Wellness Department prepare a presentation on hypertension, one of the diseases the Wellpoint Medical Clinic focused on during a recent study. The Wellness Department will use the presentation to educate patients about high blood pressure.

On Slide 1 ("Hypertension Basics"), ignore all suggested spelling changes to "Wellpoint", which is spelled correctly.

Apply Italic to the "Prepared by the staff of the Wellness Department" text box.

On Slide 2 ("What Is Hypertension?"), format and animate the content placeholder on the left to make the text more meaningful and interesting:

Add bullets to the text in the content placeholder on the left.

Increase the indent of the second bullet ("Blood pressure readings…at least two occasions"), the fourth bullet ("Most common cardiovascular disease"), and the fifth bullet ("About 30% of adults").

Increase the font size of the entire content placeholder on the left by clicking the Increase Font Size button one time.

For the top-level bulleted text ("Definition" and "Prevalence in U.S."), apply Bold and change the font color to Green, Accent 1.

Animate the content placeholder on the left using the Wipe entrance animation.

Change the animation to animate the text All at Once.

Change the direction of the animation to From Left.

Remaining on Slide 2, add a picture to the content placeholder on the right as follows:

Use the content placeholder on the right to insert the picture in the file Support_PPT365_2021_1-3a_Heart.png.

Crop out the red rectangle at the bottom of the picture containing the text "Hypertension".

Margarita wants to insert an Excel chart and a table from Word containing information about Wellpoint patients. Insert a new slide for this content as follows:

Insert a new Slide 3 using the Title Only layout.

Type Wellpoint Patients as the slide title.

Add the following speaker note to the slide as a reminder for the presenters: Data is based on a recent study.

Still on Slide 3 ("Wellpoint Patients"), switch to the Word document Support_WD365_2021_1-3a_Hypertension.docx. Insert content from the document as follows:

Copy the "Prevalence of Hypertension by Age" table on page 3 of the Word document.

Keep source formatting as you paste the table on Slide 3 of the PowerPoint presentation.

Change the font size of the table text to 18 point.

Move the table so its right side aligns with the 6" mark on the ruler and the top is aligned as shown in Figure 1.

Figure 1: Alignment of the Table

Margarita also wants to insert text from the Word document in the PowerPoint presentation. Return to the Word document Support_WD365_2021_1-3a_Hypertension.docx, and then insert the text as follows:

Copy the paragraphs from "Fast Facts" to the fourth bullet ("47.5 percent are not controlling it.") on page 2 of the Word document.

Use the destination theme as you paste the text on Slide 3 of the PowerPoint presentation.

Resize the text box to a width of 6.5" so it is about the same width as the table.

Position the text box below the table as shown in Figure 2, aligning the right side of the text box with the right side of the table.

Figure 2: Position of the Text Box

Margarita also wants to show an Excel chart on Slide 3. Open your Excel Project workbook, go to the Studies worksheet, and then copy and paste a chart as follows:

Copy the Patients in Studies pie chart on the Studies worksheet.

Paste the chart on Slide 3 of the PowerPoint presentation using the Use Destination Theme & Embed Workbook paste option.

Without changing the width, resize the height to 4".

Change the font size of the chart text to 16 point.

Move the chart to the left of the table, and then align the top of the chart with the top of the table.

Close the Excel workbook.

On Slide 4 ("Know the Numbers"), Margarita wants to show something more visually interesting than a bulleted list. She also wants to make it easy to access the website for the Centers for Disease Control and Prevention. Add SmartArt and a hyperlink to the slide as follows:

Convert the bulleted list (from "Normal" to "Higher than 180/120") to SmartArt using the Step Up Process layout.

Change the SmartArt style to Subtle Effect.

Format the text "Centers for Disease Control and Prevention" as a hyperlink to the cdc.cengage.gov webpage.

On Slide 5 ("Prevent and Manage"), Margarita plans to display four pictures and use text boxes as captions to identify the picture content. Add a fourth text box and then arrange the text boxes as follows:

Insert a text box to the right of the "Healthy weight" text box, and then type Manage stress in the new text box.

Resize the "Manage stress" text box to a height of 0.4" and a width of 2".

Align the right side of the "Manage stress" text box with the 5.5" mark on the ruler.

Align the top of the four text boxes with the top of the "Physical activity" text box.

Distribute the four text boxes horizontally.

Switch to the Word document Support_WD365_2021_1-3a_Hypertension.docx. Insert pictures from the Word document on Slide 5 as follows:

On page 4 of the Word document, copy the first picture, which appears in the "Physical activity" row of the table.

Paste the picture on Slide 5 of the PowerPoint Project presentation using the destination theme.

Copy and paste the other three pictures from page 4 of the Word document to Slide 5 of the PowerPoint Project presentation using the destination theme.

Resize all four pictures to a height of 4" and a width of 2.6".

Move each picture below its corresponding text box as shown in Figure 3.

Align the tops of the pictures.

Close the Word document.

Figure 3: Position of the Pictures on Slide 5

Still on Slide 5, adjust the pictures as follows to improve their appearance and unify them on the slide:

Sharpen the "Healthy, low-salt diet" picture by 25%.

Apply the Beveled Matte, White picture style to all four pictures.

Remaining on Slide 5, add a shape as follows to display a tip for maintaining a normal blood pressure:

Insert a Rectangle: Rounded Corners shape.

Resize the shape to a height of 0.65" and a width of 5.8".

Type the following sentence in the rectangle: Moderation and consistency are the keys to success.

Center the rectangle on the slide below the pictures.

Apply the Subtle Effect – Lime, Accent 3 shape style to coordinate more closely with the pictures.

Apply an Offset: Bottom shape effect from the Outer section of the Shadow gallery to include a shadow, which the pictures also have.

Still on Slide 5, Margarita wants to animate the text boxes and rectangle to make them more noticeable. Animate the objects as follows:

Apply the Zoom entrance animation to the rectangle.

Apply the Font Color emphasis animation to the four text boxes.

Change the Start settings for the text box animations to After Previous so each plays in sequence from left to right after the slide is displayed.

Margarita wants to complete the presentation by inserting a footer and a transition. Add these elements as follows:

Insert a footer that includes the slide number and the date.

Display the footer on all slides except the title slide.

Apply the Fade transition from the Subtle section of the Transitions gallery to all the slides in the presentation.

Your completed project should look like the Final Figures on the following pages. Save your changes, close the file(s), and then exit all Office applications. Follow the directions on the website to submit your completed project.

Final Figure

© Vector Stock Icons Stamps/Shutterstock.com; © Spotmatik Ltd/Shutterstock; © Lilly Trott/Shutterstock; © Monkey Business Images/Shutterstock; © mimagephotography/Shutterstock

,

,

ParticipantID	PatientID	ProviderID	StudyID
T370	47	P114	S2057
T371	54	P131	S2057
T380	11	P114	S2079
T381	12	P102	S2079
T382	31	P119	S2079
T384	55	P124	S2079
T385	41	P119	S2079
T386	64	P124	S2079
T387	38	P124	S2079
T388	61	P131	S2079
T390	9	P138	S2079
T391	32	P107	S2079
T392	57	P124	S2079
T400	56	P102	S2091
T401	3	P114	S2091
T403	21	P131	S2091
T404	8	P124	S2091
T405	12	P102	S2091
T406	19	P119	S2091
T407	59	P131	S2091
T408	26	P102	S2091
T409	44	P145	S2091
T411	18	P138	S2091
T420	27	P102	S2104
T421	30	P119	S2104
T422	52	P131	S2104
T423	28	P124	S2104
T424	4	P107	S2104
T426	50	P114	S2104
T429	48	P145	S2104
T431	1	P102	S2104
T432	29	P131	S2104
T433	49	P138	S2104
T434	55	P124	S2104
T435	18	P138	S2104
T436	39	P119	S2104
T440	34	P107	S2116
T441	16	P131	S2116
T442	7	P145	S2116
T444	40	P102	S2116
T445	2	P140	S2116
T446	63	P102	S2116
T448	13	P145	S2116
T450	6	P138	S2116
T451	22	P124	S2116
T453	41	P119	S2116
T454	23	P119	S2116
T455	17	P145	S2116
T456	57	P124	S2116
T457	26	P102	S2116
T458	65	P102	S2116
T459	44	P145	S2116
T460	14	P107	S2116
T461	24	P140	S2116
T470	61	P145	S2127
T471	4	P107	S2127
T472	62	P114	S2127
T473	64	P124	S2127
T475	59	P131	S2127
T476	18	P138	S2127
T477	46	P119	S2127
T478	21	P131	S2127
T480	40	P102	S2127
T481	51	P124	S2127
T490	5	P131	S2131
T491	22	P114	S2131
T492	53	P138	S2131
T494	25	P119	S2131
T495	47	P114	S2131
T497	54	P131	S2131
T498	11	P114	S2131
T499	12	P102	S2131
T500	31	P119	S2131
T501	55	P124	S2131
T503	38	P124	S2131
T504	9	P138	S2131
T506	32	P107	S2131
T508	56	P102	S2131
T509	8	P124	S2131
T510	19	P119	S2131
T511	42	P114	S2131
T512	20	P107	S2131
T515	58	P102	S2131
T516	10	P124	S2131
T302	42	P102	S2011
T303	20	P107	S2011
T305	41	P119	S2011
T306	58	P102	S2011
T307	50	P114	S2011
T309	57	P124	S2011
T310	61	P131	S2011
T312	3	P114	S2011
T313	36	P102	S2011
T315	35	P131	S2011
T316	64	P124	S2011
T318	59	P131	S2011
T319	63	P102	S2011
T320	45	P107	S2011
T321	21	P131	S2011
T322	27	P102	S2011
T323	22	P114	S2011
T330	43	P145	S2024
T331	7	P145	S2024
T332	33	P140	S2024
T334	30	P119	S2024
T335	13	P145	S2024
T337	37	P119	S2024
T338	24	P140	S2024
T339	14	P145	S2024
T341	17	P145	S2024
T342	23	P119	S2024
T350	50	P114	S2057
T351	4	P107	S2057
T353	35	P131	S2057
T354	59	P131	S2057
T356	18	P138	S2057
T357	63	P102	S2057
T358	45	P107	S2057
T360	46	P119	S2057
T361	21	P131	S2057
T362	40	P102	S2057
T364	51	P124	S2057
T365	5	P131	S2057
T366	22	P124	S2057
T367	53	P138	S2057
T369	25	P119	S2057

PatientID	LastName	FirstName	Gender	DOB	Street	City	State	Zip	Phone
1	Gomez	Manuel	M	1990-04-02	2119 W Dayton St	Columbia	MD	20588	2405554431
2	Duley	Rhoda	F	1993-07-17	3545 N Burke Rd	Columbia	MD	21044	3015555602
3	Levy	Andrew	M	1958-09-24	110 S Aspen Ct	Columbia	MD	21075	3015555108
4	Levy	Jennifer	F	1959-03-24	110 S Aspen Ct	Columbia	MD	21075	3015555110
5	Li	Deng	M	1975-01-16	1240 E Galway Dr	Columbia	MD	21150	4105556531
6	Engleberger	Todd	M	1994-06-14	3905 Meadow Dr	Columbia	MD	21044	4435557188
7	Suarez	Maria	F	2010-03-27	8530 Mayo Ave	Ellicott City	MD	21150	4435555734
8	Suarez	Liliana	F	1985-08-30	8530 Mayo Ave	Ellicott City	MD	21150	4435555734
9	Suarez	Omar	M	1983-07-05	8530 Mayo Ave	Ellicott City	MD	21150	4435551361
10	Curwick	Lawrence	M	1954-12-12	1324 E Upland Rd	Columbia	MD	20588	2405559284
11	La Haye	Janelle	F	1980-10-04	716 N Roblyn Pl	Columbia	MD	21075	3015554432
12	Wimmer	Daniel	M	1980-12-05	716 N Roblyn Pl	Columbia	MD	21075	3015552412
13	Torres	Luis	M	2000-04-13	3791 W Tuileen Rd	Columbia	MD	21150	3015555832
14	Severson	Renee	F	1998-10-24	1280 S Gils Way	Columbia	MD	21044	4105552125
15	Bohn	Warren	M	2006-11-16	24 High Woods Ln	Savage	MD	20794	3015551524
16	Bohn	Robin	F	1993-03-06	24 High Woods Ln	Savage	MD	20794	3015551524
17	Quam	Amanda	F	1997-05-24	1452 N Wickham Ave	Columbia	MD	21150	4105552450
18	Shen	Junjiang	M	1963-02-14	1433 S Baxter	Columbia	MD	21044	4435551761
19	Petri	Carrie	F	1986-10-05	117 S Aspen Ct	Columbia	MD	21075	3015552724
20	Windelborn	Mitchell	M	1950-01-10	2523 E Carrolltown Ln	Columbia	MD	20588	2405552901
21	Maradiagan	Sathsivam	M	1967-04-22	4904 W Gordon Dr	Columbia	MD	21075	3015552087
22	Hamdan	Kamal	M	1975-06-07	1860 N Chestnut Way	Columbia	MD	20794	4105551110
23	Jaworski	Maya	F	1994-11-01	410 E Lincoln Pl	Columbia	MD	21075	3015550788
24	Hulsey	Heather	F	1999-04-25	6971 W Glenway	Ellicott City	MD	21150	4435556973
25	Khoury	Sida	M	1978-12-23	8731 E Woodburn	Columbia	MD	21044	3015557005
26	Marquez	Gilberto	M	1987-06-11	1819 S Baxter	Columbia	MD	21044	4105550809
27	Johnson	Leanne	F	1969-01-26	545 W Monroe Ct	Columbia	MD	21075	3015553747
28	Purcell	Melissa	F	1988-08-14	1976 N Farrell Dr	Columbia	MD	20588	2405555525
29	Bowden	Anne	F	1990-09-20	1323 E Scott Ave	Columbia	MD	20588	3015559198
30	Calcari	April	F	2003-10-20	175 N Woods	Columbia	MD	21044	4435557253
31	McCormick	Patrick	M	1981-07-18	2113 N Henry St	Columbia	MD	21075	2405552749
32	McCormick	Theresa	F	1983-09-25	2113 N Henry St	Columbia	MD	21075	2405552749
33	McCormick	Kerry	M	2004-09-14	2113 N Henry St	Columbia	MD	21075	2405552749
34	Lin	Tien-Min	M	1992-11-07	1630 N Linden St	Columbia	MD	20794	3015551626
35	Wilfong	Tanya	F	1960-07-03	5524 W Fall Oaks	Columbia	MD	21150	4435550177
36	Blystone	Valerie	F	1958-10-09	973 E Grove Rd	Columbia	MD	21044	4105554879
37	Nikolai	Alex	M	2000-02-18	455 E Warbler Way	Columbia	MD	20588	3015555611
38	Samatar	Delia	F	1982-04-21	1624 W Sawyer Rd	Columbia	MD	21044	4435550257
39	Gutag	Arvid	M	1992-07-08	418 S Jason St	Ellicott City	MD	21150	4105557048
40	Tian	Linzhu	M	1970-11-14	1490 N Park St	Columbia	MD	21044	3015554498
41	Lamont	Bradley	M	1950-04-22	902 N Henry St	Columbia	MD	21075	3015551556
42	Andrews	John	M	1948-03-01	645 Valley Rd	Savage	MD	20794	3015551377
43	Gui	Mina	F	2010-12-16	5514 S Randall Dr	Columbia	MD	21075	2405559113
44	Gui	Sonja	F	1987-12-18	5514 S Randall Dr	Columbia	MD	21075	2405559113
45	Preidecker	Howard	M	1964-09-02	701 E Sky View Pl	Columbia	MD	20588	4435557140
46	Swain	David	M	1966-11-09	1655 N Plains Rd	Columbia	MD	20794	3015559797
47	Koratko	Keshena	F	1980-05-12	902 S Holliday Dr	Columbia	MD	21044	4105550520
48	Hoffman	Charity	F	1989-01-17	1417 E Erwood	Columbia	MD	20588	3015556724
49	Jackson	Verilee	F	1991-06-24	2823 W Glenwood	Columbia	MD	21044	3015551601
50	Jaimez	Nestor	M	1951-02-08	840 W Violet Ln	Columbia	MD	21150	4435553344
51	Shamji	Naveed	M	1971-11-02	3704 W Glenway	Ellicott City	MD	21150	3015552392
52	Thurow	Alice	F	1988-03-14	139 E Hollyhock Way	Columbia	MD	20588	3015557403
53	Hidalgo	Rocio	M	1978-07-19	109 S Maria Pl	Columbia	MD	21075	4435555617
54	Hidalgo	Irena	F	1980-08-03	109 S Maria Pl	Columbia	MD	21075	4435550344
55	Fullenkamp	Susan	F	1981-10-14	1584 W Lake Rd	Columbia	MD	21044	3015553186
56	Sallah	Diana	F	1984-09-10	214 S Pearl St	Columbia	MD	20588	3015550043
57	Amberson	Darlene	F	1953-04-20	1433 E Cypress St	Columbia	MD	21075	2405551343
58	Josephson	Herb	M	1950-06-13	1238 N Cardinal Dr	Columbia	MD	20794	3015556514
59	Stanton	James	M	1962-09-28	1433 W Ridge Rd	Columbia	MD	20588	3015551882
60	Renneburg	Debra	F	1956-07-10	2308 S Pine St	Columbia	MD	20588	3015554467
61	Harmon	Linda	F	1954-04-22	4415 E Shady Way	Columbia	MD	21150	4435551603
62	Gray	Sheila	F	1961-11-11	3011 S Shorewood Rd	Columbia	MD	21075	3015558466
63	Tham	Chee	F	1963-10-02	726 E Vernon Rd	Columbia	MD	20588	3015556173
64	Wanninger	Hilde	F	1962-01-16	6170 N Bayridge St	Columbia	MD	21044	2405550887
65	Ortega	Victor	M	1997-07-05	1381 S Pleasant St	Columbia	MD	20588	4435556264

ProviderID	ProviderFirst	ProviderLast	Degree	DepartmentID
P102	Elena	Ortiz	MD	D500
P107	Dale	Klug	MD
P114	Robert	Hatzinger	MD
P119	Tanesha	Shahidi	NP
P124	Ashley	Togstad	MD
P131	Gerard	Mero	MD
P138	Gloria	Hernandez	RN
P140	Antero	Garcia	RN
P145	Faye	Vancleave	PA

StudyID	StudyName	StartDate	EndDate	MinParticipants	MaxParticipants
S2011	Arthritis	2019-01-16	2019-07-16	15	50
S2024	Asthma	2019-03-01	2019-12-01	10	50
S2057	Cholesterol	2019-06-15	2019-12-15	15	35
S2079	Diabetes	2019-08-01	2019-02-01	10	25
S2091	Chronic Pain	2020-01-20	2020-06-20	10	50
S2104	Hearing Loss	2020-02-01	2020-08-01	10	25
S2116	Migraine	2020-02-15	2021-02-15	15	50
S2127	Thyroid	2020-03-01	2020-08-01	10	30
S2131	Hypertension	2020-06-01	2021-06-01	15	50

,

		HYPERTENSION FACTS
		Wellpoint Medical Clinic

Overview

Hypertension, or high blood pressure, is the most common cardiovascular disease.

Blood pressure is the force of blood pushing against the walls of your arteries. Because the arteries carry blood from the heart to other parts of the body, blood pressure is an indication of heart health.

Your blood pressure rises and falls during the day in response to activities and diet.

Blood Pressure Measurements

The only way to know if you have hypertension is to measure your blood pressure. A blood pressure monitor measures systolic and diastolic pressure. Both use units of mmHg. Systolic is the top number and measures the pressure in your arteries when your heart beats. Diastolic is the bottom number and measures the pressure in your arteries when your heart rests between beats.

Consistent blood pressure readings of 120/80 mmHg or lower are considered normal. Higher numbers indicate that your heart is working too hard to pump blood to the rest of your body.

· Normal: 90–120/60–80

· Elevated: 120–129/60–80

· Hypertension Stage 1: 130–139/80–89

· Hypertension Stage 2: 140–179/90–119

· Critical: 180/120 or higher

Normal blood pressure means you should maintain a healthy lifestyle to prevent hypertension. Elevated blood pressure has a good chance of developing into hypertension but can be managed with diet and exercise. You can also manage Hypertension Stage 1 with diet and exercise, though you might also need medication. Hypertension Stage 2 is a serious condition that requires medication and changes in lifestyle habits. Critical blood pressure readings need urgent care even if you experience no symptoms.

Hypertension Prevalence

About 30 percent of adults in the U.S. have hypertension. It is more likely in people with a family history of high blood pressure, heart disease, or diabetes. It is also more common in people who are older than 55, overweight, inactive, and drink or smoke heavily.

Quick Facts

According to the American Heart Association, of people who have hypertension:

81.5% are aware they have it.

74.9% are under current treatment.

52.5% are controlling it.

47.5% are not controlling it.

Wellpoint Patients

Wellpoint Medical Clinic conducted an extensive survey of its patients to assess and monitor treatments of common cardiovascular diseases, including hypertension. Prevalence as compared to the general U.S. population is shown in the following table. As a Wellpoint patient, you are doing well to keep these numbers below the national average.

Prevalence of Hypertension by Age

[Insert table]

Prevention and Treatment

Even if your blood pressure is normal, you should do what you can to lower your risk of developing hypertension, especially as you age.

You can prevent and manage hypertension through changes to your lifestyle. Approaches that have proven to be effective are eating a healthy diet low in sodium (salt) and high in potassium. Bananas, potatoes, salmon, lentils, and Brussels sprouts are a few of the foods high in potassium. A diet that is lower in fat and includes plenty of whole grains, fruits, and vegetables is a healthy way to prevent many cardiovascular diseases.

To decrease sodium intake, read food labels and choose low-salt products when they are available. Eat fewer processed foods in general to avoid added salt. Gradually replace salt in the food you cook with herbs and spices.

Part of a healthy diet is moderation in eating and drinking alcoholic beverages. Drinking more than moderate amounts of alcohol can raise blood pressure and reduce the effectiveness of blood pressure medications. Some people are also sensitive to caffeine and experience a rise in blood pressure when they consume coffee and other caffeinated beverages.

Getting regular exercise can also lower your blood pressure. Part of your exercise routine should include aerobic exercise, such as brisk walking or biking. Aerobic exercise makes your heart beat harder and use more oxygen than usual. Exercise should become part of your daily activities to prevent and treat high blood pressure.

Being overweight or obese significantly increases your risk for hypertension. Maintaining a healthy weight reduces the risk for other health problems as well. Weight loss is one of the most effective ways to control high blood pressure if you already have it.

Learning how to relax and manage stress can improve your physical and emotional health and lower high blood pressure. Stress management includes exercising, relaxing to music, meditating, and performing yoga.

The following table summarizes the prevention and treatment strategies for hypertension.

Physical activity Engage in at least 150 minutes of physical activity each week, which is 30 minutes a day for five days a week.
Healthy, low-salt diet Eat a diet rich in whole grains, fruits, and vegetables and low in saturated fats, cholesterol, and sodium.
Healthy weight Maintain a healthy weight, reducing pounds, if necessary, especially around the waistline.
Manage stress Make time to relax and engage in activities you enjoy. Get the amount of sleep you need every night, and find solutions, such as yoga or meditation, that reduce stress for you.

image4.jpeg

image5.jpeg

image6.jpeg

image1.png

image2.svg

.MsftOfcThm_Accent1_Fill { fill:#549E39; } .MsftOfcThm_Background1_Stroke { stroke:#FFFFFF; }

image3.png