Information Processing 10, 20, 30
INFO15B
Module 15B: Spreadsheets B (Core)
Outcome
Explain and use the mathematical features that are characteristic of spreadsheet applications.
Indicators
(a) | Describe the mathematical concept of order of operations. |
(b) | Perform calculations in spreadsheets using simple mathematical formulae that include addition (+), subtraction (-), division (/), multiplication (*) and exponentiation (^). |
(c) | Explain that a function is a pre-defined formula. |
(d) | Apply introductory mathematical functions such as SUM, AVERAGE, MEDIAN, MAX, MIN and ROUND to perform calculations in spreadsheets. |
(e) | Compare the effectiveness of the fill handle to that of copying and pasting when replicating and adapting data. |
(f) | Compare the efficiency of using mathematical functions to developing mathematical formulas from scratch. |
(g) | Explore the effects of changing one or several data values in spreadsheets. |
(h) | Discuss how data within a spreadsheet can be used to facilitate the decision-making process. |
Loading...
R012546
Excel 2019 in Easy Steps
This resource offers information about Excel 2019 for introductory to advanced levels. It can serve as a reference book to guide learners to use the functions and features of Excel by following the basic instructions and visual supports provided.
Media and Formats :
Book
Price :
$23.95
Record posted/updated:
December 8, 2021
R022403
Office 2019 in Easy Steps
The key features of five Microsoft Office 2019 programs - Word, Excel, Access, PowerPoint and Outlook - are presented in this resource. Instructions for creating and managing files and data in all programs, as well as time-saving shortcuts, provide a good introduction to effectively using the core applications in Microsoft Office 2019.
Media and Formats :
Book
Price :
$23.95
Record posted/updated:
February 22, 2022
R012465
Microsoft Excel 2019 Bible
This book sequences beginner to advanced skills using Excel. The resource offers many supportive graphics and concise language to explain tutorials on specific topics. An extensive table of contents and index are included.
Media and Formats :
Book
Price :
$66.00
Record posted/updated:
December 7, 2021
R012466
Microsoft Excel 2019: Data Analysis and Business Modeling(6th ed.)
This resource provides advanced and comprehensive information about Microsoft Excel 2019 in the context of business. It contains concise directions to use the various functions and offers problems for practice at the end of each chapter. There are practice and solution files available on a companion website. An extensive table of contents and index are included.
Media and Formats :
Book
Price :
$58.40
Record posted/updated:
December 7, 2021
R021515
Visual Basic in Easy Steps(6th ed.)
This resource shows how to create Windows applications using Visual Basic programming. The code examples, screenshots and step-by-step instructions provide the supports needed to create an interactive application.
Media and Formats :
Book
Price :
$15.99
Record posted/updated:
December 8, 2021
R014656
Microsoft Excel 365 Complete in Practice 2019
This resource provides complete guide to becoming proficient is using the Microsoft Excel 365 program. Students could use this as a textbook, or the teacher could incorporate sections into a course.
Media and Formats :
Book
Price :
See publisher.
Record posted/updated:
June 16, 2022
R012545
Microsoft Office 365 and Office 2019 Introductory
This book goes through very detailed instructions of three projects in each of the following programs: Word, Excel, Access, and PowerPoint. Many graphics and screenshots are provided to accompany the text. It would be most suited for a student or teacher who was unfamiliar with these programs.
Media and Formats :
Book
Price :
$149.95
Record posted/updated:
December 7, 2021
R022893
Your Office. Microsoft Office 365 Excel 2019 Comprehensive
This spiral bound reference book provides a thorough exploration of Microsoft Excel 2019 and its features. Each chapter offers accessible online projects that use real world and business scenarios. The step-by-step tutorials provide hands-on learning. Supplemental instructor resources are available.
Media and Formats :
Book
Price :
$199.99 USD
Record posted/updated:
December 8, 2021
R011308
Microsoft Office 365 Excel 2016. Introductory
This concise spiral-bound resource can be used as a tutorial to learn about the features of Microsoft Excel 2016 at an introductory to intermediate level. It starts with the basics of Excel 2016 and then guides the user on how to begin a spreadsheet, working with formulas and functions, formatting, working with charts and analyzing data using formulas within Excel. There are opportunities to practise, review and apply skills at the end of each module.
Media and Formats :
Book
Price :
$95.95 USD
Record posted/updated:
December 8, 2021
R022895
Go! with Microsoft Office 365: Getting Started(2019 ed.)
This guide provides an overview of how to use Word, Excel, Access and PowerPoint at introductory and intermediate levels, using real life projects to practice and learn the software features. It functions as a step-by-step visual tutorial and has features such as chapter summaries and reviews, project guides, and a glossary. There are instructional components available on the publisher’s website.
Media and Formats :
Book
Price :
$174.99
Record posted/updated:
December 8, 2021
R014931
Microsoft Office 365: A Skills Approach(2019 ed.)
This spiral bound reference book provides a thorough exploration of Microsoft Office 365 and its features. There are sections dedicated to Office, Word, Excel, Access and PowerPoint. Each one has chapters that explore the basics of how to get started and how to format and apply some of the features of the programs in a progression from beginner to advanced levels. Detailed instructions with visual support are provided throughout the resource. There are chapter summaries, guided practice, and independent and challenge projects. Practice files are available on the publisher's SIMnet online platform.
(More information)
Media and Formats :
Book
Price :
$175.33 USD
Record posted/updated:
December 8, 2021