119 results
Higher education computer science resources for Microsoft Excel
Task/Help Cards (Formula Practice) for Google Sheets™ & Excel Spreadsheets
A wonderful set of 12 task/instruction cards which can be printed and laminated and then given to students to help them learn and practice the following formulae/calculations in Excel or Google Sheets; • Addition • Subtraction • Division • Multiplication• =sum()• =max()• =min()• =average() • =count()• =counta()• =countif()Each card provides a clear description and example of how specified formulae work in Excel and Google Sheets, thus a brilliant visual learning aid. These task cards can also be
Grades:
5th - 12th, Higher Education, Adult Education, Staff
Types:
MICROSOFT EXCEL: Patriotic 50 States Project Using Formulas & Functions
Students will use Microsoft Excel and Internet Research skills to complete this project. Students will navigate the internet using a specific website and find information about states, fill in a spreadsheet, and use functions such as SUM, MIN, MAX, AVERAGE, and IF to calculate data results. High school and middle school students learning Microsoft Excel will explore the Internet and use data entry skills and formulas to complete this project. Students should have basic knowledge of formulas befo
Grades:
6th - 12th, Higher Education
Types:
Google Sheets Activities Bundle
This bundle includes 12 engaging Google Sheets Activities consisting of:Introductory level (Shows students why spreadsheets are useful and efficient)Intermediate level (formatting, sorting, formulas)Advanced level (conditional formatting, pivot tables)Links to the Products included in this bundle:Intro Activity: Calculator VS SpreadsheetSpreadsheet Vocabulary Word SearchGoogle Sheets Basics Google Sheets Budgeting ActivityGoogle Sheets Functions ActivityPivot Tables ActivityGoogle Sheets Large D
Grades:
6th - 12th, Higher Education
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:
Grocery Shopping & Meal Planning Spreadsheet Activities Google Sheets Excel
100% DIGITAL AND EDITABLE Interactive Spreadsheet Activities – Two Google Sheets/Microsoft Excel Activities will teach your students how to online grocery shop. Students will learn to navigate an online grocery store website, determine current price of grocery items, determine brand and size/unit/count, etc., locate sale items, and compare prices. Students will learn just how much groceries cost! Downloads in Google Sheets and works perfectly in Microsoft Excel. Includes a link for students to o
Grades:
8th - 12th, Higher Education
Excel Practice Bundle #1
Help your students ACE Microsoft Excel with a bundle of 10 short practice activities. In my classroom, I use these as bell ringers. They each take about 10-15 minutes to complete. They come complete with start file downloads, video tutorials, and completed keys so students can check their work. These can be used as reviews for the MOS exams, bell ringer activities, or as stand-alone learning activities.Each activity covers different skills/tools in Excel. Here is a list of skills/tools cove
Grades:
8th - 12th, Higher Education, Adult Education
Types:
Microsoft Excel 2016 Project- Films (Highest Grossing of All Time)
Microsoft Excel 2016 Project- Films (Highest Grossing of All Time)
This is a fun project for students to do at the end of a unit on Microsoft Excel to demonstrate what they have learned. For this project students will utilize a website to obtain data about the top 10 highest grossing movies of all time. UNDERSTAND EACH TIME YOU DO THIS ASSIGNMENT THE MOVIE DATA MORE THAN LIKELY WILL BE DIFFERENT. Students will have a handout to record the data. Students will then enter that data in Excel and be
Grades:
6th - 12th, Higher Education, Adult Education
Types:
Teach Google Spreadsheet Skills
Teach your students the basic tools in a spreadsheet.try it out here: https://goo.gl/koTuKWThis spreadsheet activity guides students through the basics of:spreadsheet as a calculatormoving cells vs dragging cellscreating listsperforming calculations on listsgraphing and best-fit linesIt also includes two questions that ask students to apply their skills.see video above or view it in action hereFor more advanced google spreadsheet functions, see this resource.<a google/gmail account is require
Subjects:
Grades:
7th - 12th, Higher Education, Adult Education
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 Word & Excel Lessons - Entrepreneur Project
This Entrepreneur Project is designed to teach students how to use computer applications as they would for a business. The scenario – a Pet Sitting business. Kids love pets and pet sitting is something students could really do in real-life, in their own neighborhood and at a young age so that is why Pet Sitting was the perfect choice for the business scenario. Students will create a their own business name, tagline, and decide on a "logo" to use.There are 10 ready-to-print activities (plus an En
Grades:
7th - 12th, Higher Education
Types:
Microsoft 365 - Excel Ribbon Labeling Worksheets / Slides
This is an assignment that has the students label the Microsoft 365 Excel Ribbon. The activity goes through each tab of the ribbon as well as a few extras. A KEY is also included.This is is Google Slide file. It comes fully editable. You can choose to use one slide or section of the ribbon labeling exercise or all of them. You can choose to assign this as a digital lesson or print it out as worksheets.
Grades:
5th - 12th, Higher Education, Adult Education
Types:
Google Sheets Thanksgiving Activity
Get in the Thanksgiving spirit by having students follow step by step instructions in order to create a Thanksgiving Dinner Budget in Google Sheets! There are a total of 17 steps. Each step is clearly explained in a google slides 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 spreadsheet skills such as locating cells, formatting cells, sorting inf
Grades:
6th - 12th, Higher Education
Types:
Also included in: Computer Applications Holiday Bundle
Google Sheets Formulas Activity
In this activity, numerical data for calories, number of items sold, and price per item are given. Students will enter basic formulas to calculate items such as revenue and average calories such as:Sum FormulaAutofillAverage FormulaMultiplicationSubtraction .There is a total of 22 cells that students will enter a formula into.Answer key included!Looking for additional spreadsheet activities? Check out the resources below!Intro to Spreadsheets SlideshowGoogle Sheets Intro to Conditional Formattin
Grades:
6th - 12th, Higher Education
Types:
Also included in: Google Sheets Activities Bundle
Google Sheets Budget Activity
In this activity, students will create a monthly budget to determine whether they have enough money saved to go on a camping trip.Google sheet skills to be applied include:formulasformattingfilling down/rightinserting various charts, and moreI consider this activity to be intermediate level because I do not give students the formulas to use as I do in beginner level activities. Students must decide which formulas and functions to use.Looking for additional Google Apps Activities? Click the links
Grades:
6th - 12th, Higher Education
Types:
Also included in: Google Sheets Activities Bundle
MICROSOFT EXCEL: Christmas Spreadsheet Using 3D and Absolute Cell References
This is an assignment for students in grades 6-12 learning about spreadsheets to practice using formulas such as absolute cell references, 3D cell references, SUM function and practice formatting techniques. This is an intermediate activity which requires students to have basic knowledge about Microsoft Excel or other spreadsheet programs. Students will have to type information into a spreadsheet and use formulas to calculate results. File type will be in zipped folder with PDF of worksheet and
Grades:
6th - 12th, Higher Education
Types:
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:
Google Sheets Introduction Activity
Spreadsheets can be tricky for students to comprehend & sometimes they have trouble understanding the usefulness of spreadsheets!Give students the following assignment to complete using a simple calculator, paper, and pencil.After students have completed the first section, students will complete the SAME assignment using Google Sheets so they can compare the difference in time and efficiency.The assignment will include data, finding averages, changing/ adding information, and sorting and wil
Grades:
6th - 12th, Higher Education
Types:
Also included in: Google Sheets Activities Bundle
Christmas Excel Project
Need a formative or summative assessment for Excel? Then this project is for you! Students are given a budget for planning a Christmas dinner. This Christmas Dinner Excel Project tests students' knowledgeof Excel basics, formatting, formulas, functions, and charts. This project also incorporates essential "real life" skills such as budgeting, organization, critical thinking, and mathematical skills.This product includes:-Teacher instructions-Student handout-Project rubric-Sample solution file
Grades:
9th - 12th, Higher Education, Adult Education
Also included in: Excel Project Bundle
Introduction to Formulae in Excel Lesson Plan
This fantastic lesson teaches children about the basics of Excel formulae in a child friendly manner. It teaches them about cell references first before incorporating cell references into formulae.
This resource includes the following:
• Editable and animated PowerPoint presentation
• PDF version of the powerpoint
• Lesson plan indicating how the lesson can be delivered
• 2 worksheets (included in the presentation) which can be printed out for students.
A good teacher demonstration resour
Grades:
3rd - 12th, Higher Education, Staff
Excel - Absolute Cell Referencing Spreadsheet Tasks
A set of Excel Spreadsheet Tasks which allow students to practice their Absolute Cell Referencing skills. It also allows them to identify the difference between the absolute cell referencing and relative cell referencing,
Grades:
7th - 12th, Higher Education, Adult Education, Staff
Types:
Google Sheets 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 spreadsheet 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 Google Sheets.Assesses Google Sheet skills such as adding and renaming worksheets, identifying cells and inserting information, formatting cells, using formulas
Subjects:
Grades:
7th - 12th, Higher Education
Types:
Also included in: Computer Applications Holiday Bundle
Google Sheets Activity
This individual activity is for students just getting started with Google Sheets as there are step by step instructions explaining how to complete each task! 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. Looking for more Google Applications Acti
Grades:
6th - 12th, Higher Education
Types:
Also included in: Google Sheets Activities Bundle
Microsoft Excel Functions Workbook, Volume 2 (BUSINESS MATH)
NOTE: Check out Microsoft Excel Functions Workbook, Volume 1!This is an Excel 97-2003 workbook collection of 15 project-based, problem solving spreadsheet exercises (with complete keys - SEE PREVIEW) that help students learn to use the following powerful Microsoft Excel functions:SUMAVERAGEIFCOUNTIFCOUNTBLANKEach exercise generally takes between 1 and 2 full class periods to complete. I take 10-15 minutes to explain the problem, the deliverable, and the tools, and then let the students work inde
Grades:
8th - 12th, Higher Education, Adult Education, Staff
Types:
Excel Business Project
Comprehensive Excel project for high schoolers or higher education. Requires students to create a business that they will pretend to run for two weeks. They will organize their business data in several tabs, including an inventory list, invoices to customers, total sales, order list for next week, payroll, expenses, and total income. The project applies what students have learned about formulas, functions (including SUM, SUMIF, and VLOOKUP), charts, tables, dropdown lists, and more. This package
Subjects:
Grades:
9th - 12th, Higher Education, Adult Education
Types:
Showing 1-24 of 119 results
TPT is the largest marketplace for PreK-12 resources, powered by a community of educators.
IXL family of brands