Month

Content/Topic

Skills

Assessment

Standards

January

• Section 1:  Keyboarding Review

• Demonstrate proper technique and posture.
• Demonstrate proper keying of 26 alphabet keys, 5 punctuation keys, space bar, enter, tab, caps lock, backspace, 2 shift keys, 10 number keys,16 symbol keys, and 10 key pad.
• Develop proofreading skills and use correct proofreading symbols.
• Develop speed and accuracy and show improvement.
• Identify basic computer parts and define basic computer terms.

• Microtype Lessons (speed, accuracy, improvement)
• Technique Evaluation
• Timings
• Keyboard Quiz

• Information Systems Technology:  B.4.1, B.4.2, B.4.3, B.4.4, B.4.5, B.4.6, B.4.7, B.4.8, B.8.1, B.3.2, B.8.3, B.8.5, B.8.9, B.12.3

February

• Section 2:  Microsoft Word Features

• Section 3:  Letters & Memos

• Section 4:  Reports & Outlines

• Demonstrate use of Microsoft Word toolbar including:  new, open, save, print, preview, spell check, cut, copy, paste, undo/redo, font, font size, font style, alignment, bullets, numbering, and other features.
• Demonstrate the use of Microsoft Word shortcut keys including:  control key shortcuts, home, end, page up, page down, etc.
• Demonstrate the use of the Microsoft Word drawing toolbar including:  order, rotate, group, text/object wrapping, AutoShapes, lines, arrows, line style/thickness, text box, WordArt, diagrams, clipart, picture from file, line/shape color, text color, shadows, etc.
• Apply knowledge of Microsoft Word by following a list of directions to format a document to match the instructor’s key.
• Identify basic computer parts and define basic computer terms.

• Use block and modified block styles to format business and personal letters following FBLA format guidelines.
• Use FBLA format guidelines to format standard memorandums.
• Apply formatting guidelines (memorize formats) to unformatted documents on quiz.

• Use FBLA guidelines to format an unbound report with quotations and numbered lists.
• Create a title page for a standard report.
• Create a reference page following FBLA guidelines, alphabetical order & MLA style.
• Use FBLA format guidelines to format a bound report with endnotes.
• Use FBLA format guidelines to format a bound report with footnotes.
• Demonstrate the ability to create an outline following the FBLA format guidelines.
•  

• Worksheets

• Daily Assignments

• Easter Letter Assignments

• Application Quizzes

• Written Quiz

• Information Systems Technology:  B.4.3, B.4.7, B.4.8, B.8.6

• Communications:  A.4.1, A.4.5, A.8.1, A.12.1, A.12.2
• Information Systems Technology:  B.4.3, B.4.7, B.4.8, B.8.6, B.8.9

• Communications:  A.4.1, A.8.1, A.12.1, A.12.2
• Information Systems Technology:  B.4.3, B.4.7, B.4.8, B.8.6, B.8.9

March

• Section 5:  Tabs & Tables

• Section 6:  Document Formatting Simulation

• Section 7:  Using the Internet

• Use a standard tab to create a list style table.
• Demonstrate the ability to set a left tab to format a table.
• Demonstrate the ability to set a center tab to format a table.
• Demonstrate the ability to set a right tab to format a table.
• Demonstrate the ability to set a decimal tab to format a table with various number sets.
• Demonstrate the ability to insert table in Microsoft Word & format to meet guidelines.
• Apply table formatting features—borders, shading, merge, insert, etc.

• Apply formatting skills to create a variety of documents (16) using Microsoft Word (letters, memos, mail merge, report, table, itinerary, outline)
• Use teamwork and leadership skills to work in an office setting assigning tasks to group members.

• Demonstrate the ability to use internet browsers—explorer, navigator, and firefox.
• Apply internet navigating skills in a variety of browsers—back, forward, home, refresh, stop, favorites, history, and other skills.
• Define basic internet terminology.
• Demonstrate the ability to use a variety of search engines—google, msn, yahoo, lycos, megacrawler, dogpile, etc.
• Demonstrate ability use various skills to narrow down searches and find specific information—use Boolean operators, advanced search, various search words, etc.
• Identify reliable sources found using internet searches and differentiate between reliable and nonreliable sources.
• Apply researching skills to find answers to questions in an internet scavenger hunt.

