The easiest way to skyrocket your YouTube subscribers
Get Free YouTube Subscribers, Views and Likes

2021 June Paper 21 Cambridge 0417 ICT [IGCSE]

Follow
Nicos Paphitis

[0417_s21_qp_21 ]
In this video i solve the complete Cambridge IGCSE ICT 0417 June 2021 practical paper 21
A great resource for all students taking this exam. A link to the question paper and source files can be found at the bottom of the description.

Word Processing
Question 1:
2:37 Saving your document and displaying the file type extensions.
5:09 how to configure windows to display file extensions
Question 2:
7:07 Removing page breaks
Question 3:
8:17 Adding Headers and Footers
Questions 4,5:
10:44 Creating styles
Question 6:
16:57 Formatting paragraphs to 2 columns
Question 7:
18:20 Applying bullets and modifying spacing
Question 8:
21:43 Modifying a style
Question 9:
24:42 Paragraph formatting (indenting, border)
Question 10,11,12:
26:56 Tables (editing, merge, text format, text wrap, borders, spacing)
Question 13:
33:19 Inserting images (flipping, resize maintain aspect ratio, text wrap)
Question 14:
35:56 Proof read, widows and orphans, printing

Databases
Question 15:
37:31 Importing .csv files as tables (3 tables imported in this paper)
Question 16:
52:19 Creating relationships
Question 17,18:
55:18 enter a new record, finding and editing a record
Question 19:
59:15 Creating the Query for the report
1:04:44 Creating the report from the query
Question 20:
1:11:31 Creating the Query for the report (fields generated at runtime)
1:17:47 creating the report, adding calculated field at the end of teh report

Mail merge
Question 21,22,23:
1:25:11 Source data, merge fields, date field, Filtering the source data,
Question 24:
1:34:05 Merging and printing

Presentation

Questions 25,26,27:
1:35:10 Importing slides from .rtf file, master slides, deleting slides
Questions 28,29,30,31,32
1:39:30 Creating a pie chart from .csv file, modifying the chart, adding to a slide
Question 33:
1:43:58 Adding audio to a slide
Question 34:
1:45:34 Printing


Link to the files used:
https://thejuniorschoolmy.sharepoint...

Link to data entry forms with databases:
   • [Part 6] Creating Data Entry Forms (M...  

Link to presentation complete tutorial:
   • PowerPoint complete guide, [Cambridge...  

posted by vuvarj4