72 results
Career and technical education assessments for Microsoft Excel
Sponsored
MICROSOFT WORD & EXCEL - 14 Page Magazine Project
Will work with Microsoft Word 2010 & 2013Students are to create a 14 page magazine from scratch. It assess's all of the students abilities using all of two of Microsoft Office's Software, Word and Excel. It requires students to use Word, Excel, tables, photos, columns, hyperlinks, lists, text boxes, etc... This is an extremely creative project. Attached is a rubric, checklist (for the students to stay organized), requirements, and an example magazine I created. I recommend this as a final pr
Grades:
6th - 12th
Types:
Also included in:Â MICROSOFT WORD BUNDLE- Assignments, Projects, Quizzes, & Tests
Google Sheets Unit
Spreadsheet software is a must in Business education classes! Teach your students how to use Google Sheets and create spreadsheets. Start with a lesson, assignment and then a final project to show they are a master at using Google Sheets!This interactive and engaging unit for a Computer Applications or Technology class! Typically, this unit takes 11-12 days (60 min class periods) and is completely prepped and ready for you to use.This unit includes:1. Lesson Plan - A lesson plan with step by ste
Grades:
6th - 12th
Types:
Microsoft Excel Activities Bundle
This Bundle includes 8 engaging Microsoft Excel activities consisting of:Spreadsheet Vocabulary Word SearchExcel Timeline CreationIntro Activity: Why is Excel Useful?Excel Shopping ActivityExcel Basic SkillsExcel Budgeting ActivityExcel Star Wars ActivityExcel Surplus & DeficitThese activities will get students comfortable with using the different functions of spreadsheets in several fun scenarios. The skills in this bundle range from introductory level to intermediate/advanced. You will sav
Grades:
6th - 12th, Higher Education
Types:
Microsoft Excel Christmas Activity
Looking for an activity that allows you to assess student learning but also gets students in the holiday spirit? In this activity:Students will use budgeting and excel skills in order to shop for christmas gifts for 8 hypothetical children in need using a budget of $750. Students must stay organized by inputting all information into excel. Assesses Excel skills such as adding and renaming worksheets, identifying cells and inserting information, formatting cells, using formulas, copying and pasti
Subjects:
Grades:
8th - 12th
Types:
Also included in:Â Microsoft Activities Bundle
Google Sheets Pivot Tables Activity
I use this assignment as an introduction to Pivot Tables! In this activity, students are given the scenario that they were hired as a data analyst for a popular video game publisher. They must extract information from the data given using pivot tables in order to provide recommendations to the publisher. Students will complete a total of 3 pivot tables.Directions on how to complete the pivot tables and recommendation questions are provided on the first tab. Video Game Data is included in the sec
Grades:
6th - 10th, Higher Education
Types:
Also included in:Â Google Sheets Activities Bundle
Microsoft Excel Thanksgiving Activity
Get in the Thanksgiving spirit by having students follow step by step instructions in order to create a Thanksgiving Dinner Budget in Microsoft Excel! There are a total of 18 steps. Each step is clearly explained in a powerpoint presentation (one step per slide). You can give a copy of the directions to the students or display it on your projector/smartboard & have students follow along with you! Students will practice excel skills such as locating cells, formatting cells, sorting informatio
Grades:
7th - 12th
Types:
Also included in:Â Microsoft Activities Bundle
Accounting Journalizing Practice - Multicolumn Journal
Sometimes your students need extra practice journalizing transactions! This product is perfect for teachers who use the Century 21 Accounting Multicolumn Journal 11e, but can also be used with other editions. This extra supplement can be used after chapter 5 as either a review or assessment. An excel file for students to journalize transactions is included, but you could also make copies of a blank journal if you want to use paper. Journalizing Entries Include:Cash payments including one debit c
Grades:
9th - 12th
Types:
Accounting: Chapter 1-10 Finance Meeting Role Plays!
Students will work in groups to role play financial meetings for provided companies. Finance Meeting#1: This assignment works best once students have full knowledge of the entire accounting cycle for a sole proprietorship. (If using Century 21 Accounting General Journal, this is after learning Chapter 8).Students will:-prepare a worksheet, income statement, and balance sheet-calculate vertical analysis-analyze financial reports and provide verbal explanations-recommend suggestions for future gro
Subjects:
Grades:
9th - 12th
Types:
Excel - Count, Max, Min, Average Formulas and Sorting
This Microsoft 2010 Excel file teaches students how to use the count formula, max formula, min formula, average formula and introduces sorting. There is Excel instruction and Excel tips for each formula with practice problems for the students to solve. The final worksheet can be quickly assessed by the teacher to check for understanding.
Grades:
6th - 9th
Types:
Microsoft Excel Activity Basic Skills
This activity is for students just getting started with Excel! Students will enter data into a spreadsheet regarding a scenario in which they have just graduated high school and received money from their graduation celebration. Students will complete basic formatting and enter simple formulas. There are directions on how to complete the formatting and formulas. Answer key included!Looking for more Microsoft Excel Resources? Click the links below!Excel Back To School Shopping ActivityIntro Activ
Grades:
7th - 12th
Types:
Also included in:Â Microsoft Activities Bundle
Clean Up Schedule for Shop Class
Clean Up Schedule for Shop ClassEasily customizable to your needs!
Subjects:
Grades:
9th - 12th
Types:
Accounting Cycle Activity
Give students the opportunity to complete an activity demonstrating all parts of the accounting cycle for a sole proprietorship organized as a service business.
This activity includes electronic journals, ledgers, and financial statements as well as paper copies. (The electronic journals are great for any activity you need to use for journalizing!)
Grades:
10th - 12th, Higher Education
Types:
Oral Pathology Exam Tracking and Answer Sheet
This is the tracking and answer google sheet crated for the oral pathology exam to help keep tack of correct/incorrect answers and used as an answer key.
Subjects:
Grades:
11th - 12th, Higher Education
Types:
Microsoft Excel Lessons PowerPoint BUNDLE
Three PowerPoint lessons with Excel sheets, Tests, Rubrics, and Answer Keys.Lesson 1: (Football Statistics)Basic formatting skills such as word wrapping text in a cell and drawing boxes around cells,How to sort data,writing formulas to determine net receiving yards, average number of carries per game, average number of yards gained per game, and the percentage of total yards that each player contributed to the season.Using the formula builder to quickly calculate the sum totals and the overall a
Grades:
8th - 11th
Microsoft Excel Activity Timeline Creation
In this activity, students will create a timeline for multiple categories (personal, historic, etc.) for every year since they were born using Microsoft Excel. They will use computer & excel skills such as researching, inputting data into specific cells, formatting borders, fill color, inserting shapes/pictures.Looking for additional engaging excel activities? Check out the resources linked below!Why is Excel Useful?Star Wars ActivityBudgeting in Excel
Grades:
6th - 12th
Types:
Also included in:Â Microsoft Activities Bundle
Break Even Analysis Template
Students can use this break-even analysis template to determine the break-even point for a hypothetical company. The template includes the necessary formulas in an Excel document to calculate the exact point at which the company will break even.
Grades:
11th - 12th, Higher Education
Types:
Accounting Monopoly Project (Full Accounting Cycle)
This is a multiple week/Semester long Monopoly Accounting Project that allows students to get out of their seats, interact with their peers, be competitive while having fun, all while continuing to learn and implement principles taught in Accounting I.
Grades:
9th - 12th
Types:
Basic Computer Skills SGO Assessment - Task Analysis Checklist
This is a 13 page document that I used for my Student Goal Objectives for this year for a special education high school level Introduction to Computers/ Performing and Visual Arts Class.
I used this as a Pre and Post-Test to measure improvement and growth in my students in basic computer skills. I read the directions/transcripts that I wrote (included in the package) to each students and used the task analysis sheet to track whether or not they were able to complete each task. The test include
Grades:
6th - 12th, Higher Education, Adult Education
Types:
GLC2O - Unit 3 - Life Planning & Culminating (Complete Unit Bundle)
This is the Complete Unit 3 (Life Planning) Bundle of my GLC2O Careers Class including two culminating activities.Includes the following topics:1) Understanding and setting Smart Goals (PPT and Activity)2) Banking in Canada (Reading and Activity)3) Budgeting Intro Activity 4) Personal Budgeting (PPT, Excel examples, and Activity)5) Culminating Activity (two choices)
Subjects:
Grades:
7th - 10th
Types:
Also included in:Â CHV2O / GLC2O - Full Civics and Careers Semester Bundle
PERSONAL WORK HABITS RUBRIC (FILL-IN Excel & PDF Versions)
PERSONAL WORK HABITS RUBRIC (FILL-IN Excel & PDF Versions) - This is the most important assessment tool you (the teacher) will need and use with your ENTREPRENEURSHIP 101 student company members. This rubric is a tool that is most useful when evaluating student participation in an entrepreneurial activity where the whole grade depends upon what students do and accomplish on a daily basis plus how they interact with one another in a team (departmental) environment. It is totally up to you
Grades:
7th - 12th
Types:
Accounting Equation Bundle
This bundle has two of my resources for the Accounting Equation- Opening lessons, 10 transactions in Word form, and a set of 20+ transactions. The second item is Excel practice using the accounting equation to balance. This is what we use to show mastery. There is an excel Practice Problem and Test set (2 versions)
Subjects:
Grades:
9th - 11th
Types:
Microsoft Excel Activity Star Wars
In this Introductory level spreadsheet activity, students will complete a star wars themed excel activity. Students will apply spreadsheet skills such as: · Formatting spreadsheets· Inputting formulas· Adjusting numbers and data· Formatting landscape, gridlines, headers, footers· Using function icons, etc. Looking for additional Excel Activities? Click the links below!Excel Christmas ActivityBasic Skills in ExcelNew Years Activity in ExcelExcel Timeline ActivityBudgeting in Excel
Grades:
6th - 12th
Types:
Also included in:Â Microsoft Activities Bundle
Spreadsheet Class Starter
Make Students Write their own Formulas!! This activity consists of 5 simple worksheets in 1 workbook (Excel) where students have to write their own formulas with no directions. After I have explained simple formulas and basic functions to students, I use this as a reinforcement activity. At the beginning of each period, I put up one worksheet on my Smart Board and have students supply formulas to solve the problem. GREAT CLASS STARTER! Problem topics include: Family Camping Trip, Let's Go
Grades:
7th - 12th, Higher Education, Adult Education
Microsoft Excel Lessons Video BUNDLE
Three video lessons with Excel sheets, Tests, Rubrics, and Answer Keys.Lesson 1: (Football Statistics)Basic formatting skills such as word wrapping text in a cell and drawing boxes around cells,How to sort data,writing formulas to determine net receiving yards, average number of carries per game, average number of yards gained per game, and the percentage of total yards that each player contributed to the season.Using the formula builder to quickly calculate the sum totals and the overall averag
Grades:
8th - 11th
Showing 1-24 of 72 results
TPT is the largest marketplace for PreK-12 resources, powered by a community of educators.
IXL family of brands