Difference between revisions of "ICT student textbook/Numbers and patterns"

From Open Educational Resources
Jump to navigation Jump to search
Line 1: Line 1:
−
{{Navigate|Prev=Data representation and processing level 2|Curr=Numbers and patterns|Next=Text document with data analysis}}
+
{{Navigate|Prev=Columns and rows!|Curr=Numbers and patterns|Next=Data representation and processing level 2 learning check list}}
−
'''Title of Activity'''
+
 
 +
'''<u><big>{{font color|brown|Numbers and patterns}}</big></u>'''<br>
 +
{{font color|brown|In this activity, you will explore the fun in numbers and mathematics, using the spreadsheet software}}
 +
 
 
<div class="noprint" style="float:right; border:1px solid blue;width:300px;background-color:#F5F5F5;padding:2px;">
 
<div class="noprint" style="float:right; border:1px solid blue;width:300px;background-color:#F5F5F5;padding:2px;">
 
{| cellspacing="0"
 
{| cellspacing="0"
 
| [[File:Book.jpg|none|80px|Book image]]
 
| [[File:Book.jpg|none|80px|Book image]]
−
| style="padding-left:2px;" | Go to <br /> [[ICT teacher handbook/Data_representation_and_processing|Teacher Transaction Notes]]
+
| style="padding-left:2px;" | Go to <br /> [[ICT teacher handbook/Data_representation_and_processing|ICT Teacher Handbook]]
 
|}</div>
 
|}</div>
  
Line 16: Line 19:
 
#Comfort with data input methods
 
#Comfort with data input methods
 
#Entry into spreadsheets  
 
#Entry into spreadsheets  
−
===Resources needed ===
+
===What resources do you need===
 
#Computer lab with projection equipment
 
#Computer lab with projection equipment
 
#Number patterns worksheets (for students to explore, create)
 
#Number patterns worksheets (for students to explore, create)
 
#Handout for [[Learn LibreOffice Calc|LibreOffice Calc]]
 
#Handout for [[Learn LibreOffice Calc|LibreOffice Calc]]
 
#Handout for [[Learn LibreOffice Writer|LibreOffice Writer]]
 
#Handout for [[Learn LibreOffice Writer|LibreOffice Writer]]
 +
#For additional reference - PK Srinivasan's [http://www.arvindguptatoys.com/arvindgupta/rompinginnumberlandeng.pdf Romping in Numberland]
 +
#For additional reference - PK Srinivasan's [http://www.arvindguptatoys.com/arvindgupta/calendar-1.pdf Fun with calendar]
  
−
===Digital skills===
+
===What digital skills will you learn===
 
#Working with spreadsheets for entering numbers  
 
#Working with spreadsheets for entering numbers  
 
#Getting familiar with simple operations in a spreadsheet
 
#Getting familiar with simple operations in a spreadsheet
  
 
===Description of activity with detailed steps===
 
===Description of activity with detailed steps===
−
====Teacher led activity====
+
====Teacher led activity ====
−
#Your teacher will show you the spreadsheet with some numbers
+
 
−
#She will demonstrate how you can use the spreadsheet to understand a pattern
+
===== How much fun in  calendar!! =====
−
#She will show you how to create a given pattern
+
{| class="wikitable"
−
====Student activities====
+
|[[File:Calendarmagicpicture.png|thumb|450x450px|How much fun in a calendar!!]]
−
#Individual spreadsheet patterns – Your teacher will give you some sheets for number patterns, you can create them with the spreadsheet
+
|
−
#Group activities – Did you ever imagine a calendar can be so much fun?  In groups, create the patterns in the spreadsheet.
+
# Do you recognize this picture? Yes, it is a calendar of a month with 30 days.
 +
# Your teacher will show you how to create this with spreadsheet and help you identify the hidden patterns in this calendar. 
 +
# See if you can find the following:
 +
## Horizontal sequences
 +
## Vertical sequences
 +
## Diagonal sequences
 +
## Find rectangular and square arrangements in the calendar
 +
## Averages and sums in the calendar
 +
# Finding days when dates are given
 +
|}
 +
===== Number puzzles =====
 +
Your teacher will discuss the following number puzzle with you.  See if you can solve the last equation by doing different operations on the numbers. CORRECT THE 1+2+3 to 1 O 2 O 3 IN TABLE BELOW
  
 +
<gallery mode="packed" heights="100px" style="text-align:left">
 +
File:Spreadsheetdemo.png
 +
File:Spreadsheetpattern1.png
 +
File:Spreadsheetpattern2.png
 +
File:Spreadsheetpattern3.png
 +
</gallery>
 +
 +
==== Algebra made easy ====
 +
