Easier to read with cream paper, a tint, more contrast or larger text? Choose your colours and text, once, for every page.

Free preview

BTEC Level 2 Data Management: the chapters

Pick a chapter, then a lesson. Each preview is the first page of the lesson, with its first activities to try, free and with no account.

BTEC is a registered trademark of Pearson Education, and these lessons are written by Mitsuru Technologies and are not published, endorsed or approved by Pearson.

Unit 6: Database tools and techniquesInternally assessed unit · 13 lessons
  1. Unit 6 A1: Why organisations use databases45 minutes
  2. Unit 6 A1, B1, C1: Review: design, query and present60 minutes
  3. Unit 6 A2: Kinds of data and where it comes from45 minutes
  4. Unit 6 A2: Collecting data well and legally50 minutes
  5. Unit 6 B1: The data dictionary50 minutes
  6. Unit 6 B1: Validation rules and the ERD50 minutes
  7. Unit 6 B1: Forms, reports and the design document50 minutes
  8. Unit 6 B2: Creating tables, rules and imports50 minutes
  9. Unit 6 B2: Relationships and data entry forms50 minutes
  10. Unit 6 B3: Testing a database with a test plan50 minutes
  11. Unit 6 C1: Sorting and searching with queries55 minutes
  12. Unit 6 C1: Calculations, cleansing and mining55 minutes
  13. Unit 6 C2: Presenting data to an audience50 minutes
Unit 9: Organisational data systemsInternally assessed unit · 12 lessons
  1. Unit 9 A1: The stages of analysing data50 minutes
  2. Unit 9 A1, B1, C1: Review: analyse, show and look after data60 minutes
  3. Unit 9 A2: Create, read, update and delete data55 minutes
  4. Unit 9 A2: Queries that make reports for readers55 minutes
  5. Unit 9 A3: Big data and where it comes from55 minutes
  6. Unit 9 A4: Preparing big data for analysis55 minutes
  7. Unit 9 A4: Predicting, finding patterns and judging results55 minutes
  8. Unit 9 B1: Choosing a chart for the question55 minutes
  9. Unit 9 B1: Visuals for links, groups and words55 minutes
  10. Unit 9 B2: Designing a clear dashboard screen55 minutes
  11. Unit 9 C1: Planning data maintenance and a user manual55 minutes
  12. Unit 9 C2: Keeping data accurate and clean55 minutes

All folders