ICT I & II 15F/15F

ICT I and II - 15F/15F

Course Schedule (includes lessons, assignments, projects, due dates, etc.)

September | October | November | December | January 2013-2014 - Semester 1 Period 5

Sign up to receive text message reminders by texting @ict1and2 to 204-272-5412.

Due Dates and Final Deadline Dates

Students will be given suggested deadlines for assignments and projects, to encourage responsibility and assist with time management. Assignments and projects may be submitted to me in any order, however all assignments and projects must be submitted to me no later than the final scheduled deadline day. Assignments and projects not submitted by the final deadline day will be awarded a grade of zero. This is a project-based course – no tests.

Final Deadline Date #1 - October 11
Final Deadline Date #2 - November 8
Final Deadline Date #3 - December 13
Final Deadline Date #4 - January 27

Includes all items due from: September 4 to October 4
Includes all items due from: October 5 to November 8
Includes all items due from: November 9 to December 6
Includes all items due from: December 7 to January 27

Evaluation

Quarter 1
Computer Orientation
Online Communication and Internet
Word Processing
Photography
Digital Film
Total

10%
20%
30%
20%
20%
100%

Quarter 2
Spreadsheets
Electronic Presentations
Web Design
Databases
2D Animation
Total

30%
10%
15%
15%
30%
100%

Classroom Expectations

Computer Access for Missed Work:
Computer time and space is available in the student support center and the library before school, at lunch, and after school. Students may also make arrangements with me to work in the lab during lunch and spares.

Attendance and Punctuality:
Students are expected to attend class and be on time. Attendance and punctuality is mandatory and extremely necessary for success in the course. Remember that most learning occurs inside the classroom.

If a student is absent, they are responsible for finding out what work they missed and for completing that work on their own time. Class work, assignments, projects, etc., are all posted on my web site.

Plagiarism and Cheating:
Plagiarism and cheating on any work including assignments, projects, and tests is unacceptable and will result in a grade of zero. If a student copies another student’s work, both of the students will receive a grade of zero.

Outline

Purpose

The purpose of this course is to reinforce and extend the ICT knowledge, attitudes, and skills acquired by students in the Early and Middle Years. The course will further prepare students to use ICT to learn and demonstrate their learning in all Senior Years courses.

Objectives

Develop the abilities to use, manage, and understand information and communication technologies by exploring software and computer‑controlled devices.
Demonstrate appropriate problem-solving skills while seeking solutions to technological challenges.
Demonstrate effective communication skills in listening, speaking, reading, writing, viewing, and representing.
Demonstrate tolerance, teamwork, leadership, and responsible and ethical behaviour.

Quarter 1

Unit 1 – Computer Orientation (1 week)

Review school’s computer use policy
Demonstrate proper file Management

        o    Create, move, copy, and rename files and folders
        o    Identify file extensions
        o    Sort and view files and folders

Identify, illustrate, and demonstrate proper ergonomic techniques
Demonstrate printing to PDF

Unit 2 – Online Communication and Internet (1.5 weeks)

E-mail

        o    Discuss e-mail etiquette (e.g. subject line, salutation, closing) in regards to business versus personal e-mails
        o    Discuss confidentiality and security in e-mail writing (e.g. ease of forwarding, discretion of what to share)
        o    Discuss spam
        o    Compose e-mails that include the following:
                - CC vs. BCC
                - Signature
                - Attachment
                - Appropriate language
        o    Create and manage an address book

Online safety

        o    Identify what makes good passwords and user names
        o    Investigate phishing, predators, identity theft, privacy (e.g. sharing of personal information), and auto settings (e.g. Facebook settings, auto saving
              passwords, etc.)
        o    Discuss cyber safety (e.g. online bullying)

The Web

        o    Practice efficient web searching techniques
        o    Evaluate web sites (e.g. validity and credibility)
        o    Discuss copyright laws and demonstrate proper referencing

Unit 3 – Word Processing (2.5 weeks)

Compose a two-point punctuation Personal Business Letter and/or a Business Letter
Compose or copy a multi-page unbound report containing the following:

        o    Title Page
        o    Referencing (footnotes and work cited)
        o    Headers and footers

Create tables that include the following:

        o    Changes in vertical and horizontal alignment
        o    Merged and split cell formatting
        o    Changes in borders and shading

Create ordered and unordered lists
Create and use graphic organizers

Unit 4 – Photography (1.5 weeks)

Capture photos using the following photo techniques:

        o    Rule of thirds
        o    Leading lines
        o    Simplicity (unclutter)
        o    Close up (macro photography)
        o    Framing
        o    Angles

Modify and manipulate photos as follows:

        o    Crop
        o    Make colour adjustments
        o    Add text
        o    Remove backgrounds

Investigate proper file sizes and types (i.e. JPG, TIFF, PNG, TIFF)
Discuss ethics in photography including:

        o    Permission to take photos
        o    Security (storage and sharing)
        o    Copyright

Unit 5 – Digital Film (1.5 weeks)

Plan a video

o Determine audience and purpose
o Create a storyboard

Capture video
Edit a video by adding the following:

        o    Text
        o    Transitions
        o    Sound
        o    Special Effects

Quarter 2

Unit 6 – Spreadsheets (2 weeks)

Create spreadsheets that demonstrate the following:

        o    Basic Formatting
                - Borders and shading
                - Number formats
                - Cell alignment
                - Cell merging
                - Fill down and across
        o    Formulas using cell referencing
                - Addition
                - Subtraction
                - Division
                - Multiplication
        o    Functions
                - SUM
                - AVG
                - MAX
                - MIN
        o    Absolute referencing and relative referencing

Create and modify charts that include:

o One and multiple sets of data
o Legends, titles, and labels

Print spreadsheets to PDF’s making changes to the following:

        o    Headers and footers
        o    Headings and gridlines
        o    Page scaling (e.g. fit to one page)

Unit 7 – Electronic Presentations (1.5 weeks)

Plan a presentation

o Determine audience and purpose

Use appropriate presentation rules and skills including:

o Content and structure
o Body language, pacing, voice projection, etc.

Present live

Unit 8 – Web Design (1 week)

Create a web site using an online template (e.g. Moonfruit, PBwiki, Weebly, Google page creator, Wix) that includes the following:

        o    Appropriate content
        o    Internal links
        o    External links
        o    Graphics (royalty free)
        o    Columns and/or tables

Unit 9 – Databases (using a database program) (1.5 weeks)

Create tables (with one primary key)

Create forms using wizards
Add and delete records
Sort records
Execute basic queries using wizards (note: for large databases data will be provided) – queries should include the following criteria:

         o    Equal to
         o    Less than
         o    Greater than
         o    Not equal to
         o    And/or
         o    Wild card

Create reports using wizards

Unit 10 – 2D Animation (using Flash) (2 weeks)

Plan an animation