Revision Cards

Starter

Go to Google Classroom HERE

Find our class

Main

Task 
Open the Revision Cards Assignment 

Use the links below to help you complete the cards for the following sections:

AQA Student Revision Guide  - HERE

BBC Bitesize Revision - HERE



Unit1 Computer Systems

• Introduction to Computer Systems - Click Here
• ICT and the Law - Click Here

Unit 2 - Hardware

• Input and Output Devices - Click Here
• Storage Devices - Click Here

Unit 3 - Data Representation

• Binary, Hexadecimal and Image Representation - Click Here

Unit 4 - Software

• Software development - Click Here

Unit 5 - Networks

• Networks - Click Here
• Connecting to the Internet - Click Here
• Cloud Computing - Click Here

Unit 6 - Databases

• Databases - Click Here

Unit 7 - Programming Concepts 

• Sequences and Flowcharts - Click Here

Unit 6 - Databases - Lesson 2/3 - Queries and SQL

Learning Objectives:

• Learn how to Query a databse
• Create simple SQL statements to extract, add and edit data

Download and Save the Data base HERE

Main

Worksheet 3 - HERE

Worksheet 4 - HERE

Unit 6 - Databases - Lesson 1

Learning Objectives:

• To discuss some of the many computer systems which may hold data about you or your family on a database
• To learn how this data is held so that information can be quickly retrieved
• To learn some database terms: record, field, table, primary key, index
• To set up a simple table in Access and enter some records

Main

Download and Save the SportsDay database HERE

Databases Worksheet 1

Exam Questions gone through in class:

Databases Homework 1

BBC Bitesize - Revise & Tests HERE

Unit 7 - Programming Concepts - L4 - Error Handling

Learning Objectives:

• Explain what is meant by an Integrated Development Environment (IDE)
• Describe and give examples of syntax, logic and runtime errors
• Describe common tools and facilities available in an IDE to help debug programs: watch, breakpoint, step
• Correct logic errors in a program

Main

Tasks

Worksheet - HERE

BBC Bitesize - HERE - add notes to your book

Test your knowledge - HERE

Textbook Ref:

• error handling 80

Revision - Computer Science Glossary

Make your very own Glossary of Computer Science terms, just like the one below.

Download your own file - HERE

Revision Cards

Starter

Go to Google Classroom HERE

Find our class - eg 11ACs1 or 11BCs1

Main

Task 
Open the Revision Cards Assignment 

Use the Revision Guide below to help you complete the cards:

AQA Student Revision Guide  - HERE

Unit 7 - Programming Concepts - L3 Data Types & Structures

Data types and Structures

Learning Objectives:

• Define the terms variable and constant
• Use and identify variables and constants in program code
• Identify and use the data types integer, real, Boolean, character and string
• Use one- and two-dimensional arrays
• Use text files to read and write data

Starter

Fill in the sheet - HERE

Main

Programming Worksheet 3 Data types and structures

Plenary

BBC Bitesize - HERE

Test your knowledge - HERE

Homework

Programming Homework 3 Data types and structures




Textbook Ref:

• constants 27, 31
• data structures 39–40
• data types 21, 22

CS Keywords Quiz

Download and save BOTH files below in to the same folder.

Run the python program to start the quiz.

Python File - HERE

Keywords .csv - HERE

Unit7 - Programming Concepts L2

Lesson Objectives

 - Understand and use sequence, selection and iteration in an algorithm
 - Use NOT, AND and OR when creating Boolean expressions

Starter

Think of some real life situations where you:

 SEQUENCE - to do things in a particular order

SELECTION - to do one thing rather than another

ITERATE - to continue to do something until a certain thing happens

Fill in the sheet HERE with your examples.

Controlled Assessment Tip:
Think of some examples of SEQUENCE, SELECTION and ITERATION that you have used in your Controlled Assessment Coursework.

Add a paragraph explaining how each of the above is used in your coursework for extra marks.

 

Main

RED TASK

Look at the presentation below and make notes in your book when you see the pencil!

AMBER TASK

Download, Save and fill in the worksheet HERE

GREEN TASK
See BBC Bitesize - HERE

Useful Prezi - HERE

Extension 
TEST

Plenary

Explain to a partner what you have learnt in today's lesson and what you would like to find out more about.

Homework
Fill in the Program Control Flow sheet  HERE

Exam Top Tips

Unit7 - Programming Concepts L1

Algorithms, flow diagrams and pseudocode

Learning Objectives:

Understand algorithms written using flow diagrams or pseudocode Correct or complete algorithms Produce algorithms using flow diagrams or pseudocode to solve problems

Programming L1 Algorithms, flow diagrams and pseudocode

Programming Worksheet 1 Algorithms flow diagrams and pseudocode

Programming Homework 1 Algorithms flow diagrams and pseudocode

Useful Websites

Teach ICT - Algorithms

BBC Bitesize - GCSE - Algorithms/Data Flow

ICT Workout - Sequences & Flowcharts 

Textbook Ref:

• algorithms 138–142
• flowcharts 55–56, 59–60

Controlled Assessment - Final Changes

You still have 2 weeks left to make any final changes to your Controlled Assessment coursework.

See the FULL MARK SCHEME HERE. Have a go at marking your own work.

You will need to plan your time carefully. 

Access the Planning Document HERE and Open/Save in your Google Drive. You will need to share, once complete.

Take some time to fill in the Planning Document, thinking carefully about what still needs doing and what time you have available after school.


