Computer Applications A & B

 

Computer Applications A

All Grades
1 Semester, ½ Credit

 

Computer Applications B

Grades 11-12
Prerequisite: Computer Applications A

This course provides training in the computer applications and operating system used at PHS. Students will learn to use the operating system to manage data, use application software, and perform basic networking tasks. They will be introduced to e-mail, Internet browsers, and Web tools to access information. They will develop keyboarding skills needed to create, format, revise, save, print, and import graphics into documents. Primary focus will be on comprehensive activities using word processing and presentation software. This course meets the computer application ½ credit requirement. This course builds on the knowledge and skills developed in Computer Applications A with emphasis on advanced applications in spreadsheet, database, and software integration.

Essential Learnings

 

Computer Applications A

Word

  1. Identify terms associated with computer hardware and software applications.
  2. Practice shortcut keys and keyboard commands for efficient input.
  3. Use organizational skills to effectively perform file management.
  4. Develop keyboarding techniques and typing speed to improve productivity.
  5. Use skills, terminology, and techniques to create and format a variety of document types.
  6. Use skills, terminology, and techniques to create and edit text and graphics.
  7. Create basic business documents such as letters, envelopes, and labels.
  8. Use formatting skills to create documents with columns, outlines, tabs, and tables.
  9. Use formatting skills to create documents related to personal, school, and business use including report formats and business templates.

Excel

  1. Enter and edit data and navigate through cells in a spreadsheet.
  2. Organize, manage, and format data in a worksheet and workbook.
  3. Use functions, formulas, and automated tools to analyze data.
  4. Chart data and describe findings.
  5. Use comments and electronic communications to share data and collaborate with others.

PowerPoint

  1. Create, present, and print a PowerPoint presentation.
  2. Use formatting, text editing, graphic design,  and organizational skills to improve presentations.
  3. Create tables, charts, and diagrams using smart art graphics.
  4. Apply animation, sound, and video to presentations.
  5. Run and navigate a show using tools such as the pen and shortcut keys

 

Computer Applications B

 

  1. Microsoft Office Suite:  What are the names of the application software products in the Microsoft Office Suite, what are they used for and how can Office Applications be integrated?
  2. File Management and Internet Use:  How do you create, find, work with, organize, delete files and utilize the Internet?
  3. Microsoft Word: How do you generate and merge a form letter, envelope, and labels with a data source?
  4. Microsoft Excel:  How do you create a spreadsheet with graphs, enter formulas including financial functions and analyze data?
  5. Microsoft Access:   How do you create tables, advanced forms, reports and queries in Access for practical application?
  6. Microsoft Publisher: How do you create a flyer and a three page web site using Publisher?
  7. Microsoft PowerPoint: How can you enhance a presentation by using visuals and presentation formats in PowerPoint?
  8. Microsoft Outlook:  What are the steps for schedule management using the calendar and e-mail features?