The stages of project management by wxz21301

VIEWS: 0 PAGES: 10

									           ICT – Coursework Framework for the Database

Introduction
 What is the name and the                   Blockbusted DVD’d are a shop that rents out …….
 nature of the organisation?
                                            It is located in a side street from the main shopping mall
                                             and could do better in a better location.
 Required – a paragraph of                  The owner – Miss Smith is using a paper based system to
 at least 3 sentences.                       run………. Records of her DVD’s, her members, and what
                                             films are rented to whom.
                                            Miss Smith would like the business to run more efficiently
 LESSON 1
                                             and to do this she would like to try out keeping her records
                                             on a computer system.



Identify
 1. What problems need to Explain in as much detail as you can:
be solved?
                              The problem is that Miss Smith is using a paper based system..
                                Data is kept in books, files, loose paper folders……..
Required – a paragraph of
                                When a question is asked it takes time to search……..
at least 6 sentences.
                                Data is often written down more than once……
                                Space is a problem as filing cabinets are…….
LESSON 1
                                A summary and detailed lists are not possible because




 2. What solution is                      The paper based system consists of………
presently being used?
                                          Membership details are kept……
                                          DVD details are kept……..
Required – a paragraph of at              New DVD’s are written into……..
least 8 sentences.
                                          New members are written into………
                                          When a DVD is borrowed by a member details are written to…
LESSON 1
                                          These files are kept…..
                                          If a customer has a question the staff have to….
                                          If a DVD is not returned on time…….




 3. Who will be using your                 Miss Smith is the owner and she will oversee……
system?
                                           I will be the computer technician and will produce…..
Required – a paragraph of
                                           Mrs X and Mr Y are the staff and they will……….
at least 2 sentences.
LESSON 2


Short Course GCSE – Page 1                           ICT-Teacher.com               Blockbusted Database
           ICT – Coursework Framework for the Database

 4. What alternatives can           Miss Smith may enhance the paper system by using card
be used?                             index files but……
                                    Miss Smith may use a spreadsheet for recording data but…
Required – a paragraph of at
                                    Miss Smith may use a Word processor but……
least 6 sentences.
                                    I recommend that Miss Smith uses a Database as it can do
                                     the following……… facilities to sort data, select data, to
LESSON 2                             search for data and produce a variety of different outputs on
                                     screen and paper.




 5. What objectives will            The database will have 3 linked tables that……
your solution aim to
                                    I will add data to the database to test it works by entering….
achieve? Identify at least
three objectives that can be        I will create queries that will……….to test the searches work.
measured.
                                    I will create data entry forms to make it easier…..
                                    I will create printed reports for….
Required – a paragraph of
at least 5 sentences.


LESSON 2
Complete for homework.


IDENTIFY Marks:
Objectives:                                                                5. What
                  1. What      2. What       3. Who will    4. What        objectives
                  problems     solution is   be using       alternatives
                                                                           will your
                  need to be   presently     your           can be         solution aim
                  solved?      being used?   system?        used?
                                                                           to achieve?

Mark          1           1            1             1             1            Total : 5
Note: The marking breakdown is an approximation, your teacher will give you a more accurate
assessment.


Analysis
 1. What software and/or        Software:
hardware will be needed?
                                 An Operating system (e.g. Microsoft Windows XP) to run the…..
                                 A Word processor (e.g. Microsoft Word, Microsoft Notepad) to
Required – a paragraph of at      use to send……
least 5 sentences, or a          A Database (e.g. Microsoft Access) to store, sort and search…
bulleted list.
                                 A Spreadsheet (e.g. Microsoft Excel) to calculate financial……
                                 A Desktop publishing (e.g. Microsoft Publisher) for producing
                                  advertising flyers…..
LESSON 3
                                 Other software to get and what it will be used for.
                                Hardware:
                                 Personal computer give some details such as:
                                 Processor - Pentium 2.4 GHz



Short Course GCSE – Page 2                    ICT-Teacher.com                 Blockbusted Database
           ICT – Coursework Framework for the Database
                                Memory - RAM 256 Mb or 512Mb
                                Hard Drive- 40 Gg or 60Gb or 80Gb.
                                DVD or CD drive.
                                Network connection for future upgrade
                                Monitor (VDU) 17”, or 19”, or 21”.
                                Keyboard and Mouse
                                A Printer, ink jet colour or laser colour.
                                A Scanner
                                Digital camera
                                USB connections for outside devices.




 2. How will any data used                 Data will be transferred from the old paper based system
