QT2

=Computer Applications II - Daily Assignments - QT2 - 2nd Marking Period=

Finish MidTerm Parts I and II
 * Monday 1/25/10

Friday 1/22/10** Part II: 25 Multiple Choice Questions media type="custom" key="5209349"
 * MidTerm Exam

Thursday 1/21/10** Part I: Word/Excel Project Tables & Graphs Created within a Word Processing Document Filename: AIM.doc __//You must do this silently and individually.//__ Follow the directions on pages 28 - 38 in the back of your red notebook. If you would like to make the spreadsheet portion in Excel and copy and paste special into Word you may. ** **Include the usual header and footer. Save to the desktop and upload to your Gaggle digital locker. Print!!!**
 * MidTerm Exam

Wednesday 1/20/10 Finish **Checkbook.xls Make it better by:** - shading alternate rows - displaying gridlines - making it landscape - including more lines in the print area - making fit on one page - including filename, your name, and page numbers in header and footer Print it.** Save it to your desktop. Upload to your gaggle digitial locker.
 * Make sure it looks REALLY GOOD.
 * FINISH OTHER BACK WORK.**

Setting Up a Checkbook Directions in back of red notebook.
 * Tuesday 1/19/10**
 * Filename: Checkbook.xls**

**Friday 1/15/10** Continue with GradeSheet.xls Self-evalute your work and enter it into the GradeSheet.
 * Print your GradeSheet.xls** so I can write your actual grades on it for you to type in next time.
 * MAKE UP DAY --- FINISH BACK WORK. **

Continue with GradeSheet.xls Self-evalute your work and enter it into the GradeSheet.
 * Thursday 1/14/10**

Create **GradeSheet.xls** Self-evaluate the work you have in your Gaggle digital locker and put your best estimate of your grade in your spreadsheet.
 * Tuesday & Wednesday 1/12, 13/10**

Watch photostory projects.
 * Monday 1/11/10**

__Due today! These need to be in your Gaggle digital locker.__** PhotoData.xls Title.jpg WorksCited.jpg VisitYourName.wp3 VisitYourName.wmv - 15 photos - captions on some (change font properties and placement for readability and look) - movement that enhances on some (customize motion for positive effect) - transitions between some - music - title page - works cited with web addresses - your name on the title page or works cited page
 * Friday 1/8/10
 * Your photostory includes:**


 * Wednesday & Thursday 1/6, 7/10**

__** Assignment: **__ Use Customize Motion to put motion or transitions in your Photo Story document. Adjust text location and font properties to make it easier to read. See demonstration by Miss Hangen


 * Monday & Tuesday 1/4,5/10

__ Assignment: __** Continue working on your **VisitYourName.wp3** Photo Story project.

Make sure you have **PhotoData.xls**, all your photos, **Title.jpg**, **WorksCited.jpg**, **VisitYourName.wp3** saved in your gaggle digital locker.
 * First page: Title page made in PowerPoint and saved as **Title.jpg** [[image:happy-new-year.jpg width="250" height="185" align="right" caption="What's your resolution?"]]
 * 15 photos with meaningful captions
 * Last page: Works cited with web addresses of where you found the photos and information, made in PowerPoint and saved as **WorksCited.jpg**
 * Background music
 * Transitions

When you are completely finished, follow the directions on the last page in the red notebook to save you story for playback as **VisitYourName.wmv

Share with the class. !!!! **


 * [[image:http://1.bp.blogspot.com/_LPzytfPH1JU/SwRr9EZGVzI/AAAAAAAAABQ/zymKZSDHngI/s1600/christmas_comment_graphic_08.gif]]

Monday - Wednesday 12/21-23/09**

__** Assignment: **__ Continue working on your **VisitYourName.wp3** Photo Story project.

Make sure you have **PhotoData.xls**, all your photos, **Title.jpg**, **WorksCited.jpg**, **VisitYourName.wp3** saved in your gaggle digital locker.
 * First page: Title page made in PowerPoint and saved as **Title.jpg**
 * 15 photos with meaningful captions
 * Last page: Works cited with web addresses of where you found the photos and information, made in PowerPoint and saved as **WorksCited.jpg**
 * Background music
 * Transitions

__ Assignment: __** For your title, create a slide in Powerpoint and save it as **Title.JPG**. Use this as your first photo for your PhotoStory document. Filename: **VisitYourName.wp3** At this time, create your Photo Story document so it contains:  Save to the desktop and upload to your Gaggle digital locker. Make sure you have all your photos in your locker. Perhaps you would like to make a separate folder just for the project that contains the photo files, your title slide, PhotoData.xls, and your Visit.wp3 project file.
 * Friday 18, 2009
 * A title slide
 * Photos of the place you would like to visit
 * Captions
 * Transitions

__ Assignment: __** Photo Story Tutorial with Sample Pictures Filename: **Sample.wp3** Directions are in your notebook.
 * Thursday 17, 2009

__ Assignment: __** Objective: Create a digital picture story about a country or place you would like to visit. Filename: **PhotoData.xls**Example: Change the format of the web address column and the notes column to alignment wrap text.
 * Monday - Wednesday 14-16, 2009
 * You need at least 15 pictures and information by the end of the day today (Wed). **


 * 1) Make a spreadsheet file where you will save information about the pictures.
 * 2) Search online for photos from a country or place you would like to visit.
 * 3) Save each of the photos to your desktop with a descriptive name.
 * 4) In the spreadsheet include the URL where you found the photo to use in the works cited.
 * 5) In the spreadsheet include notes to help you produce captions and narration.
 * 6) In the spreadsheet include the descriptive filename you gave so you can find it easily.
 * 7) Save the Excel file to your desktop.
 * 8) Upload the PhotoData.xls and your photos to your Gaggle digital locker.

