This course provides students with an opportunity to expand upon previously learned ICT skills. Students will use office productivity software to meet a variety of project outcomes, such as the creation of documents, spreadsheets, databases, web pages and presentations. In addition, students will explore the production of multimedia through a variety of projects that emphasize the use of graphics, animation, audio and video. The integration of software tools will be utilized to complete complex tasks and projects. The Internet and e-mail will be used as communication tools to assist in the research and data-gathering process. Ethical considerations, acceptable use and the challenges associated with various uses of ICT in the home and workplace will also be examined.

Computer Orientation (5 Hours)

• Working at school

- Introducing what is available (software, computers, printers, scanners)

• Working at home

- Accessing school resources online
- Transferring files 

Word Processing (10 Hours)  

• Formatting and designing documents

- Referencing sources of text and inserted objects
- Including headers, footers and pagination
- Choosing fonts and colour

 Spreadsheets and Databases (20 Hours)

• Determining when to use a database and when to use a spreadsheet
• Creating a spreadsheet with formulas and logic
• Manipulating spreadsheets (sorting and beyond)
• Creating a flat file database; capturing and importing data
• Manipulating the database (sorts and queries)
• Displaying the result

Graphics (15 Hours)

• Importing images and getting permission
• Capturing still images (cameras and scanners)
• Drawing and changing images

Presentations (10 Hours)

• Conveying the message
• Creating an outline
• Creating speaking notes
• Creating a consistent design
• Customizing images and backgrounds
• Inserting objects and linking to resources, including audio, video and animation

Multimedia (20 Hours)

• Telling a story with animation and video
• Capturing good pictures and sounds

Webpage Design (20 Hours)

• Making your words, images and sounds communicate a message

Ethical and Legal Issues (5 Hours)

Reflection and Assessment (5 Hours) 

• Appraising tasks completed by peers using criteria and constructive feedback
• Self-assessing and setting personal goals for the future

Note: The number of hours assigned to each topic will depend on each student’s prior knowledge. The hours listed above are only an estimate for students who have progressed considerably through the Developmental Continuum for Literacy with ICT Across the Curriculum. The actual time spent on each topic will depend on the needs of the students. Students may have spent considerably more time word processing and creating presentations in kindergarten to Grade 8 than in creating multimedia or designing web pages.