Module 3: Spreadsheets
Microsoft Excel 2010 is the spreadsheet application software that you will be using to complete this module.
Specific Curriculum Outcomes
Students will be expected to:
3.1 identify the purpose, characteristics, and terminology associated with the use of spreadsheet application software
3.2 manipulate data using spreadsheet software to solve problems
3.3 use mathematical features of spreadsheet software to manage data
3.4 produce functional, informative, and effectively formatted charts to present a range of workplace data
3.5 create and format spreadsheets to solve a range of workplace problems
Specific Curriculum Outcomes
Students will be expected to:
3.1 identify the purpose, characteristics, and terminology associated with the use of spreadsheet application software
3.2 manipulate data using spreadsheet software to solve problems
3.3 use mathematical features of spreadsheet software to manage data
3.4 produce functional, informative, and effectively formatted charts to present a range of workplace data
3.5 create and format spreadsheets to solve a range of workplace problems
Topic
Intro to Excel Spreadsheets (key information)
Building basic excel skills. Applying Excel Skills Calculating Discounts Calculating Sales Data (totals, averages, etc.) Data Reports in Excel Creating Professional Data Reports in Excel Using Excel to Budget Finances Visual Displaying Data in Excel Data Management |
Assignment
Introductory Information
Exercises
Excel Exercise 3: Daily Sales Report
Excel Exercise 4: Sport Team Stats
Excel Exercise 5: Payroll
Excel Exercise 6: Fragrances at a Discount!
Excel Exercise Review AssignmentGoogle Sheets Exercises
Complete the following exercises using Google Sheets.
Excel Exercise 7: Personal Banking Activity
Excel Exercise 8: Class Marks
Excel Exercise 9: Bowling Team Statistics
Charts in Excel
|
Due Date
|