Transcript Grade 10

Version’s date 30 May 2010
Comments in yellow
are common
mistakes
Grade ?
PAT
Word Report
and
PPT Promotion
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
2
Note!
• No fabrication of data
PAT 2010
3
Gr 12 PAT 2010
1. Introduction
a.
b.
What is coming
Description of the topic, e.g. effects of salty food, lack of sleep,
eating fast foods, lack of exercise, etc.
2. Habits of learners in your class, e.g. eating salty food,
sleep, eating fast foods, taking exercise, etc.
3. Problems found with the learners in your class
4. Solutions to the problem in general
5. Conclusion
a.
b.
Description of what found in your class
Solution for the learners in your class based on your findings
6. Bibliography or List of references
PAT 2010
4
Phase 1
Start
1. 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’.
Be careful of number of
Use words such as ‘to help complete’ and
‘marks
to given.
help
No relationship between the
direct’.
Problem and the Main
Question!
Used own words
1. Write down the main question – short and clear
e.g. What is the effect of lack of sleep on Gr12
learners at PHS?
PAT 2010
6
Sub topics
No relationship between the Main
Question and the sub topics and small
questions!
When counting questions ignore those
irrelevant to the topic.
PAT 2010
15-20
questions
Plan in table
• Decide on sub topics or headings needed
to investigate
• What do I need to know to solve the
problem?
7
Make table – landscape – Move
(not copy) details
Q
No
Heading
Level
No
Questi
on
Why
ask
Source
1
Plan in table
2
3
4
5
6
7
PAT 2010
8
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
PAT 2010
Plan in table
•
•
•
•
9
1.8, 9 Type of questions
Level
Type
Look for ONE of each kind
2
Explore, query – why, how
3
Adjust, alter, predict - what if
4
Judgement – would it be better if, what
would be the best way
PAT 2010
Plan in table
1
What, when, where, who – usually 1 word
answers
10
1.10 Answers
Why? / For each question
Plan in table
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
PAT 2010
11
1.11, 12 Answers
Where? / For each question
Find answers in
PAT 2010
Plan in table
1. Books (Print), e.g. textbooks, library books
2. Magazines (Print)
3. E-mail questions (People)
4. Interviews (People)
Note the numbering
of separate sources.
5. Surveys (People)
Have too few types
6. Encarta (Internet)
of sources
7. News24.com (Internet)
12
Format table
Plan in table
1. Sort the work under Sub topics or
Headings
Headings
not sorted
2. Check Q numbering
3. Make columns ‘just’ wide enough
4. Make rows not too deep
5. Column headings – Bold and shaded,
repeated
6. Keep all text the same font size, except
for headings
PAT 2010
13
Collect information
• Save electronic information, e.g. web
pages, emails
• Save magazine articles / brochure /
survey, etc.
– in Paper envelope
• Keep a Word document with list of URLs
collected and date when found
• Start thinking APAPATor2010Harvard
Collect information
– In Information folder
14
1.13 Collect survey information
PAT 2010
Collect 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
15
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)
Looks good
• Say to whom it must be returned
– well done
PAT 2010
Collect information
•
•
•
•
16
Word 2003 paper survey
Adapt a survey template
Collect information
PAT 2010
17
Word 2007 paper survey
Adapt a survey template
Collect information
PAT 2010
18
Example of a paper survey
Collect information
PAT 2010
19
Word forms survey 1/2
Collect information
• Create Word
form
• Tell people
how and
where to save
PAT 2010
20
Word forms survey 2/2
PAT 2010
Collect information
• Make form Read only
by right-clicking
• Put where people can
view
21
Survey
PAT 2010
Collect information
• 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
22
Collect information from paper
survey
PAT 2010
Collect information
Silly layout! Only need one column per question
23
Collect information from paper
survey
Silly layout! Only need one row per person
Collect information
PAT 2010
24
Collect information from paper
survey
PAT 2010
Collect information
Meaningless
headings
25
Collect information from paper
survey
Best!
Collect information
Nice headings
Well laid out
PAT 2010
26
Collect information from Word
form 1/5
PAT 2010
Collect information
• Open completed Word form
• Office button, Word Options, Advanced,
Preserve fidelity when sharing this
document, Save form data as delimited
text file
27
Collect information from Word
form 2/5
PAT 2010
Collect information
• Save carefully – at
our school save on
Desktop and in
folder (why – does
not seem to save in
folder)
• As txt
28
Collect information from Word
form 3/5
• That is the data saved
Collect information
• That data must be imported
PAT 2010
into Excel
29
Collect information from Word
form 4/5
• In Excel, Data, From Text
• Delimited, Comma
Collect information
PAT 2010
30
Collect information from Word
form 5/5
Collect information
• Hooray. Now add the data from all the forms.
• Leave ONE line between each until you have all
(why – experience – do not know)
PAT 2010
31
Get totals
Analyse the information
Analyse information
Use Countif
function
to total results
PAT 2010
32
Select data for graph
Analyse information
PAT 2010
33
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.
PAT 2010
Analyse information
1.
2.
3.
4.
5.
34
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
35
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
Believe?
Trust?
– Authority
Look
– Coverage
at
– Accuracy
next
slide
– Reliability
Then write – ‘This source is trustworthy or not trustworthy because
…’ for every single source.
PAT 2010
36
1.17 Trustworthiness – 2/2
Currency /
Timeliness
How recent is the information, but is the date important? Is the
date of information given, the date of publication, date of
revision?
Authority
Is the author an authority in that field? Is the author’s name
listed elsewhere as an authority?
Coverage
Does the article cover the topic?
Accuracy
Is the article accurate - Can you check what the source says
anywhere else?
Reliability
Is the information dependable and error-free? Are sources of
information stated? Is the information verifiable?
When possible, it is best to compare the content with
information in a traditional print or electronic resource.
Evaluate every source with this table
Then make a decision on its trustworthiness!
PAT 2010
37
1.18 File structure
• Check logical file structure, same topics
grouped together
• Clear folder names
• Clear file names
• No duplication
PAT 2010
38
Phase 1 Hand in
a.
Information collected
•
•
•
Paper envelope / plastic sleeve with 20 completed/ticked surveys
Photocopies of magazine articles
Any other evidence in printed format
b.
c.
d.
e.
f.
g.
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
Hand in in the
order given
Information in Phase 1 folder
1.
Information collected
•
•
2.
3.
4.
5.
6.
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
Clear file names
Document on cross referencing
PAT 2010
39
Document on trustworthiness
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 allPATquestions
2010
40
Phase 2
PAT 2010
41
Gr 12 PAT 2010
1.
2.
3.
4.
5.
6.
Introduction
a.
Discuss what is coming
b.
Description of the topic, e.g. effects of salty food, lack of sleep, eating fast
foods, lack of exercise, etc. and main question
c.
Rationale for this research
Habits of learners in my class
a.
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.
b.
5 topics
Problems found with the learners in my class
a.
I will look at the information in my graphs and compare it with the information
found on the topic.
b.
5 topics
Solutions to the problem in general
Conclusion
a.
Description of what found in your class
b.
Solution for the learners in yourPAT
class
based on your findings
2010
42
List of references
Phase 2
Part 1 – Report planning
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
44
Report planning
• Plan! Do not do the report
PAT 2010
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
45
Headings
PAT 2010
Report planning
• 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
46
Applications
In the planning document
say which formula, query,
etc. you used
Report planning
• 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
Think of all the features
– Word
you have learned in
• display information in table
Excel, Access, Word and
– PowerPoint
PowerPoint
PAT 2010
47
• present finding
Phase 2
Part 2 – Analyse
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
49
Phase 3
Final presentation
Gr 12 PAT 2010
1.
2.
3.
4.
5.
Introduction
a.
Discuss what is coming
b.
Description of the topic, e.g. effects of salty food, lack of sleep, eating fast
foods, lack of exercise, etc. and main question
c.
Rationale for this research
Habits of learners in my class
a.
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.
b.
5 topics
Problems found with the learners in my class
a.
I will look at the information in my graphs and compare it with the information
found on the topic.
b.
5 topics
Solutions to the problem in general
Conclusion
a.
Description of what found in your class
PAT 2010
51
b.
Solution for the learners in your class based on your findings
Introduction
• Describe what you are going to do in the
report
PAT 2010
52
Habits in detail – Use planning
document
• Heading1 for 6 main headings
• Under Habits heading – add Heading2s – must
make sense, not questions
PAT 2010
53
Habits in detail - Get ready – PATs
• Spreadsheet – Countif; graph – background ?,
no amount of people, labels- must make sense;
conditional formatting, print ONE page
• Database
– Table – Imported, Records only,
– Queries
•
•
•
•
<> 100 – not equal to
Is Null, Is not null
NOT “hip Hop”
Calculation, Totals
– Reports – Grouping, Count
2010
– Report footer – Count,PATAverage,
etc.
54
Under each Heading2 of Habits
• Copy the graph
– In-line with text, centre
– Caption – Figure - short, to the point, needs no full stop,
centre
– Discussion – Use highest, more, most, lowest, less or least
– Cross reference
• Copy a calculation totals query from Access
– In-line with text, centre
– Caption – Table - short, to the point, needs no full stop,
centre
– Discussion of table - Use highest, more, most, lowest, less
or least
MaybePAT
only
have one set of comments with cross
2010
55
– Cross reference
referencing at end of graph and query table.
Under each Heading2 of Habits
• Copy some totals / averages from a
database report
• Discussion – use good language
It is clearly shown in Figure X and Table Y
that ….
PAT 2010
56
Habits
• At the beginning of the Habits section add
the words
In the following section I will discuss the habits
of learners in my class: …, …, …, … and ….
• At end of Habits section, add the words
In the following section on Problems I will
discuss the problems the learners in my class
can have from their habits.
PAT 2010
57
Extra
•
•
•
•
•
•
•
•
Add a Cover page
Add a page for a Table of contents
Add a Table of contents
Add a Table of figures
Add a Table of tables
Check you have page numbering!
Introduction – clean up text
Put on network – hand in rubric
PAT 2010
58
Phew!
• Have taught so far
• 6 May 2010
PAT 2010
59
Problems - Found with the
learners in my class
–
–
Use same headings as Habits
(Look at the information in your graphs and compare
it with the information found on the topic.)
– Discuss
•
the subject where it is connected to what you investigated
•
–
therefore based on the data shown in Habits the learners
have the following problem
Good grief. Is that how the learner
are!
Based on what I found in books and
on the web, they will have this
problem and that problem!
Insert
•
•
Cross referencing to every graph/table
citations every reference to information found elsewhere!
PAT 2010
60
Solutions - To the problem in
general
• Use same headings as Habits and
Problems
• What solutions can you suggest for
the young people in your class under
the chosen topics?
• Insert citations for every reference to
information found elsewhere!
PAT 2010
61
Conclusion
• Say what you intended in the report
• Say what you found and solutions
• Most one page
PAT 2010
62
Formatting
• Graphs
– Insert captions – Figures
– When you talk about the graph use cross referencing
• Tables
– Insert captions – Table
– When you talk about the table use cross referencing
• Every fact
– Provide citation
– Get ready for List of references
PAT 2010
63
Finishing off - Structure
Title page
Name, class, game name
Page numbers
X of y
Table of contents
Table of figures
Table of tables
On page on own at beginning of document,
page numbers right of headings
References
At end
Introduction
Say what you are going to discuss, put this just
before Planning or …
Conclusion
Say what you have discussed and final
recommendations
PAT 2010
64
Finishing off - Looks
Title page
Use a nice Cover page
Images,
graphs and
tables
Centred, in-line with text, write about each, must be
part of the story - not separate, must help explain the
text where it is placed
Captions
Under images, graphs and tables, centred, is a short
heading, no full stop, explanation in body text
Paragraph
spacing
1.5
Fonts
One font used
Headings
Bold, larger than body text, no colons, no bullets
Body text,
headings
Aligned left
Columns
Maybe something
columns
PATin
2010
65
Phase 3 - Report
• Hand in
– Printed report
– (PowerPoint as Word document)
– Completed rubric
• Information in Phase 3 folder
–
–
–
–
Spreadsheet
Database
(PowerPoint)
Report
PAT 2010
66
List of references
• Free Internet Morabaraba Server. (n.d.) Retrieved: 27
July 2009, from http://www.morabaraba.org/.
• Jukskei. (2009) Jukskei. Retrieved: 27 July 2009, from
http://en.wikipedia.org/wiki/Jukskei.
• Marabaraba. (n.d.). Retrieved: 27 July 2009, from
http://www.kr.co.za/Publishing/Marketing/Teambuilding_
Activities_Marabaraba.pdf.
• Mindsprts South Africa. (n.d.) Retrieved: 27 July 2009,
from http://www.mindsportssa.freeservers.com/rulesmorabaraba.htm.
Sort alphabetically
Tricky
Rather use 2007 referencing
Grade
PAT 2010
10 PAT
67
4 June