Standards Database Logo
Home | Browse | Search | Purpose | History | Process | Acknowledgment| Reference

 


 


Topic: Spreadsheets/databases 

Business Education

 Standard 4.  Understands and uses accounting software and spreadsheets
  Level IV (Grade 9-12)
   Benchmark 1.Uses spreadsheet technology to prepare financial statements and reports (including charts and graphs)
    Knowledge/skill statements
     1.Uses spreadsheet technology to prepare financial statements
     2.Uses spreadsheet technology to prepare financial reports
     3.Uses spreadsheet technology to prepare financial charts
     4.Uses spreadsheet technology to prepare financial graphs
   Benchmark 2.Uses spreadsheets and databases to determine price, profit, cost, and break-even point
    Knowledge/skill statements
     1.Uses spreadsheets to determine price
     2.Uses spreadsheets to determine profit
     3.Uses spreadsheets to determine cost
     4.Uses spreadsheets to determine the break-even point
     5.Uses databases to determine price
     6.Uses databases to determine profit
     7.Uses databases to determine cost
     8.Uses databases to determine the break-even point
   Benchmark 4.Uses financial spreadsheets or accounting software for budget analysis and forecasting
    Knowledge/skill statements
     1.Uses financial spreadsheets for budget analysis
     2.Uses financial spreadsheets for budget forecasting
     3.Uses accounting software for budget analysis
     4.Uses accounting software for budget forecasting
 Standard 13.  Analyzes and interprets data using common statistical procedures, charts, and graphs
  Level IV (Grade 9-12)
   Benchmark 2.Uses tables, graphs, diagrams, and charts to obtain or convey quantitative information (e.g., manual or electronic representations)
    Knowledge/skill statements
     1.Uses tables to obtain quantitative information
     2.Uses graphs to obtain quantitative information
     3.Uses diagrams to obtain quantitative information
     4.Uses charts to obtain quantitative information
     5.Uses tables to convey quantitative information
     6.Uses graphs to convey quantitative information
     7.Uses diagrams to convey quantitative information
     8.Uses charts to convey quantitative information
     9.Uses manual representations to obtain quantitative information
     10.Uses manual representations to convey quantitative information
     11.Uses electronic representations to obtain quantitative information
     12.Uses electronic representations to convey quantitative information
 Standard 22.  Knows the characteristics and uses of industry- and subject-specific computer software programs
  Level IV (Grade 9-12)
   Benchmark 1.Uses database software to enter, sort, search, and retrieve data (e.g., sort patient records according to admission date in a hospital database; look to see if a car part is in stock for an auto repair business)
    Knowledge/skill statements
     1.Uses hospital database to sort patient records according to admission date
     2.Uses database software to see if a car part is in stock for an auto repair business
     3.Uses database software to enter data
     4.Uses database software to sort data
     5.Uses database software to search data
     6.Uses database software to retrieve data
   Benchmark 2.Uses spreadsheet software to update, add, and delete data and to produce documents (e.g., classroom grade totals, profit-loss statements, charts and graphs showing increase in customers eating at a restaurant)
    Knowledge/skill statements
     1.Uses spreadsheet software to update data in classroom grade total documents
     2.Uses spreadsheet software to add data in classroom grade total documents
     3.Uses spreadsheet software to delete data in classroom grade total documents
     4.Uses spreadsheet software to produce classroom grade total documents
     5.Uses spreadsheet software to update data in profit-loss statements
     6.Uses spreadsheet software to add data in profit-loss statements
     7.Uses spreadsheet software to delete data in profit-loss statements
     8.Uses spreadsheet software to produce profit-loss statements
     9.Uses spreadsheet software to update data in charts and graphs that show a restaurant’s increase in customers
     10.Uses spreadsheet software to add data in charts and graphs that show a restaurant’s increase in customers
     11.Uses spreadsheet software to delete data in charts and graphs that show a restaurant’s increase in customers

Technology

 Standard 2.  Knows the characteristics and uses of computer software programs
  Level II (Grade 3-5)
   Benchmark 3.Knows the common features and uses of databases (e.g., databases contain records of similar data, which is sorted or organized for ease of use; databases are used in both print form, such as telephone books, and electronic form, such as computerized card catalogs)
    Knowledge/skill statements
     1.Knows the common features of databases
     2.Knows the common uses of databases
     3.Knows that databases contain records of similar data, which is sorted or organized for ease of use
     4.Knows that databases are used in print form such as telephone books
     5.Knows that databases are used in electronic form such as computerized card catalogs
   Benchmark 4.Uses database software to add, edit, and delete records, and to find information through simple sort or search techniques
    Knowledge/skill statements
     1.Uses database software to add records
     2.Uses database software to edit records
     3.Uses database software to delete records
     4.Uses database software to find information through simple sort techniques
     5.Uses database software to find information through simple search techniques
  Level III (Grade 6-8)
   Benchmark 3.Knows the common features and uses of spreadsheets (e.g., data is entered in cells identified by row and column; formulas can be used to update solutions automatically; spreadsheets are used in print form, such as look-up tables, and electronic form, such as to track business profit and loss)
    Knowledge/skill statements
     1.Knows the common features of spreadsheets
     2.Knows the common uses of spreadsheets
     3.Knows that data is entered into a spreadsheet in cells identified by row and column
     4.Knows that formulas in spreadsheets can be used to update solutions automatically
     5.Knows that spreadsheets are used in print form, such as look-up tables
     6.Knows that spreadsheets are used in electronic form, such as to track business profit and loss
   Benchmark 4.Uses a spreadsheet to update, add, and delete data, and to write and execute valid formulas on data
    Knowledge/skill statements
     1.Uses a spreadsheet to update data
     2.Uses a spreadsheet to add data
     3.Uses a spreadsheet to delete data
     4.Uses a spreadsheet to write valid formulas on data
     5.Uses a spreadsheet to execute valid formulas on data
   Benchmark 5.Uses boolean searches to execute complex searches on a database
    Knowledge/skill statements
     1.Understands the concept of the boolean search technique
     2.Executes complex searches on a database
  Level IV (Grade 9-12)
   Benchmark 2.Knows how to import and export text, data, and graphics between software programs
    Knowledge/skill statements
     1.Knows how to import and export text between software programs
     2.Knows how to import and export data between software programs
     3.Knows how to import and export graphics between software programs