• Daily Assignments

• Application Quizzes

• Written Quiz

• Formatting Simulation

• Scavenger Hunt

• Internet Test

• Communications:  A.4.1, A.8.1, A.12.1, A.12.2
• Information Systems Technology:  B.4.3, B.4.7, B.4.8, B.8.6, B.8.9

• Communications:  A.4.1, A.4.5, A.8.1, A.12.1, A.12.2
• Information Systems Technology:  B.4.3, B.4.7, B.4.8, B.8.6, B.8.9
• Interpersonal and Leadership Skills:  J.12.1, J.12.3, J.12.7, J.12.8, J.12.10, J.BS.8

• Information Systems Technology:  B.4.10, B.8.10, B.8.11, B.8.12, B.12.1

March

• Section 8:  Email

• Section 9:  Microsoft Outlook

• Demonstrate the ability to compose a professional email.
• Apply basic email skills to send, receive, reply to, and forward emails.
• Demonstrate the ability to attach a document/file to an email.
• Demonstrate the ability to open an attachment from an email.
• Apply organizational skills to create folders, save emails, and permanently delete emails.
• Demonstrate the ability to print an email.
• Create a contact list in your email account.

• Apply organizational skills to create a personal folder in Outlook.
• Demonstrate the ability to create a schedule, adding appointments and events.
• Create and organize a contact list in Microsoft Outlook.
• Demonstrate the ability to create a task list, make journal entries, and write notes.
• Utilize all Outlook skills learned to complete a final organizational project with class schedules, appointments, personal contacts, project notes, etc.

• Daily Assignments

• Email Test

• Outlook Project

• Outlook Test

• Information Systems Technology:  B.4.10, B.8.10, B.8.11, B.8.12, B.12.1, B.12.2, B.12.19, B.12.21

• Information Systems Technology:  B.8.10, B.8.11, B.12.2, B.12.21

April

• Section 10:  Microsoft Excel—toolbars & formulas

• Section 11:  Microsoft Excel—Sorting Information

• Section 12:  Microsoft Excel—Charts & Graphs

• Section 13:  Microsoft Excel—Project

• Section 14:  Microsoft Access--Overview

• Demonstrate the ability to use Microsoft Excel toolbars including:  new, open, sheets, rows, columns, cells, borders, shading, gridlines, printing, orientation, etc.
• Apply the correct formulas for different needs including:  summation, subtraction, multiplication, division, average, minimum, maximum, if/then statements etc.
• Apply the fill features to quickly copy formulas across/down a sheet.
• Identify the importance of using formulas and demonstrate how to print/view cell formulas.

• Use Microsoft Excel to enter information in a database form.
• Apply sort features to sort names (alphabetically), scores (numerically), etc.

• Use various forms of information to create a pie chart.
• Use various forms of information to create different graphs—bar, column, and line.
• Demonstrate the ability to format charts and graphs—change key, colors, titles, labels, etc.

• Apply the skills learned in Microsoft Excel to complete a final project—enter personal grades into spreadsheet and format a graph that displays progress in the class.
• Create a letter to accompany the spreadsheet and graph to send to parents for signature to complete project.

• Demonstrate the ability to use the toolbars in Access.
• Demonstrate how to create a simple table in Access.
• Apply skills to create a simple query in Access.
• Use Access to create a basic form.
• Demonstrate the ability to create a report using Access.

• Daily Assignments

• Excel Final Project

• Excel Test

• Mini Access Project

• Information Systems Technology:  B.4.2, B.4.3, B.8.3, B.3.4, B.8.7, B.8.10, B.12.3, B.12.12

• Information Systems Technology:  B.4.2, B.4.3, B.8.3, B.3.4, B.8.7, B.8.10, B.12.3, B.12.12

