Course Content
Course Materials
0/1
All Study Notes
00:00
Introduction of ICT
0/1
What is ICT?
10:00
Chapter-1. Digital Devices
we will discuss the types of digital devices, the features of digital devices, types of peripheral devices-Input, Output, Storage in this chapter.
0/16
Lesson-1.1.0-Definitions of digital devices, Mainframe Computer & Microprocessor
08:57
Lesson-1.2.1-Types of Digital Devices (Mobile phone, Tablet, Camera & Camcorders)
40:00
Lesson-1.2.2- Types of digital devices ( Television, Sound System, PVR, blueray-DVD, game console)
40:00
Lesson-1.2.3- Types of Digital Devices (Media Player, Navigation Aids, smart assistance, Multifunctional Devices)
40:00
Lesson-1.3.0- Features of Digital Devices (Portability, Performance, Storage, User Interface)
40:00
Lesson-1.3.1- Features of digital devices (Connectivity, Media Support, Energy Consumption, Expansion Capability, Security)
40:00
Lesson-1.4.0- Types of Peripheral Devices-Input (Keyboard, Mouse, Tracker Ball, Trackpad)
40:00
Lesson-1.4.1- Types of peripheral device- Input (Joystick, Graphical Tablet, OCR & OMR Scanner, Barcode Scanner, Webcam, Microphone, Touch Screen, Biometric scanner, Card Reader, Sensors)
40:00
Lesson-1.5.0- types of peripheral device-Output (Monitor, Printer, Speaker, Control Device,)
40:00
Lesson-1.6.0- Types of peripheral device-Storage ( Primary storage, Secondary storage (Megnetic, Optical , Solid State))
40:00
Assignments-1.0
Assignments-1.1
Assignments-1.2
Quiz-1.0
Quiz-1.1
Quiz-1.2
Chapter-2. Memory and Processor
We will discuss the memory & processors, How they work. How memory and processor related to each other through their job.
0/3
Lesson-2.1.0- Definitions of memory, types of memory (RAM, ROM, Flash Memory)
40:00
Assignments-2.0
Quiz-2.0
Chapter-3. Digital Communication
We will discuss bandwidth, ping, latency, D2D Communication, Network Communication( PAN, LAN, WAN, Tethering), digital device communication, Sattelite communication, Broadcast Communication, Wired communication, Wireless Communication,
0/4
Lesson-3.1.0- BANDWIDTH, Streaming, Buffering, Ping, Latency, D2D Communication, Network Communication (PAN, LAN, WAN, Tethering)
40:00
Lesson-3.1.1- Satellite, Broadcast, Wired and, Wireless Communication
40:00
Assignments-3.0
Quiz-3.0
Chapter-4. Networks
we will discuss the definition of Network, Network operating system, stand-alone-operating system, IP (Internet protocol), Difference between IPv4 & IPv6, MAC (Media Access Control) address, Components of wire and wireless system, Connecting to the internet and use it, Filter software, LAN, Client-Server Network, Benefits of using LAN, Benefits of using Client-Server Networks, Securing data on Networks
0/9
Lesson-4.1.0- Network & Stand-alone Operating System, IP (Internet Protocol),
40:00
Lesson-4.2.0- MAC Address, Components of wire and wireless system
40:00
Lesson-4.3.0-Connecting to the internet and use it, LAN, Client-Server Network,
40:00
Lesson-4.4.0- Securing data on Networks, WEP, WPA, VPN, File access rights, Transaction Logs, Backups
40:00
Assignments-4.0
Assignments-4.1
Quiz-4.0
Quiz-4.1
Quiz-4.2
Chapter-5. Applying ICT
we will discuss the Applying ICT on this topic.
0/4
Lesson-5.1.0- Definition of Data & Information, Differences between data & information, Different types of Data
40:00
Lesson-5.2.0- Font, Application software and the purposes for which they can be used
40:00
Assignments-5.0
Quiz-5.0
Chapter-6. File Management
we will discuss the File management system.
0/3
Lesson-6.1.0- Definition of File management , NAMING FILES, File Formatting,
40:00
Assignments-6.0
Quiz-6.0
Chapter-7. Word Processing
we will discuss word processing.
0/3
Lesson-7.1.0- Definition of word processing, Standard features, text formatting, Paragraph alignment, Line and Paragraph Spacing,
40:00
Assignments-7.0
Quiz-7.0
Chapter-8. Spreadsheets
We will discuss the spreadsheet.
0/19
Lesson-8.1.0- Definition of Spreadsheet, Features of spreadsheet, Data types, Formatting, Merge and Split Cells, Text Wrap, Row Height and Column width:
40:00
Lesson-8.2.0-Cell Border and Shading, Gridlines, Hiding Rows and Columns
40:00
Lesson-8.3.0- Formulas, Functions, Relative Cell Referencing
30:00
Lesson-8.4.0- Mathematical and Statistical Functions,
30:00
Lesson-8.5.0- Multiple Worksheets
30:00
Lesson-8.6.0- Graphs and Charts, Types of chart and graph in excel
40:00
Assignments-8.0
Quiz-8.0
Quiz-8.1
Lesson-8.7.0- Lookup Functions
30:00
Lesson-8.8.0- Using Functions and formulas in Spreadsheet
25:00
Lesson-8.9.0- Conditional Operators, Cross-Sheet Referencing
30:00
Lesson-8.10.0-Absolute cell reference in Excel
25:00
Lesson-8.11.0- Filtering in EXCEL
20:00
Lesson-8.12.0- Graphs and Charts , Formatting Charts
40:00
Assignments-8.1
Assignments-8.2
Quiz-8.2
Quiz-8.3
Chapter-9. Practical
0/9
Lesson-9.1.0- File Management
40:00
Lesson-9.1.1- Word Processing
40:00
Lesson-9.1.2-Word Processing
40:00
Lesson-9.2.1- Spreadsheet
40:00
Lesson-9.2.2-Spreadsheet
40:00
Assignments-9.0
Assignments-9.1
Quiz-9.0
Quiz-9.1
Chapter-10. Software
0/5
Lesson-10.1.1- What is meant by software? Types of software (System software), the role/function of the operating system
00:00
Lesson-10.1.2- Types of software (Application software, Utility Software)
00:00
Lesson-10.1.3- Software Licensing (Open source and proprietary software)
00:00
Assignments-10.1
Quiz-10.1
Chapter-11. Operating Online
0/42
Lesson-11.1.1- aware of risks to data and information: • unauthorized access • deliberate damage by malware • accidental deletion • theft of personal data: phishing, pharming.
00:00
Lesson-11.1.2- methods available to secure data and personal information online: • firewalls • encryption • passwords, PIN, biometrics, CAPTCHA tests, security questions
00:00
Lesson-11.1.3- methods available to secure data and personal information online: • anti-malware, anti-virus, anti-adware, anti-spyware • access rights, file permissions • secure websites • not opening email attachments or following web links • backup procedures.
00:00
Lesson-11.1.4- online payment systems, third party payment systems, bank cards, contactless payment using NFC and how payments are protected.
00:00
Assignments-11.1
Quiz-11.1
Lesson-11.2.1- Meaning of the word Internet. Protocols are used by applications to transfer data across the internet, includes: IMAP, FTP, SSH, VoIP, XMPP, HTTP, HTTPS
00:00
Lesson-11.2.2- the impact on employment, such as new job opportunities as the nature of a job changes, new skills requirements, potential job loss.
00:00
Lesson-11.2.3- the impact on working practices, including collaborative working and flexible or mobile working.
00:00
Lesson-11.2.4- better access to information and services, new ways of learning, and the wider range of entertainment and leisure opportunities
00:00
Lesson-11.2.5- social impacts such as: • reduced social interaction • increases in cyberbullying • reduced physical activity. how to stay safe online.
00:00
Assignments-11.2
Quiz-11.2
Lesson-11.3.1- the availability of digital devices and the internet enables individuals to work from home. the benefits and drawbacks of working from home for individuals and organizations.
00:00
Assignments-11.3
Quiz-11.3
Lesson-11.4.1- Impact of the internet on organizations- positive impacts: improved communication, access to global markets and workforce, changes in the way information is managed and used. negative impacts: security issues, risk of hacking, greater competition.
00:00
Assignments-11.4
Quiz-11.4
Lesson-11.5.1- the impact on society of the ability of individuals to have less-restricted access to networks at any time. the gap between information rich and information poor.
00:00
Lesson-11.5.2- the causes and implications of unequal access to ICT (locally, globally). the impact on individuals and communities of limited or no access to digital technologies. the impact of changes in ways of socializing.
00:00
Assignments-11.5
Quiz-11.5
Lesson-11.6.1- key features of online communities: social networking
00:00
Lesson-11.6.2- key features of online communities: online gaming, online work spaces, virtual learning environments (VLE),
00:00
Lesson-11.6.3- key features of online communities: user-generated reference sites: wikis, websites, forums | user-generated content: video sharing sites, blogs, websites
00:00
Lesson-11.6.4- key features of online communities: key features of online communities:
00:00
Lesson-11.6.5- the functions and target audience of different forms of online communities. the ways in which online communities are used to communicate and collaborate on a global scale.
00:00
Lesson-11.6.6- the ways in which online communities are used to communicate and collaborate on a global scale. how to stay safe online: cyber bullying, anonymity of others (misrepresentation), disclosure of personal information/location.
00:00
Assignments-11.6
Quiz-11.6
Lesson-11.7.1- Implications of the use of digital technologies- Implications of the use of digital technologies.
00:00
Lesson-11.7.2- how copyright legislation affects the use of digital information and media.
00:00
Lesson-11.7.3- Monitoring Individuals- Movements, Anti-Surveillance clothing,
00:00
Lesson-11.7.4- Be aware of safe and responsible practice when using ICT. sustainability issues and ways of mitigating the environmental impact of digital devices.
00:00
Lesson-11.7.5- the health and safety issues that arise from individuals’ use of ICT and know how they can be minimized.
00:00
Assignments-11.7
Quiz-11.7
Lesson-11.8.1- Availability of information online and the use of online information. information can be gathered from a wide range of sources. select and use appropriate sources of information.
00:00
Lesson-11.8.2- evaluate the fitness for purpose of available information in terms of accuracy, age, relevance, reliability, bias. issues related to plagiarism: copy and paste, rewriting, paraphrasing.
00:00
Assignments-11.8
Quiz-11.8
Chapter-12. Online Goods and Services
0/13
Lesson-12.1.1- Types of services- shopping sites – basket, checkout, secure payment, product catalogue | booking systems for travel, leisure and entertainment | banks
00:00
Lesson-12.1.2- Types of services- • education and training providers – VLE, online support, online training courses, remote access • gaming sites • news and other information providers • auction sites • entertainment providers – on demand, streaming, downloads.
00:00
Assignments-12.1
Quiz-12.1
Lesson-12.2.1- Impact of online services- the impact on an individual’s lifestyle and behavior of the availability of goods and services online.
00:00
Lesson-12.2.2- the impact of the internet on the ways that organizations do business. how transactional data is collected and used: what is collected, cookies, transaction tracking.
00:00
Lesson-12.2.3- targeted marketing and personalization techniques. the features and characteristics of online services and local services.
00:00
Assignments-12.2
Quiz-12.2
Lesson-12.3.1- the impact of cloud-based services: hosted applications, storage. the features and characteristics of hosted applications software and locally installed software.
00:00
Lesson-12.3.2- the features and characteristics of online data storage and local storage.
00:00
Assignments-12.3
Quiz-12.3
Chapter-13. Presentation
0/5
Lesson-13.1.1- Create a template/master slide: placeholders, footer, slide number, background, font enhancements (bold, italic, underline).
00:00
Lesson-13.1.2- Create slides: insert text, images, action buttons, hyperlinks; add animation, transition effects.
00:00
Lesson-13.1.3- Print: handouts (two to a page, three to a page), notes pages, full page, headers and footers.
00:00
Assignments-13.1
Quiz-13.1
Chapter-14. Graphics
0/4
Lesson-14.1.1- features of image types: bitmap, vector. | Create images: combining basic shapes and text, rectangles (including square), circles (including ovals), lines, triangles, arrows, text boxes.
00:00
Lesson-14.1.2- Edit images: image editing, cropping, adding captions/text, editing/deletion of unwanted aspects.
00:00
Assignments-14.1
Quiz-14.1
Chapter-15. Web Authoring
0/5
Lesson-15.1.1- Use a template: tables/frames, standard page features, banners, menu/navigation.
00:00
Lesson-15.1.2- Insert text, images, buttons, animation. | Format a web page: headings, subheadings, body text, alignment.
00:00
Lesson-15.1.3- Use HTML code: insert hyperlinks, insert images, font enhancements.
00:00
Assignments-15.1
Quiz-15.1
Chapter-16. Database Management
0/11
Lesson-16.1.1- Identify data types: alphanumeric/text, numeric/number, date, currency, logical/Boolean.
00:00
Lesson-16.1.2- Explain the structure of a given database, including: record, field, table, primary key/field, foreign key/field, relationships between tables.
00:00
Lesson-16.1.3- Explain the need for validation and identify validation checks such as range check, presence check, type check, length check.
00:00
Lesson-16.1.4- Sort using a single field, multiple fields, ascending/descending order.
00:00
Lesson-16.1.5- Input information to given tables or forms applying format consistently.
00:00
Lesson-16.1.6- Use search/query using single criterion, multiple criteria, search within results, relational operators, logical operators.
00:00
Lesson-16.1.7- Produce outputs: reports, mail merge documents, specified fields, design view (table structure, searches/queries, forms, relationships), data view (table, search/query results, forms).
00:00
Assignments-16.1.1
Assignments-16.1.2
Quiz-16.1.1
Quiz-16.1.2
Test Yourself
You can test your current situation on this course.
0/3
Final Mock-1
Final Mock-2
Final Mock-3
Practical
0/4
Presentation
00:00
Graphics
00:00
Web Authoring
00:00
Database Management
00:00
Mastering Edexcel OLevel ICT Skills for the Digital Age
    Previous
    Next