Course Content
Chapter 1: Problem Solving: Algorithms, Decomposition, and Abstraction
0/4
Lesson 1.1.1: Be able to produce algorithms using flowcharts and structured English
00:00
Lesson 1.1.2: Understand how bubble sort and linear search algorithms work
00:00
Lesson 1.1.3: Be able to look for the most efficient solution when comparing alternative algorithms for the same problem
00:00
Lesson 1.1.4: Be able to design and use computational abstractions that model the state and behavior of real-world problems and physical systems
00:00
Chapter 2: Programming and Development
0/10
Lesson 2.1.1: Be able to write and interpret programs in a high-level textual programming language. Any code in questions will use Python 3 code
00:00
Lesson 2.1.2: Understand the purpose and use of variables, sequence, selection, and repetition/iteration when writing programs
00:00
Lesson 2.1.3: Understand the need for and how to use data structures (records, one-dimensional arrays/lists)
00:00
Lesson 2.1.4: Understand the need for and how to manipulate strings
00:00
Lesson – 2.1.5: Understand the purpose of subprograms and the role of arguments, parameters, return values, and local variables in subprograms
00:00
Lesson – 2.1.6: Understand the purpose of, and how to use, arithmetic operators (add, subtract, divide, multiply, modulus, integer division) and the order of operations (BIDMAS)
00:00
Lesson – 2.1.7: Understand the purpose of, and how to use, relational operators (equal to, less than, greater than, not equal to, less than or equal to, greater than or equal to)
00:00
Lesson – 2.1.8: Understand the purpose of, and how to use, logical operators (AND, OR, NOT)
00:00
Lesson – 2.1.9: Understand the need for and use of pre-existing (built-in, library) subprograms in high-level programming languages
00:00
Lesson – 2.1.10: Be able to locate and fix logical and syntax errors in a program
00:00
Chapter 3: Data Representation
0/8
Lesson – 3.1.1: Be able to convert between binary and denary positive integers (0–255)
00:00
Lesson – 3.1.2: Be able to add two positive binary numbers
00:00
Lesson – 3.1.3: Understand how computers use binary to represent data (numbers, text, sound, graphics) and program instructions
00:00
Lesson – 3.1.4: Understand why and how computers encode characters using ASCII and Unicode
00:00
Lesson – 3.1.5: Understand how bitmap images are represented in binary (pixels, resolution, color depth (2-bit max))
00:00
Lesson – 3.1.6: Understand how sound is represented in binary (sample rate, amplitude, bit-depth)
00:00
Lesson – 3.1.7: Understand the terms describing the capacity of storage (bit, byte, kibibyte, mebibyte, gibibyte)
00:00
Lesson – 3.1.8: Be able to convert storage capacities into different units of measurement
00:00
Chapter 4: Computers: Hardware, Processing, and Software
0/8
Lesson – 4.1.1: Understand the function of the hardware components of a computer system (central processing unit (CPU), main memory, secondary storage, input and output devices)
00:00
Lesson – 4.1.2: Know that data and instructions are stored in main memory and instructions are executed in the CPU
00:00
Lesson – 4.1.3: Understand the function of random-access memory (RAM) and read-only memory (ROM)
00:00
Lesson – 4.1.4: Know that an operating system provides an interface between the machine and the user
00:00
Lesson – 4.1.5: Understand the purposes of different software categories (application software, utility software, managing files, compression, backing up, anti-malware (anti-virus, anti-spyware))
00:00
Lesson – 4.1.6: Understand why storage devices (hard-disk drives (HDDs), solid-state drives (SSDs), optical discs, pen drives) are used for a particular task
00:00
Lesson – 4.1.7: Understand the difference between storage devices and the media they use to store data (magnetic, optical, solid state)
00:00
Lesson – 4.1.8: Know the software licensing types (free/open-source software and proprietary software)
00:00
Chapter 5: Communications and Networks
0/15
Lesson – 5.1.1: Understand the different types of networks (local area network (LAN), wide area network (WAN), personal area network (PAN))
00:00
Lesson – 5.1.2: Understand why computers are connected in a network, including the Internet, and the opportunities they offer for communication and collaboration
00:00
Lesson – 5.1.3: Understand benefits and drawbacks of the use of wired and wireless connectivity
00:00
Lesson – 5.1.4: Understand that network data speeds are measured in bits per second (Mbps, Gbps)
00:00
Lesson – 5.1.5: Know that data can be transmitted wirelessly using both Wi-Fi and mobile phone networks
00:00
Lesson – 5.1.6: Understand that data can be transmitted in packets and that control information is provided in the packet header (sender’s address, receiver’s address, sequence number)
00:00
Lesson – 5.1.7: Understand the risks posed to data by missing software security updates, malicious software (malware), malicious USBs/digital devices designed to intercept data
00:00
Lesson – 5.1.8: Know what is meant by the term ‘Internet’
00:00
Lesson – 5.1.9: Know what is meant by the term ‘World Wide Web’
00:00
Lesson – 5.1.10: Understand the components of the WWW (web server URLs, HTTP, HTTPS, HTML)
00:00
Lesson – 5.1.11: Understand the role of components used to access the Internet (modem, router, switch, wireless access point (WAP)) and how these are combined)
00:00
Lesson – 5.1.12: Know the role of web browsers, search engines, and filter software
00:00
Lesson – 5.1.13: Know how digital devices can receive information (satellite, cable, broadcast)
00:00
Lesson – 5.1.14: Understand why appropriate wireless communication protocols (Wi-Fi, Bluetooth®, Near-field Communication (NFC)) should be used for a particular task
00:00
Lesson – 5.1.15: Know that technology enables individuals’ movements and communications to be monitored (CCTV, ID cards, social media posts, GPS location data, eavesdropping)
00:00
Chapter 6: Safe and Responsible Practice
0/4
Lesson – 6.1.1: Understand how to stay safe online (protecting online identity and privacy, recognizing inappropriate content, contact, and conduct, knowing how to report concerns)
00:00
Lesson – 6.1.2: Understand the environmental impact of the manufacture, use, and disposal of technology
00:00
Lesson – 6.1.3: Understand the ethical impact of using technology (privacy, inclusion (digital divide))
00:00
Lesson – 6.1.4: Understand the legal impact of using technology (digital piracy, plagiarism, copyright)
00:00
Chapter 7: Information Technology
0/4
Lesson – 7.1.1: Understand the purpose of software applications (word processing, database management, spreadsheet, web authoring, presentation (multimedia), graphics)
00:00
Lesson – 7.1.2: Understand why different types of data/information are collected and used (primary sources, secondary sources, reliability of data, data analysis to find patterns and trends)
00:00
Lesson – 7.1.3: Understand why digital products should be fit for purpose and suitable for the intended audience
00:00
Lesson – 7.1.4: Understand the need for a house style
00:00
Chapter 8: Software Skills: Word Processing
0/4
Lesson – 8.1.1: Know the purpose of different document types (letter, report, newsletter, memo)
00:00
Lesson – 8.1.2: Understand the importance of, and reasons for using, page layout options (headings, sub-headings, lists, templates, header, footer, page orientation, page breaks, page numbering)
00:00
Lesson – 8.1.3: Understand the use of formatting techniques (font styles and enhancements (bold, italics, color, shading), alignment, grouping, layering, resizing)
00:00
Lesson – 8.1.4: Understand components of a document (charts, diagrams, tables, images, callouts/autoshapes, text from different files, text boxes, values and charts from spreadsheets)
00:00
Chapter 9: Software Skills: Database Management
0/5
Lesson – 9.1.1: Know the difference between a flat file and a relational database
00:00
Lesson – 9.1.2: Understand how a relational database is structured (tables, records, fields, primary keys, foreign keys, relationships)
00:00
Lesson – 9.1.3: Understand field data types (text, number, date/time, logical/Boolean)
00:00
Lesson – 9.1.4: Know how to search/query a database using a single criterion, multiple criteria, and relational and logical operators
00:00
Lesson – 9.1.5: Understand why reports are produced for a specific purpose
00:00
Chapter 10: Software Skills: Spreadsheets
0/6
Lesson – 10.1.1: Understand the formatting options for data in a spreadsheet (currency, percentage, decimal places, date/time)
00:00
Lesson – 10.1.2: Be able to use basic formulae, including add, subtract, multiply, and divide in a spreadsheet
00:00
Lesson – 10.1.3: Be able to use basic functions in a spreadsheet (SUM, AVERAGE, MAX, MIN, COUNT, LEN)
00:00
Lesson – 10.1.4: Understand the reason for using multiple worksheets, sorting and filtering
00:00
Lesson – 10.1.5: Understand the purpose of graphs and charts (pie chart, line graph, bar/column chart, scattergraph)
00:00
Lesson – 10.1.6: Understand the formatting of graphs/charts (title, axis labels, color, legend)
00:00
Chapter 11: Software Skills: Web Authoring
0/3
Lesson – 11.1.1: Know how a web page is structured (head and body)
00:00
Lesson – 11.1.2: Understand the need for and how to use web design terminology, including hyperlinks, bookmarks, and anchors
00:00
Lesson – 11.1.3: Know the role of WYSIWYG (what you see is what you get) software and the use of HTML to create a web page
00:00
Chapter 12: Software Skills: Presentation
0/2
Lesson – 12.1.1: Know the features of presentation software (text and image formatting, inserting buttons, hyperlinks to internal and external content, animation effects, transition effects, embedding multimedia content, including videos)
00:00
Lesson – 12.1.2: Understand the importance of the selection of appropriate images and content to meet the needs of the audience
00:00
Chapter 13: Software Skills: Graphics and Digital Photo-Editing
0/3
Lesson – 13.1.1: Understand the difference between bitmap and vector graphics
00:00
Lesson – 13.1.2: Understand graphics and photo-editing techniques (image adjustment and enhancement, crop, color adjustment, resizing, painting, erasing)
00:00
Lesson – 13.1.3: Understand the use of appropriate file types and compression options to save an image to meet the needs of the audience
00:00
Chapter 14: Software Skills: File Handling
0/3
Lesson – 14.1.1: Understand the use of cloud-based services (hosted applications, hosted storage)
00:00
Lesson – 14.1.2: Understand the use of permission-based file sharing
00:00
Lesson – 14.1.3: Understand the reason for using file compression tools
00:00
K7 Computing Technology: Unleash the Digital World with Arif Sir
    Join the conversation
    Previous
    Next