Learning Objectives:
Using Excel to make a Spread Sheet
A Pioneer Journey
Information and Communication Technology Outcomes- Spreadsheets
The Outcomes listed below represent baseline Outcomes achieved when students engage in spreadsheet activities.
C. Communicating, Inquiring, Decision Making, and Problem Solving
C1. Students will access, use and communicate information from a variety of technologies.
Division 1
1.1 access and retrieve appropriate information from electronic sources for a specific inquiry
1.2 process information from more than one source to retell what has been discovered
C3. Students will critically assess information accessed through the use of a variety of technologies.
Division 1
1.1 compare and contrast information from similar types of electronic sources
C4. Students will use organizational processes and tools to manage inquiry.
Division 1
1.1 follow a
plan to complete an inquiry
1.2 formulate new questions as research progresses
1.3 organize information from more than one source
C6. Students will use technology to investigate and/or solve problems.
Division 1
1.1 use technology to organize and display data in a problem-solving context
1.3 use technology to support and present conclusions
C7. Students will use electronic research techniques to construct personal knowledge and meaning.
Division 1
1.1 develop questions that reflect a personal
information need
1.2 summarize data by picking key words from gathered information and by using
jottings, point form or retelling
1.3 draw conclusions from organized information
1.4 make predictions based on organized information
F. Foundational Operations, Knowledge, and Concepts
F4. Students will become discerning consumers of mass media and electronic information.
Division 1
1.1 compare similar types of information from two different electronic sources
Outcomes for Social Studies- Topic A: My Community in the Past, and Future- Spreadsheet Activity Present,
Major Generalization- Changes in my community have taken place over time.
1) Changes in my community have taken place in the past, are taking place today, and may occur in the future.
a) Indefinite time concepts.
b) Time and place relationships.
c) What the community was like before the settlers came.
d) The reasons for settling an area.
2) People in communities contribute to change.
a) Changes in food, clothing, shelter, communication, education, land use, and/or inhabitants.
b) Causes and effects of change.
c) Positive and negative results of change.
3) Locating/Organizing/Interpreting Information
a) Arranging events, facts and/or ideas.
b) Using various electronic tools to locate and organize information.
4) Analyzing/Synthesizing/Evaluating/
a) Generate ways an individual can influence change.
b) Compose a title for a story, paragraph, picture, graph, map and /or chart.
Outcomes for Grade 3 Mathematics- Spreadsheets
|
Strand: Number (Number Operations) Students will:
|
General Outcome
Use and justify an appropriate calculation strategy or technology to solve problems.
Specific Outcomes
1. Verify solutions to addition and subtraction problems, using estimation and calculators.
.2. Verify solutions to addition and subtraction problems, using the inverse operation.
3. Justify the choice of method for addition and subtraction, using:
 |
