home

Links/Files:  Syllabus (^_^)  TypingMaster (^_^)  SAM (^_^)  QF Mail

Welcome to Your Course Wiki! This is the main page of the wiki where I will post our daily progress and work.

=__**Thursday, May 3:**__=

First of all, thank you for your wonderful presentations you've given! I've enjoyed learning about your chosen profession and I hope you have as well.

Exam Info: Your exam will be Tuesday, May 8, from 10:15 until 11:45 pm. Check the schedule for your room assignment. The exam will consist of both Excel AND PowerPoint. Remember that the extra skills (video and voice recording) that we covered in the PowerPoint unit will NOT be on your exam.

In order to prepare well for your exam, I __**require**__ you to do the following projects in SAM:
 * Exam Review Excel Unit A - DUE Tuesday, May 1, before class
 * Exam Review Excel Unit B - DUE Tuesday, May 1, before class
 * Exam Review Excel Unit C - DUE Thursday, May 3, before class
 * Exam Review Excel Unit D - DUE Thursday, May 3, before class

These projects all deal with Excel, the hardest part of the exam. Here is the Practice Worksheet we used in class that includes formulas for percentage increase and decrease. It also includes any other items students asked to see during class. [|Excel Exam Prep Workbook.xlsx]

In addition, here is the study guide I gave you in class: [|Spring Exam Review.xlsx]

I strongly recommend that use some or all of the following strategies to prepare for the exam:
 * Do the four Exam Review PowerPoint Units (A-D) in SAM
 * Watch the training videos in SAM
 * Revise (redo) the skills review for each unit
 * Revise (redo) the lesson
 * Watch the videos from the video tutorials on the Computers page of the ABP Announcements website.

If you have ANY questions, find me on either Sunday or Monday and ask. You can also ask any computer faculty member.

__**I hope you study well (remember, work smarter, not harder) and that your efforts are rewarded with wonderful exam grades!**__

__**Tuesday, April 24:**__
Start Career Project Presentations. You will go in the following order:
 * 1) Anas
 * 2) Jamilla
 * 3) Lolwa
 * 4) Raja
 * 5) Kholoud
 * 6) Hissa
 * 7) Khloud
 * 8) Jawaher K.
 * 9) Ali
 * 10) Jawaher Al-N.
 * 11) Al-Anood

__**Sunday, April 22:**__
Today we started with a typing test in TypingMaster (Astronauts, 3 minutes).

Continue working on the Career Project.

Hints for effective presentations:
 * look at your audience
 * put your notes in the notes section for each slide and print them out so you can refer to them
 * don't read from the slides
 * don't apologize
 * speak loudly and clearly
 * slow down!
 * get the pronunciation correct
 * ask audience questions to attract their interest
 * good looking slides!
 * be confident
 * don't add too much color/flash, put the emphasis on the content instead
 * include something to grab the audience's interest

__**Sunday, April 15:**__
Today we began with a typing test in TypingMaster (Netiquette, 3 minutes).

The new project will be a presentation on a specific career in which you are interested. You must choose a SPECIFIC job, not a general one (e.g. not doctor but orthopedist, not engineer but petroleum engineer). You will spend the week researching your chosen vocation ( مهنة ), creating the PowerPoint and next week you will present the information you found to the class.

Here are the requirements of this project:
 * definition
 *  what does this job require you to do daily
 *  what education is required
 *  employment facts from the region in which you plan to work
 *  interview with someone in the field (can be found online or done in person, must be voice recording or video)
 *  at least one video
 *  at least one sound file
 * <span style="font-family: Arial,Helvetica,sans-serif; font-size: 90%;">use good presentation guidelines (see PowerPoint page 86 in Unit D) <-- This is VERY important.

This assignment is designed to allow you to explore your chosen field. Make the most of this opportunity by putting all your efforts into this. Enjoy and learn about what you want to do. :-)

We will start presentations on //** Tuesday, April 24th. **//

__**Sunday, April 8:**__
Today we began with a typing test in TypingMaster (History of Photography, 3 minutes).