__ Assignment: __ Read:** Yellow pages in your red notebook. Finish back work.
 * Thursday & Friday December 10,11 2009
 * Spreadsheet:** Crickets.xls
 * Word Document**: Analysis.doc

@http://computingcareers.acm.org/ Why choose computer science as a career?
 * Wednesday December 9, 2009**
 * Computer Science Education Week -- The first one ever!!!! **

__ **Assignment:** __ Filenames: **WetlandsGraph.xls and WetlandsReport.doc** Follow the directions in the red notebook very closely.
 * Finish and PRINT**

**__Do Now:__** media type="custom" key="4981437"
 * Monday & Tuesday December 7,8, 2009**

Filenames: **WetlandsGraph.xls and WetlandsReport.doc** Follow the directions in the red notebook very closely.
 * __Assignment:__**

__ Assignment: __ ** Filenames: **Basics.xls and Basics.doc** Follow the directions in the red notebook very closely.
 * Thursday & Friday December 3,4 2009

__ Assignment: __ Read:** Reviews and Inspections of Spreadsheets
 * Wednesday December 2, 2009
 * Read:** A Checklist for Us in Reviewing or Inspecting Spreadsheets
 * Write** an explanation of what you learned.

__ Assignment: __ Read:** Computer Buying Guide - Laptop vs Desktop
 * Tuesday December 1, 2009
 * Write** an explanation of which computer would be best for you now and why. Support it with details from the article.
 * Write** an explanation of which computer would be best for you in 5 years and why. Support it with details from the article.

__** Assignment: **__ Have an Excel file open to try things while you are doing the quiz. Repeat until you get a good grade. @http://www.quia.com/rr/35568.html //**Show me how you did.**// @http://www.writefix.com/ICDL/excelcross2.html
 * Wednesday November 25, 2009[[image:Turkey.PNG width="216" height="194" align="right" caption="Creative Commons"]]**
 * 1.** Do the online quiz. @http://www.quia.com/quiz/268964.html
 * //Show me your last grade.//**
 * 2.** Become an Excel Millionaire by doing this online quiz.
 * 3.** Click a block of the crossword puzzle to get the clue.
 * //Show me when you are done.//**

__**Do Now:**__ @http://library.thinkquest.org/J0110054/quiz/vocab_quizw.htm @http://www.catawba.k12.nc.us/pages/sites/edwebsites/computerskills/quizzes/ssterms.htm @http://www.catawba.k12.nc.us/pages/sites/edwebsites/computerskills/quizzes/spreadsheetmatching.htm
 * Tuesday November 24, 2009**

LineGraph.xls and LineGraph.doc Follow directions on new handout. Make sure you have a header and footer. Have Miss Hangen give you approval to print.
 * __Assignment:__**

__**Do Now:**__ How do you change the scale of the y-axis in a graph in Excel? I suggest doing and writing down the steps as you go. LineGraph.xls and LineGraph.doc Follow directions on new handout. LineGraph will be done completely on your own.
 * Monday November 23, 2009**
 * __ Assignment: __**

Finish CreateTable.doc LineGraph.xls and LineGraph.doc Follow directions on new handout. LineGraph will be done completely on your own.
 * Friday November 20, 2009**

//Objectives: Analyze data from a bar graph. Scale the y-axis.//** CreateTable.xls and CreateTable.doc
 * Thursday November 19, 2009

Finish FECtables.xls and FECtables.doc Follow the directions from the Create Tables from Graphs handout.
 * Monday, Tuesday, Wednesday November 16, 17, 18 2009**

__**Do Now:**__ media type="custom" key="4793485"
 * Thursday and Friday November 12, 13, 2009**

__Assignment:__ **

1. Save an Excel spreadsheet to the desktop with the filename **FECtables.xls** 2. Save a Word document to the desktop with the filename **FECtables.doc** 3. Put your standard **header and footer** in the Word document.
 * 4. Create the tables from the last page in your red notebook in the Excel spreadsheet**.

5. Copy and Paste (**regular paste**) to the Word document. 6. Upload both FECtables.xls and FEC
 * Make them look as much like the original as possible.
 * **Where there are supposed to be totals use formulas to calculate them.**
 * Remember you can use the AutoFill feature to save time.





Finish back work.
 * Tuesday and Wednesday November 10,11, 2009

Thursday, Friday, Monday November 5,6, 9 2009** __**Do Now:**__
 * Create an assignment log spreadsheet. Save it with the filename Log.xls

__ Assignment: __ Project:** See details here. Use the filenames: FastFood.xls and FastFood.doc

Previous dates can be found on the QT1 page.