Digital Literacy Core Skills – UWCSEA Dover
Scope & Sequence of Information and Communications Technology (ICT) Skills This document attempts to answer the question of what to teach and when. However, because students should learn skills on an as-needed basis, this chart is not intended for planning. The chart then ideally reflects the skills students learned in the previous year. The chart serves as a review of skills learned previously, not as a guideline for the future. When a teacher wants to know whether a new class has practised a particular computer skill, this chart helps to provide an answer. The chart is based on ISTE's National Educational Technology Standards for students (NETS•S); it is a review and reflection tool, not a prescriptive plan. It is expected that each grade pay attention to at least meeting the standards annually, so that students develop technology proficiency over time. Throughout the year, DLCs will help grades to keep a track of the skills introduced, developed or mastered at each grade level. Each grade level should expose students to new skills and new technologies, so that students build competencies with various applications. Skills move from Introduction > Developing > Mastery. Generally the left most dot ! indicates Introduction, the right most dot indicates mastery, and is then implied on upwards from there.
Multimedia: Text, Image & Video (incl. Keyboarding & Word Processing) Standard 1: Creativity and Innovation Students demonstrate creative thinking, construct knowledge, and develop innovative products and processes using technology. Students: a. b.
apply existing knowledge to generate new ideas, products, or processes. create original works as a means of personal or group expression. * For c & d See Standard 4
K1
K2
1
2
3
Recognise that pressing keys on a keyboard creates letters on a screen
!
Recognise and type lower case letters
!
!
Recognise and type upper case letters
!
!
Identify and use the space bar
!
!
Identify and use the delete/backspace
!
!
Identify and use the return/enter key
!
!
!
Understand the relative positions of keys on a keyboard
!
!
!
Identify and use number keys (& number pad on full size keyboards)
!
!
!
Identify and use the shift keys to make capital letters
!
!
Open a word processing program
!
!
!
Print from a word processing program
!
!
!
Delete text, forward, backspace & highlight/delete
!
!
!
Change text size
!
!
Understand the insertion point and the use of a cursor
!
!
Use the cursor keys or mouse to move around the screen
!
!
Type words and sentences correctly
!
!
!
Use the caps lock key
!
!
!
Use the tab key (to tab and move between entry fields in web pages)
!
!
!
Use the arrow keys
!
!
!
Insert and position graphics into a word processing document
!
!
!
Move, resize and reshape objects
!
!
!
Use ‘special’ keys such as shift and punctuation keys
!
!
!
4
5
1
Digital Literacy Core Skills – UWCSEA Dover
K1
K2
1
2
3
4
Save and retrieve files
!
!
!
Highlight text and change font, size and style
!
!
!
Use and adjust text wrapping with an image
!
!
!
Cut, copy and paste text
!
!
!
Use spell and grammar check into a word processing document
!
!
!
Change the layout of a document by centring and justifying
!
!
!
5
!
!
!
!
!
!
!
!
!
!
Insert/format page numbers
!
!
Add header/footer to a word processing document
!
!
Use and modify templates
!
!
Use document page breaks, sections and styles
!
!
Create an automatic table of contents (TOC)
!
!
4
5
Paste text without formatting, or to match destination formatting Move or copy text between two documents !
Insert a table into a word processing document Insert and delete rows, columns, and merge cells in a table
Graphics K1
K2
1
Experiment with mouse/pointer control
!
!
Experiment with colours
!
!
Experiment with tools
!
!
Identify, open and close a graphics program
!
!
!
Select graphics tools
!
!
!
Use the pencil tool
!
!
!
Use the eraser
!
!
!
Use the paint brush
!
!
!
Use the spray can in a paint program
!
!
!
Change the colour or pattern of brush, bucket or spray can in a paint program
!
!
!
Use the paint bucket to fill areas
!
!
!
Use a line tool
!
!
!
Use shape tools
!
!
!
2
3
Use the text box tool
!
!
!
Use cut, copy and paste
!
!
!
!
!
Use a digital device to take a picture
!
Transfer images to a computer taken with a digital device
!
!
!
Search for, locate, download, and save and insert images from the internet
!
!
!
Understand and use pixels as a unit of measurement on screens
!
!
!
Adjust the size (pixel width) of images
!
!
!
Apply effects, such as rotate, flip, arrange, align etc, to an image or object
!
!
!
Duplicate an object or image
!
!
! 2
Digital Literacy Core Skills – UWCSEA Dover
K1
K2
1
2
3
4
5
Capture images (scanner, camera, etc.)
!
!
!
Crop and enhance images
!
!
!
!
!
4
5
Annotate image and PDF files
Multimedia Presentations (Slideshows) K1
K2
1
2
3
Create presentations that include text and graphics
!
!
Create presentations that include sound and/or animation
!
!
Add text and graphics to slides
!
!
!
Use various View options (show, slide sorter, etc)
!
!
!
Communicate through a series of slides
!
!
!
Add transitions to slides
!
!
!
Format and use themes
!
!
!
Add photographs from a variety of sources
!
!
!
Create a series of screens with buttons for navigation
!
!
Add video/music to enhance a presentation
!
!
Apply design principles to layout and font
!
! !
Insert a hyperlink in a slide
Video K1
K2
1
Experiment with the recording of video in the classroom
!
!
!
Speak clearly to a recording device
!
!
!
Know the functions of a recording device
!
!
!
Locate the controls on a recording device
!
!
!
Switch a recording device on and off
!
!
!
Switch between camera and video on a recording device
!
!
!
3
4
!
!
!
!
Use video for a presentation
!
!
!
Create a documentary type of video presentation
!
!
!
Create a short film from a storyboard
!
!
!
Create an animation from still images (eg, stop motion)
!
!
!
Insert video into a web page
!
!
Import and edit video
!
!
Add narration to a recording
!
!
Select and add music to a video presentation
!
!
Start and stop, and pause and play a recording Play back (review) a recording - fast forward and rewind
!
2
5
!
Record video with attention to the control of camera movement
!
Transfer video to a computer
!
3
Digital Literacy Core Skills – UWCSEA Dover
Communications Standard 2: Communication and Collaboration: Students use digital media and environments to communicate and work collaboratively, including at a distance, to support individual learning and contribute to the learning of others. Students: a. b. c. d.
interact, collaborate, and publish with peers, experts, or others employing a variety of digital environments and media. communicate information and ideas effectively to multiple audiences using a variety of media and formats. develop cultural understanding and global awareness by engaging with learners of other cultures. contribute to project teams to produce original works or solve problems.
K1
K2
1
2
3
!
!
!
Compose, address and send email messages
!
!
!
Reply to/forward/delete email messages
!
!
!
Post appropriate materials to a collaborative website
!
!
!
Respond appropriately to the postings of others
!
!
!
Compose, send and respond appropriately to instant messages (Chat)
!
!
!
Attach a file of appropriate size (< 5 MB) to an email
!
!
!
!
!
4
5
Use video conferencing to communicate with others regionally and globally
Embed media into a web page using embed code
4
5
Information Systems & the Internet Standard 3: Research and Information Fluency: Students apply digital tools to gather, evaluate, and use information. Students: a. b. c.
plan strategies to guide inquiry; locate, organize, analyze, evaluate, synthesize, and ethically use information from a variety of sources and media. evaluate and select information sources and digital tools based on the appropriateness to specific tasks. process data and report results.
1
2
3
!
!
!
Access a Web site by typing a URL accurately
!
!
!
Use History to return to a previously visited page
!
!
!
Save an image from a web page (copy/save as)
!
!
!
Insert an image into a web page (upload/paste URL)
!
!
!
Identify key words, names, and phrases for a search
!
!
!
Find information in an online database
!
!
!
Search using a Web browser
!
!
!
Perform a simple search (single field)
!
!
Identify and open a web browser
K1
K2
Appreciate the advantages and disadvantages of a variety of sources
!
!
!
Use the find command to locate specific words
!
!
!
Understand and carry out a multiple field search
!
!
Identify key words and major headings or groups
!
!
Perform a search using Boolean terms (and, or, not)
!
!
Use citation methods for sources and pictures, eg MLA, APA etc.
!
!
4
Digital Literacy Core Skills – UWCSEA Dover
K1
K2
1
2
3
4
5
Upload and download files as appropriate
!
!
!
Capture information from an online source and transfer to a word processor
!
!
!
Open two windows separately or in tabs for browsing
!
!
!
Save sites (bookmark/favourites)
!
!
Use the tools from the menu bar in a web browser, eg, find, zoom etc.
!
! !
Independently select relevant material for a topic
Data Handling, Spreadsheets & Modelling Standard 4: Critical Thinking, Problem Solving, and Decision Making: Students use critical thinking skills to plan and conduct research, manage projects, solve problems, and make informed decisions using appropriate digital tools and resources. Students: a. b. c. d.
identify and define authentic problems and significant questions for investigation. plan and manage activities to develop a solution or complete a project. collect and analyse data to identify solutions and/or make informed decisions. use multiple processes and diverse perspectives to explore alternative solutions.
(From Standard 1) c. use models and simulations to explore complex systems and issues d. identify trends and forecast possibilities.
K1
K2
1
Collect data and enter into a data handling program
!
!
!
Present data using a data handling program
!
!
!
Organise data in a data handling program
!
!
!
Insert data into a data table
!
!
!
Explore a simulation or adventure type application
!
!
!
!
!
!
!
!
Use collected data to create graphs (eg, bar chart) Understand the need for accuracy when entering data
2
3
Use an online survey to gather data
4
5
!
!
5
Spreadsheets K1
K2
1
2
3
4
Recognise the elements of a spreadsheet (cell, row, column)
!
!
Move to a specific cell on a spreadsheet (eg C7)
!
!
Enter text or numbers and move among cells in a spreadsheet
!
!
Save and retrieve spreadsheet files
!
!
Add header/footer to a spreadsheet
!
!
Create a data table
!
!
!
Create a graph from a data table
!
!
!
Format a graph (background, font, text colour, etc)
!
!
!
Interpret spreadsheet results
!
!
!
Copy/paste a graph into another application
!
!
Sort or filter a column of numeric data
!
! 5
Digital Literacy Core Skills – UWCSEA Dover
K1
K2
1
2
3
4
5
Enter and use a simple formula (A2+B2)
!
!
!
Select and format a cell or range of cells
!
!
Use common functions (eg, SUM, AVERAGE etc)
!
!
!
Insert and remove rows, columns and merge cells
!
!
Use ‘drag copy’ to apply functions and formulae to a range of cells
!
!
Build a simple table using interrelated functions/formulae
!
!
Change inputs and formulae in a spreadsheet model and predict consequences
!
!
Use formulae and functions to solve (mathematical) problems
!
!
5
The UWCSEA Learner Profile (Online) Skills & Qualities Standard 5: Digital Citizenship: Students understand human, cultural, and societal issues related to technology and practice legal and ethical behaviour. Students: a. b. c. d.
advocate and practice safe, legal, and responsible use of information and technology. exhibit a positive attitude toward using technology that supports collaboration, learning, and productivity. demonstrate personal responsibility for lifelong learning. exhibit leadership for digital citizenship.
K1
K2
1
Demonstrate appropriate behaviour while using digital devices
!
!
!
2
3
4
Treat digital equipment with respect
!
!
!
Understand/adhere to school procedures
!
!
!
Use technology cooperatively and collaboratively with others
!
!
! !
!
!
Understand copyright and plagiarism
!
!
!
Practise safe searching and communications techniques (e-safety)
!
!
!
3
4
5
Describe uses (and abuses) of computer technology in society
General Technological Awareness Standard 6: Technology Operations and Concepts: Students demonstrate a sound understanding of technology concepts, systems, and operations. Students: a. b. c. d.
understand and use technology systems. select and use applications effectively and productively. troubleshoot systems and applications. transfer current knowledge to learning of new technologies.
K1
K2
Start, restart and shutdown a computer
!
!
1
Understand that appliances need to be switched on and off in different ways
!
!
Identify a mouse/trackpad and explain what it does
!
!
Press and hold on a touchscreen device to activate a contextual menu
!
!
Move a mouse/trackpad and point it to a desired location
!
!
!
Click a mouse button to select and deselect an icon (click on, click off)
!
!
!
Click and drag an object using the mouse/trackpad (drag and drop)
!
!
!
Identify icons for files, programs, folders and disks
!
!
!
Identify the parts of a computer
!
!
!
2
6
Digital Literacy Core Skills – UWCSEA Dover
K1
K2
1
2
3
4
5
Understand and use computer terms, eg: menu, icon, scroll bar, cursor etc
!
!
!
Save/retrieve work
!
!
!
Press and hold on a touchscreen device to activate a contextual menu
!
!
!
Use multi-touch gestures to control a touch screen device
!
!
!
Use mouse/trackpad skills (single and double left click and right/left clicks)
!
!
!
Open and close a program by double clicking with the mouse/trackpad
!
!
!
Print a document
!
!
!
Log in with user name and password
!
!
!
Understand that work can be saved in a file
!
!
Understand that every file needs its own meaningful name
!
!
Create and name folders
!
!
!
Handle and use a wireless device appropriately, eg, laptop, tablet etc.
!
!
!
Control cursor movement accurately
!
!
Open a previously saved file
!
!
Understand the affects of changing cursor icons (select, move, type etc)
!
!
!
Understand secure methods of using and managing passwords
!
!
!
Save and organise files into folders and sub folders
!
!
!
Save/retrieve work using a network
!
!
!
Troubleshoot basic internet connectivity issues
!
!
!
Change the name of a file and/or folder (rename)
!
!
!
Save a copy of a file (Save As or Duplicate)
!
!
Open and use two or more programs at the same time (multi-task)
!
!
Move and resize windows
!
!
Save a file on portable disk, external media or network drive (eg Google drive)
!
!
Use kilobytes, megabytes and gigabytes as units of measurement
!
!
!
Familiar with common software menus systems, conventions and icons
!
!
!
7
