Hero image

LJ Create STEM Shop

Average Rating4.02
(based on 96 reviews)

We provide a range of free, and low-cost STEM resources for schools and further education. Our resources include theory presentations, activity sheets, information fact files, and informative posters for your classroom.

198Uploads

227k+Views

65k+Downloads

We provide a range of free, and low-cost STEM resources for schools and further education. Our resources include theory presentations, activity sheets, information fact files, and informative posters for your classroom.
Spreadsheets - Sorting and Filtering
ljcreateljcreate

Spreadsheets - Sorting and Filtering

(2)
A presentation suitable for KS3 looking at sorting and filtering in spreadsheets. Presentation includes multi-choice questions to engage students and get them thinking about the subject throughout the presentation. Learning Objective(s): Identify how sorting and filtering can be used to find data in spreadsheets. Main Skills: Interpret written text and diagrams. Duration: Approximately 30 mins 18 slides covering: • Sorting • Filtering
Spreadsheets - Working with Graphs
ljcreateljcreate

Spreadsheets - Working with Graphs

(0)
A presentation suitable for KS3 looking at working with graphs in spreadsheets. Presentation includes multi-choice questions to engage students and get them thinking about the subject throughout the presentation. Learning Objective(s): Identify how to create a line graph from data in a spreadsheet. Main Skills: Interpret written text and diagrams. Duration: Approximately 30 mins 18 slides covering: • Axes • Data • Titles and Units • Creating a Line Graph • Formatting a Line Graph • Printing a Line Graph
Spreadsheets - Formatting Numbers
ljcreateljcreate

Spreadsheets - Formatting Numbers

(0)
A presentation suitable for KS3 looking at formatting numbers in spreadsheets. Presentation includes multi-choice questions to engage students and get them thinking about the subject throughout the presentation. Learning Objective(s): Identify how to change the appearance of numbers in spreadsheets. Main Skills: Interpret written text and diagrams. Duration: Approximately 30 mins 16 slides covering: • Formatting Numbers • Decimal Places • Percentages • Formatting Dates • Entering Numbers • Entering Other Data
Spreadsheets - Working with Formulae
ljcreateljcreate

Spreadsheets - Working with Formulae

(0)
A presentation suitable for KS3 looking at working with formulae in spreadsheets. Presentation includes multi-choice questions to engage students and get them thinking about the subject throughout the presentation. Learning Objective(s): Identify how to use formulae in spreadsheets. Main Skills: Interpret written text and diagrams. Duration: Approximately 30 mins 18 slides covering: • Formula • Referencing Cells • Useful Formula • Date and Time • Copying Formulae • Errors
Spreadsheets - Working with Rows and Columns
ljcreateljcreate

Spreadsheets - Working with Rows and Columns

(0)
A presentation suitable for KS3 looking at working with rows and columns in spreadsheets. Presentation includes multi-choice questions to engage students and get them thinking about the subject throughout the presentation. Learning Objective(s): Identify how to work with rows and columns in a spreadsheet. Main Skills: Interpret written text and diagrams. Duration: Approximately 30 mins 15 slides covering: • Rows and Columns • Selecting Columns • Selecting Rows • Column Width • Row Height • Copying and Pasting Columns • Copying and Pasting Rows • Inserting New Columns • Deleting a Column or Row
Spreadsheets - Working with Text
ljcreateljcreate

Spreadsheets - Working with Text

(0)
A presentation suitable for KS3 looking at working with text in spreadsheets. Presentation includes multi-choice questions to engage students and get them thinking about the subject throughout the presentation. Learning Objective(s): Identify how to change the appearance of data in a spreadsheet. Main Skills: Interpret written text and diagrams. Duration: Approximately 30 mins 18 slides covering: • Data • Formatting Text • Selecting Text • Text Options • Changing Colour • Changing the Alignment of Text • Wrapping Text • Merging Cells • Formatting Text
Spreadsheets - Working with Cells
ljcreateljcreate

Spreadsheets - Working with Cells

