About Course

Cambridge OLevel ICT Crash Course

Welcome to Arif Sir Science Hub’s Cambridge OLevel ICT Crash Course! Are you ready to elevate your ICT skills and triumph in the Cambridge O-Level exam? Look no further! Our intensive crash course is meticulously crafted to equip you with the essential knowledge and skills needed to excel in this dynamic subject area. Under the expert guidance of our seasoned educators, tailored specifically to your exam needs, this crash course is your express route to success in ICT.

Why Choose Our Course:

At Arif Sir Science Hub, we recognize the pivotal role of ICT proficiency in today’s digital landscape. Our crash course is strategically designed to empower you with the expertise and confidence required to navigate the intricacies of ICT effectively. Here’s why our course stands out:

Comprehensive Coverage: Despite its condensed format, our crash course leaves no stone unturned in covering all crucial topics from the Cambridge O-Level ICT syllabus. From fundamental concepts of hardware and software to advanced topics like networks and communication technologies, we ensure you’re thoroughly equipped to tackle every facet of the exam.
Expert Instruction: Learn from our team of seasoned instructors, each possessing an in-depth understanding of the Cambridge O-Level ICT exam. Our instructors are not just educators; they are passionate advocates of ICT education, dedicated to nurturing your skills and fostering your success. With their guidance, you’ll receive clear explanations, valuable insights, and indispensable strategies for exam triumph.
Interactive Learning: Engage in dynamic lessons that transform ICT education into an engaging and immersive experience. Our crash course employs a diverse array of teaching methodologies, including interactive lectures, collaborative discussions, practical demonstrations, and hands-on activities. Through active participation and exploration, you’ll deepen your understanding and cement your knowledge of ICT concepts.
Practice and Feedback: Reinforce your learning through extensive practice exercises and assessments. Our crash course integrates regular quizzes, tests, and practical assignments, providing you with ample opportunities to gauge your progress and identify areas for improvement. With personalized feedback from our instructors, you’ll receive invaluable guidance to refine your skills and enhance your performance.
Flexible Schedule: Our crash course is thoughtfully designed to accommodate your busy lifestyle. We offer flexible scheduling options, including weekday and weekend classes, ensuring you can tailor your study schedule to suit your needs. Whether you’re a student juggling multiple subjects or a working professional with limited time, our crash course adapts to your schedule with ease.
Convenient Location: Situated in a prime location, our institute offers easy accessibility, minimizing travel time and maximizing learning potential. Within our welcoming and conducive learning environment, you’ll find the ideal setting to focus on your studies, collaborate with peers, and unleash your full potential in ICT.

Course Structure:

Our Cambridge O-Level ICT Crash Course is meticulously structured to optimize your learning experience and maximize your exam readiness. Here’s an overview of the course structure:

Duration: The crash course spans a duration of [X weeks/months], comprising [X hours] of instruction per week.
Content Coverage: The course encompasses all topics outlined in the Cambridge O-Level ICT syllabus, with a comprehensive focus on core concepts, practical applications, and exam-specific strategies.
Class Format: Each class combines theoretical instruction with practical application, fostering a holistic understanding of ICT principles and methodologies.
Assessments: Throughout the course, you’ll undergo regular assessments, including quizzes, tests, and simulated exams, to evaluate your progress and readiness for the Cambridge O-Level exam.

Enroll Now:

Don’t let time constraints hinder your pursuit of success in ICT. Seize the opportunity to enroll in our crash course today and embark on a transformative journey towards exam triumph! For inquiries and enrollment, contact us at [email protected] or call us at +8801327331903. Let Arif Sir Science Hub be your guiding light as you embark on your quest for excellence in ICT and soar to new heights of achievement!

Learn everything there is to know about the importance of ICT in the modern world and how it affects different industries and sectors.
Learn the fundamentals of digital literacy to successfully navigate the online world.
Become proficient in file management and other fundamental computer functions.
For academic and professional purposes, develop your word processing, spreadsheet, and presentation skills.
To protect personal information and maintain online security, learn effective internet usage and security precautions.
Examine numerous platforms and tools for communication, such as social media and email, and gain knowledge of efficient online collaboration.
Learn the basics of web design and development, including as HTML and CSS, so you can create and modify online sites.
Utilize a programming language like Python to hone your problem-solving and programming foundations.
Learn how to handle and analyze data, including how to collect, organize, and visualize data.
Recognize the ethical issues surrounding the use of ICT and the privacy and protection of data.
To protect the security of digital assets and information, become familiar with cybersecurity best practices.
Examine real-world ICT applications in both the personal and professional spheres.
Determine new trends and potential developments in the ICT sector.

Course Content

Introduction of ICT

What is ICT?

00:30

Chapter-1. Types and components of computer systems

Lesson-1.1.1-Hardware consists of the physical components of a computer system Internal components including Central Processing Unit (CPU), processor, motherboard.

40:00
Lesson-1.1.2-Internal memory including random access memory (RAM), read-only memory (ROM).