IMPORTANT:
Once completed share the document with me and your new ICT teacher. (see me if you are unsure who that is)

Download the New BBC Bitesize App

Testing & Evaluating - due Fri 18th March

Lesson Objectives

 - under the requirements for Testing and Evaluating 
 - document Testing and Evaluation of program

Starter

Check your progress so far by viewing your Tracking Sheet 
11ACs1
11BCs1

Main

Red Task
Take a look at the Mark Scheme for Testing and Evaluating

See the FULL MARK SCHEME HERE

PLEASE print your completed Testing & Evaluating and hand in to Mrs Palmer 
(Rm 901) by Friday 18th March

Amber Task
Set up a section in your Word document with the heading Testing & Evaluating

What to include:

     1. A 'Testing Table'  to list ALL tests carried out on your program, with ACTIONS to be taken. 
         
See example:

     2. A 'Re- Testing Table'  to list ALL tests that had to carried out again due to error the first time around, with any further ACTIONS to be taken. 
         
See example:

Green Task
Add a section to Evaluate your program by comparing it to the User Needs/Criteria you stated in your Design Solution


REMEMBER: you gain marks for ANY tasks you manage to complete.

PLEASE don't worry if you don't manage to complete them all. You will STILL get marks.

Plenary

With your Python Buddy review your work again using the Mark Scheme above.

Homework

Review your work so far and complete any tasks outstanding, ready to hand in for marking on Fri 18th March (hard copy)

05 Programming Techniques (36 marks)

Lesson Objectives

 - document the Programming Techniques used 
 - understand how the techniques were used together to create a functioning program

Starter

Programming Techniques Matching Task

Main

Red Task
Take a look at the Mark Scheme for Programming Techniques

See the FULL MARK SCHEME HERE

Amber Task
Set up a Word document to include the following:

     1. A 'Table of Programming Techniques'  to list ALL functions, methods, lists and variables used in your program.

     2. List the techniques used in column ONE. In column TWO explain where and why each technique was used in your program - see below.

Green Task
Add a section  'Data Structures'  to list and explain all the variables you have set up and their purpose. What data do they hold and why were they needed?

Add a section  'Justification of Techniques Used' to go through in more detail WHY you have used the techniques you have.

Add a section  'Robustness & Efficiency' to go through how you have ensured the program works in ALL circumstances. Eg what happens if the user types a number instead of a letter.


REMEMBER: you gain marks for ANY tasks you manage to complete.

PLEASE don't worry if you don't manage to complete them all. You will STILL get marks.

Plenary

With your Python Buddy review your work again using the Mark Scheme above.

Game Tasks

Controlled Assessment Structure - DETAILED

How to layout your Controlled Assessment

Create a NEW WORD DOCUMENT

Save it in your CONTROLLED ASSESSMENT FOLDER  as:

SURNAME_FIRSTNAME_58243_CAND NO_TASK

Header and Footer with Information about you, the work and the School

Use Arial Font for all writing 

Fully Justify your text also 

and use 

Consolas Regular Font for all code in size 12

Further explanation of some of these sections can be seenhere

TITLE PAGE

CONTENTS PAGE

DESIGN OF SOLUTION (9 Marks)

What the Problem Involves (The problem in your own words from the paper)

Overview Plan (A numbered list of the problem and then a Flow Chart showing this list)

Predicting Future Needs (What do you think you might add to the solution in the future)

How to Solve this Problem (The tasks in order?  Is there any logical way?) 

Input/Output Storage Diagram (Where will you save and locate files and your program?)

Algorithms (as Text and Flowcharts)

Variables (What do you think you need?  Think about Naming Conventions)

Detailed Plan (From all the above what is your plan Using AQA Pseudocode)

SOLUTION DEVELOPMENT (9 Marks)

How my solution meets the User's Requirements (Show what you have planned will do what you have been asked)

Annotated Code (Show where your code attempts to solve the problem)

What the User Sees (Snips/Print Screens of the program)

Full Code Print Out (in Consolas Font)

PROGRAMMING TECHNIQUES (36 Marks)

Techniques used and how they work with each other

Processes Used 

Data Structures Used

Validation

TESTING AND EVALUATION (9 Marks)

Test Plan

Evidence of Test Plan  (Print Screens of your program running/What the user sees)

Test Results and Changes Made

Trace Table Testing

Evaluation Against Users Needs

How Well Does It Deliver What the User Wanted?

Suggested Improvements

If at any time you find problems with what you have already done don't delete what you have written but add an improved version e.g. flowchart v2 and add a note explain this in the testing section and by the improvement.

03 - Solution Development (9 marks)

Lesson Objectives

Use Python to read() the contents of a file


Task 1
Open a file on your drive. 
Controlled Assessment files have been emailed to you - check your mail.
NB. Make sure it is saved in the same location as your python file.

~~~Your Task~~~ 

Write a program that will open() and read() the contents of your file and display it in the screen to test it has loaded.

Task 2

As the scenario asks you to select random words from the file you may want to consider storing it as a list.

Knowing about indices in a list is very useful and if you use the correct conventions Python will instantly recognise your list as a list.

Task
Create a list to hold members of your family. Then use the print() function to print out their names as shown.

~~~Your Task~~~ 

1. Create a program that will prints out random members of your family, using a list as reference, using the random library and rand int. 

How could you print them in a grid?

Useful site for lists - HERE and for random  - HERE