Sheryll Needham
Month	Computer Technology		Business & Computer Technology
	Assignments	Competencies	Assignments	Competencies
August	Lessons1-10 Students will learn the placement of letters and characters on the keyboard and to use the correct finger for each letter or character.	1. Use of keyboards and other input and output devices efficiently and effectively -- 30. Print using a network printer	Review formatting of business letters. Students will type various business letters to re-familiarize themselves with past skills learned.	13. Produce and format common business documents such as letters, memos and reports
September	Lessons 11-35 Students will continue to learn the keyboard. Keyboard Test.	1. Use of keyboards and other input and output devices efficiently and effectively. 30. Print using a network printer	Crest and Poster Students will create a table and insert graphics, word art, shapes, etc. to create a crest that shows their personality and interests Students will research a topic and make a poster using graphics, text, bullets. They will apply desktop publishing concepts when arranging the poster. ----- Career Report Students will research and type a report about an occupation of their choice Spreadsheets Students will create and edit teacher made spreadsheets using the Excel Program	22. Demonstrate knowledge of graphics -- 46. Use a variety of references and research resources 49. Apply appropriate writing skills 72. List skill requirements/qualifications needed to enter a selected career path 81. Set occupational objectives 17 Perform basic spreadsheet applications 18. Edit a spreadsheet 19. Enhance a spreadsheet PASS Standard 5.1, 5.2, 5.3
October	Type Documents such as Personal notes, memos, letters Reports Lessons 41-57 in typing book	1. Use of keyboards and other input and output devices efficiently and effectively 13. Produce and format common business documents such as letters, memos and reports	Formatting Tables for common business applications Students will use table format to create business documents	22. Demonstrate knowledge of graphics software 46. Use a variety of references and research resources 23. Demonstrate knowledge of presentation software 13. Produce and format common business documents such as letters, memos and reports
November	Technology Applications WorkText Chapter 1 – Exploring Computer Systems Chapter 2 – Undersetanding Input/Output Students will complete textbook and workbook assignments along with teacher made worksheets	1. Use basic terminology common in the computer industry. 2. Identify the types and functions of hardware, multimedia equipment, and peripheral components.	Formatting Tables for common business applications Students will prepare a brochure using a table format Students will research an author to prepare a brochure about.	13. Produce and format common business documents such as letters, memos and reports 22. Demonstrate knowledge of graphics software 46. Use a variety of references and research resources
December	Chapter 2, cont. Students will complete textbook and workbook assignments along with teacher made worksheets Create table to make a card Students will create a table, insert text and graphics and create a Christmas Card.	1. Use basic terminology common in the computer industry. 2. Identify the types and functions of hardware, multimedia equipment, and peripheral components. 13. Produce and format common business documents such as letters, memos and reports 22. Demonstrate knowledge of graphics	Formatting Tables Use digital camera and download pictures Students will take pictures, create cards using table format.	13. Produce and format common business documents such as letters, memos and reports 22. Demonstrate knowledge of graphics software PASS 4.1 Use technology tools to create knowledge products for audiences
January	Memos, Lesson 68-70 Letter production. Report production. Students will type letters from Lessons 71-74, , 83, 89 Students will be timed to evaluate production skill.	13. Produce and format common business documents such as letters, memos and reports	Powerpoint Students will create a short powerpoint presentation using the PowerPoint graphics software program Students will do research and create a large powerpoint presentation with a team member. Students will use a digital camera for pictures	22. Demonstrate knowledge of graphics software 46. Use a variety of references and research resources 23. Demonstrate knowledge of presentation software PASS 4.1 Use technology tools to create knowledge products for audiences 37. Practice awareness and skills to be an effective team member.
February	Chapter 3 Understanding Data Storage Students will complete textbook and workbook assignments along with teacher made worksheets Document Processing Students will type various business documents from Lessons 91-100	13. Produce and format common business documents such as letters, memos and reports	Research Project Students will research a Fortune 500 company and prepare a 6 page report including cover, table of contents, and references.	13. Produce and format common business documents such as letters, memos and reports 46. Use a variety of references and research resources
March	Chapter 4 - Understanding System Software Chapter 5 – Understanding applications Typing Assignments using software applications	1. Use basic terminology. 4. Identify types of operating systems 5. Use specific operating system commands 6. Organize directories/folders ____________________ 1. Use basic terminology 13. Produce and format common business documents such as letters, memos and reports PASS, Standards 1, 2.1, 2.2, 3.1, 3.2, 3.3, 4,1	Income Tax -Using IRS website Excel spreadsheet applications	17 Perform basic spreadsheet applications 18. Edit a spreadsheet 19. Enhance a spreadsheet PASS Standard 5.1, 5.2, 5.3
April	Chapter 6 – Understanding Word Processing Chapter 7 – Understanding Spreadsheets Typing Assignments using software applications	1. Use basic terminology 13. Produce and format common business documents such as letters, memos and reports 17 Perform basic spreadsheet applications PASS, Standards 1, 2.1, 2.2, 3.1, 3.2, 3.3, 4,1	Portfolio and Career Orientation	81. Set occupational objectives 82. Compose a letter of application 83. Create a resume 84. Review potential interview questions 85. Formulate responses to simulated situations. 86. Participate in job interview 87. Create a portfolio
May	Chapter 8 – Understanding Databases Chapter 9 Understanding Graphics Typing assignments using software applications	1. Use basic terminology 13. Produce and format common business documents such as letters, memos and reports 20. Perform basic database operations 23. Demonstrate knowledge of presentation software PASS, Standards 1, 2.1, 2.2, 3.1, 3.2, 3.3, 4,1	Review of all software applications and projects for the year. Create a project that uses software applications, forms, etc. learned throughout the year for year-end project	All previous competencies learned throughout the year.