MW

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

Welcome to Your Course Wiki! Monday - Wednesday Classes

This is where I will post your daily progress and work.

__**Monday, April 30:**__
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 Wednesday, May 2, before class
 * Exam Review Excel Unit B - DUE Wednesday, May 2, before class
 * Exam Review Excel Unit C - DUE Friday, May 4, by noon
 * Exam Review Excel Unit D - DUE Friday, May 4, by noon

These projects all deal with Excel, the hardest part of the exam.

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.

__**Monday, April 23:**__
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
 * be well organized
 * don't waste time when opening your documents to present (the time between presentations)
 * include useful information (don't have to mention every detail)

__**Wednesday, April 18:**__
Continue working on the Career Project.

__**Monday, April 16:**__
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
 * <span style="font-family: Arial,Helvetica,sans-serif; font-size: 19.2px;"> at least one sound file
 * <span style="font-family: Arial,Helvetica,sans-serif; font-size: 19.2px;">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 //** Wednesday, April 25. **//

__**Wednesday, April 11:**__
Today we continued working on the assignments due this coming Monday.

__**Monday, April 9:**__
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 Monday, April 16, before class //. **No late assignments will be accepted**.

__**Monday, April 2:**__
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 Monday and everything will be due one week later on Monday. Here is the soft copy of the unit ([|2007 PowerPoint Unit D.pdf]).

Here are this week's assignments. Make sure to do the assignments IN THIS ORDER!
 * 1) PowerPoint Unit C Project in SAM
 * 2) PowerPoint Unit D Training in SAM
 * 3) PowerPoint Unit D Lesson in textbook: [|PPT D-1.pptx], [|PPT_D-2.jpg]. Renamed: Last_First_QuestD.pptx
 * 4) PowerPoint Unit D Skills Review in textbook: [|PPT D-3.pptx], [|PPT_D-4.jpg]. Renamed: Last_First_MediaCom.pptx
 * 5) PowerPoint Unit D Project in SAM
 * TypingMaster, 2 hours, if you are //not// above 30 wpm //and// 90% accuracy.

These assignments are due on Monday, April 9th, before class. Use your time wisely. If you have any questions, please see me.

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

**__Wednesday, March 28:__**
Today we worked on the Skills Review for PowerPoint Unit C. Here are the files you will 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.

__Monday, March 26:__
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. After that we began the lesson for Unit C of PowerPoint. Here is the soft copy ([|2007 PowerPoint Unit C.pdf]) and here are the files you will need ([|PPT C-1.pptx], [|PPT C-2.docx], [|PPT_C-3.jpg]) the first one will change its name to Last_First_QuestC.

Homework:
 * Finish the training for Unit C.
 * Finish the Quest C PowerPoint file.

__Wednesday, March 21:__
Today we continued practicing the skills of PowerPoint by completing the Unit B project in SAM. After you complete Unit B Project, do the Independent Challenge #2 in the Purple pages of PowerPoint Unit B (page PowerPoint 46). You will need this file ([|PPT B-4.pptx]) and it will change its name to Last_First_Loan_Broker.pptx.

Homework:
 * Finish SAM PowerPoint Unit B Project and submit to SAM.
 * Finish Independent Challenge #2 (Loan Broker) and send to me.
 * TypingMaster - Finish the hours required by Monday, March 26th.

__Monday, March 19:__
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 for PowerPoint Unit B. This is the file you need ([|PPT B-2.pptx]) and its name will change to Last_First_TechJet.pptx. When you are done, send it to me.

Homework:
 * Get caught up on anything you are missing. See the assignments page for what has been assigned.
 * TypingMaster, 2 hours due by Monday, March 26, if you are //not// above 30 wpm //and// 90% accuracy. By this date you should have 10 hours of typing. This is the deadline.

__Wednesday, March 14:__
Today, class was short or non-existent due to the photo-shoot with Her Highness. You must complete the assignments below for homework. The Unit B lesson uses this file (<span class="wiki_link_ext">[|PPT B-1.pptx] ) and its name will change to be LastName_FirstName_QuestB.pptx. Here is the soft copy for Unit B ([|2007 PowerPoint Unit B.pdf]).

Homework:
 * Complete SAM Project Unit A
 * Complete the Unit B Lesson from the textbook, Quest B.
 * TypingMaster, 2 hours due by Monday, March 19, if you are //not// above 30 wpm //and// 90% accuracy.