be collected?                               and entered…..
                                           Data will be collected from new customers becoming…..

Required – a paragraph of at               Data will be collected from deliveries of……….
least 6 sentences.                         Data may also be collected from questionnaires, surveys,
                                            interviews, price lists, invoices etc…. (choose 1 or 2).
LESSON 3




                                            Data needs to be collected to be entered into tables in the
   3. What data has been
 identified as necessary to                  database. The database will have three tables called…….
 the system?
                                            It will be necessary to enter the following data into these

 Required – a paragraph of                   tables…….
 at least 3 sentences, and                  Membership table……data field headings.
 the bulleted lists.
                                            Films table…………….data field headings.

 LESSON 3                                   Rented table……….….data field headings.




 4. How will data be                      Once the data tables have been created, Data entry forms can
entered? (Inputs).                         be created for…….
                                          Data can be then be entered into Data entry forms in the
                                           allocated fields…….

Required – a paragraph of at              Data types need to be selected for certain fields….
least 5 sentences.                        When the selected data is entered it will be available for
                                           queries to be created to search for selected information. Some
                                           of the searches will be……..
LESSON 4
                                          A report showing selected information for Miss Smith will
                                           show…..

Short Course GCSE – Page 3                           ICT-Teacher.com                Blockbusted Database
           ICT – Coursework Framework for the Database




  5. How will the database     Simple flow diagrams.
operate showing data flow
in the system? (Processing).   1    Data entered.           Validation check    List of members
                                                            return OK.          shown
                                                            Stored in a table   alphabetically on
                                                            and sorted by       the computer
Required – a paragraph of                                   name.               monitor.
containing a sentence for
each diagram.

                               2    Search                  Tables              Results shown on
                                    requested about         interrogated for    the computer
LESSON 4                            certain films.          matching data.      monitor.




                               3    Data entered in         Validation check    Error message
                                    error.                  returns an error.   displayed, correct
                                                                                data entered.




                                                                                Correct data shown
                                                                                on the computer
                                                                                monitor.



                                      Reference to be made to linked tables and data searches
                                       from them to produce the required results for Miss Smith,
                                       staff and customers.




 6. How will information            Screen displays used by the staff when answering customer
be displayed? (Outputs).             enquiries.
                                    Printouts of queries for customers to read.

Required – a paragraph of at        Printed reports for Miss Smith such as lists of films etc……
least 4 sentences.                  Mail merged letters with membership details for customers
                                     who……….
LESSON 5




 7. What system backup                The computer is kept in the office which is locked………
and security has been
                                      The database will save automatically……………
used?

Short Course GCSE – Page 4                          ICT-Teacher.com             Blockbusted Database
             ICT – Coursework Framework for the Database
                                             The data will be backed up on CD Rom every night, and
                                              taken……………..by…………….

Required – a paragraph of at                 This will safeguard the data in case of burglary…………..
least 6 sentences.                           Anti-virus will protect………….
                                             Staff will have passwords to prevent…………
LESSON 5

Complete for homework.



ANALYSIS Marks:
             1. What    2. How       3. What        4. How      5. How will     6. How will   7. The
             software   will any     data has       will data   the database    information   system
             and/or     data used    been           be          operate?        be            backup
             hardware   be           identified     entered?    Show data       displayed?    and
Objectives




             will be    collected?   as             (Inputs).   flow in the     (Outputs).    security
             needed?                 necessary                  system.                       has
                                     to the                                                   been
                                     system?                    (Processing).                 used.


Marks 1           1        2          1         2             1            1        Total : 9
Note: The marking breakdown is an approximation, your teacher will give you a more accurate
assessment.




Design (Handouts Necessary)
     1. How will the initial                 Draw sketches of the three tables on paper, include data
    sketched designs look on                  types, and any other information.
    paper?
                                             Draw sketches of the three data entry forms, include some
                                              notes.
    LESSON 6




Short Course GCSE – Page 5                             ICT-Teacher.com                  Blockbusted Database
           ICT – Coursework Framework for the Database
  2. Has the user given any             Write a note or letter from Miss Smith and include
feedback on the initial                  recommendations for improvements…………
design?
                                        The improvements will be the changes from your designs to
                                         the designs given for you to type in. These are:

