Information Technology I/GCSE | Information & Communication Technology

EDUCATION COLLABORATION

DASHBOARD
SETTINGS
PERSONAL PROFILE
MY COURSES
MEMBERSHIPS
ASSESSMENT
BADGZ
QUIZLZ
STICKLRZ
IMAGE WALLS
SPUZLZ
POLLS
REVIZRZ
WEBSITES
qDOCS
MY BLOG
PERSONAL CLOUD
SIGN UPS
LINKS
VIDEOS
BRAINRZ

Collaborate on this course Please sign in

Button

Information Technology I/GCSE
- Syllabuses
Theory
- Computer System Components
  - Hardware & Software
    - Hardware
    - Software
      - Applications software
    - Utility Programs
  - Computer Components
    - RAM
    - ROM
    - Input - Output
    - Storage devices.
    - The CPU
  - User Interfaces
    - Command Line Interface (CLI)
    - Graphical User Interface (GUI) .....
  - Types of Computers
    - PCs : Desktops : iMacs
    - Laptops
    - Tablets
    - Smartphone
    - Smartwatch
    - Mainframe Computer
- Emerging Technologies
  - Biometrics
  - Quantum Cryptography
- Input & Output Devices
  - Input Devices
    - Scanners
    - Digital Cameras
    - Keyboards
    - Mice
    - Touch Screens
    - Microphones
  - Output Devices
- System Life Cycle
  - Investigation and analysis
  - Analytical Approaches
  - Design
  - Hardware & Software
  - Implementation / Development
  - Gantt / CPA
- Storage Devices & Media
  - Devices & Media
  - Serial & Direct Access
- Networks
  - LAN & WAN
    - Pros & Cons
  - WLAN
  - Network Hardware
    - Network Interface Card (NIC)
    - Network Cables
    - Modem
    - Hub
    - Switch
    - Bridge
    - Router
    - Gateway
  - Data Packets
  - MAC Addresses
  - IP Addressing
  - Proxy Servers
  - Home Network
    - ISP
Practical
- Database
  - Badge Project
  - Set Up
  - Naming Conventions
  - Selecting Data Types
  - Database Terms
  - CSV / Text Files - Import
  - Validation
    - Types of Validation
    - Rules
  - Verification
  - Add Dropdown Box
  - Data Dictionary
  - Calculated Fields
  - Relationships
  - Entity Relationship Diagrams
    - The Diagrams
  - Queries
    - Simple, Complex, Static, Dynam .....
      - Simple Queries
      - Complex Queries
      - Static Queries
      - Dynamic Queries
    - Query Examples
      - Sorting
      - AND / OR
      - Show / Hide
      - Simple Queries
      - Text Queries
      - Number Queries
      - Date Queries
      - Calculated Fields
  - School Data Manager (Building) .....
    - Super Simple
      - Create Database
      - Create Table
      - Create Forms
    - Importing Data
      - CSV / Text Files
    - Querying Data
    - 2 Table Relationship
- Website Authoring
  - Main Structure
  - Colours (Colors)
  - HTML Tables
    - Inline Height & Width
    - Using CSS
  - Relative : Absolute Paths
  - Images
  - Built-In Styles
  - Hyperlinks
  - StyleSheets
    - Style Properties
- Document and Presentation Prod .....
  - Text To Table
  - Paragraph Glyph On
  - Image Wrap
  - Rotate & Crop
  - Size, Orientation & Margin .....
  - Headers & Footers
  - Dates / Page Numbers / File Na .....
- Spreadsheets
  - Worksheets, workbooks, rows, c .....
  - Basics
  - Count / CountA
  - Absolute & Relative Refere .....
  - Conditional Formatting
  - Concatenate
  - IF / NESTED IF
  - VLOOKUP
  - SUMIF
  - COUNTIF
  - AVERAGEIF
  - ROUNDING
  - Modelling
    - What if?...
    - Modelling Software

ALPHABETICAL LIST

Information Technology I/GCSE

Links ➤

Reads: 1320

This page last updated: Wednesday September 2 2020 01:25 UTC

Created By: devxel

Share URL https://www.quozr.org/courses/ .....