Class 10 Notes

Class 10 Notes are in progress and are subject to change

Discourse
Minimize Discourse

Copy 10balance folder from Class folder to your Groups (shared) folder.

Class 10 Outline

Continue discussion on legal, social and ethical uses of Internet:

Hands-on - Create a container (HTML) and run a Javascript prompt

Understand and identify Excel operations for Calculations, Charting and Databases

In Class Exercises

Functions and formulas
Running Balance for relative cell references
Commission for absolute cell references
Travel Expenses
GPA for review
Horse racing for graph
Database for sorting and filtering

Know when to use absolute and relative cell references and be able to create them in the Excel formula window

Running balance - tutorial
Adjustable percentage

Be able to produce a simple graph from Excel spreadsheet data

Homework - Two Parts

Q & A - Questions about Excel so far - homework review

How to calculate monthly payments in Excel

Spreadsheets (in class):

Freeze
Running Balance
Commission
3GPA
Horse Racing

Homework - TWO PARTS!:

Part One:

Internet Ethics Part 2: Legal, Social and Ethical Op-Ed Blog Entry

IIn last week's class, we discussed the complexities of copyright and ownership of intellectual property in the Internet culture. Internet law is in its infancy with new, virtually daily, challenges. It is important to examine your thoughts on these challenges and to be able to share them articulately and in an informed manner.

Assignment: Choose one of the hypothetical situations, below. Write a one-page (approx 700 word) Op-Ed blog column addressing all aspects of the issues. Think critically and objectively. There is no “right” answer, only your informed opinion. Address the questions for your chosen situation and do some research as well. Use at least one quote from the Internet to support your thoughts, and cite it.. You may cite legal cases but do not present your opinion as any kind of legal advice. Upload to your blog. Give it a short, relevant title, and add a graphic of your choice if you wish to get your reader's attention.

Situation A.

A first-year medical student in California whose personal blog is hosted by a large weblog content provider posts explicit directions on facilitating an assisted suicide in the interest of “serving the rights of competent, terminally ill adults.” Is this legal? Is it ethical? A teenager in another state who is being treated for depression reads the post and succumbs to a fatal, self-administered overdose of drugs, crediting the blogger for “helping her do it right” in her last note to her family. Who is responsible for the tragedy? The teenager herself? The medical student? The weblog content provider for allowing the blog content to be posted? The parents for not monitoring their emotionally fragile child’s Internet access closely enough? What, if any, crime has been committed and who can and should be prosecuted?

Situation B.

A recent college graduate applies for a job in a prestigious law firm. The confidential interview goes well and he feels optimistic about his prospects. He is stunned when he is turned down. He learns through a friend in the law firm that a routine Internet background search has turned up pictures posted by a friend on Facebook showing him participating in the use of an illegal substance during a fraternity party in his junior year. He was not aware that the pictures existed. Does he have any legal recourse? Was it ethical of the friend to take and publish the photos without his knowledge or permission? Was it ethical of his law firm acquaintance to share the reason for his disqualification? What should he do (or should have done)?

Part Two:

A file has been created for you in 9balance and titled metric_conversions. (6 pts. for correct information, formatting, and formulas - use the measurement equivalents given in the instructions to make your conversion chart.) The point? Using different figures to get different results with the same formula.

A file has been created for you in 9balance and titled personal_finances. (6 pts. for correct information, formatting, and formulas - follow information in example in text and use running balance activity from class to remember how to do the formula) The point? Knowing how to write a formula that automatically adds and/or subtracts any amount from a current balance.
Data to be entered :

A file has been created for you called ExcelPayment. Follow the directions and create a formula for monthly payments for the items listed. (6pts)