212 results
Career and technical education independent works for Microsoft Excel
Health Insurance Scenarios
Help your students figure out the cost of health insurance. Students are required to figure out the yearly medical expenses for various individuals factoring in their deductibles, stop loss provisions, and co-pays. This assignment can be done as a worksheet or having students utilizing their excel skills by filling in the spreadsheet. It is updated to reflect new health care provisions of preventative care coverage mandated through the Affordable Care Act.
Grades:
9th - 12th
Types:
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:
Excel Essentials
Excel Essentials covers the core skills that need to be learned to become a functional user of Excel. This unit also covers the skills that are required for competency in the MOS certification exam. There are instructional slideshows, a student workbook, editable Excel workbooks, puzzles and a quiz to consolidate proficiency. Excel Essentials is a complete unit with solutions for all activities – no teacher prep needed. It is suitable for teacher directed learning or self-paced or remote learnin
Grades:
7th - 12th
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
Microsoft Excel Bundle
I recommend using these four products in this order. You could also use the last one as an assessment.1. Excel Number Format Practice2. Excel Formula Practice3. Excel Formula Chart Practice4. Excel Formula and Chart Practice
Grades:
7th - 12th
Types:
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
STEM - Engineering Design Process CROSSWORD PUZZLE #1 35 Clues
This 35-clue crossword puzzle is based on a 7-step Engineering Design Process. All Content needed to solve this is included (one-page handout). This should take 1-2 class periods. SAMPLE CLUES:1 The sharing of ideas from one person to another. 2 When everyone calls out ideas and they are written down 3 As a group, you'll _____ the best solution. 6 This allows us to come up with creative ways of doing things. 9 People see things from their own ____; diverse viewpoints; 13 A test model or practi
Grades:
5th - 12th
Types:
Also included in: STEM / Engineering Design Process BUNDLE
Excel Crossword & Label Parts of Screen
This activity is a great bell ringer and way to introduce Excel or for remediation. This is a crossword puzzle and a worksheet to label parts of the Excel screen. I have provided a page with vocabulary words and definitions as well as answer keys for both activities.
Grades:
5th - 10th
Types:
Counselor career lesson activities plus career day planning sheet
This includes 5 worksheets to use during career lessons or individual sessions! They vary in difficultly so if you have multiple grade levels on your schedule you can accommodate K-12 with these worksheets! You can use them with a research project or with a book. I am also including a career day planning sheet in Google sheets format. This is editable and can help you plan the perfect career day!
Grades:
K - 12th
Types:
Junior/Senior Meeting Template for Postsecondary Plans
This Google Sheet is intended to be used by school counselors or other career counselors to discuss post-secondary plans with high school students. It has multiple tabs with embedded resources for you and your students. Each pathway has its tab that students can access depending on their needs. It is easily adaptable to fit your school's demographics, graduation requirements, local scholarship organizations, etc. I often use this starting junior year and edit until right before they graduate so
Grades:
11th - 12th
Types:
Accounting Digital Worksheets (Journal, Ledger, Worksheet, Inc. Stmt. + Bal. S )
Help your students understand the concepts of the Accounting Cycle with these color coded and user friendly Google sheets! Your students will love the pop of color and creative fonts used to complete different Accounting documents, including:General Journal, Ledger, Reconciling a Bank Stmt, Worksheet, Income Stmts for both Sole Proprietorship & Corporations, and a Balance SheetIt doesn't get better than this! Happy teaching!
Grades:
9th - 12th, Higher Education
Types:
Microsoft Excel Icon Identification Worksheet
Great for an introduction to the Excel ribbon icons or as a review. Commonly used Microsoft Excel icons and commands are shown. Students identify the name of the icon, give a description of its function, and draw a picture that demonstrates understanding of its function. You may choose to have students use Microsoft Excel to help complete the worksheet (especially if using as an introduction) or complete it from memory. Also a great worksheet for a substitute to use.
Grades:
7th - 10th
Types:
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
Library of Excel Workbook Solutions for Learning and Teaching
The Library of Excel Workbook Solutions for Learning and Teaching contains over 100 workbook files and solutions for everything from simple workbooks demonstrating basic concepts to complex loan calculators to sales plans, budgeting tools, stock evaluators, personal and business financial planning, resource planning and much more. Bonus - DashboardsIncluded in this package is a bonus………Advanced Dashboards. A set of stunning business intelligence dashboards to further your learning and teaching
Grades:
8th - 12th, Higher Education, Adult Education, Staff
Types:
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:
Career Day Schedule
Career Day can be a BIG undertaking and keeping yourself organized is the most important aspect of pulling off such a great event! The excel workbook I have created is going to be your new best friend This schedule will help you build a master schedule for up to 50 teachers, 40 vendors and 20 time slots. You will be able to see at a glance the location of teachers for each time slot and make sure that all available time is accounted for. You can also use this to make sure lunch, restroom breaks
Grades:
Not Grade Specific
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
Calendar Creation Assignment for Microsoft Office Excel
Students follow step-by-step directions to complete a personalized calendar in an Excel spreadsheet. Used in Computer Applications in Business course, this assignment engaged students while reinforcing skills such as text alignment, column and row resizing, and general formatting. Students should have basic abilities in Excel formatting, although the step-by-step instructions guide students through the process. Would also be a great assignment to use as a review with a more experienced class whe
Grades:
7th - 10th
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:
RUBRIC FORM TEMPLATE (Excel) "Form for Writing Your Own Rubrics/Assessments"
RUBRIC FORM TEMPLATE (Excel) "Form for Writing Your Own Rubrics/Assessments" can be a real life saver when you (as a secondary teacher) are writing rubrics for an assignment of any length, including a major project. There are two different versions now available in this zip file: the EXCEL editable version (with formulas in place to automatically calculate the grades for you), and the PDF FILL-ABLE version (which does not have that capability) -- both of which have been created to save you loads
Grades:
Not Grade Specific
Types:
Adjusting Entries - Quiz Package - BAF3M, Financial Accounting Fundamentals
Comprehensive BAF3M Adjusting Entries Quiz PackageElevate your accounting class with this meticulously crafted BAF3M Adjusting Quiz Package, ideal for teachers aiming to reinforce their students' understanding of adjusting entries and worksheet preparation. This all-encompassing package includes a series of quizzes, each tailored to different points throughout the academic year, ensuring a progressive learning curve.Features:Varied Difficulty Levels: From introductory concepts in November to mor
Grades:
10th - 12th
Types:
Payrates & Payroll
The spreadsheet includes student worksheets and answer keys. Calculate gross pay in a variety of ways including overtime, commission, and piece-rate. Complete a payroll register and calculate withholding including FIT, SS, MC. Includes journalizing payroll on a multi-column journal; can be adapted for the general journal as well.
Grades:
9th - 12th
Showing 1-24 of 212 results
TPT is the largest marketplace for PreK-12 resources, powered by a community of educators.
IXL family of brands