Computer Science Fractional Data assignment worksheet

Data/PresetImageFill3-19.jpg

Data/PresetImageFill2-18.jpg

Data/PresetImageFill1-17.jpg

Data/PresetImageFill5-21.jpg

Data/PresetImageFill4-20.jpg

Data/PresetImageFill0-16.jpg

Data/bullet_gbutton_gray-22.png

preview.jpg

CIS 101 – Introduction to Computer Science

Assignment 2

Due Sep 24th at 23:30 – upload to worksheet to Canvas,

20 points

The objectives of this exercise are to:

1) Gain skill converting decimal to

fractional binary forms.

2) Gain skill fractional binary forms to

decimal.

For this assignment you will use a Fractional

Data Assignment Worksheet as shown to the

right:

The Fractional Data Worksheet is a spreadsheet

contains formulas to:

1. Generate a set of problem numbers both

decimal and binary fractional forms.

2. Prompt for input of converted values

3. Check to the input converted values are

correct

4. Compute a score giving 2 points for each correct converted value

The formulas are locked and hidden.

Instructions:

1. Download the Fractional Data Assignment Worksheet from Canvas and open it in Excel.

2. Enter your name and the last two digits of your VMI id (this will be checked incorrect entry will

result in a 4-point penalty). Excel will generate two decimal and four binary fractional numbers.

3. Convert the decimal and binary fractional numbers as prompted and enter the converted

values into the worksheet. Excel will check if the entered value is correct. If so, TRUE will

be displayed to the right, otherwise FALSE will be displayed. Excel will update your score

giving 2 points for each correct entry.

4. Once you have scored 20 points (or at least the best score you are willing to submit), save the

spreadsheet using “xxxx Fractional Data Worksheet” where xxxx is your name, and the name

of the spreadsheet.

5. Upload your worksheet to Canvas and submit the assignment by the due date.