Grade ? PAT

1. Version’s date 30 May 2010 Comments in yellow are common mistakes Grade ?PAT Word Report and PPT Promotion

2. Folders and files • Folder saved as SurnameFirstname • Clear folder names • Clear file names • No duplication • Phase 1 • Phase 2 • Phase 3 File names! PAT 2010

3. Note! • No fabrication of data PAT 2010

4. Gr 12 PAT 2010 • Introduction • What is coming • Description of the topic, e.g. effects of salty food, lack of sleep, eating fast foods, lack of exercise, etc. • Habits of learners in your class, e.g. eating salty food, sleep, eating fast foods, taking exercise, etc. • Problems found with the learners in your class • Solutions to the problem in general • Conclusion • Description of what found in your class • Solution for the learners in your class based on your findings • Bibliography or List of references PAT 2010

5. Phase 1

6. Start • Write on what you must DO. • Begin with ‘I am going to investigate ….. ‘ • ‘Use Microsoft Office as a tool to produce the final report on my findings as well as create a PPT to help explain …’. • Use some of the words from the main topic, e.g. ‘Healthy Life Style campaign’. • Use words such as ‘to help complete’ and ‘ to help direct’. • Used own words • Write down the main question – short and clear e.g. What is the effect of lack of sleep on Gr12 learners at PHS? Be careful of number of marks given. No relationship between the Problem and the Main Question! PAT 2010

7. Sub topics • Decide on sub topics or headings needed to investigate • What do I need to know to solve the problem? Plan in table 15-20 questions No relationship between the Main Question and the sub topics and small questions! When counting questions ignore those irrelevant to the topic. PAT 2010

8. Make table – landscape – Move (not copy) details Plan in table PAT 2010

9. 1.6, 7 Questions • Sort Q under headings • Label Qs according to Levels • All Qs relevant to the topic • Answers • Say why the answer to each Q will help • Say where or how you will find information to answer each Q – type of source, e.g. Internet, person, magazine Plan in table PAT 2010

10. 1.8, 9 Type of questions Look for ONE of each kind Plan in table PAT 2010

11. 1.10 AnswersWhy? / For each question What are you going to DO with the found information? Examples • Use in spreadsheet to extract information of those at risk • Use in database criteria to extract those whose diet, exercise, etc. is poor • Match list of all those at risk with correct diet, exercise, etc. after a filter/query Plan in table PAT 2010

12. 1.11, 12 AnswersWhere? / For each question Find answers in Books (Print), e.g. textbooks, library books Magazines (Print) E-mail questions (People) Interviews (People) Surveys (People) Encarta (Internet) News24.com (Internet) Plan in table Note the numbering of separate sources. Have too few types of sources PAT 2010

13. Format table • Sort the work under Sub topics or Headings • Check Q numbering • Make columns ‘just’ wide enough • Make rows not too deep • Column headings – Bold and shaded, repeated • Keep all text the same font size, except for headings Headings not sorted Plan in table PAT 2010

14. Collect information • Save electronic information, e.g. web pages, emails • In Information folder • Save magazine articles / brochure / survey, etc. • in Paper envelope • Keep a Word document with list of URLs collected and date when found • Start thinking APA or Harvard Collect information PAT 2010

15. 1.13 Collect survey information • Test survey on 3 people – change as needed • Hand out to 20-30 people / collect data from 20 people • Every question must have a purpose • Every question must be analysable • Can use different methods to collect information, e.g. Word forms Collect information PAT 2010

16. Survey • About ±5 Qs • Create Qs first, and only then format the page • Use template survey OR create new document • Format neatly and logically. • Use tabs, columns and or tables • On a FULL page or two FULL pages • Heading • Picture • Please complete … (at beginning) • Thank you … (at end) • Say to whom it must be returned Collect information Looks good – well done PAT 2010

17. Word 2003 paper surveyAdapt a survey template Collect information PAT 2010

18. Word 2007 paper surveyAdapt a survey template Collect information PAT 2010

19. Example of a paper survey Collect information PAT 2010

20. Word forms survey 1/2 • Create Word form • Tell people how and where to save Collect information PAT 2010

21. Word forms survey 2/2 • Make form Read only by right-clicking • Put where people can view Collect information PAT 2010

22. Survey • All information must go onto one Excel work sheet or Access table • Keep details for each person • Arrange it so the amounts can be added up Collect information PAT 2010

23. Collect information from paper survey Collect information Silly layout! Only need one column per question PAT 2010

24. Collect information from paper survey Silly layout! Only need one row per person Collect information PAT 2010

25. Collect information from paper survey Collect information Meaningless headings PAT 2010

26. Collect information from paper survey Best! Collect information Nice headings Well laid out PAT 2010

27. Collect information from Word form 1/5 • Open completed Word form • Office button, Word Options, Advanced, Preserve fidelity when sharing this document, Save form data as delimited text file Collect information PAT 2010

28. Collect information from Word form 2/5 • Save carefully – at our school save on Desktop and in folder (why – does not seem to save in folder) • As txt Collect information PAT 2010

