39 results
Adult education instructional technology resources for Microsoft Excel
Microsoft Excel Spreadsheet and Graph Skills Digital Resources - Fast Food
Students have to read through the tasks on the worksheet to change the data held in the Fast Food Menu Spreadsheet and to create graphs. Students will learn the impact that changing spreadsheet data has on graphs. They will also learn how to analyz e data held in spreadsheets and graphs. This resource comes with the following: Fast Food Menu Spreadsheet WorksheetTask Cards/Help Cards The following skills are taught in detail: Creating graphsFormatting graphs Analyzing Spreadsheet DataInserting s
Grades:
5th - 11th, Adult Education, Staff
Types:
Also included in: Microsoft Excel Spreadsheets Ultimate Bundle - Computer Applications
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:
Introduction to Excel Formulae Lesson Plan
This fantastic lesson allows children to make link between Maths and Excel Spreadsheets. It also introduces the very basics of Excel Spreadsheets by introducing the following key terms in a very child friendly manner: • Cell • Row• Active Cell• Column • Worksheet • Cell ReferenceAlongside the above, children are introduced to very basic calculations in Excel Spreadsheets. This resource includes the following: • Editable and animated PowerPoint presentation • PDF version of the powerpoint• Lesson
Grades:
1st - 11th, Adult Education, Staff
Excel Spreadsheets Million Dollars Activity
This resource allows students to understand the following: How graphs change when spreadsheet data is alteredUse of SUM() functionsHow graphs are madeComponents of a graphAdvantages of spreadsheets over pen and paper methodsStudents use this resource to understand how altering data in spreadsheets allow graphs to change. They understand such concepts by trying to spend a Million Dollars in a minute. Students are then expected to complete the associated worksheet which accompanies the spreadsheet
Grades:
5th - 12th, Adult Education
Types:
Excel Spreadsheets Pocket Money Activity
A Microsoft Excel worksheet activity which tests students’ knowledge on the following skills: 1) Cell referencing2) Use of simple formulae/calculations such as addition, subtraction, multiplication and division. 3) Use of Sum() function 4) Making predictions by changing dataOther Microsoft Excel Products Available:• Microsoft Excel Bundle 1: Click Here• Microsoft Excel Bundle 2: Click Here• Grades 1- 4: Microsoft Excel The Bundle: Click Here• Excel Spreadsheets - Lesson Book & 7 Different Sp
Grades:
5th - 12th, 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:
Introduction to Excel
Learn the basics of Excel with this innovative resource. The hands-on workbooks provide instruction and activities about the fundamentals of formatting cells, calculating and creating charts as introductory activities to the world of Excel. Complete lessons with solutions are provided – no teacher prep needed. It is great for beginners or revision at the beginning of a course. The learner initially works in 4 editable Excel workbooks that teach and provide appropriate activities at the same time
Grades:
7th - 10th, Adult Education
Types:
Keyboarding-Typing- Numeric Keypad Assignment with Evaluation Sheet
Keyboarding-Typing- Numeric Keypad Assignment with Evaluation Sheet
This zip file download contains everything you need to teach a lesson on learning the numeric keypad. The first item in the download is a Word document that introduces students to the numeric keypad- how to use it, features, what finger goes on each key, etc. It also contains directions for the actual typing exericises. The 2nd item in the download is an Excel spreadsheet consisting of 5 sheets that contain exercises for learni
Grades:
5th - 12th, Adult Education
Types:
The Ultimate Teachers Markbook & Assessment Log
READY TO USE OR PRINT! EDITABLE DOCUMENT!Change the way you record your student assessments. Use this ultimate teachers markbook & assessment log to input and keep a clear track of student assessment marks across the school year. Track student progress and keep your marking organised and up-to-date. This markbook will allow you to record marks for various classes, subjects and students. Get organized this year!• Digital Markbook - Simply follow the included instructions to enter your data.•
Grades:
PreK - 12th, Higher Education, Adult Education, Staff
Types:
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:
Microsoft Excel - Pinky's Spreadsheets (Worksheet Task)
A brilliant set of worksheets which allows students to deduce information from
worded spreadsheet scenarios in a child friendly manner. This worksheet should last for at least 2 lessons (depending on the ability of your children).
Many thanks to KindergartenWorks for use of fomt LesliesHand: https://www.teacherspayteachers.com/Product/KindergartenWorks-Font-Leslies-Hand-327383
The following skills are covered:
- Understanding formulae
- Writing formulae
- Modifying formulae
- Designing sprea
Grades:
5th - 11th, Adult Education, Staff
Types:
Also included in: Microsoft Excel Spreadsheets Ultimate Bundle - Computer Applications
Statistics Project Unit 3 Spreadsheets Mean Median Mode Std. Deviation (2 day)
This is a 1-2 day project aimed at introducing a statistics class to Excel (or Numbers) who are familiar with Pie Charts, Bar Charts, Measures of Central Tendency, and Standard Deviation. The students will input data (included) into Excel (on fires in restaurants), form their own Bar Charts and Pie Charts, and be able to input formulas into the Excel to automatically calculate statistics. Students will be given the opportunity to explore different charts and design their charts to make them colo
Subjects:
Grades:
9th - 12th, Higher Education, Adult Education
Student Password Cards
Put up to 6 user names and passwords. Just type the passwords and it will automatically create a password card for each student. Print for students or if you prefer keep them for your own records.
Click on Preview to see a video showing the spreadsheet.
If you like this please follow us and share with your friends.
Grades:
PreK - 12th, Higher Education, Adult Education, Staff
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 Spreadsheets - Pinky's Lunchtime
A nice activity to either complete in Excel or on paper which encourages students to read spreadsheet scenarios and perform calculations on them to make decisions. This set of worksheets expect students to practise using the following calculations:
= Sum()
Multiplication
Division
Subtraction
= Average()
Other Microsoft Excel Products Available:
• Microsoft Excel Bundle 1: Click Here
• Microsoft Excel Bundle 2: Click Here
• Grades 1- 4: Microsoft Excel The Bundle: Click Here
• Excel Spreads
Grades:
5th - 10th, Adult Education, Staff
Types:
Also included in: Microsoft Excel Spreadsheets Ultimate Bundle - Computer Applications
Keyboarding-Typing- Touch Typing Assessment
Keyboarding-Typing- Touch Typing Assessment
This assessment is to be used to test students' knowledge of the letter keys on the computer keyboard. There are two parts. Part 1 tests the students knowledge of striking each letter key by using the proper finger and then actually striking the correct key. Part 2 (WHICH IS ON SHEET 2) has the students type the pangram sentence- The quick brown fox jumps over the lazy dog.
To give the test, you would watch each student individually . You can have t
Grades:
5th - 12th, Adult Education
Types:
Customized Automated Score Sheet MC and Open Response Test w/ Graphs
This re-usable 2 Part Test Score Sheet will grade your MC responses and give item analysis with number listing as well as line graphs based on whole group and class performance. PURCHASE OF THIS TEMPLATE COMES WITH ASSISTANCE SETTING IT UP FOR YOUR TEST- SAME # OF QUESTIONS, ANSWER KEY SET-UP, ETC.; Entering the MC responses and Open Response Scores will be the most difficult part of creating this document which will give you instant feedback on items for remediation. Check out the preview do
Grades:
3rd - 12th, Higher Education, Adult Education, Staff
Types:
Microsoft Excel - Analysing Spreadsheets
This set of worksheets expects students to read the scenarios and answer the questions associated with them.
Student will be expected to recall their knowledge on using the following calculations:
= sum()
multiplication
subtraction
what if questions
making predictions based on data held in spreadsheets.
These worksheets can be used as part of the main lesson or for homework.
Many thanks to KindergartenWorks for use of font LesliesHand: https://www.teacherspayteachers.com/Product/Kindergarte
Grades:
5th - 11th, Adult Education, Staff
Types:
Also included in: Microsoft Excel Spreadsheets Ultimate Bundle - Computer Applications
ExcelHow2: A guide to understanding Excel spreadsheet software
Ideal to support the delivery of GCSE, BTEC and ECDL ICT courses!If you like the quality of my other resources, you won't want to miss this!!!A comprehensive guide on a broad range of differentiated Excel skills which include;Data Types: Raw, Changing Type, Relative & Absolute Cell ReferencingFormatting: Cells, Colours, Font & BordersBasic Arithmetic Formulas: Simple arithmetic (+ - * /), Relative & Absolute Formulas, Common ErrorsFunctions: SUM, AVE,MIN, MAX, COUNT, COUNTA, ROUNDAdv
Grades:
6th - 10th, Adult Education, Staff
Types:
Also included in: Excel Bundle
Excel Charts
This resource is for those new to creating Charts in Excel. There are step by step instructions within the 10 page training manual to learn how to create and modify bar charts and pie charts. It is a ready to go lesson that requires no further prep. This is a 2 hour lesson that has tasks for learners to complete.Learning Objectives: Create a simple bar chart with existing data. Create a simple pie chart to show percentages Modify bar and pie charts to enhance presentation and update details.T
Grades:
9th - 12th, Higher Education, Adult Education
Types:
CCSS:
Also included in: Microsoft Excel Bundle
Excel Spreadsheet - Making it Visual
Teach Excel Spreadsheets by making it fun!No stuffy textbook lesson here!From scratch, you will complete the following:Enter data in cellsFormat the data and numbersApply cell bordersCreate an Excel tableApply cell shadingFilter your dataSort your dataCreate a formulaChart your dataPrint your worksheetMy Other Product Categories© Information Technology⏰ PowerPoint⏳ Puzzles☕️ Food Sciences⚔️ Social Studies⚙️ PhotoShop⚡️ Photography⚱️ Pottery✂️ Visual Arts Education✅ FREE!❤ TeachersThank you for c
Grades:
8th - 12th, Higher Education, Adult Education, Staff
![Preview of [FULL COURSE] Microsoft Excel Spreadsheets](https://ecdn.teacherspayteachers.com/cdn-cgi/image/format=avif,quality=70,width=525,height=525,onerror=redirect/thumbitem/-FULL-COURSE-Microsoft-Excel-Spreadsheets--4612038-1656585340/750f-4612038-1.jpg)
[FULL COURSE] Microsoft Excel Spreadsheets
This is the new activity I have created using real data from online sources with regards to Global Warming, Climate Change and Sustainability figures. This is using Excel Spreadsheets, but can be opened with any spreadsheets program / converted to suit.it is intended as a group research activity in which I would demonstrate how to solve the questions by researching solutions online.After demonstrating, I get the students to complete it again together in groups in order to get them started.The st
Grades:
7th - 12th, Adult Education, Staff
Types:
Also included in: Ultimate Computer Science BUNDLE
Excel - Chart Analysis in Spreadsheets
An excellent resource to allow students to reinforce their subject knowledge on creating and reading charts/graphs in Excel. Can be used as a homework or classwork.
Other Microsoft Excel Products Available:
• Microsoft Excel Bundle 1: Click Here
• Microsoft Excel Bundle 2: Click Here
• Grades 1- 4: Microsoft Excel The Bundle: Click Here
• Excel Spreadsheets - Lesson Book & 7 Different Spreadsheets: Click Here
• Introduction to Excel Spreadsheets & Formulae Lesson Plan: Click Here
• Goo
Grades:
5th - 10th, Adult Education, Staff
Types:
Excel - Absolute Cell Referencing Worksheet
This worksheet can be given at the start of the lesson or set for homework. It gives students an opportunity to write down what they know and understand about Absolute Cell Referencing.
Other Microsoft Excel Products Available:
• Microsoft Excel Bundle 1: Click Here
• Microsoft Excel Bundle 2: Click Here
• Grades 1- 4: Microsoft Excel The Bundle: Click Here
• Excel Spreadsheets - Lesson Book & 7 Different Spreadsheets: Click Here
• Introduction to Excel Spreadsheets & Formulae Lesson P
Grades:
6th - 12th, Adult Education, Staff
Types:
Showing 1-24 of 39 results
TPT is the largest marketplace for PreK-12 resources, powered by a community of educators.
IXL family of brands