Homework #1: Open the cryptanalysis HW1 excel file the worksheet displays a cipher text with number of cipher characters used. Students should submit the original plaintext in the MS Word format or OpenOffice format. Students must break this cipher text by hand, not by a decode software other than the Excel worksheet provided. The main purpose of this homework is NOT to learn the cryptanalysis technique, but to learn the importance of encryption.So, if you cannot find the correct answer, do not waste too much time on it, and submit a report what you have done as an incomplete work.

*** HW1 ciphertext *** j r g d g i d x g q a n n g z g t g t t s i t g j r a n m n o e d d i o m n w j r a j v k s e x j m d x k m n w j r g m t t g d t g o g n j a j m z g o v g k i n l a q g t j a m n x m s m j j r g k o j t g n w j r g n j r g v a t t m g t a w a m n o j j r g w i z g t n s g n j i b a b g u ***** Hint for Homework #1 ******

Homework #1																															cipher	# used	Plain
																															a	10
j	r	g	d	g	i	d	x	g	q	a	n	n	g	z	g	t	g	t	t	s	i	t	g	j	r	a	n	m	n		b	2
o	e	d	d	i	o	m	n	w	j	r	a	j	v	k	s	e	x	j	m	d	x	k	m	n	w	j	r	g	m		c	0
t	t	g	d	t	g	o	g	n	j	a	j	m	z	g	o	v	g	k	i	n	l	a	q	g	t	j	a	m	n		d	6
x	m	s	m	j	j	r	g	k	o	j	t	g	n	w	j	r	g	n	j	r	g	v	a	t	t	m	g	t	a		e	2
w	a	m	n	o	j	j	r	g	w	i	z	g	t	n	s	g	n	j	i	b	a	b	g	u							f	0
																															g	23
																															h	0
ANSWER:																															i	6
																															j	17
0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0		k	4
0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0		l	1
0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0		m	11
0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0		n	14
0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0							o	6
																															p	0
																															q	2
																															r	8
							* Entire worksheet is protected, except the																								s	4
							plaintext part (Thick-border box) of the																								t	13
							translation chart. Low case letters are ones																								u	1
							used in cipher text, and numbers show their																								v	3
							frequency in the cipher text.																								w	5
																															x	4
							* Do not manipulate the ANSWER area - if you																								y	0
							enter a character in the plain text part, it will																								z	3
							change ANSWER area automatically.

To break a cipher text, you always begin with a simple method - character substitution (shift to right a certain number just like Caesar did, or to the left). If it does not work, you can try more organized substitution. Rearrange your substitution part in the encryption table - begin with 'a' for 'A' (plaintext) and skip to character (2, 3, 4, 5, 6, ...) to the right or to the left and put the next character... until you fill out all the substitution chart. Here, when you try the number of skip, remember that alphabet has 26 characters, which is 2 X 13. So, do not use even numbers as a skip number (because A will be repeated eventually), also do not use 13 (same reason). Always begin with 3, 5, 7, 9, 11, 13 (left or right direction). This method assumes that there is no key used, and the first cipher letter is always 'a'. Also remember this, the most frequently used letter in English is ETAOIN. However, if the number of characters is small, this statistic means very little. Of course, if you have 30-40 characters in the cipher, 0 frequency of big three (E T A) is also unusual. From the Wikipedia, the most frequently used first letter is T and A. The most frequently used double-letter is LL EE SS OO. This work will be very time consuming, so an Excel worksheet for this problem is provided. You can play with it, and hopefully find the answer quickly. This cipher text does not use any complex encryption method. So, all students can find the answer.