Binary Academy Computing - ICT Resources for K-12 by Andreas Tsouchlaris

SAMPLER

COURSES FOR 21st CENTURY LEARNERS

Computing

ICT

and

includes sample modules

Grade 1 Digital Kids Starter

Grade 5 Digital Kids Genius

Grade 8 Digital Teens Level 2

This sampler includes Introduction 3 International Standards

Curriculum Framework

Modern educational material

Developing 21st Century Skills

Programming - Coding - Robotics

Computing and ICT topics

Student Resources

Teacher Academic Support

Teacher Resources Samples

Effective Teaching Methodology

Digital Kids Scope & Sequence

DIgital Teens Scope & Sequence

Digital Kids Starter (Grade 1) Key Features

Digital Kids Starter (Grade 1) Sample Pages

Digital Kids Genius (Grade 5) Key Features

Digital Kids Genius (Grade 5) Sample Pages

Digital Teens 2 (Grade 8) Key Features

Digital Teens 2 (Grade 8) Sample Pages

Computing and ICT are the new literacy

Information and Communications Technologies (ICT) are now part of the educational experience of children and teenagers in most parts of the world. Taught as a separate subject, as well as being embedded within the curriculum, Computing and ICT is increasingly regarded as a new literacy, alongside reading, writing and numeracy. Digital Kids and Digital Teens are designed to introduce students to the key Computing concepts and ICT applications they need to use in order to acquire that literacy and to help them understand the impact of technology on our daily lives. The curriculum provides a framework in which Computing and ICT competences and practical skills can be developed within an environment that is appropriate for the age of the students.

38 years

working with technology in schools > Serving the learning community

Binary Logic has been working actively with schools, universities and Ministries of Education around the world since 1982 and is well known for the quality of its educational resources and services. The company belongs to the MM Educational Group which was founded in 1974 and since then it has been dedicated to excellence in education. The founders of Binary Logic are educators who decided to incorporate technology early on as they saw the need for innovative ways and methods to enrich students’ learning experience. With Belt Study System and ELT SKILLS, we’ve made English language learning practical, ﬂexible and fun through learning experiences that are interactive and tailored to students’ specific needs. In today’s everchanging society, we are focusing on the subject of Computing and ICT in schools. Through our innovative curriculum and academic support we have become a worldwide leader.

> Our experience in school environments

We design complete solutions for real classroom conditions. The students’ needs determine the form of our educational material and with our extensive experience in educational technology we are well positioned to meet the challenges in a wide variety of school environments. There are thousands of schools and universities in Europe, the Middle East, Asia and Latin America using educational solutions created by Binary Logic.

binarylogic.net

mmedugroup.com

Digital Kids

FOR PRIMARY SCHOOLS

6 LEVELS

Student-centered learning through a fun, hands-on approach Written and designed by educators Modern educational material that meets various learning styles Fully graded and designed for schools Content aligned to student needs in each age group Activities based on school subjects in each grade

Digital Teens

FOR SECONDARY SCHOOLS

6 LEVELS

Language in English edition is graded to facilitate non-native speakers Available in several languages Coding and robotics available in diďŹ&#x20AC;erent grades

Local education with global standards

ICT SKILLS

FOR COLLEGES & UNIVERSITIES

eSkills

FOR SCHOOLS

LEVELS

Digital Kids Grades 1-6 for Primary schools

Grade 1

Computing and ICT . Sampler

Grade 2

Grade 3

Grade 4

Digital Kids Starter and Explorer are specifically created for very young learners!

Grade 5

Grade 6

Digital Teens Grades 7-12 for Secondary schools

Grade 7

Grade 8

Grade 10

Grade 11

Digital Teens 6 is entirely project-based and helps students practice the Computing and ICT skills they acquired in previous years.

Computing and ICT . Sampler

Grade 12

Grade 9

International Standards Digital Kids and Digital Teens follow the latest international Computing and ICT teaching standards

> The series take into consideration the competencies valued in Computing and ICT around the world. > The curriculum is mapped against national standards and requirements in a number of countries. > The skills learned reďŹ&#x201A;ect the performance standards in demand in an international context. Digital Literacy Standard Curriculum

The International Society for Technology in Education (ISTE) completed a Seal of Alignment for Readiness review of Digital Kids, Digital Teens, eSkills and ICT Skills and determined that they provide an effective foundation for successfully acquiring the knowledge and applying the skills described by the ISTE Standards for Students.

Suitable for international exam preparation

Computing and ICT . Sampler

for example:

Extra Online Material

Curriculum Framework Content curriculum and resources that are aligned with and support digital age learning

> Designed specifically for young learners and teenagers incorporating the latest developments in pedagogy. > Provides interesting real-life scenarios and activities to engage and motivate students. > Promotes key skills: collaboration, communication, teamwork, critical thinking, problem-solving and decision-making.

Spiral Curriculum Following the spiral curriculum, students repeat the material at different grade levels, each time at a higher level of difficulty and in greater depth.

Grade 1

Grade 2

Grade 3 ❸ My first article

❷ I type a letter

1. W ork with text

❹ Let’s type

1. I start typing

2. Give a title

1. T he notepad

2. Change the font

3. M ake a list

2. Letter and words

3. I nsert pictures

4. Check and save

3. M ove around

4. Save and print

4. Select and change a word

Grade 4

Grade 5 ❶ Creating a document

Grade 6 ❶ Designing a document 1. P resentation graphics 2. Columns and tabs

1. F ormat a paragraph

2. Search and replace

3. H eader and footers

2. Images - Advanced formatting

3. W orking with tables

4. The final touch

3. S pelling and grammar check

4. Document views

4. Print

Computing and ICT . Sampler

1. A dvanced formatting

❷ Working with text

Modern educational material Project-based learning The Group Work section in Digital Kids 1-6 and the Project Task in Digital Teens 7-12 engage students through real life activities. Digital Teens 12 is entirely based on projects. > Cross-curricular activities based on the school subjects of the same grade > Promotes collaboration and group work

Digital Kids Racer

> For the home or the computer lab

Digital Kids Flyer

Digital Teens 1

Flexibility

Computing and ICT . Sampler

Digital Kids can be started at grade 1, 2, 3 or 4.

The do you remember? section takes care of important knowledge that the students may have missed. The Studentâ&#x20AC;&#x2122;s Book and the supporting teaching resources accommodate the teacherâ&#x20AC;&#x2122;s teaching style.

Digital Kids Expert Digital Kids Flyer

Developing 21st Century Skills A complete approach to ICT skills Digital Literacy is more than the ability to use a computer. Learning to collaborate with others and connect through technology are essential skills. Thinking Creativity, critical thinking, problem-solving, decision-making and learning Working Communication and collaboration

Critical Thinker Communicator

Solving problems

Understanding and communicating ideas

Collaborator Working with others

Creator Producing innovative work

Living Digital citizenship, personal and social responsibility

Learning all modern platforms and tools Our digital world is not only Windows and Office. As with anything related to technology, new tools are emerging constantly. Students learn how to work with different kinds of platforms and tools to build real life computer skills. We want them to be able to adapt to change and be equipped to face their future life and work. Imagine what technology will be like 5 or 10 years from now when your students will be completing their studies.

Digital Kids Genius

Our Computing and ICT curriculum covers a broad range of technologies and tools. The Other platforms section at the end of each module shows some of the alternatives available.

Computing and ICT . Sampler

Students learn to gather and use information appropriately and ethically and use social tools responsibly and safely.

Digital Kids Flyer

Programming - Coding - Robotics Programming helps students understand and apply the fundamental principles and concepts of computing and computer science, including logic, algorithms and data representation.

Short lessons that can match the time that is available in the school curriculum.

Our educational material follows a spiral, project-based approach based on the age and school grade of the students. Programming is introduced at various stages and in various complexity both in primary and secondary grades with different programming tools and languages. Robotics labs are supported with resources for different educational robot kits and virtual platforms.

Extra coding and robotics material for Grades 1-9.

Learn how to code in: Logo Small Basic Scratch Python Visual Basic HTML MIT App Inventor

Computing and ICT . Sampler

Apply coding skills to robotics for the new generation of kids and teenagers.

Teacher support Teachers get full support to be effective in the computer lab, easily, even if they do not have experience in teaching programming.

Computing and ICT topics Our curriculum for schools ensures that all students: > Are competent, confident, and creative users of information technology > Can critically evaluate and apply information technology (including new and unfamiliar technologies) responsibly, collaboratively and effectively to solve problems > Can analyze problems in computational terms, and can write computer programs in order to solve them > Can understand and apply the fundamental principles of computer science, including logic, algorithms, data representation, and networks > Can critically express the individual, cultural and societal impacts of technology, and know how to stay safe, exploit opportunities and manage risks

To accomplish these goals, the following topics are covered with an emphasis on skills needed to build a knowledge-based economy:

> The computer (hardware, peripherals, operating system, file system, security) > Working on the Internet (web surfing/ searching, email, calendar and contact management, safe computing) > Multimedia presentations (editing photos, sound, movie clip creation) > Word processing (with mathematical equations, envelopes and labels) > Spreadsheets (with charts and data exchange) > Presentations (with presentation skills) > Databases (working with various tools to organize information) > Online communication (blogging, social media, video conferencing) > Cloud computing and collaboration (online office suites, sharing documents, online meetings, presentation broadcasting, notes management and sharing, mind mapping) > Digital citizenship (e-safety, privacy, ethics and intellectual property) > Computer Science concepts (computer systems and networks) > Introduction to programming â&#x20AC;&#x201C; Computational thinking > Introduction to robotics > Designing and developing software applications > Building websites (with online apps and later with HTML/CSS tools) > Introduction to game development

> Project management and diagramming > Image manipulation and 2D animation techniques > Video editing and 3D animation techniques

Computing and ICT . Sampler

> Modern technology skills (networking, storage & backup, simple IT troubleshooting, security, cloud storage)

Student Resources For any device > Works on any device with a web browser such as tablets, smartphones and even smart TVs > Supports Windows, MacOSX, iOS, Android, Linux, Chrome Book > No need for a DVD drive Module Resources

> Accessible anywhere anytime

Dynamic Online Content New content continually updated according to changes in technology and the evolution of applications. 2020

2021

FUTURE PROOF

2023

2022 Video Tutorials

