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

From Open Educational Resources
Jump to navigation Jump to search
 
(6 intermediate revisions by 3 users not shown)
Line 1: Line 1:
−
{{Navigate|Prev=Data representation and processing level 2|Curr=Numbers and patterns|Next=Columns and rows!}}
+
[http://karnatakaeducation.org.in/KOER/index.php/ಐಸಿಟಿ_ವಿದ್ಯಾರ್ಥಿ_ಪಠ್ಯ/ಸಂಖ್ಯೆಗಳು_ಹಾಗು_ವಿನ್ಯಾಸಗಳು ಕನ್ನಡ]{{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>
  
−
=Objectives=
+
===Objectives===
−
#
+
#Understanding that numbers are data and they represent data
−
#
+
#Working with spreadsheet to decode number patterns
−
#
+
#Working with spreadsheet to create number patterns
−
#
+
 
 +
===What prior skills are assumed===
 +
#Familiarity with the ICT environment and various applications
 +
#Comfort with data input methods
 +
#Entry into spreadsheets
 +
===What resources do you need===
 +
#Computer lab with projection equipment
 +
#Number patterns worksheets (for students to explore, create)
 +
#Handout for [[Learn LibreOffice Calc|LibreOffice Calc]]
 +
#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]
 +
 
 +
===What digital skills will you learn===
 +
#Working with spreadsheets for entering numbers
 +
#Getting familiar with simple operations in a spreadsheet
 +
 
 +
===Description of activity with detailed steps===
 +
====Teacher led activity ====
 +
 
 +
===== How much fun in  calendar!! =====
 +
{| class="wikitable"
 +
|[[File:Calendarmagicpicture.png|thumb|450x450px|How much fun in a calendar!!]]
 +
|
 +
# 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. The following symbol ‘*’ is used to indicate the operation.
  
−
=What prior skills are assumed=
+
<gallery mode="packed" heights="150px" caption="Number puzzles">
−
#
+
File:SpreadsheetPicture1.png|left|thumb|Number puzzle 1
−
#
+
File:Spreadsheetpicture2.png|thumb|Number puzzle 2
−
#
+
File:Spreadsheetpicture4.png|thumb|Number puzzle 4
−
#
+
File:Spreadsheetpicture3.png|thumb|Number puzzle 3
−
=Resources needed =
+
</gallery>
−
'''Hardware, software, Files'''
 
−
#
 
−
#
 
−
#
 
−
#
 
  
−
=Digital skills=
+
==== 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!!
−
#
 
−
#Link to tool page as needed
 
−
#Link to tool page as needed
 
  
−
=Description of activity with detailed steps=
+
<gallery mode="packed" heights="180px" style="text-align:left">
−
==Teacher led activity==
+
File:Algebraprep1.png
−
#
+
File:Algerbraprep2.png
−
#
+
File:Algebraprep3.png
−
#
+
File:Algebraprep4.png
−
#
+
</gallery>
−
##
 
−
##
 
−
##
 
−
##
 
−
#
 
−
##
 
−
##
 
−
==Student activities==
 
  
−
=Portfolio=
+
==== 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===
 +
#Calendar explorations in a spreadsheet
 +
#Your spreadsheet files
  
−
=How to use the template=
+
[[Category:Level 2]]
−
#<nowiki>{{subst:ICT-Project}}</nowiki>
+
[[Category:Data representation and processing]]
−
#After the template is inserted go to the side box syntax and add the corresponding chapter link from the teacher handbook
 
−
Add a link to the Teacher Handbook
 

Latest revision as of 12:38, 3 June 2019

ಕನ್ನಡ

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 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. The following symbol ‘*’ is used to indicate the operation.

  • Number puzzles

  • Number puzzle 1

  • Number puzzle 2

  • Number puzzle 4

  • Number puzzle 3

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=9865"