Jump to content

Computer Skills/Intermediate/Spreadsheets

Add links
From Wikiversity
Computer Skills
Levels
  1. Fundamentals
  2. Basic
  3. Intermediate
  4. Advanced
  5. Proficient

Intermediate spreadsheet concepts include calculations, row and column management, formatting, graphs and charts.

Objectives and Skills

[edit | edit source]

Objectives and skills for spreadsheets include:[1]

  • Make simple calculations
  • Know how to insert/delete rows/ columns; sort
  • Know how to format data: font; color; number; text; etc
  • Understand that a change to one cell impacts on another
  • Know how to draw graphs and make charts

Multimedia

[edit | edit source]
  1. YouTube: Simple Formulas
  2. YouTube: Modifying Cells, Rows, and Columns
  3. YouTube: Sorting
  4. YouTube: Format Cells
  5. YouTube: Charts

Activities

[edit | edit source]
  1. Complete the tutorial Creating Simple Formulas.
  2. Complete the tutorial Modifying Columns, Rows, and Cells.
  3. Complete the tutorial Sorting Data.
  4. Complete the tutorial Formatting Cells.
  5. Complete the tutorial Working with Charts.

See Also

[edit | edit source]

References

[edit | edit source]
  1. ↑ University of New South Wales: Computer Skills Assessment Framework
Retrieved from "https://en.wikiversity.org/w/index.php?title=Computer_Skills/Intermediate/Spreadsheets&oldid=1987602"