Phase 3 PAT Research project Big purpose Investigate

Phase 3 PAT / Research project

Big purpose • Investigate problem • In Word report provide evidence of full investigation with clear Introduction and Conclusion • In summary Power. Point pull everything together using 1/10 of time used in report PAT - Research project - Phase 3

Task 1 Use information – Processing/analysing

Folder structure • Surname. Firstname – Phase 1 – Phase 2 – Phase 3 • Need clear file names • Extra folders in Phase 3 if required PAT - Research project - Phase 3

Use survey to get information to help solve problem

Use a database to help solve the problem • 20 records in database (from Survey) • Use validation, datatypes, etc. to HELP you input correctly • Queries – Calculation, And OR • Report – Group, Calculation, Picture

Meaningless query

Meaningful query

Copy meaningful query to Excel – make graph

Integrate Excel and Access

Use a spreadsheet to help solve the problem • Format for interpretation • Functions and formulas for solving problem • Integration, i. e. import from … , export to Word report, Access • Graph – labelled meaningful PAT - Research project - Phase 3

• Put completed spreadsheet and database in folder Phase 3 • Create the report • Create what the rubric requires PAT - Research project - Phase 3

Task 2 Use information - Final presentation/synthesis

Report • Introduction Must be linked – Describes problem – Indicates what is coming • Body – Under Headings – Discusses solution, describes your findings – Includes graphics/images, tables, graphs • Conclusion – Provides the solution or makes a proposal or presents your idea – Says which is the best solution and WHY – Makes sense If you have changed your questions since Phase 1, that is fine. The report must answer whatever questions you have. PAT - Research project - Phase 3

Rephrase questions if necessary to help solve the problem Questions to solve problem Fixed Q Access Fixed Q Oops. Need to rephrase Q Rephrased Q Excel Report Refine. Questions must be reflected in report

Report includes 1. Title page 2. Table of contents 3. List of references 4. Hyperlinks to documents / evidence PAT - Research project - Phase 3

Report formatting • • Table of contents Styles for headings Page numbering Automatic bullets and numbering, outline numbering • Paragraph line spacing and indenting • Graphs and tables with Captions • Cross referencing PAT - Research project - Phase 3