Infotech 9

Course Outline

Each day you will record what you achieved that day in a google calender. Every two weeks you will take part in a conference where you show what you have been working on.

To see the schedule for conferences add the calender at "sd81.bc.ca_uah072vrs5uk30psch9q4n03f8@group.calendar.google.com" to your list

Word:

Basics Create a document which shows off your knowledge of word processing. Save your file as a pdf titled "word1_YOURNAME.pdf" and submit. (100 marks)

Howto Create a document in which you will create a help guide for Word. Save your file as a pdf titled "word2_YOURNAME.pdf" and submit. (100 marks)

Styles Create a document and format it using styles. Save your files as pdfs titled "word3_YOURNAME_1.pdf", "word3_YOURNAME_2.pdf", and "word3_YOURNAME_3.pdf" and submit. (100 marks)

PowerPoint

Powerpoint #1 See assignment. And example. Save your file as power1_YOURNAME.pptx and submit.

Powerpoint #2 Create a powerpoint presentation on one either a famous person/group you admire OR something you learned in the past year. Your presentation should include:

  • At least 10 slides
  • Animations which help tell your story
  • A list of sources used, both for all pictures you use and any information
  • No more than 10 words per slide
  • Should look very good and be engaging. There should be no "animations for animations sake"
Save your file as power2_YOURNAME.pptx and submit.

Excel

Excel Assignment #1

Download the following excel spreadsheet then sort the salespeople from highest sales to lowest sales using sort tool. Speadsheet Save your file as 9excel1_YOURNAME.xlsx

Excel Assignment #2

Use formulas to calculate total profit. Follow Assignment Guide 9excel2_YOURNAME.xlsx

Excel Assignment #3

Create a speadsheet which would be a gradebook for a made up class should have

  • 10 students(rows) who have different marks in 10 different assigments (columns)
  • A percentage mark column, and a letter grade column which is automatically filled in based on their assignment marks
  • Conditional formatting which highlights any mark less than 50%
  • See tutorial for how to make lookup table for letter grades.
  • Save your file as9excel3_YOURNAME.xlsx

Excel Assignment #4

Create a line graph comparing the stock prices of Coca-Cola and Amazon. Get data from Dr. Rasp's Website Save your file as 9excel4_YOURNAME.xlsx

Finished product should look something like this

Creating a website

  • Get your code academy log in from Mr. Nelson
  • Complete the "Make a website course"
  • Create website about an important person or group using atom text editor
  • Find a free hosting service
  • Upload website using ftp

Scratch Programming

Scratch Assignment #1

Create a program so the cat can move around the canvas using the arrow keys.

Scratch Assignment #2

Create a pong clone

Scratch Assignment #3

Create an awesome game of your own design.

Blender

  • Folow along with the lessons at Neal Hirsig's tutorial
  • Create the yellow submarine animation by following the pdf guide
  • Create something of your own in blender

Grades

No grades are available yet.