(0)
A presentation suitable for KS3 looking at working with cells in spreadsheets. Presentation includes multi-choice questions to engage students and get them thinking about the subject throughout the presentation. Learning Objective(s): Identify how to work with data in cells of spreadsheets. Main Skills: Interpret written text and diagrams. Duration: Approximately 30 mins 16 slides covering: • Cells • Selecting Cells • Editing a Cell • Copying and Pasting Cells • Cell References • Moving Cell Data • Clearing Cells
Spreadsheets - Introduction to Spreadsheets
ljcreateljcreate

Spreadsheets - Introduction to Spreadsheets

(0)
A presentation providing an introduction to using spreadsheets, suitable for KS3. Presentation includes multi-choice questions to engage students and get them thinking about the subject throughout the presentation. Learning Objective(s): Identify how to load a spreadsheet program and open files. Main Skills: Interpret written text and diagrams. Duration: Approximately 30 mins 15 slides covering: • The Spreadsheet • Using a Spreadsheet • Loading a File • Editing a Spreadsheet • Saving a Spreadsheet • Using Help • Printing a Spreadsheet
Computer Science - Operators and Control Structures
ljcreateljcreate

Computer Science - Operators and Control Structures

(0)
A presentation most suitable for KS4 looking at computer science operators and control structures. Presentation includes multi-choice questions to engage students and get them thinking about the subject throughout the presentation. Learning Objective(s): Explore operators and control structures used in computer programming. Main Skills: Interpret written text and diagrams. Duration: Approximately 30 mins 21 slides covering: • Mathematical Operators • Comparison Operators • Logic Operators • Control Structures • Sequences • Selection • Iteration • Subprograms
Computer Science - Inputs and Outputs
ljcreateljcreate

Computer Science - Inputs and Outputs

(0)
A presentation most suitable for KS4 looking at computer science inputs and outputs. Presentation includes multi-choice questions to engage students and get them thinking about the subject throughout the presentation. Learning Objective(s): Investigate inputs and outputs of computer systems. Main Skills: Interpret written text and diagrams. Duration: Approximately 30 mins 21 slides covering: • Input - Process - Output • Inputs • Outputs • Sensors • Analogue Sensors • Digital Sensors • Analogue to Digital Conversion • Motors • Motor Control • Open Loop Systems • Servomotors • Closed Loop Systems
Computer Science - Documentation and Testing
ljcreateljcreate

Computer Science - Documentation and Testing

(0)
A presentation most suitable for KS4 dealing with computer science documentation and testing. Presentation includes multi-choice questions to engage students and get them thinking about the subject throughout the presentation. Learning Objective(s): Explore how documentation and testing are an important part of developing computer programs. Main Skills: Interpret written text and diagrams. Duration: Approximately 30 mins 21 slides covering: • Software Development Lifecycle • Specification Requirements • Design • Implementation • Testing • Errors • Syntax • Test Plan • Test Data • Testing • Maintenance and Evolution
Computer Science - Data Constants and Variables
ljcreateljcreate

Computer Science - Data Constants and Variables

(0)
A presentation most suitable for KS4 looking at data constants and variables. Presentation includes multi-choice questions to engage students and get them thinking about the subject throughout the presentation. Learning Objective(s): Recognise data types used in computer science. Main Skills: Interpret written text and diagrams. Duration: Approximately 30 mins 24 slides covering: • Data Verses Information • Variables • Constants • Data Types • Integer • Real • Character • String • Boolean • Arrays
Computer Science - Computing Concepts
ljcreateljcreate

Computer Science - Computing Concepts

(0)
A presentation most suitable for KS4 looking at computing concepts. Presentation includes multi-choice questions to engage students and get them thinking about the subject throughout the presentation. Learning Objective(s): Explore basic computer science concepts including applications, processes and languages. Main Skills: Interpret written text and diagrams. Duration: Approximately 30 mins 25 slides covering: • Computers • Input - Process - Output • Hardware • Software • Programming • Machine Language • Assembly Language • Programming Languages • High Level Languages
Computer Science - Algorithms and Problem Solving
ljcreateljcreate

Computer Science - Algorithms and Problem Solving

(3)
A presentation most suitable for KS4 looking at algorithms and problem solving. Presentation includes multi-choice questions to engage students and get them thinking about the subject throughout the presentation. Learning Objective(s): Explore program design methods used to solve problems. Main Skills: Interpret written text and diagrams. Duration: Approximately 30 mins 23 slides covering: • Problem Solving • Specification Requirements • Analysis and Design • Algorithms • Algorithms and Flowcharts • Pseudocode
Sugar in Food
ljcreateljcreate