29. Collect information from Word form 3/5 • That is the data saved • That data must be imported into Excel Collect information PAT 2010

30. Collect information from Word form 4/5 • In Excel, Data, From Text • Delimited, Comma Collect information PAT 2010

31. Collect information from Word form 5/5 • Hooray. Now add the data from all the forms. • Leave ONE line between each until you have all (why – experience – do not know) Collect information PAT 2010

32. Get totalsAnalyse the information Use Countif function to total results Analyse information PAT 2010

33. Select data for graph Analyse information PAT 2010

34. Graphs • Create one graph per question in spreadsheet • Add a suitable picture as a background • Label horizontal and vertical axises • Copy each graph to Word document (centre it) • Under each graph • insert a caption (short heading for the graph, centre it) • write/type about what is shown in each graph (non caption, in body text, align left). Use the words highest, more, most, lowest, less or least. Analyse information PAT 2010

35. 1.15 Cross referencing / Linking • Copy original Word document with questions • Use ALL good questions • Add hyperlinks to your data saved in Folder for questions Links do not all work – linked to things IN folder. Can also use colour coding PAT 2010

36. 1.17 Trustworthiness – 1/2 • Look at every source of information, e.g. web page, magazine article, person, etc. • Write 1 sentence about each source (so if you looked at 2 web pages and did a survey, evaluate those 2) on: • Currency • Authority • Coverage • Accuracy • Reliability Then write – ‘This source is trustworthy or not trustworthy because …’ for every single source. Believe? Trust? Look at next slide PAT 2010

37. 1.17 Trustworthiness – 2/2 Evaluate every source with this table Then make a decision on its trustworthiness! PAT 2010

38. 1.18 File structure Check logical file structure, same topics grouped together Clear folder names Clear file names No duplication PAT 2010

39. Phase 1 Hand in • Information collected • Paper envelope / plastic sleeve with 20 completed/ticked surveys • Photocopies of magazine articles • Any other evidence in printed format • Printed task description with main question and planning table, etc. • Printed survey • Printed document with graphs and writing about each graph • Printed document on cross referencing • Printed document on trustworthiness • Completed rubric Information in Phase 1 folder • Information collected • Web pages • Saved e-mail letters, videos, etc. • Task description with main question and planning table, etc. • Spreadsheet /database with survey data • Document with graphs and writing about each graph • Document on cross referencing • Document on trustworthiness Hand in in the order given Clear file names PAT 2010

40. Marking of Phase 1 • Mistakes are indicated. • Mark stays the same • In Phase 2 work is done based on the corrections of Phase 1 • Good marking of Phase 1 essential • Common mistake • Must focus topics and questions on the Problem statement • Cross reference all questions PAT 2010

41. Phase 2 PAT 2010

42. Gr 12 PAT 2010 • Introduction • Discuss what is coming • Description of the topic, e.g. effects of salty food, lack of sleep, eating fast foods, lack of exercise, etc. and main question • Rationale for this research • Habits of learners in my class • I will look at the habits of learners in my class. I got information via a survey and analysed it in graphs. I will focus on …e.g. eating salty food, sleep, eating fast foods, taking exercise, etc. • 5 topics • Problems found with the learners in my class • I will look at the information in my graphs and compare it with the information found on the topic. • 5 topics • Solutions to the problem in general • Conclusion • Description of what found in your class • Solution for the learners in your class based on your findings • List of references PAT 2010

43. Phase 2 Part 1 – Report planning

44. I am pulling my hair out! This all part of ONE project, it is not separate, it is all on the same topic, not a new topic! The results of the survey are shown in a graph. The survey asked questions to help solve the problem. The graphs will be shown in the final report, in Phase 3, and NOT in the Phase 2 planning document. Phase 2 Part 1 is a planning document. Every sentence must begin with I WILL DISCUSS … PAT 2010

45. Report planning • Decide how you are going to write your report. What is it meant to be about? Think! Look at your Phase 1 questions! • Put down your headings / sections and subheadings / sub sections • Plan! Do not do the report Report planning PAT 2010

46. Headings • Under each heading and in each paragraph • write what you are going to say • write or show what graph you are going to use, if any • write or show what picture you are going to use, if any • Use styles for the headings Report planning PAT 2010

47. Applications In the planning document say which formula, query, etc. you used • In Phase 1 you indicated what you were going to DO with the information • Now indicate how you are going to use each package to collect/analyse/present the problem/solution, e.g. • Excel • extract details from survey and display in graphs • Access • use information from spreadsheet and use grouping to extract details and numbers, use calculations in queries and reports • extract lists of people, and link with information from web pages • Word • display information in table • PowerPoint • present finding Report planning Think of all the features you have learned in Excel, Access, Word and PowerPoint PAT 2010

48. Phase 2 Part 2 – Analyse

49. Now use applications • Use applications to collect/analyse/present the problem/solution • Spreadsheet - Formatting, functions, graph, integration • Database – Table, queries, reports, calculations in query or report, integration • PPT – all the bells and whistles PAT 2010

50. Phase 3 Final presentation