CompuTech Logo Study Logo
   
 
BTEC National (2016) L3 Dip / Ex Cert in IT
  Course Administration Materials
  Unit 01: Information Technology Systems
  Unit 02: Creating Systems to Manage Information
  Unit 03: Using Social Media in Business
  Unit 05: Data Modelling
  Unit 08: Computer Games Development
  Unit 11: Cyber Security and Incident Management
  
Unit 02: Creating Systems to Manage Information Teaching Topics

Topic
Individual Work
 
1
Introduction To Databases
Your understanding will be assessed by your tutor either within or after the lesson
Complete outstanding activities as indicated by your for Homework
    2
    Introduction Entities
    Carry out the activities as indicated within the lesson PowerPoint
    Your understanding will be assessed by your tutor either within or after the lesson
    Complete outstanding activities as indicated by your for Homework
      3
      Entity Relationships
      Carry out the activities as indicated within the lesson PowerPoint
      Your understanding will be assessed by your tutor either within or after the lesson
      Complete outstanding activities as indicated by your for Homework
        4
        Database Keys
        Carry out the activities as indicated within the lesson PowerPoint
        Your understanding will be assessed by your tutor either within or after the lesson
        Complete outstanding activities as indicated by your for Homework
          5
          Data Types
          Carry out the activities as indicated within the lesson PowerPoint
          Your understanding will be assessed by your tutor either within or after the lesson though the completion of ERD modeling
          Complete outstanding activities as indicated by your for Homework
          6
          Normalisation
          Carry out the activities as indicated within the lesson PowerPoint
          Your understanding will be assessed by your tutor either within or after the lesson
          Complete outstanding activities as indicated by your for Homework
            7
            Scenario 2 Design
            Carry out the activities as indicated within the lesson PowerPoint
            Your understanding will be assessed by your tutor either within or after the lesson
            Complete Activity #3
              8
              User Interface Design
              Carry out the activities as indicated within the lesson PowerPoint
              Your understanding will be assessed by your tutor either within or after the lesson
              Complete outstanding activities as indicated by your for Homework
                9
                SQL
                Carry out the activities as indicated within the lesson PowerPoint
                Your understanding will be assessed by your tutor either within or after the lesson
                Complete Activity #3 from lesson 07
                  10
                  Output Design
                  Your understanding will be assessed by your tutor either within or after the lesson
                  Complete Exercise 01
                  11
                  Queries and Reports
                  Complete the exercises as indicated below
                  Your understanding will be assessed by your tutor either within or after the lesson
                  12
                  Applying Security Measures
                  Carry out the activities as indicated within the lesson PowerPoint
                  Your understanding will be assessed by your tutor either within or after the lesson
                  Complete outstanding activities as indicated by your for Homework
                    13
                    Action Queries
                      14
                      Database Testing
                      Carry out the activities as indicated within the lesson PowerPoint
                      Your understanding will be assessed by your tutor either within or after the lesson
                      Complete outstanding activities as indicated by your for Homework
                        15
                        Completing Your Set Task ***Updated for Jun 2018 series***  updated  Apr 2018
                        Guidance on how to tackle and complete the set task
                        Your understanding will be assessed by your tutor either within or after the lesson
                            Unit 02: Creating Systems to Manage Information Resources

                          Name
                          Source
                          Notes
                          Unit SpecificationPearsonpdf file
                          Student Book ***Pasword Protected***Pearsonpdf file c28mb
                          Official Assessment TemplatesPearsonzip file (use right click, save as)
                          Unit Generic MarkschemePearsonpdf file
                          Sample Assessment Material #1Pearsonzip file (use right click, save as)
                          Sample Assessment Material #1 Design Suggested AnswerC Johnstonpdf file
                          Sample Assessment Material #2Pearsonzip file (use right click, save as)
                          Sample Assessment Material #2 Sample Marked Learner WorkPearsonpdf file c3.5mb
                          Sample Assessment Material #2 Sample Marked Learner Work - DatabasePearsonaccdb file (use right click, save as)
                          BTEC Student Revision Workbook (includes model answer)Pearsonpdf file c15mb (Password Protected)
                          Microsoft Access Guidance BookMark Nichollspdf file
                          Microsoft Official Academic Course (MOAC) Access 2016 Book[Wiley] (9781119274438)pdf file c10mb
                          | Email | Terms | Privacy | |Copyright © C Johnston 2016 |