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 |
- 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 |
- 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 |
- 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 |
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 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 |
|
|