This week you will learn these additional features of PowerPoint: adding interactivity, adding sound, adding video clips. As these are not covered in your textbook, I will provide instructions in the form of documents and videos.

Adding Interactivity ([|Interactive PowerPoint.pdf]) Adding Sound and Video ([|PowerPoint Sounds and Video.pdf])

Here are this week's assignments:
 * 1) Create a "Choose Your Own Adventure" Interactive PowerPoint from this site. You must have a minimum of 12 slides for your story and it must look good and flow correctly.
 * 2) Create your own compilation of funny YouTube videos in a PowerPoint presentation. Add your own narration and sounds. This must have a minimum of 5 videos and a title slide, use a variety of start methods (on click or on slide advance), look good and flow well. Use www.keepvid.com to download your videos.

These assignments are //due Sunday, April 15, before class//. **No late work will be accepted.**

__**Thursday, April 5:**__
We continued to work on the assignments due on Sunday, April 8th.

__**Tuesday, April 3:**__
We worked on the assignments and discussed the difficult parts of PowerPoint Unit D (Masters, Backgrounds, Templates).

Here are some important points to remember:
 * Send me all files in ONE email, PLEASE! :-)
 * NO LATE WORK WILL BE ACCEPTED.
 * Work is due before class on Sunday.
 * Typing will be checked only at the beginning of the 5th week of the term. You will have a maximum of 8 hours due then.

__**Sunday, April 1:**__
We started today with a typing test in TypingMaster (Hubble Space Telescope, 3 minutes).

This marking period will be a bit different in how assignments are given. To help you transition to how university classes give assignments, I will give you the week's assignments on Sunday and everything will be due one week later on Sunday. Here is the soft copy for PowerPoint Unit D ([|2007 PowerPoint Unit D.pdf]).

Here are this week's assignments:
 * PowerPoint Unit C Project in SAM
 * PowerPoint Unit D Training in SAM
 * PowerPoint Unit D Lesson in textbook: PPT D-1.pptx, PPT_D-2.jpg. Renamed: Last_First_QuestD.pptx
 * PowerPoint Unit D Skills Review in textbook: PPT D-3.pptx, PPT_D-4.jpg. Renamed: Last_First_MediaCom.pptx
 * PowerPoint Unit D Project in SAM
 * TypingMaster, 2 hours, if you are //not// above 30 wpm //and// 90% accuracy.

These assignments are due on Sunday, April 8th, //**before class**//. Use your time wisely. If you have any questions, please see me.

Here is the [|Assignment Tracking Sheet.docx] if you would like to use it.

<span style="color: #df0b0b; display: block; font-family: 'Arial Black',Gadget,sans-serif; font-size: 32px; text-align: center;">START 6TH MARKING PERIOD

__Thursday, March 29:__
Today we did the skills review from PowerPoint Unit C. Here are the three files you will need ([|PPT C-4.pptx], [|PPT C-5.docx], [|PPT_C-6.jpg]). You will rename the .pptx file as Last_First_BlueMoon. Finish and send it to me.

Homework:
 * Finish the Blue Moon file and send it to me.
 * Do the PowerPoint Unit D Training in SAM.

__**Tuesday, March 27:**__
Today we did the lesson for Unit C PowerPoint. Here are the three files you will need ([|PPT C-1.pptx], [|PPT C-2.docx], [|PPT_C-3.jpg]). You will submit only the first file (the .pptx file) and its name will change to Last_First_QuestC. Here is the soft copy ([|2007 PowerPoint Unit C.pdf]).

__**Sunday, March 25:**__
Today we started with a typing test in TypingMaster (Thoughts of Benjamin Franklin, 3 minutes). Then we moved on to the Project for PowerPoint Unit B in SAM. We finished with the training for PowerPoint Unit C in SAM.

__**Thursday, March 22:**__
Today, we did the lesson for PowerPoint Unit B ([|PPT B-1.pptx], name will change to QuestB) and the skills review in the purple pages ([|PPT B-2.pptx], name will change to TechJet). Here is the soft copy for Unit B ([|2007 PowerPoint Unit B.pdf]).

