2. EXCEL FINAL EXAM REVIEW (Complete on your own)Feel free to use your neighbor for help. (If you do not know an answer, 1. look it up, 2. use the hellp button, 3. ask a neighbor, 4. ask me)

3. Study excel by taking the EXCEL self check quizzes.
Lesson 1   Lesson 2   Lesson 3   Lesson 4   Lesson 5

The Word review needs to be 100% complete & submitted by Final exam day.

1. Open Access & create a blank database.
2. Name it final-your name
3. Go to the design view & remove the primary key.
4. Add at least 10 fields & adjust the field types as needed.
   1. One of your fields should be an attachment.
   2. ALL records should have an attachment.
5. Add at least 10 records each with an attachment
6. Add a field that has the hyperlink field type. Hyperlink a few of your items
7. Sort your list from A to Z
8. Freeze the most important column
9. Save and submit your project in EDMODO

BEGIN WORD FINAL EXAM REVIEW – CLICK FOR WORD-FINAL REVIEW

ACCESS FINAL PROJECT

1. Open Access & create a blank database.
2. Name it final-your name
3. Go to the design view & remove the primary key. (right click on the key & delete)
4. Choose a topic to create a database about. (Books you own, Clothes, Shoes, Baseball cards, etc)
5. Add at least 10 fields & adjust the field types as needed.
   1. One of your fields should be an attachment.
   2. ALL records should have an attachment.
6. Add at least 10 records each with an attachment
7. Save and submit your project in EDMODO

 Study excel by taking the EXCEL self check quizzes.
Lesson 1   Lesson 2   Lesson 3   Lesson 4   Lesson 5

Complete the PPT Self Check Quizzes below.

U4L1 Quiz U4L2 Quiz U4L3 Quiz U4L4 Quiz
Interactive Reviews – Lesson 4   Lesson 3  Lesson 2

 PPT TEST TOMORROW.

Monday: Finish game & test
Tuesday: With a partner, play each persons game.
When you finish complete the self checks for ppt. (they are linked on yesterday)

Next Project: Using templates, create a game in PowerPoint.
Click here for the terms, & the game templates.

You may work on on your typing skills or you may create another animation in PowerPoint

CA3.5

1. Finish Holiday Slide Master with a simple animated greeting.
2. Choose a topic to research & create a “How To” slide show.
3. Click to see REQUIREMENTS
4. Create your CUSTOM slide master for your how to. It should have graphics that go along with the theme. Be sure you can read your text.

Review Skills from yesterday & learn how to use the Slide Master. CLICK FOR SLIDE MASTER ASSIGNMENT
Create an animated Birthday greeting card with a custom Design using the slide master. CLICK FOR HOLIDAY ASSIGNMENT

4. After you have created Ms. Orange, try to create your own avatar in PowerPoint.

 Click to see an example

1. Open your Animation Practice. Finish the pinball machine & chimney slide.
2.Create a cartoon.
- no CLICKS (with or after previous)
- Inlcudes entance, emphasis, motion path, & exit effects.
- Is an advanced animation.
- Min of 10 Effects

(Winter Challenge)Try to create an animation where a tree shakes and then all of the ornaments fall off.

NO GAMES. If you are finished you may play Computer Apps review games or read through the Bagpiper online

