Muskingum Valley ESC Standards-Based Business Course of Study
Course: Computer Applications
Unit: 1 –Keyboarding
Standard/Benchmark / Indicators / ResourcesA. Use proper techniques to develop proficiency in the touch typing method.
B. Develop speed and accuracy. /
- Use proper posture.
- Use correct fingering for all reaches.
- Keep eyes on copy or screen.
1.Complete practice and drill work.
2. Complete time writings.
Course: Computer Applications
Unit: 2- Word Processing
Standard/Benchmark / Indicators / ResourcesA. Demonstrate basic word processing skills.
B. Use advanced word processing features.
/ 1.Identify capabilities of word processing software.
2.Enter and store text in a word processing application.
3.Search for and replace text in a document stored in a word processing application.
4.Retrieve, edit and print a document stored in a word processing application.
5.Cut and paste information from one text document into another in a word processing application.
6.Create a text document containing columns in a word processing application.
7.Insert and print a graph in a word processing document.
8.Utilize the page numbering feature.
------
1.Calculate values within a table.
2.Create a document using the borders feature.
3.Create, format, edit and delete a header and/or footer within a document.
4.Use merge functions.
5.Create styles for documents.
6.Use outlining features.
7.Generate an index.
8.Generate a table of contents automatically from marked section headings.
9.Number the lines in a document automatically.
10.Create footnotes and/or endnotes within a document.
11.Create and apply macros.
Course: Computer Applications
Unit: 3 -Spreadsheet
Standard/Benchmark / Indicators / Resources- Plan, develop, use and maintain spreadsheets.
- Create basic spreadsheets.
- Use advanced spreadsheet functions to communicate information.
2.Populate and edit columns and rows.
3.Sort and retrieve data from spreadsheets.
4.Organize and present the results through graphical charts.
5.Perform various calculations using formulas and functions.
------
1.Describe the components of a spreadsheet.
2.Identify the capabilities of spreadsheet software.
3.Format spreadsheets.
4.Use basic formulas.
5.Enter and store data in a spreadsheet file.
6.Retrieve, edit and print data from a spreadsheet.
7.Create charts and graphs using information in a spreadsheet.
------
1.Sort rows alphabetically or numerically.
2.Select items that match specified selection criteria.
3.Use desktop publishing features offered in the spreadsheet application.
4.Create macros with the spreadsheet application.
5.Utilize statistics functions in spreadsheets.
6.Link files and 3D sheets.
------
- Use advanced spreadsheet functions to analyze financial and business data.
2.Use the Payment function.
3.Use the Goal Seek function.
4.Use the Solver function.
5.Use the Pivot Tables function.
6.Use the IF function.
7.Use the SUMIF function.
8.Use the Lookup function.
Course: Computer Applications
Unit: 4 - Presentation
Standard/Benchmark / Indicators / Resources- Incorporate multimedia tools into various student-produced documents.
- Use presentation software.
2.Prepare multimedia projects using various input and output devices.
------
1.Identify the capabilities of presentation software.
2.Describe the characteristics of effective presentation documents.
3.Enter and store text into a presentation document.
4.Import graphics into a presentation document.
5.Develop builds and transitions for screens and/or slides.
6.Retrieve and edit screens and/or slides.
7.Add/Delete screens and/or slides.
8.Create presentations that are compelling, professional and visually appealing.
Course: Computer Applications
Unit: 5 -Database
Standard/Benchmark / Indicators / Resources- Plan, develop, use and maintain database management systems.
- Create basic databases.
2.Populate and edit fields and records.
3.Sort and retrieve data from databases.
4.Organize and present the results of data retrieval through reports.
5.Describe search strategies and use them to solve common information problems.
6.Use online databases, Web-based sources, and other information sources to access and retrieve information.
------
1.Identify the capabilities of database software.
2.Create a database structure.
3.Construct queries.
4.Enter and store data.
5.Retrieve and modify data.
6.Delete database records.
7.Sort data in a database given predetermined criteria.
8.Output data into a report format.
9.Create a chart or graph using information in a database file.
10.Print labels from a database.
11.Print a database list and/or report.
12.Ensure data integrity.
13.Validate data.
14.Eliminate data redundancy (i.e., normalize data).
Course: Computer Applications
Unit: 6 –Web Design
Standard/Benchmark / Indicators / Resources- Create and post a basic Web page.
- Incorporate multimedia tools into various student-produced documents.
2.Describe limitations associated with Web page creation (e.g., typography, graphics file sizes, navigation).
3.Explain the importance of tags in structuring Web pages.
4.Discuss the importance of using a descriptive, useful title on a Web page.
5.Identify naming conventions for Web files.
6.Save and name Web files.
7.Identify information in HTML documents that will be ignored by browsers.
8.Set up an HTML document.
9.Format the text of a Web page.
10.Discuss considerations in selecting a graphics format.
11.Add graphic elements to a Web page.
12.Add attributes to a tag for a Web page.
13.Add hypertext links in a Web page.
14.Display a document within a Web browser.
15.Upload a Web page.
------
1.Identify and use various input and output devices.
2.Prepare multimedia projects using various input and output devices.
Course: Computer Applications
Unit: 7 –Career Development
Standard/Benchmark / Indicators / Resources- Describe positions and career paths in information technology, and explain that men and women of diverse cultures can participate in these careers.
2.Define outsourcing, identify its advantages and disadvantages, and explain how it affects information technology careers.
3.Explore and research participating colleges and universities that offer degrees in various information technology-related fields.
Course: Computer Applications
Unit: 8 –Digital Applications
Standard/Benchmark / Indicators / Resources- Incorporate multimedia tools into various student-produced documents.
2.Prepare multimedia projects using various input and output devices.
Course: Computer Applications
Unit: 9 –Application Fundamentals
Standard/Benchmark / Indicators / Resources- Apply the most appropriate applications (word processing, spreadsheet, database, presentation, collaborative groupware, Web) to record, analyze and present information.
- Integrate business software applications.
- Exhibit legal and ethical behaviors when using technologies.
2.Determine what applications are needed for the task.
3.Use the appropriate applications.
4.Communicate electronically.
5.Research information electronically.
------
1.Describe situations in which integration of software applications would be beneficial.
2.Move and copy information between applications.
3.Embed information in applications.
4.Link objects between applications.
------
1.Adhere to the organization’s policies for technology use.
2.Describe the consequences of illegal and unethical use of technology.
3.Explain property, privacy, access and accuracy issues pertaining to technology.
4.Demonstrate the ethical uses of software, hardware and the Internet.
Course: Computer Applications
Unit: 10 –Emerging Technologies
Standard/Benchmark / Indicators / Resources- Describe current and emerging technology trends.
- Describe and explain four technology advances in the past year.
- Explain two technology advances that will happen in the next five years.
- Describe how new technology advances will impact society.
- Describe disruptive technologies and their impact on society.
1