Homework:
 * Finish both QuestB and TechJet and send them to me.
 * TypingMaster - finish up your hours that are due Sunday, March 25th.

__**Tuesday, March 20:**__
Today we did training in SAM for PowerPoint Units A and B and then we did the PowerPoint Unit A Project in SAM.

Homework:
 * Finish the training for PowerPoint Units A and B and then the PowerPoint Unit A Project.
 * TypingMaster - finish up your hours that are due Sunday, March 25th.

__**Sunday, March 18:**__
Today we started with a typing test in TypingMaster (DNA Research - The Human Genome Project, 3 minutes). Then we started PowerPoint Units A & B by watching the video "Life After Death by PowerPoint 2010".

Homework: None [|PPT B-1.pptx]

__**Thursday, March 1:**__
Today we continued the project @Fast Food Fun. Follow the instructions for **Step Two** on that wiki-page.

Homework:
 * Finish part two of the project during class so you have NO homework.
 * TypingMaster - 2 hours this week if you have not earned //**both**// 30+ wpm and 90+% accuracy on this weeks typing test.

__**Tuesday, February 28:**__
Today we started the project @Fast Food Fun. Follow the instructions on that wiki-page.

Homework:
 * Finish part one of the project.
 * TypingMaster - 2 hours this week if you have not earned //**both**// 30+ wpm and 90+% accuracy on this weeks typing test.

__**Sunday, February 26:**__
Today we started with a typing test in TypingMaster (Rules of Baseball (from 1889), 3 minutes). Then you continued practicing the integration of Excel and Word by completing Independent Challenge 2 and 3. The files needed are listed here: IC#2: [|INT A-11.xlsx] and [|INT A-12.docx]. IC#3: [|INT A-13.xlsx] and [|INT A-14.docx]. Change the names of the files as instructed in the challenges and submit to me.

Homework:
 * Finish the Independent Challenge 2 and Independent Challenge 3 and send me all the files in ONE email.
 * TypingMaster - 2 hours this week if you have not earned //**both**// 30+ wpm and 90+% accuracy on this weeks typing test.

__**Thursday, February 23:**__
Today we worked on the Skills Review for the Integration Unit (Pages Integration A 12-14). You will need the following FOUR files ([|INT A-5.xlsx], [|INT A-6.docx] , [|INT A-7.xlsx] , [|INT A-8.docx] ) and will change the names as the instructions say. Remember that you CANNOT rely on the soft copy as it is incomplete. You can check out a book from the library.

Homework:
 * Finish the Skills Review and send me the files in ONE email. Do NOT send separate emails!!!
 * TypingMaster - 2 hours this week if you have not earned //**both**// 30+ wpm and 90+% accuracy on this weeks typing test.

__**Tuesday, February 21:**__
Today we started the Integration Unit A. Note that this soft copy ([|2007 Integration of Word and Excel.pdf]) is incomplete so be careful relying on it! Use the textbook from the library as the best option. You will need these FOUR files ([|INT A-1.xlsx], [|INT A-2.docx], [|INT A-3.xlsx], and [|INT A-4.docx]) and their names will change to start with QST Vancouver (Survey Data, Survey Report, Price List respectively and 2010 Tours for the last document).

Homework:
 * Finish the QST Vancouver Survey Data, QST Vancouver Survey Report, and QST Vancouver Price List files and send them to me in ONE email. Do NOT send separate emails!!!
 * TypingMaster - 2 hours this week if you have not earned //**both**// 30+ wpm and 90+% accuracy on this weeks typing test.

__**Sunday, February 19:**__
Today we started with a typing test in TypingMaster (Observations of the "Father of Computing", 3 minutes). Then we continued working on the Real Life Independent Challenge (My Dream House).

Homework:
 * Finish the My Dream House assignment and send it to me.
 * TypingMaster - 2 hours this week if you have not earned //**both**// 30+ wpm and 90+% accuracy on this weeks typing test.

