Computer+Apps+II

> > **Application - a word we hear as "download our app"** > **1** **:** an act of applying: //**a**// //(1)// **:** an act of putting to use  //(2)// **:** a use to which something is put  //(3)// **:** a program (as a word processor or a spreadsheet) that performs one of the major tasks for which a computer is used. > toc
 * 1) Computer Applications II

Practice Keyboarding Skills:
@http://www.mrkent.com/typingtutor/index.htm @http://www.mrkent.com/typingtest/index.htm @http://www.techconnect.glencoe.com/techconnect/keyboarding/start.htm @http://www.testmytyping.com/typing-tutor.php @http://play.typeracer.com/
 * great for a quick refresher on which keys to use with which figures.
 * variety of tests to test yourself on your abilities
 * take a little to load, be patient! Need Adobe Shock-wave. Has lessons to follow.
 * Variety of skills, also talks about jobs related to typing.
 * My all time favorite! Are you ready to race? Race strangers or we can race each other!

Operating Systems:

 * 1) Pre test
 * 2) Lesson: watch videos and take notes using the Google Docs - worksheet
 * 3) Google docs: Presentation - compile the information you learned and collaborate with a group of 6 to create a presentation using the information learned.
 * 4) Post Test

Microsoft Word and Google Docs:
Pre-assessment - following this web as a guide; MS Word is divided into three categories, Basic, Intermediate and Advanced Watch Video on using the DEVELOPER tools in MS Word
 * Review the basic tools in MS Word**
 * Activity 1: Using the Page Layout Ribbon and www.Lyrics.com create a visually appealing poster. Must fit on 8"x11" paper, and use at least 5 different tools on the Page Layout Ribbon primary focus on Shapes.
 * Using Tables to make forms**
 * Brainstorm as a group and make list of the forms you use. Think of others ones that maybe your parents or teachers use.
 * Activity 2: Using tables, create a form.
 * @http://youtu.be/anWiC0g5lJM
 * Mail Merge -**
 * Write a thank you letter, see an example by using the link below.
 * @http://www.csufresno.edu/scholarships/faq/thankyouletter.shtml
 * Create a mailing, merging the information collected in this class to merge to printer. Then print envelops.

Show three different types of links in Word
 * Links -**
 * 1) website
 * 2) document on your computer's hard drive
 * 3) bookmark (where you link with in the same document to something further down)

Spreadsheets
Excel and Google Docs Spreadsheets:

> > Show me! No need to print this workbook. Skip #40. Thanks.
 * Learning basic formulas**
 * sum, minimum, maximum and average
 * countif
 * simple addition and subtraction
 * multiplication and division (order of operations
 * **How to input data, keep it neat and organized**
 * [[file:Activity 25 - Sales Report Assessment.xlsx]]TEST YOUR SK
 * PRINT ON ONE SHEET AND PRINT FORMULAS ON ONE SHEET **(CONTROL ~)**
 * Complete Activity 26 - print and file
 * [[file:Activities 27-30 Students.xlsx]]
 * Show me! No need to print this workbook.
 * [[file:Activities 31-36 Students.xlsx]]
 * Show me! No need to print this workbook.
 * [[file:Activities 37-41 Students.xlsx]]
 * [[file:ACTIVITY 39 - MUSIC GENRES.txt]]
 * [[file:Activities 42-48 Students.xlsx]]
 * There are 6 learning activities in this workbook, you will use a variety of graphs.
 * [[file:Activities 50-55 Students.xlsx]]
 * [[file:Activities 56 - 60 Students.xlsx]]
 * #59 is different pay attention to what is asked of you.

Wikispaces:
Our Class Wiki Site Your job is to:
 * Sept 14th** - We worked on Links in our Wiki. You should know that I changed the privacy settings, so only those of use who are members and are logged in can see this wiki. I also changed title to Our Class.
 * 1) Create your own page which will be your digital portfolio for this class. Tag it with your name.
 * 2) Need to have: at least one link to another website: school, go edu star, my wiki, bottom line it is your choice
 * 3) Upload and insert at least one document - I suggest the form you made, also the Lyrics creation, one can even use the picture we took with Jing and embed it!!!
 * 4) Use a widget like the table of contents; ask for clarity in class if you aren't sure. I would rather show you then describe it length here! Thanks.

Photo Editing:
Adobe Elements by Torrey Yeates @http://download.cnet.com/Adobe-Photoshop-Express/3000-13455_4-10826051.html?tag=rb_content;main IT IS NEW and you can use it on any computer with internet access. YEAH!

Movie Maker:
The goal is to create a 30 second clip that tells a story. The story is your choice. Movie Maker Videos and tips @http://download.cnet.com/windows/video-editing-software/
 * While you are building this you will learn a few things!
 * When finished I would like to see a list of 10 pointers. Things that could help you or another person in the near future.
 * Resources:**

__QUESTIONS to answer?__ HINT how and where you save you pictures - tell me the best practices.
 * 1) There are specific things your must do to use this program effectively and efficiently. What are they?
 * 1) How can you make an "automatic movie", when would this be handy?
 * 2) Can you time the slide show with music? Can you choose a verse or a chorus instead of the whole song?
 * 3) what would be helpful to do before making a movie? How would you plan it?

Access:
Access It - Go here! :)

**Objective:** You will learn to communicate effectively while using computer applications such as a word processor, spreadsheet, and presentation tools.

**Links for supplemental assignments**


 * 1) Word - Book
 * 2) Word - Online
 * 3) Excel
 * 4) Power Point
 * 5) Publisher
 * 6) Google Docs
 * 7) Access
 * 8) Technology Poster