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

228k+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
Word Processing - Introduction to Mail Merge
ljcreateljcreate

Word Processing - Introduction to Mail Merge

(0)
A presentation suitable for KS3 looking at mail merging. 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 simple mail merge. Main Skills: Interpret written text and diagrams. Duration: Approximately 30 mins 17 slides covering: • The Mailings Tab • Start Mail Merge • Select Recipients • Edit Recipients List • Address Block • Greeting Line • Inserting Merge Field • Preview Results • Finish and Merge
Word Processing - Introduction to Word Processing
ljcreateljcreate

Word Processing - Introduction to Word Processing

(0)
A presentation suitable for KS3 looking at the basic functions of word processing. Presentation includes multi-choice questions to engage students and get them thinking about the subject throughout the presentation. Learning Objective(s): Identify some of the functions of Microsoft Word. Main Skills: Interpret written text and diagrams. Duration: Approximately 30 mins 14 slides covering: • The Interface • Typing Text • The Ribbon • File Commands • Saving • Printing
Word Processing - Lists and Tables
ljcreateljcreate

Word Processing - Lists and Tables

(0)
A presentation suitable for KS3 looking at lists and tables in word processing. Presentation includes multi-choice questions to engage students and get them thinking about the subject throughout the presentation. Learning Objective(s): Identify how to add bullet-point lists and tables to documents Identify how to apply justification and tabs to text. Main Skills: Interpret written text and diagrams. Duration: Approximately 30 mins 15 slides covering: • Bullet-points • Tables • Alignment • Tabs
Word Processing - Formatting Text
ljcreateljcreate

Word Processing - Formatting Text

(0)
A presentation suitable for KS3 looking at formatting text in a word processor. Presentation includes multi-choice questions to engage students and get them thinking about the subject throughout the presentation. Learning Objective(s): Identify how to format paragraphs. Identify how to change font styles, colours and formatting. Main Skills: Interpret written text and diagrams. Duration: Approximately 30 mins 16 slides covering: • Paragraphs • Indents • Line Spacing • Paragraph Spacing • Font Types • Font Sizes • Bold • Italics • Underline
Word Processing - Editing Text
ljcreateljcreate

Word Processing - Editing Text

(0)
A presentation suitable for KS3 looking at editing text in a word processor. Presentation includes multi-choice questions to engage students and get them thinking about the subject throughout the presentation. Learning Objective(s): Identify how to edit text in a word processor. Identify how to open new documents and access help in a word processor. Main Skills: Interpret written text and diagrams. Duration: Approximately 30 mins 16 slides covering: • Opening a Document • Switching Between Open Documents • Using Help • Errors • Cut, Copy and Paste
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
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
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
Word Processing - Page Layout, Pictures and Printing
ljcreateljcreate

Word Processing - Page Layout, Pictures and Printing

(0)
A presentation suitable for KS3 looking at page layout, pictures and printing in word processing. Presentation includes multi-choice questions to engage students and get them thinking about the subject throughout the presentation. Learning Objective(s): Identify how to add borders, pictures, headers and footers to documents Identify page layout and advanced printing techniques. Main Skills: Interpret written text and diagrams. Duration: Approximately 30 mins 15 slides covering: • Borders • Pictures • Headers and Footers • Page Layout • Advanced Printing
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
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 - 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 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 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
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 - 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 - 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 - 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
21st Century Engineering
ljcreateljcreate

21st Century Engineering

(0)
21st Century Engineering poster aimed at giving students an overview of a range of engineering industries to help prepare them for the workplace. Engineering industries include: - Control and Instrumentation - Mechanical and Fluid Power - Electronics - Research. Design and Technology - Engineering Management - Computer Programming - Warehouse and Logistics