Page 10 of 12
INTEGRATED BUSINESS APPLICATIONS II
LONG-RANGE PLAN
TEACHER: Shirley A. Johnson YEAR: 2015-2016
SCHOOL: GENESIS EDUCATION CENTER GRADE: 9-12
COURSE DESCRIPTION: This course of study is designed to teach the student advanced computer concepts as related to processing data into useful information needed in business situations by using advanced database, spreadsheet, word processing, and presentation software capabilities. Because the design of this course is to prepare students for Microsoft Office Specialist (MOS) Certification, the emphasis is on speed, accuracy, and production using proper keyboarding techniques.
PREREQUISITE: Successful completion of Integrated Business Applications 1
TEXTBOOKS: Performing with Computer Applications, Word Processing, Desktop Publishing, Spreadsheets, Database, Presentations, and Web Design, Learning Microsoft Office 2007
RESOURCES: Computer Technology, Integrated Computer Applications with Multimedia & Input Technologies, Chromebook
EQUIPMENT: Computers required, one computer per student
Long-Range Planning
Description of Students
In my second block A Day class, I teach students with varied ability levels. There are six girls and seven boys in the class. They are from Greenwood High and Emerald High. Many of the students have taken a computer course. I have one student in the class who types very slowly and need extra time to complete assignments. I also have one resource student in the class. He is given extra time to complete assignments so that he can achieve success. I have one Hispanic student in the class. This class works well together. They volunteer to assist one another. They come from different cultural backgrounds. I have to be mindful of each other’s differences and remind them that they need to accept each other’s differences.
Describe the adaptations you will make to this plan to accommodate special needs students. In this description, include adaptations for ESOL students.
To accommodate my special needs students, I allow extra time for them to complete the assignments. There are other students who sit near them who assist them with directions on how to complete assignments. They also have the option of coming before school or after school to complete assignments that they may have missed. I also allow them to complete assignments during their compass class if they need to makeup work missed. Sometimes I modify the exercise and allow them to do a portion of what other students have to do if they type very slowly and they are working steadily on their assignment. If the student’s behavior is interfering with his or her assignment, I don’t modify the work, but I give them the option of making up the work after school or before school. I also allow them to retake tests that they did poorly on.
II. Learning and Developmental Goals:
Students will be able to apply Word Expert level skills to documents and activities
Students will be able to apply Microsoft Expert level skills to Excel, Access, and PowerPoint
Students will be able to integrate applications
Students will be able to simulate activities using the Internet
Students will be able to identify good work attitudes that affect safety.
Students will be able to explain how related student organizations are integral parts of career and technology courses.
I have aligned these goals with the following required sources:
Microsoft Office 2007
Learning Microsoft Office 2007
Performing With Microsoft Word 2003
Resource Activities
Teacher Made Activities
*These goals refer to learning that will take place during the time span in which you will be teaching the class (year, semester, or nine weeks)
A. SAFETY 1 Day
The student will be able to:
1. Identify good work attitudes that affect safety on the job.
2. Identify major causes of work-related accidents in offices.
3. Demonstrate knowledge of an emergency plan.
4. Describe the threat of viruses to a computer network, methods of avoiding attacks, and options in dealing with a virus attack.
5. Identify potential abuse and unethical uses of computers and
networks.
B. STUDENT ORGANIZATIONS 1 DayThe student will be able to:
1. Explain how related student organizations are integral parts of career and technology courses.
2. Explain the goals and objectives of related student organizations.
3. List opportunities available to students through participation in related student organization conferences and other activities.
4. Explain how participation in career and technology education student organizations can promote lifelong responsibility for community service and professional development.
C. MICROSOFT OFFICE SPECIALIST (MOS)—WORD EXPERT LEVEL 4 Wks.
The student will be able to:
1. Apply paragraph and section shading.
2. Use text flow options (Widow/Orphan options and keeping lines together).
3. Sort lists, paragraphs, and tables.
4. Create and modify page borders.
5. Format first page differently then subsequent pages.
6. Use bookmarks.
7. Create and edit styles.
8. Create watermarks.
9. Use find and replace with formats, special characters, and non-printing elements.
10. Balance column length (using column breaks appropriately).
11. Create or revise footnotes and endnotes.
12. Work with master documents and subdocuments.
13. Create and modify a table of contents.
14. Create cross-references.
15. Create and modify an index.
16. Embed worksheets in a table.
17. Perform calculations in a table.
18. Link Excel data as a table.
19. Modify worksheets in a table.
20. Add bitmapped graphics.
21. Delete and position graphics.
22. Create and modify charts.
23. Import data into charts.
24. Create main document.
25. Create data source.
26. Sort records to be merged.
27. Merge main document and data source.
28. Generate labels.
29. Merge a document using alternate data sources.
30. Insert a field.
31. Create, apply, and edit macros.
32. Copy, rename, and delete macros.
33. Create and modify form.
34. Create and modify a form control (add an item to a drop-down list).
35. Use advanced text alignment features with graphics.
36. Customize toolbars.
37. Create and format tables.
38. Insert comments.
39. Protect documents.
40. Create multiple versions of a document.
41. Track changes to a document.
42. Set default file location for workgroup templates.
43. Round trip documents from HTML.
D. MICROSOFT OFFICE SPECIALIST (MOS)—EXCEL EXPERT LEVEL 4 Wks.
The student will be able to:
1. Import data from text files (insert, drag, and drop).
2. Import from other applications.
3. Import a table from HTML file (insert and drag and drop—including HTML round tripping).
4. Export to other applications.
5. Apply templates.
6. Edit templates.
7. Create templates.
8. Use a workspace.
9. Link workbooks.
10. Apply number formats (accounting, currency, and number).
11. Create custom number formats.
12. Use conditional formatting.
13. Preview and print multiple worksheets.
14. Use the Report Manager.
15. Add and delete a named range.
16. Use a named range in a formula.
17. Use Lookup Functions (Hlookup or Vlookup).
18. Hide and display toolbars.
19. Customize a toolbar.
20. Assign a macro to a command button.
21. Record macros.
22. Run macros.
23. Edit macros.
24. Work with the Auditing Toolbar.
25. Trace errors (find and fix errors).
26. Trace precedents (find cells referred to in a specific formula).
27. Trace dependents (find formulas that refer to a specific cell).
28. Apply conditional formats.
29. Perform single and multi-level sorts.
30. Use grouping and outlines.
31. Use subtotaling.
32. Apply data filters.
33. Extract data.
34. Query databases.
35. Use data validation.
36. Use PivotTable autoformat.
37. Use Goal Seek.
38. Create pivot chart reports.
39. Work with Scenarios.
40. Use Solver.
41. Use data analysis and PivotTables.
42. Create interactive PivotTables for the Web.
43. Add fields to a PivotTable using the Web browser.
44. Create, edit, and remove a comment.
45. Apply and remove worksheet and workbook protections.
46. Change workbook properties.
47. Apply and remove file passwords.
48. Track changes (highlight, accept, and reject).
49. Create a shared workbook.
50. Merge workbooks.
E. MICROSOFT OFFICE SPECIALIST (MOS)—ACCESS 4 Wks.
The student will be able to:
1. Create a form with the Form Wizard.
2. Use the Control Toolbox to add controls.
3. Modify Format Properties (font, style, font size, color, and caption) of controls.
4. Use form sections (headers, footers, and detail).
5. Use a Calculated Control on a form.
6. Use the Office Clipboard.
7. Switch between object views.
8. Enter records using a datasheet.
9. Enter records using a form.
10. Delete records from a table.
11. Find a record.
12. Sort records.
13. Apply and remove filters (filter by form and filter by selection).
14. Specify criteria in a query.
15. Display related records in a subdata sheet.
16. Create a calculated field.
17. Create and modify a multi-table select query.
18. Establish relationships.
19. Enforce referential integrity.
20. Create a report with the Report Wizard.
21. Preview and print a report.
22. Move and resize a control.
23. Modify and format properties (font, style, font size, color, and caption).
24. Use the Control Toolbox to add controls.
25. Use report sections (headers, footers, and detail).
26. Use a Calculated Control in a report.
27. Import data to a new table.
28. Save a table, query, and forms as a Web page.
29. Publish a presentation to the Web.
30. Add hyperlinks.
31. Print database relationships.
32. Back up and restore a database.
33. Compact and repair a database.
F. MICROSOFT OFFICE SPECIALIST (MOS)—POWERPOINT 4 Wks.
The student will be able to:
1. Copy a slide from one presentation to another.
2. Create a new presentation from existing slides.
3. Insert headers and footers.
4. Create a presentation using the AutoContent Wizard.
5. Send a presentation via e-mail.
6. Find and replace text.
7. Modify the Slide Master.
8. Import text from Word.
9. Use the Office Clipboard.
10. Use the Format Painter.
11. Add and group shapes using WordArt or the drawing Toolbar.
12. Add text to a graphic object using a text box.
13. Create tables within Powerpoint.
14. Rotate and fill an object.
15. Add AutoNumber bullets.
16. Add speaker notes.
17. Add graphical bullets.
18. Print audience handouts.
19. Print speaker notes in a specified format.
20. Print a slide as an overhead transparency.
21. Use the pen during a presentation.
22. Publish a presentation to the Web.
23. Insert a hyperlink.
G. INTEGRATING SOFTWARE APPLICATIONS 2 Wks.
The student will be able to:
1. Produce documents integrating word processing, database, spreadsheet, and presentation files.
2. Produce documents integrating graphic files with other application software.
3. Produce documents integrating sound files with other application software if technology is available.
III. Materials and Resources
Materials Source of Funding(If item(s) are to be purchased)
Century 21 Computer Applications & Keyboarding School
Microsoft Office 2000 Introductory course School
Projector School
Overhead School
Jumpdrive Allotment
Printer cartridge Allotment
Kleenex, lotions, hand sanitizer Teacher
Envelopes Allotment
DVD’s DVD jackets Allotment
Pencils/pens Allotment
Folders School
Printer paper School
Printer School
Computer School
Chromebook District
IV. Assessment
Informal assessment strategies: (Include list of the strategies and description of criteria for use in evaluation process).
I use informal and formal assessment strategies in my class. I monitor and observe the students as they type lessons. I observe their technique, hand and eye coordination, and their attention to reaching their goal. I also give them points on their point sheet if they make an effort to complete assignments and do not cause a distraction in my class. I also assess them with teacher made quizzes after I have taught a concept to reinforce the concept. They are also given teacher made tests to assess units or several concepts learned thus far. I also use the district’s grading policy when assigning letter grades.
Monitoring student progress: (If you use various strategies for keeping track of student progress, list and describe them. For example, keeping folders/portfolios, weekly reports to parents, etc.)
I use folders for keeping track of student work. They are responsible for filing their papers after I have graded and returned them to the student. I also keep their grades in my computer in spreadsheet which makes it easier to average. The student can know at all times what his or her grade is in the class because I keep their grades posted in the computer for them to see if they ask. They also know what they have missed when they see a red zero in the cell. I also communicate with parents through interim and regularly calling parents if there is a problem with attendance, behavior, or concern.
Formal assessment strategies: (Include list of the assessment strategies and criteria for use in the evaluation process).
I use teacher made quizzes and written tests. I also use the assessment at the end of a unit so that they can display mastery of material by utilizing hands on. I also design activities for them to show mastery of unit concepts. The tests count 35% towards their final grade and quizzes count 25% towards their final grade.
Recording grades: (Which grades are actually recorded? Describe set-up of grade book, computer program, check-lists, etc.)
My grades are recorded in the Microsoft Excel spreadsheet. I record the quizzes, tests, participation, warm-ups, and daily grades. Each student writes everyday in his or her warm-up file on the computer from a question or statement from a previous lesson that is given at the beginning of class to reinforce prior learning. Their writing and oral communication skills are assessed daily as they read their response and print the warm-ups at the end of the week for a daily grade.
Grading/Criteria for assigning grades for report cards: (List categories of assignments, weights, and grading scale).
Weighted categories for grades:
Daily assignments 40%
Quizzes 25%
Tests 35%
I will be using the District’s grading scale:
93—100 A
85—92 B
77—84 C
70—76 D
0—69 F
V. Discipline Plan
Describe the discipline plan used in your classroom.
CLASSROOM EXPECTATIONS,
ROUTINES/PROCEDURES/CONSEQUENCES
Ms. Johnson, Room 503
CLASSROOM EXPECTATIONS
· Be in class on time with materials
· No eating or drinking in the lab.
· Keep your area neat and clean; put up materials in proper area before leaving the lab.
· Be respectful to teacher and peers.