S2 - Introduction - Lesson 1

S2 ICT

Introduction

Poll

Which was your favourite ICT topic last year?

• Word Processing

• Excel (Spreadsheets)

• Pivot

• PowerPoint Presentation

• Scratch Programming

​S2 ICT Course Topics

• ​Excel - Spreadsheets

• ​Access - Database

• ​Word Part 2

• ​Business Management

• ​Web Design

• ​Email

• ​Scratch

​

​​During second year we will continue to build on your ICT skills and use new software...

What is the difference between software and hardware?

Software is a set of instructions, data or programs used to operate computers and carry out specific tasks. We can't touch software.

​

​WHEREAS

​

​Hardware is the physical components that a computer system requires to function. We can touch hardware.

Multiple Choice

Is a KEYBOARD hardware or software?

• Software

• Hardware

Multiple Choice

Is EXCEL hardware or software?

• Software

• Hardware

Multiple Choice

Is a MONITOR hardware or software?

• Software

• Hardware

Multiple Choice

Is a MOUSE hardware or software?

• Software

• Hardware

Multiple Choice

Is GOOGLE CHROME hardware or software?

• Software

• Hardware

​Today we are using... Excel

But first we are going to do some quick revision to see what you can remember about spreadsheets

Multiple Choice

What is highlighted on the spreadsheet?

• A Row

• A Column

• A Cell

Multiple Choice

What is highlighted on the spreadsheet?

• A Row

• A Column

• A Cell

Multiple Choice

What is highlighted on the spreadsheet?

• A Row

• A Column

• A Cell

Multiple Choice

We can name a cell

• True

• False

​How we name a cell...

​By using the letter at the top of the column and the number of the row.

​

​For example...

​

​The cell that contains Sc-Fi would be B9

Fill in the Blank

Name the cell that contains "50 First Dates"

Fill in the Blank

Name the cell that contains "2014"

Fill in the Blank

Name the cell that contains "Comedy"

Fill in the Blank

Name the cell that contains "Year Released"

Poll

Have you inserted a chart onto a Spreadsheet before?

• Yes

• No

• Not sure

​Activity 1 - Pixel Art

• Using Excel you have to create a Pixel Art.

• Before we start to create our pixel art we will need to change the width of the columns.​

• ​Open a new Excel workbook and wait for instruction.

Activity 2 - ​Battle Ships

​You are going to create a game using Excel. The aim of the game is to sink your appointment ships.

​

​You will have to guess the cells that your appointments ships are in. Guess all of the correct cells and you will sink their ship!

​Your Spreadsheet will look something like this...

​Instructions and rules can be found in....

​Subjects => ICT => S2ICT => 1.Excel => 7.Battle Ships

Open Ended

Did you enjoy using the Quizizz lesson today?

If so what did you like about it?

Or what would you improve?