Introduction to MS Excel
Spreadsheet Standards Aligned with the BCTE Frameworks
Vocational Technical Education Framework
Business & Consumer Services Occupational Cluster
Business Technology (VBUS)
June 2014
In this course we will cover some, not all standards, listed.
2.I.01 Performance Examples:
Students will build a spreadsheets based on simulated business functions, ie. address book, price list, customer data, inventory, sales spreadsheets and charts Student will filter information in a spreadsheet, to show specific information.
2.I.03 Performance Examples:
Students will create a customer list for a simulated business and apply sorts and filters. Students will develop a budget for a simulated business, business project, or personal scenario; using simple formulas. Students will create sales spreadsheets and charts.
2.I Essentials of Spreadsheet Development
2.I.01 Create, edit, format and print a spreadsheet.
2.I.01.01 Enter, edit, format and proofread data in rows and columns.
2.I.01.02 Differentiate between the various ways to view a spreadsheet.
2.I.01.03 Describe and demonstrate the use of page orientation and setting margins.
2.I.01.04 Format a spreadsheet using borders, shading, headers and footers. 2.I.01.05 Apply conditional formatting to data in a spreadsheet.
2.I.01.06 Demonstrate how to link information on a spreadsheet.
2.I.01.07 Differentiate between the various ways to print a spreadsheet.
2.I.02 Insert elements and other items into a spreadsheet.
2.I.02.01 Create, insert and format graphics and pictures in a spreadsheet.
2.I.02.02 Create, insert and format a chart and a pivot table in a spreadsheet
2.I.03 Utilize advanced spreadsheet development features.
2.I.03.01 Utilize the comments feature to review and collaborate on a spreadsheet.
2.I.03.02 Create, insert and format a simple and custom sort.
2.I.03.03 Create, insert and format a basic, advanced and custom filter.
2.I.03.04 Utilize advanced features to automate, integrate and share information.
2.I.03.05 Create, insert and format simple and complex formulas.
Excel Tutorials:
Here are the three tutorials:
Here are the three tutorials:
See lessons page for the items below,
do not use this page
for
Excel Exercises!
do not use this page
for
Excel Exercises!
Click this button to return to the Excel Projects Page!
Project E-1 Undergraduate Admissions
e-1_undergraduateenrollment.pdf | |
File Size: | 130 kb |
File Type: |
Project E-2 Market Analysis
proj_e-2_marketanalysis.pdf | |
File Size: | 91 kb |
File Type: |
Project E-3 Employee Roster
proj_e-3_employeeroster.pdf | |
File Size: | 109 kb |
File Type: |
Project E-4 Top Selling Products
proj_e-4_top-selling_products.pdf | |
File Size: | 142 kb |
File Type: |
Project E-5 Employee Productivity Report
proj_e-5_employee_productivity_report.pdf | |
File Size: | 196 kb |
File Type: |
Project E-6 Event Budget
proj_e-6_event_budget.pdf | |
File Size: | 153 kb |
File Type: |
Project E-7 Nutritional Facts
proj_e-7_nutritional_facts.pdf | |
File Size: | 117 kb |
File Type: |
Project E-8 Dessert Take Out Menu
proj_e-8_dessert_take_out_menu.pdf | |
File Size: | 167 kb |
File Type: |
Project E-9 Accounts Payable
e9_accounts_payable.pdf | |
File Size: | 278 kb |
File Type: |
Project E-10 Inventory Markup
e10_inventory_markup.pdf | |
File Size: | 232 kb |
File Type: |
Project E-11 Sales Projection
e11_sales_projection.pdf | |
File Size: | 197 kb |
File Type: |
Project E-12 Football Player Statistics
e12_football_player_statistics.pdf | |
File Size: | 264 kb |
File Type: |
Project E-13 Most Popular Services
e13_most_popular_services.pdf | |
File Size: | 178 kb |
File Type: |
e13_most_popular_services_pie_chart_exemplar_13.2.pdf | |
File Size: | 118 kb |
File Type: |
Project E-14 Sales History Chart
e14_sales_history_chart.pdf | |
File Size: | 236 kb |
File Type: |
Project E-15 Sales Forecast Chart
e15_sales_forecast_chart.pdf | |
File Size: | 256 kb |
File Type: |
Project E-16 Vocabulary List
e16_vocabulary_list.pdf | |
File Size: | 14 kb |
File Type: |
Project E-17 Top 5 Rides
e17_top__5__rides.pdf | |
File Size: | 99 kb |
File Type: |
Project E-18 Expense Pie Chart
e18_expense_pie_chart.pdf | |
File Size: | 141 kb |
File Type: |
Project E-19 Annual Admissions Tickets Sales Revenue
e19_annual_admissions_ticket_sales_revenue.pdf | |
File Size: | 133 kb |
File Type: |
data_sheet_19.1_excellent_adventures_annual_admissions_ticket_sales_revenue.docx.pdf | |
File Size: | 178 kb |
File Type: |