Struggling to get your head round revision and exams. The computer system finds the current price in its database. Teachict database concepts resources to support the teaching of database theory at gcse level. Please refer to the j276 syllabus to ensure that you are covering the material to the standard required. There are a number of different terms that are used when talking about databases. Specialist application software performs a single very specific type of task. There is an accompanying question sheet which will enable you to check whether students understand datatypes, validation rules and how to write a query in order to extract information from a database. If data is not checked before it is processed any errors could cause the final output to be nonsense. Sorting involves putting the records in a file into a particular order, such as alphabetical order. Shop revise gcse ict practice papers paperback online in dubai. If we teach today as we taught yesterday, we rob our children of tomorrow. New gcse computer science ocr revision guide for the grade 91 course.
Ict activity booklets and exercises teaching resources. This workbook assumes that student know how to set up a simple one table database in access. Data stored on a computer is only useful as long as it is correct and uptodate. We have a brilliant team of more than 60 support team members looking after discussions on the student room, helping to make it a fun, safe and useful place to hang out. We will not be looking at these in detail here as they are covered in other miniwebs operating systems. Teach ict gcse ict network topologies, network hardware. A field is made up of a group of related characters. It is these instructions which tell the hardware that it needs to print a document or save a file or display a web page. A record is made up of lots of individual pieces of information. Gcse ict examples and use of computerised databases teach ict. 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. The syllabus combines theoretical and practical studies focusing on the ability to use common software applications to solve problems, including word processors, spreadsheets, databases, interactive presentation software, web browsers and website design. About us bookshop coursework downloads links revision tips.
System software includes the operating system and utility programs. Play top trumps after each team has printed and cut out their top trump cards, explain the rules see below and give a quick demonstration with the help of two volunteers. Other examples include programs to work out payroll, calculate accounts, deal with stock control and handle appointments. Teach ict gcse ict database validation and verification. Gcse ict revision section covering operating systems, user interfaces, application software, databases, spreadsheets, word processing, desktop publishing, graphics packages, modelling and simulation, software, computer control and software configure. Check with your teacher which of these theory units are in your particular. Using merge facilities within the database software, create personalised passes for these customers, no larger than 10 cm. Databases can be computerised or paperbased, but for the purposes of this course we will discuss computerised databases. The five main steps in setting up a mailmerged letter are.
These were originally used to teach edexcel gcse ict but they can easily be used in some cases as stand alone ictcomputer science lessons. Databases are one of the most powerful tools that people use to help them handle large amounts of information. This video explains about verification and validation. Gcse ict database terminology, fields, tables, files. Awardwinning tutorials, tips and advice on gcse ict coursework and exams for students, parents and teachers. Computer science and ict are taught together at key stage 3, and include. Dbms database management systems gcse computer science. An operating system such as windows xp or mac os x, applications such as microsoft word, and the instructions that control a robot are. You do not need to learn everything in this section. Part of awardwinning tutorials, tips and advice on gcse ict coursework and exams for students, parents and teachers. Binary system use binary in computer registers for a given application cell 1.
Ict and computing interactive software see our posters come to life with our ict interactive software. These are a series of quizzes based on the information available at author. May 03, 2016 this is a unit devised for alevel computing to teach all the concepts required for a level computing. This is the field that has a different value in every record. This is a unit devised for alevel computing to teach all the concepts required for a level computing.
Learn about the importance of a dbms and how it is used to separate data from applications with gcse bitesize computer science. Two patients can have the same birthday like rachel and david in our table. Whether youre a brand new computer science teacher, or youve been teaching ict for years, our resources will save you. We have tons of free material as well as professional schemes of work and material for teachers. Software is not a physical thing but it can of course be stored on a physical medium such as a cdrom, it is just a bunch of codes. Learn about the power of databases to store and analyse large amounts of data and learn about running searches and queries for ks3 ict. The passes should also include the following information. Merging merging involves combining two files to produce teach ict database gamespot new file. Students are shown a term or given a scenario and they have exactly 10 seconds to come up with 5 different, suitable answers. The query tells the software which fields to look at in each record and what to look for. There are many different types of validation check that software can make on data. Data that is not sensible or allowed is rejected by the computer. Hardware can be defined as items that you can actually touch or move from one desk or room to another. Application software the everyday programs that you use such as microsoft.
Gcse ict welcome to your first stop for gcse ict help. Software is made up of a series of instructions or computer code. The price is sent back to the till which adds it to the current sale. You need to refer to your gcse syllabus to ensure that you are covering all of the necessary theory. It is important to check data when it is entered to make sure that it is both sensible and correct. Students have exactly 100 words to summarise the key points about this topic subscription only agony aunt. Binary system use binary in computer registers for a given applicationcell 1. Programs to work out driving routes are one common example of specialist application software. Students are put into the role of an agony aunt who has to answer a set of letters about technology related problems. A computer needs to be told what to do, otherwise it will just sit on your desk collecting dust and taking up space. Edexcel gcse computer science teaching lesson resources. These are a series of quizzes based on the information available at. Mail merge word processing and desktop publishing gcse.
Database uses databases ks3 ict revision bbc bitesize. Software are the applications and programming instructions that tell your computer what to do and enable you to use it for things such as playing. All resources are included, there are activities for students to work on as well as a power point for teaching the content. If an items stock falls below a preset reorder level, an order for more stock is.
Activity booklets for web browsing, web design, spreadsheet design and basic database. Cars database and queries 2007 here is an access database based on cars. We have put together a full gcse computer science curriculum that will give you all the teaching materials you need to teach any topic. There are two methods that can be used to check data when it is input. This section will look at the different types of software that you need to know about for your exam. Coding databases a welldesigned database will code data that appears many times, rather than entering full terms. Is it a personal site for amusement or does it have a serious purpose. We will look at each of these categories in a bit more detail over the next few pages. If an items stock falls below a preset reorder level, an order for more stock is sent to the warehouse or supplier.
Gcse ict learning resources for adults, children, parents and teachers organised by topic. Please dont hesitate to get in touch if you have any questions. A database is an application which allows the effective storage of data and records in a logical way. Talented in computers, no ict qualification post gcse. Otherwise the site might be one big mess that visitors will not come back to.
If you want to teach or learn gcse, key stage 3 and a level computer science then come over and have a look at what we have. Mail merge is a word processing feature that allows users to personalise letters with names and addresses from a database. Copyright test questions gcse ict revision bbc bitesize. Play top trumps after each team has printed and cut out their top trump cards, explain the rules see below and give a quick demonstration. Bbc bitesize ict teach ict both of these websites will be useful to help with features of databases and software covered in this unit. The material under development will be suitable for all gcse ict students.
Application software the everyday programs that you use such as microsoft office, graphics packages and web browsers. Use the personal finances sheet in conjunction with the spreadsheet booklet. Software is a collection of instructions that can be run on a computer. Generic general purpose software that is not written for any particular type of business. Teach ict ocr gcse computing hardware and software. We have tons of free material as well as professional schemes of work for teachers. Igcse specification gcse document reference additional content 1 theory of computer science 1.
Students usually take two years to complete the edexcel gcse computer science course. This is one of those terms that you really need to learn by rote in order to ensure you get all of the marks available in an exam question. The passes must include customers full names, their activity date, number in group and hospitality option. Types of applications software applications and programming. In the table below, all of the information about each cartoon character is stored in a row or record. A welldesigned database will code data that appears many times, rather than entering full terms. Teach ict gcse ict database terminology, fields, tables, files. This means that you will only acquire your certificate if you sit all of your exams at the end of the course not throughout it. Check with your teacher which of these theory units are in your particular syllabus.
It is important that you understand these different terms and that. Top quality computer science resources for ks3, ks4, ks5. Cie gcse igcse computer science teaching lesson resources. Database uses microsoft office access is a popular database package but there are alternatives such as openoffice base. Application software caries out userrelated tasks and can be classified as generalpurpose, specialist or tailormade. The material on this site is not endorsed by the ocr examination board.
Mar 09, 2017 these were originally used to teach edexcel gcse ict but they can easily be used in some cases as stand alone ict computer science lessons. Revise applications and programming languages for gcse ict. Software are the applications and programming instructions that tell your computer what to do and enable you to use it for things such as playing games, writing an essay or listening to music. Jul 23, 2016 word processing, presentation and spreadsheet softwares are used in our day to day computer applications. There are two main categories of computer software that you need to know about. Word processing, presentation and spreadsheet softwares are used in our day to day computer applications.
1605 747 1354 996 1112 405 583 1299 163 658 786 1483 456 1070 819 912 920 1035 568 1433 934 141 1449 949 382 148 317 237 1520 462 21 61 1603 922 653 1054 1500 607 1474 592 880 455 1075 642 178