Can You Compute?
  • HOME
    • Yr 6
    • Revision
    • Class of 2017
    • COVER LESSON FB
    • Yr 10: Program of Study 2016
    • Yr 11:Coming soon
    • Student Showcase
  • KS3
    • Term 6: Databases
    • Term 5 Scratch
    • Term 4 Websites
    • Term 3 Spreadsheets
    • Term 2: Binary & Algorithms
    • Term 1: Basics and Hardware
  • J277/01 NEW
    • EPIC FAILS
    • Intro Lessons
    • 1.1 System Architecture >
      • 1.1.1: The CPU
      • 1.1.1: Parts of the CPU
      • 1.1.2: The CPU in action
      • CPU Recap Lesson
      • Little Man Computer
      • 1.1.3: Embedded Systems
      • RISC & CISC
      • End of Unit Exam
    • 1.2 Memory and Storage >
      • 1.2.1: Primary Storage (Memory)
      • Intro to Units of Memory
      • 1.2.2 Secondary Storage
      • How stuff works
    • 1.2.3 Units & Data Capacity
    • 1.2.4 Data Storage >
      • 1.2.4 Binary Conversion
      • 1.2.4 Binary Addition
      • L4: Hexadecimal
      • L5: Recap
      • L6: Characters
      • L7: Images
      • L8: SenseHAT images
      • L9: Sound & Sampling
      • L10: Code Sound
      • L11: Compression Part 1
      • L12: Compression Part 2 >
        • Compression
      • What do you know?
  • J276/02 old
    • Unit 2 Overview
    • 2.1 Algorithms >
      • L1: Intro to Algorithms
      • L2: The Knight's Tour
      • L3: Bresenham
      • L4: Searching Algorithms
      • L5: Bubble Sort
      • L6: Insertion Sort
      • L7: Merge
      • L8: Sorting Recap
      • L9: Creating Algorithms
      • L10: Pseudocode
      • L11: Interpreting Algorithms
      • L12: End of Unit Test
    • 2.2 Programming Techniques >
      • Coding Intro
      • L1: Programming Concepts
      • L2: Sequence, Selection & Iteration
      • L3: SSI Practice
      • L4: String Manipulation
      • L5: Secret Codes
      • L6: File Handling
      • L7: Use of records to store data
      • L8: SQL
      • L9: SQL Python
      • L10 ,11, 12: Arrays
      • L13: Functions
      • L14: Data Types
      • L15: Casting
      • L16 -17: Test and Code
    • 2.3 Robust Programs >
      • L1 : Defensive Design
      • L2 : Testing Programs
    • 2.4 Computational Logic >
      • L1: Comp. Logic 1
      • L2: Comp. Logic 2
      • L3: Operators (Python)
    • 2.5 Translators & Language >
      • L1: Types of Languages
      • L2: Translators
  • Yr 9
    • Year End Examination
    • iMedia 5: Comics
    • iMedia 4: School Brochure
    • iMedia 3: Presentations
    • iMedia 2: Review and Mail Merge
    • iMedia 1: IT Letter Writing
    • L10: Intro to iMedia
    • L9 Building a Computer
    • L8: Buying a House
    • L7: Logic Gates
    • L6: Binary
    • L5: CS Alan Turing
    • L4: Spreadsheets
    • L3: JS in an Hour!
    • L2: Intro to Coding
    • L1: CS Compression
  • Py
    • Coding Concepts
    • Writing your first Program
    • Python Pages
    • Python Playground
    • Strings
    • Python Operators
    • Functions
    • Conditions
    • Try and Except
    • Break and Continue
    • Odd codes
  • Py +
    • Looping
    • Why does my code not work?
    • Errors
    • Validation
    • Lists
    • Lists again
    • Looking for data in String
    • Writing to Files
    • Read, Write & Sorting Data
  • CODING
    • Magic Python
    • Alan Turing
    • Brian the Turtle
    • Grade Calculator
    • Nested IF Hotels
    • Vending Machine
    • A Looping Menu
    • For
    • Christmas Coding
    • JS in an Hour!
    • CSS + HTML
    • Medical Claims
    • Hour of Code 2015
  • Contact
    • Dictionaries - coming soon
    • L2:
  • Squid Game
  • Reflectico