Online Resources Individualized access from school or home according to grade: > Video tutorials for the applications in the Studentâ&#x20AC;&#x2122;s Book and alternative ones > Digital resources > Animated Stories for very young students

Computing and ICT . Sampler

> Interactive Activities for primary students

> Extra eBooks for Coding and Robotics

> Extra eBooks for alternative applications > Extra eBooks for international exams

Online Module Tests

> Online module tests, certificates and Grades Management Platform (optional)

Go to binary-academy.com to access the Studentâ&#x20AC;&#x2122;s Online Resources

Animated Stories - Interactive Activities

Teacher Academic Support Online Resources > Teacher’s Guide with structured and detailed lesson plans > Worksheets with extra activities for the computer lab or homework > Self evaluation sheets > Practice websites with stable and safe content for children > All language editions are available to the teacher

binary-academy.com All teacher resources are available in editable DOC and PPT files. Everything is online and updated to accommodate technological advances and teacher feedback.

Assessment Opportunities For each task (Lesson) > Hands-on activity (individual performance) > Worksheet (individual or group performance) > Student self-evaluation questionnaire (student-driven accountability) For every module (Unit) > Group Work and Projects (project-based learning, collaboration, group performance / presenting results) > Module Test (online testing, automated grading, individual performance, online record-keeping) - Optional End of course (Level) > Final Exam (online testing, automated grading, individual performance, successful completion Certificate available) - Optional

http://binary-academy.com/dnld Download sample Teaching Resources

Grades Management Each school that adopts our curriculum has access to our Grades Management Platform. The supervisor can prepare the school environment: > Create teachers > Create classes

> Assign teachers to classes The teacher can manage the students’ tests and grades: > Unlock online tests for each class > Enter grades for assignments

> Get reports for tests or grades > Print certificates

Become a confident and eﬀective Computing and ICT teacher. BinaryAcademy offers Continuing Professional Development (CPD) on how to use our educational material via online and face-to-face training courses. Our teacher training takes care of the ever-changing challenges in technology and helps you adapt our resources to your teaching style and the specific needs of your school.

Computing and ICT . Sampler

> Move students to classes

Professional Development

Teacher Academic Support

http://binary-academy.com/dnld Download sample Teaching Resources

Resources for Digital Kids Expert Module 5 Task 1 Lesson Plan

DKEXPERT

MODULE 5 TASK 1

Programming the computer Introduction to programming

TEACHER

CLASS

OVERVIEW The general purpose of this lesson is for students to understand the concept of algorithms, programs and flowcharts. OBJECTIVES • To understand what a program is. • To understand what happens when a program runs. • To describe how programmers write programs. • To understand what an algorithm is. SKILLS • To create an algorithm in order to solve a problem. • To convert an algorithm into a flowchart. • To draw a flowchart. • To name the boxes that a flowchart consists of. • To describe the function of each box in a flowchart. WHAT IS NEEDED Prerequisites (None) Resources • Digital Kids Expert Student’s Book • K.6.5.1_Worksheet_1.docx • K.6.5.1_Worksheet_2.docx • K.6.5.1_Worksheet_3.docx • K.6.5.1_Evaluation_Sheet.docx

Activity Worksheets

Worksheet

Level

Module

Task

Student(s)

LEARNING DIFFICULTIES • Students have difficulty understanding that 0s and 1s can control a computer. • Students have difficulty understanding that in programming there are rules that always have to be followed. • Students have difficulty analyzing a problem correctly in order to present its solution, broken down into smaller subunits. • Students have difficulty understanding the input and output of data in a flowchart.

Class Date

The concept of the program

LESSON DESCRIPTION 1. Start – Brainstorming Introduce the purpose of the lesson which is for students to understand the meaning of programming. Then they have to introduce the meaning of algorithms. More specifically: • Ask students to describe the solution to a problem, such as the recipe of a cake, using simple and clear steps. • Write down the steps on the whiteboard and ask them to put the steps in a logical order. • Liken this process to the meaning of the

As you know, computers consist of hardware and software. Hardware is all the devices that are necessary for a computer to work. On the other hand, software is all the programs that hardware needs in order to work correctly!  But what is a program?  Do you know of any programs?  What happens when a program runs?

True

False

    

1. A computer program is a list of instructions. 2. Computers understand the English language. 3. Programs are written by programmers in 0s, 1s and 2s. 4. There are special programming languages such as Small Basic. 5. Computers cannot make decisions by themselves.



Self Evaluation Sheet

There are many problems in our everyday life that we try to solve. Sometimes their solutions are easy and obvious and other times they are difficult. A good way to solve a problem is to use an algorithm. An algorithm is a sequence of defined actions. We use a flowchart in order to represent an algorithm. This is a flowchart:



NOTES

- 35 -

DIGITAL KIDS EXPERT / MODULE 5 / TASK 1

Indicate  whether the following sentences are true or false?

DATE

algorithm. • Ask them if the order of the steps of a solution are changed, will the solution still work? Draw a flowchart representing an algorithm to introduce the steps applied in execution of an algorithm. Separate students into groups of 2-3. Give out “K.6.5.1_Worksheet_1.docx” and ask students to read the introduction and encourage them to answer the questions. 2. Investigation – Development of Knowledge Then, ask students to do the activities on the worksheet. During the activities they will realize that: • A program is a list of instructions. • There are people that create programs in order to solve problems. • An algorithm is a step-by-step list of instructions in a specific order. • A flowchart is a representation of an algorithm. • There are specific types of boxes in a flowchart. 3. Implementation Hand out “K.6.5.1_Worksheet_2.docx.” In this activity students have to create a flowchart. They have to put the steps in the correct order. Then, hand out “K.6.5.1_Worksheet_3.docx.” Students have to draw the correct shape and arrows in order to complete the flowchart. During the completion of the flowchart, students should note the importance of: • The correct input of data • The validity of data • The output of data Let students discuss how to draw their flowcharts amongst themselves and if necessary consult the Student’s Book. 4. Completion – Evaluation After completing the activities, collect all the worksheets and file them in the class folder. • Hand out the evaluation sheet to every student and ask them to complete it. • Collect the sheets and see if the students understood all the objectives of the lesson. • Check which part of the lesson students didn’t completely understand and make any changes required in the teaching process.

Self Evaluation

START

Level

Module

Task

Class

Student

Date

READ a

READ b

CALCULATE a + b

PRINT a + b

END © Binary Logic SA 2013-2017. PHOTOCOPIABLE

Worksheet

Level

Module

Page 1 of 2

Task

Student(s)

Class

Worksheet

Date

Computing and ICT . Sampler

Match each action with the proper box:

Mark the beginning of the process



Give commands



Show data



Mark the end of the process



Make a decision



Get data



Do calculations



Level

Module

Task

Class Date



Create an algorithm! 

When you get up every morning, you follow a set of actions to go to school. Below is a list of instructions that you have to use in order to fill in the blanks in a step by step algorithm and in a flowchart:



Eat breakfast



Go to school

Indicate  whether the following sentences are true or false? True

If it is raining take an umbrella

False

1. An algorithm is a step-by-step list of instructions.



2. A computer can decide which instructions of an algorithm need to be followed in order to solve a problem.



3. An algorithm’s instructions must be simple.



4. There are algorithms in the world of computers, but not in the real world.



5. A recipe is like an algorithm.



6. An algorithm describes steps.



7. If a programmer gives the wrong instructions to a computer, the computer can correct them.



8. A flowchart represents an algorithm.



9. A flowchart is the only way to solve a problem.



10. A flowchart shows the steps of a solution to a problem, as well as their order.



11. You should first write a program and then the corresponding flowchart.



12. The arrows in a flowchart show us the order of the steps.



13. The arrows in a flowchart are optional.



14. To draw a flowchart you use 5 different types of boxes.



Student(s)

The concept of the program

Brush your teeth



Put on your clothes Get up from bed Get your backpack

Step by step algorithm 1

Page 2 of 2

....................................................

Start

……………………… ………… ……………………… ………… ……………………… ………… ……………………… ………… ………………………… ……… …………….

I can create an algorithm in order to solve a problem.

□

I can convert an algorithm into a flowchart.

□

I can draw a flowchart.

□

I can name the boxes that a flowchart consists of.

□

I can describe the function of each box in a flowchart.

□

Yes

……………………… ………… ………………………… ……… End

Page 1 of 1

Teacher Academic Support

http://binary-academy.com/dnld Download sample Teaching Resources

Resources for Digital Teens 2 Module 5 Task 1

Lesson Plan

DT2

MODULE 5 Analyzing data

OVERVIEW To make complex calculations in Microsoft Excel.

Level

Module

Task

WHAT IS NEEDED Prerequisites Basic knowledge of Microsoft Excel (to use AutoFill in order to copy, to add columns and rows to a spreadsheet, to know the correct sequence of calculations). Resources • Digital Teens 2 Student’s Book • T.2.5.1_Worksheet_1.docx • T.2.5.1_Worksheet_2.docx • T.2.5.1_Evaluation_Sheet.docx • T.2.5.1_Final.xlsx Tools & Equipment Microsoft Excel Or a similar program from the list with alternative tools.

Class

Student(s)

Date

Let’s work with spreadsheets

LEARNING DIFFICULTIES • Many students have difficulty in following the proper sequence of math calculations as they don’t know the basic mathematical rules. • Some students confuse the function of the percent sign of Percent Style on the Formatting toolbar with the percent sign. When they need to add a percent sign to a number, they select the cell first and then click the Percent Style button on the Formatting toolbar. Doing this, won’t only add a percent sign to the number, but it will also multiply the number by 100. On the other

As you know, the main reason people use spreadsheets is to organize and analyze information. Imagine that the mayor of your city assigns some research for the construction of a round square in your neighborhood to your group. Analyze the given data using a spreadsheet in order to get the best results. First of all, you have to know that: The radius of the round square is 50 m. The budget is $15,000. You can choose five different items that your square can contain. Below is a table of the construction costs which will help you calculate the total building cost.

   

Cost ($) / m2

NOTES

- 43 -

DIGITAL TEENS 2 / MODULE 5 / TASK 1

DATE

