Employed 36 years in FE, teaching and managing Computing/Digital/IT. Specialised in level 3 database, spreadsheet, programming, level 2 database and spreadsheet for Pearson qualifications. Shop includes learning resources/projects for Pearson level 3 Unit 2 Create a System to Manage Information. Learning projects could be used for other level 3 relational database learning.
Employed 36 years in FE, teaching and managing Computing/Digital/IT. Specialised in level 3 database, spreadsheet, programming, level 2 database and spreadsheet for Pearson qualifications. Shop includes learning resources/projects for Pearson level 3 Unit 2 Create a System to Manage Information. Learning projects could be used for other level 3 relational database learning.
Complete walk through for parts A and B of Pearson June 2022 Unit 2 CSMI paper. One PowerPoint per activity includes video demonstration of activity, terminology, recaps and exam tips/advice on maximising marks. Potential uses: whole class, independent learning, differentiated learning, revision, exam prep, CPD for teachers new to unit.
Powerpoints cover: review of paper/activities, design using ERD method, create database structure (activity 1), validation (activity 2), queries and report (activity 3), testing database structure and validation (activity 4), evaluation of database structure and validation (activity 5), create input forms (interface) (activity 6), test interface (activity 7), evaluate interface (activity 8). Completed activity templates with suggested solutions.
Complete walk through for Part A of Pearson June 2022 Unit 2 CSMI paper. One Powerpoint per activity includes video demonstration of activity, terminology, recaps and exam tips/advice on maximising marks. Potential uses: whole class, independent learning, differetiated learning, revision, exam prep, CPD for teachers new to unit.
Powerpoints cover: review of paper/activity, design relational database using ERD method, create database structure (activity 1), validation (activity 2), queries and report (activity 3), testing table structure and validation (activity 4) and evaluation of table structure and evaluation (activity 5). Includes completed activity templates for suggested solutions.
Complete walk through of par B of Pearson June 2022 Unit 2 CSMI paper. One PowerPoint file per activity includes video demonstration of activity, terminology, recaps and exam tips/advice on maximising marks. Potential uses: whole class, independent learning, differentiated learning, revision, exam prep, CPD for teaches new to unit.
The PowerPoints cover: review of paper, creating input forms (activity 6), testing interface (activity 7), evaluation of interface (activity 8). Completed activity templates provided showing suggested solutions.
Learning Project created in the style of the exam for Pearson Level 3 Unit 2 Create a system to Manage Information (design, create Access database, build queries/report, test, and evaluate a relational database). Contains guidance/pointers and suggestions for gaining higher marks. Learning Project can be used to demonstrate to whole class or as a resource for learners to work through individually for practice. Templates are provided for learners to complete supporting practice for the final exam. Learning Project may be used for other level 3 courses covering relational databases concepts: ERD/normalisation/design/development/testing/evaluation.
Learning Project created in the style of the exam for Pearson Level 3 Unit 2 Create a system to Manage Information (create user interface/forms, test, and evaluate). Contains guidance/pointers and suggestions for gaining higher marks. Learning Project can be used to demonstrate to whole class or as a resource for learners to work through individually for practice. Templates are provided for learners to complete supporting practice for the final exam. Learning Project may be used for other level 3 courses covering relational databases concepts: interface/form creation, test, and evaluate.
Bundle covers Part A and Part B of Pearson Level 3 Unit 2 Create a System to Manage Information. Learning Project tasks include advice/guidance for completion. Templates are included for learner evidence. Suggested solutions for tasks 1-4 and 6 and 7. Zipped database is included for Part B.
Suggested solution for Angelo Airways Learning Project Part B tasks covering interface/form creation and test for Pearson Level 3 Unit 2 Create a System to Manage Information.
Suggested solution for Angelo Airways Learning Project Part A tasks covering design (normalization using Entity Relationships Diagram), create relational database in Access, build queries/report, and test for Pearson Level 3 Unit 2 Create a System to Manage Information.