half Term 6
​DATABASES

Lesson 1: What is a Database?


Starter: Use Google to find out what a Database is, find 15 examples.
Discuss with another student what you found and and also why an electronic Database is useful.

The school uses a database to store all your data in a logical order.  Each one of you in the class will have a student record which contains all of your information.  Can you think of other business and organisations that will have a database?  

The Police use databases to solve crimes, just like the famous and awesome Sherlock.  You are going to use a database to solve 10 crimes, click the link below, 

The game is on......

Plenary:
  • Make a list of the new skills you have learnt, discuss with another student how you might use them in your own games and programs.
  • Make a rap about Databases, perform it next lesson.
​

Lesson 1a: Database Theory 


Starter:
Play this game
or

Load up Yell.com and find the answers to the phone number and addresses for the businesses below:
  1. Enterprise Car Hire Durham City 
  2. Evans Halshaw (Renault) Durham City 
  3. Theatre Royal Newcastle upon Tyne 

This lesson looks at the structure and features of a database, Complete the first worksheet and share and mark with another student.  Task 2 develops your understanding further of what a database is.  DB uses a lot of different data types, for example, text.  Can you think of some more? Complete task sheet three. As a bonus, try finding out what the terms in task 4 mean, this is a challenge, good luck.  Don't forget to share your findings with others. 
Who uses databases?
File Size: 31 kb
File Type: doc
Download File

Task 2
File Size: 35 kb
File Type: doc
Download File

3_datatypes.doc
File Size: 34 kb
File Type: doc
Download File

4_common_database_terms.doc
File Size: 37 kb
File Type: doc
Download File

Lesson 2:_ Queries

​


Starter: Click the starter link and play this Database game for 5 minutes, Share with another student what you learnt

In this lesson you will learn about Queries, look this up.  It is like a question, a way of filtering out unwanted data to find the exact pieces you need.  For example looking for a student's phone number to call home about their missing HW!

Look at the lesson notes which the teacher will talk through, you are going to solve a case using the clues you are given to filter the data and create a query.  You will also need to download the suspects database.  Your teacher will walk you through case one.
Suspects
File Size: 2149 kb
File Type: pptx
Download File

suspects.accdb
File Size: 524 kb
File Type: accdb
Download File

Now that you have the hang of it create your own cases using the template below.  Share these with other students and challenge them to solve the case, can they?
make_your_own.pptx
File Size: 1540 kb
File Type: pptx
Download File


​Lesson 3: Queries part 2


Starter: watch the Civil War trailer.  You are a film director and looking for superheroes for the new and up and coming sequel.  Download and save the Database and cast requirements list.  
  1. Add five new heroes / villains to the database
  2. Use your knowledge of queries to find the 'hero' you need.  Complete your answer on the sheet.
civil_war_db.mdb
File Size: 819 kb
File Type: mdb
Download File

resource_2.doc
File Size: 39 kb
File Type: doc
Download File

Extention task
File Size: 29 kb
File Type: doc
Download File

Lesson 4: Top Trumps Part 1


Lesson Starter - Click here and play the game for 10 minutes.

​Do you remember the game of Top Trumps?  Some of you may have brought your own in today.  Play it to see how the game works.

In this lesson you are going to create your own version of top trumps using a database.  This requires two parts.  This first is to set up a table, store the details of all the cards and then create a Form to display each card.  Your teacher may demonstrate how to get started but you can use the guides below to help you out, if in doubt as another student.
Top Trumps
File Size: 1087 kb
File Type: pptx
Download File

Top Trumps Instructions
File Size: 1657 kb
File Type: docx
Download File

Homework - complete this worksheet
​

Lesson 5: Top Trumps Part 2


In this lesson you will set up the TT game

Queries
The Games

End of Year Test:


This lesson you will complete the end of year test.  This covers all the content from the year and is used to measure how much you have learnt and progressed.
  1. Download the file below an answer the questions.
  2. Your teacher will enter the password to 'self mark' the questions.
  3. Hand in the final score to your teacher.
  4. Check sheet 2 to see how well you did and areas for improvements.
Year 8 EOY test
File Size: 608 kb
File Type: xlsm
Download File

