Computer Science Assignment | Online Assignment

Lab 9 – Assessment Worksheet
Attacking a Virtual Private Network
Course Name and Number:
________________________________________________________________
Student Name:
________________________________________________________________
Instructor Name:
________________________________________________________________
Lab Due Date:
________________________________________________________________
Lab Assessment Questions
1. What is the darknet?
a. An Internet for non-English speaking people
b. The criminal side of the Internet
c. An Internet just for law enforcement
d. The old, IPv4 Internet that is being retired as IPv6 takes over
e. None of the above
2. What email protocol does Marina and Rita’s Cupcakes use and why is it
important?
3. Text in an email must match the URL to which it links. True or false?
4. Instead of relying just on a user ID and password systems, VPN access can
be protected by tokens like SecurID and other ____________ methods.
5. In many instances an IP address is used to access a server rather than a
URL because a URL is more difficult to set up and easier to track. True or
False.
6. A well designed malicious email campaign can expect ____________
number of responses, or click-throughs, as a legitimate commercial email
campaign.
a. fewer
b. more
c. about the same
7. Were Charlie Roberts and Susan Dougherty known to each other, and did
they have a trust relationship that could be exploited?
8. Which of the following steps can make VPN access more secure?
a. Assure Perfect Forward Secrecy during IKE key exchange
b. Allow access only from specific MAC addresses
c. Allow access only from specific MAC/IP address pairs
d. Use foreign words as passwords
e. Change password letters to numbers, such as all Ls to 7s and all Os to
0s.

Project: Mean-Variance Optimization
Due Date: May 1 Both as a Word Document Report and Supporting Excel File
(submitted on Blackboard)
Purpose:
1. Provide students a real-world application of asset allocation, following a process as
done by many financial planners.
2. Provide an opportunity to apply course material to explain an asset allocation
recommendation in understandable (to a well-educated non-finance person) but
using appropriate technical terms.
Specific Tasks:
1. Open Excel file “Portfolio VaR Updated” and save with new name.
2. Prepare the Excel spreadsheet as instructed in the videos, making sure to use your
own set of constraints, different from those provided in the example file.
3. Prepare an asset allocation recommendation paper for a fictitious client, including
the following sections (including graphics as appropriate):
a. Definition of your client (risk profile and risk tolerance, current portfolio,
goals (for example, saving for retirement).
b. Assumptions (asset class assumptions (you can reference Professor’s
assumptions), theory of finance using (efficient frontier, mean, standard
deviation), others) and constraints (be sure to include your rationale for
your constraints)
c. Summary of your analysis
i. Mean-variance analysis (put the efficient frontier graph in your
paper), including how you came up with your recommended portfolio
and other portfolios you considered
ii. Historical VaR Anlaysis
d. Final recommendation along with rationale
e. Style analysis of a mutual fund and recommendation as to if that fund is a
good fit to execute your asset allocation recommendation.
i. Assume your client comes to you with a balanced portfolio mutual
fund (contains both stocks and bonds (usually will have “balanced” or
“asset allocation” in title)). You will run the style analysis to
determine if that mutual bfund would be a good fit for your
recommendation. You do not need to find a mutual fund that has a
high R-squared to your recommended allocation.
4. Manager attribution of a single asset class mutual fund (for example: U.S. Large
Cap Growth). Assess the manager’s alpha, tracking error, information ratio, batting
average, upside/downside capture, Sharpe ratio, Upside/Downside Capture,
Jensen ratio, and Treynor index. The following videos provide more guidance:
a. https://www.youtube.com/watch?v=rD82uGAazyY
b. https://www.youtube.com/watch?v=Ii4Edw4zT8E
Student Input: These videos will also help you with the excel sheet. They are step
by step instructions in videos.
Videos for next week:
March 31 (Class 17): these are all on the Risk Project, so I do not need your notes on
these videos for attendance.



April 2 (Class 18):


Instead of a video, please read through and quickly summarize this short article. I
mentioned in class that it is important that you have some exposure to FASB 157, and
this fits well with the discussion of price discovery in the two videos above: https://
financetrainingcourse.com/education/2010/07/fas-157-fair-value-accounting-andlevel-
3-assets/