Hero image

546Uploads

221k+Views

80k+Downloads

Database Queries and Excel filtering in KS3 Computing
studeappsstudeapps

Database Queries and Excel filtering in KS3 Computing

(0)
A set if questions that can be used to teach filtering in Excel, or querying in databases. A series of interesting activities for your students to teach them these fundamental concepts in computing. I used the file to teach SQL using Cute SQL (http://cutesql.software.informer.com/1.2/) before moving to Access. Instructions provided.
Computing Algorithms Artificial Intelligence, AI and Crowd Sourcing Lesson for KS3
studeappsstudeapps

Computing Algorithms Artificial Intelligence, AI and Crowd Sourcing Lesson for KS3

(0)
A single lesson to help students understand crowd sourcing. We are increasingly using artificial intelligence for simple tasks in the business world. Google use algorithms to digitize books. However there is something quite sinister in the way that Google are using the Crowd to work for them, often with the workers unaware that they are working for a large multinational firm. This lesson is fully resourced and has a complete teacher’s guide. (L2Answers.docx) There is a full lesson (L2AI2016edc.docx), and a shortened poster lesson (L2AI2016dc.docx)
Induction lesson for Computing Year 7
studeappsstudeapps

Induction lesson for Computing Year 7

(0)
Ever had the problem that students come into year 7 used to their home computers and how the systems worked at their last school? Perhaps you have set up the machines with a default password and need to get them to change that, but also remember that into the coming weeks and months? This lesson has been created to help you. WALT • Understand the computer room rules • Use an algorithm WILF • Access the school network • Access your user area • Present the classroom rules
Variables concept for computing (KS3 and KS4)
studeappsstudeapps

Variables concept for computing (KS3 and KS4)

(0)
A great plan for variables in computing. TESPlan.docx gives a lesson plan that guides you through the following: - VariablesTES is the main presentation to explain variables. - Data types variables introduces data types and has an exercise for students to complete (worksheet is VariablesDataTypes - Code Scramble has questions for off computer work related to variables - VariablesProgrammingTask has a set of questions (not programming language dependent) for students to complete This lesson is not dependent on a particular programming language. It is a set of activities and a presentation to help students with this important concept in computing.
Passwords poster
studeappsstudeapps

Passwords poster

(0)
Passwords poster. Useful for a display telling students how their passwords can be obtained.
Generalisation lesson Computing (late KS3 or GCSE)
studeappsstudeapps

Generalisation lesson Computing (late KS3 or GCSE)

(0)
Full lesson to explain generalisation to your students Learning objectives: To understand that patterns are important using algorithms To know that generalisation helps us to create programs This is taught by tic-tac-toe and counting rectangles. An enjoyable lesson for the students.
Python  Pair Programming activity for AQA GCSE Computer Science
studeappsstudeapps

Python Pair Programming activity for AQA GCSE Computer Science

(0)
Python Pair Programming activity for AQA GCSE Computer Science Based around the game "rock paper scissors", and students develop solutions in pairs, share their results and criteria against the exam board requirements. This lesson can also be run with a high ability Key stage 3 group.
eSafety discussion task
studeappsstudeapps

eSafety discussion task

(0)
eSafety discussion task. Each comment has a surprising addition. To use this use envelopes with a clear window (as in the images Envelopes.jpg and Envelopessecond.jpg show). Students then follow the following instructions. We are going to order the questions in the envelopes from most to least important. Leave them in their envelopes for now 1. Do you think the question is relevant (in turn) 2. Why do you think that your question might be regarded as important (in turn) 3. Order 4. Remove from envelopes to see additional information. Does this change your mind?
Variables theory for GCSE Computer Science
studeappsstudeapps

Variables theory for GCSE Computer Science

(0)
Teach students about variables. They study assignments and make sure that the variables are printed to the screen, using a variety of paradigms. This resource is not based on any particular programming language, so is applicable for any particular language you choose.