Computer Applications A - Microsoft Suite
Spring 2008

Computer Applications A is a course designed to help develop the fundamentals of MS Office 2003 using Windows XP as the operating system. We will focus on MS Word, Excel and PowerPoint. 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. This course prepares the student for the Microsoft Office Specialist basic exam. Access the Course Outline.

Next Test: Wednesday, April 16th

Date Assignments
6/4 Final - 1 Word Document, 1 Excel Spreadsheet, 1 PPT Presentation
5/30, 6/2 Finish all reviews
5/27, 5/28, 5/29 Internet Scavenger Hunt
5/22, 5/23 Excel Review - Carmen's Flowers
5/21 Excel Review - Computer Store
5/20 Excel Review - Future Company
5/19 Excel Review - Uniform Costs
5/16 Word Review - The Dash
5/14, 5/15 PPT Review - My Life - create a ppt slide show about your life - 10 slides, include transitions, pictures, and animation - make it look good.
5/13 PPT Review - Party
5/12 PPT review - Favorite Band
5/6, 5/7, 5/8, 5/9

Unit 4 Lesson 3 - PowerPoint

Topics: Clip art, bitmaps, tables, charts, slide master, header/footer, animation, slide transition

Book - Pages 556 - 591

  • Ex 1 - Meeting, Meeting revised
  • ex 2 - ann awards
  • ex 3 - ann awards table, ann awards customized, ann awards imported
  • ex 4 - club merch chart, club fin chart
  • ex 5 - org chart
  • ex 6b - club fin movie
  • ex 7 - secretary
  • ex 8 - ann awards transition
  • ga1 - newspaper
  • ga2 - landscape
  • diy 1 - wilderness
  • diy 2 - fitness
  • diy 3 - cleaning
  • diy 4 - building report
  • cys - sales charts
5/5 PPT Test
5/1, 5/2 PPT Review - School
4/28, 4/29, 4/30

Unit 4 Lesson 2 - Power Point

Topics: Design Template, Slide Layout, Color Scheme, Line Spacing, Bullet Style

Book Pages 523-547

  • ex 1 - Ann Trip, ann Trip revised
  • ex 2 - Roundup Color, Roundup Layout
  • ex 3 - Kickoff
  • ex 4 - Upcoming Trips
  • ga 1 - Carnival
  • ga 2 - Med Fair
  • diy 1 - Manufacturing
  • diy 2 - Math
  • diy 3 - Summer
  • diy 4 - work space
  • cys - save money
4/17, 4/18, 4/21 - 4/25 (STAR testing this week, use these days to finish Lesson 1)

Unit 4 - Lesson 1 - Powerpoint

Topics: overview, auto content wizard, insert, edit, modify, spell check, find/replace, format painter, indent, new slide, hyperlinks

Book Pages 478 - 519

  • ex 1 - Marketing
  • ex 2 - Member Info
  • ex 3 - Gen Org Info
  • ex 4, 5a-b - New Emp. Info
  • ex 5c - Roll Coast History
  • ex 6a - Gen Org Info
  • ex 6b - slide show 1
  • ex 7 - Roll coast History
  • ga 1- Agriculture
  • ga 2 - cycling
  • diy 1 - guest speaker
  • diy 2 - buff national river
  • diy 3 - nat. youth trip
  • diy 4 - chili
  • cys - vacation

 
4/16 Excel Test
4/14, 4/15 Excel Review - The Gift
4/4 Excel Review - Best Sports
4/3 Excel Review - Arbor Service
4/1, 4/2

Unit 2 Applications - Book Pages 296-300

Applications 1-6 - Piano
3/27, 3/28, 3/31

Excel - Unit 2, Lesson 4 - Merge/Center, split cells, add/delete rows, copy worksheets, 3-d Cell Reference, hyperlinks

Book Pages 270-293

  • ex 1 - Leasing Info
  • ex 2 - Sales Consolidation
  • ex 3 & 4 - Sales Consolidation2
  • ga 1 - Budget
  • ga 2 - Homes Sold
  • diy 1 - Itinerary
  • diy 2 - Tax Data
  • diy 3 - Grade Averages
3/20, 3/21, 3/24, 3/25, 3/26

Excel - Unit 2, Lesson 3 - Filtering, Formulas, Absolute vs. Relative Cell References, Functions, From Template, Charts & Graphics, Comments

Book Pages 226 - 267

  • ex 1 - Job Openings
  • ex 2 - Formulas
  • ex 3 - Tenant Space
  • ex 4 - Q1 Sales & Loan Comp
  • ex 5 - Bal Sheet
  • ex 6 - Sales Charts
  • ex 7a - Loan Comp2
  • ex 8 - Job Openings
  • ga1 - Exp Summ
  • ga2 - Payroll2
  • ga3 - Loan Amt
  • ga4 - Coll Budg3
  • diy 1 - Order of Ops
  • diy 2 - Sales Data2
  • diy 3 - Payroll3
  • CYS - Sales Projections

 
3/19 Excel Test - Lsn 1 and 2
3/18 Excel Review - Shopping List
3/12, 3/13, 3/14, 3/17