Sugar in Food

(0)
A presentation most suitable for KS5 looking at sugar in food. Presentation includes multi-choice questions to engage students and get them thinking about the subject throughout the presentation. Learning Objective(s): Identify the structure and properties of sugars. Investigate methods that are commonly used to test foods for sugar. Main Skills: Interpret written text and diagrams. Duration: Approximately 45 mins 42 slides covering: • Sugars • Regulating Foods • Sugar Consumption and Health • Diabetes • Added Sugar • Checking Food Labels • Naming Sugars • Glucose • Sucrose • The Benedict’s Test for Sugar • Testing for Reducing Sugars • Testing Foods for Reducing Sugars • Testing Foods for Non-Reducing Sugars • Positive and Negative Results • What can go Wrong?
Starch in Food
ljcreateljcreate

Starch in Food

(0)
A presentation most suitable for KS5 looking at starch in food. Presentation includes multi-choice questions to engage students and get them thinking about the subject throughout the presentation. Learning Objective(s): Explore the structure and properties of starch. Explore the iodine test for starch. Main Skills: Interpret written text and diagrams. Duration: Approximately 30 mins 27 slides covering: • What is Starch? • Glucose in Starch • Starch in Plants • Starch as a Food Source • Modified Starch • The Iodine Starch Test • What can go Wrong? • Regulating Foods
Protein in Food
ljcreateljcreate

Protein in Food

(0)
A presentation most suitable for KS5 looking at protein in food. Presentation includes multi-choice questions to engage students and get them thinking about the subject throughout the presentation. Learning Objective(s): Explore the structure and properties of protein. Investigate a test for protein. Main Skills: Interpret written text and diagrams. Duration: Approximately 45 mins 40 slides covering: • What is Protein? • Amino Acids • Peptide Bonds • Polypeptides and Proteins • Protein Structure • Protein Properties • Protein Classification • Importance of Protein in Food • Sources of Protein • Testing Foods: Biuret Test • Positive and Negative Results • What can go Wrong • Regulating Foods • Allergy Information
Human Digestive System
ljcreateljcreate

Human Digestive System

(0)
A presentation most suitable for KS5 looking at the human digestive system. Presentation includes multi-choice questions to engage students and get them thinking about the subject throughout the presentation. Learning Objective(s): Explore the structure of the human digestive system. Explore the function of components of the human digestive system. Main Skills: Interpret written text and diagrams. Duration: Approximately 45 mins 42 slides covering: • Holozoic Nutrition • GI Tract • Mastication • Swallowing • The Stomach • Duodenum • The Liver • Pancreas • Small Intestine • Carbohydrate Digestion • How Enzymes Work • Digestion in the Small Intestine • Secretion Control • Large Intestine
Fat in Food
ljcreateljcreate

Fat in Food

(0)
A presentation most suitable for KS5 looking at fat in food. Presentation includes multi-choice questions to engage students and get them thinking about the subject throughout the presentation. Learning Objective(s): Recognise reasons for testing foods for fats and oils. Investigate two methods commonly used for testing foods for fats and oils. Explore how fat and oil food tests work. Main Skills: Interpret written text and diagrams. Duration: Approximately 30 mins 29 slides covering: • Lipids • Grease Spot Test • Distinguishing Lipids from Other Liquids • Water Spots • The Emulsion Test • Positive and Negative Results • Regulating Foods • The Food Industry
Diet (KS4)
ljcreateljcreate

Diet (KS4)

(0)
A presentation most suitable for KS4 looking at diet. Presentation includes multi-choice questions to engage students and get them thinking about the subject throughout the presentation. Learning Objective(s): Explore the roles of different nutrients. Explore how diet can affect health and well-being. See how to determine the energy value of food. Main Skills: Interpret written text and diagrams. Duration: Approximately 30 mins 40 slides covering: • Nutrition • Carbohydrates • Lipids • Proteins • Vitamins • Minerals • Dietary Fibre • Water • Balanced Diet • Recommended Intake • Food Labels • Energy • Malnutrition • Obesity • Starvation • Body Mass Index (BMI) • Balanced Diet