40:00
Lesson-1.1.3- Hardware components including graphics card, sound card, Network Interface Card (NIC), camera, internal/ external storage devices, input and output devices.

40:00
Lesson-1.1.4- Software are programs for controlling the operation of a computer or processing of electronic data Applications software provides the services that the user requires to solve a task.

40:00
Lesson-1.1.5- Examples of applications software including word processing, spreadsheet, database management systems, control, measurement, applets and apps, video editing, graphics editing, audio editing, computer aided design (CAD).

00:00
Lesson-1.1.6- System software provides the services that the computer requires to operate Examples of system software including compilers, linkers, device drivers, operating systems and utilities.

00:00
Lesson-1.1.7-Characteristics of analogue and digital data Differences between analogue and digital data The need to convert: • analogue to digital data so it can be processed by a computer • digital data to analogue data so it can be used to control devices.

00:00
Lesson-1.1.8- The role of the CPU in processing instructions entered into the computer in order to produce an output. Characteristics of ROM and RAM Differences between ROM and RAM.

00:00
Lesson-1.1.9- Characteristics of input and output devices Differences between input and output devices.

00:00
Lesson-1.1.10- Characteristics of backing storage Differences between backing storage and internal memory.

00:00
Lesson-1.1.11- Characteristics of operating systems including: Command Line Interface (CLI), Graphical User Interface (GUI), dialogue based and gesture based interface.

00:00
Lesson-1.1.12- Differences between types of operating systems Advantages and disadvantages of the different types of operating systems.

00:00
Lesson-1.1.13- Characteristics of a desktop computer Uses of a desktop computer including office and business management, education, gaming and entertainment.

00:00
Lesson-1.1.14- Characteristics of mobile computers including laptop computers, smartphones, tablet and phablet computers Uses of mobile computers including office and business management, education, gaming, entertainment and remotely controlled devices Advantages and disadvantages of the different types of computer including portability and expandability.

00:00
Lesson-1.1.15- Impact on everyday life including Artificial Intelligence (AI), extended reality (virtual and augmented).

00:00
Assignments-1.1
Quiz-1.1

Chapter-2. Input and output devices
We will discuss the memory & processors, How they work. How memory and processor related to each other through their job.

Chapter-3. Storage devices and media
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,

Chapter-4. Networks and the effects of using them
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

Lesson-4.1.1- The operation and purpose of a router including: • connecting networks and devices to the internet • storing computer addresses in a router • routing data packets.

40:00
Lesson-4.1.2- Including: network interface cards (NIC), hubs, bridges, switches.

40:00
Lesson-4.1.3-The uses of wi-fi and Bluetooth Connecting a device to a network using: • wi-fi • Bluetooth Similarities and differences between Bluetooth and wi-fi

40:00
Lesson-4.1.4- The characteristics, uses and issues relating to cloud computing How data is stored, managed and shared using cloud computing Advantages and disadvantages of using cloud storage compared to other methods.

40:00
Lesson-4.1.5- Characteristics, uses and purpose of an extranet, intranet and the internet The differences and similarities between an extranet, intranet and the internet.

00:00
Lesson-4.1.6- Local Area Network (LAN), Wireless Local Area Network (WLAN), Wide Area Network (WAN) and the differences between these networks.

00:00
Lesson-4.1.7- Privacy and confidentiality of data transfer. Avoiding password interception by using up to date anti-spyware and regularly changing passwords The differences between strong and weak passwords.

00:00
Lesson-4.1.8- Including: zero login, biometric methods, magnetic stripes, smart cards, physical tokens, electronic tokens.

00:00
Lesson-4.1.9- Including the use of anti-malware and anti-virus software The operation of removing/quarantining viruses using up to date software.

00:00
Lesson-4.1.10- Scanning the storage media used to transfer data Scanning the data/software when downloading.

00:00
Lesson-4.1.11- Characteristics, uses, advantages and disadvantages of video-conferencing, audio-conferencing, web-conferencing The hardware, software and network connection required to set up each type of electronic conference.

00:00
Assignments-4.1
Quiz-4.1
Quiz-4.2

Chapter-5. The effects of using IT

Chapter-6. ICT Applications

Lesson-6.1.1- Characteristics and uses including newsletters, posters, websites, multimedia presentations, audio, video, media streaming and ePublications

40:00
Lesson-6.1.2- The use of mobile devices for communication including: SMS messaging, phone calls, Voice over Internet Protocol (VoIP), video calls, accessing the internet.

00:00
Lesson-6.1.3- Including: personal finance, bridge and building design, flood water management, traffic management, weather forecasting Advantages and disadvantages of using computer modelling rather than humans.

00:00
Lesson-6.1.4- Including: robotics in manufacture, production line control, autonomous vehicles Advantages and disadvantages of using computer controlled systems rather than humans.

00:00
Lesson-6.1.5- Systems are used to manage learner registration and attendance Systems are used to record learner performance including computer aided learning.

00:00
Lesson-6.1.6- Characteristics, uses, advantages and disadvantages of online booking systems including travel industry, concerts, cinemas, sporting events.

