1

Computer Technology & Applications BSyllabus

Course Description:This course will cover basic computer software and hardware; touch keyboarding, Microsoft Word and Power Point. Document formatting, such as letters, memos, e-mail, reports with documentations, will be emphasized. Word functions such as tables, lists, copying, pasting, outlining, will be included. This course will also incorporate career lessons, in this section of Computer & Technology Applications. Computer and Tech App B will continue the application of Microsoft Office, emphasizing in Excel and Access, and the use of Microsoft Word and PowerPoint in greater depth. Use of Microsoft Office Suite: Word, PowerPoint, Excel, and Access.

Prerequisites:Computer Technology & Applications A

Materials: Binder required, flash drive optional

Grading Policy: GCHS Grading Scale: A=90-100; B=80-89; C=70-79; D=60-69; F=0-59

Classroom Rules/Expectations: See separate document

Course Outline

  • Unit 1-Microsoft Office-Word 2 Weeks

Program of Studies

  • 1.11: Students write using appropriate forms, conventions, and styles to communicate ideas and information to different audiences for different purposes.
  • 1.16: Students use computers and other kinds of technology to collect, organize, and communicate information and ideas.
  • 2.18: Students understand economic principles and are able to make economic decisions that have consequences in daily living.
  • 2.37: Students demonstrate skills and work habits that lead to success in future schooling and work.
  • 6.2: Students use what they already know to acquire new knowledge, develop new skills, or interpret new experiences.
  • 6.3: Students expand their understanding of existing knowledge by making connections with new knowledge, skills, and experiences.
  • Writing Standard:
  • #2—Write informative/explanatory texts, including the narration of historical events, scientific procedures/experiments, or technical processes.
  • #6—Use technology, including the internet, to produce, publish, and update individual or shared writing products in response to ongoing feedback, including new arguments or information.
  • #7—Conduct short as well as more sustained research projects to answer a question (including a self-generated question) or solve a problem; narrow or broaden the inquiry when appropriate; synthesize multiple sources on the subject, demonstrating understanding of the subject under investigation.
  • #9—Draw evidence from information texts to support analysis, reflection, and research.
  • Reading Standard:
  • #1—Cite specific textual evidence to support analysis of science and technical texts, attending to important distinctions the author makes and to any gaps or inconsistencies in the account.
  • #2—Determine the central ideas of conclusions of a text: summarize complex concepts, processes, or information presented in a text by paraphrasing them in simpler but still accurate terms.
  • Speaking/Listening Standards:
  • CCSS.ELA-Literacy.SL.11-12.1 Initiate and participate effectively in a range of collaborative discussions (one-on-one, in groups, and teacher-led) with diverse partners on grades 11–12 topics, texts, and issues, building on others’ ideas and expressing their own clearly and persuasively.
  • CCSS.ELA-Literacy.SL.11-12.1a Come to discussions prepared, having read and researched material under study; explicitly draw on that preparation by referring to evidence from texts and other research on the topic or issue to stimulate a thoughtful, well-reasoned exchange of ideas.
  • PL/CS Program Review:
  • Demonstrator 2b: Curriculum incorporates connections to community, society, industry, and current events with work-based learning opportunities for all students.
  • Demonstrator 3c: Relevant technology tools (e.g., smart boards, keyboarding at elementary level, internet research, podcasting, pedometers, Wii) are integrated into classroom content and utilized by students and teachers.
  • Topics to be Covered
  • Microsoft Office (MS Word); Create, save, print, modify, spell-check, and grammar-check.
  • Microsoft Office (MS Word); Manipulate files and folders to copy, move, rename, and delete files; and to create, copy, move, rename, and delete folders.
  • Microsoft Office (MS Word); Enhance a document using centered, right justification, boldface, underlined, and italicized text.
  • Microsoft Office (MS Word); AutoFormat, AutoCorrect, formatting text, formatting paragraphs and documents, working with graphics, working with documents, and increasing efficiency.
  • Vocabulary

Resources/Activities

-Microsoft Office 2010

-LCD Projector

-Document Reader

-Text—Microsoft Office 2010, Introductory by Pasewark and Pasewark.

-Interest Differentiation-About Me

-Step-By-Step from text

-Projects from text

-Vocabulary Handout/Quiz

-Assignments from Text

-Unit 1 Performance Based Test (MS Word Project)—Microsoft Word

-Informational Reading—Facebook, Twitter, Evolution of Computer Technology, Questions to accompany

-Business Department Writing Rubric

  • Unit 2-Microsoft Office-Excel 2 Weeks