LESSON DESCRIPTION A. Start – Brainstorming • Ask students questions about the importance of making calculations and using functions in Microsoft Excel. More specifically, you could ask them: o How can we analyze imported data in a table? o Do you know the proper sequence of math calculations? o Have you ever used AutoFill in order to avoid repeating the same process? o Have you ever worked with functions in Microsoft Excel? Have you ever used the Power function? o Do you know how to calculate percentages? • Separate students into groups of 2-3. B. Implementation • Hand out “T.2.5.1_Worksheet_1.docx.” Ask students to do the activity. Open the Excel file “T.2.5.1_Final.xlsx” to show students an example of what their table should look like. • Then, hand out “T.2.5.1_Worksheet_2.docx.” Ask students to complete the activity. During the activity: o Explain to students that the total area of the items must be exactly the same as the area of the square (7,850 m2). o Help them calculate the percentages if necessary. o The total building cost must not exceed $15,000. • Tell students that they can consult their Student’s Book. • Encourage discussion amongst students and add that if they have any questions they can ask you. C. Completion – Evaluation • Hand out the evaluation sheet to every student and ask them to complete it. • Collect the sheets and see if they understood all the objectives that we had for this lesson. • Check which part of the lesson students didn’t completely understand and make any changes required in the teaching process.

SKILLS • To perform more complex calculations in a formula. • To transform a number to a percentage and more specifically to: o Add percentages with the Percent Style button o Determine the decimal places • To calculate a power of a number using the symbol ^. • To use the Power function (x , y).

Worksheet

CLASS

hand, if they just want to add a percent sign to a number without multiplying it by 100, they should just type the symbol.

OBJECTIVES • To understand the correct order of calculations. More specifically to know that: o multiplication and division are done first and then addition and subtraction. o If there are parentheses, first do the calculations inside them and then the rest. • To work with percentages making the proper calculations. • To realize the different ways to calculate percentages. • To understand how to calculate the power of a number in different ways.

Activity Worksheets

TEACHER

TASK 1 Complex calculations

Cost ($) / Item

Grass

Fountains

Trees

Flowers

20 $

1.5 $

0.5 $

Playground 500 m2 3000 $

Basketball court

Mini soccer field

Tennis court

(28x15) m

(20 x40) m

(37x16)m

2500 $

5000 $

2000 $

Self Evaluation Sheet

Create a table in a spreadsheet Now, you have to create a table to analyze this data making calculations and using functions that Microsoft Excel offers. More specifically:

o o

The “Area” column depicts the surface area which you want to cover with each item in the square. The “Percentage” column depicts what part of the total area is covered by each item. The value column depicts the construction cost of each item.

In this table cell B7 must contain the total area of the square.

Assuming that the shape of the square is a circle, put a  if the following calculations calculate the area correctly.

Level

Module

Task

Student(s)

Class

Worksheet

Date

Make calculations and enter data

= B2^2 = B2 * C2

 

= B2/B7 % = D2/B7 %

 

4.  

= B7/B5 % = 30*20/B7*100

= SUM (B2:B8) = B2*4

 

Module

Task

Student(s)

Which item takes up the most space? What is the total building cost?

= B2/B7*100 % = B7/B2 %

 

= 30*20/B7*100 % = (30*20) + B7*100

 

= SUM (B2:B6) = B1+B2+B3+B4+B5+B6

Class Date

Put a  if the sentence is correct

1. The correct sequence of calculations is addition and subtraction first and then multiplication and division.



2. If there are parentheses in an equation, first we do the calculations inside the parentheses and then the rest.



3. To calculate the area of a circle with a radius of 5 cm, we type = 3.14 * POWER(2,5)



4. To calculate the area of a circle with a radius of 5 cm, we type = 3.14 * POWER(5,2)



5. The only way to add percentage to a cell is to press shift+5.



Date

1 ..................... 2 ..................... 3 ..................... 4 ..................... 5 ..................... Item: ............................

Percentage: …….

Total cost: ……………



= B3-D3*B3



= D3*B3+B3



= 12*B3+B3



= D3*B3-B3

E6 = 0.12*B6+B6 = 0.12*B6-B6

 

G3 = B3*3 = E3*2

 = B3*2  = E3*3

G6 = (0.12*B6+B6)*3 = 0.12*B6+B6*3

     

Now, it’s time to enter data in your table making the proper calculations. Then fill in the table below:

Class

= C2 * 1.5 = B2 * 1.5

 

Task

Page 1 of 2

Page 2 of 2

 

= 0.12*(B6+B6) = 1.2 *B6+B6

= (0.12*B6+B6)*5 = 0.12*B6+B6*5 Page 1 of 1

Computing and ICT . Sampler

Now you have to enter the proper data into your Excel table. Remember that: The total building cost must not exceed $15,000. The total area of the items must be equal to the area of the square. However, do you know which calculations and functions you have to use in order to get the desired result? Look carefully at the spreadsheet below. Then select what we have to write in the cells in order to have the correct content.

 

Level

Which items will you use for the square in the end?

2. Select what we have to write in the cells in order to have the correct content on the spreadsheet below.

Page 1 of 1

Let’s work with spreadsheets

Module

Student

 = 3.14*B8^2  = 3.14*POWER(50^2)  = 3.14*POWER(2,50)  = 3.14*POWER(50,2)

Level

Open Microsoft Excel and create a table similar to the one on the right. More specifically:



Worksheet

Self Evaluation

Effective Teaching Methodology Let’s have a look inside Digital Kids Flyer (Grade 4)

Task 1 Task 2 Task 3 Task 4

Student’s Book

Module 1 Module 2 Module 3 Module 4 Module 5

Other Platforms section Group Work Activity & Vocabulary

Computing and ICT . Sampler

Student’s Online Resources

Student’s Material Teacher’s Material Downloadable Content Modiﬁable Content

Online Module Test

Student’s Book

Do you Remember section

Hands On Activity

Theory

Student’s Online Resources

Digital Documents for Practice

Video Tutorials

eBooks

Animated Stories

Interactive Activities

Teacher’s Online Resources

Activity Worksheets

Self Evaluation Sheets

Video Tutorials

Computing and ICT . Sampler

Teacher’s Guide with Lesson Plans

Scope & Sequence what students will learn

Digital Kids Starter (Grade 1)

Digital Kids Explorer (Grade 2)

Digital Kids Racer (Grade 3)

❶ My computer

❶ I use the computer

❶ My devices

1. Dinosaurs and computers

1. My computer

1. Store

2. They are every where

2. My desktop

2. Print

3. The computer

3. Mouse and keyboard

3. Capture

4. Click and type

4. My work space

4. Interact

❷ I type a letter

❷ My files

❷ Let’s start 1. My desktop

1. I start typing

1. What is a file?

2. Start a program

2. Change the font

2. Organize my folders

3. Text and pictures

3. Insert pictures

3. Search and find

4. My work space

4. Save and print

4. Start a program

❸ Let’s paint

Computing and ICT . Sampler

❸ My first article

1. Free drawing

1. How to surf

1. Work with text

2. Make shapes

2. The web page

2. Give a title

3. Copy and paste

3. Educational games

3. Make a list

4. Save my picture

4. Copy from the web

4. Check and save

❹ Let’s type

❸ I visit the world

❹ I have friends

❹ My wired world

1. The notepad

1. My email

1. Search for anything

2. Letter and words

2. Send a message

2. Knowledge treasure sites

3. Move around

3. Read and reply

3. Be polite

4. Select and change a word

4. Email rules

4. Safety online

❺ Let’s surf

❺ I give commands

❺ My first presentation

1. The Internet

1. Logo and the turtle

1. All about slides

2. Communicate

2. Move the turtle

2. Insert text

3. Have fun

3. Draw a shape

3. Insert pictures

4. Learn

4. Let’s have fun!

4. Presenting is cool

Digital Kids Flyer (Grade 4)

Digital Kids Genious (Grade 5)

Digital Kids Expert (Grade 6)

❶ Learning the basics

❶ Creating a document

❶ Designing a document

1. M y desktop

1. A dvanced formatting

1. P resentation graphics

2. Files and folders

2. Search and replace

2. Columns and tabs

3. C ontrol panel

3. W orking with tables

3. H eader and footers

4. Protect my computer

4. Document views

4. The final touch

❷ Working with text

❷ Producing multimedia

❷ Building a website

1. F ormat a paragraph

1. U se capture devices

1. W hat is a web page

2. Images - Advanced formatting

2. Create and edit a sound clip

2. Design a web page

3. S pelling and grammar check

3. F ind and use multimedia material

3. A dd more pages

4. Print

4. Create an animated story

4. Publishing the web page

❸ Communicating online

❸ Using communication tools

❸ Analyzing data

1. M y friends

1. I nternet and the web

1. M ore calculations

2. Forward an email

2. Communication tools

2. Functions

3. S end a file

3. S haring your moments

3. References

4. Email tips

4. Be secure online

4. More charts

❹ Working with media

❹ Sharing your ideas

❹ Handling data

1. C reate a sound clip

1. Blogging

1. S tructured information

2. View images and videos

2. Social media

2. Use a data entry form

3. F ix a photo

3. S afety rules

3. F ilter the data

4. Apply photo effects

4. Intellectual property

4. Create a report

❺ Presenting your ideas

❺ Formatting numbers

❺ Programming the computer

1. T ransitions and animations

1. F ormat a cell

1. I ntroduction to programming

2. Set the timing

2. Make calculations

2. How to design a program

3. I nsert a sound or video clip

3. C reate a graph

3. V ariables and commands

4. Transfer data across apps

4. Print a sheet

4. More programming

❻ Collecting information

❻ Let’s have fun

1. W hat is a spreadsheet?

1. G ather data

1. F un with shapes

2. Row - Column - Cell

2. Introduction to databases

2. What is datalogging

3. I nsert numbers and text

3. C reate a database

3. Robots!

4. Simple calculations

4. Sort and print

4. Create your computer game

Computing and ICT . Sampler

❻ Working with numbers

Scope & Sequence what students will learn Digital Teens 1 (Grade 7)

Digital Teens 2 (Grade 8)

Digital Teens 3 (Grade 9)

❶ Learning the basics

❶ Collecting information

❶ Handling databases

Computers and devices

Introduction to databases

Structured information

The operating system

Filter and sort

Data entry forms

Files and folders

Keys and relationships

Queries

Basic settings

Contact management

Reports

Hints and tips

Lab data collection

Import and export data

Project

❷ Creating a document

Tabs and columns

Text documents

Advanced font formatting

Headers and footers

