STT

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

Welcome to Your Course Wiki! Sunday - Tuesday - Thursday Classes

This is where I will post your 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 12 noon until 1:30 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]

Here is the Excel exam review that I've given 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!**__

__**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!
 * prepare well - practice!
 * be confident
 * avoid sarcasm

__**Thursday, April 19:**__
Continue working on the Career Project.

__**Tuesday, April 17:**__
Continue working on the Career Project.

__**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
 * 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 any videos necessary.

These assignments are// due on Sunday, April 15, before class //. **No late assignments 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 of the unit ([|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.

START 6TH MARKING PERIOD

Thursday, March 29:
Today you did the skills review for PowerPoint Unit C. Here are the three files you need ([|PPT C-4.pptx], [|PPT C-5.docx], [|PPT_C-6.jpg]). The .pptx file will change its name to be Last_First_BlueMoon. Remember, the only file you will send to me is the BlueMoon.pptx file, NOT the .docx or the .jpeg files.

Homework:
 * Finish the Blue Moon files and send it to me.

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

Homework:
 * Finish the QuestC PowerPoint file and send it to me.

__**Sunday, March 25:**__
We started today with a typing test in TypingMaster (Thoughts of Benjamin Franklin, 3 minutes). Then you did the PowerPoint Training for Unit C in SAM.

__**Thursday, March 22:**__
Today we continued in PowerPoint Unit B by working on the Independent Challenge #2 which is in the purple pages of the textbook (PowerPoint page 46). The file you need is [|PPT B-4.pptx] and it will change its name to Last_First_Loan_Broker.pptx.

Homework:
 * Finish Loan Broker and send it to me.
 * TypingMaster, 2 hour hours due by Sunday, March 25, if you are //not// above 30 wpm //and// 90% accuracy. By that day, you should have up to 10 hours total in TypingMaster. Once you've reached your total for this marking period, do not add more hours until I reset the time to zero. Thanks!

__**Tuesday, March 20:**__
Today, we used SAM to practice our PowerPoint skills by completing the Unit B Project.

Homework:
 * Finish the PowerPoint Unit B Project in SAM.
 * TypingMaster, 2 hour hours due by Sunday, March 25, if you are //not// above 30 wpm //and// 90% accuracy. By that day, you should have up to 10 hours total in TypingMaster. Once you've reached your total for this marking period, do not add more hours until I reset the time to zero. Thanks!

__**Sunday, March 18:**__
Today we started with a typing test in TypingMaster (DNA Research - The Human Genome Project, 3 minutes). Then we moved on to the Skills Review at the end of PowerPoint Unit B. It needs this file ([|PPT B-2.pptx]) which will change its name to LastName_FirstName_**TechJet**.pptx. The instructions are in the soft copy below or in the textbook.

Homework:
 * Finish TechJet and send it to me.
 * TypingMaster, 2 hour hours due by Sunday, March 25, if you are //not// above 30 wpm //and// 90% accuracy. By that day, you should have 10 hours total in TypingMaster.

__**Thursday, March 15:**__
Today we worked through the lesson for PowerPoint Unit B. Here is the starting file (__[|PPT B-1.pptx]__ which will change its name to Quest B) and the soft copy of the unit ([|2007 PowerPoint Unit B.pdf]).

Homework:
 * Finish the file for Unit B (Quest B) and send it to me.
 * TypingMaster, 2 hour hours due by Sunday, March 19, if you are //not// above 30 wpm //and// 90% accuracy. By that day, you should have 8 hours total in TypingMaster.

__**Tuesday, March 13:**__
Today we finished our discussion of the important features of PowerPoint from Unit A. Then you started work on two assignments: SAM Training PowerPoint A&B and SAM Project Unit A.

Homework:
 * Finish the SAM Training for PowerPoint Units A&B
 * Finish the SAM Project Unit A
 * TypingMaster, 2 hour hours due by Sunday, March 19, if you are //not// above 30 wpm //and// 90% accuracy. By that day, you should have 8 hours total in TypingMaster.

__**Sunday, March 11:**__
Today we started with a typing test in TypingMaster (Behind the scene: movie credits, 3 minutes). We then moved to talk about the uses of PowerPoint and good and bad PowerPoint presentations you've seen. We watched a video called Life After Death By PowerPoint about what NOT to do in PowerPoint. Then we discussed the first few objectives in our lesson ([|PowerPoint Unit A.ppt]).

Homework:
 * TypingMaster, 2 hour hours due by Sunday, March 19, if you are //not// above 30 wpm //and// 90% accuracy.

__**Thursday, Mar 1:**__
Today we continued practicing the skills learned in Unit D by complete the SAM Project for Unit D. You should be able to finish and submit this in class, up to three times.

Homework:
 * None, IF you finished the SAM Project for Unit D!
 * Finish the SAM Project for Unit D if you didn't finish it in class.

__**Tuesday, Feb 28:**__
Today we continued practicing the skills learned in Unit D by completing the Skills Review at the end of the unit. You used this file ([|EX D-2.xlsx]) and changed its name to LastName_FirstName_Departmental Software Usage**.**

