Replace ANY welded / plastic riveted keyboard the CORRECT WAY. Nicos Paphitis 2026-09-28 | Replace ANY welded / plastic riveted keyboard the CORRECT WAY.
XLOOKUP Using Multiple Lookup Arrays – It IS Possible! Nicos Paphitis 2025-09-30 | Learn how to use XLOOKUP with multiple lookup arrays in Excel — a trick that even advanced users often overlook! In this tutorial, I’ll show you how to set up a dynamic XLOOKUP formula that searches across more than one array, making your spreadsheets more flexible and powerful. This is a must-know Excel technique. 0:00 Introduction02:07 Demonstration of a multiple array lookup06:20 Understanding the XLOOKUP function and its parameters using 1 lookup array.11:15 How we create an XLOOKUP with a multiple array lookup.16:51 Worked example of the multiple array lookup with using XLOOKUP in Excel 17:08 Bonus trick on how to have multiple windows of the same workbook.18:12 Building the nested XLOOKUP function28:40 SummaryLinks to tutorials mentioned in this tutorial:Understand the lookup functions (Lookup, Vlookup, Hlookup, Xlookup)youtu.be/dbCvU1zkoPM?si=g_sFbT_a6RI_UvZEUnderstanding Referencesyoutu.be/qgankq3WqAE?si=Wl8I6Z4b9DQyp80aIF and Nested IF Functions:youtu.be/X7EX9IjkuFM?si=uIknrSI7Xy_LDpSP
2025 May/June Paper 22, Tasks 1 & 2, Cambridge 0417 /0983 ICT [IGCSE] Nicos Paphitis 2025-09-16 | In this tutorial i solve Tasks 1 and 2 of the 2025 May/June Paper 22 of the ICT IGCSE exam 0417 / 0983. Tasks 1 and 2 cover the creation of the Evidence document, and the Word processing component.You can access the Database component (task 3 ) here:youtu.be/QbhgaHrPdz8You can access the Presentation / chart creation component (tasks 4 & 5) here:youtu.be/SZ7Og-9d3Xs0:00 IntroTask1 - Evidence Document-------------------------------------01:05 Checking the files and making sure you know where you will create all your files.02:31 Creating the evidence documentTask 2 - Word Processing-------------------------------------04:27 Q1 - Open your document and save as specified, display extension and take screenshot08:11 Q2 - Add Header and Footer [TIP: Good tips on multiple alignments]11:58 Q3 Q4 - Add title and add style [TIP: understand when to enter a soft or hard break]14:05 Q5 - Modifying a styleTables19:32 Q6 Q7 Q8 - 20:11 Delete column from table 20:49 Format table cells 20:23 Change cell width [two methods displayed]. Screen shot evidence25:29 Q9 - Converting selected text to 2 columnsImage27:54 Q10 Q11 - Insert and format image image [Important info here on what Column Guides are)34:16 Q12 - Apply style to table selected columns 35:44 Apply internal and external borders to table [TIP: Custom borders internal and external] 37:42 add space after tableCheck the document38:09 Proof read and Spell check. Check for39:28 Important: What are Widows and Orphans and how to fix42:08 Save and print your document. Check document in print preview42:40 Recap----------------------------------------------Useful Links:Playlist of Past papers:youtube.com/playlist?list=PLWeerq9oa1ne5T9Im1ei06yz1tUFqevel
2025 May/June Paper 22, Task 3 Databases, Cambridge 0417 /0983 ICT [IGCSE] Nicos Paphitis 2025-09-16 | In this tutorial i solve Task 3 of the 2025 May/June Paper 21 of the ICT IGCSE exam 0417 / 0983. Task 3 covers the Databases component of this paper.You can access the Word processing component (tasks 1 & 2) here:youtu.be/RvMKUxUK2zcYou can access the Presentation / chart creation components (tasks 4 & 5) here:youtu.be/SZ7Og-9d3Xs0:00 IntroTask 3------------------------01:16 Q14 - 01:40 read through the question and check data types 02:29 Importing the .csv file as a new table 04:28 Making sure your device has the correct list separator [IMPORTANT] 07:28 Setting 2 decimal values and why you must set the field to a fixed format. 09:20 Taking appropriate screen shot10:16 Q15 - Import second table from .csv and take screen shot of table structure.12:34 Q16 - Create a one to many relationship15:19 Q17 - Add a new record. I also create a data entry form also although it is not needed. 18:51 Adding the record directly into the table20:14 Q18 - Creating a report (read through the question) 21:30 first create the query 24:05 understanding how to use the asterisk wild card 25:08 Using the OR operator 27:44 Create the report Here I also demonstrate using the layout view. 32:10 Applying the sorting from the design view 35:25 add title 34:37 Adding a page footer 35:18 Checking the report and printing 36:18 [IMPORTANT] creating the report but applying sorting while creating the report. For some this will be easier if you find it hard to understand ascending descending. 39:00 Q19 - Creating a report (this one has new field at run time) Read through the question 39:58 Creating the query 40:38 Creating a field generated at runtime 42:07 change to custom format hh:mm:ss 44:03 Adding criteria for query 45:56 Create the report based on the query 48:48 applying sorting 49:29 Add a title 46:51 Add a calculative field at end of report 52:02 Adding a page footer. [Difference of Page and Report footer explained]54:56 Recap----------------------------------------------Useful Links:Playlist of Past papers:youtube.com/playlist?list=PLWeerq9oa1ne5T9Im1ei06yz1tUFqevelCreating Data Entry Forms:youtu.be/yMqMoWAhLbM?si=PFzCBbonfYEIKMXoEverything about databases:youtu.be/Zrhy35nKzFQ?si=tpt5OeXrtxc6mhsh
2025 May/June Paper 22, Tasks 4 & 5 Presentation, Cambridge 0417 /0983 ICT [IGCSE] Nicos Paphitis 2025-09-16 | In this tutorial i solve Tasks 4 & 5 of the 2025 May/June Paper 22 of the ICT IGCSE exam 0417 / 0983. Tasks 4 & 5 cover the Presentation / chart creation components of the exam.You can access the Word processing component (tasks 1 & 2) here:youtu.be/RvMKUxUK2zcYou can access the Database component (task 3) here:youtu.be/QbhgaHrPdz80:00 IntroTask 4 Presentation----------------------------------01:21 Q20 - Create a new presentation and import a .rtf (2 methods demonstrate)02:43 Q21 - Slide master (what to be careful of). Add Header and Footer05:30 Q22 - Delete slides Creating Charts05:47 Q23 - Create a Chart. Start of by analyzing the data 07:13 Tips on when creating charts 07:54 2 methods to create the line chart09:56 Q24 - How to modify displayed text in the legend11:21 Q25 - Add a title11:49 Q26 - Format the value axis12:50 Q27 - Place the chart in the slide13:41 How to change the legend text in the chart by cheating15:07 Q28 - Adding and formatting bullets (indent, custom bullet, enhancement)17:17 Q29 - Adding a hyperlink to email 19:13 Taking a screenshot to show evidence of the link20:25 Q30 - Save and print the presentation (various printing techniques demonstrated here)Task 5 Print Evidence Document22:42 Print the evidence document.23:14 Recap----------------------------------------------Useful Links:Playlist of Past papers:youtube.com/playlist?list=PLWeerq9oa1ne5T9Im1ei06yz1tUFqevelPowerPoint Tutorialyoutu.be/TRHfD3RP9cg?si=XF9MbP8QIpGuZZLHCreating Chartsyoutu.be/jn3YX3SN2w8?si=T96BHyT3S_APSY4F
2025 May/June Paper 21, Tasks 3 & 4 Databases, Cambridge 0417 /0983 ICT [IGCSE] Nicos Paphitis 2025-09-08 | In this tutorial i solve Tasks 3 & 4 of the 2025 May/June Paper 21 of the ICT IGCSE exam 0417 / 0983. Tasks 3& 4 cover the Databases component of this paper.You can access the Word processing component (tasks 1 & 2) here:youtu.be/IZYLucDt-HwYou can access the Presentation / chart creation components (task 4) here:youtu.be/8VY1GAeKnCITask 3----------------------------0:00 Intro0:58 Q15 - Reading the question and understanding what we need to do 01:58 IMPORTANT - how to set up your device to display correct date format and so that you can import CSV files 04:08 Importing the CSV file as a new table 07:52 Advanced settings of the fields Date Format, Boolean Yes/No 09:29 Taking appropriate screenshot of the imported table10:41 Q16 - Importing a second table from CSF file When to use short text and when to use long text data type14:42 Q17 - Identifying the primary key field in a CSV file (We use Excel for this) 16:52 Importing the third CSV file to a new table and set the identified field as a primary key. 18:42 Q18 - Creating Relationships and producing appropriate screenshots 21:45 What not to do when taking screenshots of relationships22:48 Q19 - Adding a new record in a table. I create a simple data entry form (not needed but good for practice) Link to tutorial on Data Entry Forms: youtu.be/yMqMoWAhLbM?si=_aIPvsG9wfiX5GRs 25:39 Adding the data directly in to the table.27:26 Q20 - Creating a Report (first create a Query) 28:38 Creating the query 30:27 adding criteria to the query [IMPORTANT INFO HERE] 32:18 Explaining wildcards * in criteria 34:29 Creating the report based on the query created. Modifying the report so that it displays properly. [lots of tips and tricks here] 39:48 Applying sorting from report design view 40:36 Use a function on date in the Report [Important Tip Here], Formatting the date 46:29 Adding a Page Footer 48:11 COMMON STUDENT MISTAKE50:46 Q21 - Creating custom Labels (create query first) 50:46 understanding what we need to do Link to a tutorial on crating labels: youtu.be/DhYYgQhHp_A?si=LsI_O9Az9bNnbmK4 52:58 Creating the Query 54:44 Adding the criteria [how to OR criteria with wild cards] 57:53 Creating a custom labels from the query [a lot of important info here] 01:01:34 Modifying the labels in Design View (add a label and format the label)Task 4-----------------------------01:04:12 Print the Evidence document01:04:37 RecapLinks to Part 1 and Part 3
2025 May/June Paper 21, Tasks 1 & 2, Cambridge 0417 /0983 ICT [IGCSE] Nicos Paphitis 2025-09-08 | In this tutorial i solve Tasks 1 and 2 of the 2025 May/June Paper 21 of the ICT IGCSE exam 0417 / 0983. Tasks 1 and 2 cover the creation of the Evidence document, and the Word processing component.You can access the Database component (tasks 3 & 4) here:youtu.be/ij1BuG1QDbcYou can access the Presentation / chart creatin component (task 5) here:youtu.be/8VY1GAeKnCI0:00 Intro01:09 Quick tip on preparing your files before you startTask 1--------------------------------------------02:45 Creating the Evidence documentTask 2--------------------------------------------04:17 Q1 - Open the document check the settings and save it as a docx. 06:12 Create appropriate screenshot07:58 Q2 - Adding Header and Footer (Important Tips on alignments here)10:38 Q3 - Modifying text to 2 columns (info on working with inches or cm)13:17 Q4 - Adding and modifying bulletsWorking with Tables16:02 Q5 - Deleting row from table16:40 Q6 - Sorting data in a table.18:40 Q7 - Custom borders for tables20:30 Q8 - Merge and format cells22:20 Q9 - Applying Styles23:02 Q10 - Sizing the tableStyles24:22 Q11 - Creating a style (Important info here)30:01 Q12 - Apply style to subheadings30:43 Q13 - Create a hyperlink to a fileCheck document33:10 Q14 - Check for widows and orphans (Tip on using the Widow Orphan control)36:51 Recap
2025 March Paper 21, Task 3 Databases, Cambridge 0417 /0983 ICT [IGCSE] Nicos Paphitis 2025-09-04 | In this tutorial i solve Task 3 of the 2025 March Paper 21 of the ICT IGCSE exam 0417 / 0983. Task 3 covers the Databases component of this paper.You can access the Word processing component (tasks 1 & 2) here:youtu.be/NI42QWJX3f8You can access the Presentation / chart creation components (task 4) here:youtu.be/ZBjcLYYPNiE0:00 Intro56:11 Question 14 01:52 Analyze the csv file to identify the Primary Key (IMPORTANT info here) 04:47 Importing the csv file as a new table 06:19 IMPORTANT, why some face issues when importing. Checking your regional settings. 08:20 Setting the data types 09:57 Checking properties of data types and taking a screen shot evidence.11:45 Question 15 12:34 Importing a second csv as a second table 14:30 Set advanced properties for date fields 15:06 Set the Yes/No (Boolean) field to display text Yes or No. (IMPORTANT info here incase it does not display text) 16:13 Appropriate screen shot of the table.16:55 Question 16 17:16 Creating a relationship between 2 tables (IMPORTANT info about taking an acceptable screen shot evidence)20:00 Question 17 20:28 Understanding the difference of finding a record and filtering data in a table. 21:23 Finding a record and modifying the data.23:27 Question 18 (Creating a Query and Report) 25:41 Creating a query in design view 27:04 Understanding how to use the wildcard * in a query 28:45 Adding criteria in the query and checking results 29:59 Saving your query 30:18 Creating the Report using Wizard (IMPORTANT info here about grouping) 21:21 IMPORTANT INFO about sorting (1st method used) 33:27 Previewing the report 33:54 Putting the fields in the correct order 37:05 Adding a title 37:52 Difference between Count Records and Count Values 39:05 Adding a count Records at bottom of report and adding a label. 40:24 Adding your details 42:00 IMPORTANT INFO on common mistakes students make 44:20 Evidence of Count formula and printing your report46:18 Question 19 (Creating a Query and Report) 47:13 Creating the Query 48:44 Adding the Criteria 50:25 Creating the report 51:59 Previewing the report and sizing the Fields 54:56 IMPORTANT INFO on sorting (2nd method used) 56:14 Adding details in the Header (page or report header) of the report 58:50 Save and Print the report
2025 March Paper 21, Task 4 Presentation, Cambridge 0417 /0983 ICT [IGCSE] Nicos Paphitis 2025-09-04 | In this tutorial i solve Task 4 of the 2025 March Paper 21 of the ICT IGCSE exam 0417 / 0983. Task 4 covers the Presentation / chart creation components of the exam.You can access the Word processing component (tasks 1 & 2) here:youtu.be/NI42QWJX3f8You can access the Database component (task 3) here:youtu.be/zcczIPxNcGw0:00 Intro-----------------------------------------------------------------------------Task 4 (Presentation and Charts)-----------------------------------------------------------------------------01:07 Question 20 01:33 Importing the .rtf file as slides02:45 Question 21 03:05 Slide master05:34 Question 22, Changing slide layout06:26 Question 23, Adding text and maintaining formatting07:49 Questions 24, 25 and 26 08:28 Creating the chart (IMPORTANT INFO and TIPS here on chart certation) 12:30 Modifying legend and category labels 13:43 Adding Labels 14:41 Modifying the Value axis15:28 Question 27 15:52 Placing the chart in the slide and printing single page17:18 Question 28 17:39 Inserting a new slide and maintain formatting.19:33 Question 29 19:51 Inserting an action button with hyperlink (Two methods, shapes and action buttons) 21:37 Producing an appropriate screen shot for evidence.-----------------------------------------------------------------------------Task 5 (Printing)-----------------------------------------------------------------------------Printing 3 slides to a page and printing your evidence document.Good tips here.25:35 Sum-up
2025 March Paper 21, Tasks 1 & 2, Cambridge 0417 /0983 ICT [IGCSE] Nicos Paphitis 2025-09-04 | In this tutorial i solve Tasks 1 and 2 of the 2025 March Paper 21 of the ICT IGCSE exam 0417 / 0983. Tasks 1 and 2 cover the creation of the Evidence document, and the Word processing component.You can access the Database component (task 3) here:youtu.be/zcczIPxNcGwYou can access the Presentation / chart creatin component (task 4) here:youtu.be/ZBjcLYYPNiE0:00 Intro----------------------------------------------------------------0:39 Task 1 (Evidence document)0:39 Checking the files0:55 Creating the Evidence document----------------------------------------------------------------02:25 Task 2 (Word Processing)02:32 Question 1 03:19 Opening, checking and saving the document as a Word document. 04:56 Evidence of file saved06:12 Question 2 (Footer) 06:36 Adding a footer with multiple alignments (two methods demonstrated)09:06 Question 3 (Styles) 09:31 What to be careful of when creating styles (Important tip) 10:10:43 Creating a style 12:33 Taking correct screen shot for evidence 13:54 checking to see if any changes were applied to when the style was created14:38 Question 4 (modifying a font style) 15:39 Modifying a style 17:03 Taking appropriate screen shot18:05 Question 5 & 6 18:38 Adding text and styles19:26 Question 7 (List) 19:50 Adding and formatting a bulleted list. (IMPORTANT information here)22:19 Question 8 (Styles) 22:33 Applying styles to the subheadings23:20 Question 9 (Columns) 23:49 Selecting appropriate text and making the document 2 columns with space (IMPORTANT info here).25:21 Questions 10 and 11 (Tables) 25:45 Inserting a new row 26:36 Formatting the table (merge, shading, borders, spacing, sizing)30:13 Question 12 (Images) 30:54 Finding the paragraph to insert the image 31:13 Inserting an image 31:26 Size the picture (IMPORTANT information about units here) 32:10 Rotate the image 32:28 Add text wrap33:11 Question 13 (Check your document) 33:56 Checking my document. 34:11 How to deal with widows/orphans (IMPORTANT TIP here) 36:25 Printing your document.36:51 Summary and final thoughts on the tasks.
Stellar Converter for OST [OST to PST] Why i use it. Nicos Paphitis 2025-09-03 | 0:00 Intro0:59 Understanding what OST and PST files are and why we convert 0:59 How OST files are created 02:42 What is an OST file 04:13 What is an Orphaned OST 05:09 How can an OST be orphaned 07:47 Why convert OST to PST 08:53 What is a PST file10:21 Why use Stellar Converter for OST12:03 Where to download the software and see the different versions.13:55 Installing Stellar Converter for OSTRunning Stellar Converter for OST14:43 First screen, converting OST files on device or manually choosing an OST file15:26 How to find the location of OST files on a device so that you can copy them.17:56 Opening and importing OST file in Stellar Converter for OST20:39 Activating the software20:59 Converting the imported OST file into a PST file24:35 Opening the PST file in Outlook 24:35 Microsoft Outlook roadmap for Outlook App 25:40 Opening the PST file in Outlook27:29 Removing the PST from Outlook28:20 TIP - How to make sure the OST file you copy contains all emails on the server and not just the cached emails.31:52 RecapStellar Converter for OST Product Page:stellarinfo.com/convert-ost-to-pst.php Stellar Converter for OST link to download:stellarinfo.com/email-tools/convert-ost-to-pst/buy-now.phpMicrosoft Outlook Roadmap:microsoft.com/en-us/microsoft-365/roadmap?filters=%5B%22Outlook%22%5D
Expression Web, 2025 Feb/March Paper 31 Task 3,Web Design, [IGCSE 0417, 0983 ICT] Nicos Paphitis 2025-08-27 | In this video i explain and solve the Cambridge IGCSE ICT 0417, 0983 Feb/March 2024 Practical paper 31 Web Design component (Task 3) using Expression Web. If you want to access the Dreamweaver solution to this task you can find a link to that tutorial at the end of this description.For Tasks 1 & 2 of this paper (Evidence doc, and file management) see this tutorial:youtu.be/LMxT7JWAAyIYou can access the Spreadsheet component (task 4) here:youtu.be/kB1M1mZa6YU0:00 Intro01:00 Q2 Reading the question and analysing what we have to do 02:35 trick to ensure you find the correct size of the table to create 03:17 Open Expression Web and learn how to set up the interface 04:40 Create the HTML file 06:20 Crete the table and format as requested 09:53 Preview the webpage to check the table created10:44 Q3 Inserting an image. Understanding image dimensions and aspect ratios (COMMON student request)17:00 Q4 Insert Video using the Video tag. Tip on how to easily insert the Video tag and apply various attributes like controls, loop, auto play, muted 23:20 Entering the fallback text if browser does not support the video file type. 24:11 Extra info on videos, how to manage multiple file types incase a browser does not recognize one type it will open the next.27:28 Q5 Adding text and formatting29:13 Q6 Adding text and setting format30:43 Q7 Adding Hyperlinks and setting target window 33:21 Adding an Email hyperlink and automatic subject 34:18 Testing the hyperlinks 35:09 Q8 Reading and understanding the question on Stylesheets 37:09 where to learn all about styles (external, internal, inline, class, priority) 37:55 Creating the stylesheet and adding styles 44:37 Creating a screenshot45:29 Q9 Attaching stylesheets and setting priority 48:38 preview the webpage49:51 Q10 Add source code to evidence document 51:35 How to size your browser window so that you can take an appropriate screenshot54:18 Recap------------------------------------------------------------------You can access the Dreamweaver solution to this component here:youtu.be/eXsnfaYmKfw------------------------------------------------------------------Links to useful tutorials mentioned in this tutorial:Full Expression Web Playlist:youtube.com/playlist?list=PLWeerq9oa1nd-d57iLCICkh-sfP9hcdS8Intro to Expression web and setting up your interface:youtu.be/TbkE0Z4LEZ4?si=MYq-3HrraKSH_1ASEverything you need to know about tables:youtu.be/pLpBxYKdaJw?si=-gfNd2Y7B7k9cSdjTutorial on Styles:youtu.be/r4t1N01idsc?si=ProbfOQ6Z1DhEEgqAssess yourself on Styles:youtu.be/u22M0HoCp4o?si=xu9ieBdtH7Rtb97jYou can download the Expression Web version i use here:dropbox.com/scl/fi/bkuk9r6ygzirmgc8uxw4b/microsoft-expression-web-4-0-1460-0.zip?rlkey=nnxl0j7hu0jrscj0ybm9jvlwb&st=7p8s46fa&dl=0
2025 Feb/March Paper 31, Task 4 Spreadsheet, Cambridge 0417 ICT [IGCSE] Nicos Paphitis 2025-08-27 | This is the 3rd of 3 tutorials for the 2025 February / March Paper 31 of the ICT IGCSE exam 0417. In this tutorial i solve Task 4 . Tasks 4 covers the Spreadsheet component. You can access Tasks 1 & 2 of this paper, the Evidence Doc and file management components here:youtu.be/LMxT7JWAAyIYou can access Task 3, the Web Design component soled with Dreamweaver here:youtu.be/eXsnfaYmKfwYou can access Task 3, the Web Design component soled with Expression Web here:youtu.be/ziVcxagHXJM------------------------------------------------------------------------------------0:00 Intro0:52 Q11 Read through the question to understand what we will be doing 01:54 Examine the given file 02:45 Inserting Header (details, current date and current time) 04:11 Preview header and correct the error identified 05:14 Save the file as an Excel workbook06:19 Q12 Inserting Rows, adding text.06:58 Q13 Formatting the spreadsheet as indicated in the question paper11:47 Q14 Adding Validation rules 14:38 Appropriate screenshots for the validation rules and criteria16:32 Q15 Deleting rows17:07 Q16 Inserting a formula to calculate the Area18:02 Q17 Analyzing the formula to add 20:10 Inserting a long formula 21:40 Adding the result of an IF function to the original formula25:05 Q18 Print your spreadsheet formulas26:26 Q19 Print your spreadsheet values28:08 Recap------------------------------------------------------------Other tutorials related to the material covered in this component.Full Excel Playlist:youtube.com/playlist?list=PLWeerq9oa1ndM1kKGiwe4uM_npzPtC6M8Introduction to Excel:youtu.be/j7lpJ1jItfE?si=SA-gj_i4wmWZxKMjIF Functions:youtu.be/X7EX9IjkuFM?si=grOF-4oPgZBeDrvV
2025 Feb/March Paper 31, Task 3 Web design, Cambridge 0417 ICT [IGCSE] Nicos Paphitis 2025-08-27 | This is the 2nd of 3 tutorials for the 2025 February / March Paper 31 of the ICT IGCSE exam 0417. In this tutorial i solve Task 3 . Task 3 covers the Web Design component and i use Dreamweaver to solve this component. There is another tutorial where i solve this component using Expression Web. The link to that tutorial can be found at the end of the description.You can access Tasks 1 & 2 of this paper, the Evidence Doc and file management components here:youtu.be/LMxT7JWAAyIYou can access the Spreadsheet component (task 4) here:youtu.be/kB1M1mZa6YU------------------------------------------------------------------------------------0:00 IntroTask 3 Web Design01:00 Q2 creating the Html file and creating the Table 01:54 identifying the number of rows and columns for the table 02:40 creating the html file with Dreamweaver 03:45 Creating he table. IMPORTANT info here (common student mistake) 06:57 Previewing the webpage in the browser and checking Table width07:59 Q3 inserting image. IMPORTANT info here on dimensions and aspect ratios. Here i explain how the attributes width and height work and how the aspect ratio is effected with examples.14:30 Q4 Inserting video. adding controls, loop, auto play and muted Previewing and explaining all the controls. 19:32 Adding fallback text20:52 Q5 Inserting text from file and setting the format.21:50 Q6 Enter text and add Format to heading 223:40 Q7 Adding Hyperlinks to pages and email 25:02 adding a link to an email with automatic subject (explained) 26:31 Testing the hyperlinks27:32 Q8 Reading and understanding what needs to be done with regard to the style sheet. Important to read ahead. 31:18 Creating an External Stylesheet and saving (IMPORTANT notes here)37:14 Q9 Attaching Stylesheets. 38:25 Priority of stylesheets 39:21 Preview in browser 39:53 Screenshot of CSS40:47 Q10 copy of Source code and screenshot of webpage in browser. 41:49 Sizing your webpage to take appropriate screenshot. IMPORTANT info here to get the best screenshot to display the whole webpage.43:40 Recap.------------------------------------------------------------------You can access the Expression Web solution to this component here:youtu.be/ziVcxagHXJM------------------------------------------------------------------Links to useful tutorials mentioned in this tutorial:Full Dreamweaver playlist:youtube.com/playlist?list=PLWeerq9oa1neV2G4NC5Kt39_bK7zFcZfsSetting up the Dreamweaver interface:youtu.be/7Yr9wYQu_1k?si=1TQBcOqnK57h4U_qEverything you need to know about tables:youtu.be/pLpBxYKdaJw?si=-gfNd2Y7B7k9cSdjTutorial on Styles:youtu.be/OVWAt9xoXzY?si=eYctTobyRIBFPrPbAssess yourself on Styles:youtu.be/u22M0HoCp4o?si=xu9ieBdtH7Rtb97j
2025 Feb/March Paper 31, Tasks 1 & 2, Cambridge 0417 ICT [IGCSE] Part 1 Nicos Paphitis 2025-08-27 | This is the first of 3 parts of the 2025 Feb/March paper 31. In this tutorial i solve Tasks 1 and 2. Tasks 1 and 2 cover the creation of the Evidence document and file management.You can access Task 3, the Web Design component soled with Dreamweaver here:youtu.be/eXsnfaYmKfwYou can access Task 3, the Web Design component soled with Expression Web here:youtu.be/ziVcxagHXJMYou can access Task 4, the Spreadsheet component here:youtu.be/kB1M1mZa6YU------------------------------------------------------------------------------0.00 IntroTask1 0:47 Evidence DocumentTask 202:37 File Management. Important info on displaying file info here.
Databases Made Easy: Full explanations and Practical Examples | Complete IGCSE ICT Guide [0417] Nicos Paphitis 2025-07-29 | Learn everything you need to know about databases in this complete, easy-to-follow guide — perfect for IGCSE Cambridge ICT students and beginners!🔹 Understand database concepts🔹 Create and modify tables🔹 Build queries and use criteria🔹 Practice with real examples from the IGCSE syllabusWhether you're studying for the exam or just want to learn how databases work, this video breaks it all down in a simple and clear way.0:00 Intro02:39 What is data, database and information 04:07 An analogy to understand the difference of data, database and information 08:34 Organizing data to create a Flat File Database10:31 What is a Field and a Record 12:56 Looking at 2 variations of Flat Files to resolve an issue and the problem each method creates19:16 Identifying that our current Flat Files do not have field which is unique20:23 Breaking our Flat File into separate tables (normalizing)22:21 The issue of linking the tables together. 25:00 Creating a Unique field (Primary Key). Examples of unique fields in different types of databases and their need.28:02 Liking the individual tables. Creating Relationships. 30:29 Understanding a 1 to Many Relationship 32:15 Appropriate naming for Fields 33:58 Primary Key and Foreign Key37:55 Different types of Data types and their limitations. Assigning Data types for Fields. Understanding what Data types are. - Text - Numeric (integer, decimal) - Boolean - Date/Time48:00 Planning a database so we can create it in Access (Field names, data types, Validation)54:20 Quick recap on what we have done up to the point where we have the plan for our database.57:24 Understanding what a Query is 01:00:48 Understanding Reports01:07:01 Creating the database in Access 01:07:52 Creating the student table 01:10:56 Adding an Input Mask (input mask symbols) 01:14:54 Date formats01:15:35 Checking your Regional settings to avoid date format issues and Import errors.01:20:52 Creating the Test Table. Validation rule added01:27:35 Creating the Parent Table. Adding a mask for the Telephone01:32:31 Creating the relationships between tables 01:34:34 Understand what Enforcing referential integrity means01:36:48 Creating a Query 01:41:29 Changing the data and running the Query to see that the query will display the new results01:42:53 Creating a Report based on the Query. Demonstrating grouping 01:46:43 Seeing how the report updates when the data in the tables change.01:47:30 Sum up Download the resources i used in the tutorialdropbox.com/scl/fo/m2zox07fiey4y91ro4mz2/AJJnJOKXZ3fdrbMYAdipmqw?rlkey=j9z9kjrkp0kebis9ec2irty8v&st=ltiq4g10&dl=0
MIE Expert 2025-26 Self-Nomination COMPLETE guide. New and Returning MIEEs Nicos Paphitis 2025-05-17 | This is a COMPLETE tutorial for educators that are interested in nominating themselves as Microsoft Innovative Educator Experts (MIEE). The nomination process is the same for both new and returning MIEE's. This tutorial covers all the steps for someone to become an MIEE, from creating their account in Microsoft learn, completing the required modules and learning paths and completing and submitting the nomination survey. Links to the document used in the tutorial and the SWAY from Microsoft Education can be found at the bottom of this description.0:00 Introduction on what this tutorial will cover-----------------------------------------------------------------STEP 1 (create your Learn Account)02:05 Create a Microsoft Learn Account 05:14 IMPORTANT, check privacy settings and make sure it is set to OFF 06:21 Link a personal account to your Learn account------------------------------------------------------------------Step 2 (Access the Nomination Questions Document)08:57 Access and review the Nomination Questions document. Get it here: dropbox.com/scl/fi/tkrhyk81rrr24l8erlpfz/MIE-Expert-application-questions-2025-2026.docx?rlkey=k7rmo0nf5a65p0lwq161vdh6x&st=x3cwau19&dl=014:53 IMPORTANT INFO about completing the long form questions here------------------------------------------------------------------Step 3 (Completing the required Learning Paths and Modules)16:44 Understanding and completing a Module20:42 Understanding and completing a Learning Path22:21 Viewing your completed Modules and Learning Paths23:56 IMPORTANT that privacy settings are OFF24:25 Make sure you have a personal account linked to your Learn account25:37 Creating a link to your Achievements. 26:42 Testing your Achievements link to make sure it is ok27:36 What NOT to do when creating your Achievements link------------------------------------------------------------------Step 4 (The Nomination Platform)27:54 Login or Signup to the Nomination Platform: https://aka.ms/edunominate31:50 After you have logged in save your ID number------------------------------------------------------------------Step 5 (Completing the Nomination Survey)33:38 Completing the Survey34:46 About You section39:40 Microsoft Learn Requirements 40:19 Adding the URL to your Achievements in Microsoft Learn IMPORTANT INFO: What happens if you have not completed all the requirements in Learn and I add the URL42:57 Microsoft Tools Usage 46:01 Long Form Question A 47:11 IMPORTANT INFO when pasting your response into the survey. You TYPE at least one character in the form. 48:37 CAREFUL before you click on Next 49:23 Here I had an issue moving to next. Eventually I moved to previous and then next to resolve the issue.51:15 Long Form Question B 51:46 How to check the number of characters of your answers in Word 52:57 Make sure you TYPE one character in the long form question if you have pasted your response.53:09 Accept the Terms and Conditions and Submit 53:59 The confirmation Screen after submitting and what you will see when you sign in to the nomination platform after submitting54:55 Recap. IMPORTANT POINTS highlightedLink to the Nomination Questions Document:dropbox.com/scl/fi/tkrhyk81rrr24l8erlpfz/MIE-Expert-application-questions-2025-2026.docx?rlkey=k7rmo0nf5a65p0lwq161vdh6x&st=rcek5ti6&dl=0Link to the SWAY:https://sway.cloud.microsoft/ol5rqgEQ51ThCl7K?ref=Link
2023 June Paper 11, Cambridge 0417 /0983 ICT [IGCSE] THEORY Nicos Paphitis 2025-05-04 | In this tutorial I solve the Theory paper 2023 June Paper 11, but also cover the topic of each question using resources you can download from the link at the bottom of this description. This is a fantastic resource for all students taking the Cambridge IGCSE ICT 0417 / 0983 course.0:00 Intro01:18 Question 1 Data types03:52 Question 2 Components of a computer. Various components are identified with explanations of their purpose Primary and secondary storage explained Understanding RAM and ROM21:55 Question 3 Understanding procedure to upload files25:47 Question 4 Understanding the purpose of a web browser What is Internet, Intranet, Extranet35:59 Question 5 Physical safety and health issues from effects of ICT. Various safety issues identified and explained48:37 Question 6 Passwords, secure passwords, benefits and drawbacks00:58:13 Question 6b Biometric methods of authentication01:00:59 Question 7 Systems Life Cycle, explaining all the steps in the cycle Analysis, Design, Testing, Implementation, Documentation, Evaluation01:23:10 Question 7b Understanding cloud storage and how it can be used01:27:14 Question 7c understanding Web and Video conferencing, Webcast, Webinar01:35:50 Question 8 Automated data entry methods01:48:58 Question 9 Absolute and relative file paths explained02:09:59 Question 10 Interfaces, the different types and where each would be used. 02:20:11 Question 11 Storage devices, Magnetic, Optical, Solid State. Uses, advantages disadvantages02:30:31 Question 12 Everything about Media streaming, what is it and how does it work.02:40:51 Question 13 Image file types. Understanding the differences and how you would choose the right type. bmp, gif, jpg/jpeg, png, tiff/tiff Image quality02:55:13 Question 14 Proof reading, Validation, Verification-------------------------------------------------------------------------------Links:Link to the Live stream recording on theory:youtube.com/live/WATnP3ekkuw?si=Wapq4BffEPrxA2jjLink to download the resource i used in this tutorial:dropbox.com/scl/fi/z0petgaqbs97l6qqw9uvr/Live-Stream-1-_Theory-revision-questions.pdf?rlkey=nmd04iiqng118cy82uys1gf1b&st=genu0q8d&dl=0
Theory Revision ICT IGCSE 0417 / 0983 Nicos Paphitis 2025-04-30 | This stream is to support students taking the ICT IGCSE Cambridge 0417 course. During the live stream i will be walking through selected theory questions which require students to relate to real experiences or scenarios as opposed to memorization questions.0:00 Intro7:56 The structure on how i will be answering the questions8:40 Question 1 - Microprocessor and Smart devicesLearn about Microprocessors controlled devices and Smart devices.25:14 Question 2 - how sensors work and send data to the processor. Types of sensors and what they are used for.33:51 Question 3- Use of Microprocessors in transport devices. Examples and uses of different microprocessor devices.43:09 Question 4 - E-safety, using Internet, Social networking, Gamming, Email55:47 Question 5 - Virtual Reality01:08:21 - Question 6 - Augmented reality01:19:01 Question 7 - Different types of devices, how to decide on best device 01:27:52 Creating Paper or Electronic Forms01:32:30 Question 8 - Data Protection, what is it and why is it needed.01:40:26 Question 9 - Web conference, video conference, webcast, webinar01:52:54 Question 10 - Artificial Intelligence, what is it, it's positive and negative impacts in different areas.02:05:54 Question 11 - Physical Tokens / Safety procedures when downloading files02:16:00 Question 12 - Copyright legislation, Text, Art, Music, Software02:26:24 Question 13 - Interfaces02:40:45 RFID, what it is, how it works and its uses with examples02:51:54 Expert Systems explained03:07:35 A thank you note from me03:10:48 I go to get Leslie :)03:12:53 Leslie makes her appearanceResources i used:link to the pdf resource used in this Live stream.dropbox.com/scl/fi/z0petgaqbs97l6qqw9uvr/Live-Stream-1-_Theory-revision-questions.pdf?rlkey=nmd04iiqng118cy82uys1gf1b&st=wydw68u2&dl=0Expert systemshttps://thejuniorschool-dropbox.com/scl/fi/ua5bjjwgzjhymd6nvdsa2/Expert-Systems.pdf?rlkey=bre7koe64d6zvddbkw3jc7twt&st=ovcfpahp&dl=0
ICT IGCSE Paper 1 HELP [Cambridge ICT 0417 / 0983] Nicos Paphitis 2025-04-20 | Joint me on 30/04/2025 at 17:00 Gmt+3 where i will be helping you unlock the secrets of the dreaded Theory Paper 1.I will be analyzing and answering 12 strategically selected questions to help you prepare for your upcoming exam.Link to the stream:youtube.com/live/WATnP3ekkuw?feature=share
Expression Web, 2024 Feb/March Paper 31 Web Design [IGCSE 0417, 0983 ICT] Nicos Paphitis 2025-04-01 | In this video i explain and solve the Cambridge IGCSE ICT 0417, 0983 Feb/March 2024 Practical paper 31 Web Design component using Expression Web.For Tasks 1 & 2 of this paper (Evidence doc, Image editing and file management) see this tutorial:youtu.be/2xwizpv-ikw?si=HIkx8F-4-RFYc-uyFor the Spreadsheet component of this paper please see the this tutorial:youtu.be/Gk4t1wW0X4E?si=V7-nqR7BiS-kyo-QAs in all my tutorials i show variations of questions and give important tips on solving the paper.A great resource for all students taking this exam but also for educators teaching the course and anyone who wants to learn more on Web Page Design with Expression Web. A link to the question paper and source files can be found at the bottom of the description.Use the time stamps in the description to jump to sections of interest.0:00 Introduction--------------------------------Task 3 Web Design--------------------------------00:33 Setting up the interface of Expression Web03:22 Q2 - Starting a new HTML file 04:28 Creating a table 05:07 Learning how to use the Tag Properties panel 05:43 Using HTML4 code instead of HTML5 to show borders in tables [Important Info] 07:37 Merging cells and setting cell dimensions (width height) 09:47 Q3 - Web page title10:36 Q4 - Adding images and setting dimensions, maintain aspect ratio (using 2 methods) 13:07 Adding a video tag (controls, auto play, fallback text) [Important Info Here] I forget to add the attribute for the video to use the width of the cell but I do it later on.19:26 Q5 - Adding Alternative text to images20:39 Q6 - Adding text and setting styles21:56 Q7 - Add text from a file and setting styles23:49 Q8 - CSS code (border collapse, border spacing, cell padding, font styles, efficient programming techniques) 37:42 Taking screenshot of the CSS38:38 Copying the HTML Source code39:39 Taking a screen shot of the webpage from the browser [Important Info Here, what to do and what NOT to do]44:28 Wrap upYou can download the Expression Web version i use here:dropbox.com/scl/fi/bkuk9r6ygzirmgc8uxw4b/microsoft-expression-web-4-0-1460-0.zip?rlkey=nnxl0j7hu0jrscj0ybm9jvlwb&st=7p8s46fa&dl=0
2024 June Paper 22, Cambridge 0417 /0983 ICT [IGCSE] Tasks 1 & 2 Nicos Paphitis 2025-03-25 | In this tutorial i solve Tasks 1 and 2 of the 2024 June Paper 22 of the ICT IGCSE exam 0417 / 0983. Tasks 1 and 2 cover the creation of the Evidence document, and the Word processing component.You can access the Databases and printing components (tasks 3 & 4) here:youtu.be/Y5hPinTBNFIYou can access the Presentation / chart creatin component (task 5) here:youtu.be/mf61o3LMq0E0:00 Intro--------------------------------------Task 1 (Evidence) & Task 2 (Document)--------------------------------------00:47 Read through the first sections02:41 create the evidence document (Tip on enabling the ruler)03:41 Q1- check the document, save as a Word document. 05:12 Q2- Header and Footer (important info on using the place holders)08:43 Q3- Change layout to columns, equal width with gap07:58 Q4- Modify a style13:22 Q5/Q6- Sorting a list and alignment15:21 Q7/Q8- Insert image, align and add a link to an email19:46 Q9/Q10/Q11- Tables, add remove columns and rows, formatting23:44 Q12- Checking for split lists/tables, widows orphans.--------------------------------------
2024 June Paper 22, Cambridge 0417 /0983 ICT [IGCSE] Task 5 Nicos Paphitis 2025-03-25 | In this tutorial i solve Task 5 of the 2024 June Paper 22 of the ICT IGCSE exam 0417 / 0983. Task 5 covers the Presentation / chart creation components of the exam.You can access the Word processing component (tasks 1 & 2) here:youtu.be/vZItIwZJFpQYou can access the Database and Printing components (task 3 & 4) here:youtu.be/Y5hPinTBNFI0:00 Intro--------------------------------------Task 5 (Presentation)--------------------------------------00:46 Q18- Create presentation from .rtf file01:45 Q19- Reading the instructions and setting up the Master slide (shapes, titles, page numbers etc..)04:12 Q20/Q21/Q22/Q23- Create a chart (important chart creating info here) 12:33 adding the chart to the slide13:31 Q25/Q26 Adding presenter notes and printing slide with presenter notes, printing 6 slides to a page15:13 Wrap up.
2024 June Paper 22, Cambridge 0417 /0983 ICT [IGCSE] Tasks 3 & 4 Nicos Paphitis 2025-03-25 | In this tutorial i solve Tasks 3 & 4 of the 2024 June Paper 22 of the ICT IGCSE exam 0417 / 0983. Tasks 3 & 4 cover the Databases and Printing components of this paper.You can access the Word processing component (tasks 1 & 2) here:youtu.be/vZItIwZJFpQYou can access the Presentation / chart creation components (task 5) here:youtu.be/mf61o3LMq0E0:00 Intro--------------------------------------Task 3 (Databases)--------------------------------------00:46 Q13- Import first csv as new table 06:03 Import second csv as new table09:43 Q14- Creating a one-to-many relationship11:06 Q15- Adding a new record in a table. (i demonstrate a quick data entry form also)14:14 Q16- Understanding what we have to do to create the report. (A lot of important tips here) 16:01 Creating The query 20:55 Creating the report based on the query.( here i demonstrate 2 ways to apply the sorting and the differences of each) 26:16 applying sorting in the design view of the report 27:45 finishing the report (IMPORTANT info on adjusting the filed row height to make the report fit on 2 pages)30:32 Q17- Understanding what we need to do to generate the labels. 32:46 creating the query to generate the labels. 35:03 Creating custom sized labels (IMPORTANT info on custom labels here) 38:27 Understanding the importance of selecting the query before creating the labels 40:38 Formatting the labels 42:12 modifying the margins to make sure we get 10 labels per page--------------------------------------Task 4 (Printing the Evidence)--------------------------------------43:43 Printing the evidence document
2024 Feb/March Paper 21, Cambridge 0417 /0983 ICT [IGCSE] Tasks 4 & 5 Nicos Paphitis 2025-03-25 | In this tutorial i solve Tasks 4 & 5 of the 2024 February / March Paper 21 of the ICT IGCSE exam 0417 / 0983. Tasks 4 & 5 cover the Presentation / chart creation and Printing components of the exam.You can access the Word processing component (tasks 1 & 2) here:youtu.be/y93OxW2vi18You can access the Database component (task 3) here:youtu.be/ZakuziDylnc0:00 Intro-------------------------------Task 4 [00:43 Presentation]-------------------------------00:43 Q18-Import slides rom a .rtf file02:00 Q19-Mater slide04:24 Q20-Applying slide layout 04:50 Q21-Deleting slides05:18 Q22 Q23 Q24 Q25 -Creating a Chart from .csv file and formatting (important tips here)10:57 Q26-Adding the chart to selected slide12:13 Q27 Adding a link to open a file13:41 Q28-Adding presenter notes and printing notes page14:30 Q29-Printing selected slides, 2 slides to a page-------------------------------Task 5 [15:25 Print evidence document]--------------------------------------------------------------15:33 Wrap up-------------------------------
2024 Feb/March Paper 21, Cambridge 0417 /0983 ICT [IGCSE] Tasks 3 Nicos Paphitis 2025-03-25 | In this tutorial i solves Task 3 of the 2024 February / March Paper 21 of the ICT IGCSE exam 0417 / 0983. Task 3 covers the Databases component of this paper.You can access the Word processing component (tasks 1 & 2) here:youtu.be/y93OxW2vi18You can access the Presentation / chart creating and printing components (tasks 4 & 5) here:youtu.be/UeRSefzo-FA0:00 Intro-------------------------------Task 3 [00:43 Data Base]-------------------------------00:43 Q11-Identifying the Primary key filed in a csv file and importing the csv file as a table. (important tips here)11:40 Q12 Q13-Import .csv files as tables without changing datatypes15:00 Q13-Create table relationships16:48 Q14-Add a record.(i also create a data entry form)21:12 Q16-Creating a query and report. (1st sorting method demonstrated)33:11 Q17-Creating a query and report. (2nd sorting method demonstrated)
2024 Feb/March Paper 21, Cambridge 0417 /0983 ICT [IGCSE] Tasks 1 & 2 Nicos Paphitis 2025-03-25 | In this tutorial i solve Tasks 1 and 2 of the 2024 February / March Paper 21 of the ICT IGCSE exam 0417 / 0983. Tasks 1 and 2 cover the creation of the Evidence document, and the Word processing component.You can access the Databases component (task 3) here:youtu.be/ZakuziDylncYou can access the Presentation / chart creatin and printing components (tasks 4 & 5) here:youtu.be/UeRSefzo-FA0:00 Intro-------------------------------Task 1 [00:50 Evidence Document]-------------------------------00:50 Checking files and setting up the evidence document.-------------------------------Task 2 [02:38 Word Processing]-------------------------------02:08 Q1-Checking and saving your document. (Important saving info here)05:49 Q2-Header and Footer. (Important tips here)08:13 Q3-Applying columns to text09:23 Q4-Numbering10:59 Q5-Create a style (important tip here)14:57 Q6-Apply styles15:37 Q7-Moving a paragraph17:05 Q8 Q9 -Inserting a shape, adding text and changing settings22:21 Q10-Checking your document
2024 Feb/March Paper 31, Cambridge 0417 ICT [IGCSE] Task 5 Spreadsheet Nicos Paphitis 2025-03-19 | In this tutorial i solve Task 5 of the February / March Paper 31 of the ICT IGCSE exam 0417. Task 5 covers the Spreadsheet component.You can access Evidence Doc, image editing, file management components (tasks 1 & 2) here:youtu.be/2xwizpv-ikwYou can access the Web Design component (tasks 3 & 4) here:youtu.be/vYjrjgmFoD80:00 Intro--------------------------------------------------Task 5 (Spread Sheets)--------------------------------------------------00:40 Q10- 00:40 Reading and understanding the scenario. Analysing the files.06:00 Saving the .csv file as a spreadsheet and formatting the table as requested09:36 Q11- Adding a header10:15 Q12- Vlookup12:12 Q13- Hlookup with reference for the return row17:22 Q14- Adding a calculation18:57 Q15- Adding a calculation (tricky question here). 21:58 Q16- 21:58 Creating custom currency symbol (important info here)24:48 Printing your formulas and values26:44 Testing my model to make sure everything is correct27:47 Wrap up of whole paper
2024 Feb/March Paper 31, Cambridge 0417 ICT [IGCSE] Tasks 3 & 4 Web design Nicos Paphitis 2025-03-19 | In this tutorial i solve Tasks 3 and 4 of the February / March Paper 31 of the ICT IGCSE exam 0417. Tasks 3 and 4 cover the Web Design component. In this tutorial i use Dreamweaver to solve this component. There is another tutorial where i solve this component using Expression Web. The link to that tutorial can be found at the end of the description.You can access Evidence Doc, image editing, file management components (tasks 1 & 2) here:youtu.be/2xwizpv-ikwYou can access the Spreadsheet component (task 5) here:youtu.be/Gk4t1wW0X4E0:00 Intro--------------------------------------------------Task 3 (Web Page)--------------------------------------------------00:43 Q2-00:43 Creating a HTML file and creating the table as displayed05:18 setting cell dimensions07:40 Q3- Add a page title (metatag)08:38 Q408:38 adding images and setting dimensions (maintaining aspect ratio) 10:33 add a video and set properties13:35 Q5-13:35 add alternative text to images 14:43 Q6-14:43 Adding text and formatting. Understand the difference between new line and new paragraph16:17 Q7-16:17 Copy paste text from text file. Important, Understand lines and paragraphs18:20 Q8- Analyzing question, saving file and attaching the stylesheet. Preparation before working in the stylesheet (important tips here)22:06 Adding a comment (important tip here)23:13 Centre align table (important tips here)25:06 Cell spacing (important tips here)27:50 Cellpadding 29:32 Setting up styles. Efficient programming techniques35:30 Q9- Adding evidence to the evidence document. Sizing the browser window and taking a good screenshot. (important info)--------------------------------------------------Task 4 (Printing the Evidence Document)--------------------------------------------------
2024 Feb/March Paper 31, Cambridge 0417 ICT [IGCSE] Tasks 1 & 2 Nicos Paphitis 2025-03-19 | In this tutorial i solve Tasks 1 and 2 of the February / March Paper 31 of the ICT IGCSE exam 0417. Tasks 1 and 2 cover the creation of the Evidence document, Image editing and file management.You can access the Web Design component (tasks 3 & 4) here:youtu.be/vYjrjgmFoD8You can access the Spreadsheet component (task 5) here:youtu.be/Gk4t1wW0X4E0:00 Intro--------------------------------------------------Task 1 (Evidence Document--------------------------------------------------01:00 Checking the files and setting up the evidence document--------------------------------------------------Task 2 (Image manipulation and Windows Explorer)--------------------------------------------------02:39 Q1-02:39 Image manipulation 05:25 Displaying file information in Windows Explorer (important tips here)
Magic School AI Complete Tutorial [ GREEK tutorial ] Nicos Paphitis 2025-03-05 | Ένα σεμινάριο για το MagicSchool AI για εκπαιδευτικούς. Ηχογράφηση του σεμιναρίου που διοργανώθηκε από: Προοδευτική Κίνηση Δασκάλων και Νηπιαγωγών με τίτλο:Ενδυνάμωση εκπαιδευτικών με Τεχνητή Νοημοσύνη και ενίσχυση της Διδασκαλίας00:00 Intro and looking at the results02:37 About the SWAY: bit.ly/122024AI05:10 Creating an account with magic school (Microsoft or Personal)08:28 The Interface11:07 Working with some of the Magic School Tools 11:10 Lesson Plan 16:10 Science Labs 19:08 Multiple Choice (using a prompt and using a resource) 25:10 DOK (Depth of knowledge questions) 27:17 Text Summarizer 29:40 Text Rewriter 33:53 Worksheet Generator 37:10 YouTube Summarizer and YouTube Questions40:18 Magic Student and creating rooms 41:014 Seeing a room and various tools as a sample before generating a room with tools 48:18 Creating a Room and adding tools 50:50 Adding tools to our room 52:09 Customizing the tools 52:18 Customizing Character chat bot 54:20 Customize AI Resource Bot 56:55 Customize the Math Review 58:48 Launching the Room and sharing the room59:19 Finding your rooms, creating a share join info, editing your room and tools01:01:22 Seeing student questions and responses01:02:15 Quick Recap on the SWAY Access the SWAY here: bit.ly/122024AI
HIDE your FORMULAS in EXCEL Nicos Paphitis 2025-03-01 | In this tutorial i demonstrate how you can hide your formulas in Excel. Also, how you can use this feature to help with Teaching and Learning.Let students see the results they should be getting, testing the data but not being able to see the formulas. Once they have completed their spreadsheet you can allow them to unlock the spreadsheet to see the formulas and check their work. Or, you may just not want others you share the spreadsheet with to see your formulas.Key points in this tutorial0:00 Intro03:08 Hiding your formulas and protecting the spreadsheet05:08 Unlocking some of the cells so users can edit07:09 How we can use this locked spreadsheet to support student learning and self-assessmentLink to download the Excel file i used in this video:dropbox.com/scl/fo/udwcd4rch8i326l2p86yj/AGUZxNa9jBWLISJ4tig3o88?rlkey=8bi7y45tgctnmoka90cehmg6j&st=ky9vjlmi&dl=0
Create and Train an AI Chat-Bot complete project. Teaching & Learning AI Nicos Paphitis 2025-02-18 | This tutorial focuses assisting students in completing a project on AI by creating and training a Chat-Bot. It is also a great tutorial for educators that want to introduce teaching AI in their curriculum. A fantastic learning activity which can be used to teach any topic.0:00 Intro01:53 Creating an Account with BotPenguin (botpenguin.com)05:16 The Chat-Bot Project09:22 Creating the Chat-Bot 10:36 seeing the interface after the sample chat-bot is created 12:45 Creating our chat-bot 29:21 Training our chat-bot using a website 31:51 Training with Frequently asked questions (FAQs)36:53 Producing the evidence for your project 37:12 Exporting your Chat Flow as a .json file 38:39 Adding the URL's of the websites you used to train and a screen shot of the website training page. 40:02 Exporting the FAQ categories with your questions and answers 41:54 quick recap on generating the evidence
HTML CSS Styles Practice Test [Cambridge IGCSE ICT 0417 ] Web Design Nicos Paphitis 2025-01-31 | This is an assessment to help your practice your skills in HTML styles. The test assesses you on External Styles, Internal Styles, Inline Styles and Class.A great learning resource for students that will take the Cambridge IGCSE ICT 0417 exams.00:00 Intro01:00 Open HTML document in Dreamweaver and create a new CSS document (external stylesheet).-------------------------------------Creating the External Style Sheet-------------------------------------02:50 Creating the styles for the table using efficient programming techniques Internal external borders (weight, color, style), border collapse, Width, alignment08:39 Attaching the style sheet to the web page and previewing the page10:52 Background colour and Hexadecimal colour12:31 Creating Heading styles and implementing efficient programming techniques16:43 Creating a Class-------------------------------------Creating Internal Styles-------------------------------------18:11 Creating internal styles.20:49 Creating internal styles with priority over the external stylesheet23:27 Applying a class to selected text and paragraph-------------------------------------Inline Styles-------------------------------------27:36 Applying an inline style29:52 Another example of how inline styles have the highest priority--------------------------------------------------------------------------------Download the resources and question paper used in this tutorial here: dropbox.com/scl/fo/kvv4spde93oz938urimht/AK4GZhINg1o-eb20gZoBcoM?rlkey=yhs25htcznwj9ui72khedrd7y&st=c4akktle&dl=0Here is a complete tutorial on Styles:youtu.be/OVWAt9xoXzY?si=iYZipSoNRhNOhVC8Here is a complete tutorial on Tables in webpages to understand the tags used in styles:youtu.be/pLpBxYKdaJw?si=STr6pHDn6S-9NbV2
Expression Web, 2024 November Paper 3 Web Design [IGCSE 0417 ICT] Nicos Paphitis 2025-01-25 | In this video i explain and solve the Cambridge IGCSE ICT 0417 November 2024 Practical paper 3 Web Design component using Expression Web.For the Spreadsheet component of this paper please see the this tutorial:youtu.be/xaGDkIcV65Uwhere i solve the entire paper but use Dreamweaver for the web design component.As in all my tutorials i show variations of questions and give important tips on solving the paper.A great resource for all students taking this exam but also for educators teaching the course and anyone who wants to learn more on Web Page Design with Expression Web. A link to the question paper and source files can be found at the bottom of the description.Use the time stamps in the description to jump to sections of interest.A link to the resource files and links to other tutorials to support your learning for this paper can be found below. 0:00 Intro----------------------------------------------Task 1 File Management----------------------------------------------00:43 Checking files and creating the Evidence document----------------------------------------------Task 3 File Management----------------------------------------------02:07 Creating folder and managing files ----------------------------------------------Task 4 Web Page [Using Dreamweaver]----------------------------------------------02:32 Q13- Open CSS and create 2 classes [a couple of methods demonstrated here] 03:25 Setting up Expression Web Interface 06:17 Q14- Removing borders of table, adding details and saving the web page09:18 Q15- Identifying paragraphs and creating them. Adding styles 13:08 Adding class to selected paragraph [Important info here] 15:13 Creating paragraphs and applying list style [Some Expression Web tips here]16:41 Q16 Q17- Adding page name and default target window17:52 Q18 Q19- Adding hyperlinks and target window19:11 Q20- Adding a character set and a page description21:13 Q21- Copying the HTTML source code and displaying your webpage in the browser [make sure your screenshots display all the info]24:04 Recap of paper--------------------------------------------53:44 Recap of paper------------------------------------Link to download the resource files for this paper:dropbox.com/scl/fo/zu6lxhfq9o722gd2rozv3/ACL2QlotT_q2-acMszOMor8?rlkey=g5khbc67act8xh7suzx4i1wys&st=3009cuyk&dl=0Link to tutorial on Web Design Metatags:youtu.be/tneUcymnuX4?si=RZbKHK6PV48mpx0KYou can download the Expression Web version i use here:dropbox.com/scl/fi/bkuk9r6ygzirmgc8uxw4b/microsoft-expression-web-4-0-1460-0.zip?rlkey=nnxl0j7hu0jrscj0ybm9jvlwb&st=7p8s46fa&dl=0
2024 November Paper 3, Cambridge 0417 ICT [IGCSE] Nicos Paphitis 2025-01-25 | In this video i explain and solve the complete Cambridge IGCSE ICT 0417 November 2024 Practical paper 3. As in all my tutorials i show variations of questions and give important tips on solving the paper.A great resource for all students taking this exam but also for educators teaching the course and anyone who wants to learn more on Web Page Design and Excel. A link to the question paper and source files can be found at the bottom of the description.Use the time stamps in the description to jump to sections of interest.A link to the resource files and links to other tutorials to support your learning for this paper can be found below. 0:00 Intro----------------------------------------------Task 1 Files and Evidence Document----------------------------------------------0:55 Checking the files and creating the Evidence Document----------------------------------------------Task 2 Spreadsheet----------------------------------------------01:54 Q1- Analyze the spreadsheet, adding header and saving file06:22 Q2- Formatting the spreadsheet 08:56 Text wrapping [nice tip here]10:39 Q3, Q4- Calculating Sum and Average11:57 Q5- Nested IF Function 13:40 Understanding IF and Nested IF functions 16:50 Entering the Nested IF Function 17:59 Checking the formulas to make sure they can replicate (Relative and Absolute references)19:49 Q6- Vlookup function with calculation, check replication21:58 Q7- Replicate formulas form questions 3 to 622:35 Q8- Format cells23:00 Q9- CountIF functions with replication24:57 Q10- 24:57 Printing the formulas27:13 Q11- Conditional formatting30:18 Format font and print showing values----------------------------------------------Task 3 File Management----------------------------------------------32:23 Creating folder and managing files----------------------------------------------Task 4 Web Page [Using Dreamweaver]----------------------------------------------32:53 Q13- Open CSS and create 2 classes [a couple of methods demonstrated here]36:17 Q14- Removing borders of table, adding details and saving the web page38:58 Q15- Identifying paragraphs and creating them. Adding styles 41:11 Adding class to selected paragraph [Important info here] 44:28 Creating paragraphs and applying list style45:59 Q16 Q17- Adding page name and default target window47:42 Q18 Q19- Adding hyperlinks and target window49:05 Q20- Adding a character set and a page descriptionQ21- Copying the HTTML source code and displaying your webpage in the browser [make sure your screenshots display all the info]53:44 Recap of paper------------------------------------Link to download the resource files for this paper:Due to copyright restrictions from CIE i am not able to provide the resource files for this paper. Please seek to get the resource files from your teacher.Link to tutorial on IF Functions (nested functions):youtu.be/X7EX9IjkuFM?si=CTrq9Kaoj9qCiJtBLink to tutorial on references in Spreadsheets (Absolute, Relative, Mixed):youtu.be/qgankq3WqAE?si=LQiyNrUu7x_9PhMrLink to tutorial on Web Design Metatags:youtu.be/tneUcymnuX4?si=RZbKHK6PV48mpx0K
2024 November Paper 2, Cambridge 0417 ICT [IGCSE] Nicos Paphitis 2025-01-19 | This is not an easy paper.In this video i explain and solve the complete Cambridge IGCSE ICT 0417 November 2024 Practical paper 2. As in all my tutorials i show variations of questions and give important tips on solving the paper.A great resource for all students taking this exam but also for educators teaching the course. A link to the question paper and source files can be found at the bottom of the description.Use the time stamps in the description to jump to sections of interest.0:00 Intro---------------------------------------------Task 1 (Evidence Document)---------------------------------------------01:03 Evidence document---------------------------------------------Task 2 (Document)---------------------------------------------02:40 Q1 renaming file, display file extension05:09 Q2 Removing page breaks (using the show/hide)07:00 Q3 Adding Header and Footer. Alignment09:24 Q4 Changing paragraphs to 2 columns10:51 Q5 - Q6 Sorting a list alphabetically and adding custom bullet [different ways demonstrated]14:48 Q7 - Q8 Creating a style based on normal. Applying styles [Important tips here]18:43 Q9 - Q11 Working with tables and table properties [Important tips here]21:09 Q12 Formatting paragraph, indenting, border and shading23:04 Q13 Checking the document---------------------------------------------Task 3 (Databases)---------------------------------------------23:50 Q14 Creating a database and Importing csv files as tables34:34 Q15 Create relationship between tables36:27 Q16 Creating a query 41:55 creating the report based on the query*********************A lot of important tips here**************************** 43:40 Sizing the fields in the report. We notice that not all fields imported in report. 46:41 method 1 to add a missing field in the report 49:40 method 2 to add a missing field in the report 53:11 Method 1 in applying sorting of the report 55:05 Method 2 in applying sorting of the report***************************************************************************** 56:50 A 3rd method of adding a missing field to the report 58:27 adding and center aligning a heading 59:07 adding a calculated field to find Maximum and add label. Why we do not use Text boxes 01:01:14 adding a Page Footer01:03:29 Q17 Creating a simple Data Entry Form01:05:21 Q18 Import a table from csv to be used as a list in a Drop Down List box in a data entry from*********************A lot of important tips here**************************** 01:07:13 Creating the Drop Down List Box in the data entry form 01:10:19 Aligning the objects in the entry form 01:10:42 Limiting entries to the list 01:11:50 Looking at the properties of the Drop Down List Box Here i will demonstrate how to ensure unique values are displayed in the list box as the paper does not demonstrate this 01:12:18 Demonstrating how to ensure UNIQUE values in the list (2 methods) 01:17:10 Creating the evidence and identifying what needs to be viewable01:19:40 Q19 Adding a record in to your data entry form.---------------------------------------------Task 3 (Presentation)---------------------------------------------01:21:51 Q20 Create a presentation and import slides01:22:44 Q21 Adding Header and Footer01:24:28 Q22 Modifying lists and bullets01:26:21 Q23 Delete slides01:26:45 Q24 - Q28 Creating a Pie chart from data in csv file [Important info here]01:32:30 Q25 Inserting a shape, size the shape and make the shape a link a slide in the presentation01:35:43 Q30 Printing your slides01:36:34 Recap and key takeaways on the paper----------------------------------------------------Download the files for this paper:Due to copyright restrictions from CIE i am not able to provide the resource files for this paper. Please seek to get the resource files from your teacher.----------------------------------------------------Link to tutorial on creating Charts in Excel as per requirements of the 0417 syllabus:youtu.be/jn3YX3SN2w8?si=o7hRCUhEQbgYbrOn-----------------------------------------------------Link to tutorial on PowerPoint:youtu.be/TRHfD3RP9cg?si=4sgBhGqVg44-Q1Ru
Pivot Tables & Charts Complete Guide with PRO Tips [3 Worked Examples] Nicos Paphitis 2025-01-03 | This is a complete tutorial on Pivot Tables for beginners and more advanced users in all fields. Included in the tutorial are some Pro Tips like auto refreshing data and more (DONT MISS THESE).Unlike other tutorials this one also caters for Schools and Educators with 3 worked examples, 2 of which focus on a school environment.Worked Example 1: focuses on a Sales spread sheet.Worked Example 2: focuses on information about detentions exported from a school MIS and demonstrates how a pivot table can be create to provide useful and easy to read information and identifying trendsWorked Example 3:focuses on an Export of Grades from a Microsoft Class Teams and how Pivot tables can be generated easily to create interactive dashboards.0:00 Intro-----------------------------------------------------------------------------------------------------------01:11 Worked example 1, Sales Spreadsheet 01:46 Pro tip - Use tables. Creating a table from the data range 03:24 Analyze the data so that we know what we will be working with and what info we want to the Pivot table to display 05:47 Creating a Pivot table 05:45 Enable disable the Field list 06:05 Adding fields to our Pivot table 07:10 Adding a sum field and how to change to a different calculative field (average) 08:21 Adding a second field as a row and changing the order of priority 09:32 Pro tip - display field names instead of Row Labels 10:22 Using the field filters 10:47 Adding Slicers 11:35 Creating a new calculated filed 12:59 Adding a date filter and then a Timeline Slider 15:03 Adding a count of sales for each sales person 15:49 Removing subtotals 16:17 Formatting data in the Pivot table 16:45 Creating a second Pivot table 17:56 Managing filters and slicers and choosing which Pivot tables they effect 19:07 Creating and modifying a chart based on a Pivot Table 20:40 Pro tip - Managing all filters and the Pivot tables they effect.-----------------------------------------------------------------------------------------------------------21:44 Worked example 2 School MIS Export (Detention fie) 22:58 Create a table from the data range and creating a Pivot table 23:54 Understanding what we want the Pivot table to display 24:25 Adding rows to the Pivot table 24:42 Display the filed names as column headers 25:02 Adding another field as columns 25:50 Adding a Count filed and checking which field can be used 27:00 Analyzing the info displayed in the Pivot table 27:10 Sorting the data in the Pivot table, adding Conditional Formatting 28:19 Adding Slicers for filtering 29:23 Adding a date filter and Date Timeline 29:58 Using the Pivot table and filters to identify trends in behavior 30:44 Adding another filter for Gender 31:24 Adding new data in in the data source and manually refreshing the Pivot Table 33:00 Pro tip - Auto refreshing the Pivot table whenever the workbook is opened 34:34 Creating a second Pivot Table using a date field for Rows and creating a chart 37:44 Managing filters and which Pivot tables they effect-----------------------------------------------------------------------------------------------------------38:23 Worked example 3 Microsoft Teams Grades Export 38:35 Exporting the Excel file from Teams 39:54 Creating a Pivot Table. No need to convert data to table as it is already a table 40:59 Adding rows to my Pivot table and changing priority of fields 42:11 Adding a field with Average score 43:28 Formatting values 44:00 Adding a slicers as filters 46:23 Adding a date filter and a Timeline. Filtering results based on term using the timeline 48:03 Creating a chart 49:11 Modifying the options so for auto refresh of data and adding Field names for column headers 50:03 Sum up of the Pro Tips mentioned in the tutorial.Link to download the source file i used in the tutorial:dropbox.com/scl/fi/xnp2nc3onn56rvfj83lmk/Pivot-tables-Data.xlsx?rlkey=juqzakmrrodecc5xrj7kaaxhy&st=w0q36xl0&dl=0
Expression Web, 2024 June Paper 31 Web Design [IGCSE 0417 ICT] Nicos Paphitis 2024-12-27 | In this video i explain and solve the Cambridge IGCSE ICT 0417 June 2024 Practical paper 31 Web Design component using Expression Web.For the Spreadsheet component of this paper please see the this tutorial:youtu.be/UvJ_ygwe6EI?si=X6NexGAazV67FV9- where i solve the entire paper but use Dreamweaver for the web design component.As in all my tutorials i show variations of questions and give important tips on solving the paper.A great resource for all students taking this exam but also for educators teaching the course and anyone who wants to learn more on Web Page Design with Expression Web. A link to the question paper and source files can be found at the bottom of the description.Use the time stamps in the description to jump to sections of interest.0:00 Intro0:47 Looking at the question paper 01:46 Setting up the interface for Expression Web02:48 Q11- Creating a new .htm file and removing unnecessary code 04:31 Creating a table, merge cells, set inline attributes like cell width and height08:59 Q12- set page title09:29 Q13-Q14- Enter text and set styles11:22 Q15-Q16- inserting images 11:36 Nice tip from Mark Hamilton: Open Site so as to have quick access to files you will use 12:52 inserting the images and adding alternate text15:13 Q17- Adding text from file16:23 Preview the webpage in the browser16:46 Q18- attach an external stylesheet17:47 Q19 - creating an external stylesheet and saving 20:06 adding a background image top left corner 21:35 Align table to the right 22:52 Attaching a second external stylesheet as higher priority 24:50 Creating font tag using efficient programming 26:41 Adding a comment28:54 Creating the required screenshots and appropriate evidence33:05 Wrap upLink to download the resource files for this paper:dropbox.com/scl/fo/k2f9jdhp8qmty3y2k6i40/AHV7aXZI2BgITH7cWBnMbpA?rlkey=ez2lnuvhrw219a5ueraxo7jde&st=v4ibc2qf&dl=0Link to the complete tutorial which includes the Spreadsheet part for this paper but solving the Web Design section with Dreamweaver:youtu.be/UvJ_ygwe6EI?si=X6NexGAazV67FV9-You can download the Expression Web version i use here:dropbox.com/scl/fi/bkuk9r6ygzirmgc8uxw4b/microsoft-expression-web-4-0-1460-0.zip?rlkey=nnxl0j7hu0jrscj0ybm9jvlwb&st=7p8s46fa&dl=0
2024 June Paper 3, Cambridge 0417 ICT [IGCSE] Nicos Paphitis 2024-11-10 | In this video i explain and solve the complete Cambridge IGCSE ICT 0417 June 2024 Practical paper 32. As in all my tutorials i show variations of questions and give important tips on solving the paper.A great resource for all students taking this exam but also for educators teaching the course and anyone who wants to learn more on Web Page Design and Excel. A link to the question paper and source files can be found at the bottom of the description.Use the time stamps in the description to jump to sections of interest.00:00 Intro. Why i have a plunger on my head.---------------------------------Task 1 Evidence Document---------------------------------01:46 Creating the evidence document---------------------------------Task 2 Spreadsheets---------------------------------03:44 Q1 analyse the spreadsheets and try to determine what you will have to do. 09:17 Adding Header and Footer11:01 Q2 Q3 Q4 VlookUp functions, replicating the formulas.15:29 Q5 COUNT or COUNTA function17:32 Q6 COUNTIFS function (full analysis of building the function). Here i also demonstrate how to use Wildcards in the criteria and how you can include logic symbols if you want.22:30 Q7 Inserting Rows (mulpiple ways)23:11 Q8 COUNTIFS function. Using a cell reffrence and demonstrating the need for absolute references.26:48 Q9 Formatting the spreadsheet31:24 Q10 Printing formulas. Make sure the formulas are not cut off. Adjusting so that you print on less pages.34:37 Q11 filtering the data and printing the selection. 2 methods of filtering the data demonstrated. Small trick when using the snipping tool demonstrated.---------------------------------Task 3 File Management---------------------------------37:53 Q12 File management and displaying file information---------------------------------Task 4 Web Design---------------------------------41:44 Q13 Creating a HTML document and creating a table based on question45:16 Q14 Page title46:23 Q15 adding images to the table. 47:24 Adding a video and different video attributes for the video (Here i demonstrate the various controls. 51:04 Understanding the fall back text and how to add multiple sources of video types so that the browser will open the next video type if the first is not supported.53:22 Q16 Q17 Adding text (how to add a new line and a new paragraph)55:33 Q17 Attaching a stylesheet 56:51 Q18 Adding link to image to local page57:53 Adding a link to an image to an email with subject line.59:26 Save your work and make sure you add all the evidence. Getting a copy of the source code Getting a good screenshot of your webpage in the browser01:03:31 Recap ---------------------------------------------------------------------Access the resource files used in the tutorial here:Due to copyright restrictions from CIE i am not able to provide the resource files for this paper. Please seek to get the resource files from your teacher.
Expression Web, 2024 June Paper 32 Web Design [IGCSE 0417 ICT] Nicos Paphitis 2024-11-10 | In this video i explain and solve the Cambridge IGCSE ICT 0417 June 2024 Practical paper 32 Web Design component using Expression Web.For the Spreadsheet component of this paper please see the this tutorial:youtu.be/L5GLg98DIns where i solve the entire paper but use Dreamweaver for the web design component.As in all my tutorials i show variations of questions and give important tips on solving the paper.A great resource for all students taking this exam but also for educators teaching the course and anyone who wants to learn more on Web Page Design with Expression Web. A link to the question paper and source files can be found at the bottom of the description.Use the time stamps in the description to jump to sections of interest.0:00 Intro-----------------------------Task 3 File Management-----------------------------00:43 Q12 File management-----------------------------Task 4 Web Design-----------------------------05:07 Q13 Creating a table 05:07 Setting up Expression Web interface 08:11 creating a table (setting width, borders) 10:10 merging cells11:38 Q14 adding Page Title12:25 Q15 Adding images (different methods demonstrated). Adding Alternative text 15:51 Adding video. Using the video tag not the insert media 18:46 adding video attributes: controls, autopay, loop and adding fallback text 20:18 adding multiple video sources and explaining how the browser will choose the second option if the first is not supported.23:42 Q16 Q17 adding text and applying format style.25:44 Q8 Attaching an external stylesheet26:42 Adding a hyperlink to a local webpage. (IMPORTANT TIPS HERE)30:33 Adding a hyperlink to an email with subject31:57 Adding HTML code in evidence document and creating an appropriate screen shot of your webpage in the browser.34:57 Recap---------------------------------------------------------------------Access the resource files used in the tutorial here:dropbox.com/scl/fo/2r13cfas9hp389n5k5gpp/AHFY6cEn61QgRpfe2XtcKRo?rlkey=grps00a6xl4pvwp433haexdj4&st=hmknev0l&dl=0---------------------------------------------------------------------Use this link to see the tutorial where i solve the entire paper including the Spreadsheet component and the Web Design with Dreamweaver:youtu.be/L5GLg98DIns----------------------------------------------------------------------You can download the Expression Web version i use here:dropbox.com/scl/fi/bkuk9r6ygzirmgc8uxw4b/microsoft-expression-web-4-0-1460-0.zip?rlkey=nnxl0j7hu0jrscj0ybm9jvlwb&st=7p8s46fa&dl=0
Excel Productivity Hack [Power Query]: Transform Data Like a Pro and Save Time! Nicos Paphitis 2024-11-03 | Learn how to Transform Data Like a Pro in Excel using Power Query! In this comprehensive tutorial, I walk you through setting up and using Power Query to streamline data preparation, automate transformations, and save time on repetitive tasks. Generate dynamic pivot tables and charts from Power Query results. Follow along with a worked example, using files you can download below.0:00 Intro (see bottom of description to download the files and follow along)01:59 Planning is key.02:55 Review the folder with the data and what i will be doing in this worked example.05:51 Creating setting up the Power Query Editor09:17 The query Editor Interface10:52 Transforming data in the editor11:40 Rearranging columns11:55 Generating new column by concatenating data from 2 columns.14:09 Creating a new column using Conditional Column using the Wizard16:11 Removing unwanted columns17:14 Merging data from 2 columns using Custom column and IF function (manual entry of condition)19:41 Generating a new column populated with new string data20:21 New column generated based on logical check on data in a different column22:14 Create a new Blank column22:49 Generating the last columns with new data to populate the columns24:30 Closing and loading your Power Query25:47 Changing data in the original lists and seeing Power Query update26:29 Deleting a file used in Power Query and seeing that Power Query updates27:06 Adding a new file to the folder and seeing how Power Query will automatically transform the data and include the data in the results28:19 Creating a Pivot Table and Chart based on the Power Query and seeing how these update automatically as the original data is changed.31:20 Wrap up----------------------------------------------------Download the files i use in the tutorial to follow along and learn.dropbox.com/scl/fo/yxu5pl64rhf0r5ejke56w/ADaIdBBzCeatxyVr-M72DPo?rlkey=cppf4y4ohqq2a2xerzidpilus&st=nnooe25m&dl=0
How to open MULTIPLE INSTANCES of Microsoft TEAMS. Nicos Paphitis 2024-10-27 | Working with one instance of Teams can be frustrating and annoying as there is no native way to open multiple instances. In this tutorial i demonstrate the difficulties of using one instance and how to easily and quickly start multiple instances with a double click of the mouse with no sign in needed.
Expression Web Head section Meta tags - Cambridge ICT IGCSE 0417 Web Design Nicos Paphitis 2024-10-20 | This tutorial focuses on the HEAD section of a webpage, the commands and Meta Tags required to fulfil the skills required in the Web Design component of the Cambridge IGCSE ICT 0417 examination. Detailed explanations of the tags and their purposes, and how to implement them in Microsoft Web Expression. Also included, tips and tricks to remember how to add the tags and explanations of hierarchy with stylesheets.0:00 Introduction (the skills that will be covered based on the exam syllabus)---------------------------------------------------------Intro to meta tags and understanding the purpose of each---------------------------------------------------------03:12 Identifying and understanding the HTML, Body and Head section of a webpage03:58 Reviewing and understanding the purpose of all the required tags added in the head section 03:58 Adding a page title 04:54 Default target window 06:08 Link to style sheets. Understanding Hierarchy 08:24 Metatags Character Set Page description Keywords Author Viewport----------------------------------------------------Working with Expression Web----------------------------------------------------13:47 Looking at the 2023 June paper 31 Web Page component of the exam.15:00 Setting up your workspace in Expression Web16:04 removing any extra code from the default blank web page-------------------------------Adding the tags by typing code------------------------------- 17:25 Adding the Page Title 17:52 Adding Character set (charset) using the default code and by typing the code 19:34 Adding the Author 21:04 Adding the Pager Description 21:50 Adding Keywords 23:04 Adding the Default Target Window 24:00 Adding Viewport-------------------------------------------------------Adding the tags using the Page Properties dialogue box-------------------------------------------------------27:35 Starting from a new default HTML page. Adding thee character set28:29 creating the tags using the page properties Page Properties Page description Keywords Target Window Author31:32 Adding viewport through the dialogue box 32:27 Adding any other meta tag you are asked to add ------------33:26 Wrap up------------The complete syllabus outlining all the skills required for the 0417 ICT Exam for 2023 - 2025 can be downloaded here:dropbox.com/scl/fi/reczcx3l3hnc0ofl5osd7/0417-ICT-2023_25-Syllabus.pdf?rlkey=mihofgwjo2ulxp2pgy5qgrcpg&dl=0Download a copy of the document used in the tutorial:dropbox.com/scl/fi/1duwoxea75vnzpq2350u4/Webpage-header-info.pdf?rlkey=xuofqhz1kec6asppakkc01c0n&dl=0You can download the Expression Web version i use here:dropbox.com/scl/fi/bkuk9r6ygzirmgc8uxw4b/microsoft-expression-web-4-0-1460-0.zip?rlkey=nnxl0j7hu0jrscj0ybm9jvlwb&st=7p8s46fa&dl=0
HTML Styles Complete Guide (External, Internal, Inline, Classes) [Dreamweaver] ICT IGCSE 0417 Nicos Paphitis 2024-10-13 | This is a complete tutorial on styles in web design using Dreamweaver and is primarily focused on the requirements for the Cambridge 0417 ICT IGCSE syllabus, but is a great tutorial for anybody that wants to learn about External stylesheets, Internal Styles, Inline Styles and Classes.Use the timestamps below to see what is contained in this tutorial and to jump to points of interest. All the files I used for this tutorial can be downloaded from the link at the bottom of this description.0:00 Intro------------------------Understanding Styles------------------------01:01 The 3 layers of web design03:12 Understanding what styles do using External Stylesheets05:47 Looking at the declaration of an external stylesheet in HTML code.07:09 Looking at the declaration of an Internal style in HTML code.08:29 Understanding precedence in of Internal and External styles.10:30 Looking at the declaration of in-line styles in HTML code.11:35 Understanding precedence in of Internal, External and in-line styles.12:52 Understanding classes17:37 Seeing an example of the same webpage with External, Internal and In-line styles applied.-------------------------------------------------Dreamweaver layout and analyze the HTML document-------------------------------------------------19:21 Opening our HTML document in Dreamweaver and looking at the layout.21:13 Analyze the HTML document to see what we are going to be adding styles to.------------------------External Stylesheets-----------------------22:55 Crating and external stylesheetAdding selectors to the external stylesheet 23:43 Adding the selectors: Body, H1, H2, P, Li, 27:14 Efficient programming technique with the selectors Table and Td 28:15 Selector for table to align table to the center of page 30:00 Attach the stylesheet to a HTML document and view the modified HTML document31:34 Creating a Class in the external stylesheet33:20 Applying a class in the HTML document.35:46 Viewing our HTML document with the external stylesheet attached in the browser.------------------------Internal Styles-----------------------36:26 Creating Internal styles and classes. We use external stylesheet to make it easier38:28 Copy the styles into the HTML document in the style tag. Making sure it is after the link to the external stylesheet as internal styles have priority.40:40 Adding the internal class to a heading.------------------------InLine Styles-----------------------42:14 What is classified as an inline style. Example of old HTML code style and more modern CSS format inline style with examples.44:26 adding an inline style which and seeing how it has priority with examples48:17 Adding inline styles directly to text.49:22 Adding inline style to tags that are not modified by other styles (external or internal)50:05 Adding Internal style to a list, both to all items in the list or single item.-------------------------------Examples of Priority of Styles-------------------------------52:00 Modifying properties in the CSS style directly or from the CSS properties window53:54 Changing the order of entries in the stylesheet to see the cascading priority of styles.Useful Links:Working with tags (CSS): youtu.be/QetPGCbg7vo?si=mXrs003t1FJ_mZZuPlay list on Dreamweaver: youtube.com/playlist?list=PLWeerq9oa1neV2G4NC5Kt39_bK7zFcZfsLink to download the files (web page and images) used in this tutorial:dropbox.com/scl/fo/v3yw3ildojni4bc1hcs57/AOf-QDbqXYwStjAA1AYLpIw?rlkey=mgs78escwa40qe2z0wzsex3gr&st=gai6dkou&dl=0
HTML Styles Complete Guide (External, Internal, Inline, Classes) [Expression Web] ICT IGCSE 0417 Nicos Paphitis 2024-10-08 | This is a complete tutorial on styles in web design using Microsoft Expression Web and is primarily focused on the requirements for the Cambridge 0417 ICT IGCSE syllabus, but is a great tutorial for anybody that wants to learn about External stylesheets, Internal Styles, Inline Styles and Classes.Use the timestamps below to see what is contained in this tutorial and to jump to points of interest. All the files I used for this tutorial can be downloaded from the link at the bottom of this description.0:00 Intro------------------------Understanding Styles------------------------01:01 The 3 layers of web design03:12 Understanding what styles do using External Stylesheets05:47 Looking at the declaration of an external stylesheet in HTML code.07:09 Looking at the declaration of an Internal style in HTML code.08:29 Understanding precedence in of Internal and External styles.10:30 Looking at the declaration of in-line styles in HTML code.11:35 Understanding precedence in of Internal, External and in-line styles.12:52 Understanding classes17:37 Seeing an example of the same webpage with External, Internal and In-line styles applied.------------------------Expression Web-----------------------19:22 checking files, start Expression Web and set up the interface 23:03 Configure your page editor options -----------------------External Stylesheet-----------------------23:48 Creating an External Stylesheet24:16 Adding selectors: body, h1, h2, custom font names29:01 Add selectors table and td using efficient programming technique. Add unique properties for table selector.32:00 Table selector so that table is aligned to center of page33:33 Attach your external stylesheet and preview your webpage in the browser.35:05 Adding the P selector to the stylesheet37:05 Identifying the code that links the stylesheet to the HTML document in the head tag.38:23 Creating a class and demonstrating how to add the class to a tag. Seeing how Class has priority.43:16 Modify the styles in the Stylesheet43:53 Seeing what border collapse = separate looks like and changing to collapsed.-----------------------Internal Styles-----------------------45:10 Understand that internal styles MUST be placed after the link to any external stylesheets46:25 Creating internal styles47:52 Modifying the list tag li in the internal style.49:03 adding a class in the internal styles49:46 Add the created internal styles to the HTML document (Placement id IMPORTANT)51:01 Demonstrating precedence of internal styles over external stylesheets.52:36 Add a class from the internal styles to a HTML tags-----------------------Inline Styles-----------------------54:23 Understanding that inline styles are entered in the HTML tags55:45 Adding an inline style to the P tag. 57:03 modifying an inline style57:49 Old inline style type and the new CSS style of inline tags.59:15 Adding inline styles to modify the image size.01:00:00 Wrap upUseful Links:Working with tags (CSS): youtu.be/QetPGCbg7vo?si=mXrs003t1FJ_mZZuPlay list on Dreamweaver: youtube.com/playlist?list=PLWeerq9oa1neV2G4NC5Kt39_bK7zFcZfsLink to download the files (web page and images) used in this tutorial:dropbox.com/scl/fo/v3yw3ildojni4bc1hcs57/AOf-QDbqXYwStjAA1AYLpIw?rlkey=mgs78escwa40qe2z0wzsex3gr&st=gai6dkou&dl=0You can download the Expression Web version i use here:dropbox.com/scl/fi/bkuk9r6ygzirmgc8uxw4b/microsoft-expression-web-4-0-1460-0.zip?rlkey=nnxl0j7hu0jrscj0ybm9jvlwb&st=7p8s46fa&dl=0
Expression Web 4 INTRO [Cambridge 0417 ICT IGCSE] 2024 June Paper 32 Nicos Paphitis 2024-10-01 | This is a quick tutorial on Expression web 4Designed to support students taking the IGCSE Cambridge ICT 0417 examination for paper 3 on Web Design.June 2024 P320:00 Intro01:20 Setup Expression Web workspace03:23 Q13 Q14 Creating the table. Seeing how to modify the table properties in Expression. Adding the Page title09:00 Q15 Q16 Q17 Adding images, alternative text, modifying the image dimensions. Adding text and adding style. 12:56 Adding a video tag and adding attributes, controls, auto play, loop and setting dimensions.19:45 Q18 adding an external stylesheet20:27 Q19 add links to images. Links to local file and to email------End of the Web design questions of this paper----23:26 Learning how to create stylesheets in Microsoft Expression Web. Learning a bit about priority in stylesheets.28:18 adding more css styles, td, and editing current styles table alignment with the margin attribute33:49 Adding the body tag and working with the background image position37:39 Adding text styles like the P styleYou can download the Expression Web version i use here:dropbox.com/scl/fi/bkuk9r6ygzirmgc8uxw4b/microsoft-expression-web-4-0-1460-0.zip?rlkey=nnxl0j7hu0jrscj0ybm9jvlwb&st=7p8s46fa&dl=0
HTML Webpage using text editor [HTML Basics] Nicos Paphitis 2024-09-30 | This particular tutorial is designed to help students complete their HTML Webpage/Website project homework. It covers everything you need to know to complete your project. The resource mentioned in the video can be found in at the bottom of this description.0:00 IntroGetting started----------------------01:29 Creating your folder and text document02:23 Setting up Windows to display file extensions03:43 Changing the text file to a HTML file04:24 Looking at the resource file you should have been given and copying info from it. You can download the file from the link at the bottom of the video description05:23 Using the basic frame of a webpage (copy from the resource file), Adjusting your screen08:04 Planning our webpage and the table that will hold the dataEntering data for the webpage-----------------------------12:33 Adding a heading and adding a style and center alignCreating the table------------------------14:29 Use the templates in the resource document16:03 Creating the table 1 row at a time while previewing progress.20:28 Formatting your table Adding info to our webpage-----------------------------22:06 Getting images for my webpage. What files you can and cannot use and giving good names to your files. Changing image dimensions.24:19 Adding images to the webpage.27:32 Adjusting the width of the table cells.28:08 Adding your text to your webpage30:20 Formatting text using headingsGetting Extra credit---------------------31:39 How to get extra credit by adding new tags32:10 Create a second webpage to create a website.35:44 Creating a links so as to be able to navigate between webpages38:19 Saving your work and knowing what to send to your teacher. 38:56 How to ZIP your files to attach to an assignment.Get the resource file used in this tutorial:dropbox.com/scl/fi/890ceu0nqh8wxggngz5zz/ALL-About-HTML.docx?rlkey=p0eqllzvptmpvjpi36t2xy3t7&st=hjx4vpla&dl=0
2024 June Paper 21, Cambridge 0417 ICT [IGCSE] MUST WATCH Nicos Paphitis 2024-09-15 | This is one of the trickiest papers yet. It is the 2024 June paper 21 and it is a packed paper with quite a few new twists. In this tutorial, as in all my tutorials i show variations of questions and give important tips on solving the paper. A great resource for all students taking this exam but also for educators teaching the course and anyone who wants to learn more on Word, Access, Excel chart creation and PowerPoint. A link to the question paper and source files can be found at the bottom of the description.Use the time stamps in the description to jump to sections of interest.00:00 Intro--------------------------------Task 1 (Evidence Document)--------------------------------01:14 Check you have all files01:40 Creating the Evidence document (I added my details at the end before printing)--------------------------------Task 2 (Document)--------------------------------02:53 Q1- Saving the .rtf as a document and checking the preset settings05:35 Q2- Header and Footer. (explanation about place holders here)09:23 Q3- Creating a new style, based on normal14:13 Q4-Q5- Apply style / Change paragraphs to 2 columns16:52 Q6- Modify existing style20:36 Q7- Apply and modified numbered list (align with dialogue box or using the ruler)24:35 Q8- Inserting image, rotating, text wrap26:55 Q9- Formatting a table, fixed size, row height, table alignment (this is quite new)31:45 Q10- Spell check, proof read, checking for widows and orphans, split tables and slit lists, print document--------------------------------Task 3 (Database)--------------------------------33:50 Q11- Importing a csv file. (formatting the date field).41:49 importing a second table and adding a new field as a primary key, formatting time datatype46:52 Q12- Creating a one to many relationship. Appropriate screenshot49:39 Q13- Creating a query and report, Important info here 53:48 creating a new field which is calculated at runtime. Formatting the new field. 56:16 adding the criteria for the query. Using the OR operator 58:05 Creating the report based on the Query 59:25 Choosing which method to use to apply the sorting. 2 methods demonstrated. 01:08:12 Q14- Adding a new field in an existing table 01:09:54 Understanding radio buttons and what data they store01:13:15 Q15- Creating a Data Entry Form01:15:16 Q16- Add a radio button option group to the form, connected it to a field and format the form. (Important info here)01:23:00 Q17- Adding a new record using the newly created option group. (Bonus tip, changing an item in the form to a combo box and adding a button)01:27:39 Q18- Automated selection in table. (use of text filters)--------------------------------Task 3 (Presentation)--------------------------------01:29:58 Q19- Create a presentation from an rtf file01:31:21 Q20- Modify the Master slide01:33:39 Q21- Editing bulleted list01:36:07 Q22- Delete Slides01:36:28 Q23-Q24-Q25- Create a chart from the csv file. (Important info on charts here)01:39:47 Q26-Q27- Format axis values on the chart and place chart in slide01:41:41 Q28- Create and edit and action button which opens a local file. Add text to the shape.-------------------------------01:47:39 Wrap up-----------------------------------------------Link to download the resource files:Due to copyright restrictions from CIE i am not able to provide the resource files for this paper. Please seek to get the resource files from your teacher.
Next Years Teams. IMPORT Learning Resources from OLD Team to NEW one. Nicos Paphitis 2024-08-26 | This tutorial is aimed at educators that generate their Class Teams. This tutorial will show you the correct way to generate a New Class Team using the old one as a template and how to import the Learning Resources from old class teams to the new ones. You will also learn how to Archive old Teams and how to restore them. In the tutorial i demonstrate using both Grid and List view as the dot dot dot menus are in different locations.0:00 Intro and important does and don'ts02:27 Switching between views03:07 Finding the old Class Team and explaining what we are going to be doing to generate the new one form the old one04:38 Creating the New Class Team from the old one and seeing what is generated06:38 Transferring resources from the old OneNote Class Notebook to the New OneNote Class Notebook in the new Class Team08:51 Transferring your resources from the Class Materials or other Files section from the old Class Teams to the new one 09:24 Important tip on how to make your New Class Team visible so as to copy files to it12:08 Archiving the old Class Team13:18 How to restore an archived Team14:30 Using the List View to find the menus15:35 Restoring and locating a Team17:02 Naming ConventionDownload the naming convention file i used in the tutorial:dropbox.com/scl/fo/zbgm3j982p9zrj5q01nfw/AJY7qoPnGfWAhXT6Q-gBBzs?rlkey=az6h2lrqt20ao8x8ng9visxbe&st=avgtnjq9&dl=0Here is the video which demonstrates how to email all members of a Class Team as mentioned in this tutorial:youtube.com/watch?v=MitfiVA6Ha4&t=215s
How to IMPORT your timetable from ISAMS to your Calendar Nicos Paphitis 2024-08-22 | Quick tutorial on how to import your Timetable from ISAMS to your calendar. Outlook Calendar, Google Calendar, iCalendar.Very useful tip for educators.