00:00
Lesson-6.1.7- Characteristics, uses, advantages and disadvantages of Automatic Teller Machines (ATM) including: withdrawing cash, depositing cash or cheques, checking account balance, mini statements, bill paying, money transfers.

00:00
Lesson-6.1.8- Characteristics, uses, advantages and disadvantages of Electronic Funds Transfer (EFT), credit/debit card transactions, cheques, internet banking.

00:00
Lesson-6.1.9- Characteristics and uses of patient records, pharmacy records.

00:00
Lesson-6.1.10- 3D printers Including printing of prosthetics, tissue engineering, artificial blood vessels, customized medicines.

00:00
Lesson-6.1.11- Characteristics, uses and purpose of expert systems including mineral prospecting, car engine fault diagnosis, medical diagnosis, chess games, financial planning, route scheduling for delivery vehicles, plant and animal identification.

00:00
Lesson-6.1.12- Components of an expert system: user interface, inference engine, knowledge base, rules base, explanation system How an expert system is used to produce possible solutions for different scenarios.

00:00
Lesson-6.1.13-Characteristics and uses of computers in the retail industry including point of sale (POS) terminals and electronic funds transfer at point of sale (EFTPOS) terminals.

00:00
Lesson-6.1.14- Point of sale (POS) terminals including updating stock files automatically and ordering new stock automatically.

00:00
Lesson-6.1.15- Electronic funds transfer at point of sale (EFTPOS) terminals including checking of the validity of cards, the use of chip and PIN, the use of contactless cards, the use of Near Field Communication (NFC) payment, the communication between the supermarket computer and the bank computer.

00:00
Lesson-6.1.16- Characteristics, advantages and disadvantages of internet shopping.

00:00
Lesson-6.1.17- Characteristics, uses, advantages and disadvantages of: Optical Mark Recognition (OMR) including school registers, multiple-choice examination papers, barcode, QR code.

00:00
Lesson-6.1.18- Optical Character Recognition (OCR) including automated number plate recognition (ANPR) systems Radio Frequency Identification Device (RFID) including tracking stock, passports, automobiles, contactless payment.

00:00
Lesson-6.1.19-Near Field Communication (NFC) including payment using a smartphone Biometric recognition including face, iris, retina, finger, thumb, hand, voice.

