Computer Applications
Course Description~
Computer Applications is an introduction to the operation of Microsoft Office software, including Access, Excel, PowerPoint, and Word. This class aims to provide you with the knowledge necessary to use these applications in other classes, future employment, and in everyday life.
It counts as 5 technology credits towards the 10 that are required for graduation!
Student DocuShare ~login using student ID and computer password.
Computer Use Agreement -- must be signed by student and parent prior to working in the computer lab.
Daily Lessons~ Links to assignments listed below calendar.
November
DATE |
Week 12 |
M. 11/16/09
|
Period 5 Finish Practice Test Make corrections to practice test. Have me initial your first copy. DO NOT PRINT 2ND COPY! Make-up Work Review for Test Period 8 Practice Test Make up Work |
T. 11/17/09
|
Period 5 EXCEL TEST Period 8 Make corrections to practice test. Have me initial your first copy. DO NOT PRINT 2ND COPY! Make-up Work Review for Test |
W. 11/18/09
|
Period 5 Finish Test if needed Best Buy FILE Best Buy Instructions Period 7 Excel Test |
T. 11/19/09 |
Period 5
Period 7 Finish Test if needed |
F.11/20/09 |
Period 5 Integrating Word & Excel Together: INT A-1 QST Vancouver Survey DATA INT A-2 QST Vancouver Survey REPORT Assignment: INT A-13 Gardens Galore Sales DATA INT A-14 Gardens Galore Sales REPORT
Period 7 Finish Test if needed Best Buy FILE Best Buy Instructions |
DATE |
Week 11 |
M. 11/9/09
|
Money Smart Graphs --Monthly cost of children - file |
T. 11/10/09
|
Sorting Golf Rankings spreadsheet Golf Rankings answer sheet |
W. 11/11/09
|
Conditional Formatting Assignment: Lovely Locks page Excel 73 FILE |
T. 11/12/09 |
21 minute class period Look back on the week and see what you've missed! |
F.11/13/09 |
PERIOD 5 Bell Ringer: 1. Explain the steps to sorting 2. Explain the steps to put a > conditional formatting on some data Turn in Bell Ringers from Excel Practice Test FILE
PERIOD 8 Bell Ringer: 1. Explain the steps to sorting 2. Explain the steps to put a > conditional formatting on some data Turn in Bell Ringers from Excel Lovely Locks page Excel 73 FILE |
Start of Second Quarter
DATE |
Week 10 |
M. 11/2/09
|
WORK DAY! Finish: Ind. Chall.#1 Estimated Diner Expenses pg. 46 EX B-3 Ind. Chall.#2 Pamper Yourself Finances pg. 47 EX B-4 Ind. Chall.#3 Sales Tax Calculations-- start new spreadsheet Visual Workshop pg. 50 -- start new spreadsheet -- Sales Analysis |
T. 11/3/09
|
Together: M&M's activity Class Lists:
|
W. 11/4/09
|
Bell Ringer: 1. Explain the steps to rename a worksheet tab. 2. How do you change the color of a worksheet tab? 3. What keyboard shortcut makes a cell reference "absolute"? Graph M&M's activity together If absent yesterday, use these file and enter the formulas
|
T. 11/5/09 |
Bell Ringer: 1. Explain the steps in creating a graph 2. How do you change the color of the graph pieces (ie. pie piece)? Gas Prices - graphs (printed copy from me) |
F.11/6/09 |
Questionairre - Instructions
Finish Formula & Graph practice if needed Extra Credit: Gas Prices
|
Money Smart Graphs Sorting Conditional Formatting |
October
DATE |
Week 9 |
M. 10/19/09
|
Together: Finish missing work |
T. 10/20/09
|
Start New Bell Ringer How do you start a function for: 1. Totals 2. Averages 3. Most 4. Least Save as: Excel Bellringers Name Finish Beatles Spreadsheet Finish missing work |
W. 10/21/09
|
Bell Ringer: List two ways to enter functions (like =SUM, =MAX, etc.) Finish Beatles Spreadsheet if needed New: North Star Enterprise...SAVE IT AS THAT (not what is printed on the sheet) |
T. 10/22/09 |
Review: Formulas & Functions (Unit B) Together: Tour Revenue Analysis EX B-1 pg. 26-40 Absolute Cell Reference - open your Beatles Spreadsheet Ind. Chall.#1 Estimated Diner Expenses pg. 46 EX B-3 Ind. Chall.#2 Pamper Yourself Finances pg. 47 EX B-4 Ind. Chall.#3 Sales Tax Calculations-- start new spreadsheet Visual Workshop pg. 50 -- start new spreadsheet -- Sales Analysis |
F.10/23/09 |
Bell Ringer: 1. How do you make a cell 'absolute'? 2. What is the keyboard shortcut to do that? 3. What are the steps to "scale to fit"? WORK DAY! Finish: Ind. Chall.#1 Estimated Diner Expenses pg. 46 EX B-3 Ind. Chall.#2 Pamper Yourself Finances pg. 47 EX B-4 Ind. Chall.#3 Sales Tax Calculations-- start new spreadsheet Visual Workshop pg. 50 -- start new spreadsheet -- Sales Analysis END OF QUARTER! HAPPY FALL BREAK! |
DATE |
Week 9 |
M. 10/12/09
|
Start Excel together Unit A |
T. 10/13/09
|
Excel Pages 18- 19 (green section of the book) Do problems 1-21 AND #1 of the skills review on a Word Document Independent Challenge #2 Hot Cars Sales -- you create from scratch Real Life Challenge -- do through the Adv. Chall.! READ EX A-4 Visual Workshop EX A-5 |
W. 10/14/09
|
Internet Safety |
T. 10/15/09 |
Finish Internet Safety Review - work on what you didn't finish Tuesday.
|
F.10/16/09 |
DO WORK FROM TUESDAY!!!! |
October
DATE |
Week 8 |
M. 10/5/09
|
Practice Test |
T. 10/6/09
|
Additional Practice - if needed Work Day |
W. 10/7/09
|
WORD TEST Crazy Laws FILE |
T. 10/1/09 |
Finish Test if needed |
F.10/8/09 |
Finish Template assignment Finish Make-up work 8th Period -- sit in YOUR seats, no cube field & don't make me call home on Monday! |
September
DATE |
Week 7 |
M. 9/28/09
|
Finish Assignment: Franklin EDA Report (page 69-71) use this file WD C-2 Nina's Trackside (page 76) use this file WD C-6 |
T. 9/29/09
|
Together: Footprints (page 78-94) use this file WD D-1 *New: columns, breaks, & text wrapping photos |
W. 9/30/09
|
Assignment: Gardner's Corner - Word page 104 - WD D-7 |
T. 10/1/09 |
Practice Text Wrapping - Camping Tips Personal Newsletter Instructions |
F.10/2/09 |
Finish Personal Newletter
|
DATE |
Week 6 |
M. 9/21/09
|
Bell Ringer: 1. Name 3 of the 4 ways to cut, copy & paste Review tabs, line spacing New: Tables Assignment: Chuck Norris file Chuck Norris directions |
T. 9/22/09
|
Bell Ringer: 1. Explain how to create a table 2. How do you merge cells? Review tables Assignment: Survey Chart |
W. 9/23/09
|
Bell Ringer: 1. How do you apply a style to a table? 2. How do you change the cell alignment in a table? Together -- Indents Bullets and Numbering practice Assignment: 12 Days of Christmas - file 12 Days of Christmas - instructions |
T. 9/24/09 |
Bell Ringer: 1. What are the 4 types of indents? 2. What are two ways to change indents? Together: Last Minute Deals (page 50-66) use this file WD C-1 *Review of concepts *New: drop cap, paragraph spacing, footnotes & endnotes Turn in... |
F. 9/25/09 |
Bell Ringer: 1. How do you change the space before and/or space after a paragraph? 2. Where do you insert a footnote? 3. How do you set an endnote? TURN IN WORD BELLRINGERS TO DOCUSHARE TODAY Assignment: Franklin EDA Report (page 69-71) use this file WD C-2 Nina's Trackside (page 76) use this file WD C-6 |
DATE |
Week 5 |
M. 9/14/09
|
Intro to Word Screen Parts Character Formatting |
T. 9/15/09
|
Bell Ringer - New Document Finish 20 Questions Sample of completed problem |
W. 9/16/09
|
Bell Ringer New: Format Painter Together: Lyrics Challenge |
T. 9/17/09 |
Bell Ringer Review: Format Painter, text formatting New: Tabs, Leaders Do: Lyrics Tabs |
F. 9/18/09 |
Bell Ringer
Review: setting tabs New: Cut & Paste, Line Spacing Open: Cut and Paste practice Assign: Songs Cut & Paste Finish & turn in if you haven't:
|
DATE |
Week 4 |
M. 9/7/09
|
NO SCHOOL |
T. 9/8/09
|
Finish Music (10 - 15 min) Present Power Point |
W. 9/9/09
|
Present Power Points |
T. 9/10/09 |
Present Power Points Finish any old assignments Extra Credit - 5 slide PP on your topic. Must follow design guidelines |
F. 9/11/09 |
Sams Test - PowerPoint sam2007.course.com |
DATE |
Week 3 |
M. 8/31/09
|
Review Power Point Work Time: Worst Power Point (peer evaluation) LNS Quest Start: 10 Things to do before 82 |
T. 9/1/09
|
10 Things Rubric |
W. 9/2/09
|
Finish 10 Things - turn in to DocuShare |
T. 9/3/09 |
Music Power Point |
F. 9/4/09 |
Finish Music Power Point |
August
DATE |
Week 2 |
M. 8/24/09
|
Open CA Template from last Friday (located in your server) If absent, right click on the link and save to your folder -- template Today: Formatting in Power Point
Screen parts Saving to DocuShare Hand In folder (if time permits) |
T. 8/25/09
|
Open a blank word Document (to be used for a bell ringer) Save this FILE PPT-1B- Right click on it, Save as Quest B LAST NAME to YOUR SERVER. 1. Get book, open to Power Point section (red) and work from page 26 to the end of that Unit. SAVE with your last name! 2. If time, continue LNS power point. Other than this website, you should not need to be on the internet. |
W. 8/26/09
|
Open Quest B Finish through page Power Point pg. 40 Turn in to DocuShare Start LNS Power Point if time |
T. 8/27/09 |
Bell Ringer 1. How do you add a slide transition? 2. How do you add animations? 3. Describe the steps to add an effect to a picture or shape? Start: My Day at LNS
If needed, finish Quest B |
F. 8/28/09 |
Bell Ringer Assignment: Finish Quest B if needed Start Worst Power Point |
DATE |
Week 1 |
M. 8/17/09
|
No School |
T. 8/19/09
|
No School |
W. 8/20/09
|
Freshman Day! |
T. 8/21/09 |
1st Day of Class! Intros Seating Chart Expectations Computer Use Form Create folders If time, timed writing in MicroType |
F. 8/22/09 |
Create folders on eDisk DocuShare - downloading, marking as Favorite PowerPoint template |