Computer Business Applications

Computerized Business Applications (using Microsoft Office 2003)				2007-2008
Time line	Content	Skill	Activities/Assessment	Resources
August Unit 1: Computer Concepts Hardware/Software Brief history of the information revolution Unit 2: Web Features & Telecommunications Unit 3: Introduce Integrated Software	Hardware components of a computer system Software Operating System Software (Windows XP) Application Software File Management History of computer development time-line Introduction to computer system ethics and the InternetBuse of E-mail and Internet using MS Explorer and application softwareBdiscuss copyright and student Afair use@ guidelines and apply rules and principles Microsoft Office 2003	1.1 Comprehend the hardware components of a computer system. 1.3 Delineate various types with emphasis on classroom software Introduction to Windows XP. Explore windows directories. 1.4 Identify application software; explore program files in Windows; play a game of solitaire 1.5 Create personal folder on local network server ( F: drive ) 2.1 Define, access, and explore resources through the InternetBdistinguish Web addresses and how to cite sources 2.2 Access e-mail and compose and send a message Define application software Start an Office application, recognize parts, define and label, close a document and exit.	Label components of a computer system Hands-on exercises Research assignment using the Internet—Shopping on-line for a computer system Written assessment Spot check on Office application	Teacher-made activities Teacher-made Teacher-made Teacher-made activities
September Word Processing Unit *October* Word Processing unit continued . . .	Getting Started Identify word processing window New document Retrieve a document Create and save documents Open and edit documents Basic document formatting and editing Advanced document formatting and editing--resume= and cover letter Work with objects, lines, and text boxes Work with drawing tools Add special effects	Recognize the parts of the Word window 3.1.1 Key, format, and save a document 3.1.2 Open, edit, and print a document Define, use, and apply features: create, correct spelling and grammar, save, print, and close documents Define, use, and apply features: open a document, insert text, preview, insert comment, undo action, insert automatic date, and prepare an envelope Define, use, and apply features: text alignments (left, center, right, full), bold, italic, and underline text styles, change font and font size, change font color, apply symbols, bullets, and numbering Define, use, and apply features: indent text, change line and paragraph spacing, set margins, move, copy, and paste text, set tabs 3.1.3 Define, use, and apply advanced features: apply and edit a style, use template, outline, hyphenate, use Thesaurus, find and replace text Define, use, and apply features: text design, drop caps, watermarks, reverse text, letter spacing 3.2 Define, use, and apply features: copy picture from web; insert, position, and size an object; copy and delete an object; text wrap; caption; lines and lines styles; borders; shading and special effects Define, use, and apply features: create, position, and size a shape; layer, group, ungroup, copy, and change direction of an object	Label the parts of the Word window Complete hands-on exercise Hands-on skills assessment Complete skills and hands-on exercises Complete skills and hands-on exercises Job search activity--resume= and cover letter Written assessment Complete skills and hands-on exercises Written assessment ASpooky Scene@ Project	Teacher-made activity Computer Applications for the New Millennium textbook, Southwestern Publisher, 2002 Textbook assessment software Textbook Textbook Teacher-made Teacher-made Textbook Teacher-made Teacher-made
November Word Processing Unit concluded Multimedia Presentations Unit December Conclude Presentation Unit	Work with multiple-page and multiple documents Research paper formatting Work with columns and tables Introduce PowerPoint Basics Reinforcement features in PowerPoint	Define, use, and apply features: format a two-page letter, use headers/footers, format a multiple-page report using footnotes, page numbers, window/orphan features Define and recognize MLA style reports, team-teach with English IV teacher for Senior Project paper Define, use, and apply features: newspaper-style columns, tables, column width, data alignment, row height, borders and shading, calculate, sort, and page orientation 6.1 Start PowerPoint, open existing presentation, apply a design template, change a slide layout, add a slide presentation, change views and print options. 6.2 Create new presentation, enhance	Complete skills review and hands-on exercises Written assessment Complete MLA Style Sample Research Paper Written assessment Complete skills and hands-on exercises Unit Project - Word Written unit assessment Complete skills and hands-on exercises Project Unit Project - PowerPoint Semester Exam - Comprehensive	Textbook Teacher-made Teacher-made project Teacher-made Textbook Textbook Teacher-made Teacher-made Textbook Teacher-made
January Spreadsheet Unit	Introduce Excel spreadsheet program Strengthening Worksheet skills using Excel Advanced features in Excel	4.1 Define terms related to worksheet appl., load/access Excel, and identify parts of a worksheet. 4.2 Create new spreadsheet, enter data, save, edit, print, close. Use copy, move, insert, delete, freeze titles, protect, comment, and print features. 4.2.4 Mathematical formulas, functions, and sort data	Label sample worksheet Complete skills review and hands-on exercises Complete skills review and hands-on exercises Complete skills review and hands-on exercises Unit Project - Excel	Textbook Textbook Textbook
February Database Unit March Integration Unit	Introduce Access database program Manipulating data and using forms Advanced Access Finding and Ordering data Merge feature using Access and Word	5.1 Understand databases, start Access 5.2 Create new, design, modify, name and save, print and exit. 5.2.3 Edit data, select records and fields, cut copy, and paste data, change and enhance data structure, create and use forms. 5.2.4 Use filters, sort and index a database. Create form letters and mailing labels using Access and Word	Complete skills review and hands-on exercises Complete skills review and hands-on exercises Complete skills review and hands-on exercises Unite project - Access	Textbook Textbook Textbook Textbook
April Web Page Design Unit	Introduce FrontPage Basics - Quick Start Tools of FrontPage Professionals Webtop Publishing on Superhighway	8.1 Starting a FrontPage document, adding interest, links, enhancing site Search, faster links, exploring more editing features Web Art, organized layout, window frames, informational pages, form design, animation, Java	Hands-on activities Create personal web site, test, publish, and present to class	Teacher-made Project Teacher-guided
May	Review and reinforce integrated software applications	Integrate all programs in Microsoft Office 2003 Software	Exit Project - Integrate Presentations with other Office Applications Semester Exam	Textbook Project Teacher-made