<span style="color: #ff0000; display: block; font-family: 'Arial Black',Gadget,sans-serif; font-size: 200%; text-align: center;">**Marking Period 5**

**__Thursday, February 16:__**
Today we went over all the assignments and took care of any issues. Then you worked on the Real Life Independent Challenge on Excel Page 103. It started with a blank workbook and changed its name to My Dream House.

**__Sunday, February 12:__**
Today we started with a typing test in TypingMaster (Yosemite National Park, 3 minutes). Then we worked on the Skills Review at the end of the unit (Excel pages 97-99) which used this starting file ([|EX D-2.xlsx]) and had its name changed to Lastname_Firstname_Departmental Software Usage.

Homework:
 * Finish the Skills Review and send it to me.
 * SAM Project D-1
 * TypingMaster - 2 hours this week if you have not earned //**both**// 30+ wpm and 90+% accuracy on this weeks typing test.

**__Thursday, February 9:__**
Today, we started Unit D - Working with Charts. Here is the soft copy ([|2007 Excel Unit D.pdf]) and here is the starting file ([|EX D-1.xlsx]) which you will save as Name Quarterly Tour Revenue.

Homework: TypingMaster - 2 hours this week if you have not earned //**both**// 30+ wpm and 90+% accuracy on this weeks typing test.

**__Tuesday, February 7:__**
Today, we practiced the skills of formatting in Excel with Unit C. We started with SAM Unit C Project 1 and then did Independent Challenge #3 (starts with a blank Excel file) from page Excel 75 of the textbook. Both are due next class.

Homework:
 * Complete SAM Unit C Project 1.
 * Complete and turn in Fine Writing Instruments (Independent Challenge #3).
 * TypingMaster - 2 hours this week if you have not earned //**both**// 30+ wpm and 90+% accuracy on this week's typing test.

**__Sunday, February 5:__**
Today we started with a typing test in TypingMaster (Netiquette, 3 minutes). We went over Unit C objectives (listed below) and talked about conditional formatting, the hardest part of the unit. Here is the soft copy of the unit ([|2007 Excel Unit C.pdf]). Remember that you can check out a textbook in the library. Your assignment will be to complete the lessons using ([|EX C-1.xlsx]) and rename it to QST Advertising Expenses.


 * Unit C - Formatting - objectives:**
 * 1) Format values
 * 2) Change font and font size
 * 3) Change attributes and alignment
 * 4) Adjust column width
 * 5) Insert and delete rows and columns
 * 6) Apply colors, patterns, and borders
 * 7) Apply conditional formatting
 * 8) Name and move a sheet
 * 9) Check spelling

Homework:
 * Finish and email QST Advertising Expenses to me.
 * TypingMaster - 2 hours this week if you have not earned //**both**// 30+ wpm and 90+% accuracy on this weeks typing test.

**__Thursday, February 2:__**
Today we took the exam in SAM on Excel Units A and B.

Homework:
 * SAM Training for Excel Unit C
 * TypingMaster - 2 hours this week if you have not earned //**both**// 30+ wpm and 90+% accuracy on this weeks typing test.

**__Tuesday, January 31:__**
Today, we discussed relative and absolute cell references and did a multiplication table activity. Remember that you will have your exam on Thursday, in SAM, covering Excel Units A and B.

Homework:
 * Finish the mulltiplication table and send it to me.
 * Study for the SAM exam on units A and B.
 * TypingMaster - 2 hours this week if you have not earned //**both**// 30+ wpm and 90+% accuracy on this weeks typing test.

**__Sunday, January 29:__**
Today we started with a typing test in TypingMaster (Legends of Abraham Lincoln, 3 minutes). Then we began working on Independent Challenge #2 from page Excel 47 (a-h) of the book ([|077.jpg]). Here is the starting file you need to alter ([|EX B-4.xlsx]). When you are done, email this to me.

