Info+Tech+09+and+10

Ms. Mak will cover the following topics with you in October and November:
 * 1) **Microsoft Excel**: How can I use it effectively?
 * 2) **Computer Programming**: What is that?


 * ~ Date ||~ Topics of the Day ||~ Class Work ||~ Other Resources ||
 * Oct 14, 2010 || Excel Basics

 How can I...
 * Open a Spreadsheet?
 * Interface?
 * Create and name a worksheet?
 * Find the average?
 * Create a graph?
 * Calculate with a Spreadsheet. || <span style="font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif;">Today's work:

__<span style="font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif;">(A) Male Vs Female Comparison __ <span style="font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif;">- Compare the number of Female vs Male for the Grade 9 and 10 students in this class separately in a table. Present the data in percentages. <span style="font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif;">- If you know how to create a Pie Chart, create a pie chart to show your percentage comparison. <span style="font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif;">- Show your work to Ms. Mak, when you are done. <span style="font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif;">(I need to know what everyone knows, just do as much as you can. )

<span style="font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif;">__(B) Complete__: [|Lesson1Homework.pdf].

<span style="font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif;"> Here are the pictures for the work: "[|Lesson1_Task1.jpg]". <span style="font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif;"> "[|Lesson1_Task2.jpg]". <span style="font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif;"> "[|Lesson1_Task3.jpg]". || <span style="font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif;">An Online Excel Tutorial: [|http://people.usd.edu/~bwjames/tut/excel/] ||
 * <span style="font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif;">Oct 18, 2010 || <span style="font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif;">Review some Excel Basics || <span style="font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif;">Today's Work:

(B) Lesson 1 Assignment: <span style="font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif;"> [|Lesson1Homework.pdf]. <span style="font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif;">Finish last class's work. With the additional requirements:
 * <span style="font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif;">The tables and graphs must be in separate workbook like the above examples.
 * <span style="font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif;">Task 1: The "Average Mark" must be calculated with a function. The graph must have a title. Change the graph into "Column Type".
 * <span style="font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif;">Task 2: Subtotal,, HST (NOT GST), Total and change must be done with an Excel Math operations.
 * <span style="font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif;">Task 3: The Y values must be calculated with an Excel Math operations. The graph must have a title. ||  ||
 * <span style="font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif;">Oct 20, 2010 || <span style="font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif;">Formatting Excel Spreadsheet || <span style="font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif;">You will need to:
 * 1) <span style="font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif;">Add a picture to a worksheet in the Lesson 1 Excel file.
 * 2) <span style="font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif;">Add a text box about the picture.
 * 3) <span style="font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif;">Add a shape to the worksheet.
 * 4) <span style="font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif;">Put the picture, the shape and the text box in a group.
 * 5) <span style="font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif;">Adjust the angles of the text labels of the x-axis labels to 45 degree.
 * 6) <span style="font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif;">Add color, frame and border to your existing tables.
 * 7) <span style="font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif;">[[file:Lesson2_Sample1.pdf]] ||   ||
 * <span style="font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif;">Oct 25, 2010 || <span style="font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif;">Using Excel in my other classes. || <span style="font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif;">(A) Peer assessment: Find your assigned work from your classmate in "A2_PeerAssessment".

<span style="font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif;">(B) You will need to design an Excel spreadsheet and a graph that can be used in a field trip or one of the following subjects: PE., Social Studies, Science or another approved subject.

<span style="font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif;">In one of your worksheet, explain 1) why are you using the spreadsheet in the particular way, and 2) other ways you can use Excel in your class.

<span style="font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif;">Save your Excel spreadsheet as: <span style="font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif;">**[YourName]_[Field Trip Or Your Subject]_A3.xls**

<span style="font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif;">Below is a sample spreadsheet: ||  || <span style="font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif;">The Concept of Functions || <span style="font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif;">1) Complete the "Function" worksheet.
 * <span style="font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif;">Oct 27, 2010 || <span style="font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif;">Using Excel in my other classes.

<span style="font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif;">2) Revise Assignment from Oct 25 Class to include functions or operations in ALL your data that have calculations. ||  ||
 * <span style="font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif;">Oct 29, 2010 || <span style="font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif;">Using Excel to Generate Sequences of Numbers || <span style="font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif;">1) Hand in the third assignment.

<span style="font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif;">2) Assignment 4: Use Excel to answer these Math questions: [|IT_OCT29_A4.pdf] ||  ||
 * <span style="font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif;">Nov 2, 2010 || <span style="font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif;">Using Excel to Find Your Gain/Loss from Stocks. || <span style="font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif;">Calculate the gain/loss with the data in the "IT9_10_A5_Start.xls" file in your "Assignment" folder.

<span style="font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif;"> The "IT9_10_A5_EndNov2.pdf" file in your folder will show you what it should look like when you are done. ||  || <span style="font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif;">1) Change your broker fee to one of the following online brokers found on this page: [] <span style="font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif;">2) Add some formating to your stock data to make it easier to read. <span style="font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif;">3) Create a stock performance graph in a new worksheet with your Assignment 5 stock data.
 * <span style="font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif;">Nov 4, 2010 || <span style="font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif;">Graphing Stock Exchange data || <span style="font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif;">With your assignment 5 stock data:

<span style="font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif;">Your completed assignment should look like this: <span style="font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif;">4) Hand in your assignment as "YOUR_NAME_a5.xls"

<span style="font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif;">Extension: Create a page for yourself in the class page. Put your Excel assignment files to your page. ||  || <span style="font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif;">2) //**Assignment 6**//: Create a timeline. Assignment description:  <span style="font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif;">Tips:
 * <span style="font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif;">Nov 8, 2010 || <span style="font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif;">Time Line Project || <span style="font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif;">1) Hand in your //**Assignment 5**// Homework.

<span style="font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif;">//**Extra**//: Create your own page based on the sample page. (Due Date: Nov 17) ||  || + Garage Band || Due Today: Time Line Project + Your Wiki Page
 * <span style="font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif;">Nov 10, 2010 ||  || <span style="font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif;">Same as yesterday's class. ||   ||
 * <span style="font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif;">Nov 17, 2010 ||  || <span style="font-family: 'Palatino Linotype','Book Antiqua',Palatino,serif;">Same as Yesterday's Class ||   ||
 * Nov 19, 2010 || Time Line Project


 * Watch the Garage Band Tutorial and create a 1 minute audio clip with Garage Band using three different audio clips. (Due next class.) ||  ||