Spreadsheets

Images and graphics

HTML and PDF

Presentations

Working with tables

Mail merge

Project 1 – Leaﬂet

Check and print

Advanced topics

Project 2 – Labels

Project

Project 3 – Market research

❸ Multimedia presentations

❸ Programming the computer

Surfing the web

Storyboarding

What is a program?

Use online resources

Capture and edit multimedia

Variables and commands

Send and receive email

Record your voice

Conditions and branching

Organizing email

Fix photos and add effects

Functions and subroutines

Be safe online

Create an animated story

Have fun!

Project

❹ Working with numbers

❹ Communicating online

❹ Deep diving

Rows and columns

Networking basics

Advanced networking

Advanced formatting

What is a blog?

Servers and storage

Simple calculations

Social Media

I’m an IT administrator

Logical functions

Communication tools

Data and network security

Create a chart

Digital citizenship

Cloud storage

Project

❺ Presenting your ideas Computing and ICT . Sampler

❷ Documents for a purpose

Formatting text

❸ Getting online

❷ Designing a document

❺ Analyzing data

❺ ICT is fun

Slides, text and images

Complex calculations

Design your website

Transitions and animations

Functions

Publish your website

Sound and video

References

Design your own game

Charts and graphs

Advanced charts

Add gameplay interactions

Tips and tricks

Import and export data

Science projects

Project

Digital Teens 4 (Grade 10)

Digital Teens 5 (Grade 11)

Digital Teens 6 (Grade 12)

❶ Computer science basics

❶ Building a website

❶ Teacher

Data manipulation

Design a web page

The gradebook

Computer architecture

Web hosting and SEO

A school event

Operating systems

HTML and CSS

A topic presentation

Network fundamentals

Insert content

A school trip

Computers in society

Web forms

The school newspaper

Project

The school blog

❷ Working online

❷ Graphics design

❷ Sales manager

Working with documents online

Vector graphics

Make a proposal

Online meetings

Coloring and shaping

Daily report

Presentation broadcasting

Adding text and reshaping

Sales notebook

Notes management

Making curves

Sales reports

Mind mapping

More design tools

A new product

Project

A customer database

❸ Advanced imaging

❸ Interactive applications

❸ Digital marketer

Image essentials

Getting started

Plan your marketing stategy

Layers

Designing the UI

Email marketing campaign

Image adjustments

Animating objects

A brand blog

Retouch and enhance

Adding interactivity

Create blog content

2D animation creation

Working with sound and video

Blog and social media

Project

Social media audit

❹ Desktop Publishing

❹ Advanced multimedia

❹ Web designer

From etching to DTP

Video shooting

Newsletter template

Basic tools

Video editing

Code an email newsletter

Single-page design

Visual effects

Design a one column website

Multi-page document I

The final touch

Code a one column website

Multi-page document II

3D animation

Design a two column website

Project

Build a two column website

❺ Developing applications

❺ Project management

❺ Application developer

What is a project?

Organize the data

Decisions and repetition

Organizing tasks

Handling a database

Database management

Create a Gantt chart

Start building your app

Classes, objects and inheritance

Create a diagram

Images and videos

User interface and testing

Changing colors and fonts

Add a new record

Project

Search with a filter

Computing and ICT . Sampler

Programming concepts

Welcome to

Digital Kids Starter

Computing and Computing ICTICT . Sampler

Key features and sample pages

discover more at binarylogic.net

Key Features

An innovative approach to teaching Computing and ICT written by a team of educators. Follows latest Computing and ICT teaching standards & requirements. Each book has four or ﬁve modules. Each module provides a range of tasks and activities that help students to develop their Computing and ICT skills and allow teachers to monitor the students’ progress.

Clear explanations and illustrative contemporary examples.

The activities are based on school subjects taught in each grade.

New content continually updated according to changes in technology. Students learn how to work with many diﬀerent platforms and tools. The online video tutorials guide the students through each task.

Computing and ICT . Sampler

Clear learning objectives and functional skills.

Computing and ICT . Sample Pages DIGITAL KIDS STARTER MODULE 2

2. Letâ&#x20AC;&#x2122;s start

GRADE

Computing and ICT . Sample Pages DIGITAL KIDS STARTER MODULE 2 GRADE

2. Letâ&#x20AC;&#x2122;s start / My desktop Computing and ICT . Sample Pages DIGITAL KIDS STARTER MODULE 2

TASK 1

My desktop

This is my desktop.

GRADE

I always start my work here.

Match.

Computing and ICT . Sample Pages DIGITAL KIDS STARTER MODULE 2 GRADE

28 doublecli c

2. Letâ&#x20AC;&#x2122;s start / Start a program Computing and ICT . Sample Pages DIGITAL KIDS STARTER MODULE 2

TASK 2

Start a program To start a program. double-click its icon.

