News‎ > ‎

Muahahahahaha you're all welcome :)

posted Aug 14, 2012, 3:42 PM by Unknown user   [ updated Aug 14, 2012, 3:44 PM ]


Article 2: Google to Begin Downranking Search Results for Sites That Violate Its Copyright Policies


  1. Describe social and ethical issues Google is attempting to address by downranking websites that infringe their copyright policies.
Marking CriteriaMarks
Identifies and describes social and ethical issues Google is attempting to address by downranking websites.

3

Identifies at least two social and ethical issues Google is attempting to address by downranking websites,  but only describes one.

2

Identifies but does not describe social and ethical issues Google is attempting to address by downranking websites.

1



-Copyright: Google is attempting to protect the exclusive redistribution rights of copyright holders
-Data accuracy: Google is attempting to give more relevant search results for users

  1. Evaluate changes made to the Copyright Act to accommodate for advances in multimedia and communications technologies.
Marking CriteriaMarks
Evaluates at least two changes made to the Copyright Act to accommodate for advances in multimedia and communications technologies.

3

Evaluates a change made to the Copyright Act to accommodate for advances in multimedia and communications technologies.

2

Identifies changes made to the Copyright Act to accommodate for advances in multimedia and communications technologies.

1



-You may only have one backup copy of software
-Use of ideas may not be reverse-engineered unless they are open source
-The purpose of the use of the information matters (commercial use, personal use, educational use)

  1. Propose reasons for the increasing ubiquity in pirated media, with reference to advances in multimedia and communications technologies.
Marking CriteriaMarks
Proposes more than two reasons for the increasing ubiquity in pirated media, with references to advances in both multimedia and communications technologies.

4

Proposes TWO reasons for the increasing ubiquity in pirated media, with references to advances in both multimedia and communications technologies.

3

Proposes TWO reasons for the increasing ubiquity in pirated media, with reference to advances in EITHER multimedia or communications technologies.

2

Proposes ONE reason for the increasing ubiquity in pirated media, with reference to advances in EITHER multimedia or communications technologies.

1



-Compressed files mean smaller file size, allowing for ease of transfer over the internet
-Higher bandwidths allow for faster downloading of pirated media
-Higher quality pirated media

  1. a. Describe a method through which Google could implement an ranking system in an existing database of websites, with each website rated by the number of copyright infringement notices.
Marking CriteriaMarks
Describes a method where a relational database is used, with more than one extra table.

3

Describes a method where a relational database is used, with one extra table.

2

Describes a method in which ranking is inputted manually.

1



-Add a field for the number of copyright infringement notices in a main database
-Add a table for InfringementNotices
-Add a table for each website with an infringement notice, to keep track of infringements
-Table for each website with an infringement is linked to the copyright infringement notices field

b. Construct an example of an SQL statement to search a database for websites with the word “download” in the title, ordered by least number of copyright infringement notices to the most.

Marking CriteriaMarks
Constructs an SQL statement with four valid lines.

4

Constructs an SQL statement with three valid lines.

3

Constructs an SQL statement with two valid lines.

2

Constructs an SQL statement with one valid lines.

1



-SELECT WebsiteURL WebsiteOwner
-FROM Websites InfringementNotices
-WHERE Title CONTAINS “download”
-ORDER BY NoInfringements Ascending
Comments