Assignment 3-2: Basic Excel

Instructions

Download and open Assignment 3-2 Worksheet from the Moodle shell, and format it as follows:

1) The first two columns, Department and First Name, are too narrow to display. Change the width of both columns so all data can be seen.

2) Modify the Font across the whole worksheet to Times New Roman, 8 point. You might have to repeat this step again so that the worksheet is uniform.

3) Modify the Row Height across the entire document to Height: 31.20 (52 pixels)

4) Insert a row above row 11 and type in the following data:

a) Department: IT

b) First Name: Ernest

c) Last Name: Hemingway

d) User Name: hemingwaye

e) Put X’s in columns headed “Part 1”, “Part 2”, “Part 3”

f) Leave column G blank

g) Total: 568945

h) Address: 6528 Longfellow Rd Euless, TX 77459

5) Move the Address column to the immediate left of the User Name column

6) Move the Status column to the end, after the Total column

7) Wrap the text of the Address column so each line of the address is seen.

8) Insert a row above row 1 and do the following:

a) Type Roadrunner Inc. Company Presentations, Font 18

b) Select cells A1 through J1

c) Click “Merge and Center”

d) Click on Cell A1, make the fill color light green

9) Change the data in the Total column to currency number format

10) Make all data (and headings) left justified, bottom aligned in each cell

11)

Save your assignment as [your initials]_assignment3-2.xlsx and upload it to the Moodle shell, Week 3.

CS 120 – Week 5: Internet and Networks

Instructions:

Answer the following three questions, using the Supplementary articles posted in Week3 Moodle shell.

1) What is your current IP Address? (Read the Article and use the ipconfig /all command). For Mac users, do a spotlight search on Network Utility and it should show your IP address.

Take a screen print with the SNIP tool and paste it here:

2) Using the tracert command, how many “hops” does it take to get to google.com? For Mac users, tracert is one of the options at the top of the Network Utility.

Take a screen print with the SNIP tool and paste it here:

3) Using the ping command, try to ping google.com. For Mac users, ping is one of the options at the top of the Network Utility.

Take a screen print and paste it here:

4) You have read articles and seen videos on the OSI model this week. What do the different layers of the OSI model represent? (AT LEAST 2 sentences per layer).

COMPUTER ETHICS SCENARIOS

Ten Commandments of Computer Ethics

1. Thou shalt not use a computer to harm other people.

2. Thou shalt not interfere with other people’s computer work.

3. Thou shalt not snoop around in other people’s files.

4. Thou shalt not use a computer to steal.

5. Thou shalt not use a computer to bear false witness.

6. Thou shalt not copy or use proprietary software for which you have not paid.

7. Thou shalt not use other people’s computer resources without authorization or proper compensation.

8. Thou shalt not appropriate other people’s intellectual output.

9. Thou shalt think about the social consequences of the program you write or the system you design.

10. Thou shalt use a computer in ways that show consideration of and respect for your fellow humans.

ethics –plural noun (from dictionary.com)

1.

2. the rules of conduct recognized in respect to a particular class of human actions or a particular group, culture, etc.: medical ethics; Christian ethics.

Copyright – –noun (from dictionary.com)

1. the exclusive right to make copies, license, and otherwise exploit a literary, musical, or artistic work, whether printed, audio, video, etc.: works granted such right by law on or after January 1, 1978, are protected for the lifetime of the author or creator and for a period of 50 years after his or her death.

TO DO:

1. Pick 5 of the 18 scenarios and answer the four questions below. Each question should be answered in 2-4 sentences.

a. Describe the underlying netiquette/ethics issue(s) in each scenario.

b. Which of the Ten Commandments of Computer Ethics does the scenario concern?

c. What is your opinion of the behaviors involved?

d. What equitable (fair) solutions can you suggest?

2. Then write a reflection: How do these scenarios relate to you? Describe a time you had to handle an ethical situation. What did you do? How would you handle it differently now?

SCENARIOS

A. Jules has walked away from a lab computer without logging off. Trish sits down and, still logged in as Jules, sends inflammatory e-mail messages out to a number of students and posts similar messages on the class newsgroup.

B. Sharon and Timothy are students at Big Suburban High School. They have designed a Web page devoted to their favorite rock band using their personal disk space on the school’s Web server. They have posted song clips, lyrics, photographs of each band member, and articles they have found in various Web news sources. However, school authorities have asked them to shut down their site because of the obscene content of many of the lyrics. Sharon and Timothy object, noting that their First Amendment (free speech) rights are being violated.

C. Sandy has been receiving 4 or 5 anonymous insults daily over e-mail. Because of the context of the notes, she has narrowed the suspect down to someone in her 4th period class. She sends the entire class a nasty warning not to do it again.

D. Paula and Ron went out for a few months. During that time, they sent each other some pretty personal e-mail. But their break up was messy. The final straw came when Ron found out that Paula was sending copies of their old messages to his new girlfriend. Pretty soon, copies of the messages seemed to be all over the school and his new girlfriend wouldn’t speak to him.