Homework:
 * Finish the Pamper Yourself Finances (EX B-4.xlsx). Due next class.
 * TypingMaster - 2 hours this week if you have not earned //**both**// 30+ wpm and 90+% accuracy on this weeks typing test.

**__Thursday, January 26:__**
Today, we did the Independent Challenge #1 on page 46 of your book ([|Excel_p46_Unit_B_IC#1.jpg]). Here is the starting file you need for this ([|EX B-3.xlsx]). This is due next class.

Homework:
 * Finish the Estimated Diner Expenses (started as EX B-3.xlsx) and email it to me. Due next class.
 * SAM project: Int-Excel Unit B Project. Due next class.
 * TypingMaster - 2 hours this week if you have not earned //**both**// 30+ wpm and 90+% accuracy on this weeks typing test.

**__Tuesday, January 24:__**
Today, we started Unit B in Excel. Here is the starting file that you will need to alter ([|EX B-1.xlsx]). Here is the soft copy of the unit ([|2007 Excel Unit B.pdf]).

Homework:
 * Finish the Tour Revenue Analysis (started as EX B-1.xlsx). Email to me when done.
 * SAM Excel Unit B Training
 * TypingMaster -2 hours this week if you have not earned //**both**// 30+ wpm and 90+% accuracy on this weeks typing test.

**__Sunday, January 22:__**
Today, we started with a typing test in TypingMaster (The Life of Calamity Jane, 3 minutes). Then we worked on Independent Challenge 2 from the textbook (page Excel 21-22) and that was due at the end of class (Hot Cars Sales.xlsx).

Homework:
 * SAM - Excel Unit A Independent Project 1 - due next class, Tuesday, Jan 24. Submit to SAM as usual.
 * TypingMaster - 2 hours this week if you have not earned both 30+ wpm and 90+% accuracy.

**__Thursday, January 19:__**
Today, we completed the work on the **Tour Guide Payroll Calculator** (which started as **EX A-1.xlsx**). We also logged in to SAM (link above) where you have a training called **Excel Unit A Training**. Class time was spent working on these assignments.

Homework:
 * **Tour Guide Payroll Calculator** - from textbook (unit A), due Sunday, printed out and turned in physically.
 * **Excel Unit A Training** - in SAM, due Sunday, in SAM, nothing to 'turn in'.
 * **TypingMaster** - 2 hours due by Sunday (Jan 22), 8am.

**__Tuesday, January 17:__**
Today, we discussed the advantages of using Excel (or other spreadsheet programs). You then began Unit A from the Excel section of the textbook. Here is the soft copy of the book ([|2007 Excel Unit A.docx]) and here is the starting file you need for Unit A ([|EX A-1.xlsx]). You worked through the unit at your own pace. We will continue working through this unit next class.

Homework:
 * TypingMaster - 2 hours due by Sunday (Jan 22), 8am.

**__Sunday, January 15:__**
Today, you continued watching presentations given by your fellow classmates. You started TypingMaster and took the first typing test of the semester (Astronauts, 3 minutes). We finished talking about the syllabus. We discussed what a spreadsheet is and how spreadsheet programs are useful in today's world.

Homework:
 * TypingMaster - 2 hours due by Sunday (Jan 22), 8am. __All accounts and passwords have been reset!!!__ Log in using your student number and Passw0rd. Start from the beginning of the Touch Typing Course. Remember that although you only have to complete two hours each week, if you complete more you will improve faster. Once you can prove you can type at least 30 words per minute with at least 90% accuracy, //THEN// you will no longer be required to do two hours of typing each week. Until you have reached that goal, you must complete the typing hours each week.

**__Thursday, January 12:__**
Today you watched presentations given by your fellow classmates. We talked about the syllabus details.

Homework:
 * None

**__Tuesday, January 10:__**
Today you learned about what this course covers and you watched a presentation about me. Here is my presentation ([|Miss Kim Intro.pptx]).

Homework:
 * Make a PowerPoint presentation about yourself and present it next class (Thursday, Jan 12).
 * Below is the last slide from my presentation about what your presentation should include.