ICT Plus Paper Tutorial (Nov 2023 Paper 2)
Presenter: Nicholas Paphitis
Key Points and Steps Covered:
Introduction
- Nicholas Paphitis from Cyprus
- Introduction to the ICT Plus Paper 2 for November 2023
- Emphasis on time management and new syllabus features
Task 1: Setting Up Evidence Document
- Open the necessary files and keep them in an organized folder.
- Open the Evidence Document and ensure personal details are in the header.
- Save the document as "EVIDENCE + candidate number".
Task 2: Editing Report in Word
- Paragraph Styles: Create, modify, and apply as instructed.
- File Setup: Open
N2302_review.rtf
, set landscape orientation, and save as Word document with the name VG_REVIEW
.
Step-by-Step Instructions:
- Remove Page Breaks:
- Enable Show/Hide to reveal page breaks.
- Delete page breaks appropriately using Backspace or Delete.
- Header and Footer:
- Insert automated page numbers (left-aligned) in the header.
- In the footer, insert text “Market review by” followed by personal details (right-aligned).
- Text Formatting:
- Modify specific paragraphs to two columns of equal width with a 2 cm space between them.
- Styles Creation:
- Create a style named
VG_subhead
based on normal paragraph style. Set specified font and properties.
- Apply
VG_subhead
to four subheadings.
- Text Movement:
- Locate and move specific paragraphs to a new position.
- Chart Creation:
- Import data from a CSV file into Excel and create a vertical bar chart for 2022 data.
- Configure chart properties as specified and insert chart into the Word document.
- Editing Styles:
- Modify the
VG_list
style to specified properties.
- Paragraph Indentation:
- Indent specific paragraphs by 1.5 cm from both left and right margins.
- Spell Check and Consistency:
- Ensure no spelling errors, consistent spacing, and proper formatting without widows or orphans.
Task 3: Creating Database Reports
Initial Setup
- Import Files:
- Import necessary CSV files into Access and set up fields, data types, and primary keys.
- Screenshot evidence for field names, data types, and primary keys.
- Relationships:
- Create a one-to-many relationship between specified tables and screenshot this.
- Record Modification and Entry:
- Modify specified records and add new records to the tables.
- Generating Queries:
- Generate queries based on specified criteria.
- Reports:
- Create and format reports based on query results.
- Ensure proper layout, sorting, and inclusion of specific fields.
Task 4: Presentation
- Slide Setup:
- Create a presentation with specified slides from an outline file.
- Add a header with personal details on all slides.
- Slide Formatting:
- Change layout for specific slides and insert tables with specified formatting.
- Adjust column widths and row heights for proper display.
- Ensure no more than three lines of text wrap in specified columns.
- Format specified slides with indentation and bullet points.
- Create hyperlinks within the presentation.
- Printing:
- Print specified slides as handouts in portrait orientation, two slides per page.
- Evidence Document:
- Ensure evidence document has the required details and print it.
Ending Remarks
- Emphasize the importance of following steps meticulously.
- Reminder to double-check work for accuracy and consistency.
- Encourage feedback and corrections from viewers.
Study Tips: Ensure practice with new syllabus features, manage time effectively, and double-check all details.