COMPUTER APPLICATIONS

 

Computer Applications is a course designed to help develop the fundamentals of MS Office 2007 using Windows as the operating system, and to develop basic keyboarding and computer skills. We will focus on MS Word, Excel and PowerPoint, and keyboarding skills. This class will acquaint you with the proper way to solve word-processing problems, illustrate practical applications and presentations. Assignments will be individual and team based.

Computer use #1

Computer use #2


Excel Lessons

excel quizzes

Making a quiz in excel

Excel Shortcuts

Other excel items

Project #1 Presidents: Create a spreadsheet of the 44 United States Presidents. SAVE the file and name it "Presidents". Make sure to have headers, and that all information goes in seperate cells. List how old when he was elected, his favorite food, and political party. Also was he elected to office? Did he die in office? Was he Vice President first? What was his home state? Did he have pets in the White House? Was he elected to a second term?

practice sorting this table.

Excel projects

Project #2 business spreadsheet.

Project #3 Million dollars

Set up a spread sheet where you spend $1million dollars on at least 10 items. Include sales tax of 8.25%. You must spend exactly $1 million dollars, to the exact penny. Create a pie cahrt of your final results.

Review for test.

Test

 

TYPING

Ten Key

Google Posters

 

Word Lessons

(Remember there are multiple lessons in each section. Practice files and "test yourself" are in most lessons)

Sections 1

Section 2

Complaint letter

Section 3

Section 4

Advertisement

Section 5

Accomplishments

 

Musician report

Presentation Skills Discussion

Powerpoint Lessons

Power Point Tips

Powerpoint Projects

Project #1 create a powerpoint for the school's Dress code

Project #2 Game using internal hyperlinks: create a game using Powerpoint hyperlinks.

 

Prezi.com

Create a Prezi to promote a product off of Quirky.com

Sliderocket.com Create a SlideRocket for the Bill Of Rights. Make sure 2 slides are about why, who and how the Bill of Rights was created. Then have 1 slide SUMMARIZING each amendment.

 

Google Docs

Create a questionnaire with 5 questions and submit to 10 friends

Internet search skills:

W3SCHOOLS.COM

Web Design

Dreamweaver/Flash

Wix.com