Scribd Logo
Upload

Welcome to Scribd!

  • 16 views

    What Is The Project About?: Year 12 IPT Assessment Task 1 Due Date: Term 4 Week 9 6 December 2011 Weighting: 15%

    Uploaded by

    Marco Huang
    This document outlines an assessment task for a Year 12 Information Technology class. Students are asked to create a computerized database for a video store to track customer and video information like rentals and returns. They must include context diagrams, data flow diagrams, problem statements, and data dictionaries. The database should have forms for data entry, queries to search information, and customized reports like receipts. Students will be evaluated on correctly implementing these database components and demonstrating an understanding of testing and evaluating their solution.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PDF, TXT or read online from Scribd

    What Is The Project About?: Year 12 IPT Assessment Task 1 Due Date: Term 4 Week 9 6 December 2011 Weighting: 15%

    Uploaded by

    Marco Huang
    16 views3 pages
    This document outlines an assessment task for a Year 12 Information Technology class. Students are asked to create a computerized database for a video store to track customer and video information like rentals and returns. They must include context diagrams, data flow diagrams, problem statements, and data dictionaries. The database should have forms for data entry, queries to search information, and customized reports like receipts. Students will be evaluated on correctly implementing these database components and demonstrating an understanding of testing and evaluating their solution.

    Original Description:

    sdasdad

    Original Title

    12IPTtask1DatabasesAssesment2011ass

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document outlines an assessment task for a Year 12 Information Technology class. Students are asked to create a computerized database for a video store to track customer and video information like rentals and returns. They must include context diagrams, data flow diagrams, problem statements, and data dictionaries. The database should have forms for data entry, queries to search information, and customized reports like receipts. Students will be evaluated on correctly implementing these database components and demonstrating an understanding of testing and evaluating their solution.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    16 views3 pages

    What Is The Project About?: Year 12 IPT Assessment Task 1 Due Date: Term 4 Week 9 6 December 2011 Weighting: 15%

    Uploaded by

    Marco Huang
    This document outlines an assessment task for a Year 12 Information Technology class. Students are asked to create a computerized database for a video store to track customer and video information like rentals and returns. They must include context diagrams, data flow diagrams, problem statements, and data dictionaries. The database should have forms for data entry, queries to search information, and customized reports like receipts. Students will be evaluated on correctly implementing these database components and demonstrating an understanding of testing and evaluating their solution.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 3

    Year 12 IPT Assessment Task 1 Due Date: Term 4 Week 9 6th December 2011 Weighting: 15%

    Topics: Project Management (5%) and Information Systems and Databases (10%)
    ___________________________________________________________________________________ Outcomes to be assessed:
    H1.1 applies and explains an understanding of the nature and function of information technologies to a specific practical situation H2.1 analyses and describes a system in terms of the information processes involved H2.2 develops and explains solutions for an identified need which address all of the information processes H3.2 demonstrates and explains ethical practice in the use of information systems, technologies and processes H4.1 proposes and justifies ways in which information systems will meet emerging needs H5.1 justifies the selection and use of appropriate resources and tools to effectively develop and manage projects H6.2 selects, justifies and applies methodical approaches to planning, designing or implementing solutions H7.2 uses methods to thoroughly document the development of individual and team projects.

    What is the project about?


    Currently the video store you just bought uses a non-computer card system to hold details on videos and customers. You are to create a computerised database for a video store holding information on borrowers and videos. This database will help the users to locate and find videos that people have borrowed, returned and are due to return.

    Understanding the problem to be solved:


    For the planning of the database include the following: 1. Context diagram 2. Data flow diagram 3. Problem statement 4. Feasibility Study (minimum Half an A4 page) 5. Data Dictionaries for all the tables

    Producing the solution:


    1. You will need to create one database file but with many TABLES within it.
    Video Details Borrower Details Postcodes Genre Rating etc

    2. You will need to create a user friendly FORM which opens on start up. The form will have ways of entering the data easily, buttons to make tasks easier, buttons for queries and reports. 3. You will need to create a number of QUERIES that will make it easy for the users to find out what videos are borrowed, available etc. Who has borrowed the video, what is due back today? Etc.
    This is just a guideline on the tables you

    could have you could certainly have more!

    4. You will need to create a number of REPORTS that will look like printout of most of the queries. A report should also be made to look like a receipt for the customer on what they have borrowed and when it has to be returned.

    Testing and Evaluating the Solution:


    1. Which conversion method should be used to implement the new system? Explain how and why this would be done. (Parallel, Direct, Phased, Pilot) 2. What training methods would you implement? Give reasons. 3. How would you test the new system? 4. How would you evaluate and maintain the new system?

    9-10 The Context diagram, Data flow diagram, Problem statement, Feasibility study and Data dictionaries 20 marks HC A detailed description of the database that is easy to read and understand. All parts of the diagrams work, are concise and follow the rules on how to create them. C A detailed description of the database that is easy to read and understand. Most parts of the diagrams work, are concise and follow the rules on how to create them. D A description of the database that is easy to read and understand. Some parts of the diagrams work, are concise and follow the rules on how to create them. ED A simple description of the database with little or no understanding. The creation of the database with tables 10 marks HC Has multiple and detailed tables that ensures all data has data integrity, reduces data redundancy and checks data validation. C Has multiple and detailed tables that ensures most of the data has data integrity, reduces data redundancy and checks data validation. D Has multiple and detailed tables that ensures some of the data has data integrity, reduces data redundancy and checks data validation. ED Has simple tables and shows little or no understanding of how to ensure data integrity, reducing data redundancy and checking data validation. The creation of the database with forms 10 marks HC Has a detailed and working form that opens on start up. The form always allows ease of data entry by having buttons for all queries and reports, tab order and an effective screen design. C - Has a detailed and working form that opens on start up. The form mostly allows ease of data entry by having buttons for all queries and reports, tab order and an effective screen design. D The form sometimes allows ease of data entry by having buttons for all queries and reports, tab order and an effective screen design. ED - The form shows little or no understanding of effective screen design and understanding of form creation. The creation of the database with queries 5 marks HC Has detailed and working queries that make it easy for the users to find out what videos are borrowed, available etc. The queries allow users to find data quickly and easily. They are always beneficial for the everyday tasks needed to run the video business. C Has mostly detailed and working queries that make it easy for the users to find out what videos are borrowed, available etc. These queries should allow users to find data quickly and easily. They mostly beneficial for the everyday tasks needed to run the video business. D Has some detailed and working queries that make it easy for the users to find out what videos are borrowed, available etc. These queries should allow users to find data quickly and easily. They are sometimes beneficial for the everyday tasks needed to run the video business. ED Has little or no understanding of how to create queries to ensure that data is found quickly and easily. The creation of the database with reports 5 marks HC Has reports for all the queries. They look like documents that the video store would use. Customer receipts are created and show the necessary detail needed as well as added information to help the user understand the information printed for them. (Labels, headings etc) C Has reports for all the queries. They mostly look like documents that the video store would use. Customer receipts are created and show the necessary detail needed as well as added information to help the user understand the information printed for them. (Labels, headings etc) D Has reports for some of the queries. The reports mostly look like the Report Wizard Designs provided by MS Access with little or no added labels, heading or other formatting. ED Has little or no understanding of how to modify a report to show extra information. Testing and Evaluation 10 marks In relation to the questions: HC Has detailed and concise explanations demonstrating an excellent understanding of testing and evaluating a solution. C Has detailed and concise explanations demonstrating a good understanding of testing and evaluating a solution. D A simple explanation demonstrating some understanding of testing and evaluating a solution. ED An explanation demonstrating little or no understanding of testing and evaluating a solution.

    6-8

    3-5

    0-2

    You might also like