Powered by Create your own unique website with customizable templates.
  • HOME
    • Yr 6
    • Revision
    • Class of 2017
    • COVER LESSON FB
    • Yr 10: Program of Study 2016
    • Yr 11:Coming soon
    • Student Showcase
  • KS3
    • Term 6: Databases
    • Term 5 Scratch
    • Term 4 Websites
    • Term 3 Spreadsheets
    • Term 2: Binary & Algorithms
    • Term 1: Basics and Hardware
  • J277/01 NEW
    • EPIC FAILS
    • Intro Lessons
    • 1.1 System Architecture >
      • 1.1.1: The CPU
      • 1.1.1: Parts of the CPU
      • 1.1.2: The CPU in action
      • CPU Recap Lesson
      • Little Man Computer
      • 1.1.3: Embedded Systems
      • RISC & CISC
      • End of Unit Exam
    • 1.2 Memory and Storage >
      • 1.2.1: Primary Storage (Memory)
      • Intro to Units of Memory
      • 1.2.2 Secondary Storage
      • How stuff works
    • 1.2.3 Units & Data Capacity
    • 1.2.4 Data Storage >
      • 1.2.4 Binary Conversion
      • 1.2.4 Binary Addition
      • L4: Hexadecimal
      • L5: Recap
      • L6: Characters
      • L7: Images
      • L8: SenseHAT images
      • L9: Sound & Sampling
      • L10: Code Sound
      • L11: Compression Part 1
      • L12: Compression Part 2 >
        • Compression
      • What do you know?
  • J276/02 old
    • Unit 2 Overview
    • 2.1 Algorithms >
      • L1: Intro to Algorithms
      • L2: The Knight's Tour
      • L3: Bresenham
      • L4: Searching Algorithms
      • L5: Bubble Sort
      • L6: Insertion Sort
      • L7: Merge
      • L8: Sorting Recap
      • L9: Creating Algorithms
      • L10: Pseudocode
      • L11: Interpreting Algorithms
      • L12: End of Unit Test
    • 2.2 Programming Techniques >
      • Coding Intro
      • L1: Programming Concepts
      • L2: Sequence, Selection & Iteration
      • L3: SSI Practice
      • L4: String Manipulation
      • L5: Secret Codes
      • L6: File Handling
      • L7: Use of records to store data
      • L8: SQL
      • L9: SQL Python
      • L10 ,11, 12: Arrays
      • L13: Functions
      • L14: Data Types
      • L15: Casting
      • L16 -17: Test and Code
    • 2.3 Robust Programs >
      • L1 : Defensive Design
      • L2 : Testing Programs
    • 2.4 Computational Logic >
      • L1: Comp. Logic 1
      • L2: Comp. Logic 2
      • L3: Operators (Python)
    • 2.5 Translators & Language >
      • L1: Types of Languages
      • L2: Translators
  • Yr 9
    • Year End Examination
    • iMedia 5: Comics
    • iMedia 4: School Brochure
    • iMedia 3: Presentations
    • iMedia 2: Review and Mail Merge
    • iMedia 1: IT Letter Writing
    • L10: Intro to iMedia
    • L9 Building a Computer
    • L8: Buying a House
    • L7: Logic Gates
    • L6: Binary
    • L5: CS Alan Turing
    • L4: Spreadsheets
    • L3: JS in an Hour!
    • L2: Intro to Coding
    • L1: CS Compression
  • Py
    • Coding Concepts
    • Writing your first Program
    • Python Pages
    • Python Playground
    • Strings
    • Python Operators
    • Functions
    • Conditions
    • Try and Except
    • Break and Continue
    • Odd codes
  • Py +
    • Looping
    • Why does my code not work?
    • Errors
    • Validation
    • Lists
    • Lists again
    • Looking for data in String
    • Writing to Files
    • Read, Write & Sorting Data
  • CODING
    • Magic Python
    • Alan Turing
    • Brian the Turtle
    • Grade Calculator
    • Nested IF Hotels
    • Vending Machine
    • A Looping Menu
    • For
    • Christmas Coding
    • JS in an Hour!
    • CSS + HTML
    • Medical Claims
    • Hour of Code 2015
  • Contact
    • Dictionaries - coming soon
    • L2:
  • Squid Game
  • Reflectico