00:00
Lesson-6.1.20- Characteristics, uses, advantages and disadvantages of satellite systems including Global Positioning Systems (GPS), satellite navigation, Geographic Information Systems (GIS), media communication systems (satellite television, satellite phone.

00:00
Assignments-6.0
Quiz-6.0

Chapter-7. The systems life cycle

Lesson-7.1.1- Characteristics, uses, advantages and disadvantages of the research methods of observation, interviews, questionnaires and examination of existing documents.

40:00
Lesson-7.1.2- The need to identify the inputs, outputs and processing of the current system, problems with the current system, the user and information requirements for the new system.

00:00
Lesson-7.1.3- Identify and justify suitable hardware and software for the new system.

00:00
Lesson-7.1.4- Design file/data structures, input formats, output formats and validation routines File/data structures including field length, field name, data type, coding of data for example M for male, F for female.

00:00
Lesson-7.1.5- Validation routines including range check, character check, length check, type check, format check, presence check, check digit Input formats including data capture forms Output formats including screen layouts and report layouts.

00:00
Lesson-7.1.6- The need to test the system before implementation Test designs, test strategies, test plan (test data, expected outcomes, actual outcomes, remedial action) following testing.

00:00
Lesson-7.1.7- Test designs including the testing of data structures, file structures, input formats, output formats and validation routines Test strategies including to test each module, each function and the whole system.

00:00
Lesson-7.1.8- The definition, characteristics and use of test data using normal, abnormal and extreme data The use of live data.

00:00
Lesson-7.1.9- Characteristics, uses, advantages and disadvantages of the four methods of implementation, direct changeover, parallel running, pilot running, phased implementation.

00:00
Lesson-7.1.10-Characteristics, uses and purpose of technical and user documentation.

00:00
Lesson-7.1.11- Components of technical documentation including: purpose of the system/program, limitations of the system, program listing, program language, program flowcharts/algorithms, system flowcharts, hardware and software requirements, file structures, list of variables, input format, output format, sample runs/test runs, validation routines.

00:00
Lesson-7.1.12- Components of user documentation including: purpose of the system, limitations of the system, hardware and software requirements, how to load/ run/install software, how to save a file, how to print data, how to add records, how to delete/edit records, input format, output format, sample runs, error messages, error handling, troubleshooting guide/ helpline, frequently asked questions, glossary of terms.

00:00
Lesson-7.1.13- Evaluate a solution including the efficiency of the solution, the ease of use of the solution, and the appropriateness of the solution.

00:00
Lesson-7.1.14- Compare the solution with the original task requirements, identify any limitations and necessary improvements to the system, evaluate the users’ responses to the results of testing the system.

00:00
Assignments-7.0
Quiz-7.0

Chapter-8. Safety and security

Lesson-8.1.1- Including: electrocution from spilling drinks near electrical equipment and touching live cables, fire from sockets being overloaded or equipment overheating, tripping over trailing cables, heavy equipment falling and injuring people The causes of these safety issues and strategies for preventing them.

40:00
Lesson-8.1.2-The principles of a typical data protection act and why data protection legislation is required.

40:00
Lesson-8.1.3- Characteristics of personal and sensitive data including personal name, address, date of birth, a photograph in school uniform, medical history The need for personal data to be kept confidential and protected to avoid inappropriate disclosure.

30:00
Lesson-8.1.4- The need for eSafety when using the internet, email, social media, online gaming Minimise the potential danger of using: The internet including only using trusted websites recommended by teachers, using a search engine that only allows access to age appropriate websites.

30:00
Lesson-8.1.5- Email including an awareness of the potential dangers of opening or replying to an email from an unknown person. An awareness of the risks associated with sending personal identifiable data or images via email.

30:00
Lesson-8.1.6- Social media including knowing how to block and report unwanted users, an awareness of the potential dangers of meeting an online contact face to face, avoiding the distribution of inappropriate images, avoiding the use of inappropriate language, respecting confidentiality of personal data of other people Online gaming including not using real names, not giving out personal or financial data.

40:00
Lesson-8.1.7- Characteristics and effect of threats to data including hacking, phishing, pharming, smishing, vishing, viruses, malware, card fraud Hacking including the measures that must be taken in order to protect data.

30:00
Lesson-8.1.8- Phishing, pharming, smishing, vishing including the methods that can be used to help prevent them Viruses and malware including how to take preventative action to avoid the danger of infecting a computer from a downloaded file Card fraud including shoulder surfing, card cloning, key logging.

25:00
Lesson-8.1.9- Characteristics and methods of protecting data including biometrics, digital certificate, secure socket layer (SSL), encryption, firewall, two-factor authentication, user id and password.

30:00
Lesson-8.1.10-Biometrics including the use of biometric data Digital certificate including its purpose and contents Secure socket layer (SSL) including encrypted links between the server and the client computer.

25:00
Lesson-8.1.11- Encryption including its purpose for the protection of data on hard discs, email, cloud, HTTPS websites Firewall including its purpose Two-factor authentication including its purpose and function User id and password including how they are used to increase the security of data.

20:00
Assignments-8.1
Quiz-8.1

Chapter-9. Audience

Chapter-10. Communication

Lesson-10.1.1- Characteristics, uses and constraints of email communication including acceptable language, guidelines set by an employer, the need for security, netiquette, email groups, carbon copy (cc), blind carbon copy (bcc), forward, attachments Characteristics and effects of spam email including the methods which can be used to help prevent spam.

00:00
Lesson-10.1.2- Characteristics, uses, advantages and disadvantages of using the internet including the differences between the internet, an intranet, an extranet and the World Wide Web (WWW), blog, forum, wiki, social networking.

00:00
Lesson-10.1.3- Functionality including Internet Service Provider (ISP), structure of a web address, Uniform Resource Locator (URL), hyperlink, web browser.

00:00
Lesson-10.1.4- Use of search engine including speed of searching, amount of information, the speed of finding relevant information, ease of finding reliable information Evaluating the information found on the internet including how up to date, reliable, biased and valid this information is.

00:00
Lesson-10.1.5- Internet protocols including HyperText Transfer Protocol (HTTP), HyperText Transfer Protocol secure variant (HTTPS), File Transfer Protocol (FTP), Secure Socket Layer (SSL).

00:00
Lesson-10.1.6- Risks of using the internet including inappropriate and criminal material, restricting data through parental, educational and ISP control.

00:00
Assignments-10.1
Quiz-10.1

Chapter-11. File management

Lesson-11.1.1- Locate stored files Open and import files of different types Save files in a planned hierarchical directory/folder structure.

00:00
Lesson-11.1.2- Save files using appropriate file names Save and print files in a variety of formats including a document, screenshots, database reports, data tables, graphs/charts, a web page in browser view, a web page in HTML view.

00:00
Lesson-11.1.3- Save and export in the file format of an application package including .docx, .doc, .xlsx, .xls, .sdb, .sdc, .accdb .odb, .rtf, .pptx, .ppt

00:00
Lesson-11.1.4- Save and export in a generic file format including .csv, .txt, .rtf, .pdf, .css, .htm, .jpg, .png

00:00
Lesson-11.1.5- Characteristics and uses of file formats including css, csv, gif, htm, jpg, pdf, png, rtf, txt, zip, rar The need for generic file formats.

00:00
Lesson-11.1.6- Reduce file sizes for storage or transmission where necessary using file compression including .zip, .rar

00:00
Lesson-11.1.7-The need to reduce file sizes for storage or transmission.

00:00
Assignments-11.1
Quiz-11.1

Chapter-12. Images

Chapter-13. Layout

Lesson-13.1.1- EEnter and modify text and numbers with total accuracy Use editing techniques to manipulate text and numbers including highlight, delete, move, cut, copy, paste, drag and drop.

00:00
Lesson-13.1.2-Place objects into the document from a variety of sources including text, image, screenshot, shapes, table, graph or chart, spreadsheet extract, database extract.

00:00
Lesson-13.1.3- Wrap text around a table, chart or image including above, below, square and tight .

00:00
Lesson-13.1.4- Create a table with a specified number of rows and columns Place text or objects in a table.

00:00
Lesson-13.1.5- Edit a table and its contents including insert row(s) and column(s), delete row(s) and column(s), merge cells.

00:00
Lesson-13.1.6- Format a table including to set horizontal cell alignment (left, right, centre, fully justified), set vertical cell alignment (top, middle, bottom), show gridlines, hide gridlines, wrap text within a cell, shading/colouring cells, adjust row height, adjust column width.

00:00
Lesson-13.1.7- Create or edit headers and footers Align the contents of the header and footer consistently within a document including to left margin, right margin and centred within margins Place text and automated objects in headers and footers including file information, page numbering, total number of pages, date, time.

00:00
Assignments-13.1
Quiz-13.1

Chapter-14. Styles

Chapter-15. Proofing

Lesson-15.1.1- Use automated software tools (spell check, grammar check) and make appropriate changes to ensure all work produced contains as few errors as possible Use validation routines to minimize data entry errors.

00:00
Lesson-15.1.2- Automated suggestions given by spell check software do not always give the correct response.

00:00
Lesson-15.1.3- Importance, characteristics and uses of appropriate validation including range check, character check, length check, type check, format check, presence check.

00:00
Lesson-15.1.4- Identify and correct data entry errors including transposed numbers, incorrect spelling, inconsistent character spacing, inconsistent case.

00:00
Lesson-15.1.5- Identify and correct inconsistent line spacing, remove blank pages/slides, remove widows/orphans, inconsistent or incorrect application of styles, ensure that tables and lists are not split over columns or pages/slides.

00:00
Lesson-15.1.6- Importance, characteristics and uses of verification including visual checking and double data entry to reduce data entry errors The need for validation as well as verification.

00:00
Assignments-15.1
Quiz-15.1

Chapter-16- Graphs and charts

Chapter-17. Document production

Chapter-18. Databases

Lesson-18.1.1- Import data from existing files (including .csv, .txt) using specified field names to create tables Set appropriate data types to fields including text, numeric (integer, decimal, currency), date/time, Boolean/logical.

00:00
Lesson-18.1.2- Set sub-types of numeric data including percentage, number of decimal places Set display format of Boolean/logical field (yes/no, true/false, checkbox.

00:00
Lesson-18.1.3- Set display format of date/time data Create and edit primary and foreign keys Create relationships between tables.

00:00
Lesson-18.1.4- Create a data entry form including specified fields, appropriate font styles and sizes, appropriate spacing between fields, character spacing of individual fields, use of white space, radio buttons, check boxes, drop down menus.

00:00
Lesson-18.1.5- Characteristics, uses, advantages and disadvantages of a flat file and a relational database.

00:00
Lesson-18.1.6- Characteristics of primary key and foreign keys.

00:00
Lesson-18.1.7- Characteristics of good form design.

00:00
Lesson18.1.8- Use arithmetic operations or numeric functions to perform calculations including calculated fields, calculated controls.

00:00
Lesson-18.1.9- Use formulae and functions to perform calculations at run time including addition, subtraction, multiplication, division, sum, average, maximum, minimum, count.

00:00
Lesson-18.1.10- Use a single criterion, or multiple criteria to sort data into ascending or descending order.

00:00
Lesson-18.1.11- Use a single criterion, or multiple criteria to select subsets of data using a query perform searches using a variety of operators including AND, OR, NOT, LIKE, >, =, <=, perform searches using wildcards.

00:00
Lesson-18.1.12- Produce reports to display data including displaying all the required data and labels in full.

00:00
Lesson-18.1.13- Use appropriate headers and footers within a database report including report header, report footer, page header, page footer Set report titles.

00:00
Lesson-18.1.14- Produce different output layouts including controlling the display of data, labels, tabular or columnar format.

00:00
Lesson-18.1.15- Align data and labels appropriately including right aligning numeric data and decimal alignment Control the display format of numeric data including number of decimal places, currency symbol, percentage.

00:00
Assignments-18.1
Quiz-18.1

Chapter-19. Presentations

Lesson-19.1.1- Insert and edit objects consistently including images, text, shapes, logos, slide headers and footers, placeholder position, automated slide numbering Format master slide objects including headings, subheadings, bullets, background colour.

00:00
Lesson-19.1.2- Apply slide layout Insert a new slide Move or delete a slide Insert and edit objects on a slide including text (headings, subheadings, bulleted lists), images (still images, video clips, animated images), charts, tables, audio clips (sound), symbols, lines, arrows, call out boxes and shapes.

00:00
Lesson-19.1.3- Add presenter notes Insert and edit a hyperlink including linking text or objects to a slide within the presentation, an external file or an email address Insert an action button including modifying settings to navigate to a specified slide or file.

00:00
Lesson-19.1.4- Add alternative text/screentip to an object Apply consistent transitions between slides Apply consistent animation effects on text, images and other objects Hide slides within a presentation.

00:00
Lesson-19.1.5- Display the presentation for a variety of purposes including looped on-screen carousel, presenter controlled.

00:00
Lesson-19.1.6- Print the presentation in a variety of layouts including full page slides, presenter notes, handouts.

00:00
Assignments-19.1
Quiz-19.1

Chapter-20. Spreadsheets

Lesson-20.1.1- Insert cell(s), row(s) and column(s), delete cell(s), row(s) and column(s), merge cells.

00:00
Lesson-20.1.2- Create formulae using cell references Replicate formulae using absolute and relative cell references where appropriate.

00:00
Lesson-20.1.3- Use arithmetic operators in formulae including add, subtract, multiply, divide, indices Use named cells and named ranges.

00:00
Lesson-20.1.4- Use functions including sum, average, maximum, minimum, integer, rounding, counting, LOOKUP, VLOOKUP, HLOOKUP, XLOOKUP, IF

00:00
Lesson-20.1.5- Use external data sources within functions Use nested functions.

00:00
Lesson-20.1.6- The difference between a formula and a function. The order in which mathematical operations are performed including the use brackets to make sure that formulae work.

00:00
Lesson-20.1.7- Characteristics and use of absolute and relative cell referencing.

00:00
Lesson-20.1.8- Using a single criterion, or multiple criteria sort data into ascending or descending order.

00:00
Lesson-20.1.9- Using a single criterion, or multiple criteria, select subsets of data Perform searches using a variety of operators including AND, OR, NOT, >, =, <=, Perform searches using wildcards.

00:00
Lesson-20.1.10- Display either formulae or values Adjust row height, column width and cell sizes so that all data, labels, and formulae is fully visible Wrap text within cells so that all data is fully visible Hide and display rows and columns.

00:00
Lesson-20.1.11- Enhance a spreadsheet including text colour, cell colour, bold, underline, italic, shading Format numeric data appropriately including to display the number of decimal places, different currency symbols, percentages.

00:00
Lesson-20.1.12- Use conditional formatting to change the display format depending on the contents of a cell.

00:00
Lesson-20.1.13- Set the orientation to portrait or landscape Control the page layout to print including specified number of pages, print area, display or hide gridlines, display or hide row and column headings.

00:00
Assignments-20.1
Quiz-20.1

Chapter-21. Website Authoring

Lesson-21.1.1- Content layer is used to enter the content and create the structure of a web page Presentation layer is used to display and format elements within a web page.

00:00
Lesson-21.1.2-Behaviour layer is for a scripting language to control elements within a web page.

00:00
Lesson-21.1.3- Create the content layer of a web page.

00:00
Lesson-21.1.4- Place appropriate elements in the head section of a web page including: • insert a page title to display in the browser • attach external stylesheets (with the correct hierarchy, using a relative file path) • metatags to use the appropriate attributes including to define the charset, name attributes (description, keywords, author, viewport), content attributes • default target windows.

00:00
Lesson-21.1.5- Place appropriate content in the body section of a web page Insert a table including table header, table rows, table data.

00:00
Lesson-21.1.6- Use appropriate table attributes to meet the needs of the audience including to adjust cells to span more than one row or column, to set table and cell sizes in terms of pixels or % values, to apply styles to tables.

00:00
Lesson-21.1.7- Insert appropriate objects into a web page including text, images, sound clips, video (display controls, remove controls, autoplay), to adjust image or video size, aspect ratio and apply alternate text.

00:00
Lesson-21.1.8- Use the tag including to apply styles and classes Apply tags to text within a web page to display predefined styles including h1, h2, h3, p, li

00:00
Lesson-21.1.9- Apply classes to elements within a web page Apply styles to elements within a web page including to a list (ordered list, unordered list) Create a bookmark within a web page using an id attribute.

00:00
Lesson-21.1.10- Create hyperlinks from text and images to: • bookmarks on the same page • other locally stored web pages • a website using the URL • send mail to a specified email address • to open in a specified location (the same window, a new window, with a window named as specified).

00:00
Lesson-21.1.11- Purpose of the head and body sections of a web page The reason tables are used to structure elements within a web page.

00:00
Lesson-21.1.12- Function of metatags including to define: the charset, keywords for search engines, the author of the web page, a description of the web page, the viewport (to make your web page display on all devices) Function of a hyperlink.

00:00
Lesson-21.1.13- Concept of a bookmark including methods of creating a bookmark within a web page Function of an anchor Relative file path and absolute file path including the reason absolute file paths must not be used for hyperlinks to locally saved web pages/objects.

00:00
Lesson-21.1.14- Create the presentation layer of a web page Create generic external styles and inline style attributes including: • background properties including colour, images • font properties • table, table row, table header and table data properties including size, background colour, horizontal and vertical alignment, spacing, padding, borders: including collapsed, colour, thickness, visible/invisible.

00:00
Lesson-21.1.15- Create classes including: • background properties including colour, images • font properties • table, table row and table data properties including size, background colour, horizontal and vertical alignment, spacing, padding, borders: including collapsed, colour, thickness, visible/ invisible.

00:00
Lesson-21.1.16- Create external styles to be tagged in a web page including h1, h2, h3, p, li Specify the font properties including font family, size, colour, alignment, bold, italic Attach comments to an external stylesheet Save styles in cascading stylesheet format.

00:00
Lesson-21.1.17- Characteristics of cascading stylesheets including the difference between attached stylesheets and inline style attributes, the hierarchy of multiple attached stylesheets and inline styles within a web page.

00:00
Lesson-21.1.18- Characteristics of a style and a class including the difference between them Reason relative file paths must be used for attached stylesheets.

00:00
Assignments-21.1
Quiz-21.1

Student Ratings & Reviews

No Review Yet

About Course

Cambridge OLevel ICT Crash Course

What Will You Learn?

Course Content

Introduction of ICT

What is ICT?

Chapter-1. Types and components of computer systems

Lesson-1.1.1-Hardware consists of the physical components of a computer system Internal components including Central Processing Unit (CPU), processor, motherboard.

Lesson-1.1.2-Internal memory including random access memory (RAM), read-only memory (ROM).

Lesson-1.1.3- Hardware components including graphics card, sound card, Network Interface Card (NIC), camera, internal/ external storage devices, input and output devices.

Lesson-1.1.4- Software are programs for controlling the operation of a computer or processing of electronic data Applications software provides the services that the user requires to solve a task.

Lesson-1.1.5- Examples of applications software including word processing, spreadsheet, database management systems, control, measurement, applets and apps, video editing, graphics editing, audio editing, computer aided design (CAD).

Lesson-1.1.6- System software provides the services that the computer requires to operate Examples of system software including compilers, linkers, device drivers, operating systems and utilities.

Lesson-1.1.7-Characteristics of analogue and digital data Differences between analogue and digital data The need to convert: • analogue to digital data so it can be processed by a computer • digital data to analogue data so it can be used to control devices.

Lesson-1.1.8- The role of the CPU in processing instructions entered into the computer in order to produce an output. Characteristics of ROM and RAM Differences between ROM and RAM.

Lesson-1.1.9- Characteristics of input and output devices Differences between input and output devices.

Lesson-1.1.10- Characteristics of backing storage Differences between backing storage and internal memory.

Lesson-1.1.11- Characteristics of operating systems including: Command Line Interface (CLI), Graphical User Interface (GUI), dialogue based and gesture based interface.

Lesson-1.1.12- Differences between types of operating systems Advantages and disadvantages of the different types of operating systems.

Lesson-1.1.13- Characteristics of a desktop computer Uses of a desktop computer including office and business management, education, gaming and entertainment.

Lesson-1.1.15- Impact on everyday life including Artificial Intelligence (AI), extended reality (virtual and augmented).

Assignments-1.1

Quiz-1.1

Chapter-2. Input and output devices We will discuss the memory & processors, How they work. How memory and processor related to each other through their job.

Lesson-2.1.1- Characteristics, uses, advantages and disadvantages of input devices including: keyboard, numeric keypad, pointing devices, remote control, joystick/driving wheel, touch screen (as an input device), scanners, camera, microphone, sensors, light pen.

Lesson-2.1.3- Characteristics, uses, advantages and disadvantages of output devices including: monitors, touch screen (as an output device), multimedia projector, laser printer, inkjet printer, dot matrix printer, plotter, 3D printers, speaker, actuator.

Assignments-2.1

Quiz-2.0

Chapter-3. Storage devices and media 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,

Lesson-3.1.1- Characteristics, uses, media, advantages and disadvantages of storage devices including magnetic, optical and solid-state.

Lesson-3.1.2- Magnetic drives including fixed and portable magnetic hard drives, magnetic tape drives Optical drives including CD, DVD, Blu-ray Fixed and portable solid-state drive (SSD) including SSD, pen drive, flash drive.

Lesson-3.1.3- Characteristics, uses, advantages and disadvantages of storage media including magnetic, optical and solid-state.

Lesson-3.1.4- Magnetic drives including magnetic hard disks, magnetic tape Optical discs including CD, DVD, Blu-ray Solid-state media including memory cards (SD, xD, CFast).

Assignments-3.1

Quiz-3.1

Lesson-4.1.1- The operation and purpose of a router including: • connecting networks and devices to the internet • storing computer addresses in a router • routing data packets.

Lesson-4.1.2- Including: network interface cards (NIC), hubs, bridges, switches.

Lesson-4.1.3-The uses of wi-fi and Bluetooth Connecting a device to a network using: • wi-fi • Bluetooth Similarities and differences between Bluetooth and wi-fi

Lesson-4.1.4- The characteristics, uses and issues relating to cloud computing How data is stored, managed and shared using cloud computing Advantages and disadvantages of using cloud storage compared to other methods.

Lesson-4.1.5- Characteristics, uses and purpose of an extranet, intranet and the internet The differences and similarities between an extranet, intranet and the internet.

Lesson-4.1.6- Local Area Network (LAN), Wireless Local Area Network (WLAN), Wide Area Network (WAN) and the differences between these networks.

Lesson-4.1.7- Privacy and confidentiality of data transfer. Avoiding password interception by using up to date anti-spyware and regularly changing passwords The differences between strong and weak passwords.

Lesson-4.1.8- Including: zero login, biometric methods, magnetic stripes, smart cards, physical tokens, electronic tokens.

Lesson-4.1.9- Including the use of anti-malware and anti-virus software The operation of removing/quarantining viruses using up to date software.

Lesson-4.1.10- Scanning the storage media used to transfer data Scanning the data/software when downloading.

Lesson-4.1.11- Characteristics, uses, advantages and disadvantages of video-conferencing, audio-conferencing, web-conferencing The hardware, software and network connection required to set up each type of electronic conference.

Assignments-4.1

Quiz-4.1

Quiz-4.2

Chapter-5. The effects of using IT

Lesson-5.1.1- The positive and negative effects of microprocessors/ smart devices in monitoring and controlling devices in the home including the impact on lifestyle, leisure time, physical fitness, security of data, the degree of social interaction.

Lesson-5.1.1- The positive and negative effects of microprocessors/ smart devices in monitoring and controlling transport including security of data, autonomous vehicles, transport safety.

Lesson-5.1.3- Including: repetitive strain injury (RSI), back problems, eye problems, headaches.

Lesson-5.1.4- The causes of these health issues and strategies for preventing them.

Assignments-5.1

Quiz-5.1

Chapter-6. ICT Applications

Lesson-6.1.1- Characteristics and uses including newsletters, posters, websites, multimedia presentations, audio, video, media streaming and ePublications

Lesson-6.1.2- The use of mobile devices for communication including: SMS messaging, phone calls, Voice over Internet Protocol (VoIP), video calls, accessing the internet.

Lesson-6.1.3- Including: personal finance, bridge and building design, flood water management, traffic management, weather forecasting Advantages and disadvantages of using computer modelling rather than humans.

Lesson-6.1.4- Including: robotics in manufacture, production line control, autonomous vehicles Advantages and disadvantages of using computer controlled systems rather than humans.

Lesson-6.1.5- Systems are used to manage learner registration and attendance Systems are used to record learner performance including computer aided learning.

Lesson-6.1.6- Characteristics, uses, advantages and disadvantages of online booking systems including travel industry, concerts, cinemas, sporting events.

Lesson-6.1.7- Characteristics, uses, advantages and disadvantages of Automatic Teller Machines (ATM) including: withdrawing cash, depositing cash or cheques, checking account balance, mini statements, bill paying, money transfers.

Lesson-6.1.8- Characteristics, uses, advantages and disadvantages of Electronic Funds Transfer (EFT), credit/debit card transactions, cheques, internet banking.

Lesson-6.1.9- Characteristics and uses of patient records, pharmacy records.

Lesson-6.1.10- 3D printers Including printing of prosthetics, tissue engineering, artificial blood vessels, customized medicines.

Lesson-6.1.11- Characteristics, uses and purpose of expert systems including mineral prospecting, car engine fault diagnosis, medical diagnosis, chess games, financial planning, route scheduling for delivery vehicles, plant and animal identification.

Lesson-6.1.12- Components of an expert system: user interface, inference engine, knowledge base, rules base, explanation system How an expert system is used to produce possible solutions for different scenarios.

Lesson-6.1.13-Characteristics and uses of computers in the retail industry including point of sale (POS) terminals and electronic funds transfer at point of sale (EFTPOS) terminals.

Lesson-6.1.14- Point of sale (POS) terminals including updating stock files automatically and ordering new stock automatically.

Lesson-6.1.16- Characteristics, advantages and disadvantages of internet shopping.

Lesson-6.1.17- Characteristics, uses, advantages and disadvantages of: Optical Mark Recognition (OMR) including school registers, multiple-choice examination papers, barcode, QR code.

Lesson-6.1.18- Optical Character Recognition (OCR) including automated number plate recognition (ANPR) systems Radio Frequency Identification Device (RFID) including tracking stock, passports, automobiles, contactless payment.

Lesson-6.1.19-Near Field Communication (NFC) including payment using a smartphone Biometric recognition including face, iris, retina, finger, thumb, hand, voice.

Lesson-6.1.20- Characteristics, uses, advantages and disadvantages of satellite systems including Global Positioning Systems (GPS), satellite navigation, Geographic Information Systems (GIS), media communication systems (satellite television, satellite phone.

Assignments-6.0

Quiz-6.0

Chapter-7. The systems life cycle

Lesson-7.1.1- Characteristics, uses, advantages and disadvantages of the research methods of observation, interviews, questionnaires and examination of existing documents.

Chapter-2. Input and output devices
We will discuss the memory & processors, How they work. How memory and processor related to each other through their job.

Chapter-3. Storage devices and media
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,