See more ideas about computer science, gcse computer science and computer programming. Software and operating systems teach computer science. Full course content for gcse computer science 91 every single course specification objective addressed in a lesson staggering amount of lesson plans, workbooks and resources for a level computer science over 700 files all designed to help you teach lesson presentations made by teachers all you need to do is load them up and teach. Coding databases a welldesigned database will code data that appears many times, rather than entering full terms. The code identifies the card and also the maker of that card. Our modules can be used with all exam boards, with mapping tables to help you align to ocr, aqa, or edexcel spec. Data conversion denary to binary denary to hexadecimal binary to denary binary to hexadecimal computer systems input process output types of systems benefits and concerns of computer systems. Home gcse study tools computing computer science databases. Foreign key a reference to a primary key in a relational database table. Databases gcserevision, ict, software, databases revision world. Dec 03, 2014 a short video that serves as an introduction to this database focused chapter. Microsoft mapping document for edexcel gcse computing at school. Over 200 gcse computer science lessons to teach any computer science topic in the classroom. Gcse computing databases learning resources for adults, children, parents and teachers.
Learn computing is a site made by teachers of computer science specifically to aid other teachers of computer science. A good test of whether they understand the structure of a standard sql search query. System software includes the operating system and utility programs. Computer science databases flashcards in gcse computing. This publication sets out the learning outcomes and content coverage required for gcse specifications in. Video thumbnail for dr macs gcse ict revision databases. This publication sets out the learning outcomes and content coverage required for. It is a 48 bit binary number stored within the card hardware itself. Author mr ali posted on march 16, 2015 march 17, 2015 categories databases, gcse computing, uncategorized tags creating queries, databses post. A database is made up of one or more related files or tables in microsoft access. Table where data is organised and stored in a database.
Ict is really just admin work or something, writing word documents and spreadsheets. This means that the way in which the data was organised and the way in which it was accessed were both decided by the requirements of the application that. Database software access presentations software powerpoint graphics. Introducing databases gcse computer science revision bbc. Some examples of software includes operating system, word processors, databases, games and utilities. Gcse computingcomponents of a computer system wikibooks. Gcse computing databases practice mr alis ict blog. The computer misuse act is there to make sure that computers are used for their intended purpose only. Mr gristwood talks about gcse computing database section of the specification. Types of databases this section focuses on different types of databases, in particular, flatfile and relational databases. Database keywords keyword definition database persistent organised store of data. Year 11 computing students study for gcse computing, offered by the ocr examination board.
Learn about why databases are used to store data and they are vital to many areas of computing with gcse bitesize computer science. This is the unique identifier assigned to a network card or wifi adapter. A file is a collection of related records related records means that each record in a file will contain the same sort of information as all the other records. Gcse computingdatabases wikibooks, open books for an. Use these as revision guides to help students prepare for the mysql practical investigation for a452 controlled assessment june 2017 submission. Gcse computing online, based on the pioneering ocr gcse in computing launched in 2011. Learn vocabulary, terms, and more with flashcards, games, and other study tools. Many modern databases are described as being relational. Students work in pairs to turn over two cards and matchup a keyword with a definition or example. Which database field type would be used to store a customers account balance. This can include things like the cpu, harddrive, printer, mouse and so on. Students are asked to act as records and respond to sql queries about benign pieces of personal data. Learn faster with brainscape on your web, iphone, or android device. Boolean operators which can be used in sql queries for example.
Read more on ip and mac addresses or sign up to download our gcse computer science resources today. They were produced by question setters, primarily for the benefit of the examiners. Solution notes are available for many past questions. Available for the mac, it lets you create and manage a plethora of relational databases from one user interface, including the likes of mysql, sqlite, redis, amazon redshift and postgres. Gcse computing revision session ultimate quiz quiz quizizz. Trusted by over 4,000 computer science teachers in the uk and abroad who use our resources in their classroom. Computing involves things like creating websites, applications and working with hardware or databases etc. Study tom torgersons flashcards for their harrogate grammar class now. An ip address is the location of your device on the internet, whilst a mac address identifies the actual device. Our goal is to arm you with the resources you need to deliver inspiring lessons that promote progress and high attainment. There will be 20 hours of controlled assessment in each year. Ip and mac addresses gcse computer science revision. We were the first year to do computing, teacher abandoned us after her shit teaching and the whole ocr mess and started the whole course again in year 11 with a more experienced teacher but then again we still couldnt get all the theory done and no exam practice until last week or.
Targeted revision booklets hardware software data representation databases networks and the internet. People often get confused trying to understand the difference between ip and mac addresses. Contains the destination ip address or mac address if. This is a bitesized summary of theory for your gcse computing. Customized coursework help has never been that accessible. Microsoft windows xp, microsoft windows 7, mac os x, linux and unix are. A database is made up of one or more related files or tables in microsoft access a file is made up of one or more related records records are made up of one or more related fields a field is made up of a group of related characters. Gcse computing online flashcards by tom torgerson brainscape. Students are given instructions about creating a revision podcast based on this topic subscription only task. Entity something in real life about which we store data. Quizlet flashcards, activities and games help you improve your grades. This website and its content is subject to our terms and conditions. In this case it is the task of being able to uniquely identify every computer connected to an ip based network.
We were the first year to do computing, teacher abandoned us after her shit teaching and the whole ocr mess and started the whole course again in year 11 with a more experienced teacher but then again we still couldnt get all the theory done and no exam practice until last week or before the holidays, cant remember. On a computer, the mac address is a unique code built into a nic. An ip address is the location of your device on the internet, and a mac address identifies the actual device. Generalpurpose packages a generalpurpose application package is a type of software that can perform many different related tasks. Due to these circumstances i am going to be covering the whole course in a year, not ideal for a first timer but i like being in at the deep end keeps me on my toes. A short video that serves as an introduction to this database focused chapter. Please respect the community by not trashing this page. Flat file database a database that stores data in a single table. Information in computerbased filing systems is stored in data files. Gcse computing assessment overview schemes of assessment are untiered, ranging from a to g, less than a g grade will result in unclassified quality of written work will also be assessed. This scale is known as the uniform mark scalescore ums. For this unit a451 it is essential that you use your own time to read around what is covered in class.
The difficulty of asa level and gcse exam papers may vary from year to year, so in order to ensure fairness and consistency across years and within subjects the raw examination marks are converted into a common scale. Database data types database field database queries database record database table database validation primary key what is a. Databases are one of the most powerful tools that people use to help them handle large amounts of information. Computer systems and programming gcse computing examination 1 hour 30. Awardwinning tutorials, tips and advice on gcse ict coursework and exams for students, parents and teachers. Database theory and quizzes for computer science gcse. Highquality learning content delivered online at the core of cambridge gcse computing. Gcse computer science learning resources for adults, children, parents and teachers organised by topic. Im currently in year 11 and halfway through the course, my exam board is. These numbers, also known as hardware addresses or physical addresses, are either installed in the network hardware during the manufacturing process, or are saved in firmware, and intended to never be altered.
Page 1 of 2 gcse computing science revision material year 11 to help you prepare for the a451 examination in the summer term, here are lots of revision resources for you to use. A prime advantage of modern databases is that the database and applications that use the data can be altered independently of each other. Select name from teachers where subject the three main parts of an sql query for example. Ict and computer science at gcse, it is anticipated that the programme followed by your child during key stage 3 will look something like this. A welldesigned database will code data that appears many times, rather than entering full terms. Gcse computingdatabases wikibooks, open books for an open. Gcse computing i was given two gcse computing classes to teach from september one first year and one second year. As the uks first online gcse computing course, it will provide an opportunity for teachers and students to reach higher in this dynamic area of the curriculum. Students have three lessons per week, usually with one teacher. Coursework help provided by best academic writing service. Jan 26, 2015 gcse subject content for computer science. Your teachers will cover all the syllabus and topics required but in order to retain and apply the knowledge gained you need to regularly and repeatedly apply this knowledge to a range of different situations. Gcse computing revision session ultimate quiz draft.
714 134 73 180 559 58 200 1194 187 1417 759 296 625 190 157 1460 1175 645 225 87 438 1287 383 1085 463 1447 486 1214 1058 450 1185 1092 1149 1025 488 931 1033 822