36 results
Computer science handouts for Microsoft Excel
Formulas in Google Sheets
Use formulas to add averages, totals, & more to your spreadsheets.
Walk students through the process of creating different types of formulas in Google Sheets. Packet includes printable resources, demonstrations of skills through YouTube screencast (Writing your first formula), and link to Google Sheets template that students can use to complete hands-on activities.
Aligned to the following Massachusetts Technology Literacy Standards, grades 6 through 8
G6-8: 1.12 Describe the use of spreads
Subjects:
Grades:
5th - 8th
Types:
Super Bowl Excel Project
About this product:This project was created for students with beginner to intermediate knowledge of Microsoft Excel. You may make any changes to fit the needs of your students. This project can be used with any spreadsheet application including Google Sheets and Numbers.This project includes:Teacher instructionsStudent handout Sample solution fileProject Rubric Terms of Use:You are welcome to make copies for your classroom for personal use. Please keep my copyright information at the bottom o
Grades:
6th - 12th, Adult Education
Types:
Also included in: Excel Project Bundle
Create a crossword puzzle with any version of Microsoft Excel
This lesson deals with any version of Microsoft Excel. The student will create a 10 word crossword puzzle with appropriate formatting.The student will review: resizing columns and rows, formatting cells, adding borders and shading, inserting comments, and conditional formatting.
Grades:
9th - 12th, Adult Education
Types:
Video Game Development Timeline of Contributions 4000BC-present
Career Training Instruction Video Game DevelopmentThis amazing timeline sums it all up - what inventions, countries, and technological feats brought us to video games?Organized for a visual learner with STEAM-minded categories, the Video Game Timeline of color-coded categories is the right mix for most learning styles.This Timeline has been created for any middle school, high school, career training, college, or professional organization to view a range of inventions and events that have contrib
Grades:
6th - 12th, Higher Education, Adult Education, Staff
Middle School Excel Assignment- Create A Gradebook
This assignment was created for a 7th grade Computers class learning Microsoft Excel. The assignment requires the students to create a grade-book for "an imaginary" class. The skills incorporated in this assignment include: inserting headers, formatting cells as a table, alphabetizing, using formulas and filtering data. There are step-by-step instructions given but they don't replace a teacher's instructions. Certain skills on this assignment were review for my class so I didn't give the student
Subjects:
Grades:
6th - 8th
Excel Spread Sheet Formulas
This is an information sheet explaining and giving examples of the more commonly used Excel formulas The cells and numbers are only an example - you will need to change the cells and numbers to relate to each spread sheet.
Grades:
7th - 12th, Higher Education
Types:
Lemonade Stand Spreadsheet
What do you do when life gives you lemons? When life gives you lemons, you make lemonade. Students will play a lemonade stand game online and track their progress. Then, they will use the data to create a lemonade stand spreadsheet in Microsoft Excel. The first handout walks students through how to play the game. The second handout describes what students will need to do to create the spreadsheet. Students will input data, insert formulas, insert a column chart, and insert a picture. The handout
Grades:
6th - 12th
Finance -economics -money -checking -stocks -deposits -reconcile
This is a 2-unit Financial Literacy bundle.Unit 1 is the 1st module in the Financial Literacy Unit. This will cover checking accounts including vocabulary, writing a check, completing a deposit slip, different endorsements, reconciling a bank statement.It culminates with a complete simulation. There are 2 versions to differentiate student learning styles. Unit 2This is the 2nd module in a Financial Literacy Unit. The 1st unit covered checking accounts. This unit is an introduction into the stoc
Grades:
9th - 12th
VEX Generic Scouting Sheet 1 - In the Zone
Scouting at VEX tournaments is an important part of a successful team. This is one of the scouting sheets our team uses for the current years competition - In the Zone. We are the 2017 VEX Oregon State Champion and would not have been able to achieve this without great scouting. This will download as a fully editable excel spreadsheet.
Grades:
7th - 12th
Excel Functions Quick Reference Handout and Cheat Sheet
This resource contains informaiton in table format of the most used functions in Excel. It is separated by Core functions, Date Functions, Text Functions, and Lookup / Reference Functions.It is set out attractively in a word table, the column headings being: Function Name, Syntax and Description. It gives a quick reference to over 35 different functions. Really handy for students to refer to when working with functions and formulae. It is available in a pdf and word document so that you can make
Grades:
10th - 12th, Higher Education, Adult Education, Staff
Types:
CCSS:
Also included in: Microsoft Excel Bundle
Graphing with Technology (Microsoft Word/Excel 2013)
Help students learn to create graphs using technology! This graphing with technology booklet acts as a compressed guide and practice sheet for Microsoft Word/Excel 2013.
Each graph contains step-by-step directions and screen-capture images so that students will never get lost. In addition, the data used in this assignment is both relatable and engaging for teenage target groups.
By completing this task, students will be able to create 7 different types of graphs using technology:
- pie gra
Subjects:
Grades:
8th - 12th, Higher Education, Adult Education
Types:
Stock Market -Finance -Excel -Gains -Losses -Quote
This is the second module in a financial literacy unit. The 1st unit covered checking accounts. This unit is an introduction into the stock market. Students will be able to identify the different parts of a stock quote. Students will learn how to read a stock quote, calculate gains and losses and create Excel spreadsheet to track the stocks they choose for a stock simulation that can be turned into a competition.
Grades:
10th - 12th
Types:
Shopping Spree Spreadsheet
This handout instructs your students on how to create a shopping spree spreadsheet. In the activity students will be given $10,000 of imaginary money to spend on anything they desire. I included a screenshot of an example in the instructions to aid students in the activity. The spreadsheet will teach students how to insert formulas, format data, and insert pictures. I have uploaded a zip file so that you will also have the spreadsheet file to help you in grading.
Grades:
6th - 12th
Types:
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
Understanding RobotC
Programming in RobotC for Vex Robots can have a learning curve not only for the students but the teachers as well. This guide can help you better understand how to set things up and help the kids get set up. Allow the kids to access this file to give them some extra guidance to help them through RobotC. The troubleshooting tab is very helpful to guide them through a few steps eliminating wasting time sitting and waiting for you the teacher. This has gone through many versions through the yea
Grades:
6th - 12th
Types:
Excel Guide / Handout - Beginner to Advanced Users
Microsoft Excel Spreadsheets is a vital resource in many businesses, professions, and organizations. Understanding how to effectively use the multitude of tools within this software will save time and impress your boss and coworkers. Students graduating high school with these skills exhibit job-ready capabilities. When you understand how to use Microsoft Excel, you will easily transfer those skills to other spreadsheet software.
For personal use, classroom use, or as a gift for someone in de
Grades:
9th - 12th, Higher Education, Adult Education
Birthday Money Spreadsheet Lesson
This resource contains a lesson plan for introducing intermediate, middle school, or high school students to Excel spreadsheets. It includes two student handouts, a Power Point presentation, a quiz with answer key, and an evaluation form that includes student self-assessment. The activity requires students to pretend they have $1000 to spend for their birthday and that they must find the items they wish to buy on Amazon.com so that they can incorporate a hyperlink to the item in a spreadsheet
Grades:
5th - 8th
Types:
What America Buys Computer Applications Project
Students will create a one page report on how Americans spend their money using Word and Excel. The solution files (in Excel and Word) are included as well as the one page handout for students.What America Buys Computer Applications Exercise by Kim Nichols is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License.
Grades:
9th - 12th
Types:
Excel Basics Notepad / Worksheet
This slideshow is setup as an 11 x 8.5 size so it can be printed out into worksheets. There's enough room for students to take notes on these sheets.There are 12 slides that lay out beginner topics such as:Getting Started with ExcelCell BasicsModifying Rows, Columns, and CellsFormatting Cellsintroduction to FormulasFunctionsKeyboard ShortcutsThere are also video links at the top of each sheet that correlate with the subject content. The background of these slides are a PDF, but the writing for e
Grades:
9th - 12th
Types:
IBCS Case Study Genetic Algorithms Excel Workbook & Printable Worksheets
This is Excel workbook provides worksheets for practicing PMX, CX and OX crossover techniques by hand. The data is based on the IBCS Genetic Algorithm 2021-22 Case Study. The CHROMOSONES and the members of the MATING POOL are dynamically created each time the workbook recalculates. Students then use the parents in the mating pool to complete the PMX, CX and OX processes. Thorough instructions on how each process is to be included are on the worksheets. After performing crossover by hand, st
Grades:
11th - 12th
Types:
Weather Tracking Spreadsheet
This handout instructs your students on how to create a spreadsheet based the weather forecast. I included a screenshot in the instructions to aid students in the activity. The spreadsheet will require students input data, format data, format cells, insert formulas, and insert pictures. This activity is a good assessment of what your students have learned. I have uploaded a zip file so that you will also have the spreadsheet file to help you in grading. If your class is using a version of Excel
Grades:
6th - 12th
Types:
Curso de Excel 2010 avançado
Curso de Excel avançado. Material auto explicativo com telas e exemplos práticos.
Grades:
Staff
Types:
Stock Market Excel Challenge
This word document guides students through the process of finding an excel template, customizing it, inserting formulas and functions, then adding their own information. They will need to find companies they are interested in buying, find purchase prices, calculate trade fees and then track their stocks. We usually go back and can incorporate charts and other features.
Grades:
7th - 12th
Types:
Math - Data Management using Technology
This lesson is a detailed example of how Microsoft Excel can help not only statisticians, but the regular student complete tasks in a way that is functional, efficient and easy to read. It is a fantastic tool that helps the student build an appreciation and awareness of how to communicate properly in math. This lesson will allow students to reflect on the topic of “mean” within Data Management and encourage them to clarify and build on their mathematical arguments.
Lastly, this is a perfect w
Grades:
5th - 9th
Showing 1-24 of 36 results
TPT is the largest marketplace for PreK-12 resources, powered by a community of educators.
IXL family of brands