INF1060 Spreadsheet 1
Introductory · 1 credit · BIT - Business, Admin, Finance and IT
- Description
- Students develop skills in the proper use of spreadsheet software through general data manipulation and personal recordkeeping.
- Prerequisite
- None
- Parameters
- Access to an appropriate computer work station and spreadsheet software.
Outcomes The student will:
1 demonstrate basic electronic spreadsheet software competence
1.1 describe key features of the spreadsheet software
1.2 use help functions and references as appropriate
2 create and manipulate data
2.1 insert data using fill such as:
2.1.1 cut, copy and paste cells
2.2 modify cell contents and formulas by:
2.2.1 changing font, font size and style
2.2.2 applying borders and copying cell contents
2.3 change worksheet views
2.4 manage worksheets including:
2.4.1 rename a worksheet
2.4.2 hide and unhide a worksheet
3 format data and content
3.1 format worksheets including:
3.1.1 hide and show gridlines
3.1.2 create, rename and duplicate worksheets
3.1.3 add backgrounds
3.2 insert and modify rows and columns by:
3.2.1 deleting and inserting rows and columns
3.2.2 inserting and deleting cells
3.3 format cells and cell content including:
3.3.1 edit, move and clear cell contents
3.3.2 find and replace cell contents
3.3.3 insert and edit hyperlinks
3.3.4 convert text to columns
3.4 format data and tables by:
3.4.1 applying table styles
3.4.2 modifying and editing tables
4 create and modify formulas
4.1 reference data in formulas including:
4.1.1 key and edit basic formulas
4.1.2 use functions to create formulas
4.1.3 copy and move formulas
4.1.4 use relative, absolute and mixed references
4.1.5 enter a range into a formula by dragging
4.2 summarize data using subtotals with various techniques; e.g., autosum, cell referencing
4.3 display and print formulas
5 present data visually
5.1 create and format charts and diagrams
5.2 modify and position chart elements
5.3 insert and modify illustrations by:
5.3.1 inserting, moving and sizing graphics
5.4 sort and filter data using:
5.4.1 simple sorts and filter sorts
6 collaborate and secure data
6.1 save and print workbooks including:
6.1.1 use print preview
6.1.2 change page orientation
6.1.3 set print area
6.1.4 create headers and footers
6.1.5 set print options
6.1.6 print workbook and selections
7 apply consistent and appropriate work station routines
7.1 demonstrate good health and safety; e.g., posture, positioning of hardware and furniture
7.2 employ practices that provide security for hardware, software, supplies and personal work
8 demonstrate basic competencies
8.1 demonstrate fundamental skills to:
8.1.1 communicate
8.1.2 manage information
8.1.3 use numbers
8.1.4 think and solve problems
8.2 demonstrate personal management skills to:
8.2.1 demonstrate positive attitudes and behaviours
8.2.2 be responsible
8.2.3 be adaptable
8.2.4 learn continuously
8.2.5 work safely
8.3 demonstrate teamwork skills to:
8.3.1 work with others
8.3.2 participate in projects and tasks
9 make personal connections to the cluster content and processes to inform possible pathway choices
9.1 complete/update a personal inventory; e.g., interests, values, beliefs, resources, prior learning and experiences
9.2 create a connection between a personal inventory and occupational choices
Program of Studies 2009. Source document, © Alberta Education.