Marking+Guidelines

__**Marking Guidelines **__

HSC Information Processes and Technology __**Assessment Task 3: Marking Criteria **__

UNDERSTANDING THE PROBLEM (H2.1, H6.1, H7.2)
 * **__Marks __** || **__Criteria __** ||  ||
 * 8-10 || * Identifies and provides a clear and comprehensive problem definition
 * Provides an extensive preliminary investigation, detailing whether or not the solution to the problem can be solved quickly ||
 * 5-7 || * Identifies and provides a thorough problem definition
 * Provides an thorough preliminary investigation, detailing whether or not the solution to the problem can be solved quickly ||
 * 3-5 || * Provides a broad problem definition, without a clear comprehension of the problem
 * Provides a broad preliminary investigation, detailing whether or not the solution to the problem can be solved quickly ||
 * 1-3 || * Provides a limited problem definition, without a clear comprehension of the problem
 * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Provides a poor preliminary investigation, detailing whether or not the solution to the problem can be solved quickly ||

<span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">PLANNING (H2.1, H2.2, H6.1, H6.2, H7.2)
 * **__<span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Marks __** || __**<span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Criteria **__ ||
 * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">8-10 || * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Provides a clear and comprehensive feasibility study containing a requirement report, feasibility of the new system and recommendations for the new system
 * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Provides a comprehensive description of the design specifications for the new system ||
 * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">5-7 || * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Provides a detailed feasibility study containing a requirement report, feasibility of the new system and recommendations for the new system
 * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Provides a thorough description of the design specifications for the new system ||
 * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">3-5 || * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Provides a broad feasibility study containing a requirement report, feasibility of the new system and recommendations for the new system
 * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Provides a broad description of the design specifications for the new system ||
 * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">1-3 || * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Provides a limited study containing a requirement report, feasibility of the new system and recommendations for the new system
 * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Provides a limited description of the design specifications for the new system ||

<span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">DESIGNING (H2.2, H6.1, H6.2, H7.2)
 * __**<span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Marks **__ || **__<span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Criteria __** ||
 * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">8-10 || * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Provides a clear and comprehensive Data Flow Diagram (DFD) containing all required entities and correct data flows
 * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Provides a complete Entity Related Diagram (ERD) consisting of various tables and their relationships
 * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Provides a comprehensive description of five queries used in the database (three of which involve relationships) ||
 * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">5-7 || * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Provides a detailed Data Flow Diagram (DFD) containing most required entities and correct data flows
 * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Provides a thorough Entity Related Diagram (ERD) consisting of various tables and their relationships
 * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Provides a thorough description of four to five queries used in the database (two to three of which involve relationships) ||
 * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">3-5 || * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Provides a broad Data Flow Diagram (DFD) containing some required entities and few correct data flows
 * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Provides a satisfactory Entity Related Diagram (ERD) consisting of a limited number of tables and some relationships
 * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Provides a broad description of three to four queries used in the database (one to two of which involve relationships) ||
 * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">1-3 || * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Provides a limited Data Flow Diagram (DFD) containing little of the required entities and no correct data flows
 * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Provides a poor Entity Related Diagram (ERD) consisting of few tables with little or no relationships
 * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Provides a limited description of less than a total of two queries used in the database which may involve relationships ||

<span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">IMPLEMENTING (H6.2, H7.1)
 * __**<span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Marks **__ || **__<span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Criteria __** ||
 * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">4-5 || * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Provides a clear and comprehensive explanation of the method of conversion to be used in the new system
 * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Provides a critical analysis of the reasoning behind choosing the method of conversion ||
 * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">2-4 || * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Provides a thorough explanation of the method of conversion to be used in the new system
 * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Provides a detailed analysis of the reasoning behind choosing the method of conversion ||
 * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">1-2 || * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Provides a satisfactory explanation of the method of conversion to be used in the new system
 * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Provides a limited analysis of the reasoning behind choosing the method of conversion ||