Required – a paragraph of at            Designs of three tables needed, include all information.
least 6 sentences, or a                 Design of a data entry form……
bulleted list.
                                        Design of some queries……
LESSON 6 & 7



 3. Design the database on     Use word processing techniques to show the designs of:
 the computer for your                   Tables
 report.                                 Form
                                         Query
                                         Report
 LESSON 7




  4. List the Validation      Look through the designs and comment on:
 techniques used to prevent
                                  Data types for certain fields.
 data being entered in error.
                                  Validation rules….date range, length range, text length.
Required – a bulleted list.
                                  Input masks…….date formatting.
LESSON 8




 5. How will the design be              Create a testing program that will test the various elements
tested?                                  of your design when it is implemented.
                                        The testing program should include relevant tests that can
Required –bulleted list.                 be performed and which will show any errors that need to be
                                         corrected I will test the data validation rules;

LESSON 8                                I will add data to a database to ensure that the data entry
                                         procedures work;
                                        I will set database and manually check that they will produce
Complete for homework.                   predictable and/or known returns.



DESIGN Marks:
 Objectives:                                     3. Computer
                  1. The       2. User           produced       4. List the   5. How
                  initial      feedback                         Validation    will the
                                                 designs for
                  sketched     on the            tables and     techniques    design be
                  designs on   initial                                        tested?
                                                 forms.
                  paper        design.

 Mark         1           1            2.5           2              2.5         Total : 9
Note: The marking breakdown is an approximation, your teacher will give you a more accurate
assessment.



Short Course GCSE – Page 6                         ICT-Teacher.com              Blockbusted Database
           ICT – Coursework Framework for the Database




Implementation (Handouts Necessary)
 1. Has the final designs         The final designs have been approved by Miss Smith and she
been approved by Miss              has given me instructions to start the implementation of the
Smith ready for                    database.
implementation?
Required – a paragraph of
at least 1 sentence.
LESSON 9


                                  Create the Tables, Links, Data entry Forms, Queries, and
                                   Report in Microsoft Access. Correct some errors, and do
2. Create 3 table designs.
                                   some tests.
3. Link the tables.
                                  Record everything you did and copy / paste into your report.
4. Create 3 data entry
                               Here is a checklist:
forms.
5. Enter data in forms or         For each new stage show how you created it using step by
                                   step instructions.
tables.
6. Error correction.              The implementation should have the following
                                   diagrams/pictures and each annotated with a caption of
7. Unstructured testing.           what you have done.
8. Create 5 queries.              Membership table in design view.
9. Create a report.               Membership table in design view showing certain fields.
10. Full validation               Membership table showing the data.
techniques tested.
                                  Film table in design view.
11. Full structured testing
including, correct, extreme,      Film table in design view showing certain fields.
and error data.                   Film table showing the data.
                                  Rented table in design view.
LESSONS 9 - 16                    Rented table in design view showing certain fields.
                                  Rented table showing the data.
                                  Membership, Film and Rental data entry forms.
Show print screens of all
                                  Some data entry in error and corrections.
the work done with
annotations?                      Some validation testing, and results.


Short Course GCSE – Page 7                   ICT-Teacher.com               Blockbusted Database
           ICT – Coursework Framework for the Database
LESSONS 17 - 20                          Each query in design view and the results.
                                         Query 1, Sort data;
                                         Query 2, search from one table;
                                         Query 3, search using two criteria – OR;
                                         Query 4, search using two criteria – AND;
                                         Query 5, search using all three tables.
                                         A report based on data from all the tables.
Complete for homework.
                                         Fully structured validation testing, showing correct, extreme,
                                          and error data entered and results.




IMPLEMENTATION Marks:
Objectives:
                 1. Has the final   2. Create        3. Link the     4. Create      5. Enter      6. Some
                 designs been       three table      tables.         three          data in       error
                 approved by        designs.                         data           forms or      correction
                                                    Paste and
                 Miss Smith                                          entry          tables.       done.
                 ready for          Paste and       annotate in      forms.
                                    annotate in     the report.                     Paste and    Paste and
                 implementation?
                                    the report.                      Paste and      annotate     annotate in
                                                                     annotate       in the       the report.
                                                                     in the         report.
                                                                     report.
Mark             0.5                1.5             1                1           1               1
7.
                 8. Create five     9. Create a      10. Full list   11. Full structured list
Unstructured
testing done.    queries, some      report           of Validation   of Validation techniques
                 complex.                            techniques      tested, from design
                                                     tested from     plan.
