UA-38867514-1
skip to main content
Justin Pickett Staff Photo

Computer Applications Syllabus 

Computer Application Syllabus 

 

Course Description

This course is designed to develop computer technology skills.  Students will use a variety of computer software and hardware tools and features of an electronic information network.  Students will explore the historical, social, and ethical issues of using computer technology.  The students will develop skills that will assist them will efficient production; accurate production analysis; management of information and design and presentation of a multimedia project.

Text and Resources                                                                                        

Microsoft Office 365 Word, Excel, PowerPoint, and Access

 

Class Supplies

Pencils, Pens, Paper, 3 Ring Binder, Dividers

 

Grading Scale

A          93-100                                                       Quiz                        30%

B          85-92                                                         Test                         50%

C          75-84                                                         Daily/Product         15%

D          74-70                                                         Technique               5%

F          Below 70 (No credit given)

 

Make Up Work

Any assignment missed due to any absence should be made up as quickly as possible.  The number of days missed is the number of days the student will be given to complete the assignment. Missed assignments, quizzes, or test may only be made up with excused absence.  Absences due to OSS will be considered as unexcused absences.

Standards

Standard 1 - Research recent developments in information technology affecting the supply/demand characteristics of the job market, including career pathways and occupational outlooks for occupations in business...

    

1.1 - Research recent developments in information technology affecting the supply/demand characteristics of the job market, including career pathways and occupational outlooks for occupations in business...

