Week 7 of 10
Objectives
By the end of the session you will be able to:
- Create a table
- Add or remove borders
Objectives
By the end of the session you will be able to create an interactive quiz in Excel containing ‘if’ statements and at least 3 questions with the aid of a “How to do it Checklist”
Objectives
By the end of the session you will be able to:
- Input data using Access's Form Wizard
- Output data using Access's Report Wizard
Programme
Numeracy Assignment
BREAK
Walkthrough with tutor Forms & Reports Wizard
Enter your own data and output reports
Review
CLOSE
Objectives
By the end of the session you will be able to
Move between cells
Key in data
Delete and amend data
Save the spreadsheet
Change column width
Align a column label
Use autosum tool
Copy contents of a cell
Use a formula
Format numbers
Programme
Intro to session
Review
Spreadsheet Basics
BREAK
Individuals work through Spreadsheet Basics workbook
Review
CLOSE
Homework
Notes & Queries
One thing I learnt this evening
Jackie: Learnt lots of things but the main thing is I learnt to edit text and formulas in the Formula Bar.
Vanessa: Decrease decimal points with the icon on the Formatting toolbar.
Ed: Using the Countif Function.
Jill: Ctrl ` (grave accent) to show formula.
Roger: $ sign to make an absolute cell reference for autofilling.and Use Keyboard Shortcuts shown on drop down menu commands.
Suzanne: Right click to get menu commands.