Edexcel Computer Science Year 11 – Revision Topics



centercenterAlison BartonBelper school??Edexcel Computer Science Year 11 – Revision Topics882000Alison BartonBelper school??Edexcel Computer Science Year 11 – Revision TopicsYear 11 – Revision Topics for Final examTopic 3 - DataYou already have the list of topics that you should have covered for the mock exam at the beginning of the school term. We now need to make sure that you have an understanding of the theory. Data representationWhat is ASCII – what does it stand for? How does it represent a character? What is Unicode – Why was Unicode developed –Data standardsIn the table below add the data standards (File Types)Type of dataStandards includeImagesSoundMoving imagesAlphanumericOutline graphics/fontsBitmaps and Binary ImagesWhat is a bitmap – What is a pixel – What is a one-bit monochrome – What is an 8 bit grey – What is 24 bit colour – What is resolution –Analogue and Digital dataWhat is analogue data – What is digital data – Data Storage and CompressionA bit has a value of A nibble is A byte is A kilobyte is A megabyte is What does GB stand for? What does TB stand for? What does PB stand for? What does EB stand for? What does ZB stand for? What does YB stand for? Why do we use data compression?What is lossless compression? –Where is lossless compression used? –What is lossy compression? –How does lossy compression work? – Where can lossy compression be used –Name two file formats that are lossy What is RLE? –How does RLE work? –Calculating data transmission speeds – remember this!Bandwidth is not measured in bytes it is measured in bits. I byte contains 8 bits so a computer receiving 5KB BANDWIDTH (5000 bytes) in a second it would take 8 seconds for it to receive a file of 40KBData Encryption Why do we encrypt data – What does encrypt mean – What does decipher mean – What is Caesar Cipher how does it work – Below is a message sent in cipher with a shift of 1Riddle – what is the clumsiest bee?Answer – b cvncmjoh cff DatabasesWrite a paragraph explaining what a database is. What is a table – What is a record – What is a row – What is a column – What is a field – What is a query – What is a primary key - What is a relationship – What is an index – What is SQL – Name 4 SQL statements - for each one explain how they work DELETE - CREATE - INSERT – UPDATE – SELECT – WHERE – SORT Year 11 – Revision Topics for Final examTopic 4 – ComputersMachines and computational models Draw the input – Process – Output – Storage modelWrite a sentence explaining what each part of the model does What is a parallel algorithm? What is a sequential algorithm?HardwareThis is the name given to a collection of physical things that when put together in a particular way form a systemWhat is a motherboard? How does the motherboard communicate with the other components such as the CPU and Memory How is data transferred on a motherboard –How is the speed of data transmitted on a motherboard measured? – What is a CPU –Thinking about the CPU explain what each component does3322320762000Control Unit –ALU – Registers Internal Clock –Internal Buses Logic Gates – 3704590190500Describe the FETCH – DECODE - EXECUTE cycle MemoryTHIS IS NOT STORAGE AND HAS NOTHING TO DO WITH SAVING FILES!Where does the CPU not get data from? – What is the super-fast memory called? What are the two types of memory? –What is a hard disk drive, explain the advantages and disadvantages of this kind of storage –What is flash memory explain the advantages and disadvantages of this kind of storage –What is an optical drive explain the advantages and disadvantages of this kind of storage –SoftwareWhat is an Operating System – List 5 operating systems –What tasks does an operating system perform, describe in as much detail as you can –Programming LanguagesWhat is a high-level programming language? Give a couple of examples –What is a low-level programming language? Give a couple of examples – What is a complier –What is an interpreter –Write a paragraph that discusses the advantages and disadvantages of a) Python b) JAVA c) C##Year 11 – Revision Topics for Final examTopic 5 – Communication and the InternetNetworksWhat is a computer network – What are the advantages of a network –What are the disadvantages of a network –Write a definition for the list belowServer -Client –Network Interface card (NIC) –User –Protocol – What is a LAN - What is a WAN – What is a PAN –What is a VPN – Write a short paragraph to explain the advantages and disadvantages of copper cable as a medium to transmit data – Write a short paragraph to explain the advantages and disadvantages of fibre optic as a medium to transmit data – Write a short paragraph to explain the advantages and disadvantages of wireless as a medium to transmit data - What is bandwidth, how is it measured –What is a network protocol –What is addressing –What is TCP/IP –What is a checksum – What is an IP address –What is a MAC address – Draw a Bus topology – List the advantages and disadvantages –Draw a Ring topology – List the advantages and disadvantages –Draw a Star topology – List the advantages and disadvantages –Draw a Mesh topology – List the advantages and disadvantages –The Internet and the WWWWhat is the Internet - What is the WWW – What is a web page – What is a website – What is a web address –What language is used to create webpages - What is an ISP –What is HTTP –11430021907500What is CSS –Write a paragraph that explains how the Client –Server Model works What is the difference between client side and server side processing - What is a cookie - Year 11 – Revision Topics for Final examTopic 6 – The bigger pictureEmerging Trends, issues and impactWrite a short essay that explains the advantages and disadvantages of Quantum computing Write a short essay that explains the advantages and disadvantages of DNA computing Write a short essay that explains the advantages and disadvantages of Artificial Intelligence Write a short essay that explains the advantages and disadvantages of Nano Technology Write a short essay that explains the advantages and disadvantages of Cloud computing Write a short essay that considers the issues that arise from File sharingThe digital divideEmail PrivacyPlagiarismSoftware Piracy HackingInvasion of privacyComputer virusesOnline gamblingWhat does IP stand for and why is it important – What is Open source software – how does it differ from software like Microsoft Office - what are the advantages and disadvantages of using this type of software What is propriety software, what are the advantages and disadvantages of using this type of software ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download