<span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">TESTING, EVALUATING, MAINTAINING (H6.1, H7.2)
 * __**<span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Marks **__ || **__<span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Criteria __** ||
 * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">4-5 || * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Provides a clear and comprehensive description of the types of testing and evaluation to be used in the new system
 * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Provides a critical analysis of the reasoning behind choosing the methods of testing and evaluation
 * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Provides a comprehensive evaluation of whether or not the initial needs of the new system were met ||
 * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">2-4 || * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Provides a thorough description of the types of testing and evaluation to be used in the new system
 * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Provides a detailed analysis of the reasoning behind choosing the methods of testing and evaluation
 * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Provides a thorough evaluation of whether or not the initial needs of the new system were met ||
 * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">1-2 || * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Provides a satisfactory description of the types of testing and evaluation to be used in the new system
 * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Provides a limited analysis of the reasoning behind choosing the methods of testing and evaluation
 * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Provides a limited evaluation of whether or not the initial needs of the new system were met ||

__**<span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Total Marks for Documentation: **__

__<span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">General Comments __

__<span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;"> PRACTICAL COMPONENT (H1.1) __


 * **<span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Marks ** || **<span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Criteria ** ||
 * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">12-15 || * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Provides a clear and comprehensive database for the online music store
 * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Provides a complete number of tables with sample entries
 * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Demonstrates a number of relationships between various tables
 * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Provides a comprehensive description of five queries used in the database (three of which involve relationships)
 * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Can be viewed in Microsoft Access 2007 ||
 * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">9-12 || * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Provides a detailed database for the online music store
 * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Provides a thorough number of tables with sample entries
 * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Demonstrates a number of relationships between most tables
 * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Provides a thorough description of four to five queries used in the database (two to three of which involve relationships)
 * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Can be viewed in Microsoft Access 2007 ||
 * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">5-9 || * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Provides a broad database for the online music store
 * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Provides a satisfactory number of tables with a limited number of sample entries
 * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Demonstrates a limited number or relationships between some tables
 * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Provides a broad description of three to four queries used in the database (one to two of which involve relationships)
 * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Can be viewed in Microsoft Access 2007 ||
 * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">1-4 || * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Provides a limited database for the online music store
 * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Provides a poor number of tables with little or no sample entries
 * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Demonstrates little or no relationships between tables
 * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Provides a limited description of less than a total of two queries used in the database which may involve relationships
 * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Cannot be viewed in Microsoft Access 2007 ||


 * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Total Marks for Practical Component: **

__<span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">General Comments: __


 * <span style="font-family: 'Times New Roman',Times,serif; font-size: 140%;">Total Marks for Assessment Task 4: /60 **
 * <span style="font-family: 'Times New Roman',Times,serif; font-size: 140%;"> /25% **

__**<span style="font-family: 'Times New Roman',Times,serif; font-size: 16pt; line-height: 115%;">Assessment Task 3: Allocated Marks **__

<span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">7
 * __**<span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Marks **__ || **__<span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Task Requirement __** ||
 * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">3

<span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">7

<span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">3

<span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">2 <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">3 <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">5

<span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">5

<span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">5 <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">5

<span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">15 || <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Documentation <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">· UNDERSTANDING THE PROBLEM (H2.1, H6.1, H7.2) <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">o Preliminary Investigation (150 words) <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">o Problem Definition (200 words)

<span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">· PLANNING (H2.1, H2.2, H6.1, H6.2, H7.2) <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">o A feasibility study: <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;"> § Requirement Report (200 words) <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;"> § Feasibility of the new system (technical feasibility, schedule feasibility only) (250 words) <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;"> § Recommendations for the new system (200 words) <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">o Design Specifications for the database (Can be in bullet points 100 words)

<span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">· DESIGNING (H2.2, H6.1, H6.2, H7.2) <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">o A Data Flow Diagram for Searching for videos and DVDs in the store (1 page) <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">o An Entity Related Diagram (ERD) (This can be printed straight from Microsoft Access) <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">o A description of at LEAST five queries used in your database. (Three of these queries must involve relationships between tables in the database)

<span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">· IMPLEMENTING (H6.2, H7.1) <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">o Explanation of the method of conversion to be used when implementing the new system into the online music store (200 words)

<span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">· TESTING, EVALUATING, MAINTAINING (H6.1, H7.2) <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">o Brief description of the testing and evaluation of the new system (300 words) <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">o Evaluation of whether or not initial needs were met through the development of the new system (150 words)

<span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Practical Component (H1.1) <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">· Construct a database which could be implemented in the online music store. This relational database should be developed using Microsoft Access 2007, and should contain a minimum of five queries and a number of related tables. ||
 * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">60 || **__<span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Total Marks __** ||