Program of Studies

  • 1.11: Students write using appropriate forms, conventions, and styles to communicate ideas and information to different audiences for different purposes.
  • 1.16: Students use computers and other kinds of technology to collect, organize, and communicate information and ideas.
  • 2.37: Students demonstrate skills and work habits that lead to success in future schooling and work.
  • 1.5-1.9: Students use mathematical ideas and procedures to communicate, reason, and solve problems.
  • 2.7: Students understand number concepts and use numbers appropriately and accurately.
  • 2.8: Students understand various mathematical procedures and use them appropriately and accurately.
  • Writing Standard:
  • #2—Write informative/explanatory texts, including the narration of historical events, scientific procedures/experiments, or technical processes.
  • #6—Use technology, including the internet, to produce, publish, and update individual or shared writing products in response to ongoing feedback, including new arguments or information.
  • #10—Write routinely over extended time frames (time for reflection and revision) and shorter time frames (a single sitting or a day or two) for a range of discipline-specific tasks, purposes, and audiences.
  • Reading Standard:
  • #1—Cite specific textual evidence to support analysis of science and technical texts, attending to important distinctions the author makes and to any gaps or inconsistencies in the account.
  • #2—Determine the central ideas of conclusions of a text: summarize complex concepts, processes, or information presented in a text by paraphrasing them in simpler but still accurate terms.
  • Speaking/Listening Standards:
  • CCSS.ELA-Literacy.SL.11-12.1 Initiate and participate effectively in a range of collaborative discussions (one-on-one, in groups, and teacher-led) with diverse partners on grades 11–12 topics, texts, and issues, building on others’ ideas and expressing their own clearly and persuasively.
  • CCSS.ELA-Literacy.SL.11-12.1a Come to discussions prepared, having read and researched material under study; explicitly draw on that preparation by referring to evidence from texts and other research on the topic or issue to stimulate a thoughtful, well-reasoned exchange of ideas.
  • CCSS.ELA-Literacy.SL.11-12.2 Integrate multiple sources of information presented in diverse formats and media (e.g., visually, quantitatively, orally) in order to make informed decisions and solve problems, evaluating the credibility and accuracy of each source and noting any discrepancies among the data.
  • PL/CS Program Review:
  • Demonstrator 2b: Curriculum incorporates connections to community, society, industry, and current events with work-based learning opportunities for all students.
  • Topics to be Covered
  • Microsoft Office (MS Excel);changing the appearance of a worksheet.
  • Microsoft Office (MS Excel); organizing the worksheet.
  • Microsoft Office (MS Excel); entering worksheet formulas, using functions.
  • Microsoft Office (MS Excel); enhancing a worksheet, working with multiple worksheets and workbooks.
  • Microsoft Office (MS Excel); working with charts.
  • Vocabulary

Resources/Activities

-Microsoft Office 2010

-LCD Projector

-Document Reader

-Text—Microsoft Office 2010, Introductory by Pasewark and Pasewark.

-Interest Differentiation-About Me

-Step-By-Step from text

-Projects from text

-Vocabulary Handout/Quiz

-Assignments from Text

-Unit 2 Performance Based Test (MS Excel Project)—Microsoft Excel

-Informational Reading—Facebook, Twitter, Evolution of Computer Technology, Questions to accompany

-Business Department Writing Rubric

  • Unit 3-Microsoft Office-Access 2 Weeks