Homework:
 * Finish Departmental Software Usage and send it to me.
 * TypingMaster, 2 hour hours due by Sunday, March 11, if you are //not// above 30 wpm //and// 90% accuracy.

__**Sunday, Feb 26:**__
Today we started with a typing test in TypingMaster (The Rules of Baseball (from 1889), 3 minutes). Then we moved on to Unit D - Charts. Here is the soft copy ( [|2007 Excel Unit D.pdf] ) of the unit. Use this file ([|EX D-1.xlsx]) as your starting file and its name will change to Quarterly Tour Revenue.

Homework:
 * Finish Quarterly Tour Revenue and send it to me.
 * TypingMaster, 2 hour hours due by Sunday, March 11, if you are //not// above 30 wpm //and// 90% accuracy.

__**Thursday, Feb 23:**__
Today we continued practicing the skills in Unit C - Formatting. We worked on completing the SAM Unit C Project.

Homework:
 * Finish the project and submit it through SAM to get the highest grade possible.
 * SAM Training on Unit D
 * TypingMaster, 2 hour hours due by Sunday, Feb 26, if you are //not// above 30 wpm //and// 90% accuracy.

__**Tuesday, Feb 21:**__
Today we continued QST Advertising Expenses and you sent it to me when it was done. Then you moved on to the Unit C Skills Review (pages 71-73, uses [|EX C-2.xlsx] which will be called Health Insurance Premiums).


 * NOTE: ** There is an old version of the textbook that is **__incorrect__**. In the Unit C Skills Review, #6f should read: Format the range A14:B14 with a pattern style of Thin Diagonal Stripes, a fill color of Dark Blue, Text 2, Lighter 40%, then apply the bold attribute.

Homework:
 * Finish Health Insurance Premiums and send it to me. Make sure it is named **//correctly//**.
 * TypingMaster, 2 hour hours due by Sunday, Feb 26, if you are //not// above 30 wpm //and// 90% accuracy.

__**Sunday, Feb 19:**__
Today we started with a typing test in TypingMaster (Observations of the "Father of Computing", 3 minutes). Then we continued with the lesson from Unit C, QST Advertising Expenses (see last class for the documents).

Homework:
 * Finish QST Advertising Expenses and send it to me.
 * TypingMaster, 2 hour hours due by Sunday, Feb 26, if you are **//not//** above 30 wpm **//and//** 90% accuracy.

**Start Marking Period 5 **

__**Thursday, Feb 16:**__
Today we went over any problems with submitting assignments through Excel and SAM. Then you started the lesson for Unit C (soft copy: [|2007 Excel Unit C.pdf]) and the starting document ([|EX C-1.xlsx]) which will change to be named LastName_FirstName_QST Advertising Expenses.

Homework:
 * DO NOT FINISH C-1 for homework.
 * TypingMaster - 2 hours due by Sunday, Feb 19, if you are //**not**// above 30 wpm **//and//** 90% accuracy.

__**Sunday, Feb 12:**__
Today, we started with a typing test in TypingMaster (Yosemite National Park, 3 minutes). You did an Exam in SAM on Unit B. You worked on the SAM Excel Unit C Training.

Homework:
 * Finish SAM Excel Unit C Training
 * TypingMaster - 2 hours due by Sunday, Feb 19, if you are //**not**// above 30 wpm **//and//** 90% accuracy.

__**Thursday, Feb 9:**__
Today we worked on the Independent Challenge #2 on page Excel 47. It uses this file ([|EX B-4.xlsx]) which will be changed to Pamper Yourself Finances. Submit this via email.

Homework:
 * Finish the Pamper Yourself Finances.
 * SAM Excel Unit C Training
 * TypingMaster - 2 hours due by Sunday, Feb 12, if you are //**not**// above 30 wpm **//and//** 90% accuracy.

__**Tuesday, Feb 7:**__
Today, we talked through any problems you had with the previous assignments. The class assignment is Project B in SAM. Submit through SAM as normal. You have three attempts to score as high as possible.

Homework:
 * Finish the SAM Project B
 * TypingMaster - 2 hours due by Sunday, Feb 12, if you are //**not**// above 30 wpm **//and//** 90% accuracy.

__**Sunday, Feb 5:**__
Today, we started with a typing test in TypingMaster (Netiquette, 3 minutes). Today we finished the last objective (8. Round a value with a function). We finished the Tour Revenue Analysis and turned that in via email. We worked on the skills review (Excel pages 44-45) and it uses this file ([|EX B-2.xlsx]) and it will change its name to Candy Supply Company Inventory.

Homework:
 * Finish the Skills Review (Candy Supply Company Inventory) and send it to me.
 * TypingMaster - 2 hours due by Sunday, Feb 12, if you are //**not**// above 30 wpm **//and//** 90% accuracy.

__**Thursday, Feb 2:**__
Today we continued learning Excel Unit B by looking at the most complex items in the unit - relative and absolute cell references. Objectives #5-7 were completed (5. Understanding relative and absolute cell references; 6. Copying formulas with relative cell references; 7. Copying formulas with absolute cell references).