• Information Systems Technology:  B.4.2, B.4.3, B.8.3, B.3.4, B.8.7, B.8.10, B.12.3, B.12.12

• Information Systems Technology:  B.4.2, B.4.3, B.8.3, B.8.4, B.8.7, B.8.10, B.12.3, B.12.12

• Information Systems Technology:  B.4.2, B.4.3, B.8.3, B.8.4, B.8.8, B.8.10, B.12.3, B.12.5, B.12.10

May

• Section 15:  Microsoft PowerPoint—Guidelines & Features

• Section 16:  Microsoft PowerPoint—Presentations

• Section 17:  Desktop Publishing—Programs

• Section 18:  Desktop Publishing—Documents

• List basic guidelines for creating a professional PowerPoint—rule of 7, contrast, readable fonts, number of graphics, etc.
• Demonstrate the ability to change backgrounds, set up slide layouts, change text, insert graphics, add animations and transitions, and print slides in various forms.
• Apply concepts learned to download and insert pictures and use a scanner to scan and insert pictures.

• Apply PowerPoint skills learned to create a PowerPoint presentation following guidelines.
• Present information about a predetermined topic using a PowerPoint presentation as a visual aid.

• Demonstrate the use of Microsoft Word toolbars and features to create various types of published documents.
• Demonstrate the use of Microsoft Publisher toolbars and features to create various types of published documents.
• Demonstrate the use of Adobe PageMaker tools and features to create various types of published documents.

• Participate in an office simulation creating a portfolio of documents for a company.
• Utilize leadership skills and cooperation to select the best documents to include in the portfolio for grading.
• Create a portfolio of documents including:  letterhead, business card, poster, calendar, brochure, program, card, resume, and references.

• Daily Assignments

• PowerPoint Presentation—top 10

• Desktop Publishing Simulation

• Information Systems Technology:  B.4.2, B.4.3, B.4.6, B.8.3, B.3.4, B.8.9, B.8.10, B.12.2, B.12.4, B.12.5, B.12.14

• Communications: A.BS.5
• Information Systems Technology:  B.4.2, B.4.3, B.4.6, B.8.3, B.3.4, B.8.9, B.8.10, B.12.2, B.12.4, B.12.5, B.12.14, B.BS.8

• Information Systems Technology:  B.8.3, B.8.4, B.8.9, B.8.10, B.12.12.4, B.12.13, B.BS.6, B.BS.7, B.BS.15

• Communications:  A.4.1, A.4.2, A.8.1, A.8.5, A.12.1, A.12.2
• Information Systems Technology:  B.8.3, B.8.4, B.8.9, B.8.10, B.12.12.4, B.12.13, B.BS.6, B.BS.7, B.BS.15
• Interpersonal and Leadership Skills:  J.12.1, J.12.3, J.12.7, J.12.8, J.12.10, J.BS.8
• Career Development:  K.12.12

May

• Section 19:  Newsletter

• Section 20:  Competencies Check

• Contribute one article to use for a school newsletter created by the class.
• Participate in formatting/designing the end of the year school newsletter.

• Recall skills learned to complete the final test with questions about concepts in:  keyboarding, proofreading, computer terminology, formatting, Microsoft Word, Excel, PowerPoint, Access, Outlook, internet, email, and desktop publishing.

• Daily Assignments

• Article Writing

• Newsletter Layout

• Final Test

• Communications:  A.4.1, A.4.2, A.8.1, A.8.5, A.12.1, A.12.2
• Information Systems Technology:  B.8.3, B.8.4, B.8.9, B.8.10, B.12.12.4, B.12.13, B.BS.6, B.BS.7, B.BS.15
• Interpersonal and Leadership Skills:  J.12.1, J.12.3, J.12.7, J.12.8, J.12.10, J.BS.8

• Communications:  A.4.1, A.4.2, A.8.1, A.12.1, A.12.2
• Information Systems Technology:  B.4.1, B.4.2, B.4.3, B.8.1, B.8.2, B.8.4, B.8.9