__Monday, March 12:__
Today we started with a typing test in TypingMaster (Behind the scenes: movie credits, 3 minutes). Then we watched a video called Life After Death By PowerPoint 2010 about what **NOT** to do in PowerPoint. We went through PowerPoint Unit A as a class ([|PowerPoint Unit A.ppt]).

Homework:
 * SAM Training for PowerPoint Units A & B
 * TypingMaster, 2 hours due by Monday, March 19, if you are //not// above 30 wpm //and// 90% accuracy.

__Wednesday, February 29 (LEAP DAY!):__
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**.** This should be completed and sent to me before you leave class.

Homework:
 * Finish Departmental Software Usage (if you haven't finished it already) and send it to me.
 * SAM Project Unit D
 * TypingMaster, 2 hour hours due by Sunday, March 11, if you are //not// above 30 wpm //and// 90% accuracy.

__Monday, February 27:__
Today we started with a typing test in TypingMaster (Rules of Baseball (from 1889), 3 minutes). Then we moved on to do the lesson from 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. Complete all the non-purple pages for Unit D.

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

__Wednesday, February 22:__
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). You should have finished this during class and sent it to me.


 * 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:
 * SAM, Unit C Project - due by next class.
 * TypingMaster, 2 hour hours due this week if you are **//not//** above 30 wpm **//and//** 90% accuracy

__Monday, February 20:__
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).

__Wednesday, February 15:__
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.
 * TypingMaster - 2 hours due by Monday, Feb 20, if you are //**not**// above 30 wpm **//and//** 90% accuracy.

__Monday, February 13:__
Today we started with a typing test in TypingMaster (Yosemite National Park, 3 minutes). Then we moved on to an exam in SAM on Unit B. Then you started the training for Unit C in SAM.

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

__Wednesday, February 8:__
Today we discussed any problems you had with the previous assignments. Then you did a SAM Unit B Project. You have three attempts to get the highest score possible.

__Homework:__
 * Finish the SAM Project for Unit B.
 * TypingMaster - 2 hours due by Monday, Feb 13, if you are //**not**// above 30 wpm **//and//** 90% accuracy.

__Monday, February 6:__
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. Due by next class.
 * TypingMaster - 2 hours due by Monday, Feb 13, if you are //**not**// above 30 wpm **//and//** 90% accuracy.

__Wednesday, February 1:__
Today we discussed the SAM training on Unit B and then we started the objectives of the unit:
 * 1) Create a complex formula
 * 2) Insert a function
 * 3) Type a function
 * 4) Copy and move cell entries
 * 5) Understanding relative and absolute cell references
 * 6) Copying formulas with relative cell references
 * 7) Copying formulas with absolute cell references

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 -39 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 Monday, Feb 6, if you are //**not**// above 30 wpm **//and//** 90% accuracy.

__Monday, Jan 30:__
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 Monday, Feb 6, if you are //**not**// above 30 wpm **//and//** 90% accuracy.

__Wednesday, Jan 25:__
Today, we discussed the SAM training and found solutions to problems (like not marking the tasks complete and such). Then you did the Independent Challenge #2 (Hot Cars Sales) from the textbook on page 21. Then I showed how to do a 'project' in SAM. You will have a SAM exam next class on the Excel Unit A Training.

Homework:
 * SAM Excel Unit A Project 1 Scenario 2 - due Monday, Jan 30
 * Finish SAM Excel Unit A Training if not already done
 * Finish Independent Challenge #2 (Hot Cars Sales) if not already done
 * TypingMaster - 2 hours due Monday, Jan 30, 8am. **-- Note the changed due date!**

__Monday, Jan 23:__
Today, you started class with a typing test in TypingMaster (The Life of Calamity Jane, 3 minutes). Next you finished working on the Tour Guide Payroll Calculator (EX A-1.xlsx) and //__printed the final version for me__//. Then we walked through SAM and how to do a training module.

Homework:
 * Excel Unit A Training in SAM - due next class, Wednesday, Jan 25
 * TypingMaster - 2 hours due by Sunday (Jan 29), 8am

__Wednesday, Jan 18:__
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]). In class, you finished up through at least page 11.

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

__Monday, Jan 16:__
Today you watched presentations given by your fellow students. We discussed the syllabus (see the link at the top of this page). You started Typing Master and took your first typing test of the semester (Astronauts, 3 minutes).

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.

**__Wednesday, Jan 11:__**
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"]].