Homework:
 * Complete pages Excel 34-39 from the textbook using the files already given to you.
 * TypingMaster - 2 hours due by Sunday, Feb 5, if you are //**not**// above 30 wpm **//and//** 90% accuracy.

__**Tuesday, Jan 31:**__
Today we discussed the SAM training on Unit B and the first four objectives of the unit (1. Create a complex formula; 2. Insert a function; 3. Type a function; 4. Copy and move cell entries). Here is the soft copy of the unit ([|2007 Excel Unit B.pdf]) and the starting file ([|EX B-1.xlsx]) which will change to have the name "Tour Revenue Analysis."

Homework:
 * Complete pages Excel 25 -33 from the text book using the file above. Remember you can check out a text book in the library. - due next class.
 * TypingMaster - 2 hours due by Sunday, Feb 5, if you are //**not**// above 30 wpm **//and//** 90% accuracy.

__**Sunday, Jan 29:**__
Today, we started with a typing test in TypingMaster (Legends of Abraham Lincoln, 3 minutes). Then we did a SAM exam on Excel Unit A Training. After the exam, you started the SAM Unit B Training.

Homework:
 * Finish the SAM Unit B Training.
 * TypingMaster - 2 hours due by Sunday, Feb 5, if you are //**not**// above 30 wpm **//and//** 90% accuracy.

__**Thursday, Jan 26:**__
Today, you learned how to do a project in SAM and started on Project 1 (Scenario 2). You will need to submit this to SAM, up to three times, to get the best score possible. Be prepared for a SAM exam next class on the Excel Unit A Training.

Homework:
 * Finish the SAM project.
 * TypingMaster - 2 hours due by Sunday, Jan 29, 8am

__**Tuesday, Jan 24:**__
//**Period 1:**// Today, you finished the Tour Guide Payroll Calculator and printed it out for me. Then you started on Independent Challenge #2 (page 21 in the textbook, Hot Car Sales). When you are done with this one, email it to me - do not print it out as the instructions say.

//**Period** **7:**// Today, you finished the Tour Guide Payroll Calculator and printed it out for me. Then you worked on the Independent Challenge #2 (page 21 in the textbook, Hot Car Sales). When you are done with this one, email it to me - do not print it out as the instructions say.


 * Homework:**
 * Period 1: Finish the Hot Car Sales file from Independent Challenge #2 and email it to me.
 * Period 7: Finish the Hot Car Sales file from Independent Challenge #2 and email it to me.
 * TypingMaster - 2 hours due by Sunday, Jan 29, 8am.

__**Sunday, Jan 22:**__

 * //Period 1://** Today, we started with a Typing Test in TypingMaster (The Life of Calamity Jane, 3 minutes). Then you logged in to SAM and I walked you through the beginning of the Excel Unit A Training. We started to work on the Tour Guide Payroll Calculator (EX A-1.xlsx) to complete it but we ran out of time.

//**Period 7:**// Today, we started with a Typing Test in TypingMaster (The Life of Calamity Jane, 3 minutes). Then we worked on the Tour Guide Payroll Calculator (EX A-1.xlsx).

Homework: >
 * Period 1: SAM Excel Unit A Training
 * Period 7: Finish Unit A from the book using the Tour Guide Payroll Calculator (EX A-1.xlsx). Make sure to print it following the directions in the last section and be prepared to physically hand it in to me either in class or in the box on my office door by Tuesday's class.

__**Thursday, Jan 19:**__
Today, you continued working on the Tour Guide Payroll Calculator (EX A-1.xlsx). You should have finished up through page 13, but you may have gotten farther.

Homework: >
 * Period 1 - Tour Guide Payroll Calculator done up through page 13.
 * Period 7 - SAM Excel Unit A Training
 * TypingMaster - 2 hours due by Sunday (Jan 22), 8am.

__**Tuesday, Jan 17:**__
Today you finished watching presentations by your fellow students. Then we discussed spreadsheet software and started Unit A in Excel. Here is the soft copy of Unit A ([|2007 Excel Unit A.pdf]). Here is the document you will need to alter for Unit A ([|EX A-1.xlsx]).

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

**__Sunday, Jan 15:__**
Today you watched more presentations given by your fellow students. We discussed the syllabus (see the link at the top of this page). We started looking at Excel and spreadsheet programs.

Homework:
 * TypingMaster - 2 hours due by Sunday (Jan 22), 8am. __All accounts and passwords have been reset!!!__ Login 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, Jan 12:__**
Today you watched presentations given by your fellow students and got to know a bit about them. We also took a look at the syllabus (link is at the top of this page) and will finish that up next class.

Homework:
 * None if you've already given your presentation. If you still need to give yours, be prepared next class.

**__Tuesday, January 10:__**
Today you learned about what this course covers and you watched a presentation about me. Here is my PowerPoint ([|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[[image:a.PNG width="327" height="246" align="left"]].