Excel - Unit 2, Lesson 2 - Insert/Delete Rows, Freeze Panes, Bold, Italics, Underline, Font, Font Size, Fill Color, Vert Alignment, Test Wrap, Rotate Text, Styles, Format Painter, Page Setup (Orientation, Margins, Header, Footer, Rpt Rows, Center on Page)

Book - Pages 190-222

  • ex 1 & 2 - Mall Employees
  • ex 3 - Facts & Figs
  • ex 4 & 5 - Employee Info
  • ga1 - Profit & Loss
  • ga 2 - Expense Summary
  • diy 1 - Coll Budg 2
  • diy 2 - My Sched 2
  • diy 3 - Inventory
  • diy 4 - Balance Sheet
3/6, 3/7, 3/10, 3/11

Excel - Unit 2, Lesson 1 - Managing Worksheets, Rows, Columns, Cells, Range of cells, formatting toolbar (currency, percent, comma style), number of decimal places, cut/copy/paste, spell check, find/replace, goto (F5)

Book - pages 162-187

  • ex 1 & 2 - Facts
  • ex 3 & 4 - Final Facts
  • GA 1 - Payroll
  • GA 2 - Expenses
  • diy 1 - college budget
  • diy 2 - sales data
  • diy 3 - My Schedule
  • CYS - invoice
3/5 Word Test - All
2/28, 2/29, 3/3, 3/4

Word Review

Musician Report

Accomplishments

2/26, 2/27

Unit 1 Applications - Word Review (all)

Book - pages 150-155

  • Apps 1 - Smith Letter
  • Apps 2 - Biography
  • Apps 3-5 - Operations Review
  • Apps 6 - Grilling News
2/21, 2/22, 2/25

Word - Unit 1, Lesson 4 - Tracking Changes, Reviewing Toolbar, Save as html, insert & modify date & time field

Book - pages 124-149 -

  • ex 1 - Renewal Letter
  • ex 2 - Special Offer
  • ex 3 - Quarterly Expenses
  • ga1 - Cost Overruns
  • ga 2 - Picnic
  • diy1 - Temporary
  • diy 2 - Change Order
  • diy 3 - New Menu
  • diy 4 - Customer Tips
  • cys - benefits memo
   
2/20 Test - Unit 1, Lesson 3 - rescheduled for Friday due to Assembly
2/14, 2/19 Review - Advertisement
2/6, 2/7, 2/8, 2/11, 2/12, 2/13

Word - Unit 1, Lesson 3 - highlighting, text effects, Tables (cells, rows, columns, merge/split cells), Format tables (border/shading, autoformat), Graphics (clip art, chart, org chart), Columns, Page Orientation (Portrait/Landscape), Margins, Envelopes, Labels

Book - pages 82 - 121

  • Ex 1 - 4 - Subscription Activity
  • Ex 5 - Inside Line
  • Ex 6 - Subscriber Letter
  • ga 1 - Schedule Letter
  • ga 2 - Notes & Such
  • diy 1 - Price Change
  • diy 2 - Monthly Sales
  • diy 3 - Organization
  • diy 4 - Turnover
  • CYS - Instruction Manual
2/5 Test - Unit 1, Lesson 1 and 2
2/1, 2/4 Review - Who's the Boss (Word Document)
1/24, 1/25, 1/26, 1/29, 1/30, 1/31

Word - Unit 1, Lesson 2 - Formatting, Paragraph style, Character Style, Format Painter, Alignment (Left, Right, Center, Justify), Line Spacing, Indent, Border, Shading, Tabs, Bullets, Number, Outline numbering, Character Formats, Headers/Footers (including different first page), Page Break, Page numbers

Book - Pages 42-79

  • Ex 1 - 7 - Cayman Backgrounder
  • ga 1 - Itinerary
  • ga 2 - Bid Memo
  • diy 1 - Truck Complaint
  • diy 2 - Candy Recall
  • diy 3 - Tel Con Itinerary
  • diy 4 - Drawing
  • CYS - Industrial Revolution
1/23 Complaint Letter (use MS Word template)
1/17, 1/18, 1/22

Word - Unit 1, Lesson 1 - enter/edit text, show/hide non-printing characters, save/save as, templates, placeholders, cut, copy, paste, undo, find/replace, AutoCorrect, Spelling/Grammar, Thesaurus

Book - pages 15-39

  • Ex 4 - Tanner Fax and Job Description
  • Ex 5 - 8 - Offer Letter
  • ga 1 - Intern Resume
  • ga 2 - Mayor Letter
  • diy 1 - Promotion Letter
  • diy 2 - Vacation Memo
  • diy 3 - Introduction
  • diy 4 - Cover Letter
1/15, 1/16
1/14
   

 

 

Email Me (eblanke@hartdistrict.org) Phone: 661-294-1188 ext. 510 Fax: 661-294-3828 Last Update: March 24, 2008
Click here to learn more about Computer Applications A - Microsoft Suite Click here to link to more information about Computer Apps B - Adobe CS 3 - course outline, projects and more! Click here to see course outline, assignments, etc. for Home Page Production! Click here to go to information about the Work Experience Program! Click here to see grades! Click here to go to Valencia High School Main Page! Click here to go to the Practical Arts Department Page for Valencia High School! Click here to go to Mrs. Blankenship's main page! Click here to see information about Mrs. B!