Introduction
Learning Target: I can assess my learning.
Success Criteria: I will know I am successful when I have printed my worksheet and filled out my name, teacher, date, and pre-unit self assessment.
Learning Target: I can recall information from a non-fiction source.
Success Criteria: I will know I am successful when I have completed the spreadsheet overview and paper quiz
Step 2 Create Spreadsheet
Learning Target: I can navigate a program with multiple screens.
Success criteria: I will know I am successful when I have navigated the google menu to create a new blank worksheet.
Step 3 Rename File and Tabs
Learning Target: I can rename a file or subfile
Success criteria: I will know I am successful when I have renamed my spreadsheet file my grade level and practice and renamed the three tabs " bar chart" "Line chart" and "double bar chart"
Learning Target: I can add text to a page. I can edit text when I make mistake.
Success Criteria: I will know I am successful when I have copied the student and temperature data into my spreadsheet.
Step 5 Create a chart
Learning Target: I can navigate pull down menus. I ca nselect items on the screen.
Success Criteria: I will know I am successful when I have navigated the spreadsheet program to create a bar chart for the student data and a line chart for the temperature data
Learning Target: :I can highlight and drag items on the screen. I can recognize number patterns.
Success Criteria:I will know I am successful when I have created 2 addition patterns and 2 subtraction patterns.
Learning Target: I can highlight and drag items on the screen. I can edit text.
Success Criteria: : I will know I am successful when I have added, subtracted, multiplied or divided three different columns.
Step 8 Formulas Part 2
Learning Target: I can highlight and drag items on the screen. I can edit text.
Success criteria: I will know I am successful when I have added formulas for sum, minimum, maximum and average.
Step 9 Fill Cells with Color
Learning Target: I can select/multi-select items on the screen.
Success Criteria: I will know I am successful when I have used the fill tool to highlight my header information and formula data.
Step 10 Submit work : Turn in your work by attaching your sheet from Google Drive.
Learning Target: I can navigate a program with multiple screens. I can copy and paste items. I can assess my learning.
Success Criteria: I will know I am sucessful when I have navigated the screens to share my project and have submitted my link and reflection.
Unit Standards
CCSS:
Mathematics - Data, Statistics and Probablity
Measurement & Data: Represent and interpret data. (CCSS: 4.MD.B)
ISTE: Computational Thinking
5B:Students collect data or identify relevant data sets, use digital tools to analyze them, and represent data in various ways to facilitate problem-solving and decision-making.
5D: Students understand how automation works and use algorithmic thinking to develop a sequence of steps to create and test automated solutions.