69 results
Business assessments for Microsoft Excel
Personal Financial Literacy Full Course Notes Bundle with Assessments and Agenda
This complete 2024 updated collection of notes covers my entire year teaching Personal Finance at the high school level and can easily be adopted for a one semester course as well.*Download the preview above to see my Cost of Housing notes from my Budgeting Unit for an example of how my notes are typically structured*This full set contains 44 sets of notes within ten major units, as well as a midterm and final project, full daily agenda (for 93 65-minute class days with links to activities used)
Subjects:
Grades:
9th - 12th, Higher Education, Adult Education
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:
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
Financial Plan Start-Up Costs Project - Entrepreneurship Google Drive (New Item)
You can also find this project included in different bundles:- Entrepreneurship Full Year Project Bundle- Entrepreneurship Semester Project BundleIf you would like the Microsoft Word version of this product, click hereI always emphasize the importance of a business' financial feasibility. This project helps walk them through the wide range of expenses a typical business could occur before even making their first sale. With an attached spreadsheet included and the expectation that the students wi
Subjects:
Grades:
9th - 12th, Higher Education, Adult Education
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:
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:
Self-Grading 10-Key Practice in Excel
This Excel file is a great way to drill 10-Key in a keyboarding class or math class, as well as re-enforce how to do formulas in Excel. The file is protected in such a way that students are unable to use Excel functions or autofill as a shortcut. They need enter an = sign followed by the numbers shown and the operation, then press enter. If their answer is correct, it will be blue and they will receive a check mark. This method allows students to self-correct and makes grading much simpler for t
Subjects:
Grades:
6th - 12th
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
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:
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:
Entry Level Spreadsheet Assignment
This Excel Basics Assignment is designed as an excellent entry-level project for students who are new to spreadsheets and want to develop fundamental skills in data organization, analysis, and visualization using Microsoft Excel. The assignment focuses on three key areas: Formatting, Formulas, and Graphing. Students will gain hands-on experience in utilizing essential features and functions of Excel while working with sample data sets. By completing this assignment, students will not only learn
Subjects:
Grades:
9th - 12th, Adult Education
Types:
BB1201 Culminating Performance Task, Introduction To Business (CPT)
BB1201 Culminating Performance Task, Introduction To Business (CPT)Unit#1 Assignment, Business Proposal with ExemplarsBusiness Proposal Pt.1Students will create their own product/ service business which will be a formal proposal. So it needs to be structured, organized, and professionalStudent Sign Up SheetStudents will put their name on a shared Google Doc and choose the list of business providedUnit #1, Exemplar #1Hotel Business ProposalUnit #1, Exemplar #2Renovations Business ProposalUnit #1,
Subjects:
Grades:
10th - 12th, Higher Education, Adult Education
Types:
Peter Parkers Financial Scenario Budget and Balance Sheet Practice
This activity allows students to use Microsoft Excel to create BOTH a realistic balance sheet and a budget based on the financial situation of the fictional character Peter Parker (better known as Spider-Man!)This activity reinforces important financial literacy topics such as pay yourself first, assets vs liabilities, and balancing a budget!
Subjects:
Grades:
6th - 12th, Adult Education
Types:
Microsoft Word 2010 Work Orders
As students work through the video assignments in this series, they are also asked to complete "work orders." The purpose of a work order is to give the student an opportunity to demonstrate what they know. Just as in the real world, an employee might be told to create a particular document that does a certain function, but would be given no step by step instructions. Students must draw from what they have learned to complete the requirements of a work order. This series has 3 work orders. Work
Subjects:
Grades:
8th - 12th, Adult Education
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:
Keyboarding-Typing- Proper Keyboarding Techniques Assessment- Student Use
Keyboarding-Typing- Proper Keyboarding Techniques Assessment- Student Use
Note: Shows 4 thumbnail images but assessment is only 1 page. Everything is neatly on one page- no columns or text is cut off going on to another page! Will look perfectly fine when you download!
This is an evaluation sheet you can use to evaluate whether or not your students have mastered proper computer keyboarding techniques. There are 14 categories to rate them on and each is worth either 7 or 8 pts. The highest poi
Grades:
5th - 12th, Higher Education, Adult Education
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
Accounting Transaction Analysis Exercise - Carlos
Accounting - Transaction Analysis Exercise - CarlosThis transaction analysis activity is a perfect way to introduce students to the world of accounting. This activity requires students to complete a General Journal, General Ledger and Trial Balance. As an additional level of difficulty, this exercise includes a cost price calculation. The resource is an excellent exam revision tool for middle school accounting classes. This exercise set is an editable excel file, but is also printable if you pre
Subjects:
Grades:
8th - 12th
Types:
VLOOKUP Excel Task: The Flower Shop (includes Excel File)
An ideal task to teach students how to use the VLOOKUP function in Excel and other essential skills.Makes learning these skills simple and easy for students. Tasks include:1. Use the VLOOKUP function to find the Markup percentage to be added to each flower arrangement.2. Format the cells in Column B to Currency.3. In the sale price column use a formula to calculate the sale price. Sale price is calculated by adding the cost to the markup percentage of the cost. Example = cost + (cost *markup)4
Grades:
8th - 11th
Types:
Showing 1-24 of 69 results
TPT is the largest marketplace for PreK-12 resources, powered by a community of educators.
IXL family of brands