E. Marla figures out that when she is logged into the server she can look at others’ directories, make copies of files, and deposit new files. The operating system was designed to allow this functionality so that people could share their work. Mr. Klausinsky objects when he observes Marla poking around in another student’s directory. But Marla responds by saying, “If the system allows me to do it and there’s no specific rule against it, what’s the problem?”

F. Like many of her friends, Minnie has a blog. But unlike her friends, she keeps its location secret. She doesn’t link to anyone else’s blog and she doesn’t comment on other blogs using her blog identity. Somehow, though, Edward finds out the URL for Minnie’s blog and adds it to the “friends” list on his blog. Word spreads, and soon everyone has read Minnie’s blog. Unfortunately, she has used her blog to criticize most everyone she knows, including other students, teachers, and her parents. Everyone is furious with her.

G. A group of older boys has found out Greg’s email address and signed him up for pornographic web sites. When Greg goes to the library to check his Yahoo email, his inbox is full of “verification” emails for these websites. Clicking on the “remove” link within these emails takes Greg to the sites themselves to unsubscribe–which also brings up detailed graphic images. Ron, one of the reference librarians, sees these images on Greg’s screen, which are a violation of the library’s Internet policy, and suspends Greg’s Internet privileges for one month.

H. Chester, Agatha, and Ridley are hanging out at the park one day and meet up with Chester’s friend Troy. Troy takes a bunch of pictures with his cell phone and uploads them to Facebook, adding suggestive captions to the photos. Agatha starts getting friend requests from guys she doesn’t know. She also gets a phone call from one of the families she babysits for, cancelling her upcoming job with them.

Intellectual Property Issues

I. Tracy had a report to write on acid rain. She used several sources — books, magazines, newspaper articles, and an electronic encyclopedia. She listed all these sources in her bibliography at the end of the report. She found the encyclopedia to be the most convenient source because she could highlight portions of the text and paste them into her word processing document.

J. Jason R. designed and posted a Star Wars web site. Once the site started receiving 40,000 hits a day, he received a phone call from Lucasfilm asking him to shut it down. Jason posted excerpts of the phone conversation on his web site. Lucasfilm was then flooded with angry e-mail messages from fans who felt the company was exerting totalitarian control over products to which they felt a deep personal connection.

K. Richard asked Vicky if he could look at the essay she wrote for their history class. She told him “sure” and thought no more about it. Several days after the essays were turned in, the teacher asked her to stay after class. She showed Vicky that her essay and Richards were almost identical. She asked Vicky for an explanation.

L. Paramount pictures has cracked down on numerous Star Trek fans for printing synopses of the plots of just-released installments in the film series. In other media news, FOX TV sent a “cease and desist” letter to a woman whose Simpsons icons were starting to appear across various Web sites. She is quoted as saying that she felt she was giving Fox free publicity.

M. Roberta and Todd are the DJs for the next school dance. They surf the web for their favorite MP3s and download several songs, which they burn onto a CD to play at the dance. Some of the songs are from big name groups and others are from new artists who are using the web to build an audience.

N. Mr. Boxley asks the school librarian to check some references in Belinda’s research paper. Mr. Boxley believes that the writing is far better than Belinda’s usual work, almost spookily better. The librarian does a quick search and discovers that Belinda has copied whole paragraphs from the online articles she cites. However, in each sentence, at least two words have been changed. When confronted, Belinda argues that she has paraphrased and cited her sources. She does not believe she has plagiarized from other people’s work.

O. Larry is a fan of a superheroes cartoon which has an accompanying web site. He particularly likes one of the characters. He copies the character’s web page onto his own web page, but changes the name of the character to “Larry.” Several weeks later, the school system administrator is contacted by the company that produces the show and the web page. They threaten to sue the school if the site is not immediately removed.

P. Ken doesn’t have much money to buy new music. Instead, he checks out CDs from the public library and rips them, or copies music files from free sharing sites or friends’ computers. When he does have money, he either buys CDs the library doesn’t have or downloads songs from iTunes for $.99 apiece.

Q. Mun-Hwa has a paper due second period but doesn’t do any work until the night before. She heads to the public library where she asks the librarians for help. After they’ve shown her how to e-mail documents from online databases home, Mun-Hwa realizes that she can easily cut and paste paragraphs from the articles she retrieved into a document without citing them and that her teachers would never know.

R. The sophomore class officers decide to make a commemorative video of the year’s activities. The video will consist of a combination of still photos taken during the year as well as video interviews of class members. The background music for the photo shots will include several popular songs that really enhance the mood of the video. Students will be able to watch the video online or purchase it for $.50 (the cost of the DVD).
Scenarios provided by: http://www.uni.illinois.edu/library/computerlit/scenarios.php

Sheet 1

X

X

X X On hold

X X X

X X

X X

X X

X

X

X X

X

X

X

X

1028 Quiet Dale Rd Homosassa, MD 21610

X

3520 Sleepy Hearth Dr Calendar, WA 99340