5th+Period+Computers+for+College+and+Careers

Welcome to Computers for College and Careers! Use this page as a place to find assignments and resources. Something everyone using Facebook should think about. You'll probably need to access this from home. []
 * Great Website for Tech info when Shopping** []
 * What Happens in an internet minute**.[|http://www.techpark.net/wp-content/uploads/2014/01/WhatHappendInAnInternetMin]
 * RESOURCES LINK (** **Resources to help you. USE THEM!)** If you forgot how to do Print Screen Look in Here.

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx Materials to study for the Final Exam. xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx 1. Here are the Tech Terms Defined. 2. Hardware

3. Software You will also need to know The Commands in 4. Microsoft Word, 5. Micorsoft Publisher, M 6.Microsoft Excel and 7. The Coding Commands in the 3 Lessons and 8. The Coding Coomands in the Current Event.. **The Underclass Exam is Friday during the 5th period exam block**, Bring a pencil and something you can do silently while others are finishing the exam. You may not talk during the exam. Raise your hand if you need assistance. You may not be out of your seat without permission. XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX Past Due assignments ---  Assignments for Week of 5/19/14- 5/23/14. 1. Current Event: [] Due Tuesday. 2. Coding Assignment #3. Due Thursday. Here is the help file. [] Here is the example to compare your webpage to. []

Assignments for Week of 5/12/14-5/16/14. For those that did not do the extra credit last week. 1. Open up Notepad. This is your text editor. Be sure to save the file in your folder. Click on the file and it should open up as a webpage. It should look like this. Make sure you don't type "Your name" but actually type in YOUR NAME ie. Tyler Allen). If not, go back and check the code and see if you typed everything correctly. Due Wednesday. 2. Then, Open Notepad. Here is a Help File. [] Your Webpage should look like this. [] Due Thursday. 3. Current Event: [] Due Friday. Friday - Make-Up Work and Senior Exam. Assignments for Week fo5/5/14-5/914.

1. PPT Presentations begin Tuesday. 2. Current Event due Friday. [] 3. Extra Credit: Open up Notepad. This is your text editor. Be sure to save the file in your folder. Click on the file and it should open up as a webpage. It should look like this. Make sure you don't type "Your name" but actually type in YOUR NAME ie. Tyler Allen). If not, go back and check the code and see if you typed everything correctly.

Assignments for Week of 4/28/14-5/2/14.

Current Event: This should be done at home as it will take you a while to complete. Start Tuesday night and print before coming to class on Friday. Go to this link. [] You will need several sheets of paper. Make a list of the 50 persons that The Verge noted changed our lives in 2013. You may want to use a table in a Word Document to compile all the data. Include the following: Name Profession Age Positions held or holding, Major accomplishments.

Save it in your folder and title it "The Verge 50." Due Friday 5/2/14, Remember current events are due in the first 2-3 minutes of class. Since we are presenting out PPTs on Thursday and Friday, you will not be on the computers between Wednesday and Monday. Use your time wisely.

1. Use your your Excel file Titled **"Music Preferences.".** 2. Complete a thorough analysis of the data. Some questions you may ask are: Does age factor into your results? Is there any agreement among the participants? Within a genre, do participants agree or disagree? Do girls and boys have similar or different preferences? Other findings? There are many other questions you could ask depending our your data.

Pivot Charts []

Microsoft Excel 2013 (Pie/Column Chart, Pivot Table) []

3. Make several charts to represent your data. You might be able to show some data better in a table rather than a chart. 4. Write a short summary of your findings (2-3 sentences). 5. Now, use your charts and summary to explaing your findings in a PPT. Save your PPT as "Music Survey" in your folder. Be prepared to present your findings to the class for a grade by the end of class Wednesday. 6. Review the following document. This will help you wiht your presentation. 7. Practice your presentation for the class. We will present to each other on Thursday and Friday. Assignments for Week of 4/21-25/14

All grades are in PinPoint up through 4/23/14. If you want to improve your grade on previous assignments you have until the __end of class on Friday 4/24/14__. //__No late work will be accepted on assignments dated 4/23 or prior after the 5th period exit bell rings Friday 4/24/14__//. This includes corrections to work already submitted.

1. **Read through this tutorial** on creating charts in Excel [|http://office.microsoft.com/en-us/excel-help/create-a-chart-from-start-to-finish-HP010342356.aspx#_Toc255902075] [|2] Create the following Excel Document. It should contain all the data in this PDF. **Save it as "ClassTestData" in Excel**. 2. Open a blank word document. 3. **Save it as "Graph Imports from Excel to Word**."

4. In this assignment, you are an employee of a company called, "Test Solutions." You are writing a letter to your boss, Mr. Nononsense Getresults asking for a pay raise based on the test performance of the workers in your department. You should use charts demonstrating the performance of your workers on various skills tests. This should be a professional looking letter with no flowery borders, etc. Keep it all business.

5. Now go back into Excel and Create the charts you will use in your letter to plead your case to Mr. Getresults. Your charts should include: a. names of workers b. tests c. test scores d. a title for each graph

6. Now write your letter. In your letter, be sure to include: a. Your name and return address b. Mr. Getresults name and address c. a business professional greeting d. a short letter stating your case e. charts to help plead your case f. a closing and signature

7. Now import your charts to support your case. You will need to figure out how to move the **charts** from Excel into work and keep the formatting. **Due Wednesday 4/23/14.**

8. Current Event: [] In your summary, list the 3 ways to speed up your computer. **Due Friday 4/25/14.**

9. Assignment #2 For this assignment you will need to complete a music survey. You will need the following data for you charts: a. First and Last Name and Age of 20 Chiles High School students. They cannot be a member of this 5th period class. (This is easy because all high school students think they are music experts.) b. Favorite genre of music (ie. Rock, Jazz, Classical, etc.) c. Favorite artist within that genre. d. Favorite Song from that artist.

10. Now enter your data in an Excel doc and title it "Music Preferences." Save it in your folder. **Due Friday 4/25/14. We will do more with this next week.**

Assignments for Week of 4/14/14-4/18/14 1. Create the following Excel Document. It should contain all the data in this PDF. Save it as "CCCMail" in Excel. You will need this data to complete this week's assignment. 2. Now open the Mail Merge Tutorial. Follow each step carefully. [] 3. Once you've gone through the Tutorial, and think you understand the process of a mail merge from an Excel File into a word letter, open a Word Document and save it as "Mail Merge from Excel into Word." 4. You will be creating a letter to the people in your CCCMail file telling them they are being fired today. In your letter, you need to tell they why they are being fired and how to go about getting their final paycheck, including when to pick it up and who to pick in up from. 5. Be sure to include a greeting and a closing to the letter along with the company's name. (You may use a form letter for Microsoft or write one of your own. 6. After you've finished the merge, Save your letter in a PDF file titled Merge from Excel to Word in PDF and put it in your 4th Nine weeks folder. Due Wednesday 4/16/14. 7. Current Event: [] **Due Friday 4/18/14.** 8. Merge Assignment #2: Type the following PDF as a Word Document. The fields that are to be merged you will enter using the mail merge to enter each field. Do not type it in or it will not merge. Here is the PDf  you will need to type as an excel data file to be merged into your word document. Save your merged word document and title it Merge Assignment 2. **Due Friday 4/18/14.**

Assignments for Week of 4/7/14-4/11/14. 1. Practice working through modules 1-6 of this link []. Be sure to watch each of the videos along the way. This may take you two class periods. 2. Wednesday: You should be through Step 1 by today. Instructions for Publisher document titled "Objects." Due Friday 4/11/14.

3. Current Event: [] Be sure to explain in your summary the reason for this invention and the goals of the gloves' creator.

4. Step 1.:Create a calender (You will need more than 1 month) that shows all the assignments (Including the tutorials and practice assignments) form the beginning of the 4th nine weeks. Place each item on their due date. Use the complete name of the assignments from Pinpoint. You will need to adjust the size of the box or the text size. Be sure that is it is legible. Step 2: Open a word Document and save your calendar in a one page word document. Step 3. Print your word Document as a PDF and save it as "Calendar Saved in Word" in your 4th nine weeks folder. Due Friday. This assignment should be the last item included on your calendar.

Have a great weekend!

Assignments for Week of 3/31/14-4/5/14.

1. Study the following tutorial of formatting text. [|http://www.bing.com/videos/search?q=Publisher+2010+How+to+Guides&qs=n&form=QBVR&pq=publisher+2010+how+to+guides&sc=0-0&sp=-1&sk=#view=detail&mid=F56ABA8D04257CFF4CE8F56ABA8D04257CFF4CE8]

2. Create a one page Publisher document. Create 3 separate text boxes. Link each of the 3 text boxes so that the text will run into the next text box. Create a half-page typed story, using a font size of 14pt Times New Roman, about something that happened to you when you were younger that made a difference in your life. Add pictures to illustrate your story. Now adjust each sentence to a different font size. Sentence 1 20pt courier in italics; Sentence 2 12pt Comic Sans MS underlined; Sentence 3 16pt Arial Black Bold; For each of the remaining sentences, use a different font and effect. **Due Thursday 4/3/14.**

3. Study the following tutorial about using business data in your documents. [|http://www.bing.com/videos/search?q=Publisher+2010+How+to+Guides&qs=n&form=QBVR&pq=publisher+2010+how+to+guides&sc=0-0&sp=-1&sk=#view=detail&mid=0F6181C729E89F98DE360F6181C729E89F98DE36]

4. Create a tri-fold brochure.. Research a place you would like to visit including costs, places of interest, entertainment, and dining. Including testimonials from former customers. Somewhere in your brochure insert your business data that you've created. Include a business logo. **Due Friday 4/4/14.** Here is an example of a brochure.

5. Current event: [|http://www.cnet.com/news/filling-the-gaps-microsoft-contest-locates-new-prime-numbers**/**] **Due Friday 4/4/14**

1. Introduction to Publisher - Read the following introduction to Publisher 2010 Tutorials. []
 * Assignments for Week of 3/25-29/14**

2. Create a 2 page newsletter using the features from the Tutorial. The Newsletter should give information about what you did during spring break. Include pictures and other interesting information. Due Friday 3/28/14. Here is an example of a News letter.

[] In your summary discuss the benefits of crowdsourcing, collaboration and the industrial internet.
 * 3. Current Event Due Friday 3/28/14. You'll want to do this at home and use your classtime for #4.**

[|http://www.bing.com/videos/search?q=Publisher+2010+How+to+Guides&qs=n&form=QBVR&pq=publisher+2010+how+to+guides&sc=0-0&sp=-1&sk=#view=detail&mid=E85F5CA4B1885AF09F8DE85F5CA4B1885AF09F8D] While watching the tutorial, open a new blank Publisher Document. Save it in your 4th Nine weeks folder as "Backgrounds #1". 5. As the Background tutorial plays, follow each step and save it on a new page in your document. Create: a. a page with no backgrounds b. a page with a one color gradient background horizontal c. a page with a one color gradient background vertical d. a page with two colors gradient background horizontal e. a page with two colors gradient corner f. a page with a texture background g. a page with a pattern background blue and red h. a page with a pattern background black and white i. a page with a picture tiled background j. a page with a teal tint background Remember to save all in the same document but on separate pages. You should end up with 10 pages of backgrounds. **Due Friday 3/28/14.**
 * 4. Open the Background tutorial.**

1st 3 Nine Weeks 
 * Assignments for Week of 3/10-14/14**
 * 1. Current Event** [] **DueThursday 3/13/14.**
 * 2. 10 Common Mistakes fo Presenters [[file:10 Most Common Rookie Mistakes in Public Speaking.pdf]]**
 * 3. Answer the Questions for #2 [[file:Questions for #2 Week of 3_10-14_14.pdf]]Due Friday** 3/14/14.
 * 4. MS Word Assignment #3. [[file:MS WORD Assignment #3 Newsletter.pdf]]Due Friday** 3/14/14.

[] Then Complete the Assignment
 * Assigments for Week fo 3/3-7/14**
 * 1.[[file:Assignment for Week of 3_3-7_14.pdf]]Due Wednesday 3/5/14**
 * 2. Current Event** [] **Due Friday 3/7/14**
 * 3. MS Word Assignment #2 Complete Page 9-17 of the Tutorial link below.**
 * [[file:MS WORD Assignment #2.pdf]]Due Friday 3/7/14.**

1. Build the PPT. Meet the requirements of the project. If you want to present to the class, You must be finished by Wednesday 2/26/14. 2. Final **Due Date for PPT 2/28/14.** 3. Currrent Event **Due Friday 2/28/14**.
 * Assignments for Week of 2/24-28/14**

MAKE UP ASSIGNMENT FOR EXCEL QUIZ 1. Get Black History Research Assignment (Your person is your computer number) 2. Read Instructions for assignment. 3. Do the research. That means, take notes, use a "WEB" to focus your topics. Web Notes **Due Friday 2/21/14**. 4. Current Event **Due Friday 2/21/14**.
 * Assignments for Week of 2/18-21/14**

1. Caculate using formulas the answers to the questions in the given Excel File. Here it is. Use the Data from the PDF. Type it into your Excel Workbook, Title it "Find the Sum of the Columns based on Color and Save it in your folder. Then caculate and save. **Due Tuesday** 2. Current Event **Due Friday. ** 3. Monthly Lawn Maintenance Log. Create the Given Workbook. Caculate the Income, Expenses, and Profit and Losses asked for. **Due Friday**
 * Assignments for Week of 2/10-15/14**

The "Current Event" assignment is due every Friday during the 2-3 minutes of class (students have the assignment completed prior to arriving to class); late work will not be graded. The assignment consists of: 1) Go online and locate a current article about some type current technology. 2) Print the entire article out on white paper. Do not do Step #2. 3) Read the article you have selected for comprehension. 4) On a sheet of notebook paper, write a summary of the article that is legible and at minimum of 1/2 one side of a sheet of 8.5 x 11 paper (fold in half to see if you have enough written). 5) Staple your summary to the print-out of the article and make sure your name is on the assignment. 6) Place on Mr. German's desk during the 2-3 minutes of class every Friday. 1. Current Event 2. Practice and Study How to Use the SUMifs and CountIf Functions [] 3. Practice and Study How to Use Statistical functions [] Be sure you understand how to set up the formulas from 2 and 3 above. 4. Assigment **Due Friday: Study these examples of the cubist style.**[] [] 5. Open Paint and create your own fractured landscape. Use color and shape in the cubist style. Title your work "Fractured Landscape" and save it in your 3rd Nine Week Folder. 5. Excel Project: Postponed until further notice.
 * Current Event Article Directions Due Every Friday **
 * Assignments for Week of 2/3-7/14**
 * Study these examples of a fracture landscape.**

If you did not receive credit for an Excel Assignment, check to see that you have formulas in the workbook that calculated your answers. You can't just type in the correct answer. Make corrections and save in your folder.

1. Open the following link. [] 2. Click on **Basic.** Read, these sections [Format Cells, Keyboard Shortcuts, Print, and share]. 3. Practice the skills in #2 above on in a Excel Document you will create Titled **"Practice."** This is the preparation for the project below **Due Monday 2/3/14**. DO THIS FIRST! Here is the Assignment for the Project **Due Monday 2/3/14**. There are 10 parts to this assignment. Be sure to do all 10 parts. Here is the Workbook you wil need to copy to your folder. 4. Current Event Articles for week fo 1/26-31/14. **Due Friday.**
 * Assignments for Week of 1/26_31/14**

Attention Class On this assignment Here is the correct question you need to answer: Total sales = Income Payroll = $15,000.00 Did the Company make payroll?
 * Assignment for Friday 1/25/14 [[file:Range_ Formula Payroll.pdf]]****Due Monday 1/27/14**
 * Current Event for Week** of 1/21/-25/14 [[file:Article for Current Event Due Friday 1.pdf]]

1. Use data in this document. 2. Open and Build the worksheet in Excel and title it **5 Day Sales Project Formulas**. 3. Use several formulas to calculate the values asked for in each cell. (You may need to go back to the Formulas Study Module to Review.) 4. Extra Credit: Use color to descriminate the sales for each person or each day and their totals (you choose.) 5. Save 5 Day Sales Preoject Formulas in Excel Projects folder. **Due by the end of class Thursday 1/23/14.**
 * Assignment for Wednesday 1/22/14**


 * Assignment for Tuesday 1/21/14**

1. In your 3rd 9 weeks folder, create a new folder titled **Excel Projects**.

2. **Read and study Range, Function and Formula examples** []

Then, Open an Excel worksheet and create 3 columns of numerical data 4 rows deep.

In the 4th column, create a formula that adds the values of the first three columns.

Save your worksheet in the Excel folder and title it **Range_Formulas and Functions**. **Due 1/21/14**.

3. Begin working on your current event **Due Friday**.

1. Current Event (
 * Current Event articles for Due 1/17/14**
 * Assignments for Week of 1/6-17/14**

2.

_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
 * 1st Nine Weeks Link**

2nd Nine Weeks Link

Here is the Study Guide for the Semester Exam in case you were absent on Tuesday.

How to Print Screen