Embedded Files
Email address - SCHOOL USERNAME@bridgwatercollegeacademy.org
Email address - SCHOOL USERNAME@bridgwatercollegeacademy.org
Unit 1 - Computer Systems
Unit 1 - Computer Systems
What we are learning in this unit
What we are learning in this unit
1] Input Devices
2] Output devices
3] Storage Devices
4] Computer Components
5] Embedded Systems
End of Unit Assessment
Unit 2 - E-Safety
Unit 2 - E-Safety
What we are learning in this unit
What we are learning in this unit
1] Personal Information
2] How to create a strong password
3] Digital Footprint
End of Unit Assessment
Unit 3 - Spreadsheet
Unit 3 - Spreadsheet
What we are learning in this unit
What we are learning in this unit
1] Formatting a table of data
2] Using formulas (+ - / *)
3] Using functions (SUM / AVERAGE / MIN / MAX)
4] Creating basic charts to turn data into information
5] Creating a business model
End of Unit Assessment
1] L.O - To know how to format a table of data in a spreadsheet ... So that the data is easy to read and understand.
Skills covered - Add colour to cells / Add borders to cells / Resize cell widths / Merge and centre text / Format text to Bold / Format cells that contains money to currency
You will need this spreadsheet for this lesson
Watch this video to learn how to do the skills
EXTENSION - Watch this video to learn how to embed your formatting skills by creating a piece of pixel art.
2] L.O - To learn how to use the basic formulas ( + - / * ) ... so that you can use a spreadsheet to create financial models
Skills covered - How to create a formula / Use of addition / Use of subtraction / Use of division / Use of multiplication
You will need this spreadsheet for this lesson
Part 1 - Watch this video to learn how to do the skills
Spreadsheet Skills 3 Video Part 1
Part 2 - Watch this video to learn how to apply the basic formula skills into simple spreadsheet models
3] L.O - To learn how to use the basic functions ( SUM / AVERAGE / MIN / MAX ) ... so that you can use a spreadsheet to analyse data
Skills covered - How to create a function / Use of SUM / Use of AVERAGE / Use of MIN / Use of MAX
You will need this spreadsheet for this lesson
Part 1 - Watch this video to learn how to do the skills
4] L.O - To learn how to create and format simple graphs (Bar Chart / Pie Chart / Line Graph) ... so that you can turn DATA into INFORMATION
You will need this spreadsheet for this lesson
Part 1 - Watch this video to learn how to create and format a bar chart
Part 2 - Watch this video to learn how to create and format a pie chart
Part 3 - Watch this video to learn how to create and format a line graph
Extension - On a new spreadsheet sheet, can you create a bar chart or pie chart using your own data?
You could base the chart on ...
-how many hours you spend on computer games each day
-how often you eat vegetables (this will probably be none for some of you !!)
-what you spend your pocket money on each month.
-how much football players earn per week
Use your own creativity and if you wish, you could make up the data.
5] L.O - To create a 'How To' guide to teach Year 6 students on how to use the spreadsheet skills that you have learnt so far ... so that you are revising the skills in preparation for your end of topic assessment
Using MS PowerPoint you must include the following ...
Watch this video to see how you could present the 'How To Guide'
-How to use the ADD formula
-How to use the SUBTRACT formula
-How to use the MULTIPLY formula
-How to use the DIVIDE formula
-How to use the SUM function
-How to use the AVERAGE function
-How to use the MAX / MIN function
Make the PowerPoint engaging and simple for Year 6 students to use. You can use cartoon characters with speech bubbles if you wish. Try to include animations to make the PowerPoint more interesting.
Save the PowerPoint as How To Use Formulas and Functions inside your Year 7 Computer Science Folder
6] END OF TOPIC ASSESSMENT
Click this link to open the assessment
Enter your name clearly and select your class code. Ask your teacher if you are unsure.
Exam conditions ... so any talking or looking at other's answers = C3.
TAKE YOUR TIME ... There are some questions where you need to write your answer. Use proper sentences so that your teacher can understand what you have written.
If you have finished ...
-Silent Reading
-Doodling on a sheet of A4 Paper
Unit 4 - Creating algorithms and Programming
Unit 4 - Creating algorithms and Programming
What we are learning in this unit
What we are learning in this unit
1] What are algorithms - Using a flowchart to create an algorithm
2] Sequence / Selection / Iteration
3] Searching Algorithm
4] Sorting Algorithm
5] Currency Converter Program
6] Unit Converter Program
End of Unit Assessment
1] LO – To know what algorithms are and where we use them ......... LO – To know how to create an algorithm using a flowchart
Lesson 1 Powerpoint - Your teacher will go through this as a class
Creating algorithms - Open this to have a go at creating algorithms using a flowchart
Extension - Can you create your own algorithm ? e.g. Making a cup of tea ... Making a jam sandwich ... Converting £ to Euro
You will need to open a new blank PowerPoint.
To insert shapes, click INSERT ... SHAPES ... FLOWCHART Section ... alternatively you could draw it out on paper
2] LO – To know what variables are and how to use them ......... LO – To know how to create a python program from a flowchart
1] Create a new folder called Python ... make sure this folder is inside your Year 7 Computer Science folder
2] You will need to have Thonny open. [Click on the MAGNIFYING GLASS at the bottom of your screen ... then type Thonny ... then press Enter]
Thonny is a piece of software that allows you to create programs using the python programming language.
3] Watch this video to learn all about VARIABLES and why we use them.
4] Watch this video to create a simple program that works out the area of a rectangle
5] Watch this video to create a simple program that works out the perimeter of a triangle
Extension -
1] Can you create a program that converts cm to inches ?? Use the following algorithm to help you ... [Save this program as CM TO INCHES]
INPUT cm
inch = cm / 2.54
OUTPUT inch
2] Can you create a program that calculates the area of a circle ?? Use the following algorithm to help you ... [Save this program as AREA OF A CIRCLE]
INPUT radius
area = (radius * radius) * 3.14
OUTPUT area
3] Can you create a program that calculates the volume of a cube ?? Use this link to know the formula ... [Save this program as VOLUME OF A CUBE]
3] LO - To know how to use SELECTION when creating algorithms ... LO - To create a python program that includes selection (IF statement)
1] Open this file to learn how to use SELECTION in a flowchart
4] LO - To create an algorithm for a quiz program
1] Open this file to create your quiz algorithm
5] LO - To create a python program based on the quiz algorithm
1] Open the algorithm that you used in the previous lesson
2] Open Thonny (Thonny is used to create Python programs)
3] Create your python code in Thonny. You can open and view your previous programs to help you if you get stuck
SAVE THIS PROGRAM AS .... quiz program
Click here to view the cheat sheet
6] END OF TOPIC ASSESSMENT
Click here to access the online assessment
Unit 5 - Python Programming
Unit 5 - Python Programming
What we are learning in this unit
What we are learning in this unit
1] Sequence - Creating a Chatbot Program
2] Selection - Adding artificial intelligence to the Chatbot Program
3] Iteration - Count Controlled and Condition Controlled Loops
4] Creating a multiple choice quiz game
End of Unit Assessment
Unit 6 - Scratch Programming
Unit 6 - Scratch Programming
What we are learning in this unit
What we are learning in this unit
1] Sequence - Telling a joke / story
2] Selection - If statements
3] Iteration - Basic Loops
4] Variables
5] Maze Game
6] Racing Car Game
End of Unit Assessment
Page updated
Google Sites
Report abuse