Read pages 109-112 of Allegro Textbook
Page
Exercise
Learning Outcomes
113
School roll
Ø Create worksheet
Ø Save document with sensible filename in appropriate folder
Ø Use autosum function to calculate totals
Ø Use autofill function
Ø Format with borders
Ø Print preview
Ø Use page setup menu to place name in Header and filename in Footer
Ø Print
114
Zones
Ø Consolidate skills
Ø Use Alt+Enter function to wrap headings
115
Zones No.2
Ø Retrieve and edit spreadsheet
Ø Insert a column to the right and format
Ø Create addition formula
Ø Edit heading
Ø Resave with new filename
116
Zones No. 3
Ø Consolidate retrieval and editing
Ø Consolidate column insertion and formatting
Ø Change orientation
Ø Print also a formula sheet and be aware of its uses
117
Ethnic groups
Plus chart under teacher instruction
Ø Create and format spreadsheet
Ø Consolidate skills – autosum and addition formulae
Ø Produce chart of Total Boys and Girls Years 9-13
Ø Create
118
Ethnic groups No. 2
Ø Consolidate retrieval, editing and renaming of file
Ø Manipulate data onto second worksheet – copy and paste facility
Ø Print a formula sheet
120
Soccer fundraising
and Chart (with teacher assistance)
Ø Consolidate creation, saving and formatting
Ø Use subtraction formula
Ø Use date function
Ø Use sorting function – alphabetical order
Ø Create line graph of Packets sold
121
Soccer No.2
Plus Chart showing total sales
Ø Retrieval, copy and paste of spreadsheet to second worksheet within document
Ø Edit – delete columns, then add new column and multiplication formula
Ø Sorting by weight in descending order
Ø Problem solve to create total sales chart
122
Soccer No.3
Plus chart
Ø Retrieve and create third worksheet within document
Ø Edit and create new formula (division)
Ø Create chart showing GST exclusive chart
Ø Print (including formula sheet)
123
Pre-Assessment Task
US 18743 Assessment