The questions begin on the next page. You can use the tabs at the top to navigate to the different sections, but before you submit the test you are required to answer every question. There are 31 questions worth a possible 100 points total. 

Please note that you will be required to download some sample data via a Dropbox link that is provided in the relevant section. If you are unable to access Dropbox, please email the Training Committee at training@iaca.net and we will email the file to you. 

11. Exercise 1: Use the following information to create a manual link diagram. Create a PDF or image or your association chart: (20 pts)

 

 Create the following links: 

Make the following changes:

Change the link label for the “Associate” link between MADISON, William and MADISON, Amanda to “Spouse”

Change the link label for the “Subscriber” link between MADISON, Amanda and 2394513234 to “Work”

Change the size of MADISON, William to 3X

Add a dark blue frame to MADISON, Amanda

Change the line strength between MADISON, William and 5569870012 to tentative.

Change the line width between MADISON, Amanda and MADISON, William to 10 and the line color to red.

Add pictures (your choice, but keep them of people) to MADISON, William and MADISON, Amanda

Put a corner on the link between MADISON, William and 2012 Toyota Camry

 

12. Exercise 2: Create the following cards. Create a PDF of the Card List for MADSION, William. (20pts)

MADISON, William

Summary: Witness Report from JONES, Michael about events involving MADISON, William

Description: JONES, Michael spotted MADISON, William leaving the Holiday Inn & Suites with a woman with short hair and getting into a vehicle that he did not believe belonged to MADISON, William.

Grade 1: B

Grade 2: 3

Type: Witness

Reference: WS1023-45

 

Summary: Work schedule of MADISON, William

Description: According to the informant, MADISON, William was not scheduled to work on the night in question. Informant had seen MADISON, William there the night previous and noted that MADISON, William does not normally work two days in a row.

Grade 1: A

Grade 2: 1

Type: Informant

Reference: SR8765-09

 

2394513234 & MADISON, Amanda

Summary: Telephone report for 2384513234

Description: Upon review of telephone records provided by AT&T, phone number

2394513234 is registered to MADISON, Amanda

Type: Record

Reference: PR674-567

 

2012 Toyota Camry, MADISON, William & MADISON, Amanda

Summary: Proof of ownership for 2012 Toyota Camry

Description: According to the Department of Motor Vehicles, the 2012 Toyota Camry is registered to MADISON, Amanda and MADISON, William and has been registered to them since 2014. The car has an assessed value of $9,500.

Type: Record

Reference: DMV Report

 

5569870012 & MADISON, William

Summary: Telephone report for 5569870012

Description: Upon review of telephone records provided by Verizon, phone number

5569870012 is registered to MADISON, William.

Type: Record

Exercise 3 - Import the Excel sheet labeled “Exercise 3” and answer the questions below. 

Click here to download the Excel workbook if you did not download it already from the test page. It contains two worksheets labeled "Exercise 3" and "Exercise 4." You will use the worksheet labeled "Exercise 3" during this portion of the test. 

You will need to take screenshots of the various charts and upload them.

Exercise 4 - Import the Excel sheet labeled “Exercise 4” and answer the questions below. 

Click here to download the Excel workbook if you did not download it already from the test page. It contains two worksheets labeled "Exercise 3" and "Exercise 4." You will use the worksheet labeled "Exercise 4" during this portion of the test. 

You will need to take screenshots of the various charts and upload them.

By pressing "submit" below, you are submitting your work to be graded. A passing score is 75 points or better. Those who pass will be awarded a certificate. If you fail, you may take the test again but we will not tell you which questions you missed. You will be notified of either a passing or failing score, but it may be several weeks depending on the number of test submissions we receive.