CompuTech Logo Study Logo
   
 
GCE Applied A-Level in ICT
  Course Administration Materials
  G040:Using ICT to Communicate
  G041:How Organisations Use ICT
  G042:ICT Solutions for Individuals and Society
  G043:System Specification and Configuration
  G045:Software Development - Design
  G046:Communicating Using Computers
  G048:Working To A Brief
  G049:Numerical Modelling Using Spreadsheets
  G050:Interactive Multimedia Products
  G051:Publishing
  G053:Developing and Creating Websites
  G055:Networking Solutions
  G057:Database Design
  G058:Developing and Maintaining ICT Systems for Users
  
G049:Numerical Modelling Using Spreadsheets Teaching Topics

Topic
Individual Work
 
1
Task A - Description of Design Specification
    2
    Task C - Identification / Description of Problems and Record of How System Will Be Implemented
      3
      Task B - Spreadsheet Implementation
        4
        Task D - Testing
          5
          Task E - User Guide
            6
            Task F - Evaluation
                G049:Numerical Modelling Using Spreadsheets Resources

              Name
              Source
              Notes
              Unit 10 -Numerical Modelling Using Spreadsheets SpecificationOCR Websitepdf file
              Unit 10 - Numerical Modelling Using Spreadsheets MarksheetOCR Websitepdf file
              Unit 10 - Numerical Modelling Using Spreadsheets Marksheet CustomisedMr R Doweypdf file
              Unit 10 - Numerical Modelling Using Spreadsheets AssignmentMr R Doweypdf file
              Spreadsheet Design PaperMr C Johnstonpdf file - can be used to show the designs for your sheets
              Key Dates For The Completion of Unit 10Mr R Doweypdf file
              Unit 10 - Numerical Modelling Check ListMr R Doweypdf file
              Example of Functions Used In SpreadsheetMr R Doweypdf file
              Complex Macro Tutorial 1 “Adding Records To Excel Tables To Be Displayed in A Pull-Down Menu”Mr C JohnstonPDF File
              Creating A Copy Sales MacroSA LonglayFlash Animation
              Creating A Macro Which Will Increase Invoice NumbersSA LonglayFlash Animation
              Vlookup ExplainedSA LonglayFlash Animation
              Creating A Macro Which Will Protect Your WorksheetSA LonglayFlash Animation
              Example Excel Spreadsheet Wirh A Login (Uses VBA and A Form MB3 criteria if range of functions used)Mr C Johnston - XLS file use right click and save to view - password is qwerty (case sensitive) explore with ALT+F11 for the code
              Make Macros Work When New Rows Are Added To Your SpreadsheetMr C Johnstonpdf file - c140k
              Using Data Forms In ExcelMr C Johnstonpdf file - c300k
              | Email | Terms | Privacy | |Copyright © C Johnston 2016 |