3.CREATE A CALENDAR:
1. Open Excel
2. Go to Office Button >New> Choose Calendar 
3. download preferred template (If this does not work for you, then go to http://office.microsoft.com & choose templates, all templates, calendars, 2012 calendars)
4. Plan for the month of May
5. Add in holidays, practices, events, and appointments.
6. Add interesting facts and place them on different days
7. Add images.

FOR TOMORROW:
5.Complete  Unit 2 Lesson4 Self Check quiz & interactive review
6. Using templates in excel. Find a calendar template that you like.

7. CREATE A CALENDAR IN EXCEL USING TEMPLATES:
1. Open Excel
2. Go to Office Button >New> Choose Calendar 
3. download preferred template
4. Plan for the month of December  
5. Add in holidays.
6. Add Holiday facts and place them on different days
7. Add images.
8. Add in holiday plans
9. Print your Calender
10. We are turning this calendar into an advent calendar

For tomorrow:  Autotrader Assignment PMT, IF, autofilter, hyperlinks
Click for Data File

1. Take the IF Filter Practice Quiz
2. Begin PROM Wish List (Review Assignment of all skills learned thus far in Excel)

TODAY:  Movie Madness – Learn IF Function & Filtering

Fast Food Charts Assignment
TODAY: Work on Fast Food Assignment Part 2.
Goals:
*Go online & find a healthier meal.
*Create a chart that compares your two meals.
*Add pictures to the columns in each chart.

TODAY: CHARTS & FORMATTING IN EXCEL
Fast Food Charts Assignment

3. Finish Hollister Assignment. Check diagram at the bottom of the instructions  to be sure you have included everything.
This Week - TEST OVER EXCEL ( functions, cells,columns, rows, worksheets, workbook, screen parts, fill handle)

Lesson 1 self check quiz

Lesson 2 Self Check Quiz

1.Finish & Submit Excel Label Screen Parts
2.Learn to enter & align data in Excel – CLICK FOR AMERICAN TOP 40
1. Get back with your partner from the Lemonade stand game.
2. Open your Lemonade sheet. If you did not get to complete the lemonade game, open the blank data sheet to work with.
3.Format your sheet using borders & fill colors.
4. Use wrap text on row 4
5. Adjust the column & row width to better fit the data.
6. Learn to delete unused rows. (right click on row header)
7. Learn to create charts of the data (Insert >chart)
8. Learn to create charts that will let you compare several columns of data.
9. Format your charts with colors & titles
10. Using your charts, analyze your data. Why did you make more money on some days than others?
11. Check that you have turned in ALL excel files. (Screen Parts, Top 40, Lemonade)
12.Play for 15 more days & report back your net profit or loss.

1. Get with  your partner. Each partner will be working on a computer.
2. One partner will be entering data while the other partner will play the game. You may rotate jobs as frequently as you would like.

lemonade stand game (Click to play the lemonade stand game. Be sure to report your info to your partner)

Data Sheet (Open and save this file. One partner should fill this form out while you play)

1. Introduction to Excel. Label the parts of the screen.
Click for cheat Sheet
2. Complete the following activity to familiarize yourself with terms used in excel

• Take MLA Lesson 4 Test.
• Finish & turn in Cyberbully Paper. http://www.turnitin.com (Must have less than 5% to receive credit)
• Finish Review assignment from yesterday. (Definitions)
• If you have turned in your cyberbully paper, play the lemonade stand game. We will be using this game in an assignment tomorrow.

BELLWORK: ONE person in the pair should go to http://turnitin.com and turn your paper in. It MUST BE UNDER 5% PLAGAIRISM. 

1. Proofread your paper, highlight ex in pink, highlight (parenthetical notations) in yellow, Check MLA formatting. ONE person submit in Turn it in. I will not grade for 2 weeks. You can keep submitting the paper until you get it under 5% plagairism.
2. TODAY – L4 TEST REVIEW
   Do You Know: Word Count, View Buttons, Next Pg Buttons, Page Break(ctrl+enter), Split Window(View>window>split), endnote, footnote, parenthetical notation, heading, header, MLA spacing, insert pg #, Reveal formatting(shift+F1), next pg buttons, hanging indent, ctrl home, & navigation buttons. 
3.  Add the definitions  to the terms above. Place them in an MLA style report(pg110 for help). You may email this to yourself to study for the test. You may put the definitions in a bulleted list. 
4. Lesson 4 Interactive Review
   Lesson 4 Self Check Quiz
5. Take Lesson 4 Open Book Quiz (Test on FRIDAY)       

1. Open your research paper.
2. Highlight in pink each example
3. Highlight in yellow your parenthetical notations
4. DS & add hangin indents to your works cited page.
5. Spell check your paper. Submit a copy of your Paper in Edmodo to receive a formatting grade.
6.  Check your peer edit and fix any mistakes.

REMINDERS:
1. Be sure to include real examples in every paragraph
2. Remember to avoid using “I, you, & things” (Use the Find feature in Word to check to see if you have used these words)
Cite all sources using parenthetical notations (Last Name)
3. Transistion from one paragraph to the next so that your paper flows.
Paragraph 2 – What is cyberbullying.
Paragraph 3-Consequences/problems with Cyberbullying (List at least 3)
Paragraph 4- Ways to prevent cyberbullying (List at least 3)
Paragraph 5- Conclusion (reiterate your main points from each topic)

For tomorrow: Work on LESSON 4 REVIEW unless you have not turned in your research in Moodle, read your peer edit in turnitin.com, fixed mistakes on your paper, and resubmitted in the cyberbully final draft section.

• L4 TEST REVIEW
  Add the definitions  to the terms BELOW. Place them in an MLA style report(pg110 for help). You may email this to yourself to study for the test. You may put the definitions in a bulleted list
• Do You Know: Word Count, View Buttons, Next Pg Buttons, Page Break(ctrl+enter), Split Window(View>window>split), endnote, footnote, parenthetical notation, heading, header, MLA spacing, insert pg #, Reveal formatting(shift+F1), next pg buttons, hanging indent, ctrl home, & navigation buttons. 
•  CYBERBULLY PAPER CHECKLIST

Open Cyberbully Paper Directions

1. Proofread your paper. (Spell check, Each paragraph should have an introductory sentence & concluding sentence) Your paper should flow from one topic to the next.
2. Highlight in pink the three real examples you included in paragraphs 2,3, & 4
3. Highlight in yellow every instance of a parenthetical notation.(Last name)
4. Both parnters, copy your paper to the works cited page you created. Insert parenthetical notations. Format in MLA style. Submit in Edmodo to receive a grade for formatting.
5. ONLY ONE PARTNER should Submit your paper in turnitin http://www.turnitin.com
   class id=4931194  Password= capps
6. Paper needs to be under 5% to receive credit

REMINDERS:
1. Be sure to include real examples in every paragraph
2. Remember to avoid using “I, you, & things” (Use the Find feature in Word to check to see if you have used these words)
Cite all sources using parenthetical notations (Last Name)
3. Transistion from one paragraph to the next so that your paper flows.
Paragraph 3-Consequences/problems with Cyberbullying
Paragraph 4- Ways to prevent cyberbullying
Paragraph 5- Conclusion (reiterate your main points from each topic)

CA1.3

Remember to avoid using “I, you, & things” (Use the Find feature in Word to check to see if you have used these words)
Cite all sources using parenthetical notations (Last Name PG number)
Include a real example in paragraphs 2,3, & 4
Transistion from one paragraph to the next so that your paper flows.

1. Cyberbully Paper Directions
2. TODAY: Set up MLA format & Type paragraph 1(intro), 2(What is Cyberbullying?), 3 (problems).Type in your titanpad. (Go to your edmodo group to get the link & password to your titanpad.
3. Be sure to include real examples in every paragraph.
4. Include a transition sentence.
5. Finish adding sources to your works cited.

1.Learn about Citations
2. Open Research Sheet. You need 10 sources. Be sure to paste the URL and list 3 pieces of information for each. Three sources should be for paragraph 2 (What is Cyberbullying?), 3 for paragraph 3(Problems with Cyberbullying), and 3 for paragraph 4 (Solutions to Cyberbullying, and one that is a case study. Be sure to communicate with your partner on your group page in Edmodo.
3. Finish making your works cited page. Be sure to DS and add hanging indents. Submit in Edmodo

MLA report:
1st Paragraph: Introduction
2nd Paragraph: What is Cyberbullying (include a real example & technologies used to bully)
3rd Paragraph: Consequences (of the bully & the victim. include a real example)
4th Paragraph: Prevention Methods (solutions to prevent cyberbullying. Include a real example)
5th paragraph: Conclusion

CA3.2.1

1. Click here to for MLA assignment

1. Find 10 different Sources fill in information on this sheet. Attach the sheet to your group page after each person has 5 sources.
2. Research Paper Instructions
3. MLA report:
   1st Paragraph: Introduction
   2nd Paragraph: What is Cyberbullying (include a real example)
   3rd Paragraph: Consequences (with real example)
   4th Paragraph: Prevention Methods (with real example)
   5th paragraph: Conclusion

Look up resources for cyberbullying when you finish your test. Researching-Cyberbullying

Paste the URL into the sheet attached above.

4. Practice – Self-Check Quiz
5. Take the lesson 5 open book quiz

 TEST TOMORROW OVER L5

1. Review concepts from lesson 5.
   Complete the interactive review
   Complete the self-check Quiz

1. TURN IN SHAPES & MAP
2. Dude Ranch Brochure: Click for a video demonstration (Watch this video for assignment instructions)Click for Written directions
   Click for dude ranch data file 
3. Learn how to create a newsletter on a topic of your choice. Click here for directions

For tomorrow:  Create a Travel Brochure.  Click for Brochure Directions

4. Create a Newsletter on a topic of your choice. Click for directions.
5. Pick a destination you would like to travel to. Research this place. Find out what activities are available. We will be creating a travel brochure tomorrow.

SHAPES
1. Finish Shapes assignment from yesterday & Submit in Moodle.
2. Create a Map or blueprint of a place of your choice using shapes. Be sure to include textures or pictures within your shapes.

1. Learn how to use Shapes in Word.
2. Shape Challenge.
1. Create scenery using shapes. Try to make a snowy background with a person skiing down the hill & snow flakes falling

Lesson 3 Application portion of the test. 
Multiple Choice Test tomorrow – Click here for L3 study guide

1. Take Lesson 3 Quiz – You may use your notes, book, and the internet to help you with this quiz
2. Experiment with shapes. Draw a scene from a movie using Shapes in Word. (Insert>illustrations> shapes)

2. Insert a term, definition, image example, and hyperlink on our L3Terms page in Edmodo.

2.

3. Find an image online that represents you. Create a letter head for you. You may use photoshop.

4. Insert a term in edmodo on the wall of the Lesson 3 Terms group. Do not choose a term that has already been chosen. (f5 refreshes the page)

4. Find an image online that represents you. Create a letter head for you. You may use photoshop.

BELLWORK: Complete Self Check Quiz – Take until you get a perfect score.
TODAY:

1. Take Formatting in Word Test
2. Click to complete the NIELSEN RATINGS Assignment. (skills: quick parts, thesaurus, symbols, shading, & bullets,)

 As a class -Review format painter, indents, & bullets

1. REMINDER: Test WEDNESDAY over formatting in word (bullets, indents, tab stops, highlighting, shading, format painter, bold, strikethrough, all caps, font color, etc…)
2. ASSIGNMENT: Create a letterhead & Letter for the Highlander Outfitters. CLICK FOR DIRECTIONS
3. Complete Study Guide for Formatting Test

1. ASSIGNMENT: Click for cell phone assignment directions

• Open your Itunes file. Learn Tab Stops & Character formatting.
  • ASSIGNMENT:  Click for Character formatting assignment
• QUIZ TODAY OVER TAB STOPS & CHARACTER FORMATTING
• Create a birthday reminder sheet.
• List all 12 months in the first column,
• the names in the second column
• the exact birth date in the third column.
•  To receive credit, you must use tab stops.
• Apply character formatting to improve the appearance of your page.
• Use each of the following: Shadow, small caps, bold, font, font color. You may use more if you would like.

BELLWORK: Finish up Itunes file

1. On your Own: Hit Ctrl + enter to go to page 2. List the 7 classes you are taking and hit tab between each class ONCE. Hit enter and add an assignment for each class. Use tab stops to line up the class with the assignment.
2. ASSIGNMENT: Daily Agenda with Tabs. Click for assignment
3. SUBMIT IN EDMODO