IRM Pro/Clear Water Risk Management - Cybersecurity Project

WeightedRankingofInformationAssets-0719.xlsx

Home >Information Systems homework help >IRM Pro/Clear Water Risk Management - Cybersecurity Project

Asset Valuation Weighted Table

Table 2: Weighted Ranking of Information Assets
#	Criterion è	Insert your own criterion here	Insert your own criterion here	Insert your own criterion here	Insert your own criterion here	Insert your own criterion here	TOTAL	Importance (0-5; Not Important to Critically Important)	Delete all content in italics before submitting
	Criterion Weight è	Insert your own criterion weight here	Insert your own criterion weight here	Insert your own criterion weight here	Insert your own criterion weight here	Insert your own criterion weight here			Note: Don't just use my criteria and weights. Use your own and use realistic values
	Information Asset ê								Replace all information not in bold with your own values
1	Employee Database	0.8	0.5	0.8	0.8	0.8	0
2	HR Information System (HRIS)	0.2	0.2	0.2	0.4	0.4	0
3
4									Scales for Criterion weights are 0-100 (usually in increments of 5-10)
5									Scales for Criterion values (cells) are 0-1.0 (usually in increments of .05-.1)
6									0 is lowest, 1.0 or 100 is the highest
7
8									Your last step is to sort all assets by the TOTAL column. Be sure you only sort columns B5 through I29 (or whatever number of assets you end up with). You wan to leave the number column in order such that your number 1 asset is listed by the number 1.
9
10
11									Use the following scale to convert the weighted table analysis “Total” values to Clearwater “Importance” scores:
12									85+: 5 - Critically important
13									70+: 4 - Very important
14									55+: 3 - Important
15									40+: 2 - Somewhat important
16									25+: 1 - A little important
17									0+: 0 - Not important
18
19									You may cut and paste this table into your Project Template Word document.
20
21									The TOTAL column's calculations are based on 5 criteria. If you use more or less, you will need to add/remove rows and adjust the calculations.
22
23
24
25