Look at the following columns and numbers on each one of the pictures.  Work with your teacher to find out what is the relationship between the columns (x) and (y).  Can you state it like an equation?  Have you studied this in algebra?  You can create your own patterns and see how numbers behave!!
 +
 +
<gallery mode="packed" heights="180px" style="text-align:left">
 +
File:Algebraprep1.png
 +
File:Algerbraprep2.png
 +
File:Algebraprep3.png
 +
File:Algebraprep4.png
 +
</gallery>
 +
 +
==== Student activities ====
 +
#Make more calendars and explore the patterns; your teacher may do this in groups with you.
 +
#Your teacher will give you patterns for you to create using spreadsheet and explore.
 +
#Investigate  a set of triangular numbers with a spreadsheet
 +
#Investigate triads of of consecutive numbers
 +
##Sum of a set of consecutive numbers
 +
##Product of a set of consecutive numbers
 +
##End product of a set of consecutive numbers
 +
##End product of a set of consecutive numbers divided by the middle number
 +
#Investigate four consecutive numbers
 +
##Sum of end numbers
 +
##Sum of middle numbers
 +
##Product of end numbers
 +
##Product of middle numbers
 
===Portfolio===
 
===Portfolio===
−
#Your own number patterns with spreadsheets!
+
#Calendar explorations in a spreadsheet
 +
#Your spreadsheet files
 +
 
 +
[[Category:Level 2]]
 +
[[Category:Data representation and processing]]

Revision as of 07:05, 6 April 2017

ICT student textbook
Columns and rows! Numbers and patterns Data representation and processing level 2 learning check list

Numbers and patterns
In this activity, you will explore the fun in numbers and mathematics, using the spreadsheet software

Book image
 Go to
ICT Teacher Handbook

Objectives

  1. Understanding that numbers are data; they are data and they represent data
  2. Working with spreadsheet to decode number patterns
  3. Working with spreadsheet to create number patterns

What prior skills are assumed

  1. Familiarity with the ICT environment and various applications
  2. Comfort with data input methods
  3. Entry into spreadsheets

What resources do you need

  1. Computer lab with projection equipment
  2. Number patterns worksheets (for students to explore, create)
  3. Handout for LibreOffice Calc
  4. Handout for LibreOffice Writer
  5. For additional reference - PK Srinivasan's Romping in Numberland
  6. For additional reference - PK Srinivasan's Fun with calendar

What digital skills will you learn

  1. Working with spreadsheets for entering numbers
  2. Getting familiar with simple operations in a spreadsheet

Description of activity with detailed steps

Teacher led activity

How much fun in calendar!!
How much fun in a calendar!!
  1. Do you recognize this picture? Yes, it is a calendar of a month with 30 days.
  2. Your teacher will show you how to create this with spreadsheet and help you identify the hidden patterns in this calendar.
  3. See if you can find the following:
    1. Horizontal sequences
    2. Vertical sequences
    3. Diagonal sequences
    4. Find rectangular and square arrangements in the calendar
    5. Averages and sums in the calendar
  4. Finding days when dates are given
Number puzzles

Your teacher will discuss the following number puzzle with you. See if you can solve the last equation by doing different operations on the numbers. CORRECT THE 1+2+3 to 1 O 2 O 3 IN TABLE BELOW

  • Spreadsheetdemo.png
  • Spreadsheetpattern1.png
  • Spreadsheetpattern2.png
  • Spreadsheetpattern3.png

Algebra made easy

Look at the following columns and numbers on each one of the pictures. Work with your teacher to find out what is the relationship between the columns (x) and (y). Can you state it like an equation? Have you studied this in algebra? You can create your own patterns and see how numbers behave!!

  • Algebraprep1.png
  • Algerbraprep2.png
  • Algebraprep3.png
  • Algebraprep4.png

Student activities

  1. Make more calendars and explore the patterns; your teacher may do this in groups with you.
  2. Your teacher will give you patterns for you to create using spreadsheet and explore.
  3. Investigate a set of triangular numbers with a spreadsheet
  4. Investigate triads of of consecutive numbers
    1. Sum of a set of consecutive numbers
    2. Product of a set of consecutive numbers
    3. End product of a set of consecutive numbers
    4. End product of a set of consecutive numbers divided by the middle number
  5. Investigate four consecutive numbers
    1. Sum of end numbers
    2. Sum of middle numbers
    3. Product of end numbers
    4. Product of middle numbers

Portfolio

  1. Calendar explorations in a spreadsheet
  2. Your spreadsheet files
Retrieved from "https://teacher-network.in/OER/index.php?title=ICT_student_textbook/Numbers_and_patterns&oldid=7333"