BSBITU304A Produce Spreadsheets with Excel 2007Page 1 of 5

BSBITU304A Produce spreadsheets with Excel 2007Page 1 of 5

Document Log

BSBITU304A Produce spreadsheets with Excel 2007 2nd editionPage 1 of 5

Chapter / Activity /
Practice Exercise / Page / File name / Description / Edit 1 date / Edit 2 date / Complete date
1 / 1 / Chapter 1 – Introduction to Microsoft Excel
1 / A / 3 / Start Microsoft Excel
1 / 4 / Read / Introducing the Excel Workplace
1 / 5 / Read / The Title Bar
1 / A / 5 / The Office Button
1 / 6 / Read / The Quick Access Toolbar
1 / A / 6 / The Ribbon
1 / A / 7 / Condensing and Expanding the Ribbon
1 / A / 8 / The Word Areas & Scroll Bars
1 / A / 9 / Moving Around the Screen
1 / A / 10 / Using the Mouse
1 / A / 11 / Using the Keyboard
1 / A / 12 / Net Sales / Creating a New Workbook
1 / A / 13 / Net Sales / Entering Text and Data
1 / A / 14 / Net Sales / Name a Worksheet
1 / A / 15 / Net Sales / Saving Files with Windows XP
1 / A / 18 / Net Sales / Closing Workbook Files
1 / PE 1.1 / 18 / GG Order / Create a New Workbook File
1 / 19 / Read / Opening Files
1 / A / 19 / Net Sales/ GG Order / Open a File
1 / A / 21 / Net Sales/ GG Order / Working with Multiple Files
1 / A / 22 / GG Order / Selecting Cells
1 / A / 23 / Costs Breakdown / Using an Input Range to Enter Data
1 / PE 1.2 / 24 / Cinemania Department Sales / Enter Data Using an Input Range
1 / A / 25 / Spelling / The Spelling Checker
1 / PE 1.3 / 27 / Net Sales/ GG Order / Use Spellcheck
1 / 27 / Read / Proofreading
1 / A / 28 / AutoComplete / Using AutoComplete to Enter Text
1 / A / 29 / GG Order / Editing Text and Data
1 / A / 29 / GG Order / The Undo Button
1 / A / 29 / GG Order / Delete Key
1 / A / 29 / GG Order / Type Over
1 / A / 30 / GG Order / Edit in Formula Bar
2 / 31 / Chapter 2 - Formulas
2 / 32 / Read / Using Formulas
2 / A / 33 / Chapter 2 / Multiplication
2 / A / 35 / Chapter 2 / Division
2 / A / 36 / Chapter 2 / Addition
2 / A / 37 / Chapter 2 / Subtraction
2 / A / 38 / Chapter 2 / Using AutoSum
2 / 40 / Read / Standard error value associated with using formula
2 / A / 41 / Chapter 2 / #########
2 / A / 41 / Chapter 2 / #DIV/0!
2 / A / 42 / Chapter 2 / #REF!
2 / A / 42 / Chapter 2 / “VALUE!
2 / PE 2.1 / 43 / Chapter 2 / Total Sales
2 / PE 2.2 / 44 / Chapter 2 / Order Form Using Formulas
2 / 45 / Read / Spreadsheet Design
2 / PE 2.3 / 48 / Cinemania Movie Sales / Plan and Create a Simple Spreadsheet
2 / PE 2.4 / 49 / Crème Supreme Sales / Plan and Create a Simple Spreadsheet
3 / 51 / Chapter 3 - Formatting the Spreadsheet
3 / 52 / Read / Default Settings
3 / A / 52 / Chapter 3 / Font Size
3 / A / 53 / Chapter 3 / Changing the Font Style of Data
3 / A / 54 / Chapter 3 / Column Width
3 / A / 55 / Chapter 3 / Formatting Numbers
3 / PE 3.1 / 57 / Chapter 3 / Practice Exercise
3 / A / 58 / Chapter 3 / Wrap Text Within a Cell
3 / A / 59 / Chapter 3 / Horizontal Alignment
3 / A / 60 / Chapter 3 / Merging Cells
3 / A / 61 / Chapter 3 / Vertical Alignment
3 / A / 62 / Chapter 3 / Insert Rows
3 / A / 63 / Chapter 3 / Borders
3 / A / 64 / Chapter 3 / Border Selections
3 / A / 65 / Chapter 3 / Shading Cells: Fill Colour
3 / A / 65 / Chapter 3 / Font Colour
3 / A / 66 / Chapter 3 / Using Fill Colours
3 / PE 3.2 / 67 / Chapter 3 / Format a Spreadsheet
3 / A / 68 / Chapter 3 / Delete a Row or Column
3 / A / 70 / Chapter 3 / AutoFormat
3 / A / 71 / Chapter 3 / Format Cells
3 / 73 / Read / Splitting the Screen and Freezing the Panes
3 / A / 74 / Chapter 3 / Splitting the Screen
3 / A / 75 / Chapter 3 / Freezing Panes of Split Screens
3 / A / 75 / Chapter 3 / Unfreeze and Remove Split
3 / PE 3.3 / 75 / Chapter 3 / Split Screen and Freeze Panes
4 / 77 / Chapter 4 - Page Setup and Print
4 / A / 78 / Chapter 4 / Previewing the Spreadsheet
4 / A / 78 / Chapter 4 / Page Break Preview
4 / A / 79 / Chapter 4 / Print Preview
4 / A / 81 / Chapter 4 / Page Setup
4 / A / 81 / Chapter 4 / Orientation
4 / A / 81 / Chapter 4 / Paper Size
4 / A / 82 / Chapter 4 / Scaling to Fit
4 / A / 83 / Chapter 4 / Margins
4 / A / 84 / Chapter 4 / Printing Options
4 / A / 84 / Chapter 4 / Printing Guidelines
4 / A / 84 / Chapter 4 / Row and Column Headings
4 / A / 86 / Chapter 4 / Headers and Footers
4 / A / 87 / Chapter 4 / Creating a Custom Header
4 / A / 88 / Chapter 4 / Insert a Footer
4 / A / 89 / Chapter 4 / Printing
4 / A / 90 / Chapter 4 / Printing Part of a Sheet
4 / A / 90 / Chapter 4 / Print a Whole Workbook
4 / PE 4.1 / 92 / Chapter 4 / Prepare Workbook to Print
4 / A / 94 / Chapter 4 / Print Formula in Cells
4 / A / 94 / Chapter 4 / Display Formula Results
4 / PE 4.1 / 95 / Chapter 4 / Print and Page Setup
4 / PE 4.2 / 95 / Chapter 4 / Print and Page Setup
5 / 97 / Chapter 5 - Creating Charts
5 / 98 / Read / Why Use a Chart?
5 / A / 99 / Chart Types / Chart Types
5 / A / 100 / Chapter 5 / Creating a Chart
5 / A / 101 / Chapter 5 / Switch Row and Column Data
5 / A / 102 / Chapter 5 / Chart Layout
5 / A / 102 / Chapter 5 / Chart Title
5 / A / 103 / Chapter 5 / Axis Titles
5 / A / 104 / Chapter 5 / Chart Legend
5 / A / 104 / Chapter 5 / Data Labels
5 / A / 105 / Chapter 5 / The Data Table
5 / A / 105 / Chapter 5 / Gridlines
5 / A / 106 / Chapter 5 / Resizing a Chart
5 / A / 106 / Chapter 5 / Moving a Chart
5 / A / 107 / Chapter 5 / Deleting a Chart
5 / A / 107 / Chapter 5 / Printing a Chart
5 / PE 5.1 / 108 / Chapter 5 / Create a 3-D Stacked Column Chart
5 / A / 109 / Chapter 5 / Create a Pie Chart
5 / PE 5.2 / 112 / Chapter 5 / Create a Pie Chart
5 / A / 113 / Chapter 5 / Changing the Type of Chart
5 / PE 5.3 / 115 / Gorgeous Gifts Charts / Column Chart
5 / PE 5.4 / 116 / Gorgeous Gifts Charts / Pie Chart and Column Chart
5 / A / 117 / Chapter 5 / Adding Data to a Chart
5 / A / 118 / Chapter 5 / Removing Data from a Chart
5 / A / 119 / Chapter 5 / Formatting Data Markers
5 / A / 121 / Chapter 5 / Using a Graphic for Data Markers
5 / PE 5.5 / 123 / Chapter 5 / Create and Modify Charts
6 / 125 / Chapter 6 - More Formula and Functions
6 / 126 / Read / BODMAS Rules
6 / A / 128 / Formula and Functions / Enter Formulas
6 / PE 6.1 / 129 / Chapter 6 / Practice Exercise
6 / A / 130 / Chapter 6 / Formula with Percentage
6 / A / 132 / Chapter 6 / Relative and Absolute Cell References
6 / PE 6.2 / 135 / Chapter 6 / Using Absolute Cell References
6 / PE 6.3 / 137 / Chapter 6 / Use Absolute Cell References
6 / PE 6.4 / 139 / Chapter 6 / Entering Formulas
6 / 140 / Read / Functions
6 / A / 141 / Chapter 6 / The Average Function
6 / A / 143 / Chapter 6 / Using Functions on Non-Continuous Cells
6 / A / 144 / Chapter 6 / Using Several Ranges in a Function
6 / A / 146 / Chapter 6 / Using a Function in a Formula
7 / 147 / Chapter 7 – Fill, Copy and Move
7 / 148 / Read / Using Fill to Copy and Enter Data
7 / 148 / Read / The Fill Handle
7 / A / 149 / Chapter 7 / Fill Text into Cells
7 / A / 150 / Chapter 7 / Fill Formatting
7 / A / 151 / Chapter 7 / Fill a Formula with Relative Cell References
7 / A / 152 / Chapter 7 / Copying Text and Data
7 / A / 154 / Chapter 7 / Copy Formula with Absolute Cell References
7 / A / 157 / Chapter 7 / Copy Formula with Relative Cell References
7 / A / 158 / Chapter 7 / Copying to Several Locations at Once
7 / PE 7.1 / 159 / Chapter 7 / Practice Exercise
7 / A / 160 / Chapter 7 / Moving Text, Data and Formula
7 / A / 161 / Chapter 7 / Copying from Sheet to Sheet
7 / A / 163 / Chapter 7 / Using Drag and Drop to Move or Copy
7 / A / 166 / Chapter 7 / Sorting
7 / PE 7.2 / 167 / Chapter 7 / Sort a List
8 / 169 / Chapter 8 – Import and Export Data
8 / 170 / Read / Working with Multiple Worksheets
8 / A / 170 / Chapter 8 / Select a Range of Worksheets
8 / A / 171 / Chapter 8 / Deselect a Range of Worksheets
8 / A / 172 / Chapter 8 / Enter Data into Separate Worksheets
8 / A / 173 / Chapter 8 / Enter Formulas
8 / PE 8.1 / 174 / Chapter 8 / Enter Text, Data, Formula and Formats on Multiple Sheets
8 / A / 175 / Chapter 8 / Select Non-Consecutive Worksheets
8 / A / 176 / Chapter 8 / Consolidate the Worksheets
8 / PE 8.2 / 177 / Chapter 8 / Practice Exercise
8 / PE 8.3 / 178 / Paper Sales / Work with Multiple Worksheets and Consolidate
8 / 179 / Read / Linking Worksheets and Workbooks
8 / A / 180 / Chapter 8 / Create Links Between Worksheets
8 / A / 181 / Chapter 8 / Test the Links
8 / A / 182 / Chapter 8 / Create a Link Between Workbooks
8 / A / 183 / MST Summary / Importing Worksheets from Other Workbook Files
8 / A / 185 / Cinemania Uniform Pricelist / Copy Text from a Word Table
8 / A / 186 / Uniform Pricelist / Creating a Link between Word and Excel
8 / A / 187 / Uniform Pricelist / How to Determine if Data is Linked
8 / A / 188 / Chapter 8 / Importing Delimited Text
8 / A / 191 / Chapter 8 / Remove Links to Text
8 / A / 191 / Chapter 8 / Check and Modify Imported Data
8 / A / 192 / Chapter 8 / Use Find and Replace
8 / PE 8.4 / 193 / Chapter 8 / Using Find and Replace
8 / A / 193 / Chapter 8 / Widen Columns to Accommodate Text
8 / A / 194 / Chapter 8 / Delete Excess Headings
8 / A / 194 / Chapter 8 / The Format Painter
9 / 195 / Chapter 9 – Shortcuts and Macros
9 / A / 196 / Chapter 9 / AutoCorrect
9 / PE 9.1 / 199 / Chapter 9 / Enter AutoCorrect Phrases (AutoText)
9 / PE 9.2 / 200 / Chapter 9 / Using AutoCorrect Entries
9 / 201 / Read / Using Macros
9 / A / 202 / Chapter 9 / Record a Macro in Excel
9 / A / 204 / Chapter 9 / Run the Macro
9 / PE 9.3 / 205 / Chapter 9 / Record a Macro
9 / A / 206 / Chapter 9 / Assign Macro with a Quick Access Toolbar Button
9 / PE 9.4 / 207 / Chapter 9 / Assign Macro to a Quick Access Toolbar Button
9 / A / 208 / Chapter 9 / Saving the Macro in Excel 2007
9 / A / 209 / Chapter 9 / Open a Workbook and Enable Macros
9 / 210 / Read / Some Tips to Remember when Recording Macros
9 / A / 210 / Chapter 9 / Resetting the Quick Access Toolbar
9 / A / 211 / Chapter 9 / Delete a Macro
9 / 212 / Read / Shortcut Keys for Future Reference

Student name: ______Class/Group: ______