Podcast
Questions and Answers
What type of compression allows a file to be fully restored to its original state?
What type of compression allows a file to be fully restored to its original state?
In a database, what is used to uniquely identify each record?
In a database, what is used to uniquely identify each record?
What is used to locate specific data in a database with criteria?
What is used to locate specific data in a database with criteria?
What type of validation check ensures that a field begins with a specific pattern?
What type of validation check ensures that a field begins with a specific pattern?
Signup and view all the answers
What is used to automate tasks in a database?
What is used to automate tasks in a database?
Signup and view all the answers
What is used to add data to a database?
What is used to add data to a database?
Signup and view all the answers
What is the smallest unit of digital data represented by either 0 or 1?
What is the smallest unit of digital data represented by either 0 or 1?
Signup and view all the answers
What is the data type for storing the student score of 51 in a Computing Module?
What is the data type for storing the student score of 51 in a Computing Module?
Signup and view all the answers
How many binary digits are described by a BIT?
How many binary digits are described by a BIT?
Signup and view all the answers
What is the purpose of the instructions provided at the top of the page?
What is the purpose of the instructions provided at the top of the page?
Signup and view all the answers
What is the total mark for this paper?
What is the total mark for this paper?
Signup and view all the answers
What is the purpose of the figures in brackets printed down the right-hand side of the pages?
What is the purpose of the figures in brackets printed down the right-hand side of the pages?
Signup and view all the answers
What is the primary purpose of an operating system in a computer system?
What is the primary purpose of an operating system in a computer system?
Signup and view all the answers
What is the term for a preformatted layout into which data can be added?
What is the term for a preformatted layout into which data can be added?
Signup and view all the answers
Which software group does defragmentation belong to?
Which software group does defragmentation belong to?
Signup and view all the answers
What does the CPU stand for in relation to a computer system?
What does the CPU stand for in relation to a computer system?
Signup and view all the answers
What is the term for a system that allows multiple users to access the same computer resources?
What is the term for a system that allows multiple users to access the same computer resources?
Signup and view all the answers
What type of device is a microphone?
What type of device is a microphone?
Signup and view all the answers
What is the total amount of wages to be paid to the staff?
What is the total amount of wages to be paid to the staff?
Signup and view all the answers
What is the hourly rate of Mary Black?
What is the hourly rate of Mary Black?
Signup and view all the answers
What is the Tax Rate used in the spreadsheet?
What is the Tax Rate used in the spreadsheet?
Signup and view all the answers
What is the formula used in cell C8?
What is the formula used in cell C8?
Signup and view all the answers
What is an absolute cell reference?
What is an absolute cell reference?
Signup and view all the answers
What is the purpose of the chart produced by Mia?
What is the purpose of the chart produced by Mia?
Signup and view all the answers
What is a key principle of data processing regarding the rights of the data subject?
What is a key principle of data processing regarding the rights of the data subject?
Signup and view all the answers
What is the responsibility of the Information Commissioner regarding the Data Protection Act?
What is the responsibility of the Information Commissioner regarding the Data Protection Act?
Signup and view all the answers
What is a consequence of the increased use of digital technology on employment?
What is a consequence of the increased use of digital technology on employment?
Signup and view all the answers
What is a disadvantage of online training?
What is a disadvantage of online training?
Signup and view all the answers
What type of processing occurs when a computer system processes data all together during processor downtime?
What type of processing occurs when a computer system processes data all together during processor downtime?
Signup and view all the answers
What is the purpose of backing up computer files?
What is the purpose of backing up computer files?
Signup and view all the answers
Study Notes
Data Protection
- Data should be processed within the rights of the data subject.
- Data should be kept accurate and up to date.
Data Protection Act Responsibilities
- Information Commissioner:-responsible for one responsibility
- Data Controller: responsible for one responsibility
Impact of Digital Technology on Employment
- The increased use of digital technology has impacted on employment, specifically changing work patterns and job losses.
Online Learning
- Online learning has created many advantages for learners who cannot attend formal classes.
- Disadvantages of online training include:
- Two disadvantages (to be specified)
Processing
- Processing is an activity carried out by the computer system.
- Batch processing: processing data all together during processor downtime.
- Real-time processing: processing data fast enough to influence the behavior of the next input.
- Multi-user processing: processing that enables several users to use the system at once.
Backup and Compression
- Backup: a copy of data saved in a separate location to prevent data loss.
- Compression techniques:
- Lossless: a method of compression that allows the file to be fully restored to its original state.
- Lossy: a method of compression that discards data from the file, making it unrecoverable.
Database
- Key features of a database include:
- Records: data stored in a database will be held in one or more records.
- Tables: each table will have a key field which is used to uniquely identify each record.
- Query: a query can be used with criteria to locate specific data in a database.
- Report: data can be displayed in a user-friendly format using a report.
- Form: a form can be used to add data to a database.
- Macro: some tasks in the database can be automated using a macro.
Validation Checks
- Validation checks in a database include:
- Presence check: a check to ensure that a field is not left blank.
- Check for specific format: e.g. key field must begin with C followed by 5 numeric characters.
Computer Systems
- CPU: Central Processing Unit, the brain of the computer system.
- Operating system: manages the sharing of CPU time and resources needed by many users.
- Resources managed by the operating system include:
- CPU time
- Memory
Software Groups
- Defragmentation belongs to the system software group.
Input and Output Devices
- Input devices:
- Microphone
- Example of use: recording audio
- Output devices:
- High definition display
- Example of use: displaying high-quality images and videos
Spreadsheets
- Formatting method used on cells A12 and B12: currency formatting.
- Formula used in cell C8: (to be specified)
- Formula used in cell D3: (to be specified)
- Absolute cell reference: a reference to a cell that does not change when the formula is copied to another cell.
- Formula used in cell E3: =IF(D3>=C12, "YES","NO")
Studying That Suits You
Use AI to generate personalized quizzes and flashcards to suit your learning preferences.
Description
Practice questions for the GCSE Digital Technology Unit 1 exam, covering the compulsory core syllabus. Test your knowledge and prepare for the exam. Time-limited, 1-hour quiz.