This textbook was written for a community college introductory course in spreadsheets utilizing Microsoft Excel. While the figures shown utilize Excel 2016, the textbook was written to be applicable to other versions of Excel as well. The book introduces new users to the basics of spreadsheets and is appropriate for students in any major who have not used Excel before.
How to Use Microsoft Excel: The Careers in Practice Series is an textbook appropriate for a course covering Microsoft Excel at a beginner to intermediate level. It is geared toward and will be accommodating for students and instructors with little to no experience in using Microsoft Excel. However, the approach is not at the expense of relevance.
This lesson is to be used when teaching formulas and functions in Excel. Websites are provided for the curriculum and a project is available to use and modify as you choose. The project can be used as a checkpoint or as a final assessment.
This Remote Learning Plan was created by Melissa Dux in collaboration with Andrew Easton as part of the 2020 ESU-NDE Remote Learning Plan Project. Educators worked with coaches to create Remote Learning Plans as a result of the COVID-19 pandemic.The attached Remote Learning Plan is designed for 9-12 CIS Information Technology students. Students will create a spreadsheet with data to calculate total, average, max, and min functions. This Remote Learning Plan addresses the following NDE Standard: CIS.HS.4a.4.b Sort data, manipulate data using formulas and functions.It is expected that this Remote Learning Plan will take students one hour to complete.Here is the direct link to the Google Doc: https://docs.google.com/presentation/d/1fvmEAdP7Ad8DAe8QM0FzZltSB4VXkUjRbvBOOxrX7K8/edit?usp=sharing
This lesson uses a small snack to review spreadsheet tasks. It is typically enjoyable and memorable because the students get to eat as part of this lesson.
This is a final exam project for a class that teaches both basic Excel and Basic Programming materials. Students have previous lesson in Excel learning about formatting, formulas, and functions as well as previous lessons in Programming utilizing both the Micro:Bits and Scratch programming.