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 - Describe social and ethical issues Google is attempting to address by downranking websites that infringe their copyright policies.
| Marking Criteria | Marks | | 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- Evaluate changes made to the Copyright Act to accommodate for advances in multimedia and communications technologies.
| Marking Criteria | Marks | | 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)- Propose reasons for the increasing ubiquity in pirated media, with reference to advances in multimedia and communications technologies.
| Marking Criteria | Marks | | 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- 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 Criteria | Marks | | 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 fieldb. 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 Criteria | Marks | | 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 |
|