Program of Studies

  • 1.10: Students organize information through development and use of classification rules and systems.
  • 1.11: Students write using appropriate forms, conventions, and styles to communicate ideas and information to different audiences for different purposes.
  • 1.16: Students use computers and other kinds of technology to collect, organize, and communicate information and ideas.
  • 2.37: Students demonstrate skills and work habits that lead to success in future schooling and work.
  • 6.2: Students use what they already know to acquire new knowledge, develop new skills, or interpret new experiences.
  • Writing Standard:
  • #2—Write informative/explanatory texts, including the narration of historical events, scientific procedures/experiments, or technical processes.
  • #4—Produce clear and coherent writing in which the development, organization, and style are appropriate to task, purpose, and audience.
  • #5—Develop and strengthen writing as needed by planning, revising, editing, rewriting, or trying a new approach, focusing on addressing what is most significant for a specific purpose and audience.
  • Reading Standard:
  • #1—Cite specific textual evidence to support analysis of science and technical texts, attending to important distinctions the author makes and to any gaps or inconsistencies in the account.
  • #2—Determine the central ideas of conclusions of a text: summarize complex concepts, processes, or information presented in a text by paraphrasing them in simpler but still accurate terms.
  • Speaking/Listening Standards:
  • CCSS.ELA-Literacy.SL.11-12.1 Initiate and participate effectively in a range of collaborative discussions (one-on-one, in groups, and teacher-led) with diverse partners on grades 11–12 topics, texts, and issues, building on others’ ideas and expressing their own clearly and persuasively.
  • CCSS.ELA-Literacy.SL.11-12.1a Come to discussions prepared, having read and researched material under study; explicitly draw on that preparation by referring to evidence from texts and other research on the topic or issue to stimulate a thoughtful, well-reasoned exchange of ideas.
  • CCSS.ELA-Literacy.SL.11-12.2 Integrate multiple sources of information presented in diverse formats and media (e.g., visually, quantitatively, orally) in order to make informed decisions and solve problems, evaluating the credibility and accuracy of each source and noting any discrepancies among the data.
  • PL/CS Program Review:
  • Demonstrator 2b: Curriculum incorporates connections to community, society, industry, and current events with work-based learning opportunities for all students.
  • Topics to be Covered
  • Microsoft Office (Access);creating a database.
  • Microsoft Office (Access); creating queries.
  • Microsoft Office (Access); creating and modifying forms.
  • Microsoft Office (Access); creating and modifying reports.
  • Microsoft Office (Access); integrating Access.
  • Vocabulary

Resources/Activities

-Microsoft Office 2010

-LCD Projector

-Document Reader

-Text—Microsoft Office 2010, Introductory by Pasewark and Pasewark.

-Interest Differentiation-About Me

-Step-By-Step from text

-Projects from text

-Vocabulary Handout/Quiz

-Assignments from Text

-Unit 3 Performance Based Test (MS Access Project)—Microsoft Access

-Informational Reading—Facebook, Twitter, Evolution of Computer Technology, Questions to accompany

-Business Department Writing Rubric

  • Unit 4-Microsoft Office-PowerPoint 2 Weeks

Program of Studies

  • 1.11: Students write using appropriate forms, conventions, and styles to communicate ideas and information to different audiences for different purposes.
  • 1.13: Students make sense of ideas and communicate ideas with the visual arts.
  • 1.16: Students use computers and other kinds of technology to collect, organize, and communicate information and ideas.
  • 2.7: Students understand number concepts and use numbers appropriately and accurately.
  • 2.8: Students understand various mathematical procedures and use them appropriately and accurately.
  • Writing Standard:
  • #2—Write informative/explanatory texts, including the narration of historical events, scientific procedures/experiments, or technical processes.
  • #5—Develop and strengthen writing as needed by planning, revising, editing, rewriting, or trying a new approach, focusing on addressing what is most significant for a specific purpose and audience.
  • #10—Write routinely over extended time frames (time for reflection and revision) and shorter time frames (a single sitting or a day or two) for a range of discipline-specific tasks, purposes, and audiences.
  • Reading Standard:
  • #1—Cite specific textual evidence to support analysis of science and technical texts, attending to important distinctions the author makes and to any gaps or inconsistencies in the account.
  • #2—Determine the central ideas of conclusions of a text: summarize complex concepts, processes, or information presented in a text by paraphrasing them in simpler but still accurate terms.
  • Speaking/Listening Standards:
  • CCSS.ELA-Literacy.SL.11-12.1 Initiate and participate effectively in a range of collaborative discussions (one-on-one, in groups, and teacher-led) with diverse partners on grades 11–12 topics, texts, and issues, building on others’ ideas and expressing their own clearly and persuasively.
  • CCSS.ELA-Literacy.SL.11-12.1a Come to discussions prepared, having read and researched material under study; explicitly draw on that preparation by referring to evidence from texts and other research on the topic or issue to stimulate a thoughtful, well-reasoned exchange of ideas.
  • CCSS.ELA-Literacy.SL.11-12.2 Integrate multiple sources of information presented in diverse formats and media (e.g., visually, quantitatively, orally) in order to make informed decisions and solve problems, evaluating the credibility and accuracy of each source and noting any discrepancies among the data.
  • CCSS.ELA-Literacy.SL.11-12.4 Present information, findings, and supporting evidence, conveying a clear and distinct perspective, such that listeners can follow the line of reasoning, alternative or opposing perspectives are addressed, and the organization, development, substance, and style are appropriate to purpose, audience, and a range of formal and informal tasks.
  • CCSS.ELA-Literacy.SL.11-12.5 Make strategic use of digital media (e.g., textual, graphical, audio, visual, and interactive elements) in presentations to enhance understanding of findings, reasoning, and evidence and to add interest.
  • CCSS.ELA-Literacy.SL.11-12.6 Adapt speech to a variety of contexts and tasks, demonstrating a command of formal English when indicated or appropriate.
  • PL/CS Program Review:
  • Demonstrator 2b: Curriculum incorporates connections to community, society, industry, and current events with work-based learning opportunities for all students.
  • Topics to be Covered
  • Microsoft Office (MS PowerPoint);creating and enhancing PowerPoint presentations.
  • Microsoft Office (MS PowerPoint); working with visual elements.
  • Microsoft Office (MS PowerPoint); expanding on PowerPoint basics.
  • Vocabulary

