ICT

                    Term 2 Materials


Unit 3: Spread sheet Features

Week 1: 

• Modify worksheet data and structure and format data in worksheet
• Sort data, manipulate data using formulas and functions and create simple charts

Week 2 till Week 5: Work Placement 

Unit 5: Creating and Manipulating Data

Week 6: 

• Insert data by using AutoFill
• Ensure data integrity
• Modify cell contents and formats
• Change worksheet views
• Manage worksheets
• Worksheet: 4.1
• Project 3.1

Unit 6: Formatting Data and Content

Week 7:

• Format worksheets
• Insert and modify rows and columns
• Format cells and cell content
• Format data as a table
• Worksheet 4.2

Unit 7: Creating and Modifying Formulas

Week 7:

• Reference data in formulas
• Summarize data using a formula
• Summarize data using a subtotals
• Conditionally summarize data by using a formula
• Lookup data using a formula
• Use conditional logic in a formula
• Format or modify text using formulas
• Display and print formulas
• Minor Assessment 2.1

Unit 8: Presenting Data Visually

Week 8:

• Reference data in formulas
• Summarize data using a formula
• Summarize data using a subtotals
• Conditionally summarize data by using a formula
• Lookup data using a formula
• Use conditional logic in a formula
• Format or modify text using formulas
• Display and print formulas
• Minor Assessment 2.1

Unit 8: Presenting Data Visually

Week 9: 

• Create and format charts
• Modify charts
• Apply conditional formatting
• Insert and modify illustrations
• Outline data
• Sort and filter data
• Project 3.2
• Worksheet 4.3

Unit 9: Collaborating and Securing Data

Week 10:

• Manage changes to workbooks
• Protect and share workbooks
• Prepare workbooks for distribution
• Save workbook
• Set print options for printing data, worksheets and workbooks
• Worksheet 4.4

Revision to IC3 Module 2 topics (term 1 + term 2) and IC3 M2 Exam

Week 11:

• Revision and Exam
• Minor Assessment 2.2 (IC3 – M2 exam score to be considered)

STS End of Term Exams

Week 12: Internal Exam (Major Assessment)

====================================

                  Term 1 Materials


Course Outline                        Term 1 TAG


Unit 1: Microsoft Office Applications

Week 1: Start and exit application, identify and modify interface elements and utilize sources of online help.

• Sunday 08/09/2013: Induction Day
• Monday 09/09/2013: Starting Word 
• Activity: Word Starter 
• Tuesday 10/09/2010: Software Orientation
• Activities: Letter, Party Time

Week 2: Perform common file-management functions.

• Sunday 15/09/2013: How to create a Blog site
• Activity: Setting up your own blog site 
• Tuesday 17/09/2010: PowerPoint 2010 Basics for window
• Activity 1:Create a short presentation 
• Activity 2 : Format the bullet points of a Microsoft PowerPoint 2010 presentation

Week 3: Perform common editing and formatting functions.

• Sunday 22/09/2013: Formatting Pages
• Activity:Poor Presentation
• Monday 23/09/2013:Perform common printing/outputting functions.
• Activities: Paragraph, Menu
• Tuesday 24/09/2013:Worksheet :4.1

Unit 2: Word Processing Functions

Week 4:  Format text and document including the ability to use automatic formatting tools.

• Sunday 29/09/2013: Character Formatting
• Activities: Class description 
• Exercise 1: Sales letter
• Exercise 2: Volunteers
• Monday 30/09/2013: Formatting Text with Styles

Week 5: Use word-processing tools to automate processes such as document review, security and collaboration.

• Activity: Project: 3.1

Week 6: Eid Holiday

Week 7: Worksheet :4.2

Unit 3: Communicating with Presentation Software

Weeks 8: Managing the slides

• Sunday 27/10/2013: Create and Format simple presentation
• Minor Assessment 2.1
• Tuesday 29/10/2013: Step by Step Activity
•  Create a Quiz presentation from the Template 

Week 9: Creating master slide

• Activity:Business Plan
• Worksheet :4.3

Week 10: Adding Tables to Slides

• Activity 1: ATM presentation 
• Project: 3.2

Week 11:Using Charts in a Presentation 

• Activity 1: Revenues
• Worksheet :4.4

Week 12: Material Covered during the period Week 1 to W11

• Revision
• Minor Assessment 2.2

Week 13: STS End of Term Exams

• Revision
• Internal Practical Exam

Week 14: STS End of Term Exams