Paste and        Paste and          Paste and
                                                     design plan
annotate in      annotate in the    annotate in                      Paste and annotate in
the report.      report.            the report.     Paste and        the report.
                                                    annotate in
                                                    the report.
1            1                0.5         1.5            2                       Total: 12
Note: The marking breakdown is an approximation, your teacher will give you a more accurate
assessment.




Evaluation
 1. Does the final design                Compare the completed design with the list of the original
match the original                        requirements.
requirements?
                                         How close does the completed design match the original
                                          requirements?
Required – a paragraph of at
                                         In what ways does it differ and why?
least 4 sentences.
                                         If you didn’t achieve everything detail what you couldn’t do.
LESSON 21




  2. What problems needed                I had the following problems when implementing:

Short Course GCSE – Page 8                         ICT-Teacher.com                  Blockbusted Database
           ICT – Coursework Framework for the Database
to be overcome?                     A problem or a difficulty creating the tables – and the
                                     solution.
And how did you overcome
them?                               A problem or a difficulty linking the tables - and the solution.
                                    A problem or a difficulty with data types or validation - and
                                     the solution.
Required – a paragraph of at
                                    A problem or a difficulty creating the data entry forms - and
least 4 sentences.
                                     the solution.
LESSON 21                           A problem or a difficulty creating the queries - and the
                                     solution.
                                    A problem or a difficulty with any errors - and the solution.




 3. Has Miss Smith given            Miss Smith gave the following feedback to you on the
any feedback on the final            effectiveness of the solution.
design?
                                    List the things she liked and used.

Required – a paragraph of at        List the things that she didn’t like and couldn’t use.
least 4 sentences.                  Be honest and mention some things you didn’t do as well as
                                     the things you did well.
LESSON 21




 4. What further          Explain what further developments and/or upgrades could be made
improvements and/or       to the final design in the future.
upgrades could be made to
                          Examples:
the final design?
                              I could have added extra fields/tables/data to the database.
                                  I could have added buttons to the data entry form for better
Required – a paragraph of at       navigation.
least 6 sentences.
                                  I could have tried a few more tests to ensure the system
                                   worked correctly in all processes.
LESSON 21                         I could have………………………………….to make the project
                                   much more effective for Miss Smith and her staff.
Complete for homework.




EVALUATION Marks:
Objectives:
                 1. Does the     2. What problems    3. Has Miss    4. What further
                 final design    needed to be        Smith given    improvements
                 match the       overcome?           any            and/or
                 original                            feedback on    upgrades could
                                 And how did you
                 requirements?                       the final      be made to the
                                 overcome them?
                                                     design?        final design?

Short Course GCSE – Page 9                     ICT-Teacher.com               Blockbusted Database
            ICT – Coursework Framework for the Database




Mark            1                      1.5               1                  1.5                Total : 5



Possible Marks:
Section      Identify           Analysis        Design        Implementation      Evaluation      Total
Marks        5                  9               9             12                  5               40


Grade Boundaries:
5=G        9=F                13 = E         17 = D      21 = C        26 = B        31 = A         35 = A*



Coursework Timetable:

Database 12 weeks approx 21 lessons.

Week         Lesson 1                                        Lesson 2
Week   1     Introduction and Identify 1, 2.                 Identify 3, 4, 5.
Week   2     Analyse 1, 2, 3.                                Analyse, 4, 5.
Week   3     Analyse 6, 7.                                   Design 1, 2.
Week   4     Design 2.                                       Design 3, 4.
Week   5     Implementation 1,                               Implementation 2. Create 3 table designs
             Implementation 2. Create 3 table                with data type, primary keys and validations.
             designs with data type, primary keys
             and validations.
Week 6       Implementation 3. Link the tables               Implementation 4. Create 3 data entry forms
Week 7       Implementation 5. Enter data in                 Implementation 5. Enter data in forms or
             forms or tables                                 tables
Week 8       Implementation 6 & 7. Enter with                Implementation 8. Create five queries,
             errors and testing.                             Implementation 9. Create a report
Week   9     Implementation Print screen                     Implementation Print screen
Week   10    Implementation Print screen                     Implementation Print screen
Week   11    Evaluation 1, 2, 3, 4, 5.                       Final chance to amend and improve work
Week   12




Short Course GCSE – Page 10                               ICT-Teacher.com                  Blockbusted
Database

								
To top