Resources/Activities

-Microsoft Office 2010

-LCD Projector

-Document Reader

-Text—Microsoft Office 2010, Introductory by Pasewark and Pasewark.

-Interest Differentiation-About Me

-Step-By-Step from text

-Projects from text

-Vocabulary Handout/Quiz

-Assignments from Text

-Unit 4 Performance Based Test (MS PowerPoint Project)—Microsoft PowerPoint

-Informational Reading—Facebook, Twitter, Evolution of Computer Technology, Questions to accompany

-Business Department Writing Rubric

  • Unit 5-Microsoft Office-Outlook 1 Week

Program of Studies

  • 1.16: Students use computers and other kinds of technology to collect, organize, and communicate information and ideas.
  • 2.14: Students understand the democratic principles of justice, equality, responsibility, and freedom and apply them to real-life situations.
  • Writing Standard:
  • #4—Produce clear and coherent writing in which the development, organization, and style are appropriate to task, purpose, and audience.
  • #6—Use technology, including the internet, to produce, publish, and update individual or shared writing products in response to ongoing feedback, including new arguments or information.
  • #10—Write routinely over extended time frames (time for reflection and revision) and shorter time frames (a single sitting or a day or two) for a range of discipline-specific tasks, purposes, and audiences.
  • Reading Standard:
  • #1—Cite specific textual evidence to support analysis of science and technical texts, attending to important distinctions the author makes and to any gaps or inconsistencies in the account.
  • #2—Determine the central ideas of conclusions of a text: summarize complex concepts, processes, or information presented in a text by paraphrasing them in simpler but still accurate terms.
  • Speaking/Listening Standards:
  • CCSS.ELA-Literacy.SL.11-12.1 Initiate and participate effectively in a range of collaborative discussions (one-on-one, in groups, and teacher-led) with diverse partners on grades 11–12 topics, texts, and issues, building on others’ ideas and expressing their own clearly and persuasively.
  • CCSS.ELA-Literacy.SL.11-12.1a Come to discussions prepared, having read and researched material under study; explicitly draw on that preparation by referring to evidence from texts and other research on the topic or issue to stimulate a thoughtful, well-reasoned exchange of ideas.
  • CCSS.ELA-Literacy.SL.11-12.2 Integrate multiple sources of information presented in diverse formats and media (e.g., visually, quantitatively, orally) in order to make informed decisions and solve problems, evaluating the credibility and accuracy of each source and noting any discrepancies among the data.
  • PL/CS Program Review:
  • Demonstrator 2b: Curriculum incorporates connections to community, society, industry, and current events with work-based learning opportunities for all students.
  • Demonstrator 3e: Appropriate communication skills (e.g., verbal, non-verbal, written, listening, and interview skills) and presentation techniques are integrated across a variety of content areas.
  • Demonstrator 4a: Using a variety of formative and summative assessment data as a guide, teachers, students and parents work together to construct and to continually update the Individual Learning Plan (ILP).
  • Topics to be Covered
  • Microsoft Office (MS Outlook); basics and E-mail.
  • Microsoft Office (MS Outlook); calendar.
  • Microsoft Office (MS Outlook); working with other Outlook tools.
  • Vocabulary

Resources/Activities

-Microsoft Office 2010

-LCD Projector

-Document Reader

-Text—Microsoft Office 2010, Introductory by Pasewark and Pasewark.

-Interest Differentiation-About Me

-Step-By-Step from text

-Projects from text

-Vocabulary Handout/Quiz

-Assignments from Text

-Unit 5 Performance Based Test (MS Outlook Project)—Microsoft Outlook

-Informational Reading—Facebook, Twitter, Evolution of Computer Technology, Questions to accompany

-Business Department Writing Rubric

  • Unit 6-Microsoft Office-Publisher 1 Week

Program of Studies