GRADE

) (x2

The program window. 1

clic

Computing and ICT . Sample Pages DIGITAL KIDS STARTER MODULE 2

Minimize the program.

Maximize the program.

GRADE

Close the program. 29

TASK 3

Text and pictures

Computing and ICT . Sample Pages DIGITAL KIDS STARTER MODULE 2

Your digital ﬁles for learning and having fun.

2. Let’s start / Text and pictures

sound

GRADE

picture

video

text

Match.

Computing and ICT . Sample Pages DIGITAL KIDS STARTER MODULE 2 GRADE

TASK 4

My workspace Keep your computer and desk clean. Be careful with the cables.

Computing and ICT . Sample Pages DIGITAL KIDS STARTER MODULE 2

Don’t eat or drink in the computer room.

2. Let’s start / My workspace

GRADE

Computing and ICT . Sample Pages DIGITAL KIDS STARTER MODULE 2 GRADE

2. Letâ&#x20AC;&#x2122;s start / My workspace Computing and ICT . Sample Pages DIGITAL KIDS STARTER MODULE 2

Sit in the correct way.

GRADE

. Who is right? Mark with

. Who is wrong? Mark with

Computing and ICT . Sample Pages DIGITAL KIDS STARTER MODULE 2 GRADE

Welcome to

Digital Kids Genius

Computing and ICT . Sampler

Key features and sample pages

discover more at binarylogic.net

Key Features

An innovative approach to teaching Computing and ICT written by a team of educators.

Follows latest Computing and ICT teaching standards & requirements. Each book has four or ﬁve modules. Each module provides a range of tasks and activities that help students to develop their Computing and ICT skills and allow teachers to monitor the students’ progress. The “do you remember?” section focuses on important points which students need to revise.

Clear learning objectives and functional skills. Clear explanations and illustrative contemporary examples. The activities are based on school subjects taught in each grade.

Project-based learning The group-work activity consolidates skills previously taught and encourages students’ collaboration. Most group-work activities are cross-curricular.

New content continually updated according to changes in technology. Students learn how to work with many diﬀerent platforms and tools.

New vocabulary is organized in related topics.

Computing and ICT . Sampler

The “Other platforms” section at the end of each module shows some of the available alternatives. The online video tutorials guide the students through each task.

Computing and ICT . Sample Pages DIGITAL KIDS GENIUS MODULE 1

1. Creating a document

GRADE

Hi! Welcome back!

Learning objectives In this module you will learn:

> the correct use of spacing between lines and characters. > how to ﬁnd or replace a word quickly, anywhere in the document.

> how to edit and format tables. > to choose the best document view according to your needs.

Computing and ICT . Sample Pages DIGITAL KIDS GENIUS MODULE 1

It’s time to learn how to make your documents more attractive and easier to read. Sometimes you have to ﬁnd and replace words or phrases clearly. Also, you may want to show some information and make it stand out from the rest of the text. What do you do? Use a table, of course! Are you ready to start? Let’s go!

GRADE

Tools Skills

> Microsoft Word

After this module you will be able to:

> Apple Pages

> change the character spacing of a word.

> ﬁnd and replace a word or a phrase.

> create and format tables. > change the view of your document.

> LibreOﬃce Writer > Docs to Go for Google Android

do you remember?

How to choose a font > Change the Font. > Change the Size of the font. > Make the font Bold. > Make the font Italic.

Computing and ICT . Sample Pages DIGITAL KIDS GENIUS MODULE 1

> Underline the font.

GRADE

> Change the Color of the font.

How to format a paragraph > Align a paragraph. > Adjust the Line Spacing. > Put a Border around the text. > Insert Bullets or Numbering.

How to format a picture

1. Creating a document

> Remove the Background of an image. > Change the Style of an image. > Change the Position of an image. > Change the Wrap of the text around the image.

How to check for mistakes > On the Review Tab, in the ProoďŹ ng group, click Spelling & Grammar. > In the window that will appear select the word you want from Suggestions and click Change. > If you want to ignore the word, click Ignore Once.

TASK 1

Advanced formatting You already know how to quickly format a paragraph. Now let’s explore some more options. In Microsoft Word, most of the advanced formatting options are on the Home tab.

Character Spacing

To apply character spacing: > Select a word or phrase. > On the Home tab, in the Font group, click the expand button. 1 > In the Font window that will appear click Advanced tab. 2 > In the Spacing 3 drop down list, select Expanded if you want to increase the space or Condensed if you want to decrease the space.

2 5 3

Computing and ICT . Sample Pages DIGITAL KIDS GENIUS MODULE 1

Characters are the letters, numbers and symbols of the text. Character spacing is the distance between the letters of a word. We use this for many reasons: Sometimes you need more space between characters to make your text easier to read or you want to make the reader pay attention to a speciﬁc word without changing the word or phrase to bold or underlining it.

GRADE

> In the By text box 5 you can adjust the spacing in points (3pt is about 1 mm).

Scale can change the width of the characters. More than 100% will make the characters wider and less than 100% will make them narrower.

Position moves the characters you selected above or below the line of the rest of the text (baseline).

SMART TIP Position is not the same as Superscript or Subscript. It doesn’t change the size of the font, like they do.

Lines and paragraphs When you type a lot of text, you should follow some rules. For example, when you create a paragraph, keep typing until you ﬁnish it. Don’t press Enter  after each line. The program will take care of everything and wrap your text to the next line automatically.

Computing and ICT . Sample Pages DIGITAL KIDS GENIUS MODULE 1

1. Creating a document / Advanced formatting

This is a paragraph with continuous typing:

Press Enter  only when you want to create a new paragraph or add a new item in a list with bullets or numbers. The program will automatically add more space between paragraphs to make the text easier to read.

GRADE

Take a look! There is extra space between the lines and capital letters in the middle of the sentences! This is a sign that you have pressed Enter  at the end of a line, when probably you shouldn’t have.

Press Shift  + Enter  to break the line without a new paragraph.

Show / Hide non-printable characters To see if you have pressed Enter  or Shift  + Enter  try the following steps: On the Home tab, in the Paragraph group, click the Show/Hide button. 1 By clicking this button you can see these non-printable characters on your document where you have pressed Enter  , Space Bar , Tab  , etc.

Look at this example:

 is for Shift  + Enter 

¶ is for · is for

Enter 

Space Bar

 is for

Tab 

hands on!

Computing and ICT . Sample Pages DIGITAL KIDS GENIUS MODULE 1

Don’t worry about these symbols. You don’t have to hide them before printing. They are not printable. To hide them, just click on the Show/Hide button again.

GRADE

Type three paragraphs on how you spent your last weekend. Remember the rules about the use of Enter  . Type the following text and format it the same way on your computer. Don’t use the spacebar to create extra spacing! The Solar System

There are eight planets in our Solar System. Starting from the Sun, there’s M e r c u r y , V e n u s , E a r t h , M a r s , J u p i t e r, S a t u r n , U r a n u s a n d N e p t u n e . Some planets are bigger and some are smaller than Earth. Some are hotter and some are colder.

TASK 2

Search and replace Sometimes you want to find a word or phrase somewhere in the text and replace it with another one. If the document is large, you need a lot of time to read all of it. Imagine trying to find a single word or phrase in a document with 20 pages! Difficult, isn’t it? Let’s see how we can find any word in our document easily. To find a word or phrase: > On the Home tab, in the Editing group, click Find. 1

1. Creating a document / Search and replace

Computing and ICT . Sample Pages DIGITAL KIDS GENIUS MODULE 1

> The Navigation panel

will appear on the side.

> In the Search Document text box, type the word you want 3 and press

Enter 

> The program will ﬁnd and highlight all the places in your document containing the word or phrase you typed. 4

GRADE

2 4

4 4

Microsoft Word has a tool that can search an entire document to ﬁnd the word or phrase you want and instantly replace it with another one. It’s called Find and Replace. To replace a word or phrase: > On the Home tab, in the Editing group, click Replace. 1 > The Find and Replace will appear.

window

Replace All finds the word/phrase and replaces it with the word/phrase you want everywhere in your document. Double check before you click it.

> In the Find what text box, type the word or phrase you want to ﬁnd. 3 > In the Replace with text box, type the new word or phrase. > Click Replace.

Find Next shows the next place that this word or phrase exists in your document.

Computing and ICT . Sample Pages DIGITAL KIDS GENIUS MODULE 1

2 1

3 4

GRADE

Bz...Press Ctrl + H to open the Find and Replace dialog box...Bz

2 1

If you change your mind about a word or phrase you replaced, or if you make a mistake, you can correct it with Undo. On the Quick Access Toolbar 1 at the top of the program window, click the Undo button 2 or press Ctrl + Z .

hands on! Type the following text and try to replace the words below with synonyms from Thesaurus:

1. Creating a document / Search and replace

Computing and ICT . Sample Pages DIGITAL KIDS GENIUS MODULE 1

voyage, reached, famous, explored.

GRADE

Captain James Cook was a famous explorer. He was born in England in 1728. In 1768, he went on his ﬁrst voyage to the South Seas. On April 19th 1770, he reached and explored the East Coast of Australia. Cook named the place he reached ﬁrst Point Hicks, after one of his sailors.

Bz...Find the words: Find, Replace, Table, Advanced, Spacing, Character.

A N E H R E Z S F E F E C J F A N T E R F A F D E E W K G Z R V K E V S I M Y H R E R V U

R F I G D T A B L E J P N F M

L O E G N D H D X V V I B H D V Q B A V D V A C K G E G O A

A H D V O R E S C B S I Z H V

V J A R Q U R E H S E N O J R

R U T G C H D R A O L G N G E

E I E T K Q G T R A T C V T O

P I O R C M X G E R E P E B E C Z Z T A E Y B F A C T N W B Y B F T A N B S F A D V A V R

P B V L E C R B E Y B E B A E

A Y S A P D B D R U D R D N P

C S Q H K L L E E C E N O H V G R E G R H F R V R E F N M I F R V L O A F R V C E D I O A

TASK 3

Working with tables When you want to work with numbers and other data, you use a spreadsheet. But what do you do when you want to show organized information in a text document? For example, you may want to group the personal details of your classmates together, like their names, last names, addresses and phone numbers, or your school schedule. In this case, you can you use a table. This kind of table doesn’t have four legs! It’s a grid with rows, columns and cells, like on a spreadsheet.

Computing and ICT . Sample Pages DIGITAL KIDS GENIUS MODULE 1

To create a table:

GRADE

> On the Insert tab, in the Tables group, click Table. 1 > In the menu that appears, select the size of the table you want by moving your mouse vertically and horizontally across the boxes. For example, choose 4x4 to create a table with 4 rows and 4 columns. 2 > A table will appear in your document.

> To type text, just click inside a cell and start typing.

A table consists of rows, columns and cells, but they don’t have names like on a spreadsheet. If you want to do complex calculations, use Microsoft Excel and then copy all the cells to your document as a table.

Formatting a table Itâ&#x20AC;&#x2122;s very easy to format your table using the Table Styles group, or create a custom format.

To apply a style: > Click somewhere in the table.

1. Creating a document / Working with tables

Computing and ICT . Sample Pages DIGITAL KIDS GENIUS MODULE 1

> On the Design tab, in the Table Styles group, click the style you like. 1

GRADE

> The style you selected will change the appearance of the entire table. 2

You can also make a custom style if you want to. To do this, you can use the Borders or Shading buttons. Borders inserts lines around a table or inside a grid and Shading colors the cells. To use shading: > Select the area of the table you want to change the color of.

> On the Design tab, in the Table Styles group, click Shading. 1 > Click the color you want to apply to your table. 2

As always, you ďŹ rst select the area you want to format and then apply any format you choose from the menus.

To use a border: > Select the area of the table you want.

> On the Design tab, in the Borders group, click the small arrow. 1

> Click the type of border you want. For example Right Border. 2

Edit your table Computing and ICT . Sample Pages DIGITAL KIDS GENIUS MODULE 1

Sometimes you may want a larger table than the one you created. Good news! You don’t need to start all over again. You can add rows and columns to an existing table.

GRADE

To add a row or a column: > Right-click the cell next to which you want to add a row or a column. > On the pop-up menu click Insert. 1

> Click one of the options, for example, Insert Columns to the Right. 2 > A new column will appear on the right side of the selected cell.

You can also Insert Columns to the Left, Insert Rows Above, Insert Rows Below or Insert Cells… to add a single column, row or cell in the table.

To delete a row or a column: > Right-click any cell on the row or column you want to delete. > On the pop up menu, click Delete Cellsâ&#x20AC;Ś 1 > Click Delete entire row or Delete entire column to delete a row or column. 2 > Click OK.

1. Creating a document / Working with tables

Computing and ICT . Sample Pages DIGITAL KIDS GENIUS MODULE 1

hands on!

GRADE

Create a table for your school schedule. Put the days in columns, the hours in rows and the subjects in the cells. Format the schedule as you like. Use a big font size and print it for your desk.

TASK 4

Document views Sometimes the document that you create is not for printing. You may want to share it on the Internet or just create a long list of ideas. To work more eﬀectively, you can view your document in diﬀerent ways, like Print Layout or Web Layout.

Computing and ICT . Sample Pages DIGITAL KIDS GENIUS MODULE 1

You can explore these options on the View tab, in the Views group.

The Print Layout is the default view for Microsoft Word. It shows you how the document will look on paper. It’s better to use this document view if you are going to print your work.

GRADE

BE SAFE Sometimes you spend a lot of time in front of your computer. You don’t want to injure your neck or back so remember to sit properly when you work at your computer. “Mens sana in corpore sano” as the ancient Romans have said - a healthy mind in a healthy body.

Read documents The best way to read a document is to select the Read Mode. This type of view includes some features that have been designed for reading instead of writing. To see your document in Read mode: > On the View tab, in the Views group, click Read Mode. 1 > The document will cover the entire screen and most of the buttons are hidden. 2

1. Creating a document / Document views

Computing and ICT . Sample Pages DIGITAL KIDS GENIUS MODULE 1

> To edit the document click the View tab. 3

> In the pop-up menu that appears, click on Edit document. 4

Read Mode automatically resizes the text, using larger columns and fonts to view the document and make it bigger and easier to read.

GRADE

Web Layout shows your document as a web page. Use this layout if you prepare text and pictures for the Internet.

Outline is a special view that makes text look like a list of items.

The default view in older versions of Microsoft Word was Draft. In this view, you cannot see the actual margins of the page. Use this layout only if your computer screen is too small for Print Layout.

Zoom in and out Use the zoom slider on the bottom right corner of your window to make your document appear larger or smaller on screen. If you want to work on small details, zoom in (>100%). If you want to see the whole page or more than one page together, zoom out (<100%). Of course, this will not change the size that the text or pictures are printed when you print the document.

Bz...You can change the view of your document much faster with the small buttons on the status bar at the bottom of the program next to the zoom slider.

Read Mode

Web Layout Computing and ICT . Sample Pages DIGITAL KIDS GENIUS MODULE 1

hands on!

Print Layout

Are the following sentences true or false?

GRADE

1. The default view in Microsoft Word is Draft. True

False

2. You use Web Layout to see how the text will appear on the web. True

False

3. You always have to use Outline before you print a document. True

False

4. When your document is in Print Layout, it looks exactly as itâ&#x20AC;&#x2122;s going to be printed. True

False

5. You can edit your document in Full Screen Reading. True

False

Other platforms

> Tap to tables.

> Tables templates. > Tools button.

Apple Pages for iOS

With Apple Pages, you can easily insert tables and ﬁnd words or phrases. 1

> Find tool.

> Type the word you want to find. 5 > Choose Find and Replace to replace the word.

2 6 5

1. Creating a document / Other platforms

Computing and ICT . Sample Pages DIGITAL KIDS GENIUS MODULE 1

Docs to Go for Google Android

In Docs to Go, you can insert tables or ﬁnd words with a few taps. 5 6

> Insert table.

GRADE

> Type the number of rows you want.

> Type the number of columns you want. > Tap view to open Find.

> Type the word/phrase you want to find.

> Type the new word/phrase you want to replace the first one with. 6

LibreOffice Writer

Don’t forget! LibreOﬃce Writer is like an old version of Microsoft Word. Learn one and you can easily learn the other. Inserting tables or ﬁnding and replacing words or phrases will be very familiar procedures for you. 1

8 5

> Click Table.

> Click Insert Table. > Insert table.

7 2

> Click Find & Replace.

> Type the word/phrase you want to find. 8

> Type the number of columns. 4 > Type the number of rows.

> Click Edit.

> Type the word/phrase you want to replace the first one with. 9

4 5

wrap up Now you have learned how to:

> change the space between the characters of a text. > use Enter  and between lines.

Shift 

Enter 

correctly to make spaces

> ﬁnd a word in a text quickly.

> replace a word or phrase with another one.

Organize a picnic. Write a small text about a place near your school and what you want to do there. Use tables to organize what you need to bring with you, for example food, games, etc. and who will bring what.

GLOSSARY active cell

column

layout

replace

baseline

document view

outline

row

cell

grid

position

scale

Computing and ICT . Sample Pages DIGITAL KIDS GENIUS MODULE 1

group work

GRADE

Welcome to

Digital Teens 2

Computing and ICT . Sampler

Key features and sample pages

discover more at binarylogic.net

Key Features An innovative approach to teaching Computing and ICT written by a team of educators.

Clear learning objectives and functional skills. Each book has four or ﬁve modules. Each module provides a range of tasks and activities that help students to develop their ICT skills and allow teachers to monitor the students’ progress.

Project-based learning Clear explanations and illustrative contemporary examples. The activities are based on school subjects taught in each grade and are designed to engage students through real life projects.

New content continually updated according to changes in technology. Students learn how to work with many different platforms and tools.

New vocabulary is organized in related topics.

Computing and ICT . Sampler

The “Other platforms” section at the end of each module shows some of the available alternatives. The online video tutorials guide the students through each task.

Computing and ICT . Sample Pages DIGITAL TEENS 2 MODULE 5

5. Analyzing data

GRADE

It’s time to master your math. In this module, you are going to use Microsoft Excel to make complex calculations without mistakes. You will learn to present your information with diﬀerent types of charts and to format the data so that it is easier to understand. You will also learn how to transfer your data and use it in any other program.

Skills After this module you will be able to: > work with powers and percentages.

> use advanced functions.

> create conditions using multiple IF functions.

Learning objectives In this module you will learn: > how to make complex calculations.

> how to use Excel’s functions for faster calculations. > how to work with logical functions.

> how to avoid mistakes in calculations.

> how to present information with charts. > how to emphasize information using formatting.

> how to exchange data with other programs.

> use relative and absolute references.

> understand and correct error messages.

> format diﬀerent types of charts. > create mini charts.

> apply conditional formatting to cells.

> import and export data as a CSV ﬁle.

Tools > Microsoft Excel

> Apple Numbers > Sheet To Go

> LibreOﬃce Calc

TASK 1

Complex calculations You know how to make simple calculations using Microsoft Excel. What about a complex algebraic expression? Well, it’s time to make difﬁcult things much easier and faster.

Calculation rules

The calculation order: 1

Firstly, do the operations in parentheses.

2 Secondly, do the calculations with exponents. 3 Then, do the multiplications and divisions. 4 And in the end, do the additions and subtractions.

multiplication

exponent

division

addition

subtraction

percentage

Let’s ﬁnd the result of ((2021^2/2021)-2020)^2021 To calculate the formula: > On a worksheet, click cell A1. 1

> Type =, to start the formula.

GRADE

> Type the mathematical formula ((2021^2/2021)2020)^2021. 2 > Press

Enter 

Computing and ICT . Sample Pages DIGITAL TEENS 2 MODULE 5

When you do complex calculations and there is more than one part to the formula, the order of the calculations is from left to right, but any part of the formula in parentheses will be calculated ﬁrst.

The basic calculations and their symbols in Microsoft Excel are:

1 2

Let’s try another one! This time, you are going to write a formula which will contain a cell reference. In this way, you will produce a result that may change if the data in those cells also change. Type the numbers below:

To calculate the expression ((C1^A1)-(D1^B1))+((B1/ A1)*A1)^2: > Click cell A3 and type ((C1^A1)-(D1^B1))+ ((B1/A1)*A1)^2. 1 > Press

Enter 

When you click a cell, its reference appears in the formula box.

Work with percentages Working with percentages is a little bit tricky. Pay attention and pretty soon, everything will be clear! Type this table: You can change the value displayed from a decimal number to a percentage by applying the percentage format. Microsoft Excel multiplies the cell by 100 and displays the result with the percentage sign.

5. Analyzing data / Complex calculations

Computing and ICT . Sample Pages DIGITAL TEENS 2 MODULE 5

To transform a number to a percentage:

GRADE

> Click cell B3 and type =B2/D2.

> Click cell C3 and type =C2/D2.

> Select the cells which contain the numbers you want to format, in this case B3 and C3. 3

> On the Home tab, in the Number group, click the Expand button. 4 > In the Format Cells window, click the Number tab. 5 > In the Category list, click Percentage.

> Type a number in the Decimal places text box, e.g. 2. 7 > Click OK.

> The numbers now appear as percentages.

You can also add percentage by clicking the Percent Style button in the Number group of the Home tab.

4 3 5

Calculate powers The Power function returns the result of a number raised to a given power. Type the following table as it is below: You can use the function POWER(x;y) instead of using the ^ symbol.

To calculate powers: > Click cell C2. > In the Formula Bar, type =A2^B2. > Press

Enter ď&#x20AC;¸

Computing and ICT . Sample Pages DIGITAL TEENS 2 MODULE 5

> Repeat the steps for cells C3 and C4. 3

2 3

GRADE

hands on! Your school did some research to ďŹ nd out which is the most interesting subject for students. In the questionnaire below you can see the votes for each subject. Now, using the Microsoft Excel program type the text and numbers as they are shown in the worksheet below. Calculate the total number of votes and the percentage of votes given to each subject. Fill the empty cells with the appropriate formula and format cells B4:F4 with a percentage symbol.

TASK 2

Functions As you know, Microsoft Excel can help you calculate and analyze numerical information with the help of a wide variety of functions.

Computing and ICT . Sample Pages DIGITAL TEENS 2 MODULE 5

Type the table:

5. Analyzing data / Functions

GRADE

COUNT The COUNT function is used to calculate the number of cells that contain numbers.

To add COUNT function: > Click the cell where you want to create the function, in this example, cell B7. 1

> In the Formulas tab, in the Function Library group, click Insert Function. 2

> On the Insert Function window, in the Or select a category list, click Statistical. 3 > Click COUNT

and click OK.

> In the Function Arguments window, in the Value1 box, type A1:B6. 6 It is the range of cells which you want to count. > Click OK.

Even if you donâ&#x20AC;&#x2122;t know the purpose of a function, you can always read the description. It explains in simple words what the selected function is going to calculate.

TODAY 2

To have the current date displayed on your worksheet, use the TODAY function. To use the TODAY function: > Click cell B8, the location where you want your results to be displayed. 1

> On the Formulas tab, in the Function Library group, click Date & Time. 2 > In the list, click TODAY.

Computing and ICT . Sample Pages DIGITAL TEENS 2 MODULE 5

> In the Functions Arguments window, click OK. 4

CONCATENATE To join cell contents, you can use the CONCATENATE function. To use the CONCATENATE function: > Click cell C2.

> On the Formulas tab, in the Function Library group, click Insert Function. 2

4 1 5

> In the Insert Function window, in the Or select a category list, click All. 3 > Click CONCATENATE. > Click OK.

> In the Function Arguments window, in Text1 box type A2, in Text2 type “ ” and in Text3 type B2, in Text4 type “m”. 6 > Click OK.

GRADE

> Use the Autoﬁll tool 8 to complete the other rows. 9

8 9

LEFT, RIGHT, MID

If you want to extract a part of a string (substring) use the LEFT, RIGHT and MID functions. To use the MID function: > Click cell B10.

> On the Formulas tab, in the Function Library group, click Text. 2 > In the list, click MID.

> In the Function Arguments window, in the Text box type A10. 4 It’s the cell from which you are going to extract characters.

4 5

Computing and ICT . Sample Pages DIGITAL TEENS 2 MODULE 5

> In the Start_num box, type 4. 5 It’s the position of the ﬁrst character you want to extract.

6 7

> In the Num_chars box, type 9. 6 You are specifying how many characters you want to extract. > Click OK.

Similarly, you can use LEFT and RIGHT functions to extract text from the left or right of a text respectively

5. Analyzing data / Functions

GRADE

SUBSTITUTE If you want to replace part of a text in a cell, use the SUBSTITUTE function. To use the SUBSTITUTE function:

> Click cell A13. > On the Formulas tab, in the Function Library group, click Text. 1 > In the list, click SUBSTITUTE.

> In the Function Arguments window, in the Text box, type A12. 3 It’s the cell that contains the part of the text which you are going to replace.

4 5

> In the Old_text, type spreadsheet. 4 This is the word you want to change. > In the New_text, type worksheet. This is the new word.

> Click OK. Your text has been replaced.

Multiple IF Now that you know how to use functions, let’s do something a little more complicated. Do you remember IF? Let’s see how you can use it to get more results. Type the following two tables in separate sheets as they are:

Let’s say you want to work with students’ grades.

To add this simple Multiple IF: > Click cell D3. > In the Formula bar type =IF(C3>=85,”A”,IF(C3>= 70,”B”,IF(C3>=55,”C”,” Work Harder”))) 1 > Press

Enter 

> Click the fill handle 3 and use the Autofill tool to fill the rest of the cells with data. 4

Microsoft Excel 2007 and later versions allow you up to 67 levels of Multiple IF.

Computing and ICT . Sample Pages DIGITAL TEENS 2 MODULE 5

If a student has a score of more than 90, then he/she gets an “A”, otherwise (= else if) if he/she has more than 70 then he/she will get a “B”, otherwise (= else if) if he/she has more than 60 then he will get a “C”. Below 60 (= else) the student has the indication that he/she has to “Work Harder.”

GRADE

Remember to close as many parentheses as you open.

3 2

To make multiple IF a little more complex than the previous one, let’s add a multiple IF on cell D3 of the sheet2 which will show the following: If the total score is equal to or greater than 18, then the team will take a gold medal, when (=else if) the score is more than 15, then the team will take a silver medal, when (=else if) the score is more than 10, then the team will take a bronze medal, and if it’s under 10 (=else), the team will not take a medal. To add Multiple IF: > Click cell D3 of sheet2. > In the Formula bar, type =IF((B3+C3)>=18,”gold”,(IF((B3+C3)>=15,”si lver”,IF((B3+C3)>=10,”bronze”,”no”)))). 1 > Press

Enter 

2 3

and use the Autoﬁll tool to ﬁll the rest of the cells.

Computing and ICT . Sample Pages DIGITAL TEENS 2 MODULE 5

> Click the ﬁll handle

5. Analyzing data / Functions

GRADE

3 2

4 Keep in mind that in the criteria boxes you can type a single word or a small phrase, or you can do complex calculations and even use other functions as well.

Finally, let’s add a multiple IF that makes use of the AVERAGE formula to cell E3 of sheet1, which will show the following: If the average grade is more than 80, then the student will get the description “excellent student”, when (=else if) the average grade is more than 60, then he/she will get the description “mediocre student”, otherwise (=else if) he/she will get the description “poor student”. To combine a multiple IF statement with the AVERAGE function: > Click cell E3. > In the Formula bar, type =IF(AVERAGE(B3:C3)>85,”excellent student”,(IF(AVERA GE(B3:C3)>60,”mediocre student”,”poor student”))). 1 > Press

Enter 

> Click the ﬁll handle

and use the Autoﬁll tool to ﬁll the rest of the cells.

Computing and ICT . Sample Pages DIGITAL TEENS 2 MODULE 5

GRADE

3 2

BE SAFE To protect your neck or back from injury, remember to sit properly when you work on your computer, especially when it’s for many hours. “Mens sana in corpore sano” as the ancient Roman and Greek philosophers said - a healthy mind in a healthy body.

IF and AND together IF the orals grades are greater than or equal to 55 AND the test grades are greater than or equal to 55, then the student will pass, otherwise, the student will fail. To combine a multiple IF with AND: > Click H3. > In the Formula bar, type =IF((AND(B3>=55,C3>=55)),”pass”, “fail”). > Press

Enter 

> Click the ﬁll handle

and use the Autoﬁll tool to ﬁll the rest of the cells.

Computing and ICT . Sample Pages DIGITAL TEENS 2 MODULE 5

5. Analyzing data / Functions

GRADE

3 2

SMART TIP Many countries use a comma as a decimal separator, while others use a dot. Find which decimal separator is used in your country here: http://en.wikipedia.org/wiki/Decimal_mark

COUNTIF If you have a table and you want to ﬁnd out how many cells have a value of more than 60, then you can use the COUNTIF function.

To use the COUNTIF function:

> Click the cell you want to add your function to, in this example, cell B9.

> On the Formulas tab in the Function Library group, click Insert Function. 1

> Click COUNTIF.

> In the Function Arguments window, in the Range box, type B3:C7 and in the Criteria, type >=60. 4 > Click OK.

Computing and ICT . Sample Pages DIGITAL TEENS 2 MODULE 5

> In the Or select a category list, click Statistical. 2

GRADE

hands on! Type the following table and ﬁll in the cells with the appropriate functions. In cell I3 use the AND function to check if cells C3 to E3 have values less than or equal to 75 and in cell H3 to ﬁnd out how many cells have a value of more than 65.

TASK 3

References As you know, a cell takes its name from the column letter and row number to which it belongs. A cell reference is the “address” of the cell and identiﬁes its location. When you want to copy the same formula to new cells, you can use the relative and absolute references. See how below!

Computing and ICT . Sample Pages DIGITAL TEENS 2 MODULE 5

Relative Reference

5. Analyzing data / References

GRADE

Relative Reference is the cell reference. When you copy a cell that has a formula, the formula changes automatically. The change depends on the relative position of rows and columns.

For example, type the contents of columns A and B below and in cell C2, type =A2*B2. If you copy the formula A2*B2 to cell C3, it will become A3*B3.

Absolute Reference Sometimes you want to keep a cell, a row or a column constant when copying a formula. You have to declare this when you create the formula by using the $ (dollar sign). This way, you create an absolute reference which doesn’t change when it’s copied or “ﬁlled”. $E$1 $E1 E$1

The cell doesn’t change when it is copied. Both the column and the row remain the same. The row changes when it is copied, but the column remains the same. The column changes when it is copied, but the row remains the same.

For example, type the contents of columns A and B below and in cell C2, type =$D$1*B2.

Notice that when the number of the row changes, the cell that has the $ sign stays the same.

If you fill the formula $D$1*B2 into column C, the formula will change to become $D$1*B3, $D$1*B4, etc.

SMART TIP An easy way to remember how to use the dollar sign is to think about how you want to use the Autofill tool. If you want to use it horizontally, then type the dollar sign in front of the letter (column). If you want to use it vertically, type it in front of the number (row).

Let’s see another example. Type the following table:

To create and copy a formula using references: > Click cell H4. > In the Formula bar, type the formula =G4*$G$1. 1 > Press

Enter 

> Click the cell H4 again and use the Autoﬁll tool. 3

Computing and ICT . Sample Pages DIGITAL TEENS 2 MODULE 5

You can use the Copy, Paste commands as well, instead of the Autoﬁll tool.

GRADE

To create and copy a formula using row absolute reference: > Type this table and click E2.

> In the Formula bar, type =D2*B$8. 2 > Press Enter  to calculate the formula. 3

> Click cell E2 and Autoﬁll cells E3:E6. 4

You can click the cell you want to lock and press F4 to apply an absolute reference.

3 4

To create and copy a formula using column absolute reference: > Type this table and click B5.

> In the Formula bar, type =B4*$I1. 2 > Press

Enter 

1 2

> Use the Autoﬁll tool to complete the table. 4

Computing and ICT . Sample Pages DIGITAL TEENS 2 MODULE 5

IF and references

5. Analyzing data / References

GRADE

It’s time to do something a little more difficult. You are going to combine the IF function with an absolute reference. Before you start, let’s find the Total Value, which is the Value minus the Discount and find the Average Value in cell F8.

IF the Total Value is more than the Average Value, then it is above average, if it is less (ELSE) then it is below average. To combine IF with references: > Click G2.

> On the Formulas tab, in the Function Library group, click Insert Function. 2 > In the Insert Function window, in the Or select a category list, click All. 3 > Click IF.

> In the Function Arguments window, type F2>$F$8 in the Logical_test box. 5

> In the Value_if_true, type “Above Average”. 6

> In the Value_if_false type “Below Average”. 7 > Click OK.

The functions are displayed in alphabetical order.

> Click cell G2 and drag the ﬁll handle to ﬁll cells G3:G6. 9

5 6 7 8

Common error messages Sometimes when you type a formula, you may make mistakes. Error messages appear on your worksheet.

The most common error messages are: ###### #DIV/0! #NAME?

This error message appears when you divide something by 0. You can correct it by changing the divisor in the function or formula so it is not zero or blank. This error message appears when you have typed a wrong formula and Microsoft Excel cannot recognize it. You can correct it by typing the formula’s correct name. In the example above, cell B7 displays this error. This error appears when a mathematical formula includes cells that contain text as well as numbers. You can correct it by removing references to cells containing text.

You can correct the mistake by clicking the button that appears next to the cell that displays the message and choosing Edit in Formula bar.

Computing and ICT . Sample Pages DIGITAL TEENS 2 MODULE 5

#VALUE!

This “message” appears when a column with numerical contents is not wide enough to display all of its content. You can correct it by increasing the width of the column to ﬁt everything correctly.

GRADE

hands on! Type the following table and ﬁll in the cells with the appropriate function. In cells 14:10, remember to use a function with an absolute reference.

TASK 4

Advanced charts Chart types

5. Analyzing data / Advanced charts

Computing and ICT . Sample Pages DIGITAL TEENS 2 MODULE 5

To make your data presentations more lively and interesting, you can use charts and graphs.

The Column/Bar Chart is used to illustrate comparisons between a series of data. In a column chart, categories appear horizontally (x-axis) and numeric values appear vertically (y-axis). The opposite happens in a bar chart which is one of the most commonly used chart types.

The Line Chart is used to display trends. It shows the changes in data over a period of time. Numeric values always appear vertically (y-axis) and time horizontally (x-axis). It is suitable for showing data for a large number of groups.

The Area Chart is like a Line Chart except that the area below the plotted line is filled in with color. It is used to display trends over time or some other category and it is suitable for showing data for a limited number of groups.

The Pie Chart is used to display only one series of data. It shows the relationship of the parts to the whole. You have to pay attention. It is suitable for showing data for one group.

The Scatter Chart is used to display the values of two series and to compare them over time. It is like a line graph, except that the plotted line shows data points. It is suitable for showing the relationship between two variables.

The Doughnut Chart is used to display data as doughnut slices and is similar to a Pie Chart.

GRADE

BE SAFE

Donâ&#x20AC;&#x2122;t forget to save your work frequently and always backup your files to another place!

To add a chart: > Type this

and select cells A2:C10.

> On the Insert tab, in the Charts group, click Column. 2

> In the list of column chart sub-types, click the one you like. 3

After you create a chart, you can modify it. For instance, you may want to change its titles or its type.

1 To move the chart: > Click the Chart.

> On the Design tab in the Location group, click Move Chart. 1 > You can move your chart to a new sheet or wherever you want. 2

GRADE

Use Object in to move your chart as an object to an existing sheet.

To change the Shape Fill of the chart: > Click the shape you want to make changes to. For example select â&#x20AC;&#x153;winsâ&#x20AC;?. 1

Computing and ICT . Sample Pages DIGITAL TEENS 2 MODULE 5

Modify chart

3 1

> On the Format tab, in the Shape Styles group, click Shape Fill. 2 > Click the color of your choice. 3

You can choose to have your chart on a new sheet. In that case your chart will take up the whole spreadsheet.

Use More Fill Colors... when you want to fill the shape with a color which is not available in the Theme Colors list.

Use Gradient when you want to fill the shape with a gradient color.

Use Picture when you want to fill the shape with a picture.

Use Texture when you want to use a texture fill.

To change the titles:

Use None if you donâ&#x20AC;&#x2122;t want a title.

5. Analyzing data / Advanced charts

Computing and ICT . Sample Pages DIGITAL TEENS 2 MODULE 5

> Click the Chart to select it. > On the Design tab, in the Chart Layouts group, click Add Chart Element. 1

Use Centered Overlay when you want to center the title over the chart, but donâ&#x20AC;&#x2122;t want to change the size.

> Click Chart Title and then select Centered Overlay. 2 > Double-click the Chart Title, delete the words and type Statistics. 3

Use More Title Options... when you want more options about filling, line style, etc.

> Click anywhere outside the chart title.

GRADE

To change the format of an axis: > On the Design tab in the Chart Layouts group, click Add Chart Element. 1

1 2

> In the Axis Title popout menu, click Primary Horizontal. 2 > Double-click Axis Title, delete the words and type Teams. 3 > Click anywhere outside the axis title.

Mini chart Sometimes you just want a graphical representation of your data inside a chart. To do this, you can use mini charts.

To add a mini chart: > Select the cells you want your mini chart to be displayed in. For example, select D3:D10. 1

> On the Insert tab, in the Sparklines group, click Line. 2 > In the Create Sparklines window, in the Data Range box, type B3:C10. 3 This contains the data you want to represent in a graph.

To modify a mini chart: > Select the cells D3:D10 where the mini chart is.

> On the Design tab, in the Style group, click Sparkline Color 2 and click the color you want.

Computing and ICT . Sample Pages DIGITAL TEENS 2 MODULE 5

> Click OK.

GRADE

1 3

You can also click Marker Color to color your markers.

SMART TIP Always double-check the formulas in your spreadsheet. A tiny mistake may cause a huge problem!

Conditional formatting When you want to change the way your cells look based on what they contain, you can apply conditional formatting. First, you specify certain conditions, and your cell appearance will change to meet these conditions. To apply Conditional Formatting:

> Select the cells which you want to apply conditional formatting to, for example B3 to C10. 1 > On the Home tab, in the Styles group, click Conditional Formatting.

5. Analyzing data / Advanced charts

Computing and ICT . Sample Pages DIGITAL TEENS 2 MODULE 5

> Click New Rule.

> You can select the criteria you want to use, for example click Format only cells that contain. 4 > Type 10 to 20.

> Click Format and format the cells accordingly. 6 > Click OK.

Use Format only cells that contain to create rules and format your cells based on these.

4 5

GRADE

hands on! Type the following table; add a pie and a column chart. Change the ďŹ ll colors and the axis names in the chart.

TASK 5

Import and export data A Comma-Separated Values (CSV) file is a simple file format that is widely used by scientists and businessmen. As its name suggests, the values in each row of data are separated by a comma or a tab. CSV files are used to transfer large amounts of data to and from different companies or applications. Sometimes, you will need to import data from a CSV file to Microsoft Excel. Let’s create a CSV file. Open your Notepad and type the following text. Computing and ICT . Sample Pages DIGITAL TEENS 2 MODULE 5

Save the ﬁle under the name contacts.csv To open a CSV ﬁle in Excel: > Click the File tab then click Open.

and

> Click Browse 3 and from the Open window select Text Files from the dropdown list . 4 > Select the CSV ﬁle you want 5 and click Open.

GRADE

Using the Open command this way the CSV ﬁle does not change its format.

If you want to store lots of information, you can convert your text to a table. To convert text to a table: > Select the cells you want to convert to a table.

> On the Insert tab, in the Tables group, click Table. 1 > Select cells A1 to D7 (the text you have just imported).

3 2

5. Analyzing data / Import and export data

Computing and ICT . Sample Pages DIGITAL TEENS 2 MODULE 5

> Click OK.

GRADE

To convert a table to text: > Click the table.

> On the Design tab, in the Tools group, click Convert to Range. 2 > Click Yes to conďŹ rm the conversion. 3

2 1

You can also import data from a CSV ﬁle into the existing or a new Excel worksheet. Unlike the previous method, this is helpful because it does not simply open CSV in Excel but data can be formatted and analyzed more easily. Import data from a TXT or CSV ﬁle:

Other than and commas, in a CSV ﬁle, columns may be separated by other characters such as “;”or “.” or a space.

> On the Data tab, in the Get & Transform Data group, click From Text/CSV. 1 > Locate and click contacts.csv.

> Click Import.

> Click Load.

to import a delimited ﬁle.

The contacts.csv window will appear.

Delimiters defines the character that separates values in your text file.

Computing and ICT . Sample Pages DIGITAL TEENS 2 MODULE 5

GRADE

When you import a csv file it is automatically coverted to a table.

SMART TIP You can also convert to range by rightclicking the table, and clicking Table.

Export data Sometimes you want to store the data that you have created with Microsoft Excel in a format that can be understood by other applications. To do this, you can export them to a CSV ﬁle. For example you have the spreadsheet below:

To export data from Microsoft Excel to a TXT or CSV ﬁle: > Click the File tab.

> Click Save As and then Browse. As window will appear.

The Save

> Choose the folder where you want your document to be saved. 3 > Type a name for your ﬁle in the File name box. 4

5. Analyzing data / Import and export data

Computing and ICT . Sample Pages DIGITAL TEENS 2 MODULE 5

> In the Save as type list, click CSV. > Click Save.

GRADE

2 4 6

CSV CSV files are simple but important. A CSV is a simple text file with no format. The data are stored as a sequence of characters. This way the file is relatively small in size, even though it can hold a large amount of data. The CSV format is widely supported by companies and consumers, because it helps them transfer large amounts of data from one program to another. Because it’s small in size and can be highly compressed through zip programs, you can transfer the data more easily over the Internet. You are going to came across CSV files quite a lot from now on. Especially, if you want to transfer data from databases to spreadsheet and vice versa.

Computing and ICT . Sample Pages DIGITAL TEENS 2 MODULE 5

GRADE

hands on! Open Notepad and type the following text. Save it as a CSV ﬁle and give it the name of your choice. Then import it into Microsoft Excel. Rank, Country, Total medals 1, USA, 104 2, China, 88 3, Great Britain, 65

TASK 6

Project

Computing and ICT . Sample Pages DIGITAL TEENS 2 MODULE 5

If you want to analyze some data, ﬁrst of all you need to gather it. Brainstorm a list of the ideas that you want to include in your analysis. Write the ideas down on a notepad and don’t forget to write down all the things that you want to display and compare.

Let’s analyze the carbon dioxide emissions in your country. Using the Internet try to cross-check all your information to make sure it is correct.

5. Analyzing data / Project

GRADE

When you ﬁnish collecting your data, open Microsoft Excel and type it in an appropriate way. Keep in mind that you should add headings or titles to your columns and rows in order to deﬁne what is shown in each cell.

After inserting your data, create the formulas that you need. Don’t forget that empty cells are ignored!

Computing and ICT . Sample Pages DIGITAL TEENS 2 MODULE 5

Next, you can illustrate your data with the help of graphs. Remember that you use graphs to make visual comparisons between one or more series of data points. In this way, you can present your data in a more informative way. You can add a chart title and axis title to make your graph more informative.

GRADE

Finally, print the graph and data table.

Form teams and analyze relevant data about the top ďŹ ve countries with the most medals in the Olympic Games in the last twenty years. Find information on the Internet. Donâ&#x20AC;&#x2122;t forget to illustrate the data with the help of a graph. Print the graph and the table and share them with your classmates.

Other platforms Apple Numbers for iOS

5. Analyzing data / Other platforms

Computing and ICT . Sample Pages DIGITAL TEENS 2 MODULE 5

Use Apple Numbers for advanced formatting. Use different chart types to illustrate your information. The chart types are similar in every spreadsheet program.

Sheet To Go for Google Android The functions that youâ&#x20AC;&#x2122;ve learned are similar in any spreadsheet program. Use Sheet To Go to edit text, calculate Average, even Sine and Cosine and other algebraic functions.

GRADE

LibreOffice Calc LibreOfďŹ ce Calc has all the tools that you need to make calculations and edit data. Because its environment is very similar to Microsoft Excel, it will be a piece of cake for you to use. Use all the familiar charts and functions.

Now you have learned how to: > work with powers and percentages.

> use advanced functions. > use a multiple IF.

Computing and ICT . Sample Pages DIGITAL TEENS 2 MODULE 5

> use relative and absolute references.

> understand and correct error messages.

> format diďŹ&#x20AC;erent types of charts. > create mini charts.

> apply conditional formatting to cells. > import and export data as a CSV ďŹ le.

GRADE

GLOSSARY absolute reference

conditional formatting

addition

COUNT

AND

COUNTIF

area chart

CSV

bar chart

delimiter

column chart

division

CONCATENATE

doughnut chart error message

export

multiple IF

scatter chart

formula

multiplication

sparkline

gradient

SUBSTITUTE

import

percentage

subtraction

LEFT

pie chart

TODAY

line chart

power

TXT

MID

relative reference

mini chart

RIGHT

COURSES FOR 21st CENTURY LEARNERS

Computing

ICT

and

ISBN: 978-960-698-497-6

C1912005042-1590

All rights reserved. No part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or by any means, electronic, mechanical, photocopying, recording or otherwise, without permission in writing from the publishers. Produced in the EU.

CYPRUS FRANCE GREECE POLAND UK USA e-mail: info@binarylogic.net | Internet: www.binarylogic.net

COURSES FOR 21st CENTURY LEARNERS

Computing

ICT

and

Digital Kids and Digital Teens are graded Computing and ICT series. These highly exciting series adopt an innovative project based approach to presenting and practicing ICT skills. Key features > Presentation of computing concepts in meaningful contexts and realistic situations. > Comprehensive coverage of international ICT curricula and exams. > Fun, real-world scenarios and carefully graded activities to motivate students. > Clear step-by-step walkthroughs of the operating system and software applications. > EďŹ&#x20AC;ective student and teacher support with digital resources on the seriesâ&#x20AC;&#x2122; website.

ISBN: 978-960-698-497-6

binarylogic.net