Year 11 ICT
To close off the first part of section of the school year, we will be reviewing the concepts we have covered and look to consolidate your working in Excel: New skills - Shortcuts for Excel:
Before you leave the class today please complete the EXIT TICKET.
0 Comments
Today you will be given time to complete tasks that are overdue.
Those who are up to date should work on the following:
Spreadsheet Task 4 (task total: 25) You can use your digital textbook pages to assist you with this task.
DUE Date: Thursday, October 20, 21h00Today you will be doing a exercise to review some of the formulas you have be working with. Task:
DUE Date: Monday, 17 October, 20h00Create a new spreadsheet titled [YOURNAME_Rounding]. In cell B1 to B6 write the number 375.56411. In cell A1 write "whole number part", A2 write "two decimals", A3 write "whole number", cell A4 write "nearest ten", cell A5 write "nearest hundred and cell A6 write "nearest thousand". Adjust column A to fit the text and make all text in column B bold. In C1 to C6 create a model to calculate:
The 2010 edition digital textbook page 209 will help you with these formulas. You ca also refer to the table below as a quick guide to rounding: In your Google Drive change the folder ICT to [ICT11_YOURNAME] and share the folder with me by searching for my email address. Inside the folder create a subfolder titled "Spreadsheets". Use the Save & Send function under the File tab to create a PDF of the sheet, showing the formulas and not the values. Save it as [YOURNAME_xls3]. Upload the printed file to your spreadsheets folder in your Google Drive. Due Date: Friday, 14 October 23h00
In your school email account you will have received an invite to KhanAcademy.org. Accept this invite and create an account using your school email if you do not already have an account. You will be doing a 'course' called One Hour Internet. This course will run you through a solid basic understanding of how the internet works. Take time over the next 2 weeks to work through the content. COMPLETE COURSE By: 15 October, 22h00
Now, on this sheet calculate:
You can use the Excel formula tutorials to help you which can be accessed by clicking here, or you can use the help outlined for you in the online textbook, digital pages 205 onward. Once completed, save the file as xls_Task_[YOURNAME] upload to your Google Drive and share your file with me. Due: Saturday, 8 October 18h00Understanding how a computer thinks is very important. They work step by step in order complete tasks. Here is an example of how the microprocessor of a washing machine works: Below are two videos explaining the working or the CPU
|
LINKSPractical Archives
May 2017
Categories
All
|
ContactTelephone:
+974 4450 2172 School Mobile +974 5536 9675 |
|