주차
|
주차명
(주제)
|
주차별학습목표
|
차시
|
차시명
|
평가방법
|
|
학습내용
|
|
1
|
Introduction to the software
|
Introduction to the Microsoft Excel365
|
1-1
|
Start a Excel
|
|
|
1-2
|
Working with An Existing Workbook
|
|
1-3
|
Navigating a Worksheet
|
|
1-4
|
Navigating Data with the GO TO Command
|
|
2
|
Fundamentals of Excel
|
Learn the Fundamentals of Excel
|
2-1
|
Creating, naming and saving Workbooks
|
|
|
2-2
|
Saving in Different File Formats
|
|
2-3
|
Entering and Editing Basic Data in a Worksheet
|
|
2-4
|
Using Data Types to Populate a Worksheet
|
|
3
|
Using Office Backstage
|
How to use Office Backstage
|
3-1
|
Accessing and Using Backstage View and Print Options
|
Practical Test
|
|
3-2
|
Changing the Excel Environment
|
|
3-3
|
Customizing the Quick Access Toolbar and the Ribbon
|
|
3-4
|
Accessing and Using Excel Templates
|
|
4
|
Creating Basic Formulae
|
How to create Basic Formulae
|
4-1
|
Understanding and Displaying Formula
|
|
|
4-2
|
Using External Cell References
|
|
4-3
|
Referring to Data in Another Worksheet
|
|
4-4
|
Referencing Data in Another Workbook
|
|
5
|
Using FUNCTIONS in Excel
|
How to use FUNCTIONS in Excel
|
5-1
|
Summarizing Data with Functions
|
|
|
5-2
|
Using the SUM Function
|
|
5-3
|
Using the COUNT and COUNTBLANK Functions
|
|
5-4
|
Using the AVERAGE Function
|
|
6
|
Format Cells and Ranges
|
How to Format Cells and Ranges
|
6-1
|
Formatting Excel Worksheets
|
Quiz
|
|
6-2
|
Inserting and Deleting Cells
|
|
6-3
|
Formatting Cells with Styles
|
|
6-4
|
Applying Conditional Formatting to Cells
|
|
7
|
Format worksheets
|
How to Format worksheets
|
7-1
|
Working with Rows and Column
|
|
|
7-2
|
Using Themes
|
|
7-3
|
Inserting Headers and Footers
|
|
7-4
|
Transposing Rows or Columns
|
|
8
|
Organise Worksheets
|
How to Organise Worksheets
|
8-1
|
Organizing Worksheets
|
Midterm Exam
|
|
8-2
|
Working with Multiple Worksheets
|
|
8-3
|
Using Zoom and Freeze to Change the Onscreen View
|
|
8-4
|
Finding and Replacing Data
|
|
9
|
Work with Excel Database
|
How to work with Excel Database
|
9-1
|
Sorting Data
|
|
|
9-2
|
Sorting Data on A Single and Multiple Criterion
|
|
9-3
|
Filtering Data
|
|
9-4
|
Using Data functions
|
|
10
|
Create Charts
|
How to Create Charts
|
10-1
|
Building Charts
|
|
|
10-2
|
Formatting A Chart with A Quick Style or Layout
|
|
10-3
|
Modifying A Chart
|
|
10-4
|
Deleting Elements from A Chart
|
|
11
|
Secure Workbooks
|
How to Secure Workbooks
|
11-1
|
Securing Workbooks
|
Practical Test
|
|
11-2
|
Using the Document Inspector
|
|
11-3
|
Tracking Changes to A Workbook
|
|
11-4
|
Adding Comments to A Workbook
|
|
12
|
Insert Images and Shapes
|
How to Insert Images and Shapes
|
12-1
|
The Insert Tab’s
Illustration and Text Tools
|
|
|
12-2
|
Inserting Pictures
|
|
12-3
|
Adding Shapes
|
|
12-4
|
Adding Graphic Enhancements
|
|
13
|
Print Worksheets
|
How to Print Worksheets
|
13-1
|
Using the printer settings
|
Quiz
|
|
13-2
|
Changing page settings
|
|
13-3
|
Customise margins
|
|
13-4
|
Page scaling and page setup
|
|
14
|
Customise Excel Templates
|
How to Customise Excel Templates
|
14-1
|
Using excel templates
|
|
|
14-2
|
Create new colour themes
|
|
14-3
|
Switch or remove a theme
|
|
14-4
|
|
Changing default themes
|
|
15
|
Final Exam
|
|
|