Estimation strategies |
|
Mental mathematics strategies |
|
Manipulatives |
|
Algorithms |
|
Calculators |
|
|
4. Calculate products and quotients, using estimation strategies and mental mathematics strategies.
|
Strand: Statistics and Probability (Data Analysis) Students will:
|
General Outcomes
Collect first and second-hand data, display the results in more than one way, and interpret the data to make predictions.
Specific Outcomes
Collect data, using measuring devices and printed/technology resources.
Display data, using rank order.
Display the same data in more than one way.
Make predictions and inferences when solving similar problems.
Obtain new information by performing arithmetic operations on the data.
Life as a Pioneer Activity Using PowerPoint
Information and Communication Technology Outcomes for Multimedia Projects
Category: Communicating, Inquiring, Decision Making and Problem Solving
C1. Students will access, use and communicate information from a variety of technologies.
1.1 access and retrieve appropriate information from electronic sources for a specific inquiry
1.2 process information from more than one source to retell what has been discovered
C4. Students will use organizational processes and tools to manage inquiry.
1.1
follow a plan to complete an inquiry
1.2 formulate new questions as research progresses
1.3 organize information from more than one source
C6. Students will use technology to investigate and/or solve problems.
1.1
identify a problem within a defined context
1.2 use technology to organize and display data in a problem-solving context
1.3 use technology to support and present conclusions
C7. Students will use electronic research techniques to construct personal knowledge and meaning.
1.1develop questions that reflect a personal information need
1.2 summarize data by picking key words from gathered information and by
using jottings, point form or retelling
1.3 draw conclusions from organized information
1.4 make predictions based on organized information
Category: Foundational Operations, Knowledge and Concepts
F4. Students will become discerning consumers of mass media and electronic information
1.1 compare similar types of information from two different electronic sources
F5. Students will practice the concepts of ergonomics and safety when using technology
1.1 demonstrate proper posture when using a computer
1.2 demonstrate safe behaviors when using technology
Category: Processes for Productivity
P3. Students will communicate through multimedia.
1.1 access images, such as clip art, to support communication
1.2 create visual images by using such tools as paint and draw programs for particular audiences and purposes
1.3 access sound clips or recorded voice to support communication
P4. Students will integrate various applications.
1.1 integrate text and graphics to form a meaningful message
1.2 balance text and graphics for visual effect
Outcomes for Social Studies- Topic A: Multimedia
Major Generalization- Changes in my community have taken place over time.
1) Changes in my community have taken place in the past, are taking place today, and may occur in the future.
a. Indefinite time concepts.
b. Time and place relationships.
c. What the community was like before the settlers came.
d. The reasons for settling an area.
2) People in communities contribute to change.
a. Changes in food, clothing, transportation, shelter, communication, education, education,
land use, and/or inhabitants.
b. Causes and effects of change.
c. Positive and negative results of change.
d. Contributions of people in the community.
e. Ways to contribute to change.
Students will be able to do the following:
Process Skills
3) Locating/Organizing/Interpreting Information
a. Arranging events, facts and/or ideas.
b. Using various electronic tools to locate and organize information.
c. Identify possible sources and location of information.
d. Acquiring information by listening to or reading simple historical events.
4) Analyzing/Synthesizing/Evaluating/
a. Generate ways an individual can influence change.
b. Compose a title for a story, paragraph, picture, graph, map and /or chart.
c. Compare information gained from two different sources to see if it is similar or different.
d. Draw conclusions about community changes, past and present.
e. Predict future changes in the community.
5) Geography/Mapping
a. Identify reasons for settlement and development by using pictures, aerial
photographs and/or historical maps.
Communication Skills
a. Record events on a simple timeline.
b. Write a journal entry from the point of view of an individual in the past.
c. Collect pictures to show ways in which the community has changed.
d. Compose a title for a story, picture, paragraph, graph, map, and/or chart.
Participation Skills
Make meaningful contributions to discussions, supporting ideas with facts and reasons.
Participate in small group discussions and activities by following established rules.
Stay on task.
Students will be encouraged to develop:
a. Interest in local history.
b. Appreciation for change.
c. Self-competence; an individual can influence change.
d. Skills in various areas in technology.
Language Arts Outcomes- Multimedia
Students will listen, speak, read, write, view and represent to explore thoughts, ideas, feelings and experiences.
1.1 Discover and Explore
Express ideas and develop understanding
|
connect prior knowledge and personal experiences with new ideas and information in oral, print and other media texts |
|
explain understanding of new concepts in own words |
|
explore ideas and feelings by asking questions, talking to others and referring to oral, print and other media texts |
Experiment with language and forms
|
choose appropriate forms of oral, print and other media texts for communicating and sharing ideas with others |
Express preferences
|
choose and share a variety of oral, print and other media texts in areas of particular interest |
1.3 Clarify and Extend
Combine ideas
|
experiment with arranging and recording ideas and information in a variety of ways |
Extend understanding
|
ask questions to clarify information and ensure understanding |
Students will listen, speak, read, write, view and represent to comprehend and respond personally and critically to oral, print and other media texts.
2.1 Use Strategies and Cues
Use prior knowledge
|
share ideas developed through interests, experiences and discussion that are related to new ideas and information |
Use comprehension strategies
|
identify the main idea or topic and supporting details in simple narrative and expository passages |
2.2 Respond to Texts
Experience various texts
|
choose a variety of oral, print and other media texts for shared and independent listening, reading and viewing experiences, using texts from a variety of cultural traditions and genres, such as nonfiction, chapter books, illustrated storybooks, drum dances, fables, CDROM programs and plays |
|
tell or write about favorite parts of oral, print and other media texts |
|
connect own experiences with the experiences of individuals portrayed in oral, print and other media texts, using textual references |
|
experience oral, print and other media texts from a variety of cultural traditions and genres, such as personal narratives, plays, novels, video programs, adventure stories, folk tales, informational texts, mysteries, poetry and CDROM programs |
|
retell events of stories in another form or medium |
Construct meaning from texts
|
connect portrayals of characters or situations in oral, print and other media texts to personal and classroom experiences |
|
summarize the main idea of individual oral, print and other media texts |
|
discuss, represent or write about ideas in oral, print and other media texts, and relate them to own ideas and experiences and to other texts |
2.4 Create Original Text
Generate ideas
|
experiment with ways of generating and organizing ideas prior to creating oral, print and other media texts |
3.1 Plan and Focus
Focus attention
|
use self-questioning to identify information needed to supplement personal knowledge on a topic |
|
identify facts and opinions, main ideas and details in oral, print and other media texts |
Determine information needs
|
ask topic-appropriate questions to identify information needs |
Plan to gather information
|
contribute ideas for developing a class plan to access and gather ideas and information |
3.2 Select and Process
Use a variety of sources
|
find information to answer research questions, using a variety of sources, such as children’s magazines, CDROMs, plays, folk tales, songs, stories and the environment |
Access information
|
use text features, such as titles, pictures, headings, labels, diagrams and dictionary guide words, to access information |
|
locate answers to questions and extract appropriate and significant information from oral, print and other media texts |
|
use card or electronic catalogues to locate information |
Evaluate sources
|
review information to determine its usefulness in answering research questions |
3.3 Organize, Record and Evaluate
Record information
|
record facts and ideas using a variety of strategies; list titles and authors of sources |
|
list significant ideas and information from oral, print and other media texts |
Evaluate information
|
determine if gathered information is sufficient to answer research questions |
3.4 Share and Review
Share ideas and information
|
organize and share ideas and information on topics to engage familiar audiences |
|
use titles, headings and visuals to add interest and highlight important points of presentation |
Review research process
|
assess the research process, using pre-established criteria |
4.1 Enhance and Improve
|
use keyboarding skills to compose, revise and print text |
|
understand and use vocabulary associated with keyboarding and word processing |
Enhance artistry
|
choose words, language patterns, illustrations or sounds to add detail and create desired effects in oral, print and other media texts. |
4.3 Present and Share
Present information
|
present ideas and information on a topic, using a pre-established plan |
Enhance presentation
|
use print and nonprint aids to illustrate ideas and information in oral, print and other media texts |
Use effective oral and visual communication
|
speak or present oral readings with fluency, rhythm, pace, and with appropriate intonation to emphasize key ideas |
Demonstrate attentive listening and viewing
|
rephrase, restate and explain the meaning of oral and visual presentations |
|
identify and set purposes for listening and viewing |
5.1 Respect Others and Strengthen Community
Appreciate diversity
|
describe similarities between experiences and traditions encountered in daily life and those portrayed in oral, print and other media texts |
|
retell, paraphrase or explain ideas in oral, print and other media texts |
Packing Your Wagon- Spreadsheet Activities