Standard 2 - Identify, connect, and demonstrate the correct usage of elements of a typical home computer, including a monitor, keyboard, mouse, network cable, and USB devices (such as camera, memory...

    

2.1 - Identify, connect, and demonstrate the correct usage of elements of a typical home computer, including a monitor, keyboard, mouse, network cable, and USB devices (such as camera, memory...

Standard 3 - Correctly and safely execute basic file management operations on a typical personal computer and shared storage media, including the opening, creating, copying, moving, deleting, and renaming...

    

3.1 - Correctly and safely execute basic file management operations on a typical personal computer and shared storage media, including the opening, creating, copying, moving, deleting, and renaming...

Standard 4 - Describe and demonstrate the correct connections and setup for a new wireless router in a home computing environment. Discuss the impact of network speeds, wireless communications, firewalls...

    

4.1 - Describe and demonstrate the correct connections and setup for a new wireless router in a home computing environment. Discuss the impact of network speeds, wireless communications, firewalls...

Standard 5 - Describe the steps necessary to retrieve, download, and safely install new applications, updates, and plug-ins from the Internet.

    

5.1 - Describe the steps necessary to retrieve, download, and safely install new applications, updates, and plug-ins from the Internet. 

Standard 6 - Compare and contrast the accessibility of the Internet through a home router versus through a public wi-fi access point. Discuss the risks and advantages of using secure home networks versus...

    

6.1 - Compare and contrast the accessibility of the Internet through a home router versus through a public wi-fi access point. Discuss the risks and advantages of using secure home networks versus...

Standard 7 - While preparing materials and assignments in this course, use a browser to access and download Internet resources by uniform resource locator (URL), hyperlink, or favorite/bookmark.

    

7.1 - While preparing materials and assignments in this course, use a browser to access an download Internet resources by uniform resource locator (URL), hyperlink or favorite/bookmark.

Standard 8 - Use a word processing program to create and format documents with academic and business styles (e.g., memos, letters, agendas, reports, tabular lists) to communicate the results of research...

    

8.1 - Use a word processing program to create and format documents with academic and business styles (e.g., memos, letters, agendas, reports, tabular lists) to communicate the results of research...

Standard 9 - Craft documents using word processing program features and methods such as: a. Paragraph formatting (line spacing, justification, identations) b. Bulleted and numbered lists c. Tables of multiple...

    

9.1 - Craft documents using word processing program features and methods such as: a. Paragraph formatting (line spacing, justification, identations) b. Bulleted and numbered lists. c. Tables of multiple...

Standard 10 - Enhance documents by including graphic arts components such as borders and shaded elements, graphs and charts from other programs, watermarks, and imagery imported from technology...

    

10.1 - Enhance documents by including graphic arts components such as borders and shaded elements, graphs and charts from other programs, watermarks, and imagery imported from technology...

Standard 11 - Create, format, and edit documents suitable for print or electronic distribution, both four-color and two-color (black and white).

    

11.1 - Create, format, and edit documents suitable for print or electronic distribution, both four-color and two-color (black and white).

Standard 12 - Critique and edit existing documents with standard proofreading and editing marks to conform to a standard business style guide (e.g., fonts, colors, line spacing). Practice the use of electronic...

    

12.1 - Critique and edit existing documents with standard proofreading and editing marks to conform to a standard business style guide (e.g., fonts, colors, line spacing). Practice the use of electronic...

Standard 13 - Complete a comprehensive word-processing project with instructor approval that applies the skills acquired in this section. For example, prepare a contract, MLA-style report, business...

    

13.1 - Complete a comprehensive word-processing project with instructor approval that applies the skills acquired in this section. For example, prepare a contract, MLA-style report, business 

Standard 14 - Use a spreadsheet program to create and format academic and business documents for the purposes of tabulating and calculating numerical and/or textual data (e.g., statistics, historical data...

    

14.1 - Use a spreadsheet program to create and format academic and business documents for the purposes of tabulating and calculating numerical and/or textual data (e.g., statistics, historical data...

Standard 15 - Craft documents using a spreadsheet program using features and methods such as: a. Cells, columns, and rows b. Formulas and functions c. Copy, move, delete, and fill d. Cell-value formats...

    

15.1 - Craft documents using a spreadsheet program using features and methods such as: a. Cells, columns, and rows b. Formulas and functions c. Copy, move, delete, and fill d. Cell-value formats...

Standard 16 - Create new formulas to analyze data by calculating with, extracting from, presenting, and/or summarizing, including: a. Basic arithmetic calculations b. Basic mathematic (e.g., SUM, AVG, MIN, MAX)...

    

16.1 - Create new formulas to analyze data by calculating with, extracting from, presenting, and/or summarizing, including: a. Basic arithmetic calculations b. Basic mathematic (e.g., SUM, AVG, MIN, MAX)...

Standard 17 - Create and format for optional clarity a variety of types of graphs and charts, including bar charts, line charts, pie charts, and X-Y graphs, based on tabulated data.

    

17.1 - Create and format for optional clarity a variety of types of graphs and charts, including bar charts, line charts, pie charts, and X-Y graphs, based on tabulated data.

Standard 18 - Retrieve a spreadsheet template (from those installed with the program or from the Internet) and customize it for a particular assignment approved by the instructor. For example, prepare...

    

18.1 - Retrieve a spreadsheet template (from those installed with the program or from the Internet) and customize it for a particular assignment approved by the instructor. For example, prepare...

Standard 19 - Use a database program to interpret the structure of an existing database (found in teaching resources or teacher-created), identifying tables, fields, key fields, queries, forms, and reports.

    

19.1 - Use a database program to interpret the structure of an existing database (found in teaching resources or teacher-created), identifying tables, fields, key fields, queries, forms, and reports.

Standard 20 - Using an existing database (found in teaching resources or teacher-created), create and run a database report based on basic queries. For example, retrieve the relevant information to answer...

    

20.1 - Using an existing database (found in teaching resources or teacher-created), create and run a database report based on basic queries. For example, retrieve the relevant information to answer...

Standard 21 - Using an existing database (found in teaching resources or teacher-created), create, modify, and perform basic queries through a form to create a new table/view in a database.

    

21.1 - Using an existing database (found in teaching resources or teacher-created), create, modify, and perform basic queries through a form to create a new table/view in a database.

Standard 22 - Design, create, and deliver an oral presentation for a selected audience on a topic approved by the instructor. Using a specified slide number and duration, include the following elements:...

    

22.1 - Design, create, and deliver an oral presentation for a selected audience on a topic approved by the instructor. Using a specified slide number and duration, include the following elements...

Standard 23 - Design, create, and deliver a self-running electronic slideshow for a selected audience on a topic approved by the instructor. Using a specified slide number and duration, include the following... 

    

23.1 - Design, create, and deliver a self-running electronic slideshow for a selected audience on a topic approved by the instructor. Using a specified slide number and duration, include the following...

Standard 24 - Research, summarize, and deliver (via presentation, document, spreadsheet data/chart, or other format) a summary of the various perspectives and ramifications surrounding an ethical issue related...

    

24.1 - Research, summarize, and deliver (via presentation, document, spreadsheet data/chart, or other format) a summary of the various perspectives and ramifications surrounding an ethical issue related...

Standard 25 - Research, summarize, and deliver (via presentation, document, spreadsheet data/chart, or other format) a summary of the various perspectives and ramifications surrounding an ethical issue related...

    

25.1 - Research, summarize, and deliver (via presentation, document, spreadsheet data/chart, or other format) a summary of the various perspectives and ramifications surrounding an ethical issue related...

Standard 26 - Explain, furnish examples, and demonstrate technical literacy with the following terms: a. The Internet, World Wide Web, and various browsers b. Network speeds, wireless communication, firewalls...

    

26.1 - Explain, furnish examples, and demonstrate technical literacy with the following terms/ a. The Internet, World Wide Web, and various browsers b. Network speeds, wireless communication, firewalls... 

Standard 27 - Employ skills covered in this course (document processing, spreadsheet applications, electronic presentations, databases, Internet fluency) to complete a cross curricular project approved by...

    

27.1 - Employ skills covered in this course (document processing, spreadsheet applications, electronic presentations, databases, Internet fluency) to complete a cross curricular project approved by...