19 results
Career and technical education homework for Microsoft Excel
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:
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:
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
Accounting Posting Practice
Some of my students STRUGGLE with calculating balances when posting to their ledgers. This is a three-page practice uses four accounts in each the general, accounts receivable, and accounts payable ledgers. I created the ledgers using Excel so they do not completely match the regular workbook students are used to, but the lines and shading are similar. The numbers include a lot of cents and some zero balances. I've included a key where the answers are bold and in red. I am including both the pdf
Subjects:
Grades:
9th - 12th
Types:
Google Sheets, Full lessons for 2 weeks
This bundle covers all basic functions for the google office product: Google Sheets. This product is similar to Microsoft Excel. ALL of the lessons are connected to tutorial videos on youtube.com.YOU DON'T HAVE TO TEACH OR PREP.EASY TO USE!Students need a google account and a computer.Download--> upload to canvas/google classroom--> publish to your students--> done!Each lesson is around 20 minutes, some are 30minutes.I suggest you to force copy all google docs: https://youtu.be/k11Om8Lo
Grades:
8th - 12th
PAYROLL REGISTER
A payroll register. Students will calculate regular pay, overtime pay, withholding taxes, and net pay.
Subjects:
Grades:
10th - 12th
Types:
Accounting: Starting with T-Accounts (Template2)
Similar to the free file available for download, this is the next step for Accounting students. Once they learn DEBITS/CREDITS, this template allows the students to work transactions utilizing debits and credits. For use before students learn about REVENUE, EXPENSE, and WITHDRAWAL accounts. Features:*Customizable account names*Auto-calculate account balances*Instant accounting equation double check for students, to see if they did the transaction correctly.
Subjects:
Grades:
9th - 12th
Types:
Also included in:Â Accounting: Introduction to Accounting Transactions (Excel Templates)
Reading a Paycheck Stub
An example of an Earnings Statement (pay stub) with questions for students to answer.
Subjects:
Grades:
9th - 10th
Types:
Monthly Budget Activity Reflection Questions & Webquest * Little Prep!
DescriptionGreat supplemental material to a budgeting or finance unit. This monthly budget activity is an Excel spreadsheet that can easily be converted to a Google Sheet; complete with items, costs, and formulas. Student LearningStudents will be given a certain monthly income (you may use tokens of your choice) and will then have to chose items based on their income, as it fits into their budget. Once completed, there are reflection questions to have students explain what they have learned.
Grades:
7th - 12th, Higher Education, Adult Education
Accounting: Introduction to Accounting Transactions (Excel Templates)
This is a template that can be used over and over again by students to break business transactions down when starting Accounting. Features:*Template that you can use over and over on different assignments.*Built in formulas to calculate account balances*Students get instant feedback with the "Accounting Equation Double Checker"
Subjects:
Grades:
9th - 12th
Types:
Excel Formula and Chart Practice
This worksheet combines formulas and charts in one practice/assessment. Included topics:AdditionSubtractionMultiplicationDivisionTotalsAverageMinimumMaximumColumn ChartPie ChartLine ChartI would use this after my Excel Formula Practice and Excel Chart products. If you like these products, check out my Excel Number Format product as well.
Grades:
6th - 12th
Types:
Also included in:Â Microsoft Excel Bundle
Accounting: T-Accounts w/ Temporary Accounts (Template3)
Building off of Template1 and Template2, this allows students to practice using T-Accounts with business transactions. Now this template has added the 3 temporary accounts (revenue, expenses, and withdrawals). Features:*Account balance calculations*Accounting equation double check, for immediate student feedback
Subjects:
Grades:
9th - 12th
Types:
Also included in:Â Accounting: Introduction to Accounting Transactions (Excel Templates)
Excel Spreadsheet Christmas Wish List
Students will use Microsoft Excel to create a list of 10 items they would like to receive as gifts this Christmas.Skills Used:Input cell dataMerge and center cellsApply number formatsResearch online Adjust column widthFormat a worksheetUse this as independent or guided practice, depending on the skill level of your students.
Grades:
6th - 12th, Higher Education
Types:
Excel Vocabulary
Twenty words I use to introduce Excel to my Computer Applications students. The 1st page is the vocabulary filled in and the second page is blank copy for students to take notes with.
Grades:
6th - 8th
Types:
Accounting Worksheet Spreadsheet
Accounting Worksheet with answers for Lemonade StandCan also be used as worksheet with other accounting practice problems
Subjects:
Grades:
9th - 12th, Adult Education
Types:
Also included in:Â Accounting Worksheet Bundle
Spreadsheet Formula Practice
Students calculate net pay for a set of employees at a retail store.
Subjects:
Grades:
9th - 12th
Types:
Practice reading an architectural ruler
This worksheet allows your students to practice measuring 1/4" = 1 ft using an architectural ruler scale. The worksheet has your students measuring down to the inch and up the 24 feet. The practice scales are large enough to see that practicing this sometimes difficult skill becomes easy. The worksheet can also be used as a quiz or test.
Grades:
7th - 12th, Higher Education, Adult Education
Types:
Accounting Multicolumn Journal
This download will save you time from creating your own journal for your accounting class! This multicolumn journal is used for the Century 21 11e Accounting textbook (blue) in chapter 1-8 but might also work for other textbooks. I created this file in Excel 2016. The top three rows are frozen so students will always see the column headings. The number columns are formatted with the comma style and everything else has the general format. I also added borders to help distinguish between the cells
Subjects:
Grades:
9th - 12th
Types:
Showing 1-19 of 19 results
TPT is the largest marketplace for PreK-12 resources, powered by a community of educators.
IXL family of brands