Search this site
Embedded Files
Skip to main content
Skip to navigation
Welcome to the Islwyn High School - Digital Technology GCSE Site
DigiTech GCSE
Home
Advanced Information 2023
Mock - December 2022
Unit 1
2.1.1 Data
2.1.1a - Analogue & Digital Data
2.1.1.A2 Sound
2.1.1.A3 Advantages / Disadvantages
2.1.1.A4 Graphics
2.1.1.B1 & B2 Measuring & Storing
2.1.2 Digital Technolgy Systems
2.1.2.A1 Digital Interaction
2.1.2.A2 Connection
2.1.2 B1 Operating Systems
2.1.2 C1 Software Types & Functions
2.1.2 D1 Data Backup
2.1.2 E1 Cloud Services
2.1.2 F1 Life Cycle
2.1.3 Digital Communications
2.1.3 A1 Range of Digital Methods
2.1.3 B1 Reliability of Sources
2.1.3 C1 Social Networking Practices
2.1.3 C2 Media Ownership
2.1.3 C3 Copyright & Libel
2.1.4 Impact
2.1.4 A1 Offices & Individuals
2.1.4 B1 Implementation
2.1.4 C1 Changing Working Practices
2.1.4 C2 Digital Divide & Environment
2.1.4 D1 E-commerce
2.1.4 E1 Monetised Content
2.1.5 Securing Data & Systems
2.1.5 A1 & A2 Theats to Data
2.1.5 B1 - B3 Cyber Resilience
2.1.5 C1 & C2 Digital Footprints
2.1.5 D1 Legislation
2.1.5 D2 Ethical Concerns
2.1.6 Changing Digital Technologies
2.1.6a Computer Scientists
2.1.6b Emerging Technology
2.1.6c Future Developments
Unit 2
Marking
Spreadsheet Marking Grid
Marking Template
2.2.1 & 2.2.2 Spreadsheet Project
2.2.1 Data organisation
1. Data Input
2. Remove Duplicates
3. Removing White Space
4. Blank Cells
5. Data Types
6. Case Types
7. Conditional Formatting
8. Formula View
2.2.2 Data analytics
1. Sort
2. Sum
3. Average
4. Max
5. Min
6. Round
6. Case Types
7. Countif
8. Interquartile Range
9. Vlookup
10. Numerical Representation_Percentage
11. Relative & Absolute
12. Charts & Graphs_Bar
13. Charts & Graphs_Pie
14. Pivot Tables
15. What If Investigations
2.2.3 Planning Digital Products
Web page
Animation
2.2.4 Web Design
Adobe Video Guides
Advanced:
HTML & CSS
Dreamweaver Site & File Creation
Stages of website design
Adding page content
Managing assets
Coding faster
Page style with CSS
HTML page structure
2.2.4 Animation
Adobe Flash
2.2.5 Product Testing
Unit 3
Scenario
Front Sheet
2.3.1 Forms of Communication
2.3.2 Impact of Communications
2.3.3 Creating Digital Assets
2.3.4 Planning Assets
Marking
Resources
Revision
WJEC Resources
Past Papers
Video Resources
Illustrator
Photoshop
Logo Design
Web Design
TikTok
XD
Premiere Pro
DigiTech GCSE
Home
Advanced Information 2023
Mock - December 2022
Unit 1
2.1.1 Data
2.1.1a - Analogue & Digital Data
2.1.1.A2 Sound
2.1.1.A3 Advantages / Disadvantages
2.1.1.A4 Graphics
2.1.1.B1 & B2 Measuring & Storing
2.1.2 Digital Technolgy Systems
2.1.2.A1 Digital Interaction
2.1.2.A2 Connection
2.1.2 B1 Operating Systems
2.1.2 C1 Software Types & Functions
2.1.2 D1 Data Backup
2.1.2 E1 Cloud Services
2.1.2 F1 Life Cycle
2.1.3 Digital Communications
2.1.3 A1 Range of Digital Methods
2.1.3 B1 Reliability of Sources
2.1.3 C1 Social Networking Practices
2.1.3 C2 Media Ownership
2.1.3 C3 Copyright & Libel
2.1.4 Impact
2.1.4 A1 Offices & Individuals
2.1.4 B1 Implementation
2.1.4 C1 Changing Working Practices
2.1.4 C2 Digital Divide & Environment
2.1.4 D1 E-commerce
2.1.4 E1 Monetised Content
2.1.5 Securing Data & Systems
2.1.5 A1 & A2 Theats to Data
2.1.5 B1 - B3 Cyber Resilience
2.1.5 C1 & C2 Digital Footprints
2.1.5 D1 Legislation
2.1.5 D2 Ethical Concerns
2.1.6 Changing Digital Technologies
2.1.6a Computer Scientists
2.1.6b Emerging Technology
2.1.6c Future Developments
Unit 2
Marking
Spreadsheet Marking Grid
Marking Template
2.2.1 & 2.2.2 Spreadsheet Project
2.2.1 Data organisation
1. Data Input
2. Remove Duplicates
3. Removing White Space
4. Blank Cells
5. Data Types
6. Case Types
7. Conditional Formatting
8. Formula View
2.2.2 Data analytics
1. Sort
2. Sum
3. Average
4. Max
5. Min
6. Round
6. Case Types
7. Countif
8. Interquartile Range
9. Vlookup
10. Numerical Representation_Percentage
11. Relative & Absolute
12. Charts & Graphs_Bar
13. Charts & Graphs_Pie
14. Pivot Tables
15. What If Investigations
2.2.3 Planning Digital Products
Web page
Animation
2.2.4 Web Design
Adobe Video Guides
Advanced:
HTML & CSS
Dreamweaver Site & File Creation
Stages of website design
Adding page content
Managing assets
Coding faster
Page style with CSS
HTML page structure
2.2.4 Animation
Adobe Flash
2.2.5 Product Testing
Unit 3
Scenario
Front Sheet
2.3.1 Forms of Communication
2.3.2 Impact of Communications
2.3.3 Creating Digital Assets
2.3.4 Planning Assets
Marking
Resources
Revision
WJEC Resources
Past Papers
Video Resources
Illustrator
Photoshop
Logo Design
Web Design
TikTok
XD
Premiere Pro
More
Home
Advanced Information 2023
Mock - December 2022
Unit 1
2.1.1 Data
2.1.1a - Analogue & Digital Data
2.1.1.A2 Sound
2.1.1.A3 Advantages / Disadvantages
2.1.1.A4 Graphics
2.1.1.B1 & B2 Measuring & Storing
2.1.2 Digital Technolgy Systems
2.1.2.A1 Digital Interaction
2.1.2.A2 Connection
2.1.2 B1 Operating Systems
2.1.2 C1 Software Types & Functions
2.1.2 D1 Data Backup
2.1.2 E1 Cloud Services
2.1.2 F1 Life Cycle
2.1.3 Digital Communications
2.1.3 A1 Range of Digital Methods
2.1.3 B1 Reliability of Sources
2.1.3 C1 Social Networking Practices
2.1.3 C2 Media Ownership
2.1.3 C3 Copyright & Libel
2.1.4 Impact
2.1.4 A1 Offices & Individuals
2.1.4 B1 Implementation
2.1.4 C1 Changing Working Practices
2.1.4 C2 Digital Divide & Environment
2.1.4 D1 E-commerce
2.1.4 E1 Monetised Content
2.1.5 Securing Data & Systems
2.1.5 A1 & A2 Theats to Data
2.1.5 B1 - B3 Cyber Resilience
2.1.5 C1 & C2 Digital Footprints
2.1.5 D1 Legislation
2.1.5 D2 Ethical Concerns
2.1.6 Changing Digital Technologies
2.1.6a Computer Scientists
2.1.6b Emerging Technology
2.1.6c Future Developments
Unit 2
Marking
Spreadsheet Marking Grid
Marking Template
2.2.1 & 2.2.2 Spreadsheet Project
2.2.1 Data organisation
1. Data Input
2. Remove Duplicates
3. Removing White Space
4. Blank Cells
5. Data Types
6. Case Types
7. Conditional Formatting
8. Formula View
2.2.2 Data analytics
1. Sort
2. Sum
3. Average
4. Max
5. Min
6. Round
6. Case Types
7. Countif
8. Interquartile Range
9. Vlookup
10. Numerical Representation_Percentage
11. Relative & Absolute
12. Charts & Graphs_Bar
13. Charts & Graphs_Pie
14. Pivot Tables
15. What If Investigations
2.2.3 Planning Digital Products
Web page
Animation
2.2.4 Web Design
Adobe Video Guides
Advanced:
HTML & CSS
Dreamweaver Site & File Creation
Stages of website design
Adding page content
Managing assets
Coding faster
Page style with CSS
HTML page structure
2.2.4 Animation
Adobe Flash
2.2.5 Product Testing
Unit 3
Scenario
Front Sheet
2.3.1 Forms of Communication
2.3.2 Impact of Communications
2.3.3 Creating Digital Assets
2.3.4 Planning Assets
Marking
Resources
Revision
WJEC Resources
Past Papers
Video Resources
Illustrator
Photoshop
Logo Design
Web Design
TikTok
XD
Premiere Pro
9. VLOOKUP
DT GCSE Unit 2_Data Analysis Topic 7_VLOOKUP
9. VLOOKUP
Report abuse
Page details
Page updated
Report abuse
