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
  
G042:ICT Solutions for Individuals and Society Teaching Topics

Topic
Individual Work
 
0
G042 -Unit Deadline
Ensure all pages are numbered and a marksheet is attached. Any changes to tasks A,B,C or D must to indicated otherwise will not be remarked. Work must be submitted by 15:15 otherwise it will not be accepted
    1
    Unit Introduction
    Familer yourself with the unit specification and ask if you donít understand any of the key terms. Create a suitable folder in your area to store the work you will be doing during this unit.
      2
      Using Search Engines
        3
        Public Service Websites
        Create a table to summarise the information available on public service websites and how it is beneficial to people and organisations.
          4
          Task G Briefing Notes
          Commence writing your report for task G
            5
            Task G - Mark Band 1 Ideas  updated  Sept 2015
            Use these topics to write about how you, family and friends have been impacted by the availability of electronic information
              6
              Task G - Mark Band 2 Ideas  updated  Sept 2015
              Use these topics to write about how people and circumstances outside your normal experiences have been affect by the availability of electronic information
                7
                Task G - Mark Band 3 Notes To Get You Started  updated  Sept 2015
                These are very basic pointers which will need further research to write about at the level required - this band is for the B and A grade students
                  7.1
                  Task G - PEER ASSESSMENT SHEET
                  Use this sheet to mark your own or a peers work and suggest improvements. This will aid your understanding of what the mark bands are asking you to do
                    7.2
                    Task G - Common Issues 2009
                    These are the common errors found with task G's produced by the 12A group 2009. Use these comments to ensure your essay is up to standard
                      8
                      Commencing My Investigation - (Assignment Tasks A,B,C,D,E,F)
                        9
                        Task A - Basic Searching
                          10
                          Task A - Using Advance Search and Manually Using Boolean Operators
                          Improve the work done last week to include the mark band 2 and 3 evidence as included in this presentation - use the using Google advance search video to remind yourself of some of the techniques used.
                            10.1
                            Advanced Searching Common Errors
                            This powerpoint highlights real errors which have been found with learners advanced searches - can you spot the errors and how do we fix them??
                              10.2
                              Own Operator Searching Common Errors
                              This powerpoint highlights real errors which have been found with learners own operator searches - can you spot the errors and how do we fix them??
                                11
                                Task B - Accessing Information On Large Websites
                                  12
                                  Task C - Using A Local Database
                                    12.1
                                    Task C - Making Reports For Your Queries
                                      12.2
                                      Task A, B, C Common Issues 2011
                                      Use these notes to try and enhance your work. Your teacher will inform you of the final handin for these tasks.
                                        13
                                        Task D - Overview and Starting Point
                                          14
                                          Task D - Formulae and Functions
                                            15
                                            Task D - Using Macros In Excel
                                            Add macros to your spreadsheet to assist with inputing, processing and presenting data - the example spreadsheets and tutorial sheets in the resources section may help
                                              16
                                              Task D - Testing Your Spreadsheet
                                                17
                                                Task E - Presenting The Findings To Your Investigation
                                                  18
                                                  Task F - Unit Evaluation
                                                  Use these notes to help you write your evaluation for this unit
                                                    19
                                                    Coverwork for 28-04-2011
                                                    Compilation of lectures 17 and 18 along with an example of a good task e
                                                        G042:ICT Solutions for Individuals and Society Resources

                                                      Name
                                                      Source
                                                      Notes
                                                      G042 - ICT Solutions for Individuals and Society SpecificationOCR Websitepdf file
                                                      G042 - ICT Solutions for Individuals and Society MarksheetOCR Websitepdf file
                                                      G042 - ICT Solutions for Individuals and Society Marksheet (Interactive Version)OCR Websitepdf file
                                                      G042 - ICT Solutions for Individuals and Society Unit Assignment 2015-16Mr C Johnstonpdf file
                                                      G042 Contents PageMr C Johnstonpdf file
                                                      Local Database For Use With Invesigation 1 - Where In Devon?Mr C Johnston - Devon & Cornwall Constabularymdb file - right click, save as to download - use table design view for a description of each field
                                                      Local Database For Use With Invesigation 2 - Which University?Mr C Johnston - 6th Form Data & Guardian.co.uk & Push.co.ukmdb file - right click, save as to download - use table design view for a description of each field
                                                      Local Database For Use With Invesigation 3 - A New Theme Park?Create By Members of the OCR Social Network and their studentsmdb file - right click, save as to download - use table design view for a description of each field
                                                      Local Database For Use With Invesigation 4 - European HolidayMr C Johnston various government sources andmdb file - right click, save as to download - use table design view for a description of each field
                                                      Local Database For Use With Invesigation 5 - Learning To DriveMr C Johnston various government and insurance sourcesmdb file - right click, save as to download - use table design view for a description of each field
                                                      Availability of Electonic Information ArticlesComputer Activepdf file - some situations both inside and outside your own experiences to write about
                                                      How To Search The InternetYouTubeStreaming WMV Movie File
                                                      Using the advance search facilities of GoogleYouTubeStreaming WMV Movie File
                                                      Boolean Operators In Access QueriesMr C Johnstonpdf file
                                                      Making Reports In Access - My NotesMr C Johnstonpdf file c300k
                                                      Making Report From Scratch In AccessPrinceton University Office of ITpdf file c300k - shows you have to make reports without the wizard - not very practical but will help you customise your reports
                                                      Making Reports In Access - videoMr C JohnstonStreaming WMV Movie File
                                                      Vlookup ExplainedSA LonglayFlash Animation
                                                      Adding Conditional Formatting To Cells In ExcelMr C Johnstonpdf file
                                                      Using Data Forms In ExcelMr C Johnstonpdf file - c300k
                                                      Make Macros Work When New Rows Are Added To Your SpreadsheetMr C Johnstonpdf file - c140k
                                                      Example Simple Spreadsheet - this is a starting point of what is required for task eMr C Johnstonpdf file
                                                      Example Spreadsheet with Simple Macro UseMr C Johnstonpdf file
                                                      Example More Complicated Spreadsheet - added further numerical anaylsis capabiliy by using formuleaMr C Johnstonpdf file
                                                      Example Spreadsheet Using An Input Form To Add DataMr C Johnstonpdf file
                                                      Bibliography Layout Notes (use for task e)Mr C Johnstonpdf file
                                                      Finding Out When A Webpage Was Last UpdatedMr C Johnstonpdf file - use these instructions to find out when a webpage was last updated - vital information for producing proper bibliographies
                                                      Harvard Referencing ExamplesStaffordshire Univeristypdf file - use this to help reference using the harvard system to referenece sources used in your "presentation"
                                                      | Email | Terms | Privacy | |Copyright © C Johnston 2016 |